public HttpResponseMessage get_Product_unit()
{
try
{
XpoTypesInfoHelper.GetXpoTypeInfoSource();
XafTypesInfo.Instance.RegisterEntity(typeof(nutrition.Module.Unit));
List <Unit_Model> list = new List <Unit_Model>();
XPObjectSpaceProvider directProvider = new XPObjectSpaceProvider(scc, null);
IObjectSpace ObjectSpace = directProvider.CreateObjectSpace();
IList <Unit> collection = ObjectSpace.GetObjects <Unit>(CriteriaOperator.Parse(" GCRecord is null and IsActive = 1 ", null));
foreach (Unit row in collection)
{
Unit_Model model = new Unit_Model();
model.UnitOid = row.Oid.ToString();
model.UnitCode = row.UnitCode;
model.UnitName = row.UnitName;
model.IsActive = row.IsActive;
list.Add(model);
}
return(Request.CreateResponse(HttpStatusCode.OK, list));
}
catch (Exception ex)
{ //Error case เกิดข้อผิดพลาด
UserError err = new UserError();
err.code = "6"; // error จากสาเหตุอื่นๆ จะมีรายละเอียดจาก system แจ้งกลับ
err.message = ex.Message;
// Return resual
return(Request.CreateResponse(HttpStatusCode.BadRequest, err));
}
}
public ActionResult UnitDelete(Unit_Model unit_Model)
{
var Unit_Name = unit_Model.UnitName;
try
{
if (unit_.Delete(unit_Model.UnitId))
{
return(Json(Unit_Name + " unit has been deleted successfully"));
}
else
{
return(Json("Error"));
}
}
catch (Exception e)
{
return(Json("Error" + e.ToString()));
}
}
public ActionResult UnitAdd(Unit_Model unit_Model)
{
if (string.IsNullOrEmpty(unit_Model.UnitName) || string.IsNullOrEmpty(unit_Model.UnitAbb))
{
ViewBag.AddUnitError = "Error";
return(View("Unit"));
}
else
{
if (unit_.Save(unit_Model))
{
Session["Success"] = unit_Model.UnitName + " added successfully!!";
}
else
{
Session["Error"] = unit_Model.UnitName + " couldn't be added please retry!!";
}
return(RedirectToAction("Unit"));
}
}
public bool UpdateUnit(Unit_Model unit_Model)
{
using (var _context = new SalesTrackingSystemEntities())
{
try
{
var data = _context.Units.Where(unit => unit.UnitId == unit_Model.UnitId).FirstOrDefault();
data.UnitId = unit_Model.UnitId;
data.UnitName = unit_Model.UnitName;
data.UnitAbb = unit_Model.UnitAbb;
data.Description = unit_Model.Description;
data.DateUpdated = DateTime.Now;
_context.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
}
public ActionResult UnitUpdate(Unit_Model unit_Model)
{
if (string.IsNullOrEmpty(unit_Model.UnitName) || string.IsNullOrEmpty(unit_Model.UnitAbb))
{
ViewBag.UpdateUnitError = "Error";
ViewBag.UpdateUnitData = unit_Model.UnitId;
return(View("Unit"));
}
else
{
if (unit_.UpdateUnit(unit_Model))
{
Session["Success"] = unit_Model.UnitName + " updated successfully!!";
return(RedirectToAction("Unit"));
}
else
{
Session["Error"] = unit_Model.UnitName + " couldn't be updated please retry!!";
return(View("Unit"));
}
}
}
public bool Save(Unit_Model unit_Model)
{
using (var _context = new SalesTrackingSystemEntities())
{
try
{
var data = new Unit()
{
UnitId = GetNewUnitID(),
UnitAbb = unit_Model.UnitAbb,
UnitName = unit_Model.UnitName,
Description = unit_Model.Description,
DateCreated = DateTime.Now
};
_context.Units.Add(data);
_context.SaveChanges();
return(true);
}
catch (Exception)
{
throw;
}
}
}
