/** update disbursement details **/ public void updateDisbursementDetails(int disbursementID, String itemCode, int requestedQty, int actualQty) { /** validate requested and actual quantity **/ if (vailidateActulaQty(requestedQty, actualQty)) { var q = from dd in context.StationeryDisbursementDetails where (dd.DisbursementID == disbursementID) && (dd.ItemCode.Equals(itemCode)) select dd; StationeryDisbursementDetail updateDisbursementDetails = (StationeryDisbursementDetail)q.FirstOrDefault(); updateDisbursementDetails.ActualQty = actualQty; try { context.SaveChanges(); } catch (Exception ex) { errorState = true; errorMsg = "Update failed"; throw new UpdateFailedException(errorMsg); } } else { errorState = true; errorMsg = "The actual quantity cannot be more than requested quantity"; throw new UpdateFailedException(errorMsg); } }
/** Update Disbursement List **/ public bool updateDisbursementList(String itemCode, int actualQty, int requiredQty, int disbursementID) { if (vailidateActulaQty(requiredQty, actualQty)) { var q = (from sd in context.StationeryDisbursementDetails where (sd.DisbursementID == disbursementID) && (sd.ItemCode.Equals(itemCode)) && (sd.DeletedFlag == false) select sd).FirstOrDefault(); if (q != null) { StationeryDisbursementDetail updateDisbursementDetail = (StationeryDisbursementDetail)q; updateDisbursementDetail.ActualQty = actualQty; try { context.SaveChanges(); } catch (Exception ex) { errorState = true; errorMsg = "Failed to update Disbursement List for the department"; throw new UpdateFailedException(errorMsg); } } } else { errorState = true; errorMsg = "The actual quantity cannot be greater than required quantity"; throw new UpdateFailedException(errorMsg); } return(errorState); }
/** generate Disbursement List **/ public bool getnerateAllDisbursementLists() { StationeryRetrieval sr = getStationeryRetrieval(); /** Get the list of Department wise stationery requests **/ var sdList = (from sd in context.StationeryRetrievalDepts where (sd.RetrievalID == sr.RetrievalID) && (sd.DeletedFlag == false) select sd).ToList(); try { /** Get list of unique department codes **/ List <String> dcs = sdList.Select(x => x.DeptCode).Distinct().ToList(); ArrayList deptCodeList = new ArrayList(dcs.ToArray()); foreach (String deptCode in deptCodeList) { /** Create Stationery Disbursement **/ createStationeryDisbursement(sr.RetrievalID, deptCode); /** Retreive latest Stationery Disbursement record **/ int disbursementID = (from d in context.StationeryDisbursements orderby d.DisbursementID descending select d.DisbursementID).FirstOrDefault(); foreach (StationeryRetrievalDept sd in sdList) { if (sd.DeptCode.Equals(deptCode)) { /**Create Stationery Disbursement details**/ StationeryDisbursementDetail addStationeryDisbursementDetail = new StationeryDisbursementDetail(); addStationeryDisbursementDetail.DisbursementID = disbursementID; addStationeryDisbursementDetail.ItemCode = sd.ItemCode; addStationeryDisbursementDetail.RequestedQty = sd.RequestedQty; addStationeryDisbursementDetail.ActualQty = sd.ActualQty; addStationeryDisbursementDetail.DeletedFlag = false; context.AddToStationeryDisbursementDetails(addStationeryDisbursementDetail); context.SaveChanges(); } } } /** change Statiobnery Retrieval status **/ sr.RetrievalStatus = true; context.SaveChanges(); } catch (Exception ex) { success = false; errorMsg = "Failed to generate Disbursement List for department"; throw new CreateFailedException(errorMsg); } return(success); }
public bool UpdateDisbursement(IStationeryDisbursementDetail sdd) { StationeryDisbursementDetail sdd1 = new StationeryDisbursementDetail(); sdd1.DisbursementID = sdd.DisbursementId; sdd1.ItemCode = sdd.ItemCode; sdd1.RequestedQty = sdd.RequestedQty; sdd1.ActualQty = sdd.ActualQty; int result = udlc.updateDisbursementQty(sdd1); return(result > 0); }
public int updateDisbursementQty(StationeryDisbursementDetail sdd) { var q = (from x in context.StationeryDisbursementDetails where x.ItemCode == sdd.ItemCode && x.DisbursementID == sdd.DisbursementID select x).First(); q.ActualQty = sdd.ActualQty; int result; try { result = context.SaveChanges(); } catch (Exception e) { result = 0; } return(result); }