private void PopulateAmenities()
{
dtAme = new DataTable();
dtAme = ProjectInfoDL.SelectAmenities(i_CostCentreId, m_sType);
grdAmenities.DataSource = dtAme;
grdAmenitiesView.PopulateColumns();
grdAmenitiesView.Columns["AmenityId"].Visible = false;
grdAmenitiesView.Columns["AmenityName"].OptionsColumn.AllowEdit = false;
grdAmenitiesView.Columns["Sel"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
ChkEditAmenities.CheckedChanged += (sender, e) =>
{
if (Convert.ToBoolean(ChkEditAmenities.Editable) == true)
{
ChkEditAmenities.ValueChecked = true;
}
};
grdAmenitiesView.Appearance.HeaderPanel.Font = new Font(grdAmenitiesView.Appearance.HeaderPanel.Font, FontStyle.Bold);
grdAmenitiesView.Appearance.FocusedCell.BackColor = Color.Teal;
grdAmenitiesView.Appearance.FocusedCell.ForeColor = Color.White;
grdAmenitiesView.Appearance.FocusedRow.ForeColor = Color.Teal;
grdAmenitiesView.Appearance.FocusedRow.BackColor = Color.White;
grdAmenitiesView.OptionsSelection.EnableAppearanceHideSelection = false;
}
private void PopulateCompetitor()
{
ProjectInfoBO CompBO = new ProjectInfoBO()
{
i_CostCentreId = i_CostCentreId
};
dtCom = new DataTable();
dtCom = ProjectInfoDL.SelectCompetitor(CompBO);
grdCompetitor.DataSource = dtCom;
grdCompetitorView.PopulateColumns();
grdCompetitorView.Columns["ProjectId"].Visible = false;
grdCompetitorView.Columns["CompetitorId"].Visible = false;
grdCompetitorView.Columns["CompetitorName"].Visible = false;
grdCompetitorView.Columns["ProjectName"].OptionsColumn.AllowEdit = false;
grdCompetitorView.Columns["Sel"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
ChkEditComp.CheckedChanged += (sender, e) =>
{
if (Convert.ToBoolean(ChkEditComp.Editable) == true)
{
ChkEditComp.ValueChecked = true;
}
};
grdCompetitorView.Appearance.HeaderPanel.Font = new Font(grdCompetitorView.Appearance.HeaderPanel.Font, FontStyle.Bold);
grdCompetitorView.Appearance.FocusedCell.BackColor = Color.Teal;
grdCompetitorView.Appearance.FocusedCell.ForeColor = Color.White;
grdCompetitorView.Appearance.FocusedRow.ForeColor = Color.Black;
grdCompetitorView.Appearance.FocusedRow.BackColor = Color.Teal;
grdCompetitorView.OptionsSelection.EnableAppearanceHideSelection = false;
}
private void btnDelete_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (grdAmenitiesMasterView.FocusedRowHandle < 0)
{
return;
}
if (BsfGlobal.FindPermission("Amenities Master-Delete") == false)
{
MessageBox.Show("You don't have Rights to Amenities Master-Delete");
return;
}
int iAId = Convert.ToInt32(CommFun.IsNullCheck(grdAmenitiesMasterView.GetRowCellValue(grdAmenitiesMasterView.FocusedRowHandle, "AmenityId").ToString(), CommFun.datatypes.vartypenumeric));
if (ProjectInfoDL.CheckAmenityUsed(iAId) == true)
{
MessageBox.Show("Amenity Used, Do not Delete");
return;
}
if (MessageBox.Show("Do You want to Delete Row?", "Question", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.Yes)
{
ProjectInfoDL.DeleteAmenitiesMaster(iAId);
grdAmenitiesMasterView.DeleteRow(grdAmenitiesMasterView.FocusedRowHandle);
}
}
private void PopulateServices()
{
DataTable dtSer = new DataTable();
dtSer = ProjectInfoDL.SelectServicesMaster();
grdServicesMaster.DataSource = dtSer;
grdServicesMasterView.PopulateColumns();
grdServicesMasterView.Columns["ServiceId"].Visible = false;
grdServicesMasterView.Appearance.HeaderPanel.Font = new Font(grdServicesMasterView.Appearance.HeaderPanel.Font, FontStyle.Bold);
grdServicesMasterView.Appearance.FocusedCell.BackColor = Color.Teal;
grdServicesMasterView.Appearance.FocusedCell.ForeColor = Color.White;
grdServicesMasterView.Appearance.FocusedRow.ForeColor = Color.Teal;
grdServicesMasterView.Appearance.FocusedRow.BackColor = Color.White;
grdServicesMasterView.OptionsSelection.EnableAppearanceHideSelection = false;
}
private void btnOK_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
grdAmenitiesView.FocusedRowHandle = grdAmenitiesView.FocusedRowHandle + 1;
DataTable dt = new DataTable();
DataTable dtM = new DataTable();
dtM = grdAmenities.DataSource as DataTable;
DataView dv = new DataView(dtM);
if (dtM != null)
{
dv.RowFilter = "Sel = " + true + "";
dt = dv.ToTable();
}
ProjectInfoDL.InsertAmenities(dt, i_CostCentreId, m_sType);
Close();
}
private void grdServicesMasterView_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
if (CommFun.IsNullCheck(grdServicesMasterView.GetRowCellValue(grdServicesMasterView.FocusedRowHandle, "ServiceName").ToString(), CommFun.datatypes.vartypestring).ToString().Trim() == "")
{
grdServicesMasterView.CancelUpdateCurrentRow();
return;
}
if (m_bAns == true)
{
return;
}
ProjectInfoBO ServicesBO = new ProjectInfoBO();
if (grdServicesMasterView.IsNewItemRow(grdServicesMasterView.FocusedRowHandle) == true)
{
if (BsfGlobal.FindPermission("NearByServices Master-Add") == false)
{
MessageBox.Show("You don't have Rights to NearByServices Master-Add");
return;
}
m_bAns = true;
string sNearName = grdServicesMasterView.GetRowCellValue(grdServicesMasterView.FocusedRowHandle, "ServiceName").ToString();
int iNId = ProjectInfoDL.InsertNBSMaster(sNearName);
grdServicesMasterView.SetRowCellValue(grdServicesMasterView.FocusedRowHandle, "ServiceId", iNId);
m_bAns = false;
}
else
{
if (BsfGlobal.FindPermission("NearByServices Master-Modify") == false)
{
MessageBox.Show("You don't have Rights to NearByServices Master-Modify");
return;
}
int iNId = Convert.ToInt32(grdServicesMasterView.GetRowCellValue(grdServicesMasterView.FocusedRowHandle, "ServiceId").ToString());
string sNearName = grdServicesMasterView.GetRowCellValue(grdServicesMasterView.FocusedRowHandle, "ServiceName").ToString();
ServicesBO.s_NBSName = grdServicesMasterView.GetRowCellValue(grdServicesMasterView.FocusedRowHandle, "ServiceName").ToString();
ProjectInfoDL.UpdateServicesMaster(iNId, sNearName);
}
}
private void PopulateAmenities()
{
ProjectInfoBO AmeBO = new ProjectInfoBO()
{
i_CostCentreId = i_CostCentreId
};
DataTable dtAme = new DataTable();
dtAme = ProjectInfoDL.SelectAmenitiesMaster();
grdAmenitiesMaster.DataSource = dtAme;
grdAmenitiesMasterView.PopulateColumns();
grdAmenitiesMasterView.Columns["AmenityId"].Visible = false;
grdAmenitiesMasterView.AddNewRow();
grdAmenitiesMasterView.Appearance.HeaderPanel.Font = new Font(grdAmenitiesMasterView.Appearance.HeaderPanel.Font, FontStyle.Bold);
grdAmenitiesMasterView.Appearance.FocusedCell.BackColor = Color.Teal;
grdAmenitiesMasterView.Appearance.FocusedCell.ForeColor = Color.White;
grdAmenitiesMasterView.Appearance.FocusedRow.ForeColor = Color.Teal;
grdAmenitiesMasterView.Appearance.FocusedRow.BackColor = Color.White;
grdAmenitiesMasterView.OptionsSelection.EnableAppearanceHideSelection = false;
}
private void btnDelete_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (BsfGlobal.FindPermission("NearByServices Master-Delete") == false)
{
MessageBox.Show("You don't have Rights to NearByServices Master-Delete");
return;
}
ProjectInfoBO ServiceBO = new ProjectInfoBO();
if (MessageBox.Show("Do You want to Delete Row?", "Question", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.No)
{
return;
}
else
{
if (grdServicesMasterView.FocusedRowHandle >= 0)
{
ServiceBO.s_NBSName = grdServicesMasterView.GetRowCellValue(grdServicesMasterView.FocusedRowHandle, "ServiceName").ToString();
ProjectInfoDL.DeleteNBSMaster(ServiceBO);
grdServicesMasterView.DeleteRow(grdServicesMasterView.FocusedRowHandle);
}
}
}
private void btnOk_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
grdCompetitorView.FocusedRowHandle = grdCompetitorView.FocusedRowHandle + 1;
DataTable dt = new DataTable();
DataTable dt_CompTrans = new DataTable();
DataView dv = null;
ProjectInfoBO CompBO = new ProjectInfoBO();
CompBO.i_CostCentreId = i_CostCentreId;
dt_CompTrans = ProjectInfoDL.SelectCompetitorTrans(CompBO);
for (int j = 0; j <= dt_CompTrans.Rows.Count - 1; j++)
{
ProjectInfoDL.DeleteCompetitor(CompBO);
}
if (Convert.ToBoolean(ChkEditComp.ValueChecked) == true)
{
dtCom.AcceptChanges();
dv = new DataView(dtCom)
{
RowFilter = "Sel='" + true + "'"
};
dt = dv.ToTable();
if (dt.Rows.Count > 0)
{
for (int i = 0; i <= dt.Rows.Count - 1; i++)
{
CompBO.i_CompProjectId = Convert.ToInt32(dt.Rows[i]["ProjectId"].ToString());
ProjectInfoDL.InsertCompetitor(CompBO);
}
}
}
Close();
}
internal static void UpdateServiceOC(DataTable argdt, string argType, int argCCId)
{
ProjectInfoDL.UpdateServiceOC(argdt, argType, argCCId);
}
internal static void UpdateOCType(DataTable argdt)
{
ProjectInfoDL.UpdateOCType(argdt);
}
public static DataTable SelectAmenitiesMaster()
{
return(ProjectInfoDL.SelectAmenitiesMaster());
}
public static DataTable SelectAmenitiesTrans(ProjectInfoBO AmenityBO)
{
return(ProjectInfoDL.SelectAmenitiesTrans(AmenityBO));
}
internal static DataTable GetServiceOtherCost()
{
return(ProjectInfoDL.GetServiceOtherCost());
}
public static DataTable PopulateProjInfo(ProjectInfoBO ProjInfoBO)
{
return(ProjectInfoDL.PopulateProjInfo(ProjInfoBO));
}
public static void UpdateOC(int argCCID, DataTable argdt)
{
ProjectInfoDL.UpdateOC(argCCID, argdt);
}
public static void InsertNBS(DataTable argdt, int argCCID, string argType)
{
ProjectInfoDL.InsertNBS(argdt, argCCID, argType);
}
public static DataTable SelectServicesMaster()
{
return(ProjectInfoDL.SelectServicesMaster());
}
public static void UpdateSortOrder(DataTable dt)
{
ProjectInfoDL.UpdateSortOrder(dt);
}
internal static void UpdatePenalty(int argCCId, string argBlkType, decimal argBlkAmt, string argBType, decimal argBAmt, string argFType, decimal argFAmt)
{
ProjectInfoDL.UpdatePenalty(argCCId, argBlkType, argBlkAmt, argBType, argBAmt, argFType, argFAmt);
}
internal static DataTable GetPenalty(int argCCId)
{
return(ProjectInfoDL.GetPenalty(argCCId));
}
internal static string UnitUsed(int argCCId)
{
return(ProjectInfoDL.UnitUsed(argCCId));
}
internal static DataTable GetExcludeOtherCost(int argCCId)
{
return(ProjectInfoDL.GetExcludeOtherCost(argCCId));
}
public static void DeleteNBS(ProjectInfoBO NBSBO)
{
ProjectInfoDL.DeleteNBS(NBSBO);
}
public static void UpdateProjInfo(ProjectInfoBO ProjInfoBO)
{
ProjectInfoDL.UpdateProjInfo(ProjInfoBO);
}
public static DataTable SelectAmenities(int argCCID, string argType)
{
return(ProjectInfoDL.SelectAmenities(argCCID, argType));
}
public static DataTable SelectServicesTrans(ProjectInfoBO NBSBO)
{
return(ProjectInfoDL.SelectServicesTrans(NBSBO));
}
internal static bool CheckUsedInFlatsPayment(int argCCId, int argOCId)
{
return(ProjectInfoDL.CheckUsedInFlatsPayment(argCCId, argOCId));
}
public static void InsertNBSMaster(string argName)
{
ProjectInfoDL.InsertNBSMaster(argName);
}
internal static DataTable GetOCTypeMaster()
{
return(ProjectInfoDL.GetOCTypeMaster());
}
