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