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