public IHttpActionResult GettblShopImage(int id) { try { var data = db.tblShopImages.Where(w => w.ID == id).FirstOrDefault(); if (data == null) { return(Ok(new { code = 1, data = "Not found" })); } else { tblShopImage model = new tblShopImage(); model.ID = data.ID; model.ImageName = data.ImageName; model.ImagePath = data.ImagePath; model.ShopID = data.ShopID; model.Created = System.DateTime.Now; model.CreatedBy = data.CreatedBy; model.Updated = System.DateTime.Now; model.UpdatedBy = data.UpdatedBy; model.Active = Convert.ToBoolean(data.Active); return(Ok(new { code = 0, data = model })); } } catch (Exception ex) { return(InternalServerError(ex)); } }
public IHttpActionResult PosttblShopImage(tblShopImage tblShopImage) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.tblShopImages.Add(tblShopImage); db.SaveChanges(); return(Ok(new { code = 0, data = "Shop Image added successfully." })); }
public IHttpActionResult DeletetblShopImage(int id) { tblShopImage tblShopImage = db.tblShopImages.Find(id); if (tblShopImage == null) { return(NotFound()); } db.tblShopImages.Remove(tblShopImage); db.SaveChanges(); return(Ok(new { code = 0, message = "Record deleted successfully" })); }
public IHttpActionResult PuttblShopImage(tblShopImage tblShopImage) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } var data = db.tblShopImages.Where(w => w.ID == tblShopImage.ID).Count();//.FirstOrDefault(); if (data >= 0) { tblShopImage ShopImage = new tblShopImage(); ShopImage.ID = tblShopImage.ID; ShopImage.ShopID = tblShopImage.ShopID; ShopImage.ImageName = tblShopImage.ImageName; ShopImage.ImagePath = tblShopImage.ImagePath; ShopImage.Created = System.DateTime.Now; ShopImage.CreatedBy = tblShopImage.CreatedBy; ShopImage.Updated = System.DateTime.Now; ShopImage.UpdatedBy = tblShopImage.UpdatedBy; ShopImage.Active = Convert.ToBoolean(tblShopImage.Active); db.Entry(ShopImage).State = EntityState.Modified; try { db.SaveChanges(); } catch (OptimisticConcurrencyException) { db.SaveChanges(); } return(Ok(new { code = 0, data = "Shop Image updated successfully." })); } else { return(Ok(new { code = 1, data = "Shop Image not found." })); } }