public static void UpdateAdvertGSEQtys(AdvertGSE objAdvertGSE)
{
//Accessing DB Layer
DbCommand dbCommand = db.GetStoredProcCommand("prUpdAdvertGSEQtys");
//Adding Input parameters
db.AddInParameter(dbCommand, "AdvertId", DbType.Int32, objAdvertGSE.AdvertId);
db.AddInParameter(dbCommand, "QtyId1", DbType.String, objAdvertGSE.QtyId1);
db.AddInParameter(dbCommand, "MetricValue1", DbType.Single, objAdvertGSE.QtyValue1);
db.AddInParameter(dbCommand, "QtyId2", DbType.String, objAdvertGSE.QtyId2);
db.AddInParameter(dbCommand, "MetricValue2", DbType.Single, objAdvertGSE.QtyValue2);
//Adding Output parameters
db.AddOutParameter(dbCommand, "RespCode", DbType.Int32, 100);
db.AddOutParameter(dbCommand, "RespMsg", DbType.String, 500);
try
{
// Execute
db.ExecuteNonQuery(dbCommand);
//Set Output for AddAdvertImage
objAdvertGSE.RespCode = Convert.ToInt32(db.GetParameterValue(dbCommand, "RespCode"));
objAdvertGSE.RespDesc = db.GetParameterValue(dbCommand, "RespMsg").ToString();
}
catch (Exception ex)
{
objAdvertGSE.RespCode = 1;
objAdvertGSE.RespDesc = ex.ToString();
}
return;
}
public static AdvertGSE UpdateAdvertGSE(AdvertGSE objAdvertGSE)
{
//Accessing DB Layer
DbCommand dbCommand = db.GetStoredProcCommand("prUpdAdvertGSE");
//Adding Input parameters
db.AddInParameter(dbCommand, "AdvertId", DbType.Int32, objAdvertGSE.AdvertId);
db.AddInParameter(dbCommand, "Manufacturer", DbType.String, objAdvertGSE.Manufacturer);
db.AddInParameter(dbCommand, "DateofRegistration", DbType.DateTime, objAdvertGSE.DateofRegistration);
db.AddInParameter(dbCommand, "Year", DbType.String, objAdvertGSE.Year);
db.AddInParameter(dbCommand, "GSETypeId", DbType.Int32, objAdvertGSE.GSETypeId);
db.AddInParameter(dbCommand, "AdvertAvailabilityId", DbType.String, objAdvertGSE.AvailabilityId);
db.AddInParameter(dbCommand, "ForSaleYN", DbType.Boolean, objAdvertGSE.ForSaleYN);
db.AddInParameter(dbCommand, "ForRentYN", DbType.Boolean, objAdvertGSE.ForRentYN);
db.AddInParameter(dbCommand, "ForLeaseYN", DbType.Boolean, objAdvertGSE.ForLeaseYN);
//Adding Output parameters
db.AddOutParameter(dbCommand, "RespCode", DbType.Int32, 100);
db.AddOutParameter(dbCommand, "RespMsg", DbType.String, 500);
try
{
// Execute
db.ExecuteNonQuery(dbCommand);
//Set Output for AddAdvertImage
objAdvertGSE.RespCode = Convert.ToInt32(db.GetParameterValue(dbCommand, "RespCode"));
objAdvertGSE.RespDesc = db.GetParameterValue(dbCommand, "RespMsg").ToString();
// Now Update the Specifications
UpdateAdvertGSESpecifications(objAdvertGSE);
// Now Update the Qtys
UpdateAdvertGSEQtys(objAdvertGSE);
}
catch (Exception ex)
{
objAdvertGSE.RespCode = 1;
objAdvertGSE.RespDesc = ex.ToString();
}
return(objAdvertGSE);
}
