public static PurchaseViewModel Detach(IMSBIZZ.DAL.DBModel.Purchase purchase)
{
PurchaseViewModel purchaseViewModel = new PurchaseViewModel();
return(purchaseViewModel);
}
public static IMSBIZZ.DAL.DBModel.Purchase Attach(PurchaseServiceViewModel purchaseViewModel)
{
IMSBIZZ.DAL.DBModel.Purchase purchase = new IMSBIZZ.DAL.DBModel.Purchase();
int CompanyId = Convert.ToInt32(purchaseViewModel.CompanyId);
int BranchId = Convert.ToInt32(purchaseViewModel.BranchId);
purchase.CompanyId = CompanyId;
purchase.BranchId = BranchId;
purchase.FinancialyearId = purchaseViewModel.FinancialYearId;
purchase.InvoiceNumber = purchaseViewModel.InvoiceNumber;
purchase.PaymentModeId = purchaseViewModel.PaymentModeId;
purchase.PartyId = purchaseViewModel.PartyId;
purchase.PoDate = purchaseViewModel.PODate;
purchase.PoNo = purchaseViewModel.PONo;
purchase.Note = purchaseViewModel.Note;
purchase.OtherExpenses = purchaseViewModel.OtherExpenses;
purchase.CreatedBy = purchaseViewModel.CreatedBy;
purchase.CreatedOn = purchaseViewModel.CreatedDate;
//insert into Purchase Payment Details
PurchasePaymentDetial purchasePaymentDetail = new PurchasePaymentDetial();
purchasePaymentDetail.TaxAmount = purchaseViewModel.TaxAmount;
purchasePaymentDetail.DiscountAmount = purchaseViewModel.DiscountAmount;
purchasePaymentDetail.SubTotal = purchaseViewModel.SubTotal;
purchasePaymentDetail.GrandTotal = purchaseViewModel.GrandTotal;
purchasePaymentDetail.PaidAmnt = purchaseViewModel.PaidAmnt;
purchasePaymentDetail.GivenAmnt = purchaseViewModel.GivenAmnt;
purchasePaymentDetail.BalanceAmnt = purchaseViewModel.BalanceAmnt;
purchasePaymentDetail.FromTable = purchaseViewModel.FromTable;
purchase.PurchasePaymentDetials.Add(purchasePaymentDetail);
foreach (var purchaseDetail in purchaseViewModel.PurchaseDetailsViewModel)
{
int productId = Convert.ToInt32(purchaseDetail.ProductId);
int batchId = Convert.ToInt32(purchaseDetail.BatchId);
var qty = purchaseDetail.Quantity;
//Add into Purchase Details table for each product
PurchaseDetail purchaseDetails = new PurchaseDetail();
purchaseDetails.ProductId = productId;
purchaseDetails.BatchId = batchId;
purchaseDetails.UnitId = purchaseDetail.UnitId;
purchaseDetails.TaxAmnt = purchaseDetail.TaxAmnt;
purchaseDetails.DiscountAmnt = purchaseDetail.DiscountAmnt;
purchaseDetails.Quantity = qty;
purchaseDetails.Amount = purchaseDetail.Amount;
purchaseDetails.PurchaseRate = purchaseDetail.PurchaseRate;
purchaseDetails.SaleRate = purchaseDetail.SaleRate;
purchaseDetails.Amount = purchaseDetail.Amount;
purchaseDetails.DiscountPercent = purchaseDetail.DiscountPercentage;
purchaseDetails.TaxPercent = purchaseDetail.TotalTaxPercentage;
var groupId = purchaseDetail.GroupId;
//insert into tax group purchase
PurchaseTaxGroup purchaseTaxGroup = new PurchaseTaxGroup();
purchaseTaxGroup.TaxGroupId = groupId;
purchaseTaxGroup.ProductId = productId;
foreach (var taxType in purchaseDetail.TaxGroupDetailsViewModel)
{
PurchaseTaxgroupDetail purchaseTaxDetails = new PurchaseTaxgroupDetail();
purchaseTaxDetails.TypeId = taxType.TypeId;
purchaseTaxDetails.TaxPercentage = taxType.TaxPercentage;
purchaseTaxGroup.PurchaseTaxgroupDetails.Add(purchaseTaxDetails);
}
purchase.PurchaseTaxGroups.Add(purchaseTaxGroup);
purchase.PurchaseDetails.Add(purchaseDetails);
}
return(purchase);
}