public async Task <ActionResult <DueRecoverd> > PostDueRecoverd(DueRecoverd dueRecoverd)
{
_context.DueRecoverds.Add(dueRecoverd);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetDueRecoverd", new { id = dueRecoverd.DueRecoverdId }, dueRecoverd));
}
public async Task <IActionResult> PutDueRecoverd(int id, DueRecoverd dueRecoverd)
{
if (id != dueRecoverd.DueRecoverdId)
{
return(BadRequest());
}
_context.Entry(dueRecoverd).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!DueRecoverdExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
private async System.Threading.Tasks.Task <int> AddDueRecoveredListAsync(SortedList <int, int> IdList)
{
var ws = xS.GetWS("DueRecovereds");
var nonEmptyDataRows = ws.RowsUsed();
int Row = 6;//Title
//DueRecoverdId PaidDate DuesListId AmountPaid IsPartialPayment Modes Remarks StoreId UserName
foreach (var dR in nonEmptyDataRows)
{
if (dR.RowNumber() > Row)
{
DueRecoverd dL = new DueRecoverd
{
//DueRecoverdId = dR.Cell(1).GetValue<int>(),
PaidDate = dR.Cell(2).GetDateTime(),
DuesListId = dR.Cell(3).GetValue <int>(),
AmountPaid = dR.Cell(4).GetValue <decimal>(),
IsPartialPayment = dR.Cell(5).GetBoolean(),
Modes = dR.Cell(6).GetValue <PaymentMode>(),
Remarks = dR.Cell(7).Value.ToString(),
StoreId = dR.Cell(8).GetValue <int>(),
UserId = dR.Cell(9).Value.ToString(),
};
dL.DuesListId = IdList.GetValueOrDefault(dL.DuesListId);
await db.DueRecoverds.AddAsync(dL);
}
}
return(await db.SaveChangesAsync());
}
public async Task <IActionResult> Edit(int id, [Bind("DueRecoverdId,PaidDate,DuesListId,AmountPaid,IsPartialPayment,Modes,Remarks,StoreId,UserId")] DueRecoverd dueRecoverd)
{
if (id != dueRecoverd.DueRecoverdId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(dueRecoverd);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!DueRecoverdExists(dueRecoverd.DueRecoverdId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["DuesListId"] = new SelectList(_context.DuesLists.Include(c => c.DailySale), "DuesListId", "InvNo", dueRecoverd.DuesListId);
// ViewData["StoreId"] = new SelectList(_context.Stores, "StoreId", "StoreName", dueRecoverd.StoreId);
return(View(dueRecoverd));
}
public ActionResult DeleteConfirmed(int id)
{
DueRecoverd dueRecoverd = db.Recoverds.Find(id);
ProcessAccountDelete(dueRecoverd);
db.Recoverds.Remove(dueRecoverd);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "DueRecoverdId,PaidDate,DuesListId,AmountPaid,IsPartialPayment,Modes,Remarks")] DueRecoverd dueRecoverd)
{
if (ModelState.IsValid)
{
ProcessAccountEdit(dueRecoverd);
db.Entry(dueRecoverd).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.DuesListId = new SelectList(db.DuesLists, "DuesListId", "DuesListId", dueRecoverd.DuesListId);
return(View(dueRecoverd));
}
public ActionResult Create([Bind(Include = "DueRecoverdId,PaidDate,DuesListId,AmountPaid,IsPartialPayment,Modes,Remarks")] DueRecoverd dueRecoverd)
{
if (ModelState.IsValid)
{
db.Recoverds.Add(dueRecoverd);
ProcessAccounts(dueRecoverd);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.DuesListId = new SelectList(db.DuesLists, "DuesListId", "DuesListId", dueRecoverd.DuesListId);
return(View(dueRecoverd));
}
public async Task <IActionResult> Create([Bind("DueRecoverdId,PaidDate,DuesListId,AmountPaid,IsPartialPayment,Modes,Remarks,StoreId,UserId")] DueRecoverd dueRecoverd)
{
if (ModelState.IsValid)
{
_context.Add(dueRecoverd);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["DuesListId"] = new SelectList(_context.DuesLists.Include(c => c.DailySale), "DuesListId", "InvNo", dueRecoverd.DuesListId);
//ViewData["StoreId"] = new SelectList(_context.Stores, "StoreId", "StoreName", dueRecoverd.StoreId);
return(View(dueRecoverd));
}
// GET: DueRecoverds/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
DueRecoverd dueRecoverd = db.Recoverds.Find(id);
if (dueRecoverd == null)
{
return(HttpNotFound());
}
return(View(dueRecoverd));
}
// GET: DueRecoverds/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
DueRecoverd dueRecoverd = db.Recoverds.Find(id);
if (dueRecoverd == null)
{
return(HttpNotFound());
}
ViewBag.DuesListId = new SelectList(db.DuesLists, "DuesListId", "DuesListId", dueRecoverd.DuesListId);
return(View(dueRecoverd));
}
public async Task <IActionResult> Create([Bind("DueRecoverdId,PaidDate,DuesListId,AmountPaid,IsPartialPayment,Modes,Remarks")] DueRecoverd dueRecoverd)
{
if (ModelState.IsValid)
{
_context.Add(dueRecoverd);
new AccountsManager().OnInsert(_context, dueRecoverd);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
var dueList = _context.DuesLists.Include(c => c.DailySale).Where(c => !c.IsRecovered).ToList();
ViewData["DuesListId"] = new SelectList(dueList, "DuesListId", "DailySale.InvNo", dueRecoverd.DuesListId);
//ViewData["DuesListId"] = new SelectList(_context.DuesLists, "DuesListId", "DuesListId", dueRecoverd.DuesListId); //TODO: Make create and edit as per Create() functions
return(PartialView(dueRecoverd));
}
public void OnUpdate(AprajitaRetailsContext db, DueRecoverd objects)
{
DueRecoverd dr = db.DueRecoverds.Find(objects.DueRecoverdId);
DuesList duesList = db.DuesLists.Find(objects.DuesListId);
if (dr.AmountPaid != objects.AmountPaid)
{
//Remove Amount from In-Hands
if (dr.Modes == PaymentModes.Cash)
{
CashTrigger.UpdateCashInHand(db, objects.PaidDate, 0 - dr.AmountPaid);
}
else
{
CashTrigger.UpdateCashInBank(db, objects.PaidDate, 0 - dr.AmountPaid);
}
//Add Amount
if (objects.Modes == PaymentModes.Cash)
{
CashTrigger.UpdateCashInHand(db, objects.PaidDate, objects.AmountPaid);
}
else
{
CashTrigger.UpdateCashInBank(db, objects.PaidDate, objects.AmountPaid);
}
}
if (dr.IsPartialPayment != objects.IsPartialPayment)
{
if (objects.IsPartialPayment && dr.IsPartialPayment == false)
{
duesList.IsPartialRecovery = true;
duesList.IsRecovered = false;
duesList.RecoveryDate = null;
}
else if (dr.IsPartialPayment && objects.IsPartialPayment == false)
{
duesList.IsPartialRecovery = false;
duesList.IsRecovered = true;
duesList.RecoveryDate = objects.PaidDate;
}
}
db.Entry(dr).State = EntityState.Modified;
db.Entry(duesList).State = EntityState.Modified;
}
private void ProcessAccountEdit(DueRecoverd objects)
{
DueRecoverd dr = db.Recoverds.Find(objects.DueRecoverdId);
DuesList duesList = db.DuesLists.Find(objects.DuesListId);
if (dr.AmountPaid != objects.AmountPaid)
{
//Remove Amount from In-Hands
if (dr.Modes == PaymentModes.Cash)
{
Utils.UpDateCashInHand(db, objects.PaidDate, 0 - dr.AmountPaid);
}
else
{
Utils.UpDateCashInBank(db, objects.PaidDate, 0 - dr.AmountPaid);
}
//Add Amount
if (objects.Modes == PaymentModes.Cash)
{
Utils.UpDateCashInHand(db, objects.PaidDate, objects.AmountPaid);
}
else
{
Utils.UpDateCashInBank(db, objects.PaidDate, objects.AmountPaid);
}
}
if (dr.IsPartialPayment != objects.IsPartialPayment)
{
if (objects.IsPartialPayment && dr.IsPartialPayment == false)
{
duesList.IsPartialRecovery = true;
duesList.IsRecovered = false;
duesList.RecoveryDate = null;
}
else if (dr.IsPartialPayment && objects.IsPartialPayment == false)
{
duesList.IsPartialRecovery = false;
duesList.IsRecovered = true;
duesList.RecoveryDate = objects.PaidDate;
}
}
db.Entry(dr).State = EntityState.Detached;
}
private void ProcessAccountDelete(DueRecoverd objects)
{
DuesList duesList = db.DuesLists.Find(objects.DuesListId);
if (objects.Modes == PaymentModes.Cash)
{
Utils.UpDateCashInHand(db, objects.PaidDate, 0 - objects.AmountPaid);
}
else
{
Utils.UpDateCashInBank(db, objects.PaidDate, 0 - objects.AmountPaid);
}
if (objects.IsPartialPayment)
{
duesList.IsPartialRecovery = false;
}
else
{
duesList.IsRecovered = false;
duesList.RecoveryDate = null;
}
}
public void OnInsert(AprajitaRetailsContext db, DueRecoverd objects)
{
DuesList duesList = db.DuesLists.Find(objects.DuesListId);
if (objects.Modes == PaymentModes.Cash)
{
CashTrigger.UpdateCashInHand(db, objects.PaidDate, objects.AmountPaid);
}
else
{
CashTrigger.UpdateCashInBank(db, objects.PaidDate, objects.AmountPaid);
}
if (objects.IsPartialPayment)
{
duesList.IsPartialRecovery = true;
}
else
{
duesList.IsRecovered = true;
duesList.RecoveryDate = objects.PaidDate;
}
db.Entry(duesList).State = EntityState.Modified;
}
[Authorize(Roles = "Admin,PowerUser")] public async Task <IActionResult> Edit(int id, [Bind("DueRecoverdId,PaidDate,DuesListId,AmountPaid,IsPartialPayment,Modes,Remarks")] DueRecoverd dueRecoverd)
{
if (id != dueRecoverd.DueRecoverdId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
new AccountsManager().OnUpdate(_context, dueRecoverd);
_context.Update(dueRecoverd);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!DueRecoverdExists(dueRecoverd.DueRecoverdId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
var dueList = _context.DuesLists.Include(c => c.DailySale).Where(c => !c.IsRecovered).ToList();
ViewData["DuesListId"] = new SelectList(dueList, "DuesListId", "DailySale.InvNo", dueRecoverd.DuesListId);
// ViewData["DuesListId"] = new SelectList(_context.DuesLists, "DuesListId", "DuesListId", dueRecoverd.DuesListId);
return(PartialView(dueRecoverd));
}
