public void Getdatalist()
{
try
{
DataTable dtNcom = new DataTable();
dtNcom = TenantDetBL.PopulateCostcentre(BsfGlobal.g_lUserId);
lookUpPro.Properties.DataSource = CommFun.AddSelectToDataTable(dtNcom);
lookUpPro.Properties.PopulateColumns();
lookUpPro.Properties.DisplayMember = "CostCentreName";
lookUpPro.Properties.ValueMember = "CostCentreId";
lookUpPro.Properties.Columns["CostCentreId"].Visible = false;
lookUpPro.Properties.ShowHeader = false;
lookUpPro.Properties.ShowFooter = false;
lookUpPro.ItemIndex = 0;
DataTable dtct = new DataTable();
dtct = TenantDetBL.PopulateCity();
lookUpCity.Properties.DataSource = CommFun.AddSelectToDataTable(dtct);
lookUpCity.Properties.PopulateColumns();
//lookUpCity.Properties.ForceInitialize();
lookUpCity.Properties.DisplayMember = "CityName";
lookUpCity.Properties.ValueMember = "CityId";
lookUpCity.Properties.Columns["CityId"].Visible = false;
lookUpCity.Properties.ShowHeader = false;
lookUpCity.Properties.ShowFooter = false;
lookUpCity.ItemIndex = 0;
}
catch (Exception ex)
{
BsfGlobal.CustomException(ex.Message, ex.StackTrace);
}
}
public void GetComplaint()
{
string sql = string.Empty;
sql = "Select ExtraItemTypeId,ExtraItemTypeName from ExtraItemTypeMaster";
cboItemType.Properties.DataSource = CommFun.AddSelectToDataTable(CommFun.FillRecord(sql));
cboItemType.Properties.PopulateColumns();
cboItemType.Properties.DisplayMember = "ExtraItemTypeName";
cboItemType.Properties.ValueMember = "ExtraItemTypeId";
cboItemType.Properties.Columns["ExtraItemTypeId"].Visible = false;
cboItemType.ItemIndex = 0;
}
private void PopulateFlat()
{
DataTable dtF = new DataTable();
dtF = PMSReceiptBL.GetFlat(Convert.ToInt32(cboCostCentre.EditValue));
cboFlatNo.Properties.DataSource = CommFun.AddSelectToDataTable(dtF);
cboFlatNo.Properties.DisplayMember = "FlatNo";
cboFlatNo.Properties.ValueMember = "FlatId";
cboFlatNo.Properties.PopulateColumns();
cboFlatNo.Properties.Columns["FlatId"].Visible = false;
cboFlatNo.Properties.ShowHeader = false;
cboFlatNo.Properties.ShowFooter = false;
}
public void GetData()
{
try
{
GetComplaint();
DataTable dtPpro = new DataTable();
dtPpro = ComplaintDetBL.PopulateProject(BsfGlobal.g_lUserId);
cboProj.Properties.DataSource = CommFun.AddSelectToDataTable(dtPpro);
cboProj.Properties.ForceInitialize();
cboProj.Properties.PopulateColumns();
cboProj.Properties.DisplayMember = "CostCentreName";
cboProj.Properties.ValueMember = "CostCentreId";
cboProj.Properties.Columns["CostCentreId"].Visible = false;
cboProj.Properties.ShowFooter = false;
cboProj.Properties.ShowHeader = false;
cboProj.ItemIndex = 0;
DataTable dtExe = new DataTable();
dtExe = ComplaintDetBL.PopulateExecutive();
cboExec.Properties.DataSource = CommFun.AddSelectToDataTable(dtExe);
cboExec.Properties.PopulateColumns();
cboExec.Properties.DisplayMember = "ExecName";
cboExec.Properties.ValueMember = "ExecId";
cboExec.Properties.Columns["ExecId"].Visible = false;
cboExec.Properties.Columns["Sel"].Visible = false;
cboExec.Properties.ShowFooter = false;
cboExec.Properties.ShowHeader = false;
cboExec.ItemIndex = 0;
DataTable dtEmp = new DataTable();
dtEmp = ComplaintDetBL.PopulateEmployee();
cboAttnExec.Properties.DataSource = CommFun.AddSelectToDataTable(dtEmp);
cboAttnExec.Properties.PopulateColumns();
cboAttnExec.Properties.DisplayMember = "ExecName";
cboAttnExec.Properties.ValueMember = "ExecId";
cboAttnExec.Properties.Columns["ExecId"].Visible = false;
cboAttnExec.Properties.Columns["Sel"].Visible = false;
cboAttnExec.Properties.ShowFooter = false;
cboAttnExec.Properties.ShowHeader = false;
cboAttnExec.ItemIndex = 0;
}
catch (Exception ex)
{
BsfGlobal.CustomException(ex.Message, ex.StackTrace);
}
}
public void GetCostCentre()
{
DataTable dt = new DataTable();
dt = PMSReceiptBL.GetCostCentre();
cboCostCentre.Properties.DataSource = CommFun.AddSelectToDataTable(dt);
cboCostCentre.Properties.PopulateColumns();
cboCostCentre.Properties.DisplayMember = "CostCentreName";
cboCostCentre.Properties.ValueMember = "CostCentreId";
cboCostCentre.Properties.Columns["CostCentreId"].Visible = false;
cboCostCentre.Properties.ShowHeader = false;
cboCostCentre.Properties.ShowFooter = false;
cboCostCentre.ItemIndex = 0;
}
public void GetBuyer()
{
DataTable dt = new DataTable();
dt = CashEntryBL.GetBuyer(m_iCCId);
cboBuyer.Properties.DataSource = CommFun.AddSelectToDataTable(dt);
cboBuyer.Properties.PopulateColumns();
cboBuyer.Properties.DisplayMember = "LeadName";
cboBuyer.Properties.ValueMember = "LeadId";
cboBuyer.Properties.Columns["LeadId"].Visible = false;
cboBuyer.Properties.ShowHeader = false;
cboBuyer.Properties.ShowFooter = false;
cboBuyer.ItemIndex = 0;
}
private void cboProj_EditValueChanged(object sender, EventArgs e)
{
string sql;
if (cboProj.ItemIndex != 0)
{
//sql = "Select FlatId,FlatNo FROM FlatDetails WHERE CostCentreId=" + cboProj.EditValue + " AND Status='S' ORDER BY FlatNo";
//sql = String.Format("select A.FlatId,B.FlatNo from RentDetail A inner join FlatDetails B on A.CostCentreId={0} and A.FlatId=B.FlatId where B.Status='S' ORDER BY FlatNo", cboProj.EditValue);
sql = String.Format("Select FlatId,FlatNo FROM FlatDetails where CostCentreId={0} and Status='S' ORDER BY FlatNo", cboProj.EditValue);
cboFlatNo.Properties.DataSource = CommFun.AddSelectToDataTable(CommFun.FillRecord(sql));
cboFlatNo.Properties.PopulateColumns();
cboFlatNo.Properties.DisplayMember = "FlatNo";
cboFlatNo.Properties.ValueMember = "FlatId";
cboFlatNo.Properties.Columns["FlatId"].Visible = false;
cboFlatNo.ItemIndex = 0;
}
}
private void cboProject_EditValueChanged(object sender, EventArgs e)
{
if (cboProject.ItemIndex != 0)
{
DataTable dtQu = new DataTable();
dtQu = ServiceOrderBillBL.PopulateQuote(Convert.ToInt32(cboProject.EditValue));
cboQuote.Properties.DataSource = CommFun.AddSelectToDataTable(dtQu);
cboQuote.Properties.PopulateColumns();
cboQuote.Properties.DisplayMember = "RefNo";
cboQuote.Properties.ValueMember = "RegisterId";
cboQuote.Properties.Columns["RegisterId"].Visible = false;
cboQuote.Properties.ShowFooter = false;
cboQuote.Properties.ShowHeader = false;
cboQuote.ItemIndex = 0;
}
}
private void lookUpPro_EditValueChanged(object sender, EventArgs e)
{
//string sql;
if (Convert.ToInt32(lookUpPro.EditValue.ToString()) != 0)
{
DataTable dt = new DataTable();
dt = TenantDetBL.PopulateBlock(Convert.ToInt32(lookUpPro.EditValue));
//sql = "SELECT BlockId,BlockName FROM BlockMaster Where CostCentreId = " + Convert.ToInt32(lookUpPro.EditValue) + " ORDER BY BlockName";
lookUpBlock.Properties.DataSource = CommFun.AddSelectToDataTable(dt);
lookUpBlock.Properties.PopulateColumns();
lookUpBlock.Properties.DisplayMember = "BlockName";
lookUpBlock.Properties.ValueMember = "BlockId";
lookUpBlock.Properties.Columns["BlockId"].Visible = false;
lookUpBlock.Properties.ShowHeader = false;
lookUpBlock.Properties.ShowFooter = false;
lookUpBlock.EditValue = 0;
}
}
public void GetComplaint()
{
try
{
DataTable dtNcom = new DataTable();
dtNcom = ComplaintDetBL.PopulateNature();
cboNature.Properties.DataSource = CommFun.AddSelectToDataTable(dtNcom);
cboNature.Properties.PopulateColumns();
cboNature.Properties.DisplayMember = "NatureComplaint";
cboNature.Properties.ValueMember = "ComplaintId";
cboNature.Properties.Columns["ComplaintId"].Visible = false;
cboNature.Properties.ShowFooter = false;
cboNature.Properties.ShowHeader = false;
cboNature.ItemIndex = 0;
}
catch (Exception ex)
{
BsfGlobal.CustomException(ex.Message, ex.StackTrace);
}
}
public void PopulateProject()
{
RepositoryItemLookUpEdit ff = cboProj.Edit as RepositoryItemLookUpEdit;
try
{
DataTable dt = new DataTable();
dt = ProgBillBL.GetCostCentre();
ff.DataSource = CommFun.AddSelectToDataTable(dt);
ff.PopulateColumns();
ff.ValueMember = "CostCentreId";
ff.DisplayMember = "CostCentreName";
ff.Columns["CostCentreId"].Visible = false;
ff.ShowFooter = false;
ff.ShowHeader = false;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void PopulateOtherCost()
{
try
{
DataTable dt = new DataTable();
dt = ReceiptDetailBL.GetOtherCost();
lookUpEdit1.Properties.DataSource = CommFun.AddSelectToDataTable(dt);
lookUpEdit1.Properties.ValueMember = "OtherCostId";
lookUpEdit1.Properties.DisplayMember = "OtherCostName";
lookUpEdit1.Properties.ForceInitialize();
lookUpEdit1.Properties.PopulateColumns();
lookUpEdit1.Properties.Columns["OtherCostId"].Visible = false;
lookUpEdit1.Properties.ShowFooter = false;
lookUpEdit1.Properties.ShowHeader = false;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public void GetData()
{
try
{
DataTable dtPpro = new DataTable();
dtPpro = ServiceOrderBillBL.PopulateProject(BsfGlobal.g_lUserId);
cboProject.Properties.DataSource = CommFun.AddSelectToDataTable(dtPpro);
cboProject.Properties.PopulateColumns();
cboProject.Properties.DisplayMember = "CostCentreName";
cboProject.Properties.ValueMember = "CostCentreId";
cboProject.Properties.Columns["CostCentreId"].Visible = false;
cboProject.Properties.ShowHeader = false;
cboProject.Properties.ShowFooter = false;
cboProject.ItemIndex = 0;
}
catch (Exception ex)
{
BsfGlobal.CustomException(ex.Message, ex.StackTrace);
}
}
private void lookUpBlock_EditValueChanged(object sender, EventArgs e)
{
//string sql;
if (bStatus == true)
{
if (lookUpPro.ItemIndex != 0 && lookUpBlock.ItemIndex != 0)
{
DataTable dtF = new DataTable();
dtF = TenantDetBL.PopulateFlat(Convert.ToInt32(lookUpPro.EditValue), Convert.ToInt32(lookUpBlock.EditValue));
////sql = "Select FlatId,FlatNo FROM FlatDetails WHERE CostCentreId=" + lookUpPro.EditValue + " and BlockId=" + lookUpBlock.EditValue + " and Status in('S','R') ORDER BY FlatNo";
//sql = "SELECT A.FlatId,A.FlatNo FROM FlatDetails A LEFT OUTER JOIN TenantRegister B on A.FlatId=B.FlatId where B.FlatId IS NULL and A.CostCentreId=" + lookUpPro.EditValue + " and A.BlockId=" + lookUpBlock.EditValue + " and A.Status in('S','R') ORDER BY A.FlatNo ";
lookUpUnit.Properties.DataSource = CommFun.AddSelectToDataTable(dtF);
lookUpUnit.Properties.PopulateColumns();
lookUpUnit.Properties.DisplayMember = "FlatNo";
lookUpUnit.Properties.ValueMember = "FlatId";
lookUpUnit.Properties.Columns["FlatId"].Visible = false;
lookUpUnit.Properties.ShowHeader = false;
lookUpUnit.Properties.ShowFooter = false;
lookUpUnit.EditValue = 0;
}
}
else
{
if (lookUpPro.ItemIndex != 0 && lookUpBlock.ItemIndex != 0)
{
DataTable dtF = new DataTable();
dtF = TenantDetBL.PopulateFlatSt(Convert.ToInt32(lookUpPro.EditValue), Convert.ToInt32(lookUpBlock.EditValue));
//sql = "Select FlatId,FlatNo FROM FlatDetails WHERE CostCentreId=" + lookUpPro.EditValue + " and BlockId=" + lookUpBlock.EditValue + " and Status in('S','R') ORDER BY FlatNo";
lookUpUnit.Properties.DataSource = CommFun.AddSelectToDataTable(dtF);
lookUpUnit.Properties.PopulateColumns();
lookUpUnit.Properties.DisplayMember = "FlatNo";
lookUpUnit.Properties.ValueMember = "FlatId";
lookUpUnit.Properties.Columns["FlatId"].Visible = false;
lookUpUnit.Properties.ShowHeader = false;
lookUpUnit.Properties.ShowFooter = false;
lookUpUnit.EditValue = 0;
}
}
}
public void PopulateAge()
{
try
{
DataTable dt = new DataTable();
dt = ProgBillBL.GetAgeDesc(m_iCCId);
cboAge.Properties.DataSource = CommFun.AddSelectToDataTable(dt);
cboAge.Properties.PopulateColumns();
cboAge.Properties.ForceInitialize();
cboAge.Properties.ValueMember = "AgeId";
cboAge.Properties.DisplayMember = "AgeDesc";
cboAge.Properties.Columns["AgeId"].Visible = false;
cboAge.Properties.Columns["FromDays"].Visible = false;
cboAge.Properties.Columns["ToDays"].Visible = false;
cboAge.Properties.Columns["ReportName"].Visible = false;
cboAge.Properties.ShowFooter = false;
cboAge.Properties.ShowHeader = false;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
