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