public PurchaseRequestDetails Add(PurchaseRequestDetails PRD)
{
var sqlQuery = @"INSERT INTO PURCHASEREQUESTDETAILS (IDPURCHASEREQUEST, ITEMCODE, QUANTITY, UOM, EXPECTDATE, MANAGEBY, ESTIMATEPRICE, REMARK, APPROVEQUANTITY, COMPANYSITE, INPUTBY, INPUTDATE, UPDATEBY, UPDATEDATE) VALUES
(" + PRD.IDPURCHASEREQUEST + @", " + PRD.ITEMCODE + ", '" + PRD.QUANTITY + "', '" + PRD.UOM + "', '" + PRD.EXPECTDATE + "', '" + PRD.MANAGEBY + "', '" + PRD.ESTIMATEPRICE + "', '" + PRD.REMARKS + "', '" + PRD.APPROVEQUANTITY + "', '" + PRD.COMPANYSITE + @"', " + PRD.INPUTBY + ", '" + PRD.INPUTDATE + @"', " + PRD.UPDATEBY + ", '" + PRD.UPDATEDATE + @"'); " + "SELECT CAST(SCOPE_IDENTITY() as int)";
var SID = _db.Query <int>(sqlQuery, PRD).Single();
PRD.SID = SID;
return(PRD);
}
public JsonResult Edit(PurchaseRequestDetails PurchaseRequestDetails)
{
try
{
if (ModelState.IsValid)
{
PurchaseRequestDetails.UPDATEBY = int.Parse(Session["userid"].ToString());
PurchaseRequestDetails.UPDATEDATE = DateTime.Now;
PRD.Update(PurchaseRequestDetails);
}
}
catch (Exception ex)
{
return(Json("error"));
}
return(Json("success"));
}
private void dgvPurchaseRequest_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (e.ColumnIndex == 7)
{
int rowIndex = dgvPurchaseRequest.CurrentCell.RowIndex;
//Session.Edit = true;
var purchaseRequest = dgvPurchaseRequest.CurrentRow.DataBoundItem;
PurchaseRequestDTO purRequest = (PurchaseRequestDTO)purchaseRequest;
var _loginData = purRequest;
var solicitudCompraDetalles = new PurchaseRequestDetails(_loginData);
solicitudCompraDetalles.Show();
this.Close();
}
}
public PurchaseRequestDetails Update(PurchaseRequestDetails PRD)
{
var sqlQuery =
"UPDATE PURCHASEREQUESTDETAILS " +
"SET IDPURCHASEREQUEST = '" + PRD.IDPURCHASEREQUEST + "', " +
" ITEMCODE = '" + PRD.ITEMCODE + "', " +
" QUANTITY = '" + PRD.QUANTITY + "', " +
" UOM = '" + PRD.UOM + "', " +
" EXPECTDATE = '" + PRD.EXPECTDATE + "', " +
" MANAGEBY = '" + PRD.MANAGEBY + "', " +
" ESTIMATEPRICE = '" + PRD.ESTIMATEPRICE + "', " +
" REMARK = '" + PRD.REMARKS + "', " +
" APPROVEQUANTITY = '" + PRD.APPROVEQUANTITY + "', " +
" UPDATEBY = '" + Convert.ToInt32(PRD.UPDATEBY) + "', " +
" UPDATEDATE = '" + PRD.UPDATEDATE + "' " +
"WHERE SID = " + PRD.SID + "";
this._db.Execute(sqlQuery, PRD);
return(PRD);
}
public JsonResult Create(PurchaseRequestDetails PurchaseRequestDetails)
{
try
{
if (ModelState.IsValid)
{
PurchaseRequestDetails.COMPANYSITE = int.Parse(Session["companysite"].ToString());
PurchaseRequestDetails.INPUTBY = int.Parse(Session["userid"].ToString());
PurchaseRequestDetails.INPUTDATE = DateTime.Now;
PurchaseRequestDetails.UPDATEBY = int.Parse(Session["userid"].ToString());
PurchaseRequestDetails.UPDATEDATE = DateTime.Now;
PRD.Add(PurchaseRequestDetails);
}
}
catch (Exception ex)
{
return(Json("error"));
}
return(Json("success"));
}
public async Task <IActionResult> CreatePR(PurchaseRequestVM requestVM)//, string purchasedate, string supplierid, string paid, string remaining)//, [Bind("ItemId", "PurchasePrice", "PurchaseQuantity")] PurchaseRequestDetails[] purchaserequestdetails)
{
//if (requestVM != null)
//{ PurchaseRequestVM itm = (PurchaseRequestVM)requestVM; }
string result = "Error! Order Is Not Complete! " + requestVM.InvoiceNumber;
if (requestVM != null && requestVM.PurchaseRequestDetails != null)
{
PurchaseRequest purchaseRequest = new PurchaseRequest();
purchaseRequest.InvoiceNumber = requestVM.InvoiceNumber;
purchaseRequest.SupplierId = requestVM.SupplierId;
purchaseRequest.Paid = requestVM.Paid;
purchaseRequest.Remaining = requestVM.Remaining;
purchaseRequest.CreationDate = DateTime.Now;
purchaseRequest.PurchaseDate = requestVM.PurchaseDate;
purchaseRequest.UserId = _userManager.GetUserId(User);
var Pr = _context.PurchaseRequest.Add(purchaseRequest);
// add header success
if (await _context.SaveChangesAsync() > 0)
{
// 1- Update Customer Balances
var supp = _context.Suppliers.FirstOrDefault(sId => sId.Id == requestVM.SupplierId);
if (supp != null)
{
supp.TotalPaid = (supp.TotalPaid == null ? 0 : supp.TotalPaid) + requestVM.Paid;
supp.TotalRemaining = (supp.TotalRemaining == null ? 0 : supp.TotalRemaining) + requestVM.Remaining;
_context.Suppliers.Update(supp);
}
foreach (var item in requestVM.PurchaseRequestDetails)
{
PurchaseRequestDetails requestDetails = new PurchaseRequestDetails();
requestDetails.ItemId = item.ItemId;
requestDetails.PurchasePrice = item.PurchasePrice;
requestDetails.PurchaseQuantity = item.PurchaseQuantity;
requestDetails.CreationDate = DateTime.Now;
requestDetails.PurchaseRequestId = Pr.Entity.Id;
requestDetails.UserId = _userManager.GetUserId(User);
_context.PurchaseRequestDetails.Add(requestDetails);
// 2- Update Items Balances
var Newitem = _context.StoreItems.FirstOrDefault(sId => sId.Id == item.ItemId);
if (Newitem != null)
{
Newitem.TodayPrice = item.PurchasePrice;
Newitem.Quantity = (Newitem.Quantity == null ? 0 : Newitem.Quantity) + item.PurchaseQuantity;
_context.StoreItems.Update(Newitem);
}
}
if (await _context.SaveChangesAsync() > 0)
{
result = "Success! Order Is Complete!";
}
}
}
return(Json(result));
}
