public static ItemModel GetItemsByDisid(int disid, out string error)
{
LUSSISEntities entities = new LUSSISEntities();
error = "";
item item = new item();
disbursementdetail disdet = new disbursementdetail();
ItemModel im = new ItemModel();
try
{
disdet = entities.disbursementdetails.Where(p => p.disid == disid).FirstOrDefault <disbursementdetail>();
item = disdet.item;
im = CovertDBItemtoAPIItem(item);
}
catch (NullReferenceException)
{
error = ConError.Status.NOTFOUND;
}
catch (Exception e)
{
error = e.Message;
}
return(im);
}
public static List <DisbursementDetailsModel> UpdateDisbursementDetails(DisbursementDetailsModel dism, out string error)
{
error = "";
// declare and initialize new LUSSISEntities to perform update
LUSSISEntities entities = new LUSSISEntities();
disbursementdetail ndism = new disbursementdetail();
try
{
// finding the inventory object using Inventory API model
ndism = entities.disbursementdetails.Where(p => p.disid == dism.Disid && p.itemid == dism.Itemid).First <disbursementdetail>();
// transfering data from API model to DB Model
ndism.disid = dism.Disid;
ndism.itemid = dism.Itemid;
ndism.qty = dism.Qty;
// saving the update
entities.SaveChanges();
// return the updated model
}
catch (NullReferenceException)
{
error = ConError.Status.NOTFOUND;
}
catch (Exception e)
{
error = e.Message;
}
// return the updated model
return(GetDisbursementDetailsByDisbursementId(ndism.disid, out error));
}
public static DisbursementDetailsModel CreateDisbursementDetails(DisbursementDetailsModel disdm, out string error)
{
error = "";
LUSSISEntities entities = new LUSSISEntities();
disbursementdetail disdb = new disbursementdetail();
DisbursementDetailsModel ddm = new DisbursementDetailsModel();
try
{
disdb.disid = disdm.Disid;
disdb.itemid = disdm.Itemid;
disdb.qty = disdm.Qty;
disdb = entities.disbursementdetails.Add(disdb);
entities.SaveChanges();
ddm = new DisbursementDetailsModel(disdb.disid, disdb.itemid, disdb.item.description, disdb.qty, disdb.item.category.name, disdb.item.uom);
}
catch (NullReferenceException)
{
error = ConError.Status.NOTFOUND;
}
catch (Exception e)
{
error = e.Message;
}
return(ddm);
}
//Create new Disbursement with Detials
public static DisbursementModel CreateDisbursementwithDetails(DisbursementModel disb, List <DisbursementDetailsModel> disdm, out string error)
{
// initialize the error variable to return only blank if there is no error
error = "";
//initialize the entities , dibursement and disbursement list
LUSSISEntities entities = new LUSSISEntities();
disbursement dis = new disbursement();
List <disbursementdetail> dbdlist = new List <disbursementdetail>();
try
{
// add the data to the disbursement
dis.reqid = disb.Reqid;
dis.ackby = disb.Ackby;
dis = entities.disbursements.Add(dis);
entities.SaveChanges();
// add the arrary data to the disbursement details list
foreach (DisbursementDetailsModel dbdm in disdm)
{
disbursementdetail dbm = new disbursementdetail
{
disid = dis.disid,
itemid = dbdm.Itemid,
qty = dbdm.Qty
};
dbm = entities.disbursementdetails.Add(dbm);
entities.SaveChanges();
dbdlist.Add(dbm);
}
//get the added disbursement
disb = GetDisbursementByDisbursementId(dis.disid, out error);
}
catch (NullReferenceException)
{
error = ConError.Status.NOTFOUND;
}
catch (Exception e)
{
error = e.Message;
}
return(disb);
}
private static DisbursementDetailsModel CovertDBDisbursementDetailsstoAPIDisbursementDetails(disbursementdetail disbm)
{
DisbursementDetailsModel dism = new DisbursementDetailsModel(disbm.disid, disbm.itemid, disbm.item.description, disbm.qty, disbm.item.category.name, disbm.item.uom);
return(dism);
}
