//for android: different cos of execution of rd.allocateQty += allocateQty public int UpdateRequisitionDetailsAndroid(string itemcode, int requisitionNo, int?allocateQty) { try { StationeryModel entity = new StationeryModel(); Requisition_Detail rd = new Requisition_Detail(); rd = entity.Requisition_Detail.Where(x => x.itemCode == itemcode && x.requisitionNo == requisitionNo).First(); //start of code added by alex// //deduct retrieve qty after doing allocation List <RetrieveForm> retrievalList = (List <RetrieveForm>)HttpContext.Current.Application["retrieveForm"]; int index = retrievalList.FindIndex(x => x.ItemCode == itemcode); retrievalList[index].retrieveQty -= allocateQty; HttpContext.Current.Application["retrieveForm"] = retrievalList; //end of code// rd.allocatedQty += allocateQty; entity.SaveChanges(); return(0); } catch { return(0); } }
public override void NewMethod(object obj) { RequisitionObj = new Requisition() { Requisition_Details = new ObservableCollection <Requisition_Detail>(), ReqId = GetNewReqId(), TDate = DateTime.Today, Exp_DeliveryDate = DateTime.Today }; Requisition_DetailObj = new Requisition_Detail(); }
public override bool UndoMethod(object obj) { RequisitionObj = new Requisition() { Requisition_Details = new ObservableCollection <Requisition_Detail>() }; Requisition_DetailObj = new Requisition_Detail(); SelectedItemMcode = null; return(false); }
public int UpdateRequisitionDetails(string itemcode, int requisitionNo, int?allocateQty, int?fulfilledQty) { StationeryModel entity = new StationeryModel(); Requisition_Detail rd = new Requisition_Detail(); rd = entity.Requisition_Detail.Where(x => x.itemCode == itemcode && x.requisitionNo == requisitionNo).First(); rd.allocatedQty = allocateQty; rd.fulfilledQty = fulfilledQty; entity.SaveChanges(); return(0); }
public WCFRequisitionDetail GetRequisitionDetailsBy2Keys(string itemCode, string requisitionNO) { try { Requisition_Detail detail = requisitionRecordService.FindDetailsBy2Key(itemCode, Convert.ToInt32(requisitionNO)); return(WCFModelConvertUtility.ConvertToWCFRequisitionDetail(detail)); } catch (Exception e) { throw new Exception(e.Message); } }
public int?FindUnfulfilledQtyBy2Key(string itemcode, int requisionNo) { StationeryModel entity = new StationeryModel(); Requisition_Detail rd = entity.Requisition_Detail.Where(x => x.itemCode == itemcode && x.requisitionNo == requisionNo).First(); if (rd.fulfilledQty != null) { return(rd.qty - rd.fulfilledQty); } else { return(rd.qty); } }
private void changeItemEvent(bool IsbarcodeChangeEvent = false) { if (Requisition_DetailObj == null) { Requisition_DetailObj = new Requisition_Detail(); } Requisition_DetailObj.Mcode = _SelectedItemMcode; Requisition_DetailObj.Item = new Product(_SelectedItemMcode); Requisition_DetailObj.Unit = Requisition_DetailObj.Item.BASEUNIT; //if (IsbarcodeChangeEvent == false) //{ // Requisition_DetailObj.Bcode = Requisition_DetailObj.Item.BARCODE; //} }
public static Requisition_Detail ConvertFromWCFRequisitionDetail(WCFRequisitionDetail wcf_detail) { Requisition_Detail detail = new Requisition_Detail(); detail.allocatedQty = wcf_detail.AllocateQty; detail.clerkID = wcf_detail.ClerkID; detail.fulfilledQty = wcf_detail.FulfilledQty; detail.itemCode = wcf_detail.ItemCode; detail.nextCollectionDate = wcf_detail.NextCollectionDate; detail.qty = wcf_detail.Qty; detail.remarks = wcf_detail.Remarks; detail.requisitionNo = wcf_detail.RequisitionNo; detail.retrievedDate = wcf_detail.RetrievedDate; return(detail); }
public int UpdateRequisitionDetails(string itemcode, int requisitionNo, int?allocateQty) { try { StationeryModel entity = new StationeryModel(); Requisition_Detail rd = new Requisition_Detail(); rd = entity.Requisition_Detail.Where(x => x.itemCode == itemcode && x.requisitionNo == requisitionNo).First(); rd.allocatedQty = allocateQty; entity.SaveChanges(); return(0); } catch (Exception e) { e.Message.ToString(); return(1); } }
private ReportViewModel ConvertToReportViewModel(Requisition_Detail detail) { Stationery stationery = stationeryService.FindStationeryByItemCode(detail.itemCode); Requisition_Record record = detail.Requisition_Record; ReportViewModel vm = new ReportViewModel(); vm.CategoryName = stationery.Category.categoryName; vm.Cost = stationery.price; vm.ItemCode = detail.itemCode; vm.ItemDescription = stationery.description; vm.Month = record.requestDate.Value.Month; vm.RequestQuantity = (detail.qty == null) ? 0 : (int)detail.qty; vm.RequesterDepartment = userService.FindDeptCodeByID(record.requesterID); vm.Year = record.requestDate.Value.Year; vm.Status = record.status; return(vm); }
public bool UpdateRequisitionDetails(List <RequisitionDetailViewModel> vmList, out string errorMessage) { errorMessage = null; foreach (var vm in vmList) { Requisition_Detail rd = new Requisition_Detail(); rd.itemCode = vm.ItemCode; rd.requisitionNo = vm.RequisitionNo; rd.qty = vm.RequestQty; if (!rDAO.UpdateRequisitionDetails(rd)) { errorMessage = String.Format("Error occured when updating the quantity of {0}", vm.Description); return(false); } } return(true); }
public static WCFRequisitionDetail ConvertToWCFRequisitionDetail(Requisition_Detail detail) { Stationery s = stationeryService.FindStationeryByItemCode(detail.itemCode); WCFRequisitionDetail wcf_detail = new WCFRequisitionDetail(); wcf_detail.RequisitionNo = detail.requisitionNo; wcf_detail.ItemCode = detail.itemCode; wcf_detail.StationeryDescription = s.description; wcf_detail.UOM = s.unitOfMeasure; wcf_detail.Remarks = detail.remarks; wcf_detail.Qty = (detail.qty == null) ? 0 : (int)detail.qty; wcf_detail.FulfilledQty = (detail.fulfilledQty == null) ? 0 : (int)detail.fulfilledQty; wcf_detail.ClerkID = detail.clerkID; wcf_detail.RetrievedDate = detail.retrievedDate; wcf_detail.AllocateQty = (detail.allocatedQty == null) ? 0 : (int)detail.allocatedQty; wcf_detail.NextCollectionDate = detail.nextCollectionDate; wcf_detail.Status = detail.Requisition_Record.status; return(wcf_detail); }
private void ExecuteAdd(object obj) { if (Requisition_DetailObj.Item == null) { return; } if (Requisition_DetailObj.Quantity <= 0) { MessageBox.Show("Please provide valid Quantity"); return; } if (RequisitionObj.Requisition_Details.Any((item) => item.Mcode == Requisition_DetailObj.Mcode)) { MessageBox.Show("Item is already in the Table below", "Duplicate Data", MessageBoxButton.OK, MessageBoxImage.Error); return; } RequisitionObj.Requisition_Details.Add(Requisition_DetailObj); Requisition_DetailObj = new Requisition_Detail(); SelectedItemMcode = null; }
public bool UpdateRequisitionDetails(Requisition_Detail requisitionDetail) { using (StationeryModel context = new StationeryModel()) { try { Requisition_Detail rd = (from r in context.Requisition_Detail where r.requisitionNo == requisitionDetail.requisitionNo & r.itemCode == requisitionDetail.itemCode select r).FirstOrDefault(); rd.qty = requisitionDetail.qty; rd.Requisition_Record.requestDate = DateTime.Today; context.SaveChanges(); return(true); } catch (Exception e) { return(false); } } }
public ActionResult SubmitRequisition(List <RaiseRequisitionViewModel> requestList) { string requesterID = HttpContext.User.Identity.Name; Requisition_Record requisition = new Requisition_Record(); foreach (RaiseRequisitionViewModel request in requestList) { Requisition_Detail rd = new Requisition_Detail(); rd.itemCode = request.ItemCode; rd.qty = request.Quantity; rd.allocatedQty = 0; rd.fulfilledQty = 0; requisition.Requisition_Detail.Add(rd); } if (!requisitionService.IsUserValidToSubmitRequisition(requesterID)) { TempData["ErrorMessage"] = "Sorry, you are not allowed to submit stationery requisition."; return(RedirectToAction("NewRequisition")); } if (requisitionService.ValidateRequisition(requisition)) { // Valid request, submit to database try { requisitionService.SubmitNewRequisition(requisition, requesterID); // clear requestlist Session["RequestList"] = new List <RaiseRequisitionViewModel>(); TempData["SuccessMessage"] = "New stationery requisition has been submitted."; // go to user requisition list return(RedirectToAction("Index", "ListRequisitions")); } catch (EmailException e) { // submit requisition successfully but email throw exception // clear requestlist Session["RequestList"] = new List <RaiseRequisitionViewModel>(); TempData["SuccessMessage"] = "New stationery requisition has been submitted."; TempData["WarningMessage"] = "Failure to send email notification. Kindly contact IT personnel."; // go to user requisition list return(RedirectToAction("Index", "ListRequisitions")); } catch (Exception e1) { // error Session["RequestList"] = requestList; TempData["ErrorMessage"] = e1.Message; } } else { // Invalid request Session["RequestList"] = requestList; TempData["ErrorMessage"] = "Invalid request"; } //return to new requisition form if submit unsuccessful return(RedirectToAction("NewRequisition")); }
private void convertDataTableToObsCollection() { var _dataTable = getExcelDataToDataTable(); if (_dataTable == null) { return; } DataColumnCollection columns = _dataTable.Columns; if (columns.Contains("BARCODE") || columns.Contains("MENUCODE")) { } else { MessageBox.Show("Invalid Excel File.Must contain MENUCODE Or BARCODE Column And QUANTITY Column"); return; } if (columns.Contains("QUANTITY")) { } else { MessageBox.Show("Invalid Excel File.Must contain QUANTITY Column"); return; } var productList = new ObservableCollection <Requisition_Detail>(_dataTable.AsEnumerable().Select(i => { var RD = new Requisition_Detail(); Product P = new Product(); if (columns.Contains("BARCODE")) { using (SqlConnection con = new SqlConnection(GlobalClass.DataConnectionString)) { if (string.IsNullOrEmpty(i["BARCODE"].ToString())) { P = null; } else { var bitem = con.Query("SELECT A.BCODE,A.MCODE,A.UNIT,A.ISSUENO,A.EDATE,A.BCODEID,A.SUPCODE,A.BATCHNO,A.EXPIRY,A.REMARKS,A.INVNO,A.DIV,A.FYEAR,A.SRATE,B.DESCA,B.MENUCODE FROM BARCODE A inner join Menuitem B on A.mcode=B.mcode WHERE A.BCODE='" + i["BARCODE"].ToString() + "'").FirstOrDefault(); if (bitem == null) { P = null; } else { P.BARCODE = bitem.BCODE; P.BASEUNIT = bitem.UNIT; P.MCODE = bitem.MCODE; P.MENUCODE = bitem.MENUCODE; P.DESCA = bitem.DESCA; } } } // P = ItemList.FirstOrDefault(item => item.BARCODE == i["BARCODE"].ToString()); if (P == null) { if (columns.Contains("MENUCODE")) { P = ItemList.FirstOrDefault(item => item.MENUCODE == i["MENUCODE"].ToString()); } } } else if (columns.Contains("MENUCODE")) { P = ItemList.FirstOrDefault(item => item.MENUCODE == i["MENUCODE"].ToString()); } var Q = Convert.ToDecimal(i["QUANTITY"]); if (P == null || Q <= 0) { return(new Requisition_Detail()); } RD.Item = P; RD.Bcode = P.BARCODE; RD.Mcode = P.MCODE; RD.Bcode = P.BARCODE; RD.Unit = P.BASEUNIT; RD.ApprovedQty = Q; RD.Quantity = Q; return(RD); })); if (productList != null) { this.RequisitionObj.Requisition_Details = new ObservableCollection <Requisition_Detail>(productList.Where(item => item.Item != null)); } }