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