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