private void btnEdit_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (grdBrokerView.FocusedRowHandle < 0) { return; } if (BsfGlobal.FindPermission("Broker Details-Modify") == false) { MessageBox.Show("You don't have Rights to Broker-Modify"); return; } int iBrokerId = Convert.ToInt32(grdBrokerView.GetFocusedRowCellValue("BrokerId")); int iVendorId = Convert.ToInt32(grdBrokerView.GetFocusedRowCellValue("VendorId")); frmBrokerDet frmBr = new frmBrokerDet(); if (frmBr.Execute(iBrokerId, iVendorId) == true) { string sql = "SELECT BrokerId,A.VendorId,B.VendorName BrokerName " + " FROM BrokerDet A Inner Join [" + BsfGlobal.g_sVendorDBName + "].dbo.VendorMaster B On A.VendorId=B.VendorId" + " Where BrokerId= " + iBrokerId; DataTable dt = new DataTable(); dt = CommFun.FillRecord(sql); grdBrokerView.Columns["BrokerId"].Visible = false; grdBrokerView.Columns["VendorId"].Visible = false; if (dt.Rows.Count > 0) { grdBrokerView.SetRowCellValue(grdBrokerView.FocusedRowHandle, "BrokerName", dt.Rows[0]["BrokerName"].ToString()); } dt.Dispose(); } }
public void fillData() { try { string sql = string.Empty; sql = "SELECT BrokerId,A.VendorId,B.VendorName BrokerName,ISNULL(D.CityName,'')City,B.PinCode,C.Mobile1 Mobile FROM BrokerDet A " + " inner Join [" + BsfGlobal.g_sVendorDBName + "].dbo.VendorMaster B On A.VendorId=B.VendorId " + " left Join [" + BsfGlobal.g_sVendorDBName + "].dbo.VendorContact C On C.VendorID=B.VendorId " + " left Join [" + BsfGlobal.g_sWorkFlowDBName + "].dbo.CityMaster D On D.CityId=B.CityId ORDER BY VendorName"; dt = new DataTable(); dt = CommFun.FillRecord(sql); grdBroker.DataSource = dt; grdBrokerView.Columns["BrokerId"].Visible = false; grdBrokerView.Columns["VendorId"].Visible = false; grdBrokerView.Appearance.HeaderPanel.Font = new Font(grdBrokerView.Appearance.HeaderPanel.Font, FontStyle.Bold); grdBrokerView.Appearance.FocusedCell.BackColor = Color.Teal; grdBrokerView.Appearance.FocusedCell.ForeColor = Color.White; grdBrokerView.Appearance.FocusedRow.ForeColor = Color.White; grdBrokerView.Appearance.FocusedRow.BackColor = Color.Teal; grdBrokerView.OptionsSelection.EnableAppearanceHideSelection = false; } catch (Exception e) { throw e; } }
private void barbtnfilter_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { DataTable dt = new DataTable(); m_Filter = ""; frmFilter fFilter = new frmFilter(); if (m_dtFil.Rows.Count > 0) { fFilter.Exe(m_dtFil, fromDate, toDate); } m_Filter = fFilter.Execute(fromDate, toDate); if (m_Filter != "") { m_dtFil = fFilter.m_dtFilter; dt = CommFun.FillRecord(m_Filter); GrdLeadRegister.DataSource = dt; PopulateGrid(); } else { m_dtFil.Clear(); } grdLeadRegView.FocusedRowHandle = i; }
private void cboFlatNo_EditValueChanged(object sender, EventArgs e) { string sql; DataTable dtBuyer, dtTenant; txtBuyer.Text = ""; //txtTenant.Text = ""; if (cboFlatNo.ItemIndex != 0) { sql = String.Format("select A.LeadId,B.LeadName from BuyerDetail A inner join LeadRegister B on A.LeadId=B.LeadId where A.FlatId={0}", cboFlatNo.EditValue); dtBuyer = new DataTable(); dtBuyer = CommFun.FillRecord(sql); if (dtBuyer.Rows.Count > 0) { txtBuyer.Text = dtBuyer.Rows[0]["LeadName"].ToString(); txtBuyer.Tag = dtBuyer.Rows[0]["LeadId"].ToString(); txtBuyer.Properties.ReadOnly = true; dtBuyer.Dispose(); } sql = String.Format("SELECT A.TenantId,A.TenantName from TenantRegister A where A.FlatId={0}", cboFlatNo.EditValue); dtTenant = new DataTable(); dtTenant = CommFun.FillRecord(sql); if (dtTenant.Rows.Count > 0) { //txtTenant.Text = dtTenant.Rows[0]["TenantName"].ToString(); //txtTenant.Tag = dtTenant.Rows[0]["TenantId"].ToString(); //txtTenant.Properties.ReadOnly = true; //dtTenant.Dispose(); } } //else //{ // MessageBox.Show("There is no list for Rent Property..."); //} }
public void FillGrid() { try { string sql = string.Empty; //sql = "Select D.BrokerId,D.BName BrokerName,Sum(B.NetAmt) NetAmt,Sum(A.BrokerAmount) Payable,0 Paid,0 BalanceDue From BuyerDetail A " + // " Inner Join FlatDetails B On A.FlatId=B.FlatId And A.LeadId=B.LeadId And A.Status=B.Status " + // " Inner Join [" + BsfGlobal.g_sWorkFlowDBName + "].dbo.OperationalCostCentre C On B.CostCentreId=C.CostCentreId " + // " Inner Join BrokerDet D On A.BrokerId=D.BrokerId " + // " Inner Join LeadRegister E On A.LeadId=E.LeadId Group By D.BrokerId,D.BName"; sql = "Select D.BrokerId,F.VendorName BrokerName,Sum(B.NetAmt) NetAmt,Sum(A.BrokerAmount) Payable," + " Sum(Isnull(G.BillAmount,0)) Paid,Sum(A.BrokerAmount)-Sum(Isnull(G.BillAmount,0)) BalanceDue " + " From BuyerDetail A Inner Join FlatDetails B On A.FlatId=B.FlatId And A.LeadId=B.LeadId And A.Status=B.Status " + " Inner Join [" + BsfGlobal.g_sWorkFlowDBName + "].dbo.OperationalCostCentre C On B.CostCentreId=C.CostCentreId " + " Left Join BrokerDet D On A.BrokerId=D.BrokerId Inner Join LeadRegister E On A.LeadId=E.LeadId" + " Inner Join [" + BsfGlobal.g_sVendorDBName + "].dbo.VendorMaster F On F.VendorId=D.VendorId" + " Left Join BrokerBill G On G.FlatId=B.FlatId" + " Group By D.BrokerId,F.VendorName"; grdAbs.DataSource = CommFun.FillRecord(sql); grdViewAbs.Columns["BrokerId"].Visible = false; grdViewAbs.Columns["NetAmt"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum; grdViewAbs.Columns["NetAmt"].SummaryItem.DisplayFormat = BsfGlobal.g_sDigitFormatS; grdViewAbs.Columns["Payable"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum; grdViewAbs.Columns["Payable"].SummaryItem.DisplayFormat = BsfGlobal.g_sDigitFormatS; grdViewAbs.Columns["Paid"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum; grdViewAbs.Columns["Paid"].SummaryItem.DisplayFormat = BsfGlobal.g_sDigitFormatS; grdViewAbs.Columns["BalanceDue"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum; grdViewAbs.Columns["BalanceDue"].SummaryItem.DisplayFormat = BsfGlobal.g_sDigitFormatS; grdViewAbs.GroupFooterShowMode = DevExpress.XtraGrid.Views.Grid.GroupFooterShowMode.VisibleAlways; grdViewAbs.OptionsBehavior.AllowIncrementalSearch = true; grdViewAbs.OptionsView.ShowAutoFilterRow = false; grdViewAbs.OptionsView.ShowFooter = true; grdViewAbs.Columns["NetAmt"].Caption = "Sale Value"; grdViewAbs.Columns["NetAmt"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far; grdViewAbs.Columns["Payable"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far; grdViewAbs.Columns["Paid"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far; grdViewAbs.Columns["BalanceDue"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far; grdViewAbs.Appearance.HeaderPanel.Font = new Font(grdViewAbs.Appearance.HeaderPanel.Font, FontStyle.Bold); grdViewAbs.Appearance.FocusedCell.BackColor = Color.Teal; grdViewAbs.Appearance.FocusedCell.ForeColor = Color.White; grdViewAbs.Appearance.FocusedRow.ForeColor = Color.Black; grdViewAbs.Appearance.FocusedRow.BackColor = Color.Teal; grdViewAbs.OptionsSelection.EnableAppearanceHideSelection = false; } catch (Exception e) { throw e; } }
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; }
public void FillGrid() { try { string sql = string.Empty; sql = " Select C.FlatNo,B.TenantName,D.CostCentreName,A.EndDate,A.NetRent RentReceivable,0 Received,0 Balance" + " From RentDetail A " + " Inner Join TenantRegister B On A.TenantId=B.TenantId And A.FlatId=B.FlatId" + " Inner Join FlatDetails C On A.FlatId=C.FlatId" + " Inner Join [" + BsfGlobal.g_sWorkFlowDBName + "].dbo.OperationalCostCentre D On" + " A.CostCentreId=D.CostCentreId"; grdRent.DataSource = CommFun.FillRecord(sql); grdViewRent.PopulateColumns(); grdViewRent.Columns["FlatNo"].Caption = CommFun.m_sFuncName + " No"; grdViewRent.Columns["RentReceivable"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum; grdViewRent.Columns["RentReceivable"].SummaryItem.DisplayFormat = BsfGlobal.g_sDigitFormatS; grdViewRent.Columns["Received"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum; grdViewRent.Columns["Received"].SummaryItem.DisplayFormat = BsfGlobal.g_sDigitFormatS; grdViewRent.Columns["Balance"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum; grdViewRent.Columns["Balance"].SummaryItem.DisplayFormat = BsfGlobal.g_sDigitFormatS; grdViewRent.GroupFooterShowMode = DevExpress.XtraGrid.Views.Grid.GroupFooterShowMode.VisibleAlways; grdViewRent.OptionsBehavior.AllowIncrementalSearch = true; grdViewRent.OptionsView.ShowAutoFilterRow = true; grdViewRent.OptionsView.ShowFooter = true; grdViewRent.Columns["RentReceivable"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far; grdViewRent.Columns["Received"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far; grdViewRent.Columns["Balance"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far; grdViewRent.Columns["TenantName"].Group(); grdViewRent.ExpandAllGroups(); grdViewRent.Appearance.HeaderPanel.Font = new Font(grdViewRent.Appearance.HeaderPanel.Font, FontStyle.Bold); grdViewRent.Appearance.FocusedCell.BackColor = Color.Teal; grdViewRent.Appearance.FocusedCell.ForeColor = Color.White; grdViewRent.Appearance.FocusedRow.ForeColor = Color.Black; grdViewRent.Appearance.FocusedRow.BackColor = Color.Teal; grdViewRent.OptionsSelection.EnableAppearanceHideSelection = false; } catch (Exception e) { throw e; } }
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 txtDescription_Leave(object sender, EventArgs e) { string sql = "Select ItemDescription From ExtraItemMaster Where ItemDescription = '" + CommFun.IsNullCheck(txtDescription.EditValue.ToString(), CommFun.datatypes.vartypestring) + "' and ExtraItemId <> " + ExtraItemId; DataTable dtEI = new DataTable(); dtEI = CommFun.FillRecord(sql); if (dtEI.Rows.Count > 0) { MessageBox.Show("Item Description Already Exist"); txtDescription.EditValue = null; txtDescription.Focus(); } else { cboItemType.Focus(); } }
private void btnFilter_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (BsfGlobal.FindPermission("Lead-Filter") == false) { MessageBox.Show("You don't have Rights to Lead-Filter"); return; } DataTable dt = new DataTable(); m_Filter = ""; frmFilter fFilter = new frmFilter(); if (m_dtFil.Rows.Count > 0) { fFilter.Exe(m_dtFil, fromDate, toDate); } m_Filter = fFilter.Execute(fromDate, toDate); if (m_Filter != "") { m_dtFil = fFilter.m_dtFilter; dt = CommFun.FillRecord(m_Filter); DGvTrans.DataSource = dt; DGvTrans.ForceInitialize(); DGvTransView.PopulateColumns(); DGvTransView.Columns["LeadId"].Visible = false; DGvTransView.Columns["CostCentreId"].Visible = false; panelLeadEntry.Controls.Clear(); frmLeadInfo LeadInfo = new frmLeadInfo() { TopLevel = false, FormBorderStyle = FormBorderStyle.None, Dock = DockStyle.Fill }; panelLeadEntry.Controls.Add(LeadInfo); LeadInfo.Execute("E", Convert.ToInt32(DGvTransView.GetFocusedRowCellValue("LeadId")), Convert.ToInt32(DGvTransView.GetFocusedRowCellValue("CostCentreId")), "LeadReg"); } else { m_dtFil.Clear(); //FillEnquiry(); } DGvTransView.FocusedRowHandle = i; }
private void textItemCode_Leave(object sender, EventArgs e) { if (Convert.ToInt32(cboItemType.EditValue) != 0 && Convert.ToInt32(cboItemType.EditValue) != -1) { string sql = "Select ItemCode From ExtraItemMaster Where ItemCode = '" + CommFun.IsNullCheck(textItemCode.EditValue.ToString(), CommFun.datatypes.vartypestring) + "' and ExtraItemId <> " + ExtraItemId; DataTable dtEI = new DataTable(); dtEI = CommFun.FillRecord(sql); if (dtEI.Rows.Count > 0) { MessageBox.Show("Code Already Exist"); textItemCode.EditValue = null; textItemCode.Focus(); } else { txtDescription.Focus(); } } }
public void FillData() { string sql = "Select A.ExtraItemId,A.ItemCode,A.ItemDescription,A.ExtraItemTypeId,B.ExtraItemTypeName,C.Unit_Name UnitName,A.ExtraRate from ExtraItemMaster A " + "Inner Join ExtraItemTypeMaster B on A.ExtraItemTypeId=B.ExtraItemTypeId " + "Left Join [" + BsfGlobal.g_sRateAnalDBName + "].dbo.UOM C on A.UnitId=C.Unit_Id Order by A.ItemCode,A.ItemDescription"; dt = new DataTable(); dt = CommFun.FillRecord(sql); grdExtra.DataSource = dt; grdExtraView.PopulateColumns(); grdExtraView.Columns["ExtraItemId"].Visible = false; grdExtraView.Columns["ExtraItemTypeId"].Visible = false; grdExtraView.Columns["ItemCode"].Width = 100; grdExtraView.Columns["ItemDescription"].Width = 200; grdExtraView.Columns["ItemDescription"].Caption = "Item Description"; grdExtraView.Columns["ExtraItemTypeName"].Width = 100; grdExtraView.Columns["ExtraItemTypeName"].Caption = "Type Name"; grdExtraView.Columns["UnitName"].Width = 100; grdExtraView.Columns["UnitName"].Caption = "Unit"; grdExtraView.Columns["ExtraRate"].Width = 100; grdExtraView.Columns["ExtraRate"].Caption = "Rate"; grdExtraView.OptionsCustomization.AllowFilter = false; grdExtraView.OptionsBehavior.AllowIncrementalSearch = true; grdExtraView.OptionsView.ShowAutoFilterRow = false; grdExtraView.OptionsView.ShowViewCaption = false; grdExtraView.OptionsView.ShowFooter = false; grdExtraView.OptionsSelection.MultiSelectMode = GridMultiSelectMode.CellSelect; grdExtraView.OptionsSelection.InvertSelection = false; grdExtraView.OptionsView.ColumnAutoWidth = true; grdExtraView.Appearance.HeaderPanel.Font = new Font(grdExtraView.Appearance.HeaderPanel.Font, FontStyle.Bold); grdExtraView.Appearance.FocusedCell.BackColor = Color.Teal; grdExtraView.Appearance.FocusedCell.ForeColor = Color.White; grdExtraView.Appearance.FocusedRow.ForeColor = Color.Teal; grdExtraView.Appearance.FocusedRow.BackColor = Color.White; grdExtraView.OptionsSelection.EnableAppearanceHideSelection = false; }
public void FillData() { try { string sql = "Select A.ExtraItemId,A.ItemCode,A.ItemDescription,A.ExtraItemTypeId,B.ExtraItemTypeName," + "A.UnitId,A.ExtraRate from ExtraItemMaster A Inner Join ExtraItemTypeMaster B " + "on A.ExtraItemTypeId=B.ExtraItemTypeId WHERE ExtraItemId=" + ExtraItemId + ""; DataTable dtEI = new DataTable(); dtEI = CommFun.FillRecord(sql); if (dtEI.Rows.Count > 0) { cboItemType.EditValue = Convert.ToInt32(dtEI.Rows[0]["ExtraItemTypeId"].ToString()); textItemCode.Text = CommFun.IsNullCheck(dtEI.Rows[0]["ItemCode"].ToString(), CommFun.datatypes.vartypenumeric).ToString(); txtDescription.Text = CommFun.IsNullCheck(dtEI.Rows[0]["ItemDescription"].ToString(), CommFun.datatypes.vartypestring).ToString(); txtRate.Text = CommFun.IsNullCheck(dtEI.Rows[0]["ExtraRate"].ToString(), CommFun.datatypes.vartypenumeric).ToString(); cboUnit.EditValue = Convert.ToInt32(CommFun.IsNullCheck(dtEI.Rows[0]["UnitId"].ToString(), CommFun.datatypes.vartypenumeric).ToString()); } } catch (Exception e) { throw e; } }
private void btnEdit_ItemClick(object sender, ItemClickEventArgs e) { if (grdExtraView.FocusedRowHandle < 0) { return; } if (BsfGlobal.FindPermission("ExtraItem Register-Modify") == false) { MessageBox.Show("You don't have Rights to ExtraItem Register-Modify"); return; } DataView dvData; //bar1.Visible = false; if (grdExtraView.FocusedRowHandle >= 0) { dvData = new DataView(dt) { RowFilter = String.Format("ExtraItemId={0}", Convert.ToInt32(grdExtraView.GetFocusedRowCellValue("ExtraItemId").ToString())) }; int PBRegId = 0; PBRegId = Convert.ToInt32(grdExtraView.GetFocusedRowCellValue("ExtraItemId").ToString()); frmExtraItemMasterEntry frm = new frmExtraItemMasterEntry(); //{ dtComp = dvData.ToTable(), TopLevel = false, FormBorderStyle = System.Windows.Forms.FormBorderStyle.None, Dock = DockStyle.Fill }; //if (BsfGlobal.g_bWorkFlow == true) //{ // BsfGlobal.g_bTrans = true; // m_oDW = (Telerik.WinControls.UI.Docking.DocumentWindow)BsfGlobal.g_oDock.ActiveWindow; // m_oDW.Hide(); // BsfGlobal.g_bTrans = false; // Cursor.Current = Cursors.WaitCursor; // PanelControl oPanel = new PanelControl(); // oPanel = BsfGlobal.GetPanel(frm, "ExtraItemMaster Entry"); // if ((oPanel == null)) // return; // oPanel.Controls.Clear(); // oPanel.Controls.Add(frm); // frm.Execute(PBRegId, "E"); // oPanel.Visible = true; // Cursor.Current = Cursors.Default; //} //else //{ // Cursor.Current = Cursors.WaitCursor; // panelControl1.Controls.Clear(); // panelControl1.Controls.Add(frm); // frm.Execute(PBRegId, "E"); // Cursor.Current = Cursors.Default; //} if (frm.Execute(PBRegId, "E") == true) { string sql = "Select A.ExtraItemId,A.ItemCode,A.ItemDescription,A.ExtraItemTypeId,B.ExtraItemTypeName,C.Unit_Name UnitName,A.ExtraRate from ExtraItemMaster A " + "Inner Join ExtraItemTypeMaster B on A.ExtraItemTypeId=B.ExtraItemTypeId " + "Left Join [" + BsfGlobal.g_sRateAnalDBName + "].dbo.UOM C on A.UnitId=C.Unit_Id " + "Where A.ExtraItemId=" + PBRegId; DataTable dtEI = new DataTable(); dtEI = CommFun.FillRecord(sql); if (dtEI.Rows.Count > 0) { grdExtraView.SetRowCellValue(grdExtraView.FocusedRowHandle, "ExtraItemId", dtEI.Rows[0]["ExtraItemId"].ToString()); grdExtraView.SetRowCellValue(grdExtraView.FocusedRowHandle, "ItemCode", dtEI.Rows[0]["ItemCode"].ToString()); grdExtraView.SetRowCellValue(grdExtraView.FocusedRowHandle, "ItemDescription", dtEI.Rows[0]["ItemDescription"].ToString()); grdExtraView.SetRowCellValue(grdExtraView.FocusedRowHandle, "ExtraItemTypeId", dtEI.Rows[0]["ExtraItemTypeId"].ToString()); grdExtraView.SetRowCellValue(grdExtraView.FocusedRowHandle, "ExtraItemTypeName", dtEI.Rows[0]["ExtraItemTypeName"].ToString()); grdExtraView.SetRowCellValue(grdExtraView.FocusedRowHandle, "UnitName", dtEI.Rows[0]["UnitName"].ToString()); grdExtraView.SetRowCellValue(grdExtraView.FocusedRowHandle, "ExtraRate", dtEI.Rows[0]["ExtraRate"].ToString()); } dtEI.Dispose(); } } }
public void FillGridUnits() { if (grdViewAbs.FocusedRowHandle < 0 && grdViewProj.FocusedRowHandle < 0) { return; } int iBrokerId = Convert.ToInt32(grdViewAbs.GetFocusedRowCellValue("BrokerId")); int iCCId = Convert.ToInt32(grdViewProj.GetFocusedRowCellValue("CostCentreId")); string sBrokerName = grdViewProj.GetFocusedRowCellValue("BrokerName").ToString(); string sCCName = grdViewProj.GetFocusedRowCellValue("CostCentreName").ToString(); try { string sql = string.Empty; //sql = "Select B.FlatNo,E.LeadName BuyerName,D.BName BrokerName,B.NetAmt NetAmt,A.BrokerAmount Payable,0 Paid,0 BalanceDue From BuyerDetail A " + // " Inner Join FlatDetails B On A.FlatId=B.FlatId And A.LeadId=B.LeadId And A.Status=B.Status " + // " Inner Join [" + BsfGlobal.g_sWorkFlowDBName + "].dbo.OperationalCostCentre C On B.CostCentreId=C.CostCentreId " + // " Inner Join BrokerDet D On A.BrokerId=D.BrokerId " + // " Inner Join LeadRegister E On A.LeadId=E.LeadId Where D.BrokerId=" + iBrokerId + " And C.CostCentreId=" + iCCId + " "; sql = "Select B.FlatNo,E.LeadName BuyerName,F.VendorName BrokerName,B.NetAmt NetAmt,A.BrokerAmount Payable," + " Isnull(G.BillAmount,0) Paid,(Isnull(A.BrokerAmount,0)-Isnull(G.BillAmount,0)) BalanceDue " + " From BuyerDetail A Inner Join FlatDetails B On A.FlatId=B.FlatId And A.LeadId=B.LeadId And A.Status=B.Status " + " Inner Join [" + BsfGlobal.g_sWorkFlowDBName + "].dbo.OperationalCostCentre C On B.CostCentreId=C.CostCentreId " + " Inner Join BrokerDet D On A.BrokerId=D.BrokerId Inner Join LeadRegister E On A.LeadId=E.LeadId " + " Inner Join [" + BsfGlobal.g_sVendorDBName + "].dbo.VendorMaster F On F.VendorId=D.VendorId" + " Left Join BrokerBill G On G.FlatId=B.FlatId" + " Where D.BrokerId=" + iBrokerId + " And C.CostCentreId=" + iCCId + " "; grdUnit.DataSource = CommFun.FillRecord(sql); grdViewUnit.PopulateColumns(); grdViewUnit.Columns["BrokerName"].Visible = false; grdViewUnit.Columns["NetAmt"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum; grdViewUnit.Columns["NetAmt"].SummaryItem.DisplayFormat = BsfGlobal.g_sDigitFormatS; grdViewUnit.Columns["Payable"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum; grdViewUnit.Columns["Payable"].SummaryItem.DisplayFormat = BsfGlobal.g_sDigitFormatS; grdViewUnit.Columns["Paid"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum; grdViewUnit.Columns["Paid"].SummaryItem.DisplayFormat = BsfGlobal.g_sDigitFormatS; grdViewUnit.Columns["BalanceDue"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum; grdViewUnit.Columns["BalanceDue"].SummaryItem.DisplayFormat = BsfGlobal.g_sDigitFormatS; BuyerCaption.Caption = "BUYER WISE PAYABLE - " + sBrokerName + "(" + sCCName + ")"; grdViewUnit.GroupFooterShowMode = DevExpress.XtraGrid.Views.Grid.GroupFooterShowMode.VisibleAlways; grdViewUnit.OptionsBehavior.AllowIncrementalSearch = true; grdViewUnit.OptionsView.ShowAutoFilterRow = false; grdViewUnit.OptionsView.ShowFooter = true; grdViewUnit.Columns["NetAmt"].Caption = "Sale Value"; grdViewUnit.Columns["NetAmt"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far; grdViewUnit.Columns["Payable"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far; grdViewUnit.Columns["Paid"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far; grdViewUnit.Columns["BalanceDue"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far; grdViewUnit.Appearance.HeaderPanel.Font = new Font(grdViewUnit.Appearance.HeaderPanel.Font, FontStyle.Bold); grdViewUnit.Appearance.FocusedCell.BackColor = Color.Teal; grdViewUnit.Appearance.FocusedCell.ForeColor = Color.White; grdViewUnit.Appearance.FocusedRow.ForeColor = Color.Black; grdViewUnit.Appearance.FocusedRow.BackColor = Color.Teal; grdViewUnit.OptionsSelection.EnableAppearanceHideSelection = false; } catch (Exception e) { throw e; } }