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 PopulateServices()
{
ProjectInfoBO NBSBO = new ProjectInfoBO()
{
i_CostCentreId = i_CostCentreId
};
dtSer = new DataTable();
dtSer = ProjectInfoDL.SelectServices(i_CostCentreId, m_sType);
grdServices.DataSource = dtSer;
grdServicesView.PopulateColumns();
grdServicesView.Columns["ServiceId"].Visible = false;
grdServicesView.Columns["ServiceName"].OptionsColumn.AllowEdit = false;
grdServicesView.Columns["Sel"].Caption = "Select";
grdServicesView.Columns["ServiceDistance"].Caption = "Distance";
grdServicesView.Columns["Sel"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
ChkEditServices.CheckedChanged += (sender, e) =>
{
if (Convert.ToBoolean(ChkEditServices.Editable) == true)
{
ChkEditServices.ValueChecked = true;
}
};
grdServicesView.Appearance.HeaderPanel.Font = new Font(grdServicesView.Appearance.HeaderPanel.Font, FontStyle.Bold);
grdServicesView.Appearance.FocusedCell.BackColor = Color.Teal;
grdServicesView.Appearance.FocusedCell.ForeColor = Color.White;
grdServicesView.Appearance.FocusedRow.ForeColor = Color.Teal;
grdServicesView.Appearance.FocusedRow.BackColor = Color.White;
grdServicesView.OptionsSelection.EnableAppearanceHideSelection = false;
}
internal static DataTable SelectCompetitor(ProjectInfoBO CompBO)
{
BsfGlobal.OpenCRMDB();
string ssql = "";
DataTable dtComp = null;
SqlDataAdapter sda;
try
{
ssql = " Select A.ProjectId,A.CompetitorId,C.CompetitorName,A.ProjectName,Case When B.ProjectId IS NULL " +
" then Convert(bit, 0, 0) else CONVERT(bit, 1, 1) End as Sel from dbo.CompetitiveProjects A " +
" LEFT JOIN dbo.CompetitorMaster C ON A.CompetitorId=C.CompetitorId " +
" Left Join dbo.CCCompetitorTrans B ON A.ProjectId=B.ProjectId AND B.CostCentreId=" + CompBO.i_CostCentreId + "";
sda = new SqlDataAdapter(ssql, BsfGlobal.g_CRMDB);
dtComp = new DataTable();
sda.Fill(dtComp);
}
catch (Exception ex)
{
BsfGlobal.CustomException(ex.Message, ex.StackTrace);
}
finally
{
BsfGlobal.g_CRMDB.Close();
}
return(dtComp);
}
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);
}
}
internal static void InsertProjInfo(ProjectInfoBO ProjInfoBO)
{
BsfGlobal.OpenCRMDB();
string ssql = "";
SqlCommand scmd = null;
try
{
ssql = String.Format("Insert into ProjectInfo(CostCentreId, TotalFlats, TotalBlocks, TotalArea, FSIIndex, Rate, NoOfFloors, GuideLineValue) Values({0} , {1}, {2}, '{3}', {4}, {5}, {6}, {7})", ProjInfoBO.i_CostCentreId, ProjInfoBO.i_TotalFlats, ProjInfoBO.i_TotalBlocks, ProjInfoBO.s_TotalArea, ProjInfoBO.d_FSIIndex, ProjInfoBO.d_Rate, ProjInfoBO.i_NoOfFloors, ProjInfoBO.d_GuideLineValue);
scmd = new SqlCommand(ssql, BsfGlobal.g_CRMDB);
scmd.ExecuteNonQuery();
scmd.Dispose();
}
catch (Exception ex)
{
BsfGlobal.CustomException(ex.Message, ex.StackTrace);
}
finally
{
BsfGlobal.g_CRMDB.Close();
}
}
internal static void DeleteNBSMaster(ProjectInfoBO NBSBO)
{
BsfGlobal.OpenCRMDB();
string ssql = "";
SqlCommand scmd = null;
try
{
ssql = String.Format("Delete NearByServicemaster Where ServiceName='{0}'", NBSBO.s_NBSName);
scmd = new SqlCommand(ssql, BsfGlobal.g_CRMDB);
scmd.ExecuteNonQuery();
scmd.Dispose();
}
catch (Exception ex)
{
BsfGlobal.CustomException(ex.Message, ex.StackTrace);
}
finally
{
BsfGlobal.g_CRMDB.Close();
}
}
internal static void InsertCompetitor(ProjectInfoBO CompBO)
{
BsfGlobal.OpenCRMDB();
string ssql = "";
SqlCommand scmd = null;
try
{
ssql = String.Format("Insert Into dbo.CCCompetitorTrans(CostCentreId, ProjectId) Values({0}, {1})", CompBO.i_CostCentreId, CompBO.i_CompProjectId);
scmd = new SqlCommand(ssql, BsfGlobal.g_CRMDB);
scmd.ExecuteNonQuery();
scmd.Dispose();
}
catch (Exception ex)
{
BsfGlobal.CustomException(ex.Message, ex.StackTrace);
}
finally
{
BsfGlobal.g_CRMDB.Close();
}
}
internal static void DeleteCompetitor(ProjectInfoBO CompBO)
{
BsfGlobal.OpenCRMDB();
string ssql = "";
SqlCommand scmd = null;
try
{
ssql = String.Format("Delete CCCompetitorTrans Where CostCentreId={0}", CompBO.i_CostCentreId);
scmd = new SqlCommand(ssql, BsfGlobal.g_CRMDB);
scmd.ExecuteNonQuery();
scmd.Dispose();
}
catch (Exception ex)
{
BsfGlobal.CustomException(ex.Message, ex.StackTrace);
}
finally
{
BsfGlobal.g_CRMDB.Close();
}
}
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;
}
internal static DataTable PopulateProjInfo(ProjectInfoBO ProjInfoBO)
{
BsfGlobal.OpenCRMDB();
DataTable dtProjInfo = null;
try
{
string ssql = String.Format("Select * from ProjectInfo Where CostCentreId={0}", ProjInfoBO.i_CostCentreId);
SqlDataAdapter sda = new SqlDataAdapter(ssql, BsfGlobal.g_CRMDB);
dtProjInfo = new DataTable();
sda.Fill(dtProjInfo);
sda.Dispose();
}
catch (Exception ex)
{
BsfGlobal.CustomException(ex.Message, ex.StackTrace);
}
finally
{
BsfGlobal.g_CRMDB.Close();
}
return(dtProjInfo);
}
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 DataTable SelectCompetitorTrans(ProjectInfoBO CompBO)
{
BsfGlobal.OpenCRMDB();
string ssql = "";
DataTable dtCompTrans = null;
SqlDataAdapter sda;
try
{
ssql = String.Format("Select * from CCCompetitorTrans Where CostCentreId={0}", CompBO.i_CostCentreId);
sda = new SqlDataAdapter(ssql, BsfGlobal.g_CRMDB);
dtCompTrans = new DataTable();
sda.Fill(dtCompTrans);
}
catch (Exception ex)
{
BsfGlobal.CustomException(ex.Message, ex.StackTrace);
}
finally
{
BsfGlobal.g_CRMDB.Close();
}
return(dtCompTrans);
}
public static void DeleteAmenities(ProjectInfoBO AmenityBO)
{
ProjectInfoDL.DeleteAmenities(AmenityBO);
}
public static void InsertCompetitor(ProjectInfoBO CompBO)
{
ProjectInfoDL.InsertCompetitor(CompBO);
}
public static void InsertProjInfo(ProjectInfoBO ProjInfoBO)
{
ProjectInfoDL.InsertProjInfo(ProjInfoBO);
}
internal static void UpdateProjInfo(ProjectInfoBO argObj)
{
BsfGlobal.OpenCRMDB();
string ssql = "";
SqlCommand cmd;
int i = 0;
try
{
ssql = "Update ProjectInfo Set TotalFlats= " + argObj.i_TotalFlats + ",TotalBlocks = " + argObj.i_TotalBlocks + ", " +
"TotalArea = '" + argObj.s_TotalArea + "',FSIIndex = " + argObj.d_FSIIndex + ",Rate = " + argObj.d_Rate + "," +
"NoOfFloors = " + argObj.i_NoOfFloors + ",GuideLineValue = " + argObj.d_GuideLineValue + "," +
"LandCost=" + argObj.d_LandRate + ", LandArea=" + argObj.d_LandArea + ",BuildArea=" + argObj.d_BuildArea + ", " +
" NetLandArea=" + argObj.d_NetLandArea + ",WithHeld=" + argObj.d_WithHeld + ", " +
" LCBasedon='" + argObj.b_LCB + "',ProjectwiseUDS='" + argObj.b_UDS + "', " +
" StartDate=@StartDate," +
" EndDate=@EndDate," +
"Registration = " + argObj.d_RegValue + ", InterestBasedOn='" + argObj.c_InterestBasedOn + "' " +
"Where CostCentreId = " + argObj.i_CostCentreId;
cmd = new SqlCommand(ssql, BsfGlobal.g_CRMDB);
SqlParameter parameterDate = new SqlParameter()
{
DbType = DbType.DateTime, ParameterName = "@StartDate"
};
if (Convert.ToDateTime(CommFun.IsNullCheck(argObj.dt_StartDate, CommFun.datatypes.VarTypeDate)) == DateTime.MinValue)
{
parameterDate.Value = System.Data.SqlTypes.SqlDateTime.Null;
}
else
{
parameterDate.Value = argObj.dt_StartDate;
}
cmd.Parameters.Add(parameterDate);
parameterDate = new SqlParameter()
{
DbType = DbType.DateTime, ParameterName = "@EndDate"
};
if (Convert.ToDateTime(CommFun.IsNullCheck(argObj.dt_EndDate, CommFun.datatypes.VarTypeDate)) == DateTime.MinValue)
{
parameterDate.Value = System.Data.SqlTypes.SqlDateTime.Null;
}
else
{
parameterDate.Value = argObj.dt_EndDate;
}
cmd.Parameters.Add(parameterDate);
i = cmd.ExecuteNonQuery();
cmd.Dispose();
if (i == 0)
{
ssql = "Insert into ProjectInfo(CostCentreId,TotalFlats,TotalBlocks,TotalArea,FSIIndex,Rate,NoOfFloors,GuideLineValue,LandCost,LandArea," +
" LCBasedon,ProjectwiseUDS,BuildArea,NetLandArea,WithHeld,StartDate,EndDate,Registration,CancelPenalty,InterestBasedOn) " +
"Values( " + argObj.i_CostCentreId + "," + argObj.i_TotalFlats + "," + argObj.i_TotalBlocks + ",'" + argObj.s_TotalArea + "'," +
"" + argObj.d_FSIIndex + "," + argObj.d_Rate + "," + argObj.i_NoOfFloors + "," + argObj.d_GuideLineValue + "," +
"" + argObj.d_LandRate + "," + argObj.d_LandArea + ",'" + argObj.b_LCB + "','" + argObj.b_UDS + "'," + argObj.d_BuildArea + ", " +
" " + argObj.d_NetLandArea + "," + argObj.d_WithHeld + ",@StartDate,@EndDate, " +
"" + argObj.d_RegValue + "," + argObj.d_CancelPenalty + ", '" + argObj.c_InterestBasedOn + "')";
cmd = new SqlCommand(ssql, BsfGlobal.g_CRMDB);
parameterDate = new SqlParameter()
{
DbType = DbType.DateTime, ParameterName = "@StartDate"
};
if (Convert.ToDateTime(CommFun.IsNullCheck(argObj.dt_StartDate, CommFun.datatypes.VarTypeDate)) == DateTime.MinValue)
{
parameterDate.Value = System.Data.SqlTypes.SqlDateTime.Null;
}
else
{
parameterDate.Value = argObj.dt_StartDate;
}
cmd.Parameters.Add(parameterDate);
parameterDate = new SqlParameter()
{
DbType = DbType.DateTime, ParameterName = "@EndDate"
};
if (Convert.ToDateTime(CommFun.IsNullCheck(argObj.dt_EndDate, CommFun.datatypes.VarTypeDate)) == DateTime.MinValue)
{
parameterDate.Value = System.Data.SqlTypes.SqlDateTime.Null;
}
else
{
parameterDate.Value = argObj.dt_EndDate;
}
cmd.Parameters.Add(parameterDate);
cmd.ExecuteNonQuery();
cmd.Dispose();
}
}
catch (Exception ex)
{
BsfGlobal.CustomException(ex.Message, ex.StackTrace);
}
finally
{
BsfGlobal.g_CRMDB.Close();
}
}
public static void DeleteCompetitor(ProjectInfoBO CompBO)
{
ProjectInfoDL.DeleteCompetitor(CompBO);
}
public static void UpdateProjInfo(ProjectInfoBO ProjInfoBO)
{
ProjectInfoDL.UpdateProjInfo(ProjInfoBO);
}
public static DataTable PopulateProjInfo(ProjectInfoBO ProjInfoBO)
{
return(ProjectInfoDL.PopulateProjInfo(ProjInfoBO));
}
public static DataTable SelectServicesTrans(ProjectInfoBO NBSBO)
{
return(ProjectInfoDL.SelectServicesTrans(NBSBO));
}
public static void DeleteNBS(ProjectInfoBO NBSBO)
{
ProjectInfoDL.DeleteNBS(NBSBO);
}
public static DataTable SelectAmenitiesTrans(ProjectInfoBO AmenityBO)
{
return(ProjectInfoDL.SelectAmenitiesTrans(AmenityBO));
}
public static DataTable SelectCompetitorTrans(ProjectInfoBO CompBO)
{
return(ProjectInfoDL.SelectCompetitorTrans(CompBO));
}
