public IFluentSupplierLedger CreateEntityByView(SupplierLedgerView view)
{
try
{
//SupplierLedger supplierLedger = new SupplierLedger();
Task <SupplierLedger> supplierLedgerQueryTask = Task.Run(async() => await unitOfWork.supplierLedgerRepository.GetEntityByView(view));
Task.WaitAll(supplierLedgerQueryTask);
if (supplierLedgerQueryTask.Result == null)
{
SupplierLedger supplierLedger = MapToEntity(view);
AddSupplierLedger(supplierLedger);
processStatus = CreateProcessStatus.Insert;
return(this as IFluentSupplierLedger);
}
processStatus = CreateProcessStatus.AlreadyExists;
return(this as IFluentSupplierLedger);
}
catch (Exception ex)
{ throw new Exception("CreateEntityByView", ex); }
}
private SupplierLedger MapToEntity(SupplierLedgerView inputObject)
{
Mapper mapper = new Mapper();
SupplierLedger outObject = mapper.Map <SupplierLedger>(inputObject);
return(outObject);
}
public IFluentSupplierLedger UpdateEntityByView(SupplierLedgerView supplierLedgerView)
{
try
{
Task <SupplierLedger> supplierLedgerBaseTask = Task.Run(async() => await unitOfWork.supplierLedgerRepository.GetEntityById(supplierLedgerView.SupplierLedgerId));
Task.WaitAll(supplierLedgerBaseTask);
SupplierLedger supplierLedgerBase = supplierLedgerBaseTask.Result;
if (supplierLedgerBase != null)
{
applicationViewFactory.MapSupplierLedgerEntity(ref supplierLedgerBase, supplierLedgerView);
UpdateSupplierLedger(supplierLedgerBase);
processStatus = CreateProcessStatus.Update;
return(this as IFluentSupplierLedger);
}
processStatus = CreateProcessStatus.Failed;
return(this as IFluentSupplierLedger);
}
catch (Exception ex)
{
throw new Exception("UpdateEntityByView", ex);
}
}
public ActionResult AddSupplier(Supplier supplier)
{
SupplierLedger aSupplierLedger = new SupplierLedger();
List <Supplier> supplierList = new List <Supplier>();
if (supplier.SupplierID <= 0 && supplier.SupplierName != null && supplier.SupplierPhone != null)
{
var PhoneExist = db.Supplier.Where(c => c.SupplierPhone == supplier.SupplierPhone).FirstOrDefault();
if (PhoneExist == null)
{
//var companyName = db.Company.Where(c => c.CompanyID == customer.CompanyID).Select(g => new { Name = g.CompanyName }).First();
//var groupName = db.Group.Where(c => c.GroupID == customer.GroupID).Select(g => new { Name = g.GroupName }).First();
int?MaxId = db.Supplier.Max(x => (int?)x.SupplierID);
if (MaxId == null)
{
MaxId = 0;
}
var id = MaxId + 1;
if (supplier.SupplierPreviousDue == null || supplier.SupplierPreviousDue == 0)
{
supplier.SupplierPreviousDue = 0;
aSupplierLedger.IsPreviousDue = 0;
}
else
{
aSupplierLedger.IsPreviousDue = 1;
}
string date = DateTime.Now.ToString("M/d/yyyy");
var NowDate = Convert.ToDateTime(date);
aSupplierLedger.ReceiveDate = NowDate;
aSupplierLedger.InvoiceNo = "Previous Due";
aSupplierLedger.Remarks = "Previous Due";
aSupplierLedger.Debit = 0;
aSupplierLedger.Credit = supplier.SupplierPreviousDue;
aSupplierLedger.SupplierID = Convert.ToInt32(id);
db.Supplier.Add(supplier);
db.SupplierLedger.Add(aSupplierLedger);
db.SaveChanges();
supplierList = db.Supplier.ToList();
ViewBag.Message = 1;
}
else
{
supplierList = db.Supplier.ToList();
ViewBag.Message = 0;
}
}
else
{
supplierList = db.Supplier.ToList();
ViewBag.Message = 2;
}
ViewBag.Suppliergroup = db.SupplierGroup.ToList();
return(View(supplierList));
}
public async Task <IActionResult> DeleteSupplierLedger([FromBody] SupplierLedgerView view)
{
SupplierLedgerModule invMod = new SupplierLedgerModule();
SupplierLedger supplierLedger = await invMod.SupplierLedger.Query().MapToEntity(view);
invMod.SupplierLedger.DeleteSupplierLedger(supplierLedger).Apply();
return(Ok(view));
}
public async Task TestAddUpdatDelete()
{
SupplierLedgerModule SupplierLedgerMod = new SupplierLedgerModule();
Supplier supplier = await SupplierLedgerMod.Supplier.Query().GetEntityById(3);
Invoice invoice = await SupplierLedgerMod.Invoice.Query().GetEntityById(2);
AccountPayable accountPayable = await SupplierLedgerMod.AccountPayable.Query().GetEntityById(2);
GeneralLedger generalLedger = await SupplierLedgerMod.GeneralLedger.Query().GetEntityById(17);
AddressBook addressBook = await SupplierLedgerMod.AddressBook.Query().GetEntityById(17);
SupplierLedgerView view = new SupplierLedgerView()
{
SupplierId = supplier.SupplierId,
InvoiceId = invoice.InvoiceId,
AcctPayId = accountPayable.AccountPayableId,
Amount = 300M,
Gldate = DateTime.Parse("11/11/2019"),
AccountId = generalLedger.AccountId,
GeneralLedgerId = generalLedger.GeneralLedgerId,
DocNumber = 17,
Comment = "back to school",
AddressId = addressBook.AddressId,
CreatedDate = DateTime.Parse("11/11/2019"),
DocType = "PV",
DebitAmount = null,
CreditAmount = null,
FiscalYear = 2019,
FiscalPeriod = 11
};
NextNumber nnNextNumber = await SupplierLedgerMod.SupplierLedger.Query().GetNextNumber();
view.SupplierLedgerNumber = nnNextNumber.NextNumberValue;
SupplierLedger supplierLedger = await SupplierLedgerMod.SupplierLedger.Query().MapToEntity(view);
SupplierLedgerMod.SupplierLedger.AddSupplierLedger(supplierLedger).Apply();
SupplierLedger newSupplierLedger = await SupplierLedgerMod.SupplierLedger.Query().GetEntityByNumber(view.SupplierLedgerNumber);
Assert.NotNull(newSupplierLedger);
newSupplierLedger.Comment = "back to school update";
SupplierLedgerMod.SupplierLedger.UpdateSupplierLedger(newSupplierLedger).Apply();
SupplierLedgerView updateView = await SupplierLedgerMod.SupplierLedger.Query().GetViewById(newSupplierLedger.SupplierLedgerId);
Assert.Same(updateView.Comment, "back to school update");
SupplierLedgerMod.SupplierLedger.DeleteSupplierLedger(newSupplierLedger).Apply();
SupplierLedger lookupSupplierLedger = await SupplierLedgerMod.SupplierLedger.Query().GetEntityById(view.SupplierLedgerId);
Assert.Null(lookupSupplierLedger);
}
private void ShowSupplierForm()
{
SupplierLedger Itm = new SupplierLedger();
Itm.TopLevel = false;
this.Controls.Add(Itm);
Itm.FormBorderStyle = System.Windows.Forms.FormBorderStyle.None;
Itm.Dock = DockStyle.Fill;
Itm.BringToFront();
Itm.Show();
}
public async Task <IActionResult> UpdateSupplierLedger([FromBody] SupplierLedgerView view)
{
SupplierLedgerModule invMod = new SupplierLedgerModule();
SupplierLedger supplierLedger = await invMod.SupplierLedger.Query().MapToEntity(view);
invMod.SupplierLedger.UpdateSupplierLedger(supplierLedger).Apply();
SupplierLedgerView retView = await invMod.SupplierLedger.Query().GetViewById(supplierLedger.SupplierLedgerId);
return(Ok(retView));
}
public ActionResult EditSupplierLedger(int Id)
{
var select = db.SupplierLedger.Where(a => a.ID == Id).First();
var due = db.Supplier.Where(a => a.SupplierID == select.SupplierID).First();
SupplierLedger aSupplierLedger = new SupplierLedger()
{
ID = select.ID,
SupplierID = select.SupplierID,
ReceiveDate = select.ReceiveDate,
PreviouaDue = due.SupplierPreviousDue,
Debit = select.Debit,
Remarks = select.Remarks
};
return(Json(aSupplierLedger, JsonRequestBehavior.AllowGet));
}
public async Task <IActionResult> AddSupplierLedger([FromBody] SupplierLedgerView view)
{
SupplierLedgerModule invMod = new SupplierLedgerModule();
NextNumber nnSupplierLedger = await invMod.SupplierLedger.Query().GetNextNumber();
view.SupplierLedgerNumber = nnSupplierLedger.NextNumberValue;
SupplierLedger supplierLedger = await invMod.SupplierLedger.Query().MapToEntity(view);
invMod.SupplierLedger.AddSupplierLedger(supplierLedger).Apply();
SupplierLedgerView newView = await invMod.SupplierLedger.Query().GetViewByNumber(view.SupplierLedgerNumber);
return(Ok(newView));
}
public override void MapSupplierLedgerEntity(ref SupplierLedger supplierLedger, SupplierLedgerView view)
{
supplierLedger.SupplierLedgerId = view.SupplierLedgerId;
supplierLedger.SupplierId = view.SupplierId;
supplierLedger.InvoiceId = view.InvoiceId;
supplierLedger.AcctPayId = view.AcctPayId;
supplierLedger.Amount = view.Amount;
supplierLedger.Gldate = view.Gldate;
supplierLedger.AccountId = view.AccountId;
supplierLedger.GeneralLedgerId = view.GeneralLedgerId;
supplierLedger.DocNumber = view.DocNumber;
supplierLedger.DocType = view.DocType;
supplierLedger.Comment = view.Comment;
supplierLedger.AddressId = view.AddressId;
supplierLedger.CreatedDate = view.CreatedDate;
supplierLedger.FiscalPeriod = view.FiscalPeriod;
supplierLedger.FiscalYear = view.FiscalYear;
}
public static List <SupplierLedger> GetSupplierLedger(int supplierid)
{
var dbUtil = new DatabaseManager();
var supplierledgers = new List <SupplierLedger>();
using (var conn = new SqlConnection(dbUtil.getSQLConnectionString("MainDB")))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "spCommonGetSuppEntryLedger";
cmd.CommandTimeout = 180;
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@intIDMasSupplier", supplierid);
using (SqlDataReader reader = cmd.ExecuteReader())
{
int counter = 0;
while (reader.Read())
{
var supplierledger = new SupplierLedger
{
SupplierLedgerID = counter + 1,
BookTypeCode = ReferenceEquals(reader["strMasBookTypeCode"], DBNull.Value) ? String.Empty : (string)reader["strMasBookTypeCode"],
ReferenceNo = ReferenceEquals(reader["intRefDocNo"], DBNull.Value) ? 0 : (int)reader["intRefDocNo"],
Credit = ReferenceEquals(reader["curCredit"], DBNull.Value) ? 0 : (decimal)reader["curCredit"],
Debit = ReferenceEquals(reader["curDebit"], DBNull.Value) ? 0 : (decimal)reader["curDebit"],
Balance = ReferenceEquals(reader["curRunningBalance"], DBNull.Value) ? 0 : (decimal)reader["curRunningBalance"]
};
supplierledgers.Add(supplierledger);
counter += 1;
}
return(supplierledgers);
}
}
}
}
public SupplierLedgerView(SupplierLedger SupplierLedger)
{
this.SupplierLedgerId = SupplierLedger.SupplierLedgerId;
this.SupplierId = SupplierLedger.SupplierId;
this.SupplierName = SupplierLedger.Supplier.AddressBook.Name;
this.InvoiceId = SupplierLedger.InvoiceId;
this.AcctPayId = SupplierLedger.AcctPayId;
this.DocNumber = SupplierLedger.DocNumber;
this.DocType = SupplierLedger.DocType;
this.Amount = SupplierLedger.Amount ?? 0;
this.GLDate = SupplierLedger.GLDate ?? DateTime.Now.Date;
this.CreatedDate = SupplierLedger.CreatedDate ?? DateTime.Now.Date;
this.AccountId = SupplierLedger.AccountId;
this.AddressId = SupplierLedger.AddressId;
this.Comment = SupplierLedger.Comment;
this.DebitAmount = SupplierLedger.DebitAmount;
this.CreditAmount = SupplierLedger.CreditAmount;
this.FiscalPeriod = SupplierLedger.FiscalPeriod;
this.FiscalYear = SupplierLedger.FiscalYear;
this.GeneralLedgerId = SupplierLedger.GeneralLedgerId;
}
private void SupplierLedgerCreate(string invoiceNO, double?totalAmount, int?supplierID, DateTime date)
{
SupplierLedger aSupplierLedger = new SupplierLedger();
var aSupplier = db.Supplier.SingleOrDefault(p => p.SupplierID == supplierID);
aSupplierLedger.ReceiveDate = date;
aSupplierLedger.SupplierID = Convert.ToInt32(supplierID);
aSupplierLedger.InvoiceNo = invoiceNO;
aSupplierLedger.Debit = 0;
aSupplierLedger.Credit = totalAmount;
aSupplier.SupplierPreviousDue = GetPreviousDue(totalAmount, supplierID);
if (aSupplier.SupplierPreviousDue != 0)
{
aSupplierLedger.IsPreviousDue = 1;
}
else
{
aSupplierLedger.IsPreviousDue = 0;
}
db.SupplierLedger.Add(aSupplierLedger);
db.SaveChanges();
}
public abstract void MapSupplierLedgerEntity(ref SupplierLedger supplierLedger, SupplierLedgerView view);
public IFluentSupplierLedger DeleteSupplierLedger(SupplierLedger deleteObject)
{
unitOfWork.supplierLedgerRepository.DeleteObject(deleteObject);
this.processStatus = CreateProcessStatus.Delete;
return(this as IFluentSupplierLedger);
}
public IFluentSupplierLedger AddSupplierLedger(SupplierLedger newObject)
{
unitOfWork.supplierLedgerRepository.AddObject(newObject);
this.processStatus = CreateProcessStatus.Insert;
return(this as IFluentSupplierLedger);
}
public int InsertSupplierLedgerMasterData()
{
try
{
string query = "select * from ACM where slcd = 'SL'";
DataTable dtSupplierLedgerMaster = dbConnection.GetData(query);
List <SupplierLedger> listSupplierLedgerMaster = new List <SupplierLedger>();
int _result = 0;
using (PharmaDBEntities context = new PharmaDBEntities())
{
var maxSupplierLedgerID = context.SupplierLedger.Count();
if (dtSupplierLedgerMaster != null && dtSupplierLedgerMaster.Rows.Count > 0)
{
foreach (DataRow dr in dtSupplierLedgerMaster.Rows)
{
try
{
maxSupplierLedgerID++;
string supplierLedgerCode = "S" + maxSupplierLedgerID.ToString().PadLeft(6, '0');
string originalSupplierLedgerCode = Convert.ToString(dr["ACNO"]).TrimEnd();
Common.supplierLedgerCodeMap.Add(new SupplierLedgerCodeMap()
{
OriginalSupplierLedgerCode = originalSupplierLedgerCode, MappedSupplierLedgerCode = supplierLedgerCode
});
string areaCode = Common.areaCodeMap.Where(p => p.OriginalAreaCode == Convert.ToString(dr["PAREA"]).TrimEnd()).FirstOrDefault().MappedAreaCode;
int areaID = context.PersonRouteMaster.Where(q => q.PersonRouteCode == areaCode).FirstOrDefault().PersonRouteID;
string purchaseLedgerCode = Common.accountLedgerCodeMap.Where(q => q.OriginalAccountLedgerCode == Convert.ToString(dr["PCODE"]).TrimEnd()).FirstOrDefault().MappedAccountLedgerCode;
int purchaseTypeID = context.AccountLedgerMaster.Where(p => p.AccountLedgerCode == purchaseLedgerCode).FirstOrDefault().AccountLedgerID;
SupplierLedger newSupplierLedgerMaster = new SupplierLedger()
{
SupplierLedgerCode = supplierLedgerCode,
SupplierLedgerName = Convert.ToString(dr["ACName"]).TrimEnd(),
SupplierLedgerShortName = Convert.ToString(dr["Alt_name_1"]).TrimEnd(),
SupplierLedgerShortDesc = Convert.ToString(dr["Alt_name_2"]).TrimEnd(),
Address = string.Concat(Convert.ToString(dr["ACAD1"]).TrimEnd(), " ", Convert.ToString(dr["ACAD2"]).TrimEnd(), " ", Convert.ToString(dr["ACAD3"]).TrimEnd()),
ContactPerson = Convert.ToString(dr["ACAD4"]).TrimEnd(),
Mobile = Convert.ToString(dr["Mobile"]).TrimEnd(),
//Pager = Convert.ToString(dr["Pager"]).TrimEnd(),
//Fax = Convert.ToString(dr["Fax"]).TrimEnd(),
OfficePhone = Convert.ToString(dr["Telo"]).TrimEnd(),
ResidentPhone = Convert.ToString(dr["Telr"]).TrimEnd(),
EmailAddress = Convert.ToString(dr["Email"]).TrimEnd(),
AreaId = areaID,
CreditDebit = Convert.ToDecimal(dr["Abop"]) > 0 ? Convert.ToString(PharmaBusinessObjects.Common.Enums.TransType.D) : Convert.ToString(PharmaBusinessObjects.Common.Enums.TransType.C),
DLNo = "test", // Convert.ToString(dr["Stnol"]).TrimEnd(),
OpeningBal = Convert.ToDecimal(dr["Abop"]),
TaxRetail = Convert.ToString(dr["Vat"]).TrimEnd(),
Status = Convert.ToChar(dr["ACSTS"]) == '*' ? false : true,
PurchaseTypeID = purchaseTypeID,
CreatedBy = "admin",
CreatedOn = DateTime.Now
};
listSupplierLedgerMaster.Add(newSupplierLedgerMaster);
}
catch (Exception)
{
log.Info("SuPPLIER LEDGER : Error in ACName --> " + Convert.ToString(dr["ACName"]).TrimEnd());
}
}
}
context.SupplierLedger.AddRange(listSupplierLedgerMaster);
_result = context.SaveChanges();
return(_result);
}
}
catch (DbEntityValidationException ex)
{
throw ex;
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
///
/// </summary>
/// <param name="purchaseReturn"></param>
public void Add(PurchaseReturn purchaseReturn)
{
var flag = false;
try
{
_unitOfWork.BeginTransaction();
flag = true;
var identity = (LoginIdentity)Thread.CurrentPrincipal.Identity;
#region PurchaseReturn
purchaseReturn.Id = GenerateAutoId(identity.CompanyId, identity.BranchId, "PurchaseReturn");
purchaseReturn.Sequence = GetAutoSequence();
purchaseReturn.PurchaseReturnDate = DateTime.Now;
purchaseReturn.Active = true;
purchaseReturn.SynchronizationType = SynchronizationType.Server.ToString();
purchaseReturn.CompanyId = identity.CompanyId;
purchaseReturn.BranchId = identity.BranchId;
purchaseReturn.AddedBy = identity.Name;
purchaseReturn.AddedDate = DateTime.Now;
purchaseReturn.AddedFromIp = identity.IpAddress;
_purchaseReturnRepository.Add(purchaseReturn);
#endregion
#region PurchaseReturn Products
if (purchaseReturn.PurchaseReturnDetails != null)
{
var sqnc = GetAutoSequence("PurchaseReturnDetail");
int detailId = Convert.ToInt32(GenerateAutoId(purchaseReturn.CompanyId, purchaseReturn.BranchId, "PurchaseReturnDetail"));
foreach (var purchaseReturnDetail in purchaseReturn.PurchaseReturnDetails)
{
var productDb = _productRepository.GetOne(x => x.Id == purchaseReturnDetail.ProductId);
var purchaseDetail = _purchaseDetailRepository.GetOne(r => r.Id == purchaseReturnDetail.PurchaseDetailId);
#region Purchase return detail
purchaseReturnDetail.Id = detailId.ToString();
purchaseReturnDetail.Sequence = sqnc;
purchaseReturnDetail.PurchaseReturnId = purchaseReturn.Id;
decimal alreadyReturnQty = GetAlreadyReturnQty(purchaseReturnDetail.PurchaseId, purchaseReturnDetail.ProductId);
purchaseReturnDetail.RemainingQuantity = purchaseReturnDetail.PurchaseQuantity - (alreadyReturnQty + purchaseReturnDetail.ReturnQuantity);
purchaseDetail.Returned = purchaseDetail.Quantity == alreadyReturnQty + purchaseReturnDetail.ReturnQuantity;
purchaseReturnDetail.ProductCategoryId = productDb.ProductCategoryId;
purchaseReturnDetail.ProductSubCategoryId = productDb.ProductSubCategoryId;
purchaseReturnDetail.ProductSubsidiaryCategoryId = productDb.ProductSubsidiaryCategoryId;
purchaseReturnDetail.UOMId = productDb.UOMId;
purchaseReturnDetail.BrandId = productDb.BrandId;
purchaseReturnDetail.GradeId = productDb.GradeId;
purchaseReturnDetail.PurchaseReturnDetailDate = DateTime.Now;
purchaseReturnDetail.CompanyId = identity.CompanyId;
purchaseReturnDetail.BranchId = identity.BranchId;
purchaseReturnDetail.Active = true;
purchaseReturnDetail.SynchronizationType = SynchronizationType.Server.ToString();
purchaseReturnDetail.AddedBy = identity.Name;
purchaseReturnDetail.AddedDate = DateTime.Now;
purchaseReturnDetail.AddedFromIp = identity.IpAddress;
_purchaseReturnDetailRepository.Add(purchaseReturnDetail);
detailId++;
sqnc++;
#endregion
}
}
#endregion
#region Supplier Ledger
var supplier = _supplierRepository.GetOne(x => x.Id == purchaseReturn.SupplierId);
if (!string.IsNullOrEmpty(supplier?.Id))
{
var supplierLedger = new SupplierLedger
{
Id = GenerateAutoId(identity.CompanyId, identity.BranchId, "SupplierLedger"),
Sequence = GetAutoSequence("SupplierLedger"),
CompanyId = identity.CompanyId,
BranchId = identity.BranchId,
PurchaseId = purchaseReturn.Id,
TrackingNo = GenerateTrackingNo(identity.CompanyId, identity.BranchId, "SupplierLedger"),
SupplierId = supplier.Id,
SupplierPhone = supplier.Phone1,
Particulars = TransactionType.PurchaseReturn.ToString(),
TransactionType = TransactionType.PurchaseReturn.ToString(),
TransactionDate = DateTime.Now,
DebitAmount = purchaseReturn.TotalAmount,
CreditAmount = 0,
RunningBalance = 0,
Active = true,
SynchronizationType = SynchronizationType.Server.ToString(),
AddedBy = identity.Name,
AddedDate = DateTime.Now,
AddedFromIp = identity.IpAddress
};
_supplierLedgerRepository.Add(supplierLedger);
}
#endregion
_unitOfWork.SaveChanges();
ChangePurchaseStatus(purchaseReturn.PurchaseId);
ChangePurchaseReturnStatus(purchaseReturn.Id);
flag = false;
_unitOfWork.Commit();
_rawSqlService.UpdateSupplierLedgerRunningBalance(supplier?.Id);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
if (flag)
{
_unitOfWork.Rollback();
}
}
}
public ActionResult AddSupplierLedger(SupplierLedger model)
{
List <SupplierLedger> supplierLedger = new List <SupplierLedger>();
if (model.SupplierID != 0)
{
if (model.ID <= 0)
{
var aSupplier = db.Supplier.SingleOrDefault(x => x.SupplierID == model.SupplierID);
var totalDebit = db.SupplierLedger.Where(c => c.SupplierID == model.SupplierID)
.GroupBy(c => c.SupplierID).Select(g => new { dabit = g.Sum(c => c.Debit) }).First();
var totalCredit = db.SupplierLedger.Where(c => c.SupplierID == model.SupplierID)
.GroupBy(c => c.SupplierID).Select(g => new { credit = g.Sum(c => c.Credit) }).First();
double?previousDue = totalCredit.credit - (totalDebit.dabit + model.Debit);
aSupplier.SupplierPreviousDue = previousDue;
if (previousDue == 0)
{
model.IsPreviousDue = 0;
}
else
{
model.IsPreviousDue = 1;
}
model.Credit = 0;
db.SupplierLedger.Add(model);
db.SaveChanges();
ViewBag.Message = 1;
supplierLedger = db.SupplierLedger.ToList();
}
else
{
var aSupplier = db.Supplier.SingleOrDefault(x => x.SupplierID == model.SupplierID);
var aSupplierLedger = db.SupplierLedger.SingleOrDefault(x => x.ID == model.ID);
aSupplierLedger.Debit = model.Debit;
db.SaveChanges();
var totalDebit = db.SupplierLedger.Where(c => c.SupplierID == model.SupplierID)
.GroupBy(c => c.SupplierID).Select(g => new { dabit = g.Sum(c => c.Debit) }).First();
var totalCredit = db.SupplierLedger.Where(c => c.SupplierID == model.SupplierID)
.GroupBy(c => c.SupplierID).Select(g => new { credit = g.Sum(c => c.Credit) }).First();
double?previousDue = totalCredit.credit - totalDebit.dabit;
aSupplier.SupplierPreviousDue = previousDue;
if (previousDue == 0)
{
aSupplierLedger.IsPreviousDue = 0;
}
else
{
aSupplierLedger.IsPreviousDue = 1;
}
aSupplierLedger.SupplierID = model.SupplierID;
aSupplierLedger.ReceiveDate = model.ReceiveDate;
aSupplierLedger.Debit = model.Debit;
aSupplierLedger.Remarks = model.Remarks;
db.SaveChanges();
ViewBag.Message = 1;
supplierLedger = db.SupplierLedger.ToList();
}
}
else
{
ViewBag.Message = 0;
supplierLedger = db.SupplierLedger.ToList();
}
ViewBag.supplierList = db.Supplier.ToList();
return(View(supplierLedger));
}
