void addPurchaseDetailsData() { foreach (DataGridViewRow dr in dgSalesItem.Rows) { if (Convert.ToString(dr.Cells[0].Value) != string.Empty) { _entities = new MicroAccountsEntities1(); tbl_SalesDetails salesDetails = new tbl_SalesDetails(); salesDetails.salesId = _entities.tbl_SalesMaster.Where(x => x.billNo == txtBillNo.Text).FirstOrDefault().sId; var gridItemCode = dr.Cells[1].Value.ToString(); salesDetails.productId = _entities.tbl_ItemMaster.Where(x => x.itemCode == gridItemCode).FirstOrDefault().id; salesDetails.qty = Convert.ToDecimal(dr.Cells[2].Value.ToString()); salesDetails.weight = Convert.ToDecimal(dr.Cells[3].Value.ToString()); salesDetails.unit = dr.Cells[4].Value.ToString(); salesDetails.karat = Convert.ToDecimal(dr.Cells[5].Value.ToString()); salesDetails.making = Convert.ToDecimal(dr.Cells[6].Value.ToString()); salesDetails.rate = Convert.ToDecimal(dr.Cells[7].Value.ToString()); salesDetails.createdDate = DateTime.Now; _entities.tbl_SalesDetails.Add(salesDetails); _entities.SaveChanges(); //Update Qty in stock var itemQty = _entities.tbl_StockItemDetails.Where(x => x.itemId == salesDetails.productId).FirstOrDefault(); itemQty.qty = itemQty.qty - salesDetails.qty; itemQty.upadtedDate = DateTime.Now; _entities.SaveChanges(); } } }
public void AddSalesDetails(SalesDetailsViewModel entity) { var data = new tbl_SalesDetails { SalesDetailsId = entity.salesDetailsId, SalesTypeId = entity.salesTypeId, ProductId = entity.productId, StockId = entity.stockId, CustomerId = entity.customerId, Quantity = entity.quantity, SalesPrice = entity.salesPrice, AmountRecieved = entity.amountRecieved, SuppliedBy = entity.suppliedBy, SalesDate = entity.salesDate, PaymentId = entity.paymentId, BatchNo = reference.ConfirmReferenceNo((int)ReferenceTypesEnum.Invoice, 1), BranchId = entity.branchId }; context.tbl_SalesDetails.Add(data); //context.SaveChanges(); var pay = new PaymentViewModel { batchNo = data.BatchNo, recievedAmount = data.AmountRecieved, actualAmount = data.tbl_Payment.ActualAmount, paymentDate = data.SalesDate, paymentModeId = data.tbl_Payment.PaymentModeId, paymentMode = data.tbl_Payment.tbl_PaymentMode.PaymentMode, transactionStatus = data.tbl_Payment.tbl_TransactionStatus.TransactionStatus, transactionStatusId = data.tbl_Payment.TransactionStatusId, createdBy = data.tbl_Payment.CreatedBy, createdOn = data.tbl_Payment.CreatedOn, }; payment.AddPayments(pay); //return entity; }