public HttpResponseMessage UpdateAdvt([FromBody] ActiveAdvtModel advtVM)
{
if (advtVM != null)
{
prodAdvtManager.updateAdvt(advtVM);
prodAdvtManager.updateAdvtPic(advtVM);
return(Request.CreateResponse(HttpStatusCode.OK, "Advertisement Saved Successfully"));
}
return(Request.CreateErrorResponse(HttpStatusCode.NotAcceptable, "invalid request"));
}
public void updateAdvtPic(ActiveAdvtModel advtVM)
{
ProfilePicModel photo = new ProfilePicModel()
{
Path = advtVM.ImagePath,
Id = advtVM.ID,
Action = "Update",
Type = "Advertisement"
};
vendorDao.Pic(photo);
}
public HttpResponseMessage GetAdvt(int advtId)
{
try
{
ActiveAdvtModel prodAdvt = prodAdvtManager.getProdAdvt(advtId);
prodAdvt.ImagePath = prodAdvtManager.getImagePath(advtId);
return(Request.CreateResponse(HttpStatusCode.OK, prodAdvt));
}
catch (Exception)
{
return(Request.CreateErrorResponse(HttpStatusCode.ExpectationFailed, "Exception Occoured in reading data."));
}
}
public void updateAdvt(ActiveAdvtModel advtVM)
{
using (Conn)
{
string query = @"UPDATE Prod_Advt
SET
PROD_TYPE_ID = @PROD_TYPE_ID
,DSCP = @DSCP
,UNIT_PRICE = @UNIT_PRICE
,MAX_ORDR_LIMT = @MAX_ORDR_LIMT
,DLVRY_AVLB = @DLVRY_AVLB
,STUS_NME = @STUS_NME
WHERE ID = @ID AND IsDeleted = 0 AND IsActive = 'True' ";
Conn.Execute(query, new { PROD_TYPE_ID = advtVM.PROD_TYPE_ID, DSCP = advtVM.DSCP, UNIT_PRICE = advtVM.UNIT_PRICE, MAX_ORDR_LIMT = advtVM.MAX_ORDR_LIMT, DLVRY_AVLB = advtVM.DLVRY_AVLB, STUS_NME = advtVM.STUS_NME, ID = advtVM.ID });
}
}
public void updateAdvt(ActiveAdvtModel advtVM)
{
prod_AdvtDao.updateAdvt(advtVM);
}
