internal int UpdateParameters(CompetitorBO competitorBO)
{
DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(competitorBO.ConString);
SqlCommand command = sqlHelper.CreateCommand(CommandType.StoredProcedure);
command.CommandText = "updateParameters";
sqlHelper.AddParameter(command, "@ShopId", competitorBO.ShopId, ParameterDirection.Input);
sqlHelper.AddParameter(command, "@UserId", competitorBO.UserId, ParameterDirection.Input);
sqlHelper.AddParameter(command, "@ProductID", competitorBO.ProductId, ParameterDirection.Input);
sqlHelper.AddParameter(command, "@ParameterList", competitorBO.ParameterList, ParameterDirection.Input);
sqlHelper.AddParameter(command, "@QuantityData", competitorBO.QuantityData, ParameterDirection.Input);
sqlHelper.AddParameter(command, "@latitude", competitorBO.Latitude, ParameterDirection.Input);
sqlHelper.AddParameter(command, "@longitude", competitorBO.Longitude, ParameterDirection.Input);
sqlHelper.AddParameter(command, "@processName", competitorBO.ProcessName, ParameterDirection.Input);
sqlHelper.AddParameter(command, "@mobileTransactionDate", competitorBO.MobileTransactionDate, ParameterDirection.Input);
sqlHelper.AddParameter(command, "@mobRefNo", competitorBO.MobRefNo, ParameterDirection.Input);
sqlHelper.AddParameter(command, "@GpsSource", competitorBO.GpsSource, ParameterDirection.Input);
if (competitorBO.MobileSyncDate != "" && competitorBO.ServerSyncDate != "")
{
sqlHelper.AddParameter(command, "@MobileSyncDate", competitorBO.MobileSyncDate, ParameterDirection.Input);
sqlHelper.AddParameter(command, "@ServerSyncDate", competitorBO.ServerSyncDate, ParameterDirection.Input);
}
if (competitorBO.signalStrength != null && competitorBO.signalStrength != string.Empty && competitorBO.signalStrength != "")
{
sqlHelper.AddParameter(command, "@signalStrength", competitorBO.signalStrength, ParameterDirection.Input);
}
if (competitorBO.networkProvider != null && competitorBO.networkProvider != string.Empty && competitorBO.networkProvider != "")
{
sqlHelper.AddParameter(command, "@networkProvider", competitorBO.networkProvider, ParameterDirection.Input);
}
return(Convert.ToInt32(sqlHelper.ExecuteNonQuery(command)));
}
public void UpdateCompetitor(CompetitorBO argObject, int argProjectId, DataTable argdtFT)
{
oCostCentreDL.UpdateCompetitor(argObject, argProjectId, argdtFT);
}
public int InsertCompetitor(CompetitorBO argObject, DataTable argdtFT)
{
return(oCostCentreDL.InsertCompetitor(argObject, argdtFT));
}
public void UpdateCompetitor(CompetitorBO argObject, int argProjectId, DataTable argdt)
{
SqlConnection conn = new SqlConnection();
SqlCommand cmd;
conn = BsfGlobal.OpenCRMDB();
using (SqlTransaction tran = conn.BeginTransaction())
{
string sSql = "";
try
{
sSql = "Update dbo.CompetitiveProjects set ProjectName= '" + argObject.ProjectName + "',CompetitorId=" + argObject.CompetitorId + ",TotalFlats=" + argObject.Com_TotalFlats + "," +
"TotalArea= " + argObject.Com_TotalArea + ",UnitId=" + argObject.Com_UnitId + ",Rate=" + argObject.Com_Rate +
", TotalBlocks=" + argObject.Com_TotalBlocks + ", FSIIndex=" + argObject.Com_FSIIndex + ", GuideLineValue=" +
argObject.Com_GLV + ", TotalFloors=" + argObject.Com_NoofFloors + ",LandArea = " + argObject.Com_LandArea + "," +
" BuildArea = " + argObject.Com_BuildArea + ",LocationId=" + argObject.Com_LocationId + ", " +
" ContactNo='" + argObject.Com_Contact + "',Website='" + argObject.Com_Website + "'," +
" Email='" + argObject.Com_Email + "',Address='" + argObject.Com_Address + "', " +
" LocationRate=" + argObject.Com_LoctionRate + ",CarParkCharges=" + argObject.Com_CarparkCharges + ", " +
" RegisterCharges=" + argObject.Com_RegisterCharges + ",DocumentCharges=" + argObject.Com_DocumentCharges + ", " +
" ClubCharges=" + argObject.Com_ClubCharges + ",InfraRate=" + argObject.Com_InfraRate + ", " +
" CMWSSBCharges=" + argObject.Com_CMWSSBCharges + ",OtherCharges=" + argObject.Com_OtherCharges + ", " +
" MaintenanceRate=" + argObject.Com_MaintenanceRate + ",CorpusFundCharges=" + argObject.Com_CorpusFundCharges + ", " +
" PipedGasCharges=" + argObject.Com_PipedGasCharges + ",CancellationCharges=" + argObject.Com_CancellationCharges + " " +
" Where ProjectId= " + argProjectId + "";
cmd = new SqlCommand(sSql, conn, tran);
cmd.ExecuteNonQuery();
cmd.Dispose();
sSql = "DELETE FROM dbo.CompetitiveTrans WHERE ProjectId=" + argProjectId;
cmd = new SqlCommand(sSql, conn, tran);
cmd.ExecuteNonQuery();
cmd.Dispose();
if (argdt != null)
{
if (argdt.Rows.Count > 0)
{
for (int a = 0; a < argdt.Rows.Count; a++)
{
sSql = "INSERT INTO dbo.CompetitiveTrans(ProjectId,FlatTypeId,MinArea,MaxArea) Values" +
" (" + argProjectId + "," + argdt.Rows[a]["FlatTypeId"] + "," +
" " + argdt.Rows[a]["MinArea"] + ", " + argdt.Rows[a]["MaxArea"] + ")";
cmd = new SqlCommand(sSql, conn, tran);
cmd.ExecuteNonQuery();
cmd.Dispose();
}
}
}
tran.Commit();
}
catch (Exception ex)
{
BsfGlobal.CustomException(ex.Message, ex.StackTrace);
}
finally
{
BsfGlobal.g_CRMDB.Close();
}
}
}
public int InsertCompetitor(CompetitorBO argObject, DataTable argdt)
{
SqlConnection conn = new SqlConnection();
SqlCommand cmd;
conn = BsfGlobal.OpenCRMDB();
using (SqlTransaction tran = conn.BeginTransaction())
{
int identity = 0;
string sSql = "";
try
{
sSql = "Insert into dbo.CompetitiveProjects (ProjectName,CompetitorId,TotalFlats, " +
"TotalArea,UnitId,Rate,TotalBlocks,LandArea,FSIIndex,BuildArea,GuideLineValue,TotalFloors,LocationId, " +
" ContactNo,Website,Email,Address,LocationRate,CarParkCharges,RegisterCharges,DocumentCharges,ClubCharges, " +
" InfraRate,CMWSSBCharges,OtherCharges,MaintenanceRate,CorpusFundCharges,PipedGasCharges,CancellationCharges) " +
"Values('" + argObject.ProjectName + "'," + argObject.CompetitorId + "," +
"" + argObject.Com_TotalFlats + ", " + argObject.Com_TotalArea + "," + argObject.Com_UnitId + "," +
"" + argObject.Com_Rate + "," + argObject.Com_TotalBlocks + "," + argObject.Com_LandArea + "," +
" " + argObject.Com_FSIIndex + "," + argObject.Com_BuildArea + "," + argObject.Com_GLV + "," +
" " + argObject.Com_NoofFloors + "," + argObject.Com_LocationId + ",'" + argObject.Com_Contact + "'," +
" '" + argObject.Com_Website + "','" + argObject.Com_Email + "','" + argObject.Com_Address + "', " +
" " + argObject.Com_LoctionRate + "," + argObject.Com_CarparkCharges + "," + argObject.Com_RegisterCharges + ", " +
" " + argObject.Com_DocumentCharges + "," + argObject.Com_ClubCharges + "," + argObject.Com_InfraRate + ", " +
" " + argObject.Com_CMWSSBCharges + "," + argObject.Com_OtherCharges + "," + argObject.Com_MaintenanceRate + ", " +
" " + argObject.Com_CorpusFundCharges + "," + argObject.Com_PipedGasCharges + "," + argObject.Com_CancellationCharges + " )" +
" SELECT SCOPE_IDENTITY();";
cmd = new SqlCommand(sSql, conn, tran);
identity = int.Parse(cmd.ExecuteScalar().ToString());
cmd.Dispose();
sSql = "DELETE FROM dbo.CompetitiveTrans WHERE ProjectId=" + identity;
cmd = new SqlCommand(sSql, conn, tran);
cmd.ExecuteNonQuery();
cmd.Dispose();
if (argdt.Rows.Count > 0)
{
for (int a = 0; a < argdt.Rows.Count; a++)
{
sSql = "INSERT INTO dbo.CompetitiveTrans(ProjectId,FlatTypeId,MinArea,MaxArea) Values" +
" (" + identity + "," + argdt.Rows[a]["FlatTypeId"] + "," +
" " + argdt.Rows[a]["MinArea"] + ", " + argdt.Rows[a]["MaxArea"] + ")";
cmd = new SqlCommand(sSql, conn, tran);
cmd.ExecuteNonQuery();
cmd.Dispose();
}
}
tran.Commit();
}
catch (Exception ex)
{
BsfGlobal.CustomException(ex.Message, ex.StackTrace);
}
finally
{
BsfGlobal.g_CRMDB.Close();
}
return(identity);
}
}
