public async Task <ActionResult <PO_Detail> > PostPO_Detail(PO_Detail pO_Detail) { _context.PO_Details.Add(pO_Detail); await _context.SaveChangesAsync(); return(CreatedAtAction("GetPO_Detail", new { id = pO_Detail.PO_DetailID }, pO_Detail)); }
public async Task <IActionResult> PutPO_Detail(string id, PO_Detail pO_Detail) { if (id != pO_Detail.PO_DetailID) { return(BadRequest()); } _context.Entry(pO_Detail).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!PO_DetailExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
protected void GetSavedItems(string status) { var ldata = PO_Detail.RetrieveData(oCon, Session["idPOHeader"].ToString(), ""); //Session["Data"] = ldata; gvItems.DataSource = ldata; gvItems.DataBind(); gvItems.GridLines = GridLines.None; if (status == "Recieved" || status == "Announced") { var ldata2 = PO_Charges.RetrieveData(oCon, Session["idPOHeader"].ToString()); txtBrokerage.Text = ldata2[0].Brokerage.ToString(); txtCEDEC.Text = ldata2[0].CEDEC.ToString(); txtCustomsStamps.Text = ldata2[0].CustomsStamps.ToString(); txtDeliveryCharges.Text = ldata2[0].DeliveryCharges.ToString(); txtDocumentaryStamps.Text = ldata2[0].DocumentaryStamps.ToString(); txtDocumentationCharges.Text = ldata2[0].DocumentationCharges.ToString(); txtForkliftCost.Text = ldata2[0].ForkliftCost.ToString(); txtFreightCharges.Text = ldata2[0].FreightCharges.ToString(); txtHandlingFee.Text = ldata2[0].HandlingFee.ToString(); txtImportDuties.Text = ldata2[0].ImportDuties.ToString(); txtImportProcessingFee.Text = ldata2[0].ImportProcessingFee.ToString(); txtImportationInsurance.Text = ldata2[0].ImportationInsurance.ToString(); txtMiscellaneous.Text = ldata2[0].Miscellaneous.ToString(); txtNotarialFee.Text = ldata2[0].NotarialFee.ToString(); txtOtherCharges.Text = ldata2[0].OtherCharges.ToString(); txtProcessingFee.Text = ldata2[0].ProcessingFee.ToString(); txtWarehouseStorageCharges.Text = ldata2[0].WarehouseStorageCharges.ToString(); txtXerox.Text = ldata2[0].Xerox.ToString(); //var detail = Import_Shipment_Detail.RetrieveData(oCon, 0, Convert.ToInt32(Session["idPOHeader"].ToString())); //var head = Import_Shipment_Header.RetrieveData(oCon, detail[0].idImpShpHead, ""); //txtImpShpNum.Text = head[0].ImportShipmentNumber; } else if (status == "Sent") { txtBrokerage.Text = "0"; txtCEDEC.Text = "0"; txtCustomsStamps.Text = "0"; txtDeliveryCharges.Text = "0"; txtDocumentaryStamps.Text = "0"; txtDocumentationCharges.Text = "0"; txtForkliftCost.Text = "0"; txtFreightCharges.Text = "0"; txtHandlingFee.Text = "0"; txtImportDuties.Text = "0"; txtImportProcessingFee.Text = "0"; txtImportationInsurance.Text = "0"; txtMiscellaneous.Text = "0"; txtNotarialFee.Text = "0"; txtOtherCharges.Text = "0"; txtProcessingFee.Text = "0"; txtWarehouseStorageCharges.Text = "0"; txtXerox.Text = "0"; } }
protected void GetSavedItems() { var ldata = PO_Detail.RetrieveForPOItems(oCon, Session["idPOHeader"].ToString()); Session["Data"] = ldata; gvItems.DataSource = ldata; gvItems.DataBind(); gvItems.GridLines = GridLines.None; }
protected void btnSave_Click(object sender, EventArgs e) { if (Convert.ToBoolean(Session["ComputeClick"]) == true) { foreach (GridViewRow row in gvItems.Rows) { var objPODetail = new PO_Detail_Model { idPODetail = int.Parse(row.Cells[0].Text), idPOHeader = int.Parse(row.Cells[1].Text), idItem = int.Parse(row.Cells[2].Text), Quantity = decimal.Parse(row.Cells[5].Text), Price = decimal.Parse(row.Cells[6].Text), Tax = decimal.Parse(row.Cells[7].Text), Amount = decimal.Parse(row.Cells[8].Text), Final_Cost = decimal.Parse(row.Cells[9].Text), Unit_Comp = row.Cells[10].Text, isReceived = "No", Partial_Remaining = 0 }; PO_Detail.Update(oCon, objPODetail); } var pO_Charges_Model = new PO_Charges_Model { idPOHeader = Convert.ToInt32(Session["idPOHeader"].ToString()), Brokerage = Convert.ToDecimal(txtBrokerage.Text), CEDEC = Convert.ToDecimal(txtCEDEC.Text), CustomsStamps = Convert.ToDecimal(txtCustomsStamps.Text), DeliveryCharges = Convert.ToDecimal(txtDeliveryCharges.Text), DocumentaryStamps = Convert.ToDecimal(txtDocumentaryStamps.Text), DocumentationCharges = Convert.ToDecimal(txtDocumentationCharges.Text), ForkliftCost = Convert.ToDecimal(txtForkliftCost.Text), FreightCharges = Convert.ToDecimal(txtFreightCharges.Text), HandlingFee = Convert.ToDecimal(txtHandlingFee.Text), ImportationInsurance = Convert.ToDecimal(txtImportationInsurance.Text), ImportDuties = Convert.ToDecimal(txtImportDuties.Text), ImportProcessingFee = Convert.ToDecimal(txtImportProcessingFee.Text), Miscellaneous = Convert.ToDecimal(txtMiscellaneous.Text), NotarialFee = Convert.ToDecimal(txtNotarialFee.Text), OtherCharges = Convert.ToDecimal(txtOtherCharges.Text), ProcessingFee = Convert.ToDecimal(txtProcessingFee.Text), WarehouseStorageCharges = Convert.ToDecimal(txtWarehouseStorageCharges.Text), Xerox = Convert.ToDecimal(txtXerox.Text) }; PO_Charges.Save(oCon, pO_Charges_Model); var poheader = new PO_Header_Model { idPOHeader = Convert.ToInt32(Session["idPOHeader"].ToString()), POStatus = "Announced", Total_Charges = Convert.ToDecimal(txtTotalCharges.Text), ImportShipmentNumber = txtImpShpNum.Text }; PO_Header.UpdatePOStatus(oCon, poheader); PO_Header.UpdateTotalCharges(oCon, poheader); defaultSettings(); GetPO(); } else { HttpContext.Current.Response.Write("<script>alert(" + ControlChars.Quote + "Cost not yet computed!" + ControlChars.Quote + ");</script>"); } }
protected void Page_Load(object sender, EventArgs e) { string po_number = ""; string Remarks = ""; string Terms = ""; string POAmount = ""; string idPOHeader = ""; HttpRequest q = Request; NameValueCollection n = q.QueryString; if (n.HasKeys()) { if (n.GetKey(0) != "") { po_number = n.Get(0); } if (n.GetKey(1) != "") { Remarks = n.Get(1); } if (n.GetKey(2) != "") { Terms = n.Get(2); } if (n.GetKey(3) != "") { POAmount = n.Get(3); } if (n.GetKey(4) != "") { idPOHeader = n.Get(4); } var lDataAdd = PO_Detail.RetrieveForPOItems(oCon, idPOHeader); Microsoft.Reporting.WebForms.ReportViewer viewer = new ReportViewer(); viewer.ProcessingMode = ProcessingMode.Local; viewer.LocalReport.ReportPath = Server.MapPath(@"~\Resources\LSIPurchaseOrder.rdlc"); ReportParameter p1 = new ReportParameter("Remarks", Remarks.Replace("_-_-", Environment.NewLine)); ReportParameter p2 = new ReportParameter("Date", DateTime.Now.ToShortDateString()); ReportParameter p3 = new ReportParameter("PONumber", po_number); ReportParameter p4 = new ReportParameter("SupplierName", "GN AUDIO SINGAPORE PTE LTD"); ReportParameter p5 = new ReportParameter("SupplierAddress", "150 Beach Road, #15-05/06, Gateway West, Singapore 189720"); ReportParameter p6 = new ReportParameter("ShipToName", "LSI Leading Technologies Inc."); ReportParameter p7 = new ReportParameter("ShipToAddress", "4842 Valenzuela St., Zone 060 Brgy. 603 Sampaloc, Manila 1008"); ReportParameter p8 = new ReportParameter("SupplierTelNo", "-"); ReportParameter p9 = new ReportParameter("SupplierFaxNo", "-"); ReportParameter p10 = new ReportParameter("ShipToTelNo", "Tel. 632-727-0285, 713-0513"); ReportParameter p11 = new ReportParameter("ShipToFaxNo", "Fax: 632-721-8474"); ReportParameter p12 = new ReportParameter("Terms", Terms); ReportParameter p13 = new ReportParameter("SaleAmount", POAmount); ReportParameter p14 = new ReportParameter("TotalAmount", POAmount); ReportParameter p15 = new ReportParameter("VAT", "0.00"); ReportParameter p16 = new ReportParameter("Salesman", Session["User_Domain"].ToString()); viewer.LocalReport.SetParameters(new ReportParameter[] { p1, p2, p3, p4, p5, p6, p7, p8, p9, p10, p11, p12, p13, p14, p15, p16 }); ReportDataSource repDataSource1 = new ReportDataSource("POSet", lDataAdd); viewer.LocalReport.DataSources.Clear(); viewer.LocalReport.DataSources.Add(repDataSource1); Warning[] warnings; string[] streamIds; string mimeType = string.Empty; string encoding = string.Empty; string extension = "pdf"; byte[] bytes = viewer.LocalReport.Render("PDF", null, out mimeType, out encoding, out extension, out streamIds, out warnings); Response.Buffer = true; Response.Clear(); Response.ContentType = mimeType; Response.AddHeader("content-disposition", "attachment; filename= " + po_number + "." + extension); Response.OutputStream.Write(bytes, 0, bytes.Length); // create the file Response.Flush(); // send it to the client to download Response.End(); //var lData = Purchase_Reciept.GetPurchaseReciept(oCon, ponumber, Convert.ToInt32(idItem)); //Microsoft.Reporting.WebForms.ReportViewer viewer = new ReportViewer(); //viewer.ProcessingMode = ProcessingMode.Local; //viewer.LocalReport.ReportPath = Server.MapPath(@"~\Resources\PurchaseReceipt.rdlc"); //ReportParameter p1 = new ReportParameter("PONumber", ponumber); //ReportParameter p2 = new ReportParameter("DocNumber", docno); //ReportParameter p3 = new ReportParameter("Site", sitename); //ReportParameter p4 = new ReportParameter("TransDate", DateTime.Now.ToShortDateString()); //ReportParameter p5 = new ReportParameter("SupplierName", "GN AUDIO SINGAPORE PTE LTD"); //ReportParameter p6 = new ReportParameter("Address1", "150 Beach Road,"); //ReportParameter p7 = new ReportParameter("Address2", "#15-05/06, Gateway West"); //ReportParameter p8 = new ReportParameter("Address3", "Singapore"); //ReportParameter p9 = new ReportParameter("Address4", "189720"); ////ReportParameter p5 = new ReportParameter("SupplierName", Session["SupplierName"].ToString()); ////ReportParameter p6 = new ReportParameter("Address1", Session["Address1"].ToString()); ////ReportParameter p7 = new ReportParameter("Address2", Session["Address2"].ToString()); ////ReportParameter p8 = new ReportParameter("Address3", Session["Address3"].ToString()); ////ReportParameter p9 = new ReportParameter("Address4", Session["Address4"].ToString()); //ReportParameter p10 = new ReportParameter("PRNumber", PRNumber); //ReportDataSource repDataSource = new ReportDataSource("DataSet2", lData); //viewer.LocalReport.SetParameters(new ReportParameter[] { p1, p2, p3, p4, p5, p6, p7, p8, p9, p10 }); //viewer.LocalReport.DataSources.Clear(); //viewer.LocalReport.DataSources.Add(repDataSource); //Warning[] warnings; //string[] streamIds; //string mimeType = string.Empty; //string encoding = string.Empty; //string extension = "pdf"; //try //{ // byte[] bytes = viewer.LocalReport.Render("PDF", null, out mimeType, out encoding, out extension, out streamIds, out warnings); // Response.Buffer = true; // Response.Clear(); // Response.ContentType = mimeType; // Response.AddHeader("content-disposition", "attachment; filename= " + "PR_" + PRNumber + "." + extension); // Response.OutputStream.Write(bytes, 0, bytes.Length); // create the file // Response.Flush(); // send it to the client to download // Response.End(); //} //catch //{ // HttpContext.Current.Response.Write("<script>alert(" + ControlChars.Quote + "Download not successful!" + ControlChars.Quote + ");</script>"); //} //finally //{ //} } }
protected void btnSave_Click(object sender, EventArgs e) { if (Session["Mode"].ToString() == "Add") { string PONum = PO_Header.GetLastPONumber(oCon); if (PONum == null) { PONum = "PJ000000"; } PONum = PONum.Substring(2); int PONum_ = int.Parse(PONum) + 1; string po_number = "PJ" + PONum_.ToString("000000"); var poHeader = new PO_Header_Model { PO_Number = po_number, PO_Date = DateTime.Now, Delivery_Date = DateTime.Now, Terms = txtTerms.Text, FOB_Point = "", Shipping_Via = "", Currency = "USD", idSupplier = 0, PO_Total = Convert.ToDecimal(txtPOAmount.Text), PO_Quantity = Convert.ToInt32(txtPOQuantity.Text), Total_Charges = 0, Forex_Rate = Convert.ToDecimal(txtForexRate.Text), PR_Number = "", Created_By = Session["User_Domain"].ToString(), Remarks = txtRemarks.Text, POStatus = "Created", ImportShipmentNumber = "" }; int idPOHeader = PO_Header.Save(oCon, poHeader); foreach (GridViewRow row in gvItems.Rows) { int idItem = int.Parse(row.Cells[1].Text); decimal Quantity = decimal.Parse(row.Cells[4].Text); decimal Price = decimal.Parse(row.Cells[5].Text); decimal Extended = decimal.Parse(row.Cells[6].Text); var objPODetail = new PO_Detail_Model { idPOHeader = idPOHeader, idItem = idItem, Quantity = Quantity, Price = Price, Amount = Extended, Tax = 0, Final_Cost = 0, Unit_Comp = "", isReceived = "No", Partial_Remaining = 0 }; PO_Detail.Save(oCon, objPODetail); } POUpload(po_number, idPOHeader); } else if (Session["Mode"].ToString() == "Edit") { int idPOHeader = Convert.ToInt32(Session["idPOHeader"].ToString()); var poHeader = new PO_Header_Model { PO_Number = lblPONumber.Text, Terms = txtTerms.Text, FOB_Point = "", Shipping_Via = "", Currency = "USD", idSupplier = 0, PO_Total = Convert.ToDecimal(txtPOAmount.Text), PO_Quantity = Convert.ToInt32(txtPOQuantity.Text), Total_Charges = 0, Forex_Rate = Convert.ToDecimal(txtForexRate.Text), Created_By = Session["User_Domain"].ToString(), Remarks = txtRemarks.Text, POStatus = "Created", idPOHeader = idPOHeader, ImportShipmentNumber = "" }; PO_Header.Update(oCon, poHeader); bool result = PO_Detail.DeleteAllDetail(oCon, idPOHeader); if (result == true) { foreach (GridViewRow row in gvItems.Rows) { int idItem = int.Parse(row.Cells[1].Text); decimal Quantity = decimal.Parse(row.Cells[4].Text); decimal Price = decimal.Parse(row.Cells[5].Text); decimal Extended = decimal.Parse(row.Cells[6].Text); var objPODetail = new PO_Detail_Model { idPOHeader = idPOHeader, idItem = idItem, Quantity = Quantity, Price = Price, Amount = Extended, Tax = 0, Final_Cost = 0, Unit_Comp = "", isReceived = "No", Partial_Remaining = 0 }; PO_Detail.Save(oCon, objPODetail); } POUpload(lblPONumber.Text, idPOHeader); } else { HttpContext.Current.Response.Write("<script>alert(" + ControlChars.Quote + "Error in deleting po detail of " + lblPONumber.Text + ControlChars.Quote + ");</script>"); } } defaultSettings(); GetPO(); }