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