protected virtual void ClearNavigationProperties() { Address = null; Address1 = null; Customer = null; SalesOrderDetails.Clear(); }
public async Task <IActionResult> PutSalesOrderDetails(int id, SalesOrderDetails salesOrderDetails) { if (id != salesOrderDetails.ID) { return(BadRequest()); } _context.Entry(salesOrderDetails).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!SalesOrderDetailsExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <ActionResult <SalesOrderDetails> > PostSalesOrderDetails(SalesOrderDetails salesOrderDetails) { _context.SalesOrder_Details.Add(salesOrderDetails); await _context.SaveChangesAsync(); return(CreatedAtAction("GetSalesOrderDetails", new { id = salesOrderDetails.ID }, salesOrderDetails)); }
private void BindSaleaOrderDetails() { SalesOrderDetails salesOrder = new SalesOrderDetails(); DataTable dsSalesOrderDetails = salesOrder.GetSalesOrderDetails("SOHeader", "pSOHeaderID,SellToCustNo,SellToCustName,SellToAddress1,SellToAddress2,SellToAddress3,SellToCity,SellToState,SellToZip,SellToCountry,SellToContactName,SellToContactPhoneNo,ShipToName,ShipToAddress1,City,State,PhoneNo,Zip,Country", "pSOHeaderID=" + SoNumber); if (dsSalesOrderDetails != null) { lblSold_Name.Text = dsSalesOrderDetails.Rows[0]["SellToCustName"].ToString().Trim(); lblSold_Contact.Text = dsSalesOrderDetails.Rows[0]["SellToAddress1"].ToString().Trim(); lblSold_City.Text = dsSalesOrderDetails.Rows[0]["SellToCity"].ToString().Trim(); lblSold_Territory.Text = dsSalesOrderDetails.Rows[0]["SellToState"].ToString().Trim(); lblSold_Phone.Text = dsSalesOrderDetails.Rows[0]["SellToContactPhoneNo"].ToString().Trim(); lblSold_Pincode.Text = dsSalesOrderDetails.Rows[0]["SellToZip"].ToString().Trim(); lblSoldCom.Visible = ((lblSold_City.Text.Trim() != "" && lblSold_Territory.Text.Trim() != "") ? true : false); lblSoldCountry.Text = dsSalesOrderDetails.Rows[0]["SellToCountry"].ToString().Trim(); lblShip_Name.Text = dsSalesOrderDetails.Rows[0]["ShipToName"].ToString().Trim(); lblShip_Contact.Text = dsSalesOrderDetails.Rows[0]["ShipToAddress1"].ToString().Trim(); lblShip_City.Text = dsSalesOrderDetails.Rows[0]["City"].ToString().Trim(); lblShip_State.Text = dsSalesOrderDetails.Rows[0]["State"].ToString().Trim(); lblShip_Phone.Text = dsSalesOrderDetails.Rows[0]["PhoneNo"].ToString().Trim(); lblShip_Pincode.Text = dsSalesOrderDetails.Rows[0]["Zip"].ToString().Trim(); lblShipCom.Visible = ((lblShip_City.Text.Trim() != "" && lblShip_State.Text.Trim() != "") ? true : false); lblShipCountry.Text = dsSalesOrderDetails.Rows[0]["Country"].ToString().Trim(); lblSoldCustNum.Text = dsSalesOrderDetails.Rows[0]["SellToCustNo"].ToString().Trim(); lblShipCustNum.Text = dsSalesOrderDetails.Rows[0]["SellToCustNo"].ToString().Trim(); } }
private void btn_Savebuy_Click(object sender, EventArgs e) { if (dgv_SalesBillbuy.SelectedRows.Count == 0) { MessageBoxIcon.Warning.ToString(); MessageBox.Show("قائمة المنتجات فارغة"); } else { //numTotalCost.Value = decimal.Parse(numTotalCost.Value.ToString()); //numResCost.Value = numTotalCost.Value - numericPaiedCost.Value; SalesOrder salesOrder = new SalesOrder(); salesOrder.SalesRepresentative_id = int.Parse(cmb_companyName.SelectedValue.ToString()); // check==> salesOrder.salesRepresentative_ID = int.Parse(cmb_companyName.SelectedValue.ToString()); salesOrder.SalesOrderDate = dtp_BillDate.Value; salesOrder.SalesOrederTotalPrice = double.Parse(numericResCostbuy.Value.ToString()); salesOrder.status = false; context.SalesOrder.Add(salesOrder); context.SaveChanges(); context = new store(); ///sales order payment SalesOredersPaymment oredersPaymment = new SalesOredersPaymment(); oredersPaymment.Paied = double.Parse(numericPaiedCostbuy.Value.ToString()); oredersPaymment.Rest = double.Parse(numericResCostbuy.Value.ToString()); oredersPaymment.SalesOrder_id = salesOrder.ID; context.SalesOredersPaymments.Add(oredersPaymment); context.SaveChanges(); context = new store(); for (var item = 0; item < dgv_SalesBillbuy.Rows.Count - 1; item++) { SalesOrderDetails orderDetail = new SalesOrderDetails(); orderDetail.products_id = int.Parse(dgv_SalesBillbuy.Rows[item].Cells[4].Value.ToString()); orderDetail.quantity = int.Parse(dgv_SalesBillbuy.Rows[item].Cells[2].Value.ToString()); orderDetail.salesOrder_id = salesOrder.ID; context.SalesOrderDetails.Add(orderDetail); } context.SaveChanges(); context = new store(); for (var item = 0; item <= dgv_SalesBillbuy.Rows.Count - 1; item++) { int pidd = Int32.Parse(dgv_SalesBillbuy.Rows[item].Cells[4].Value.ToString()); Products product = context.products.FirstOrDefault(d => d.ID == pidd); product.quantityPerProducts += int.Parse(dgv_SalesBillbuy.Rows[item].Cells[2].Value.ToString()); } context.SaveChanges(); MessageBox.Show("تم العمليه بنجاح"); clearFields(); } }
public SalesOrderDetails Update(SalesOrderDetails model) { var item = db.SalesOrderDetails.Find(model.Id); var product = productService.Find(x => x.ProductName == model.ProductName); item.ProductName = product.ProductName; item.PurchaseAmount = product.PurchaseAmount; item.SellingPrice = product.SellingAmount; item.Sku = product.SKU; item.Qty = model.Qty; db.SaveChanges(); return(model); }
public IActionResult Index(SalesOrderDetails item) { try { if (ModelState.IsValid) { } } catch (Exception e) { Console.WriteLine(e); throw; } return(View(item)); }
public SalesOrderDetails Insert(SalesOrderDetails model) { var product = productService.Find(x => x.ProductName == model.ProductName); model.Sku = product.SKU; model.PurchaseAmount = product.PurchaseAmount; model.SellingPrice = product.SellingAmount; model.Id = Guid.NewGuid().ToString(); db.SalesOrderDetails.Add(model); var so = db.SalesOrders.FirstOrDefault(x => x.Id == model.SalesOrderId); db.SaveChanges(); so.TotalAmount = db.SalesOrderDetails.Where(x => x.SalesOrderId == model.SalesOrderId).Sum(x => x.SubTotal ?? 0); db.SaveChanges(); return(model); }
private void btn_Save_Click(object sender, EventArgs e) { double totalCost = 0; for (var item = 0; item < dgv_SalesBill.Rows.Count - 1; item++) { totalCost += double.Parse(dgv_SalesBill.Rows[item].Cells[1].Value.ToString()) * double.Parse(dgv_SalesBill.Rows[item].Cells[2].Value.ToString()) - double.Parse(dgv_SalesBill.Rows[item].Cells[0].Value.ToString()); } numericTotalCost.Value = decimal.Parse(totalCost.ToString()); numericResCost.Value = numericTotalCost.Value - numericPaiedCost.Value; SalesOrder salesOrder = new SalesOrder(); salesOrder.customers_Id = context.customers.FirstOrDefault(c => c.Name == cmb_CustomerName.Text).ID; salesOrder.SalesOrderDate = dtp_BillDate.Value; salesOrder.SalesOrederTotalPrice = double.Parse(numericTotalCost.Value.ToString()); // salesOrder.SalesRepresentative.ID = context.SalesRepresentatives.FirstOrDefault(s => s.ID == int.Parse(mandobCompobox.SelectedValue.ToString())).ID; context.SalesOrder.Add(salesOrder); context.SaveChanges(); context = new store(); ///sales order payment SalesOredersPaymment salesOredersPaymment = new SalesOredersPaymment(); salesOredersPaymment.Paied = double.Parse(numericPaiedCost.Value.ToString()); salesOredersPaymment.Rest = double.Parse(numericResCost.Value.ToString()); salesOredersPaymment.SalesOrder_id = salesOrder.ID; context.SalesOredersPaymments.Add(salesOredersPaymment); context.SaveChanges(); context = new store(); for (var item = 0; item < dgv_SalesBill.Rows.Count - 1; item++) { SalesOrderDetails salesOrderDetails = new SalesOrderDetails(); salesOrderDetails.products_id = int.Parse(dgv_SalesBill.Rows[item].Cells[4].Value.ToString()); salesOrderDetails.quantity = int.Parse(dgv_SalesBill.Rows[item].Cells[2].Value.ToString()); salesOrderDetails.salesOrder_id = salesOrder.ID; var product = context.products.FirstOrDefault(p => p.ID == salesOrderDetails.products_id); product.quantityPerProducts -= salesOrderDetails.quantity; context.SalesOrderDetails.Add(salesOrderDetails); } context.SaveChanges(); MessageBox.Show("تم العمليه بنجاح"); }
public Response SavedSalesOrderDetails(System.Collections.ArrayList paramList) { if (paramList.Count > 0) { CustomerMeasurement Measurment = Newtonsoft.Json.JsonConvert.DeserializeObject <CustomerMeasurement>(paramList[0].ToString()); CustomerStyle Style = Newtonsoft.Json.JsonConvert.DeserializeObject <CustomerStyle>(paramList[1].ToString()); CustomerBodyPosture Posture = Newtonsoft.Json.JsonConvert.DeserializeObject <CustomerBodyPosture>(paramList[2].ToString()); SalesOrderDetails OrderDetails = Newtonsoft.Json.JsonConvert.DeserializeObject <SalesOrderDetails>(paramList[3].ToString()); return(new Response { Result = true, Message = "Temporary Saved !", Value = 1 }); } else { return(new Response { Result = false, Message = "Failed", Value = 0 }); } }
protected virtual void ClearNavigationProperties() { ProductCategory = null; ProductModel = null; SalesOrderDetails.Clear(); }