protected void radGridReview_OnNeedDataSource(object sender, GridNeedDataSourceEventArgs e)
        {
            if (TabId != 229)
            {
                radGridReview.DataSource = SQLData.B_BEXPORT_DOCUMETARYCOLLECTION_GetbyStatus(ScreenType.ToString("G"), UserId.ToString());
            }
            else
            {

                DataSet datasource = new DataSet();//Tab1
                DataTable tbl1 = new DataTable();
                tbl1.Columns.Add("DocCollectCode");
                tbl1.Columns.Add("CollectionType");
                tbl1.Columns.Add("Currency");
                tbl1.Columns.Add("Amount");
                tbl1.Columns.Add("Status");
                var lst = _entities.BEXPORT_DOCUMETARYCOLLECTION.Where(x => x.Amend_Status == "UNA" && (x.ActiveRecordFlag == null ||x.ActiveRecordFlag == YesNo.YES)).ToList();
                foreach (var item in lst)
                {
                    if (!String.IsNullOrEmpty(item.AmendNo))
                    {
                        tbl1.Rows.Add(item.AmendNo, item.CollectionType,item.Currency,item.Amount,item.Amend_Status);
                    }
                }
                datasource.Tables.Add(tbl1);
                radGridReview.DataSource = datasource;
            }
        }

 protected void grdRegisteredEvents_OnNeedDataSource(object sender, GridNeedDataSourceEventArgs e)
 {
     if (!e.IsFromDetailTable)
     {
         grdRegisteredEvents.DataSource = ConferenceEventsViewManager.LoadByUserId(UserId).ToList();
     }
 }

        protected void radGridReview_OnNeedDataSource(object sender, GridNeedDataSourceEventArgs e)
        {
            DataTable dt = new DataTable();
            dt.Columns.Add("ReperenceNo");
            dt.Columns.Add("CustomerAccount");
            dt.Columns.Add("AmtLCY");
            dt.Columns.Add("AmtFCY");
            dt.Columns.Add("Status");
            dt.Columns.Add("LCCode");

            DataRow dr = dt.NewRow();
            dr["ReperenceNo"] = "TT/09161/078911";
            dr["CustomerAccount"] = "BANK OF SHANGHAI";
            dr["AmtLCY"] = "2,000,0000";
            dr["AmtFCY"] = "100.00";
            dr["Status"] = "UNA";
            dr["LCCode"] = "1";
            dt.Rows.Add(dr);

            DataRow dr1 = dt.NewRow();
            dr1["ReperenceNo"] = "TT/09161/078912";
            dr1["CustomerAccount"] = "CITI BANK NEWYORK";
            dr1["AmtLCY"] = "4,000,0000";
            dr1["AmtFCY"] = "200.00";
            dr1["Status"] = "UNA";
            dr1["LCCode"] = "2";
            dt.Rows.Add(dr1);

            radGridReview.DataSource = dt;
        }

 protected void grdLocation_NeedDataSource(object sender, GridNeedDataSourceEventArgs e)
 {
     if (!e.IsFromDetailTable)
     {
         grdLocation.DataSource = LocationManager.LoadAll().ToList();
     }
 }

 protected void radGridReview_OnNeedDataSource(object sender, GridNeedDataSourceEventArgs e)
 {
     if (String.IsNullOrEmpty(lstType))
         radGridReview.DataSource = bd.Teller.TellerForeignExchangeList(this.TabId, null);
     else
         radGridReview.DataSource = bd.Teller.TellerForeignExchangeList(this.TabId, bd.TransactionStatus.UNA);
 }

 protected void RadGridAllChanges_DetailTableDataBind(object source, GridNeedDataSourceEventArgs e)
 {
     DataClasses1DataContext dbContext = new DataClasses1DataContext();
     try
     {
         RadGrid sender = source as RadGrid;
         Panel item = sender.Parent as Panel;
         Label lblReferenceId = item.FindControl("lblReferenceId") as Label;
         Label lblTableName = item.FindControl("lblTableName") as Label;
         DataTable t = new DataTable();
         if (lblReferenceId.Text != string.Empty || lblTableName.Text != string.Empty)
         {
             var tableColumns = dbContext.ChangeLogColumNames.SingleOrDefault(q => q.TableName == lblTableName.Text);
             string thisSelect = "";
             if (tableColumns != null)
             {
                 string idName = tableColumns.IdColumnName;
                 foreach (var col in tableColumns.ColumnNames.Split(';'))
                 {
                     if (thisSelect == string.Empty)
                     {
                         thisSelect = "[" + col + "]";
                     }
                     else
                     {
                         thisSelect += ",[" + col + "]";
                     }
                 }
                 dbContext.Connection.Close();
                 string myQuery = "";
                 if (thisSelect != string.Empty && idName != string.Empty && lblTableName.Text != string.Empty)
                 {
                     myQuery = "select " + thisSelect + " from [" + lblTableName.Text + "] where " + idName + " ='" + lblReferenceId.Text + "'";
                     using (SqlConnection c = new SqlConnection(dbContext.Connection.ConnectionString))
                     {
                         c.Open();
                         using (SqlDataAdapter a = new SqlDataAdapter(myQuery, c))
                         {
                             a.Fill(t);
                         }
                     }
                     sender.DataSource = t;
                 }
             }
             else
             {
                 setEmptyDataSet(((RadGrid)sender));
             }
         }
         else
         {
             setEmptyDataSet(((RadGrid)sender));
         }
     }
     catch (Exception ex)
     {
         dbContext.WriteLogItem("Fehler beim generieren des ChangeLogs Details. " + ex.Message, LogTypes.ERROR);
         dbContext.SubmitChanges();
     }
 }

 protected void radGridReview_OnNeedDataSource(object sender, GridNeedDataSourceEventArgs e)
 {
     if (string.IsNullOrEmpty(lstType))
         radGridReview.DataSource = BankProject.DataProvider.Teller.CashWithrawalForBuyingTCList(null, txtCustomerId.Text, txtCustomerName.Text);
     else
         radGridReview.DataSource = BankProject.DataProvider.Teller.CashWithrawalForBuyingTCList(bd.TransactionStatus.UNA, txtCustomerId.Text, txtCustomerName.Text);
 }

 protected void radGridReview_OnNeedDataSource(object sender, GridNeedDataSourceEventArgs e)
 {
     if (!IsPostBack)
     {
         if (lstType != null && lstType.ToLower().Equals("4appr"))
         {
             var query = (from EX in entContext.B_ExportLCPayments
                          join BE in entContext.BEXPORT_DOCUMENTPROCESSINGs on EX.LCCode equals BE.PaymentId
                          join AD in entContext.BAdvisingAndNegotiationLCs on BE.LCCode equals AD.NormalLCCode
                          where EX.Status == "UNA"
                          select new { EX, AD });
             var lst = new List<BAdvisingAndNegotiationLC>();
             foreach (var item in query)
             {
                 lst.Add(new BAdvisingAndNegotiationLC
                 {
                     Id=item.EX.Id,
                     NormalLCCode=item.EX.LCCode,
                     Amount=item.AD.Amount,
                     ApplicantNo=item.AD.ApplicantNo,
                     Currency=item.AD.Currency,
                     ApplicantName=item.AD.ApplicantName,
                     Status=item.EX.Status
                 });
             }
             var source = CreateDataset(lst);
             radGridReview.DataSource = source;
         }
     }
 }

 protected void rgIndustries_OnNeedDataSource(object sender, GridNeedDataSourceEventArgs e)
 {
     using (var hrsgEntities = new HRSG_DatabaseEntities())
     {
         rgIndustries.DataSource = hrsgEntities.Industries.Where(a => a.Active).ToList();
     }
 }

 protected void radGridReview_OnNeedDataSource(object sender, GridNeedDataSourceEventArgs e)
 {
     if (tbLCNo.Text != "" || rcbApplicantID.SelectedValue != "")
     {
         radGridReview.DataSource = DataProvider.KhanhND.B_BNORMAILLC_Search(tbLCNo.Text, rcbApplicantID.SelectedValue);
     }
 }

 protected void radGridReview_OnNeedDataSource(object sender, GridNeedDataSourceEventArgs e)
 {
     radGridReview.DataSource = SQLData.B_BDOCUMETARYCOLLECTION_GetByAmendment(txtCode.Text.Trim(),
             comboDraweeCusNo.SelectedValue, txtDraweeAddr.Text.Trim(),
             comboDrawerCusNo.Text, txtDrawerAddr.Text.Trim(),
             "UNA", UserId.ToString());
 }

 protected void grdStatistics_NeedDataSource(object sender, GridNeedDataSourceEventArgs e)
 {
     if (!e.IsFromDetailTable)
     {
         grdStatistics.DataSource = PaperStatisticsViewManager.LoadAll();
     }
 }

 protected void grid_NeedDataSource(object sender, GridNeedDataSourceEventArgs e)
 {
     var value = "ObjectId".Query();
     if (value.None())
     {
         Response.Redirect("~/Depot/Home");
         return;
     }
     var objId = value.GlobalId();
     var obj = DataContext.DepotObject.Single(o => o.Id == objId);
     if (obj.Fixed)
     {
         var source = DataContext.DepotInX.Where(o => (o.AvailableAmount > 0) && o.ObjectId == obj.Id).ToList().Select(o => new Placed { Id = o.Id, Ordinal = o.Ordinal, Fixed = true, Place = o.Place, Code = o.Code }).OrderBy(o => o.Ordinal).ToList();
         grid.DataSource = source;
     }
     else
     {
         var source = DataContext.DepotInX.Where(o => (o.AvailableAmount > 0) && o.ObjectId == obj.Id).OrderByDescending(o => o.AvailableAmount).ToList().Select(o => new Placed { Id = o.Id, Ordinal = 0, Fixed = false, Place = o.Place, Code = o.Code }).ToList();
         for (var i = 0; i < source.Count; i++)
         {
             source[i].Ordinal = i + 1;
         }
         grid.DataSource = source;
     }
 }

        //CouponTitle_NeedDataSource where we can bind the based ont he values of today fromdate and member name
        protected void CouponTitle_NeedDataSource(object sender, GridNeedDataSourceEventArgs e)
        {
            if (FromDateTimePicker.SelectedDate == null && ToDateTimePicker.SelectedDate == null && FirstnameIDtxtbox.Text != string.Empty)
            {
                DataTable dt = new DataTable();
                objr.Membername = FirstnameIDtxtbox.Text.ToString();
                dt = objr.GetreportDetailsusingmembername();
                gvmember.DataSource = dt; ;
            }
            else if (FromDateTimePicker.SelectedDate != null && ToDateTimePicker.SelectedDate != null && FirstnameIDtxtbox.Text == string.Empty)
            {
                DataTable dt = new DataTable();

                objr.FDate = FromDateTimePicker.SelectedDate.Value;
                objr.Todate = ToDateTimePicker.SelectedDate.Value;
                objr.Membername = FirstnameIDtxtbox.Text.ToString();
                dt = objr.GetDonationDetailsusingDate();
                gvmember.DataSource = dt;
            }
            else
            {
                DataTable dt = new DataTable();

                objr.FDate = FromDateTimePicker.SelectedDate.Value;
                objr.Todate = ToDateTimePicker.SelectedDate.Value;
                objr.Membername = FirstnameIDtxtbox.Text.ToString();
                objr.Membername = FirstnameIDtxtbox.Text.ToString();
                dt = objr.GetreportDetailsusingmembernamewithdate();
                gvmember.DataSource = dt;

            }
        }

 protected void grdInventory_NeedDataSource(object sender, GridNeedDataSourceEventArgs e)
 {
     if (!e.IsFromDetailTable)
     {
         grdInventory.DataSource = CarInventoryViewManager.LoadAllActive().ToList();
     }
 }

        protected void grdSavingAccInterestList_OnNeedDataSource(object sender, GridNeedDataSourceEventArgs e)
        {
            var data = SavingAccountDAO.GetInteresAccountById(RefIdToReview);
            var total = data.AsEnumerable().Sum(r => r.Field<decimal?>("InterestAmt") ?? 0);
            VWlblTotalInAmt.Text = String.Format(CultureInfo.InvariantCulture,
                                 "{0:N}", total);
            VWlblPrincipal.Text = String.Format(CultureInfo.InvariantCulture,
                              "{0:N}", Convert.ToDecimal(VWlblOrgPrincipal.Text) + total);

            if (CurrencyCode == "VND")
            {
                WDnumAcmountLcy.Value =(double?)(total + PrincipalValue);
                WDlblNewCustBal.Text = string.Format("- {0}",(total + PrincipalValue).ToString()) ;
                WDlblAmtPaidToCust.Text = (total + PrincipalValue).ToString();
                WDnumAcmountFcy.Value = null;
            }
            else
            {
                WDnumAcmountLcy.Value = null;
                WDnumAcmountFcy.Value = (double?)(total + PrincipalValue);
                WDlblNewCustBal.Text = string.Format("- {0}",(total + PrincipalValue).ToString()) ;
                WDlblAmtPaidToCust.Text = (total + PrincipalValue).ToString();
            }
            grdSavingAccInterestList.DataSource = data;
        }

        protected void RadGrid1_NeedDataSource(object sender, GridNeedDataSourceEventArgs e)
        {
            var db = new UrbanDataContext();
            var manager = new UrbanDataManager(db);

            RadGrid1.DataSource = (from u in db.User
                                   select u).ToList();
        }

        //gvdonation_NeedDataSource event is apply getdonationdetails to gvmember grid
        protected void gvdonation_NeedDataSource(object sender, GridNeedDataSourceEventArgs e)
        {
            DataTable dt = new DataTable();

                dt = objd.getdonationdetails();

            gvdonation.DataSource = dt;
        }

 protected void radGridReview_OnNeedDataSource(object sender, GridNeedDataSourceEventArgs e)
 {
     if (IsPostBack)
     {
         radGridReview.DataSource = Database.BOPENACCOUNT_EnquiryTransaction(rcbAccountType.SelectedValue, rcbTransactionType.SelectedValue, txtRefID.Text, rcbCurrency.SelectedValue, rcbCustomerType.SelectedValue, tbCustomerID.Text,
                                                                                          tbGBFullName.Text, tbCustomerAccount.Text, txtFrom.Value, txtTo.Value, txtDate.SelectedDate);
     }
 }

 protected void PopulateGroupDetail(object sender, GridNeedDataSourceEventArgs e)
 {
     if (_groupViewModel == null)
         throw new Exception(string.Format("The RoleId:'{0}' does not exist or the currently logged on user is not allowed to see it", RoleId));
     
     grdDetail.DataSource = new List<GroupViewModel> { _groupViewModel };
     
 }