public void update_Cancelled(Guid Id, string CancelNotes)
{
WebDBConnection.Update(db.Database, "Payments",
DBConnection.getSqlParameter(PaymentsModel.COL_Id.Name, Id),
DBConnection.getSqlParameter(PaymentsModel.COL_Cancelled.Name, 1),
DBConnection.getSqlParameter(PaymentsModel.COL_CancelNotes.Name, CancelNotes)
);
ActivityLogsController.AddEditLog(db, Session, Id, string.Format(PaymentsModel.COL_CancelNotes.LogDisplay, CancelNotes));
//Adjust sale invoice due amount
List <PaymentItemsModel> paymentItems = PaymentItemsController.get(null, Id);
List <SaleInvoicesModel> saleInvoices;
foreach (PaymentItemsModel paymentitem in paymentItems)
{
saleInvoices = SaleInvoicesController.get(Session, paymentitem.ReferenceId.ToString());
if (saleInvoices.Count > 0)
{
WebDBConnection.Update(db.Database, "SaleInvoices",
DBConnection.getSqlParameter(SaleInvoicesModel.COL_Id.Name, saleInvoices[0].Id),
DBConnection.getSqlParameter(SaleInvoicesModel.COL_Due.Name, saleInvoices[0].Due + paymentitem.Amount)
);
}
}
db.SaveChanges();
}
public ActionResult setCreateViewBagsAndReturn(string saleInvoiceIdList)
{
List <SaleInvoiceItemsModel> SaleInvoiceItems = SaleInvoiceItemsController.get(null, null, saleInvoiceIdList, null, null, null, null, null, null, null)
.OrderBy(x => x.SaleInvoices_No)
.ThenBy(x => x.RowNo)
.ToList();
ViewBag.TotalAmount = SaleInvoiceItems.Sum(x => x.TotalAmount);
List <SaleInvoicesModel> saleinvoices = SaleInvoicesController.get(Session, saleInvoiceIdList);
ViewBag.DueAmount = saleinvoices.Sum(x => x.Due);
ViewBag.id = saleInvoiceIdList;
//BanksController.setDropDownListViewBag(this);
ConsignmentsController.setDropDownListViewBag(this);
return(View(SaleInvoiceItems));
}
public ActionResult Create(string id, string JsonPayments)
{
List <SaleInvoicesModel> saleinvoices = SaleInvoicesController.get(Session, id).OrderBy(x => x.Timestamp).ToList();
if (ModelState.IsValid)
{
PaymentsModel payment = JsonConvert.DeserializeObject <PaymentsModel>(JsonPayments);
payment.Id = Guid.NewGuid();
payment.No = Util.incrementHexNumber(getLastNo());
payment.Timestamp = Helper.getCurrentDateTime();
if (payment.DebitAmount == 0)
{
payment.DebitBank = null;
payment.DebitNumber = null;
payment.DebitOwnerName = null;
payment.DebitRefNo = null;
}
if (payment.ConsignmentAmount == 0)
{
payment.Consignments_Id = null;
}
//create payment items and update sale invoice due amount
int RemainingPaymentAmount = payment.DebitAmount + payment.CashAmount + payment.ConsignmentAmount;
int paymentItemAmount = 0;
int dueBefore = 0;
int dueAfter = 0;
foreach (SaleInvoicesModel saleinvoice in saleinvoices)
{
dueBefore = saleinvoice.Due;
dueAfter = saleinvoice.Due;
if (RemainingPaymentAmount == 0)
{
break;
}
else
{
if (RemainingPaymentAmount >= saleinvoice.Due)
{
paymentItemAmount = saleinvoice.Due;
}
else
{
paymentItemAmount = RemainingPaymentAmount;
}
RemainingPaymentAmount -= paymentItemAmount;
dueAfter -= paymentItemAmount;
SaleInvoicesController.update_Due(Session, db, saleinvoice.Id, saleinvoice.Due, saleinvoice.Due - paymentItemAmount);
saleinvoice.Due -= paymentItemAmount;
}
PaymentItemsController.add(db, payment.Id, new PaymentItemsModel {
Id = Guid.NewGuid(),
Payments_Id = payment.Id,
ReferenceId = saleinvoice.Id,
Amount = paymentItemAmount,
DueBefore = dueBefore,
DueAfter = dueAfter
});
}
//create petty cash
if (payment.CashAmount > 0)
{
PettyCashRecordsController.add(db, new PettyCashRecordsModel
{
Id = Guid.NewGuid(),
Branches_Id = Helper.getActiveBranchId(Session),
ReferenceId = payment.Id,
No = "",
Timestamp = payment.Timestamp,
PettyCashRecordsCategories_Id = SettingsController.get().AutoEntryForCashPayments.Value,
Notes = "Cash Payment [" + payment.No + "]",
Amount = payment.CashAmount,
Approved = false,
UserAccounts_Id = (Guid)UserAccountsController.getUserId(Session),
ExpenseCategories_Id = null
});
}
add(payment);
return(RedirectToAction(nameof(Print), new { id = payment.Id }));
}
return(setCreateViewBagsAndReturn(id));
}