private void PopulateOPCostCentre()
{
DataTable dtOpCC = new DataTable();
dtOpCC = FlatTypeBL.GetOpCostCentre();
DataRow dr = null;
dr = dtOpCC.NewRow();
dr["CostCentreId"] = 0;
dr["CostCentreName"] = "None";
dr["Typewise"] = false;
dtOpCC.Rows.InsertAt(dr, 0);
if (dtOpCC.Rows.Count > 0)
{
CostCentre.DataSource = dtOpCC;
CostCentre.PopulateColumns();
CostCentre.DisplayMember = "CostCentreName";
CostCentre.ValueMember = "CostCentreId";
CostCentre.Columns["CostCentreId"].Visible = false;
CostCentre.Columns["Typewise"].Visible = false;
CostCentre.ShowFooter = false;
CostCentre.ShowHeader = false;
}
cboCostCentre.EditValue = 0;
}
private void PopulateTermUnit()
{
DataTable dt = new DataTable();
dt = FlatTypeBL.GetBuyerTermSheetUnit(m_iCCId, m_bPayTypewise, m_iFlatId);
grdUnit.DataSource = null;
grdViewUnit.Columns.Clear();
grdUnit.DataSource = dt;
grdUnit.ForceInitialize();
grdViewUnit.PopulateColumns();
grdViewUnit.Columns["ActualValue"].Visible = false;
grdViewUnit.Columns["Type"].Visible = false;
grdViewUnit.Columns["Description"].Width = 150;
grdViewUnit.Columns["Actual"].Width = 120;
grdViewUnit.OptionsCustomization.AllowFilter = true;
grdViewUnit.OptionsBehavior.AllowIncrementalSearch = true;
grdViewUnit.OptionsView.ShowAutoFilterRow = true;
grdViewUnit.OptionsView.ShowViewCaption = true;
grdViewUnit.OptionsView.ShowFooter = true;
grdViewUnit.OptionsView.ColumnAutoWidth = true;
grdViewUnit.Appearance.HeaderPanel.Font = new Font(grdViewUnit.Appearance.HeaderPanel.Font, FontStyle.Bold);
grdViewUnit.FocusedRowHandle = 0;
grdViewUnit.FocusedColumn = grdViewUnit.VisibleColumns[0];
grdViewUnit.OptionsSelection.InvertSelection = true;
grdViewUnit.OptionsSelection.EnableAppearanceFocusedRow = false;
grdViewUnit.Appearance.FocusedRow.BackColor = Color.Teal;
grdViewUnit.Appearance.FocusedRow.ForeColor = Color.White;
}
private void PopulateTermPayment()
{
DataTable dt = new DataTable();
dt = FlatTypeBL.GetBuyerTermSheetPayment(m_iCCId, m_bPayTypewise, m_iFlatId);
grdPayment.DataSource = null;
grdViewPayment.Columns.Clear();
grdPayment.DataSource = dt;
grdPayment.ForceInitialize();
grdViewPayment.PopulateColumns();
grdViewPayment.Columns["SortOrder"].Visible = false;
grdViewPayment.Columns["Installment"].Width = 100;
grdViewPayment.Columns["Description"].Width = 250;
grdViewPayment.Columns["Percentage"].Width = 50;
grdViewPayment.Columns["Amount"].Width = 100;
grdViewPayment.Columns["Tax"].Width = 100;
grdViewPayment.Columns["Total"].Width = 100;
grdViewPayment.Columns["Description"].Caption = "Stage of Payment";
grdViewPayment.Columns["Percentage"].Caption = "%";
grdViewPayment.Columns["Tax"].Caption = "Service Tax";
grdViewPayment.Columns["Amount"].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
grdViewPayment.Columns["Tax"].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
grdViewPayment.Columns["Total"].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
grdViewPayment.Columns["Amount"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
grdViewPayment.Columns["Amount"].DisplayFormat.FormatString = BsfGlobal.g_sDigitFormat;
grdViewPayment.Columns["Tax"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
grdViewPayment.Columns["Tax"].DisplayFormat.FormatString = BsfGlobal.g_sDigitFormat;
grdViewPayment.Columns["Total"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
grdViewPayment.Columns["Total"].DisplayFormat.FormatString = BsfGlobal.g_sDigitFormat;
grdViewPayment.Columns["Amount"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
grdViewPayment.Columns["Amount"].SummaryItem.DisplayFormat = BsfGlobal.g_sDigitFormatS;
grdViewPayment.Columns["Tax"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
grdViewPayment.Columns["Tax"].SummaryItem.DisplayFormat = BsfGlobal.g_sDigitFormatS;
grdViewPayment.Columns["Total"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
grdViewPayment.Columns["Total"].SummaryItem.DisplayFormat = BsfGlobal.g_sDigitFormatS;
grdViewPayment.OptionsCustomization.AllowFilter = true;
grdViewPayment.OptionsBehavior.AllowIncrementalSearch = true;
grdViewPayment.OptionsView.ShowAutoFilterRow = true;
grdViewPayment.OptionsView.ShowViewCaption = true;
grdViewPayment.OptionsView.ShowFooter = true;
grdViewPayment.OptionsView.ColumnAutoWidth = true;
grdViewPayment.Appearance.HeaderPanel.Font = new Font(grdViewPayment.Appearance.HeaderPanel.Font, FontStyle.Bold);
grdViewPayment.FocusedRowHandle = 0;
grdViewPayment.FocusedColumn = grdViewPayment.VisibleColumns[0];
grdViewPayment.OptionsSelection.InvertSelection = true;
grdViewPayment.OptionsSelection.EnableAppearanceFocusedRow = false;
grdViewPayment.Appearance.FocusedRow.BackColor = Color.Teal;
grdViewPayment.Appearance.FocusedRow.ForeColor = Color.White;
}
private void PopulateCostSheet()
{
DataTable dt = new DataTable();
dt = FlatTypeBL.GetCostSheet(m_iCCId, m_bPayTypewise);
grdCost.DataSource = null;
grdViewCost.Columns.Clear();
grdCost.DataSource = dt;
grdCost.ForceInitialize();
grdViewCost.PopulateColumns();
grdViewCost.Columns["FlatId"].Visible = false;
grdViewCost.Columns["Area"].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
grdViewCost.Columns["Area"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
grdViewCost.Columns["Area"].DisplayFormat.FormatString = BsfGlobal.g_sDigitFormat;
grdViewCost.Columns["Area"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
grdViewCost.Columns["Area"].SummaryItem.DisplayFormat = BsfGlobal.g_sDigitFormatS;
for (int i = 6; i < dt.Columns.Count; i++)
{
string sName = grdViewCost.Columns[i].FieldName;
//grdViewPayment.Columns[sName].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Near;
grdViewCost.Columns[sName].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
grdViewCost.Columns[sName].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
grdViewCost.Columns[sName].DisplayFormat.FormatString = BsfGlobal.g_sDigitFormat;
grdViewCost.Columns[sName].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
grdViewCost.Columns[sName].SummaryItem.DisplayFormat = BsfGlobal.g_sDigitFormatS;
if (Convert.ToDecimal(grdViewCost.Columns[sName].SummaryItem.SummaryValue) == 0)
{
grdViewCost.Columns[sName].Visible = false;
}
}
grdViewCost.Columns["Total"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
grdViewCost.Columns["Total"].DisplayFormat.FormatString = BsfGlobal.g_sDigitFormat;
grdViewCost.Columns["Total"].Caption = "Grand Total";
grdViewCost.OptionsCustomization.AllowFilter = true;
grdViewCost.OptionsBehavior.AllowIncrementalSearch = true;
grdViewCost.OptionsView.ShowAutoFilterRow = true;
grdViewCost.OptionsView.ShowViewCaption = false;
grdViewCost.OptionsView.ShowFooter = true;
grdViewCost.OptionsView.ColumnAutoWidth = true;
grdViewCost.Appearance.HeaderPanel.Font = new Font(grdViewCost.Appearance.HeaderPanel.Font, FontStyle.Bold);
grdViewCost.FocusedRowHandle = 0;
grdViewCost.FocusedColumn = grdViewCost.VisibleColumns[0];
grdViewCost.OptionsSelection.InvertSelection = true;
grdViewCost.OptionsSelection.EnableAppearanceFocusedRow = false;
grdViewCost.Appearance.FocusedRow.BackColor = Color.Teal;
grdViewCost.Appearance.FocusedRow.ForeColor = Color.White;
}
public void cbosblock()
{
dtBlock = new DataTable();
dtBlock = FlatTypeBL.GetBlock(m_iCCId);
cboSBlock.Properties.DataSource = dtBlock;
cboSBlock.Properties.PopulateColumns();
cboSBlock.Properties.DisplayMember = "BlockName";
cboSBlock.Properties.ValueMember = "BlockId";
cboSBlock.Properties.Columns["BlockId"].Visible = false;
cboSBlock.Properties.ShowFooter = false;
cboSBlock.Properties.ShowHeader = false;
}
private void PopulateFlatType()
{
DataTable dt = new DataTable();
dt = FlatTypeBL.GetFlatTypeDetails(m_iCCId);
FlatType.DataSource = CommFun.AddAllToDataTable(dt);
FlatType.PopulateColumns();
FlatType.DisplayMember = "TypeName";
FlatType.ValueMember = "FlatTypeId";
FlatType.Columns["FlatTypeId"].Visible = false;
FlatType.ShowFooter = false;
FlatType.ShowHeader = false;
cboFlatType.EditValue = -1;
}
private void Type()
{
RepositoryItemLookUpEdit ff = cboType.Edit as RepositoryItemLookUpEdit;
DtFType = new DataTable();
DtFType = FlatTypeBL.GetCarDetails();
ff.DataSource = DtFType;
ff.DisplayMember = "TypeName";
ff.ValueMember = "TypeId";
ff.PopulateColumns();
ff.Columns["TypeId"].Visible = false;
ff.ShowHeader = false;
ff.ShowFooter = false;
}
private void btnOK_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
string sDate = UnitDirBL.FoundDateLand();
if (sDate != "")
{
if (Convert.ToDateTime(CommFun.IsNullCheck(sDate, CommFun.datatypes.VarTypeDate)) > Convert.ToDateTime(dEDate.EditValue))
{
MessageBox.Show("Enter Valid Date"); return;
}
}
grdViewRate.FocusedRowHandle = grdViewRate.FocusedRowHandle + 1;
FlatTypeBL.InsertChangeRate(dtRate, string.Format(Convert.ToDateTime(dEDate.EditValue).ToString("dd-MMM-yyyy")), dtR);
Close();
}
private void Type()
{
RepositoryItemLookUpEdit cboTyp = cboType.Edit as RepositoryItemLookUpEdit;
DataTable dt = new DataTable();
dt = FlatTypeBL.GetCarDetails();
cboTyp.DataSource = dt;
cboTyp.DisplayMember = "TypeName";
cboTyp.ValueMember = "TypeId";
cboTyp.PopulateColumns();
cboTyp.Columns["TypeId"].Visible = false;
cboTyp.ShowHeader = false;
cboTyp.ShowFooter = false;
}
private void PopulateBuyerCostSheet()
{
DataTable dt = new DataTable();
dt = FlatTypeBL.BuyerGetCostSheet(m_iCCId, m_bPayTypewise, m_iFlatId);
grdCost.DataSource = null;
grdViewCost.Columns.Clear();
DataView dv = new DataView(dt);
dv.RowFilter = "((ActualValue<>0 And DiscountValue<>0 And Type=true) or (Type=false))";
dt = dv.ToTable();
if (m_sStatus == "U")
{
dt.Columns.RemoveAt(2);
}
grdCost.DataSource = dt;
grdCost.ForceInitialize();
grdViewCost.PopulateColumns();
grdViewCost.Columns["ActualValue"].Visible = false;
grdViewCost.Columns["DiscountValue"].Visible = false;
grdViewCost.Columns["Type"].Visible = false;
grdViewCost.Columns["Description"].Width = 500;
grdViewCost.Columns["Actual"].Width = 250;
if (m_sStatus != "U")
{
grdViewCost.Columns["Discount"].Width = 250;
grdViewCost.Columns["Discount"].Caption = "After Discount";
}
grdViewCost.OptionsCustomization.AllowFilter = true;
grdViewCost.OptionsBehavior.AllowIncrementalSearch = true;
grdViewCost.OptionsView.ShowViewCaption = false;
grdViewCost.OptionsView.ShowFooter = true;
grdViewCost.OptionsView.ColumnAutoWidth = true;
grdViewCost.Appearance.HeaderPanel.Font = new Font(grdViewCost.Appearance.HeaderPanel.Font, FontStyle.Bold);
grdViewCost.FocusedRowHandle = 0;
grdViewCost.FocusedColumn = grdViewCost.VisibleColumns[0];
grdViewCost.OptionsSelection.InvertSelection = true;
grdViewCost.OptionsSelection.EnableAppearanceFocusedRow = false;
grdViewCost.Appearance.FocusedRow.BackColor = Color.Teal;
grdViewCost.Appearance.FocusedRow.ForeColor = Color.White;
}
private void PopulateBuyerCostSheet()
{
m_bLayout = false;
DataTable dt = new DataTable();
dt = FlatTypeBL.BuyerGetCostSheet(m_iCCId, m_bPayTypewise, m_iFlatId);
grdF1.DataSource = null;
grdViewF1.Columns.Clear();
DataView dv = new DataView(dt);
dv.RowFilter = "((ActualValue<>0 And DiscountValue<>0 And Type=true) or (Type=false))";
dt = dv.ToTable();
grdF1.DataSource = dt;
grdF1.ForceInitialize();
grdViewF1.PopulateColumns();
grdViewF1.Columns["ActualValue"].Visible = false;
grdViewF1.Columns["DiscountValue"].Visible = false;
grdViewF1.Columns["Type"].Visible = false;
grdViewF1.Columns["Description"].Width = 500;
grdViewF1.Columns["Actual"].Width = 250;
grdViewF1.Columns["Discount"].Width = 250;
grdViewF1.Columns["Discount"].Caption = "After Discount";
grdViewF1.Columns["Description"].ColumnEdit = repositoryItemMemoEdit1;
grdViewF1.Columns["Actual"].ColumnEdit = repositoryItemMemoEdit1;
grdViewF1.Columns["Discount"].ColumnEdit = repositoryItemMemoEdit1;
grdViewF1.OptionsView.ShowFooter = true;
grdViewF1.OptionsView.ColumnAutoWidth = false;
grdViewF1.FocusedRowHandle = 0;
grdViewF1.FocusedColumn = grdViewF1.VisibleColumns[0];
grdViewF1.OptionsCustomization.AllowColumnMoving = true;
grdViewF1.OptionsSelection.InvertSelection = true;
grdViewF1.OptionsSelection.EnableAppearanceHideSelection = false;
grdViewF1.Appearance.FocusedRow.BackColor = Color.Teal;
grdViewF1.Appearance.FocusedRow.ForeColor = Color.White;
BsfGlobal.RestoreLayout("Format1", grdViewF1);
m_bLayout = true;
}
private void FillRateDetails()
{
dtRate = new DataTable();
dtRate = FlatTypeBL.GetFlatTypeRateHistory(m_iCCId, m_sDate, m_sType);
grdRate.DataSource = dtRate;
grdViewRate.BestFitColumns();
grdViewRate.OptionsCustomization.AllowFilter = true;
grdViewRate.OptionsView.ShowAutoFilterRow = false;
grdViewRate.OptionsView.ShowViewCaption = false;
grdViewRate.OptionsView.ShowFooter = false;
grdViewRate.OptionsSelection.MultiSelectMode = GridMultiSelectMode.CellSelect;
grdViewRate.OptionsSelection.InvertSelection = false;
grdViewRate.OptionsView.ColumnAutoWidth = true;
grdViewRate.Appearance.HeaderPanel.Font = new Font(grdViewRate.Appearance.HeaderPanel.Font, FontStyle.Bold);
}
public void cboslevel()
{
dtLevel = new DataTable();
dtLevel = FlatTypeBL.GetLevel(m_iCCId);
DataRow dr = dtLevel.NewRow();
dr["LevelId"] = 0;
dr["LevelName"] = "All";
dtLevel.Rows.InsertAt(dr, 0);
cboSLevel.Properties.DataSource = dtLevel;
cboSLevel.Properties.PopulateColumns();
cboSLevel.Properties.DisplayMember = "LevelName";
cboSLevel.Properties.ValueMember = "LevelId";
cboSLevel.Properties.Columns["LevelId"].Visible = false;
cboSLevel.Properties.ShowFooter = false;
cboSLevel.Properties.ShowHeader = false;
}
private void PopulateFlat()
{
DataTable dtF = new DataTable();
dtF = FlatTypeBL.GetFlat(m_iCCId, m_iFlatTypeId, m_iBlockId, m_iLevelId);
DataRow dr = dtF.NewRow();
dr["FlatId"] = 0;
dr["FlatNo"] = "All";
dtF.Rows.InsertAt(dr, 0);
cboFlat.Properties.DataSource = dtF;
cboFlat.Properties.DisplayMember = "FlatNo";
cboFlat.Properties.ValueMember = "FlatId";
cboFlat.Properties.PopulateColumns();
cboFlat.Properties.Columns["FlatId"].Visible = false;
cboFlat.Properties.ShowHeader = false;
cboFlat.Properties.ShowFooter = false;
}
private void PopulatePaySch()
{
grdPayment.DataSource = null;
grdViewPayment.Columns.Clear();
DataTable dt = new DataTable();
dt = FlatTypeBL.GetPayReport(m_iCCId, m_iTypeId);
grdPayment.DataSource = dt;
grdPayment.ForceInitialize();
grdViewPayment.PopulateColumns();
grdViewPayment.Columns["CostCentreId"].Visible = false;
grdViewPayment.Columns["FlatTypeId"].Visible = false;
grdViewPayment.Columns["PayTypeId"].Visible = false;
grdViewPayment.Columns["TypeName"].Width = 250;
for (int i = 4; i < dt.Columns.Count; i++)
{
grdViewPayment.Columns[i].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
grdViewPayment.Columns[i].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
grdViewPayment.Columns[i].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
grdViewPayment.Columns[i].DisplayFormat.FormatString = BsfGlobal.g_sDigitFormat;
grdViewPayment.Columns[i].SummaryItem.SummaryType = SummaryItemType.Sum;
grdViewPayment.Columns[i].SummaryItem.DisplayFormat = BsfGlobal.g_sDigitFormatS;
}
grdViewPayment.OptionsView.ShowFooter = true;
grdViewPayment.OptionsView.ColumnAutoWidth = false;
grdViewPayment.Appearance.HeaderPanel.Font = new Font(grdViewPayment.Appearance.HeaderPanel.Font, FontStyle.Bold);
grdViewPayment.FocusedRowHandle = 0;
grdViewPayment.FocusedColumn = grdViewPayment.VisibleColumns[0];
grdViewPayment.OptionsSelection.InvertSelection = true;
grdViewPayment.OptionsSelection.EnableAppearanceHideSelection = false;
grdViewPayment.Appearance.FocusedRow.BackColor = Color.Teal;
grdViewPayment.Appearance.FocusedRow.ForeColor = Color.White;
grdViewPayment.Appearance.HeaderPanel.Options.UseTextOptions = true;
grdViewPayment.Appearance.HeaderPanel.TextOptions.WordWrap = DevExpress.Utils.WordWrap.Wrap;
grdViewPayment.OptionsView.AllowHtmlDrawHeaders = true;
grdViewPayment.BestFitColumns();
}
public void PopulateFlatType()
{
DataTable dt = new DataTable();
dt = FlatTypeBL.GetFlatTypeDetails(m_iCCId);
DataRow dr = dt.NewRow();
dr["FlatTypeId"] = 0;
dr["TypeName"] = "All";
dt.Rows.InsertAt(dr, 0);
cboFlatType.Properties.DataSource = dt;
cboFlatType.Properties.PopulateColumns();
cboFlatType.Properties.DisplayMember = "TypeName";
cboFlatType.Properties.ValueMember = "FlatTypeId";
cboFlatType.Properties.Columns["FlatTypeId"].Visible = false;
cboFlatType.Properties.ShowFooter = false;
cboFlatType.Properties.ShowHeader = false;
cboFlatType.EditValue = 0;
}
public void PopulateBlock()
{
DataTable dtBlock = new DataTable();
dtBlock = FlatTypeBL.GetBlock(m_iCCId);
DataRow dr = dtBlock.NewRow();
dr["BlockId"] = 0;
dr["BlockName"] = "All";
dtBlock.Rows.InsertAt(dr, 0);
cboBlock.Properties.DataSource = dtBlock;
cboBlock.Properties.PopulateColumns();
cboBlock.Properties.DisplayMember = "BlockName";
cboBlock.Properties.ValueMember = "BlockId";
cboBlock.Properties.Columns["BlockId"].Visible = false;
cboBlock.Properties.ShowFooter = false;
cboBlock.Properties.ShowHeader = false;
cboBlock.EditValue = 0;
}
private void FillRateDetails()
{
dtRate = new DataTable();
dtRate = FlatTypeBL.GetFlatTypeRateDetails(m_iCCId);
grdRate.DataSource = dtRate;
grdViewRate.Columns["ProjId"].Visible = false;
grdViewRate.Columns["FlatTypeId"].Visible = false;
grdViewRate.Columns["Area"].Visible = false;
grdViewRate.Columns["OtherCostAmt"].Visible = false;
grdViewRate.Columns["FloorwiseRate"].Visible = false;
grdViewRate.Columns["GuideLineValue"].Visible = false;
grdViewRate.Columns["AdvPercent"].Visible = false;
grdViewRate.BestFitColumns();
grdViewRate.Columns["TypeName"].OptionsColumn.ReadOnly = true;
grdViewRate.Columns["OldRate"].OptionsColumn.ReadOnly = true;
grdViewRate.Columns["TypeName"].OptionsColumn.AllowEdit = false;
grdViewRate.Columns["OldRate"].OptionsColumn.AllowEdit = false;
RepositoryItemButtonEdit btnAmtEdit = new RepositoryItemButtonEdit();
grdViewRate.Columns["NewRate"].ColumnEdit = btnAmtEdit;
btnAmtEdit.DoubleClick += btnAmtEdit_DoubleClick;
btnAmtEdit.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.Numeric;
btnAmtEdit.TextEditStyle = TextEditStyles.Standard;
btnAmtEdit.Mask.EditMask = "########################";
btnAmtEdit.Mask.UseMaskAsDisplayFormat = true;
btnAmtEdit.KeyPress += btnAmtEdit_KeyPress;
btnAmtEdit.KeyDown += btnAmtEdit_KeyDown;
btnAmtEdit.Spin += btnAmtEdit_Spin;
grdViewRate.OptionsCustomization.AllowFilter = false;
grdViewRate.OptionsView.ShowAutoFilterRow = false;
grdViewRate.OptionsView.ShowViewCaption = false;
grdViewRate.OptionsView.ShowFooter = false;
grdViewRate.OptionsSelection.MultiSelectMode = GridMultiSelectMode.CellSelect;
grdViewRate.OptionsSelection.InvertSelection = false;
grdViewRate.OptionsView.ColumnAutoWidth = true;
grdViewRate.Appearance.HeaderPanel.Font = new Font(grdViewRate.Appearance.HeaderPanel.Font, FontStyle.Bold);
}
private void PopulateAECostSheet()
{
m_bLayout = false;
DataTable dt = new DataTable();
if (m_sType == "AsOn")
{
dt = FlatTypeBL.GetAECostSheet(m_iCCId, m_bPayTypewise, Convert.ToDateTime(deDate.EditValue));
}
else
{
dt = FlatTypeBL.GetBWAECostSheet(m_iCCId, m_bPayTypewise, Convert.ToDateTime(deFrom), Convert.ToDateTime(deTo));
}
//DataView dv = new DataView(dt);
//dv.RowFilter = "PaidNetAmount<>0";
//dt = dv.ToTable();
grdF2.DataSource = null;
grdF2.DataSource = dt;
grdF2.ForceInitialize();
grdViewF2.PopulateColumns();
grdViewF2.Columns["FlatId"].Visible = false;
grdViewF2.Columns["FlatId"].OptionsColumn.ShowInCustomizationForm = false;
grdViewF2.Columns["BlockName"].Visible = false;
grdViewF2.Columns["LevelName"].Visible = false;
grdViewF2.Columns["Campaign"].Visible = false;
grdViewF2.Columns["Executive"].Visible = false;
if (Convert.ToBoolean(dt.Columns.Contains("Registration")) == false)
{
}
else
{
grdViewF2.Columns["Registration"].Visible = false;
}
grdViewF2.Columns["LeadName"].Caption = "BUYER NAME";
grdViewF2.Columns["FlatNo"].Caption = CommFun.m_sFuncName.ToUpper() + " NO";
grdViewF2.Columns["TypeName"].Caption = "TYPE NAME";
grdViewF2.Columns["BookingDate"].Caption = "BOOKING DATE";
grdViewF2.Columns["Area"].Caption = "AREA SQ.FT";
grdViewF2.Columns["Rate"].Caption = "RATE PER SQFT";
grdViewF2.Columns["BaseAmt"].Caption = "AMOUNT(RS)";
grdViewF2.Columns["LeadName"].ColumnEdit = repositoryItemMemoEdit1;
grdViewF2.Columns["FlatNo"].ColumnEdit = repositoryItemMemoEdit1;
grdViewF2.Columns["TypeName"].ColumnEdit = repositoryItemMemoEdit1;
grdViewF2.Columns["Area"].ColumnEdit = repositoryItemMemoEdit1;
grdViewF2.Columns["Rate"].ColumnEdit = repositoryItemMemoEdit1;
grdViewF2.Columns["BaseAmt"].ColumnEdit = repositoryItemMemoEdit1;
grdViewF2.Columns["BookingDate"].ColumnEdit = repositoryItemDateEdit2;
grdViewF2.Columns["Area"].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
grdViewF2.Columns["Area"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
grdViewF2.Columns["Area"].DisplayFormat.FormatString = BsfGlobal.g_sDigitFormat;
grdViewF2.Columns["Rate"].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
grdViewF2.Columns["Rate"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
grdViewF2.Columns["Rate"].DisplayFormat.FormatString = BsfGlobal.g_sDigitFormat;
grdViewF2.Columns["BaseAmt"].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
grdViewF2.Columns["BaseAmt"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
grdViewF2.Columns["BaseAmt"].DisplayFormat.FormatString = BsfGlobal.g_sDigitFormat;
grdViewF2.Columns["Area"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
grdViewF2.Columns["Area"].SummaryItem.DisplayFormat = BsfGlobal.g_sDigitFormatS;
grdViewF2.Columns["Rate"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
grdViewF2.Columns["Rate"].SummaryItem.DisplayFormat = BsfGlobal.g_sDigitFormatS;
grdViewF2.Columns["BaseAmt"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
grdViewF2.Columns["BaseAmt"].SummaryItem.DisplayFormat = BsfGlobal.g_sDigitFormatS;
for (int i = 9; i < dt.Columns.Count; i++)
{
grdViewF2.Columns[i].Caption = grdViewF2.Columns[i].FieldName.ToUpper();
grdViewF2.Columns[i].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
grdViewF2.Columns[i].DisplayFormat.FormatString = BsfGlobal.g_sDigitFormat;
grdViewF2.Columns[i].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
grdViewF2.Columns[i].SummaryItem.DisplayFormat = BsfGlobal.g_sDigitFormatS;
grdViewF2.Columns[i].ColumnEdit = repositoryItemMemoEdit2;
if (Convert.ToDecimal(grdViewF2.Columns[i].SummaryItem.SummaryValue) == 0)
{
grdViewF2.Columns[i].Visible = false;
}
}
grdViewF2.Columns["AmountReceivedLand"].Caption = "AMOUNT RECEIVED FOR LAND ON REGN";
grdViewF2.Columns["LeadName"].Width = 200;
int x = grdViewF2.Columns["GrandTotal"].VisibleIndex;
grdViewF2.Columns["UDS"].VisibleIndex = x + 1;
int x1 = grdViewF2.Columns["UDS"].VisibleIndex;
grdViewF2.Columns["LandValue"].VisibleIndex = x1 + 1;
grdViewF2.OptionsView.RowAutoHeight = true;
grdViewF2.OptionsView.ShowFooter = true;
grdViewF2.OptionsView.ColumnAutoWidth = false;
grdViewF2.FocusedRowHandle = 0;
grdViewF2.FocusedColumn = grdViewF2.VisibleColumns[0];
grdViewF2.OptionsCustomization.AllowColumnMoving = true;
grdViewF2.OptionsSelection.InvertSelection = true;
grdViewF2.OptionsSelection.EnableAppearanceHideSelection = false;
grdViewF2.Appearance.FocusedRow.BackColor = Color.Teal;
grdViewF2.Appearance.FocusedRow.ForeColor = Color.White;
grdViewF2.BestFitColumns();
BsfGlobal.RestoreLayout("Format2", grdViewF2);
m_bLayout = true;
}
private void PopulateCostSheet()
{
m_bLayout = false;
DataTable dt = new DataTable();
dt = FlatTypeBL.GetCostSheet(m_iCCId, m_bPayTypewise);
grdF1.DataSource = null;
grdViewF1.Columns.Clear();
grdF1.DataSource = dt;
grdF1.ForceInitialize();
grdViewF1.PopulateColumns();
grdViewF1.Columns["BlockName"].ColumnEdit = repositoryItemMemoEdit1;
grdViewF1.Columns["LevelName"].ColumnEdit = repositoryItemMemoEdit1;
grdViewF1.Columns["TypeName"].ColumnEdit = repositoryItemMemoEdit1;
grdViewF1.Columns["FlatNo"].ColumnEdit = repositoryItemMemoEdit1;
grdViewF1.Columns["Status"].ColumnEdit = repositoryItemMemoEdit1;
grdViewF1.Columns["Area"].ColumnEdit = repositoryItemMemoEdit1;
grdViewF1.Columns["FlatId"].Visible = false;
grdViewF1.Columns["FlatId"].OptionsColumn.ShowInCustomizationForm = false;
grdViewF1.Columns["Area"].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
grdViewF1.Columns["Area"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
grdViewF1.Columns["Area"].DisplayFormat.FormatString = BsfGlobal.g_sDigitFormat;
grdViewF1.Columns["Area"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
grdViewF1.Columns["Area"].SummaryItem.DisplayFormat = BsfGlobal.g_sDigitFormatS;
for (int i = 6; i < dt.Columns.Count; i++)
{
string sName = grdViewF1.Columns[i].FieldName;
grdViewF1.Columns[sName].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
grdViewF1.Columns[sName].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
grdViewF1.Columns[sName].DisplayFormat.FormatString = BsfGlobal.g_sDigitFormat;
grdViewF1.Columns[sName].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
grdViewF1.Columns[sName].SummaryItem.DisplayFormat = BsfGlobal.g_sDigitFormatS;
grdViewF1.Columns[sName].ColumnEdit = repositoryItemMemoEdit1;
if (Convert.ToDecimal(grdViewF1.Columns[sName].SummaryItem.SummaryValue) == 0)
{
grdViewF1.Columns[sName].Visible = false;
}
}
grdViewF1.Columns["Total"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
grdViewF1.Columns["Total"].DisplayFormat.FormatString = BsfGlobal.g_sDigitFormat;
grdViewF1.Columns["Total"].Caption = "Grand Total";
grdViewF1.Columns["FlatNo"].Caption = CommFun.m_sFuncName + " No";
grdViewF1.OptionsView.RowAutoHeight = true;
grdViewF1.OptionsView.ShowFooter = true;
grdViewF1.OptionsView.ColumnAutoWidth = false;
grdViewF1.FocusedRowHandle = 0;
grdViewF1.FocusedColumn = grdViewF1.VisibleColumns[0];
grdViewF1.OptionsCustomization.AllowColumnMoving = true;
grdViewF1.OptionsSelection.InvertSelection = true;
grdViewF1.OptionsSelection.EnableAppearanceHideSelection = false;
grdViewF1.Appearance.FocusedRow.BackColor = Color.Teal;
grdViewF1.Appearance.FocusedRow.ForeColor = Color.White;
grdViewF1.BestFitColumns();
BsfGlobal.RestoreLayout("Format1", grdViewF1);
m_bLayout = true;
}
