public static InventoryTransactionModel CreateInventoryTransaction(InventoryTransactionModel invtm, out string error)
{
error = "";
LUSSISEntities entities = new LUSSISEntities();
inventorytransaction d = new inventorytransaction();
try
{
d.datetime = DateTime.Now;
d.invid = invtm.InvID;
d.itemid = invtm.ItemID;
d.trantype = invtm.TransType;
d.qty = invtm.Qty;
d.remark = invtm.Remark;
d = entities.inventorytransactions.Add(d);
entities.SaveChanges();
invtm = GetInventoryTransactionByTransID(d.tranid, out error);
}
catch (NullReferenceException)
{
error = ConError.Status.NOTFOUND;
}
catch (Exception e)
{
error = e.Message;
}
return(invtm);
}
public static InventoryTransactionModel GetInventoryTransactionByTransID(int transid, out string error)
{
LUSSISEntities entities = new LUSSISEntities();
error = "";
inventorytransaction invt = new inventorytransaction();
InventoryTransactionModel invtm = new InventoryTransactionModel();
try
{
invt = entities.inventorytransactions.Where(p => p.tranid == transid).FirstOrDefault <inventorytransaction>();
invtm = ConvertDBModeltoAPIModel(invt);
}
catch (NullReferenceException)
{
error = ConError.Status.NOTFOUND;
}
catch (Exception e)
{
error = e.Message;
}
return(invtm);
}
public static InventoryTransactionModel UpdateInventoryTransaction(InventoryTransactionModel invtm, out string error)
{
error = "";
// declare and initialize new LUSSISEntities to perform update
LUSSISEntities entities = new LUSSISEntities();
inventorytransaction d = new inventorytransaction();
try
{
// finding the inventorytransaction object using InventoryTransaction API model
d = entities.inventorytransactions.Where(p => p.tranid == invtm.TranID).First <inventorytransaction>();
// transfering data from API model to DB Model
d.datetime = DateTime.Now;
d.invid = invtm.InvID;
d.itemid = invtm.ItemID;
d.trantype = invtm.TransType;
d.qty = invtm.Qty;
d.remark = invtm.Remark;
// saving the update
entities.SaveChanges();
// return the updated model
invtm = GetInventoryTransactionByTransID(d.tranid, out error);
}
catch (NullReferenceException)
{
error = ConError.Status.NOTFOUND;
}
catch (Exception e)
{
error = e.Message;
}
return(invtm);
}
// Convert From Auto Generated DB Model to APIModel
private static InventoryTransactionModel ConvertDBModeltoAPIModel(inventorytransaction invt)
{
InventoryTransactionModel invtm = new InventoryTransactionModel(invt.tranid, invt.datetime, invt.invid, invt.itemid, invt.item.description, invt.item.uom, invt.item.category.name, invt.trantype, invt.qty, invt.remark);
return(invtm);
}
