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