public IHttpActionResult PutProductGroup(int id, ProductGrp productGroup) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != productGroup.ID) { return(BadRequest()); } db.Entry(productGroup).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!ProductGroupExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public IHttpActionResult GetProductGroup(int id) { ProductGrp productGroup = db.ProductGrps.Find(id); if (productGroup == null) { return(NotFound()); } return(Ok(productGroup)); }
public IHttpActionResult PostProductGroup(ProductGrp productGroup) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.ProductGrps.Add(productGroup); db.SaveChanges(); return(CreatedAtRoute("DefaultApi", new { id = productGroup.ID }, productGroup)); }
public IHttpActionResult DeleteProductGroup(int id) { ProductGrp productGroup = db.ProductGrps.Find(id); if (productGroup == null) { return(NotFound()); } db.ProductGrps.Remove(productGroup); db.SaveChanges(); return(Ok(productGroup)); }
public ProductGrp GetCode(string sku) { ProductGrp model = new ProductGrp(); bool data = db.ProductGrps.Any(x => x.GroupName == sku && x.IsActive == true); if (data == true) { model = db.ProductGrps.Where(x => x.IsActive == true && x.GroupName == sku).FirstOrDefault(); } else { model.GroupName = sku; model.IsActive = true; model.CreatedOn = System.DateTime.UtcNow; model.UpdatedOn = System.DateTime.UtcNow; db.ProductGrps.Add(model); db.SaveChanges(); var list = db.ProductGrps.Where(x => x.IsActive == true).ToList(); model = list.LastOrDefault(); } return(model); }