private void InsertData() { List <CarBO> OCar = new List <CarBO>(); if (grdViewCar.RowCount > 0) { for (int i = 0; i < grdViewCar.RowCount; i++) { OCar.Add(new CarBO() { CostCentreId = m_iCCId, BlockId = Convert.ToInt32(grdViewCar.GetRowCellValue(i, "BlockId")), TypeId = m_iTypeId, NoOfSlots = Convert.ToInt32(CommFun.IsNullCheck(grdViewCar.GetRowCellValue(i, "NoOfSlots"), CommFun.datatypes.vartypenumeric)), AllotSlots = Convert.ToInt32(CommFun.IsNullCheck(grdViewCar.GetRowCellValue(i, "AllottedSlots"), CommFun.datatypes.vartypenumeric)) } ); } if (OCar.Count > 0) { dtCar = new DataTable(); dtCar = CommFun.GenericListToDataTable(OCar); } } CarBO.Slots1 = labelControl1.Text; CarBO.Slots2 = labelControl2.Text; CarBO.Cost1 = Convert.ToDecimal(textEdit1.EditValue); CarBO.Cost2 = Convert.ToDecimal(textEdit2.EditValue); CarBO.TId = m_iTypeId; UnitDirBL.InsertCar(dtCar, m_iCCId); }
private void btnOK_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { DataTable dt = new DataTable(); if (m_sType == "FlatType") { OtherAreaBO.Add(new OtherArea() { OtherCostId = m_iOCId, FlatTypeId = m_iFlatTypeId, FlatId = 0, Area = Convert.ToDecimal(CommFun.IsNullCheck(txtArea.EditValue, CommFun.datatypes.vartypenumeric)), Rate = Convert.ToDecimal(CommFun.IsNullCheck(txtRate.EditValue, CommFun.datatypes.vartypenumeric)), Unit = Convert.ToInt32(CommFun.IsNullCheck(cboUnit.EditValue, CommFun.datatypes.vartypenumeric)), Amount = Convert.ToDecimal(CommFun.IsNullCheck(txtAmt.EditValue, CommFun.datatypes.vartypenumeric)) }); } else if (m_sType == "Flat" || m_sType == "GlobalRate") { OtherAreaBO.Add(new OtherArea() { OtherCostId = m_iOCId, FlatTypeId = 0, FlatId = m_iFlatId, Area = Convert.ToDecimal(CommFun.IsNullCheck(txtArea.EditValue, CommFun.datatypes.vartypenumeric)), Rate = Convert.ToDecimal(CommFun.IsNullCheck(txtRate.EditValue, CommFun.datatypes.vartypenumeric)), Unit = Convert.ToInt32(CommFun.IsNullCheck(cboUnit.EditValue, CommFun.datatypes.vartypenumeric)), Amount = Convert.ToDecimal(CommFun.IsNullCheck(txtAmt.EditValue, CommFun.datatypes.vartypenumeric)), }); } dt = CommFun.GenericListToDataTable(OtherAreaBO); BindColumn(); if (dt != null) { if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { if (dtRetn.Rows.Count > 0) { DataView dv = new DataView(dtRetn); dv.RowFilter = "OtherCostId=" + dt.Rows[0]["OtherCostId"] + ""; if (dv.ToTable().Rows.Count > 0) { for (int j = 0; j < dtRetn.Rows.Count; j++) { if (Convert.ToInt32(dtRetn.Rows[j]["OtherCostId"]) == Convert.ToInt32(dv.ToTable().Rows[0]["OtherCostId"])) { dtRetn.Rows[j]["FlatTypeId"] = dt.Rows[i]["FlatTypeId"]; dtRetn.Rows[j]["FlatId"] = dt.Rows[i]["FlatId"]; dtRetn.Rows[j]["OtherCostId"] = dt.Rows[i]["OtherCostId"]; dtRetn.Rows[j]["Area"] = dt.Rows[i]["Area"]; dtRetn.Rows[j]["Rate"] = dt.Rows[i]["Rate"]; dtRetn.Rows[j]["Unit"] = dt.Rows[i]["Unit"]; dtRetn.Rows[j]["Amount"] = dt.Rows[i]["Amount"]; } } } else { DataRow dr = dtRetn.NewRow(); dt.AcceptChanges(); if (m_sType == "FlatType") { dr["FlatTypeId"] = dt.Rows[i]["FlatTypeId"].ToString(); dr["FlatId"] = 0; } else { dr["FlatTypeId"] = 0; dr["FlatId"] = dt.Rows[i]["FlatId"].ToString(); } dr["OtherCostId"] = dt.Rows[i]["OtherCostId"].ToString(); dr["Area"] = dt.Rows[i]["Area"].ToString(); dr["Unit"] = dt.Rows[i]["Unit"].ToString(); dr["Rate"] = dt.Rows[i]["Rate"].ToString(); dr["Amount"] = dt.Rows[i]["Amount"].ToString(); dtRetn.Rows.Add(dr); } } else { DataRow dr = dtRetn.NewRow(); dt.AcceptChanges(); if (m_sType == "FlatType") { dr["FlatTypeId"] = dt.Rows[i]["FlatTypeId"].ToString(); dr["FlatId"] = 0; } else { dr["FlatTypeId"] = 0; dr["FlatId"] = dt.Rows[i]["FlatId"].ToString(); } dr["OtherCostId"] = dt.Rows[i]["OtherCostId"].ToString(); dr["Area"] = dt.Rows[i]["Area"].ToString(); dr["Unit"] = dt.Rows[i]["Unit"].ToString(); dr["Rate"] = dt.Rows[i]["Rate"].ToString(); dr["Amount"] = dt.Rows[i]["Amount"].ToString(); dtRetn.Rows.Add(dr); } } } } m_dAmount = Convert.ToDecimal(CommFun.IsNullCheck(txtAmt.EditValue, CommFun.datatypes.vartypenumeric)); Close(); }
private void btnOK_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { grdViewCar.FocusedRowHandle = grdViewCar.FocusedRowHandle + 1; DataTable dt = new DataTable(); if (m_sType == "FlatType") { List <FlatTypeCarBO> FTCP = new List <FlatTypeCarBO>(); if (grdViewCar.RowCount > 0) { for (int i = 0; i < grdViewCar.RowCount; i++) { FTCP.Add(new FlatTypeCarBO() { CCId = m_iCCId, FlatTypeId = m_iFlatTypeId, TypeId = Convert.ToInt32(CommFun.IsNullCheck(grdViewCar.GetRowCellValue(i, "TypeId"), CommFun.datatypes.vartypenumeric)), TotalCP = Convert.ToInt32(CommFun.IsNullCheck(grdViewCar.GetRowCellValue(i, "TotalCP"), CommFun.datatypes.vartypenumeric)) }); } } if (FTCP.Count > 0) { dt = CommFun.GenericListToDataTable(FTCP); } UnitDirBL.InsertFlatTypeCar(dt); iTotCP = Convert.ToInt32(CommFun.IsNullCheck(grdViewCar.Columns["TotalCP"].SummaryText, CommFun.datatypes.vartypenumeric)); } else if (m_sType == "Flat") { List <FlatCarParkBO> FCP = new List <FlatCarParkBO>(); if (grdViewCar.RowCount > 0) { for (int i = 0; i < grdViewCar.RowCount; i++) { FCP.Add(new FlatCarParkBO() { CCId = m_iCCId, FlatId = m_iFlatId, TypeId = Convert.ToInt32(CommFun.IsNullCheck(grdViewCar.GetRowCellValue(i, "TypeId"), CommFun.datatypes.vartypenumeric)), TotalCP = Convert.ToInt32(CommFun.IsNullCheck(grdViewCar.GetRowCellValue(i, "TotalCP"), CommFun.datatypes.vartypenumeric)) }); } } if (FCP.Count > 0) { dt = CommFun.GenericListToDataTable(FCP); } //UnitDirBL.InsertFlatCar(dt); //BL.ProjectInfoBL.UpdateCarParkSlotAllot(iBlockId, m_iCCId); DataTable dt1 = new DataTable(); //dt1 = UnitDirBL.GetCarAllot(m_iBlockId, m_iCCId, m_iFlatId); dt1 = grdCar.DataSource as DataTable; if (dt1 != null) { for (int i = 0; i < dt1.Rows.Count; i++) { int i_NoOfSlots = Convert.ToInt32(CommFun.IsNullCheck(dt1.Rows[i]["NoOfSlots"], CommFun.datatypes.vartypenumeric)); int i_AllotedSlots = Convert.ToInt32(CommFun.IsNullCheck(dt1.Rows[i]["AllottedSlots"], CommFun.datatypes.vartypenumeric)); int i_TotalCarPark = Convert.ToInt32(CommFun.IsNullCheck(dt1.Rows[i]["TotalCP"], CommFun.datatypes.vartypenumeric)); int iASlots = i_NoOfSlots - i_AllotedSlots; if (iASlots < 0) { iASlots = 0; } if (i_TotalCarPark > iASlots) { MessageBox.Show(dt1.Rows[i]["TypeName"] + " is not Available"); grdViewCar.SetRowCellValue(i, "TotalCP", iASlots); return; } } } UnitDirBL.InsertFlatCar(dt); BL.ProjectInfoBL.UpdateCarParkSlotAllot(m_iBlockId, m_iCCId); iTotCP = Convert.ToInt32(CommFun.IsNullCheck(grdViewCar.Columns["TotalCP"].SummaryText, CommFun.datatypes.vartypenumeric)); } m_bOK = true; Close(); }
private void btnOk_ItemClick_1(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { string[] splitF = new string[] { }; string GetSplitted = ""; //m_sFilter = "Select LeadId, LeadName,0 CostCentreId from LeadRegister Where 1=1 "; m_sFilter = " Select Distinct R.LeadId, R.LeadName,R.LeadDate,A.CostCentreId,R.Mobile,R.Email,IsNull(O.CostCentreName,'')CostCentre," + " IsNull(U.EmployeeName,'') ExecutiveName,R.CallTypeId From dbo.LeadRegister R Left Join dbo.LeadProjectInfo A On A.LeadId=R.LeadId " + " Inner Join dbo.LeadExecutiveInfo E On A.LeadId=E.LeadId Left Join [" + BsfGlobal.g_sWorkFlowDBName + "].dbo.OperationalCostCentre O On O.CostCentreId=A.CostCentreId " + " Left Join [" + BsfGlobal.g_sWorkFlowDBName + "].dbo.Users U On U.UserId=A.ExecutiveId " + " Where R.LeadDate Between '" + m_deFrom.ToString("dd-MMM-yyyy") + "' And '" + m_deTo.ToString("dd-MMM-yyyy") + "' "; if (chkProj.Checked == true) { if (CommFun.IsNullCheck(RGProj.EditValue, CommFun.datatypes.vartypestring).ToString() != "") { //m_sFilter = m_sFilter + " AND LeadId in( Select LeadId from LeadExecutiveInfo where CostCentreId in( " + // RGProj.EditValue.ToString() + ")) "; m_sFilter = m_sFilter + " AND R.LeadId in( Select LeadId From LeadProjectInfo Where CostCentreId in( " + RGProj.EditValue.ToString() + "))"; } } if (chkProfession.Checked == true) { if (CommFun.IsNullCheck(RGProfession.EditValue, CommFun.datatypes.vartypestring).ToString() != "") { splitF = RGProfession.Text.Split(','); for (int i = 0; i <= splitF.Length - 1; i++) { GetSplitted += "'" + splitF[i].ToString().Trim() + "' , "; } GetSplitted = GetSplitted.Substring(0, GetSplitted.Length - 1); if (GetSplitted != string.Empty) { GetSplitted = GetSplitted.TrimEnd(','); } m_sFilter = m_sFilter + " AND R.LeadId in( Select LeadId from LeadPersonalInfo where Profession in( " + GetSplitted.ToString() + "))" + " OR LeadId in( Select LeadId from LeadCoApplicantInfo where Profession in( " + GetSplitted.ToString() + ")) "; } } if (chkBuyer.Checked == true) { if (CommFun.IsNullCheck(RGBuyer.EditValue, CommFun.datatypes.vartypestring).ToString() != "") { if (Convert.ToInt32(RGBuyer.EditValue) == 0) { m_sFilter = m_sFilter + " AND R.LeadId in( Select LeadId From dbo.LeadRegister A " + "Where LeadId Not in (Select LeadId from dbo.BuyerDetail)) "; } //m_sFilter = m_sFilter + " AND LeadId in( Select LeadId from LeadFlatInfo where Buyer in( " + // RGBuyer.EditValue.ToString() + ")) "; } } if (chkExe.Checked == true) { if (CommFun.IsNullCheck(RGExe.EditValue, CommFun.datatypes.vartypestring).ToString() != "") { m_sFilter = m_sFilter + " AND R.LeadId in( Select LeadId from LeadExecutiveInfo where ExecutiveId in( " + RGExe.EditValue.ToString() + ")) "; } } if (chkReligion.Checked == true) { if (CommFun.IsNullCheck(RGReligion.EditValue, CommFun.datatypes.vartypestring).ToString() != "") { m_sFilter = m_sFilter + " AND R.LeadId in( Select LeadId from LeadPersonalInfo where Religion in( " + RGReligion.EditValue.ToString() + "))" + " OR LeadId in( Select LeadId from LeadCoApplicantInfo where Religion in( " + RGReligion.EditValue.ToString() + ")) "; } } if (chkStay.Checked == true) { if (CommFun.IsNullCheck(RGStay.EditValue, CommFun.datatypes.vartypestring).ToString() != "") { m_sFilter = m_sFilter + " AND R.LeadId in( Select LeadId from LeadFinance where Stay in( " + RGStay.EditValue.ToString() + ")) "; } } if (chkSubSou.Checked == true) { if (CommFun.IsNullCheck(RGSubSou.EditValue, CommFun.datatypes.vartypestring).ToString() != "") { m_sFilter = m_sFilter + " AND R.LeadId in( Select LeadId from LeadProjectInfo where CampaignId in( " + RGSubSou.EditValue.ToString() + ")) "; } } if (chkYearlyInc.Checked == true) { if (CommFun.IsNullCheck(RGYearlyIncome.EditValue, CommFun.datatypes.vartypestring).ToString() != "") { m_sFilter = m_sFilter + " AND R.LeadId in( Select LeadId from LeadFinance where Income in( " + RGYearlyIncome.EditValue.ToString() + ")) "; } } if (chkEmp.Checked == true) { if (CommFun.IsNullCheck(RGEmpStatus.EditValue, CommFun.datatypes.vartypestring).ToString() != "") { m_sFilter = m_sFilter + " AND R.LeadId in( Select LeadId from LeadFinance where Employment in( " + RGEmpStatus.EditValue.ToString() + ")) "; } } if (chkNat.Checked == true) { if (CommFun.IsNullCheck(RGNationality.EditValue, CommFun.datatypes.vartypestring).ToString() != "") { splitF = null; GetSplitted = null; splitF = RGNationality.Text.Split(','); for (int i = 0; i <= splitF.Length - 1; i++) { GetSplitted += "'" + splitF[i].ToString().Trim() + "' , "; } GetSplitted = GetSplitted.Substring(0, GetSplitted.Length - 1); if (GetSplitted != string.Empty) { GetSplitted = GetSplitted.TrimEnd(','); } m_sFilter = m_sFilter + " AND R.LeadId in( Select LeadId from LeadPersonalInfo where Nationality in( " + GetSplitted.ToString() + "))" + " OR LeadId in( Select LeadId from LeadCoApplicantInfo where Nationality in( " + GetSplitted.ToString() + ")) "; } } if (chkCountry.Checked == true) { if (CommFun.IsNullCheck(RGCountry.EditValue, CommFun.datatypes.vartypestring).ToString() != "") { m_sFilter = m_sFilter + " AND R.LeadId in(Select LeadId from LeadCommAddressInfo where Country in(" + RGCountry.EditValue.ToString() + "))" + " OR R.LeadId in(Select LeadId from LeadCoAppAddressInfo where CoCountry in( " + RGCountry.EditValue.ToString() + "))" + " OR R.LeadId in(Select LeadId from LeadNRIAddressInfo where Country in( " + RGCountry.EditValue.ToString() + "))" + " OR R.LeadId in(Select LeadId from LeadOffAddressInfo where Country in( " + RGCountry.EditValue.ToString() + "))" + " OR R.LeadId in(Select LeadId from LeadPermanentAddressInfo where Country in( " + RGCountry.EditValue.ToString() + ")) "; } } if (chkState.Checked == true) { if (CommFun.IsNullCheck(RGState.EditValue, CommFun.datatypes.vartypestring).ToString() != "") { splitF = null; splitF = RGState.EditValue.ToString().Split(','); GetSplitted = null; for (int i = 0; i <= splitF.Length - 1; i++) { GetSplitted += "'" + splitF[i].ToString().Trim() + "' , "; } GetSplitted = GetSplitted.Substring(0, GetSplitted.Length - 1); if (GetSplitted != string.Empty) { GetSplitted = GetSplitted.TrimEnd(','); } m_sFilter = m_sFilter + " AND R.LeadId in(Select LeadId from LeadCommAddressInfo where StateId in( " + GetSplitted.ToString() + "))" + " OR R.LeadId in(Select LeadId from LeadCoAppAddressInfo where StateId in( " + GetSplitted.ToString() + "))" + " OR R.LeadId in(Select LeadId from LeadNRIAddressInfo where StateId in( " + GetSplitted.ToString() + "))" + " OR R.LeadId in(Select LeadId from LeadOffAddressInfo where StateId in( " + GetSplitted.ToString() + "))" + " OR R.LeadId in(Select LeadId from LeadPermanentAddressInfo where StateId in( " + GetSplitted.ToString() + ")) "; } } if (chkCity.Checked == true) { if (CommFun.IsNullCheck(RGCity.EditValue, CommFun.datatypes.vartypestring).ToString() != "") { splitF = null; splitF = RGCity.EditValue.ToString().Split(','); GetSplitted = null; for (int i = 0; i <= splitF.Length - 1; i++) { GetSplitted += "'" + splitF[i].ToString().Trim() + "' , "; } GetSplitted = GetSplitted.Substring(0, GetSplitted.Length - 1); if (GetSplitted != string.Empty) { GetSplitted = GetSplitted.TrimEnd(','); } m_sFilter = m_sFilter + " AND R.LeadId in(Select LeadId from LeadCommAddressInfo where CityId in( " + GetSplitted.ToString() + "))" + " OR R.LeadId in(Select LeadId from LeadCoAppAddressInfo where CityId in( " + GetSplitted.ToString() + "))" + " OR R.LeadId in(Select LeadId from LeadNRIAddressInfo where CityId in( " + GetSplitted.ToString() + "))" + " OR R.LeadId in(Select LeadId from LeadOffAddressInfo where CityId in( " + GetSplitted.ToString() + "))" + " OR R.LeadId in(Select LeadId from LeadPermanentAddressInfo where CityId in( " + GetSplitted.ToString() + ")) "; } } if (chkApt.Checked == true) { if (CommFun.IsNullCheck(RGApt.EditValue, CommFun.datatypes.vartypestring).ToString() != "") { m_sFilter = m_sFilter + " AND R.LeadId in( Select LeadId from LeadApartmentInfo where ApartmentId in( " + RGApt.EditValue.ToString() + ")) "; } } if (chkAptSize.Checked == true) { if (CommFun.IsNullCheck(RGAptSize.EditValue, CommFun.datatypes.vartypestring).ToString() != "") { m_sFilter = m_sFilter + " AND R.LeadId in( Select LeadId from LeadApartmentInfo where Size in( " + RGAptSize.EditValue.ToString() + ")) "; } } if (chkAptType.Checked == true) { if (CommFun.IsNullCheck(RGAptType.EditValue, CommFun.datatypes.vartypestring).ToString() != "") { m_sFilter = m_sFilter + " AND R.LeadId in( Select LeadId from LeadApartmentInfo where TypeId in( " + RGAptType.EditValue.ToString() + ")) "; } } if (chkArea.Checked == true) { if (CommFun.IsNullCheck(RGArea.EditValue, CommFun.datatypes.vartypestring).ToString() != "") { m_sFilter = m_sFilter + " AND R.LeadId in( Select LeadId from Area Where Sel=1 And AreaId in( " + RGArea.EditValue.ToString() + ")) "; } } if (chkCostPre.Checked == true) { if (CommFun.IsNullCheck(RGCostPre.EditValue, CommFun.datatypes.vartypestring).ToString() != "") { m_sFilter = m_sFilter + " AND R.LeadId in( Select LeadId from LeadApartmentInfo where CostId in( " + RGCostPre.EditValue.ToString() + ")) "; } } if (chkFac.Checked == true) { if (CommFun.IsNullCheck(RGFac.EditValue, CommFun.datatypes.vartypestring).ToString() != "") { m_sFilter = m_sFilter + " AND R.LeadId in( Select LeadId from Facility where FacilityId in( " + RGFac.EditValue.ToString() + ")) "; } } if (chkPoss.Checked == true) { if (CommFun.IsNullCheck(RGPoss.EditValue, CommFun.datatypes.vartypestring).ToString() != "") { m_sFilter = m_sFilter + " AND R.LeadId in( Select LeadId from Possess where PossessId in( " + RGPoss.EditValue.ToString() + ")) "; } } if (chkFin.Checked == true) { if (CommFun.IsNullCheck(RGFinance.EditValue, CommFun.datatypes.vartypestring).ToString() != "") { splitF = null; GetSplitted = null; splitF = RGFinance.Text.Split(','); for (int i = 0; i <= splitF.Length - 1; i++) { GetSplitted += "'" + splitF[i].ToString().Trim() + "' , "; } GetSplitted = GetSplitted.Substring(0, GetSplitted.Length - 1); if (GetSplitted != string.Empty) { GetSplitted = GetSplitted.TrimEnd(','); } m_sFilter = m_sFilter + " AND R.LeadId in( Select LeadId from LeadBankDetails where Need in( " + GetSplitted.ToString() + ")) "; } } if (chkGuestHou.Checked == true) { if (CommFun.IsNullCheck(RGGuestHou.EditValue, CommFun.datatypes.vartypestring).ToString() != "") { m_sFilter = m_sFilter + " AND R.LeadId in( Select LeadId from LeadFinance where GuestHouse in( " + RGGuestHou.EditValue.ToString() + ")) "; } } if (chkMaritalS.Checked == true) { if (CommFun.IsNullCheck(RGMaritalSta.EditValue, CommFun.datatypes.vartypestring).ToString() != "") { m_sFilter = m_sFilter + " AND R.LeadId in( Select LeadId from LeadPersonalInfo where MarritalStatus in( " + RGMaritalSta.EditValue.ToString() + ")) "; } } if (chkAge.Checked == true) { if (CommFun.IsNullCheck(txtFrom.EditValue, CommFun.datatypes.vartypestring).ToString() != "" && CommFun.IsNullCheck(txtTo.EditValue, CommFun.datatypes.vartypestring).ToString() != "") { m_sFilter = m_sFilter + " AND R.LeadId in( Select LeadId from LeadPersonalInfo where DATEDIFF(YEAR,DOB,GETDATE()) " + " Between " + txtFrom.EditValue + " And " + txtTo.EditValue + " )"; } } if (chkNRI.Checked == true) { m_sFilter = m_sFilter + " AND R.LeadId in( Select LeadId from LeadPersonalInfo Where NRI In(0))"; } if (chkVIP.Checked == true) { m_sFilter = m_sFilter + " AND R.LeadId in( Select LeadId from LeadRegister Where VIP In(1))"; } if (chkLocality.Checked == true) { splitF = null; GetSplitted = null; splitF = RGLocality.Text.Split(','); for (int i = 0; i <= splitF.Length - 1; i++) { GetSplitted += "'" + splitF[i].ToString().Trim() + "',"; } GetSplitted = GetSplitted.Substring(0, GetSplitted.Length - 1); if (GetSplitted != string.Empty) { GetSplitted = GetSplitted.TrimEnd(','); } m_sFilter = m_sFilter + " AND R.LeadId in(Select LeadId From LeadCommAddressInfo Where Locality In(" + GetSplitted + "))"; } m_sFilter = m_sFilter + "Order By LeadName"; m_filterBO.i_AptId = CommFun.IsNullCheck(RGApt.EditValue, CommFun.datatypes.vartypestring).ToString(); m_filterBO.i_AptSizeId = CommFun.IsNullCheck(RGAptSize.EditValue, CommFun.datatypes.vartypestring).ToString(); m_filterBO.i_AptTypeId = CommFun.IsNullCheck(RGAptType.EditValue, CommFun.datatypes.vartypestring).ToString(); m_filterBO.i_AreaId = CommFun.IsNullCheck(RGArea.EditValue, CommFun.datatypes.vartypestring).ToString(); m_filterBO.i_BuyerId = CommFun.IsNullCheck(RGBuyer.EditValue, CommFun.datatypes.vartypestring).ToString(); m_filterBO.s_City = CommFun.IsNullCheck(RGCity.EditValue.ToString(), CommFun.datatypes.vartypestring).ToString(); m_filterBO.i_CostPrefId = CommFun.IsNullCheck(RGCostPre.EditValue, CommFun.datatypes.vartypestring).ToString(); m_filterBO.i_CountryId = CommFun.IsNullCheck(RGCountry.EditValue, CommFun.datatypes.vartypestring).ToString(); m_filterBO.i_EmpId = CommFun.IsNullCheck(RGEmpStatus.EditValue, CommFun.datatypes.vartypestring).ToString(); m_filterBO.i_ExeId = CommFun.IsNullCheck(RGExe.EditValue, CommFun.datatypes.vartypestring).ToString(); m_filterBO.i_FacId = CommFun.IsNullCheck(RGFac.EditValue, CommFun.datatypes.vartypestring).ToString(); m_filterBO.i_GuestHouId = CommFun.IsNullCheck(RGGuestHou.EditValue, CommFun.datatypes.vartypestring).ToString(); m_filterBO.s_Nat = CommFun.IsNullCheck(RGNationality.Text, CommFun.datatypes.vartypestring).ToString(); m_filterBO.i_PossId = CommFun.IsNullCheck(RGPoss.EditValue, CommFun.datatypes.vartypestring).ToString(); m_filterBO.s_Prof = CommFun.IsNullCheck(RGProfession.Text, CommFun.datatypes.vartypestring).ToString(); m_filterBO.i_ProjId = CommFun.IsNullCheck(RGProj.EditValue, CommFun.datatypes.vartypestring).ToString(); m_filterBO.i_ReligionId = CommFun.IsNullCheck(RGReligion.EditValue, CommFun.datatypes.vartypestring).ToString(); m_filterBO.s_State = CommFun.IsNullCheck(RGState.EditValue.ToString(), CommFun.datatypes.vartypestring).ToString(); m_filterBO.i_StayId = CommFun.IsNullCheck(RGStay.EditValue, CommFun.datatypes.vartypestring).ToString(); m_filterBO.i_SubSourId = CommFun.IsNullCheck(RGSubSou.EditValue, CommFun.datatypes.vartypestring).ToString(); m_filterBO.i_IncomeId = CommFun.IsNullCheck(RGYearlyIncome.EditValue, CommFun.datatypes.vartypestring).ToString(); m_filterBO.i_FinId = CommFun.IsNullCheck(RGFinance.EditValue, CommFun.datatypes.vartypestring).ToString(); m_filterBO.i_MaritalId = CommFun.IsNullCheck(RGMaritalSta.EditValue, CommFun.datatypes.vartypestring).ToString(); m_filterBO.s_Locality = CommFun.IsNullCheck(RGLocality.EditValue, CommFun.datatypes.vartypestring).ToString(); oFilterBO.Add(m_filterBO); m_dtFilter = CommFun.GenericListToDataTable(oFilterBO); Close(); }