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