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();
}
