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