public ActionResult Receive(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } PO_Header pO_Header = db.PO_Header.Find(id); if (pO_Header == null) { return(HttpNotFound()); } foreach (var detail in pO_Header.PO_Detail) { Stock stock = db.Stocks.Find(detail.Item_ID); if (stock != null) { stock.Qty = stock.Qty + detail.Qty; db.Entry(stock).State = EntityState.Modified; } } db.SaveChanges(); return(RedirectToAction("Index", "Stocks")); }
public async Task <ActionResult <PO_Header> > PostPO_Header(PO_Header pO_Header) { _context.PO_Headers.Add(pO_Header); await _context.SaveChangesAsync(); return(CreatedAtAction("GetPO_Header", new { id = pO_Header.PO_SupplyID }, pO_Header)); }
public async Task <IActionResult> PutPO_Header(string id, PO_Header pO_Header) { if (id != pO_Header.PO_SupplyID) { return(BadRequest()); } _context.Entry(pO_Header).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!PO_HeaderExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
private void BindPOList() { var dt = PO_Header.RetrieveData(oCon, txtSearchItem.Text); grvPOList.DataSource = dt; grvPOList.DataBind(); }
public POModel Create(PO_Header po) { var mapper = MapInit.MapInitialize().CreateMapper(); POModel dto = mapper.Map <POModel>(po); dto.Url = _UrlHelper.Link("PO", new { id = po.PONumber }); return(dto); }
public ActionResult DeleteConfirmed(int id) { PO_Header pO_Header = db.PO_Header.Find(id); db.PO_Header.Remove(pO_Header); db.SaveChanges(); return(RedirectToAction("Index")); }
protected void GetPO() { var ldata = PO_Header.RetrieveData(oCon, txtSearch.Text.Trim()); grvMainPO.DataSource = ldata; grvMainPO.DataBind(); grvMainPO.GridLines = GridLines.None; }
public ActionResult Edit([Bind(Include = "PO_ID,PO_Number,Supplier,Date,Amount")] PO_Header pO_Header) { if (ModelState.IsValid) { db.Entry(pO_Header).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(pO_Header)); }
// GET: PO/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } PO_Header pO_Header = db.PO_Header.Find(id); if (pO_Header == null) { return(HttpNotFound()); } return(View(pO_Header)); }
//public ActionResult Create([Bind(Include = "PO_ID,PO_Number,Supplier,Date,Amount")] PO_Header pO_Header, List<PO_Detail> pO_Details) public ActionResult Create(PO_Header pO_Header, List <PO_Detail> pO_Details) { if (ModelState.IsValid) { db.PO_Header.Add(pO_Header); db.SaveChanges(); int id = db.PO_Header.FirstOrDefault(s => s.PO_Number == pO_Header.PO_Number).PO_ID; foreach (var detail in pO_Details) { detail.PO_ID = id; } db.PO_Detail.AddRange(pO_Details); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(pO_Header)); }
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 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(); }