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