public IHttpActionResult updateConversion([FromBody] conversionTable model) { try { if (!string.IsNullOrEmpty(model.id.ToString())) { var ctab = db.conversionTable.Find(model.id); ctab.base_unit_value = model.base_unit_value; ctab.master_unit = model.master_unit; db.SaveChanges(); return(Ok()); } return(BadRequest()); } catch (Exception ex) { return(Content(HttpStatusCode.BadRequest, ex.InnerException.ToString())); } }
public IHttpActionResult addCoversion([FromBody] conversionTable model) { var logInUserName = RequestContext.Principal.Identity.Name; try { var cTab = new conversionTable(); var p = db.product.Find(model.item_id); if (model != null) { cTab.item_id = model.item_id; cTab.item_name = p.product_name; cTab.master_unit = model.master_unit; cTab.master_unit_value = model.master_unit_value; cTab.base_unit = model.base_unit; cTab.base_unit_value = model.base_unit_value; //validate that a particular master unit for a single item is not duplicated. var ctb = db.conversionTable.Where(i => i.item_id == model.item_id); if (ctb.Count() > 0) { foreach (var m_unit in ctb) { if (m_unit.master_unit == model.master_unit) { return(Content(HttpStatusCode.BadRequest, "You cannot have duplicate of '" + model.master_unit + "' for '" + p.product_name + " in the conversion table, kindly, check the table to edit or delete previous conversion to '" + model.master_unit + "', incase you want to make changes.'")); } } } db.conversionTable.Add(cTab); db.SaveChanges(); ulog.loguserActivities(logInUserName, "Added new item conversion "); } return(Ok()); } catch (Exception ex) { return(Content(HttpStatusCode.BadRequest, ex.ToString())); } }