public async Task <ActionResult <LedgerMaster> > PostLedgerMaster(LedgerMaster ledgerMaster) { _context.LedgerMasters.Add(ledgerMaster); await _context.SaveChangesAsync(); return(CreatedAtAction("GetLedgerMaster", new { id = ledgerMaster.LedgerMasterId }, ledgerMaster)); }
public IActionResult Create(LedgerMaster ledgerMaster) { if (ModelState.IsValid) { ledgerMaster.LedgerMasterId = 0; bool isNameExists = IsNameExists(ledgerMaster); if (isNameExists) { ModelState.AddModelError("LedgerMasterName", "Ledger name is already exists."); return(ReturnView(ledgerMaster, true)); } if (!string.IsNullOrWhiteSpace(ledgerMaster.SubGroupName) && ledgerMaster.SubGroupId == 0) { ModelState.AddModelError("SubGroupName", "Please select valid Sub Group"); return(ReturnView(ledgerMaster, true)); } _context.LedgerMaster.Add(ledgerMaster); _context.SaveChanges(); return(RedirectToAction("List", new { id = ledgerMaster.LedgerMasterType })); } return(ReturnView(ledgerMaster, true)); }
public async Task <IActionResult> PutLedgerMaster(int id, LedgerMaster ledgerMaster) { if (id != ledgerMaster.LedgerMasterId) { return(BadRequest()); } _context.Entry(ledgerMaster).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!LedgerMasterExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public string IfAccCrossTheBalanceLimit(LedgerMaster _LedgerMaster) { LedgerMaster Channel_Ledger_Master = new LedgerMaster(); try { Channel_Ledger_Master = _IUoW.Repository <LedgerMaster>().GetBy(x => x.SystemAccountNo == _LedgerMaster.SystemAccountNo && x.AccountTypeId == _LedgerMaster.AccountTypeId); decimal _AfterTrnBalance = 0; if (_LedgerMaster.DefineServiceId == "001" || _LedgerMaster.DefineServiceId == "003") { _AfterTrnBalance = Channel_Ledger_Master.ClosingBalance - _LedgerMaster.Amount; } if (_LedgerMaster.DefineServiceId == "002" || _LedgerMaster.DefineServiceId == "004") { _AfterTrnBalance = Channel_Ledger_Master.ClosingBalance + _LedgerMaster.Amount; } if (_AfterTrnBalance > _LedgerMaster.BalanceLimit) { return("asgent has crossed transaction limit"); } else { return("true"); } } catch (Exception ex) { _ObjErrorLogService = new ErrorLogService(); _ObjErrorLogService.AddErrorLog(ex, string.Empty, "IfAccCrossTheBalanceLimit(obj)", string.Empty); return(null); } }
public int DeleteSalesInvoice(int id) { LedgerMaster ledgerMaster = _serverContext.LedgerMasters.Find(id); _serverContext.LedgerMasters.Remove(ledgerMaster); _serverContext.SaveChanges(); return(id); }
public ActionResult DeleteConfirmed(int id) { LedgerMaster ledgerMaster = db.LedgerMasters.Find(id); db.LedgerMasters.Remove(ledgerMaster); db.SaveChanges(); return(RedirectToAction("Index")); }
public int VoidSalesInvoice(int id) { LedgerMaster ledgerMaster = _serverContext.LedgerMasters.Find(id); ledgerMaster.InvoiceModifiedDate = DateTime.Now; ledgerMaster.Void = true; _serverContext.SaveChanges(); return(id); }
public ActionResult Edit([Bind(Include = "LedgerId,LedgerName")] LedgerMaster ledgerMaster) { if (ModelState.IsValid) { db.Entry(ledgerMaster).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(ledgerMaster)); }
public ActionResult Create([Bind(Include = "LedgerId,LedgerName")] LedgerMaster ledgerMaster) { if (ModelState.IsValid) { db.LedgerMasters.Add(ledgerMaster); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(ledgerMaster)); }
public IActionResult Create(int id) { var ledgerMasterCode = _context.LedgerMaster.Max(x => x.LedgerMasterId) + 1; var ledgerMaster = new LedgerMaster { LedgerMasterType = id, LedgerMasterId = ledgerMasterCode }; return(ReturnView(ledgerMaster, true)); }
public static int CreateLedgerMaster(eStoreDbContext db, Party party) { LedgerMaster master = new LedgerMaster { CreatingDate = DateTime.Today, PartyId = party.PartyId, LedgerTypeId = party.LedgerTypeId }; db.Add(master); return(db.SaveChanges()); }
// GET: Ledger/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } LedgerMaster ledgerMaster = db.LedgerMasters.Find(id); if (ledgerMaster == null) { return(HttpNotFound()); } return(View(ledgerMaster)); }
public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } LedgerMaster getMaster = _uow.LedgerMasterRepository.GetByID(id); if (getMaster == null) { return(HttpNotFound()); } return(View(getMaster)); }
private IActionResult ReturnView(LedgerMaster ledgerMaster, bool create) { switch (ledgerMaster.LedgerMasterType) { case 1: return(create ? View("CreateSupplierMaster", ledgerMaster) : View("EditSupplierMaster", ledgerMaster)); case 2: return(create ? View("CreateCustomerMaster", ledgerMaster) : View("EditCustomerMaster", ledgerMaster)); default: return(create ? View("CreateLedgerHead", ledgerMaster) : View("EditLedgerHead", ledgerMaster)); } }
public string Delete(int id) { string msg = ""; try { LedgerMaster objMaster = _uow.LedgerMasterRepository.GetByID(id); _uow.LedgerMasterRepository.Delete(id); _uow.Save(); msg = "Deleted Successfully"; } catch (Exception ex) { msg = "Error While Processing the Request " + ex.Message; } return(msg); }
public IActionResult Edit(LedgerMaster ledgerMaster) { if (ModelState.IsValid) { bool isNameExists = IsNameExists(ledgerMaster); if (isNameExists) { ModelState.AddModelError("LedgerMasterName", "Ledger name is already exists."); return(ReturnView(ledgerMaster, false)); } if (!string.IsNullOrWhiteSpace(ledgerMaster.SubGroupName) && ledgerMaster.SubGroupId == 0) { ModelState.AddModelError("SubGroupName", "Please select valid Sub Group"); return(ReturnView(ledgerMaster, false)); } _context.Entry(ledgerMaster).Property(x => x.LedgerMasterName).IsModified = true; _context.Entry(ledgerMaster).Property(x => x.LedgerMasterDescription).IsModified = true; _context.Entry(ledgerMaster).Property(x => x.Division).IsModified = true; _context.Entry(ledgerMaster).Property(x => x.SubGroupId).IsModified = true; _context.Entry(ledgerMaster).Property(x => x.MarginPercentage).IsModified = true; _context.Entry(ledgerMaster).Property(x => x.SaleRate).IsModified = true; _context.Entry(ledgerMaster).Property(x => x.Address).IsModified = true; _context.Entry(ledgerMaster).Property(x => x.City).IsModified = true; _context.Entry(ledgerMaster).Property(x => x.State).IsModified = true; _context.Entry(ledgerMaster).Property(x => x.PinCode).IsModified = true; _context.Entry(ledgerMaster).Property(x => x.MobileNumber).IsModified = true; _context.Entry(ledgerMaster).Property(x => x.EmailId).IsModified = true; _context.Entry(ledgerMaster).Property(x => x.GSTNumber).IsModified = true; _context.Entry(ledgerMaster).Property(x => x.PANNumber).IsModified = true; _context.Entry(ledgerMaster).Property(x => x.Debit).IsModified = true; _context.Entry(ledgerMaster).Property(x => x.Credit).IsModified = true; _context.Entry(ledgerMaster).Property(x => x.CreatedBy).IsModified = true; _context.Entry(ledgerMaster).Property(x => x.CreateDate).IsModified = true; _context.SaveChanges(); return(RedirectToAction("List", new { id = ledgerMaster.LedgerMasterType })); } return(ReturnView(ledgerMaster, false)); }
public string Edit([Bind(Include = "ID,LedgerName,LedgerGroupMasterID,FirmMasterID,NamePrintable,IsCheckStockAccount,Street,Area,City,Pin,State,Country,Transport,Phone,Fax,CellNo,Email,TinNo,GSTNo,Details,Supplier,Roller,JobWorker,Customer,Dyer,Winder,Weaver,Employee,Agent,Warper,Processor,AgentName,Image,CommisionPercentage,IsActive,ShortCode,Line,TransportType,DeliveryType,LCParty,DueDate,RegularDiscount,Wages,TDS,ContactPerson,RetailAgent,Broker,LedgerPartyTypeMasterID,BranchMasterID")] LedgerMaster objMaster) { string msg = ""; try { if (ModelState.IsValid) { _uow.LedgerMasterRepository.Update(objMaster); _uow.Save(); msg = "Updated Successully"; } else { msg = "Update Validation Error"; } } catch (Exception ex) { msg = "Error while Processing the Request " + ex.Message; } return(msg); }
private bool IsNameExists(LedgerMaster ledgerMaster) { var result = _context.LedgerMaster.Where(x => x.LedgerMasterName.Equals(ledgerMaster.LedgerMasterName, StringComparison.InvariantCultureIgnoreCase)).FirstOrDefault(); return(result == null ? false : result.LedgerMasterId == ledgerMaster.LedgerMasterId ? false : true); }
int UpdateLedger(CustomerInvoiceModel customerInvoiceModel, bool addMode) { LedgerMaster ledgerMaster = null; if (addMode) { ledgerMaster = new LedgerMaster(); ledgerMaster.SubsidiaryLedgerAccountId = customerInvoiceModel.Customer.Value; ledgerMaster.InvoiceBillingAddress = customerInvoiceModel.BillingAddress; ledgerMaster.InvoiceNo = customerInvoiceModel.InvoiceNo; ledgerMaster.InvoiceDate = customerInvoiceModel.Date; ledgerMaster.InvoiceDueDate = customerInvoiceModel.DueDate; ledgerMaster.InvoiceTerms = customerInvoiceModel.Terms; ledgerMaster.InvoiceReference = customerInvoiceModel.Reference; ledgerMaster.InvoiceCreatedDate = DateTime.Now; ledgerMaster.InvoiceAmount = customerInvoiceModel.Amount; ledgerMaster.TransactionType = "INV"; _serverContext.LedgerMasters.Add(ledgerMaster); _serverContext.SaveChanges(); /* LedgerDetail ledgerDetail = new LedgerDetail(); * foreach (CustomerInvoiceItemModel item in customerInvoiceModel.Items) * { * ledgerDetail.Id = 0; * ledgerDetail.LedgerMasterId = ledgerMaster.Id; * ledgerDetail.InvoiceSalesItemId = item.SalesItem.Value; * ledgerDetail.InvoiceDescription = item.Description; * ledgerDetail.InvoiceQuantity = item.Qty; * ledgerDetail.InvoiceUnitPrice = item.UnitPrice; * ledgerDetail.InvoiceTaxRateId = item.TaxRateItem.Value; * ledgerDetail.InvoiceTrackingId = item.TrackingItem.Value; * _serverContext.LedgerDetails.Add(ledgerDetail); * _serverContext.SaveChanges(); * } */ } else { ledgerMaster = _serverContext.LedgerMasters.Find(customerInvoiceModel.Id); ledgerMaster.SubsidiaryLedgerAccountId = customerInvoiceModel.Customer.Value; ledgerMaster.InvoiceBillingAddress = customerInvoiceModel.BillingAddress; ledgerMaster.InvoiceNo = customerInvoiceModel.InvoiceNo; ledgerMaster.InvoiceAmount = customerInvoiceModel.Amount; ledgerMaster.InvoiceDate = customerInvoiceModel.Date; ledgerMaster.InvoiceDueDate = customerInvoiceModel.DueDate; ledgerMaster.InvoiceTerms = customerInvoiceModel.Terms; ledgerMaster.InvoiceReference = customerInvoiceModel.Reference; ledgerMaster.InvoiceModifiedDate = DateTime.Now; ledgerMaster.TransactionType = "INV"; _serverContext.SaveChanges(); } if (!addMode) { foreach (var item in _serverContext.LedgerDetails.Where(x => x.LedgerMasterId == customerInvoiceModel.Id).ToList()) { LedgerDetail ledgerDetail = new LedgerDetail(); ledgerDetail = _serverContext.LedgerDetails.Find(item.Id); if (ledgerDetail != null) { _serverContext.LedgerDetails.Remove(ledgerDetail); _serverContext.SaveChanges(); } } } foreach (CustomerInvoiceItemModel item in customerInvoiceModel.Items) { LedgerDetail ledgerDetail = new LedgerDetail(); ledgerDetail.Id = 0; ledgerDetail.LedgerMasterId = ledgerMaster.Id; ledgerDetail.InvoiceSalesItemId = item.SalesItem.Value; ledgerDetail.InvoiceDescription = item.Description; ledgerDetail.InvoiceQuantity = item.Qty; ledgerDetail.InvoiceUnitPrice = item.UnitPrice; ledgerDetail.InvoiceTaxRateId = item.TaxRateItem.Value; ledgerDetail.InvoiceTrackingId = item.TrackingItem.Value; _serverContext.LedgerDetails.Add(ledgerDetail); _serverContext.SaveChanges(); } if (!addMode) { var tempGl = _serverContext.GeneralLedgers.Where(x => x.LedgerMasterId == customerInvoiceModel.Id).SingleOrDefault(); _serverContext.GeneralLedgers.Remove(tempGl); } return(ledgerMaster.Id); }
public string CheckAccLimit(AccLimitSetup _AccLimit) { AccLimitSetup Acc_Limit_Setup_From = new AccLimitSetup(); AccLimitSetup Acc_Limit_Setup_To = new AccLimitSetup(); LedgerMaster _LedgerMaster = new LedgerMaster(); LedgerService _LedgerService = new LedgerService(); try { #region From Account Limit Check var _From_Acc_Limit = _IUoW.Repository <AccLimitSetup>().GetBy(x => x.AuthStatusId == "A" && x.LastAction != "DEL" && x.DefineServiceId == _AccLimit.DefineServiceId && x.AccTypeId == _AccLimit.FromAccType); var _To_Acc_Limit = _IUoW.Repository <AccLimitSetup>().GetBy(x => x.AuthStatusId == "A" && x.LastAction != "DEL" && x.DefineServiceId == _AccLimit.DefineServiceId && x.AccTypeId == _AccLimit.ToAccType); if (_From_Acc_Limit == null) { return("no transaction limit has set for this service and from account type"); } if (_To_Acc_Limit == null) { return("no transaction limit has set for this service and to account type"); } #region Checking by Ledger BalanceLimit //if (_From_Acc_Limit.AllDefineService == "0") //{ // _LedgerMaster.SystemAccountNo = _AccLimit.FromSystemAccountNo; // _LedgerMaster.Amount = _AccLimit.Amount; // _LedgerMaster.BalanceLimit = _From_Acc_Limit.BalanceLimit; // _LedgerMaster.DefineServiceId = _AccLimit.DefineServiceId; // var msg = _LedgerService.IfAccCrossTheBalanceLimit(_LedgerMaster); // if (msg != "true") // { // return msg; // } //} #endregion //#region Checking by Event //else //{ // var _ListLedgerTxnFrom = (List<LedgerTxn>)_IUoW.Repository<LedgerTxn>().Get(x => x.AuthStatusId == "A" && x.LastAction != "DEL" && // x.DefineServiceId == _AccLimit.DefineServiceId && x.FromSystemAccountNo == _AccLimit.FromSystemAccountNo && x.TransectionDate == _AccLimit.TransDT); // var _ListLedgerTxnTo = (List<LedgerTxn>)_IUoW.Repository<LedgerTxn>().Get(x => x.AuthStatusId == "A" && x.LastAction != "DEL" && // x.DefineServiceId == _AccLimit.DefineServiceId && x.FromSystemAccountNo == _AccLimit.ToSystemAccountNo && x.TransectionDate == _AccLimit.TransDT); // #region Get Daily Number Of Transaction // Acc_Limit_Setup_From.NoOfOccurrence = (_ListLedgerTxnFrom.Count()).ToString(); // Acc_Limit_Setup_To.NoOfOccurrence = (_ListLedgerTxnTo.Count()).ToString(); // #endregion // #region Get Daily Transaction Amount // Acc_Limit_Setup_From.AmountOftotalOccurrences = Convert.ToDecimal(_ListLedgerTxnFrom.Select(m => m.PaymentAmount + m.ReceiveAmount).Sum()); // Acc_Limit_Setup_To.AmountOftotalOccurrences = Convert.ToDecimal(_ListLedgerTxnTo.Select(m => m.PaymentAmount + m.ReceiveAmount).Sum()); // #endregion // #region Checking Transaction Limit For From Account // if (Convert.ToInt32(Acc_Limit_Setup_From.NoOfOccurrence) > Convert.ToInt32(_From_Acc_Limit.NoOfOccurrence)) // { // return "from account has crossed daily number of transaction limit! the actual limit is " + _From_Acc_Limit.NoOfOccurrence; // } // if (Acc_Limit_Setup_From.AmountOftotalOccurrences > _From_Acc_Limit.AmountOftotalOccurrences) // { // return "from account has crossed daily total amount of transaction limit! the actual limit is " + _From_Acc_Limit.AmountOftotalOccurrences; // } // if (_AccLimit.Amount > _From_Acc_Limit.AmountOfOccurrence) // { // return "from account has crossed amount of transaction limit! the actual limit is " + _From_Acc_Limit.AmountOfOccurrence; // } // #endregion // #region Checking Transaction Limit For To Account // if (Convert.ToInt32(Acc_Limit_Setup_To.NoOfOccurrence) > Convert.ToInt32(_To_Acc_Limit.NoOfOccurrence)) // { // return "to account has crossed daily number of transaction limit! the actual limit is " + _To_Acc_Limit.NoOfOccurrence; // } // if (Acc_Limit_Setup_To.AmountOftotalOccurrences > _To_Acc_Limit.AmountOftotalOccurrences) // { // return "to account has crossed daily total amount of transaction limit! the actual limit is " + _To_Acc_Limit.AmountOftotalOccurrences; // } // if (_AccLimit.Amount > _To_Acc_Limit.AmountOfOccurrence) // { // return "to account has crossed amount of transaction limit! the actual limit is " + _To_Acc_Limit.AmountOfOccurrence; // } // #endregion //} //#endregion #endregion return("true"); } catch (Exception ex) { _ObjErrorLogService = new ErrorLogService(); _ObjErrorLogService.AddErrorLog(ex, string.Empty, "CheckStatusWiseService(obj)", string.Empty); return("false"); } }
public string UpdateClosingBalance(IUnitOfWork _IUoW, LedgerMaster _LedgerMaster) { throw new NotImplementedException(); }