public List<Installments> DeleteDeleteInstallment(long Id, long bulkBuyID) { List<Installments> lstinstallments = new List<Installments>(); using (ShopDevEntities db = new ShopDevEntities()) { try { BulkBuyInstallment installment = GetInstallment(db, Id); var bulkbuy = db.BulkBuys.Where(m => m.BulkBuyID == bulkBuyID).FirstOrDefault(); var outstandingAmount = bulkbuy.OustandingAmont; bulkbuy.OustandingAmont = outstandingAmount == null ? installment.Amount : outstandingAmount + installment.Amount; var interstableAmount = bulkbuy.InterstableAmount; bulkbuy.InterstableAmount = interstableAmount == null ? installment.Amount : interstableAmount + installment.Amount; db.BulkBuyInstallments.Remove(installment); db.SaveChanges(); var lstproducts = db.BulkBuyInstallments.Where(m => m.BulkBuyID == bulkBuyID).ToList(); foreach (var cusprod in lstproducts) { Installments objInstallments = new Installments(); cusprod.CopyProperties(objInstallments); lstinstallments.Add(objInstallments); } } catch (Exception) { } return lstinstallments; } }
public BulkBuyInstallment GetInstallment(ShopDevEntities db, long Id) { BulkBuyInstallment objinstllment = null; try { objinstllment = db.BulkBuyInstallments.Where(m => m.InstallmentID == Id).FirstOrDefault(); } catch (Exception) { } return objinstllment; }
public Installments GetInstallmentDetails(long Id) { Installments objModel = new Installments(); using (ShopDevEntities db = new ShopDevEntities()) { try { BulkBuyInstallment installment = GetInstallment(db, Id); installment.CopyProperties(objModel); } catch (Exception) { } } return objModel; }
// installments public List<Installments> AddInstallment(Installments installment) { List<Installments> lstAllinstallments = new List<Installments>(); using (ShopDevEntities db = new ShopDevEntities()) { try { installment.BulkBuyID = installment.BulkBuyID == null ? 0 : installment.BulkBuyID; BulkBuyInstallment bulkinstDetail = null; if (installment.InstallmentID > 0) { bulkinstDetail = db.BulkBuyInstallments.Where(m => m.InstallmentID == installment.InstallmentID).FirstOrDefault(); } else { bulkinstDetail = new BulkBuyInstallment(); } installment.CopyProperties(bulkinstDetail); if (installment.InstallmentID == 0) { var bulkBuy = db.BulkBuys.Where(m => m.BulkBuyID == installment.BulkBuyID).FirstOrDefault(); if (bulkBuy.InterstableAmount > 0) { if (bulkBuy.Interest != null && bulkBuy.Interest != 0) { if (installment.Amount > bulkBuy.Interest) { var interest = bulkBuy.Interest; bulkBuy.OustandingAmont -= installment.Amount - interest; bulkBuy.Interest = 0; var interstableAmount = bulkBuy.InterstableAmount; bulkBuy.InterstableAmount = interstableAmount == null ? installment.Amount - interest : interstableAmount - (installment.Amount - interest); bulkinstDetail.Description = "Amount cut for Interset" + Convert.ToString(interest) + " and adjust for amunt is " + Convert.ToString(installment.Amount - interest); } else { bulkBuy.Interest -= installment.Amount; bulkinstDetail.Description = "Amount cut for Interset" + Convert.ToString(installment.Amount) + " and adjust for amunt is 0"; } } else { bulkBuy.OustandingAmont -= installment.Amount; bulkBuy.InterstableAmount -= installment.Amount; bulkinstDetail.Description = "Amount cut for Interset 0 and adjust for amunt is " + Convert.ToString(installment.Amount); } bulkBuy.LastInstallmentDate = DateTime.Now; db.SaveChanges(); } db.BulkBuyInstallments.Add(bulkinstDetail); } db.SaveChanges(); var lstinstallments = db.BulkBuyInstallments.Where(m => m.BulkBuyID == installment.BulkBuyID).ToList(); foreach (var cusprod in lstinstallments) { Installments objcsproduct = new Installments(); cusprod.CopyProperties(objcsproduct); lstAllinstallments.Add(objcsproduct); } } catch { } return lstAllinstallments; } }