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