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