public IHttpActionResult PuttblShopProduct(tblShopProduct tblShopProduct) { if (!ModelState.IsValid) { return BadRequest(ModelState); } var data = db.tblShops.Where(w => w.ID == tblShopProduct.ID).Count(); if (data >= 0) { tblShopProduct ShopProduct = new tblShopProduct(); ShopProduct.ID = tblShopProduct.ID; ShopProduct.ShopID = tblShopProduct.ShopID; ShopProduct.Name = tblShopProduct.Name; ShopProduct.Description = tblShopProduct.Description; ShopProduct.Discount = tblShopProduct.Discount; ShopProduct.Price = tblShopProduct.Price; ShopProduct.IsDisplayOnHomePage = tblShopProduct.IsDisplayOnHomePage; ShopProduct.DisplayOrder = tblShopProduct.DisplayOrder; ShopProduct.Created = System.DateTime.Now; ShopProduct.CreatedBy = tblShopProduct.CreatedBy; ShopProduct.Updated = System.DateTime.Now; ShopProduct.UpdatedBy = tblShopProduct.UpdatedBy; ShopProduct.Active = Convert.ToBoolean(tblShopProduct.Active); db.Entry(ShopProduct).State = EntityState.Modified; db.SaveChanges(); return Ok(new { code = 0, data = "Shop Product updated successfully.", id = tblShopProduct.ID }); } else { return Ok(new { code = 1, data = "Shop Product not found." }); } }
public IHttpActionResult PosttblShopProduct(tblShopProduct tblShopProduct) { if (!ModelState.IsValid) { return BadRequest(ModelState); } db.tblShopProducts.Add(tblShopProduct); db.SaveChanges(); return Ok(new { code = 0, data = "Shop Product added successfully.", id = tblShopProduct.ID }); }
public IHttpActionResult DeletetblShopProduct(int id) { tblShopProduct tblShopProduct = db.tblShopProducts.Find(id); if (tblShopProduct == null) { return Ok(new { code = 2, data = "Shop Product not found" }); } db.tblShopProducts.Remove(tblShopProduct); db.SaveChanges(); return Ok(new { code = 0, message = "Record deleted successfully" }); }
public IHttpActionResult GettblShopProduct(int id) { try { //tblShopProduct tblShopProduct = db.tblShopProducts.Find(id); //if (tblShopProduct == null) //{ // return NotFound(); //} //return Ok(tblShopProduct); var data = db.tblShopProducts.Where(w => w.ID == id).FirstOrDefault(); if (data == null) { return Ok(new { code = 1, data = "Not found" }); } else { tblShopProduct model = new tblShopProduct(); model.ID = data.ID; model.ShopID = data.ShopID; model.Name = data.Name; model.Description = data.Description; model.Discount = data.Discount; model.Price = data.Price; 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); } }