public ActionResult GetWBItems(Guid id) { using (var db = new SCMSEntities()) { WarehouseRelease wrn = db.WarehouseReleases.SingleOrDefault(p => p.Id == id); StringBuilder blineOption = new StringBuilder(); blineOption.Append("<table width=\"95%\" align=\"center\" cellspacing=\"0\" cellpadding=\"0\" border=\"1\" style=\"border: 1px solid grey;"); blineOption.Append("border-collapse: collapse; padding: 5px; font-size: 12px;\">"); blineOption.Append("<tr class=\"gridheader\"><th colspan=\"6\" align=\"left\"><h4>" + Resources.WayBill_LoadWB_LOADINGDISPATCHDETAILS + "</h4></th></tr>"); blineOption.Append("<tr><th style=\"width: 5%; text-align: center;\"></th>"); blineOption.Append("<th style=\"width: 15%; text-align: center;\">" + Resources.WayBillController_String_ItemSerialNo + "</th>"); blineOption.Append("<th style=\"width: 28%; text-align: center;\">" + Resources.WayBill_LoadWB_EquipmentitemCommodity + "</th>"); blineOption.Append("<th style=\"width: 10%; text-align: center;\">" + Resources.Global_String_Unit + "</th>"); blineOption.Append("<th style=\"width: 17%; text-align: center;\">" + Resources.Global_String_Weight + "</th>"); blineOption.Append("<th style=\"width: 17%; text-align: center;\">" + Resources.WayBill_LoadWB_QtyDispatched + "</th></tr>"); if (wrn != null) { Int64 count = 1; foreach (WarehouseReleaseItem item in wrn.WarehouseReleaseItems.ToList()) { blineOption.Append("<tr><td align=\"center\">" + count + "</td>"); if (item.Inventory.Item.ItemCategory.CategoryCode == "C") { blineOption.Append("<td>" + item.Inventory.Item.SerialNumber + "</td>"); } else { blineOption.Append("<td>" + db.Assets.First(p => p.Id == item.AssetId).SerialNumber + "</td>"); } if (item.Inventory.Item.ItemCategory.CategoryCode == "C") { blineOption.Append("<td>" + item.Inventory.Item.Name + "</td>"); } else { blineOption.Append("<td>" + db.Assets.First(p => p.Id == item.AssetId).Name + "</td>"); } blineOption.Append("<td>" + item.Inventory.Item.UnitOfMeasure.Code + "</td>"); if (item.Inventory.Item.ItemCategory.CategoryCode == "C") { blineOption.Append("<td></td>"); } else { blineOption.Append("<td>" + item.Asset.Weight + "</td>"); } blineOption.Append("<td>" + item.Quantity + "</td></tr>"); count++; } } blineOption.Append("</table>"); ViewBag.Html = blineOption.ToString(); return(View("HTMLResponses")); } }
public ActionResult LoadWRFItem(WarehouseRelease model) { model.Id = Guid.NewGuid(); model.NotReleased = true; model.CountryProgrammeId = countryProg.Id; model.PreparedOn = DateTime.Now; model.PreparedBy = currentStaff.Id; UserSession.CurrentSession.NewWRN = model; return(ReleaseItem(model.Id)); }
public bool SaveApproved(WarehouseRelease wro) { using (var context = new SCMSEntities()) { context.WarehouseReleases.Attach(wro); ((IObjectContextAdapter)context).ObjectContext.ObjectStateManager.ChangeObjectState(wro, System.Data.EntityState.Modified); int affectedRecords = context.SaveChanges(); SessionData.CurrentSession.ReleaseOrderList = null; SessionData.CurrentSession.ReleaseOrderItemList = null; return(affectedRecords > 0); } }
public bool EditRO(WarehouseRelease RO) { using (var context = new SCMSEntities()) { var existing = context.WarehouseReleases.FirstOrDefault(p => p.Id == RO.Id); context.Entry(existing).CurrentValues.SetValues(RO); int affectedRecords = context.SaveChanges(); SessionData.CurrentSession.ReleaseOrderList = null; SessionData.CurrentSession.ReleaseOrderItemList = null; return(affectedRecords > 0); } }
public ActionResult ReleaseItem(Guid ROId) { WarehouseRelease rOrder = null; rOrder = WRFservice.GetWRNs().FirstOrDefault(k => k.Id == ROId); if (rOrder == null) { rOrder = UserSession.CurrentSession.NewWRN; } var modal = new WarehouseReleaseItem() { Items = new SelectList(WRFservice.GetInventoryItems((Guid)rOrder.WareHouseId), "Id", "ItemName"), WarehouseReleaseId = ROId }; return(View("LoadWRFItem", modal)); }
public ActionResult WBReceive() { using (var db = new SCMSEntities()) { WarehouseRelease wrn = db.WarehouseReleases.FirstOrDefault <WarehouseRelease>(); List <WarehouseReleaseItem> itmz = wrn != null?wrn.WarehouseReleaseItems.ToList() : new List <WarehouseReleaseItem>(); foreach (WarehouseReleaseItem item in itmz) { Model.Inventory iv = item.Inventory; Model.Item it = iv.Item; Model.ItemCategory itc = it.ItemCategory; Model.Asset ast = item.Asset; Model.UnitOfMeasure u = it.UnitOfMeasure; } //Use this to populate items on load for any changes in the stolen code //WayBill wb = db.WayBills.First(p => p.Id == new Guid("0D88562F-BBEC-4722-941B-91FC4D82BB1C")); //List<WarehouseReleaseItem> wrnn = db.WarehouseReleases.FirstOrDefault(p => p.Id == wb.WRNId).WarehouseReleaseItems.ToList(); //foreach (WarehouseReleaseItem item in wrnn) //{ // Model.Asset ass = item.Asset; // Model.Inventory iv = item.Inventory; // Model.Item it = iv.Item; // Model.ItemCategory ic = it.ItemCategory; // Model.UnitOfMeasure u = it.UnitOfMeasure; //} var model = new ReceiveWB() { EntityWBill = new WayBill(), IssuingOffice = new SelectList(WBService.GetSubOffices(countryProg.Id), "Id", "Name"), WBlist = new SelectList(WBService.GetWayBillsNotReceived(countryProg.Id), "Id", "RefNumber"), WRItems = new List <WarehouseReleaseItem>()//wrnn }; return(View(model)); } }
// public ActionResult ReleaseForm(Guid WRNid) { Dictionary <String, String> data = new Dictionary <string, string>(); using (var db = new SCMSEntities()) { WarehouseRelease wrnenttiy = db.WarehouseReleases.First(p => p.Id == WRNid); data.Add("{DATE}", wrnenttiy.RequestDate.ToShortDateString()); data.Add("{REF_NO}", wrnenttiy.RefNumber); data.Add("{OFFICE}", wrnenttiy.Staff1.CountrySubOffice.Name); var requestor = db.VStaffDetails.First(p => p.StaffID == wrnenttiy.PreparedBy); var recipient = db.VStaffDetails.First(p => p.StaffID == wrnenttiy.ReceivedBy); data.Add("{NAME}", requestor.StaffName); data.Add("{TITLE}", requestor.Designation); if (requestor.SignatureImage.IsNotNull()) { data.Add("{SIGNATURE}", string.Format("<img src=\"{0}\" alt=\"\" style=\"max-width: 50px;\" />", "data:image/png;base64," + Convert.ToBase64String(requestor.SignatureImage))); } data.Add("{APPROVER-NAME}", wrnenttiy.IsApproved ? wrnenttiy.Staff.Person.FirstName + " " + wrnenttiy.Staff.Person.OtherNames : ""); data.Add("{APPROVER-TITLE}", wrnenttiy.IsApproved ? wrnenttiy.Staff.Designation.Name : ""); data.Add("{APPROVER-OFICE}", wrnenttiy.IsApproved ? wrnenttiy.Staff.CountrySubOffice.Name : ""); if (wrnenttiy.Staff.Person.SignatureImage.IsNotNull() && wrnenttiy.IsApproved) { data.Add("{SIGNATURE2}", string.Format("<img src=\"{0}\" alt=\"\" style=\"max-width: 50px;\" />", "data:image/png;base64," + Convert.ToBase64String(wrnenttiy.Staff.Person.SignatureImage))); } data.Add("{RECEIVER_NAME}", recipient != null ? recipient.StaffName : ""); data.Add("{RECEIVER_TITLE}", recipient != null ? recipient.Designation : ""); data.Add("{RECEIVER_UNIT}", wrnenttiy.Staff2 != null ? wrnenttiy.Staff2.CountrySubOffice.Name : ""); data.Add("{RECEIVER_DATE}", wrnenttiy.ReceiptDate.ToDDMMyyyHHmm()); if (wrnenttiy.Staff2.Person.SignatureImage.IsNotNull()) { data.Add("{RECEIVER_SIGNATURE}", string.Format("<img src=\"{0}\" alt=\"\" style=\"max-width: 100px;\" />", "data:image/png;base64," + Convert.ToBase64String(wrnenttiy.Staff2.Person.SignatureImage))); } List <Model.WarehouseReleaseItem> writms = wrnenttiy.WarehouseReleaseItems.ToList(); string tbody = ""; int r = 1; string itemName, serialNo, AssetNo; foreach (WarehouseReleaseItem item in writms) { if (item.Inventory.Item.ItemCategory.CategoryCode == "C") { itemName = item.Inventory.Item.Name; serialNo = item.Inventory.Item.SerialNumber; AssetNo = "N/A"; } else { itemName = item.Asset.Name; serialNo = item.Asset.SerialNumber; AssetNo = item.Asset.AssetNumber; } tbody += "<tr><td>" + r++ + "</td><td>"; tbody += itemName + "</td><td>"; tbody += item.Inventory.Item.UnitOfMeasure.Code + "</td><td>"; tbody += serialNo + "</td><td>"; tbody += AssetNo + "</td><td>"; tbody += item.Quantity + "</td><td>"; tbody += item.Comments + "</td></tr>"; } while (r < 21) { tbody += "<tr><td>" + r++ + "</td><td></td><td></td><td></td><td></td><td></td><td></td></tr>"; } data.Add("{DETAILS}", tbody); List <String> options = new List <string>(); options.Add(" --copies 2 "); Byte[] output = WkHtml2Pdf.CreateReport(data, "warehouse-release-form.html", options); return(File(output, "application/pdf", "WRN_" + DateTime.Now.FormatDDMMMYYYYHHmm())); } }
public ActionResult GetWBReceivdItems(Guid id) { using (var db = new SCMSEntities()) { WayBill wb = db.WayBills.First(p => p.Id == id); WarehouseRelease wrn = db.WarehouseReleases.FirstOrDefault(p => p.Id == wb.WRNId); StringBuilder blineOption = new StringBuilder(); blineOption.Append("<table width=\"98%\" align=\"center\" cellspacing=\"0\" cellpadding=\"0\" border=\"1\" style=\"border: 1px solid grey;"); blineOption.Append("border-collapse: collapse; padding: 5px; font-size: 12px;\">"); blineOption.Append("<tr class=\"gridheader\"><th colspan=\"8\" align=\"left\"><h4>" + Resources.WayBill_ViewWBDetails_WayBillDetails + "</h4></th></tr>"); blineOption.Append("<tr><th style=\"width: 5%; text-align: center;\"></th>"); blineOption.Append("<th style=\"width: 15%; text-align: center;\">" + Resources.WayBillController_String_ItemSerialNo + "</th>"); blineOption.Append("<th style=\"width: 20%; text-align: center;\">" + Resources.WayBill_LoadWB_EquipmentitemCommodity + "</th>"); blineOption.Append("<th style=\"width: 8%; text-align: center;\">" + Resources.Global_String_Unit + "</th>"); blineOption.Append("<th style=\"width: 12%; text-align: center;\">" + Resources.Global_String_Weight + "</th>"); blineOption.Append("<th style=\"width: 12%; text-align: center;\">" + Resources.WayBill_LoadWB_QtyDispatched + "</th>"); blineOption.Append("<th style=\"width: 10%; text-align: center;\">" + Resources.Global_String_QtyReceived + "</th>"); blineOption.Append("<th style=\"width: 10%; text-align: center;\">" + Resources.Global_String_QtyDamaged + "</th></tr>"); if (wrn != null) { Int64 count = 1, cunt2 = 0; foreach (WarehouseReleaseItem item in wrn.WarehouseReleaseItems.ToList()) { blineOption.Append("<tr><td align=\"center\">" + count + ""); blineOption.Append("<input id=\"WRItems_" + cunt2 + "__Id\" name=\"WRItems[" + cunt2 + "].Id\" type=\"hidden\" value=\"" + item.Id + "\" /></td>"); if (item.Inventory.Item.ItemCategory.CategoryCode == "C") { blineOption.Append("<td>" + item.Inventory.Item.SerialNumber + "</td>"); } else { blineOption.Append("<td>" + db.Assets.First(p => p.Id == item.AssetId).SerialNumber + "</td>"); } if (item.Inventory.Item.ItemCategory.CategoryCode == "C") { blineOption.Append("<td>" + item.Inventory.Item.Name + "</td>"); } else { blineOption.Append("<td>" + db.Assets.First(p => p.Id == item.AssetId).Name + "</td>"); } blineOption.Append("<td>" + item.Inventory.Item.UnitOfMeasure.Code + "</td>"); if (item.Inventory.Item.ItemCategory.CategoryCode == "C") { blineOption.Append("<td>N/A</td>"); } else { blineOption.Append("<td>" + item.Asset.Weight + "</td>"); } blineOption.Append("<td>" + item.Quantity + "</td>"); blineOption.Append("<td><input class=\"WBnumericTb\" data-val=\"true\" data-val-number=\"" + Resources.Global_String_InvalidValue + "\" "); blineOption.Append("data-val-required=\"" + Resources.Global_String_Required + "\" id=\"WRItems_" + cunt2 + "__QuantityReceived\" name=\"WRItems[" + cunt2 + "].QuantityReceived\" type=\"text\" value=\"\" />"); blineOption.Append("<span class=\"field-validation-valid\" data-valmsg-for=\"WRItems[" + cunt2 + "].QuantityReceived\" data-valmsg-replace=\"true\"></span></td>"); blineOption.Append("<td><input class=\"WBnumericTb\" data-val=\"true\" data-val-number=\"" + Resources.Global_String_InvalidValue + "\" "); blineOption.Append("data-val-required=\"" + Resources.Global_String_Required + "\" id=\"WRItems_" + cunt2 + "__QuantityDamaged\" name=\"WRItems[" + cunt2 + "].QuantityDamaged\" type=\"text\" value=\"\" />"); blineOption.Append(" <span class=\"field-validation-valid\" data-valmsg-for=\"WRItems[" + cunt2 + "].QuantityDamaged\" data-valmsg-replace=\"true\"></span></td></tr>"); count++; cunt2++; } } blineOption.Append("</table>"); ViewBag.Html = blineOption.ToString(); return(View("HTMLResponses")); } }