private void chequeTransaction(ChequeDetails model)
{
IPChequeDetail ipcObj = new IPChequeDetail();
ipcObj.AccountNo = model.AccountNo;
ipcObj.Amount = model.Amount;
ipcObj.ApplicationUserId = User.Identity.GetUserId();
ipcObj.BankNames = model.BankNames;
ipcObj.ChequeNo = model.ChequeNo;
ipcObj.GeneralLedgerId = null;
ipcObj.InvoiceId = null;
ipcObj.InvoicePaymentId = null;
ipcObj.OtherInvoiceId = model.InvoiceId;
ipcObj.Remarks = model.Remarks;
ipcObj.SortCode = model.SortCode;
ipcObj.SysCreateDate = DateTime.Now;
ipcObj.Status = ChequeStatus.Floating;
ipcObj.BulkPayment = false;
db.IPChequeDetails.Add(ipcObj);
db.SaveChanges();
OtherInvoiceLog ilObj = new OtherInvoiceLog();
ilObj.ApplicationUserId = ipcObj.ApplicationUserId;
ilObj.OtherInvoiceId = model.InvoiceId;
ilObj.Remarks = "Cheque Payment Received - " + model.Remarks;
ilObj.SysDateTime = ipcObj.SysCreateDate;
db.OtherInvoiceLogs.Add(ilObj);
db.SaveChanges();
}
public bool InsertNewRemarksToOtherInvoice(OtherInvoiceLog model)
{
try
{
int status = 0;
using (SqlConnection connection = DataAccess.CreateConnection())
{
SqlCommand command = DataAccess.CreateCommand(connection);
DataAccess.CreateStoredprocedure(command, "InsertNewRemarksToOtherInvoice_SP");
DataAccess.AddInParameter(command, "@InvoiceId", SqlDbType.Int, (int)model.OtherInvoiceId);
DataAccess.AddInParameter(command, "@ApplicationUserId", SqlDbType.VarChar, model.ApplicationUserId);
DataAccess.AddInParameter(command, "@Remarks", SqlDbType.VarChar, model.Remarks);
status = DataAccess.ExecuteNonQuery(command);
return(status < 0 ? false : true);
}
}
catch (Exception ex)
{
return(false);
}
}
public ActionResult UpdateOtherInvoice(FormCollection col)
{
int InvoiceId = (string.IsNullOrEmpty(col["InvoiceId"])) ? 0 : Convert.ToInt32(col["InvoiceId"]);
try
{
#region Add new Remarks to invoice
if (col["trigger"].ToString() == "addRemarks")
{
OtherInvoiceLog ilObj = new OtherInvoiceLog();
ilObj.ApplicationUserId = User.Identity.GetUserId();
ilObj.OtherInvoiceId = InvoiceId;
ilObj.Remarks = (string.IsNullOrEmpty(col["InvoiceRemakrs"])) ? string.Empty : col["InvoiceRemakrs"];
new OtherInvoiceDA().InsertNewRemarksToOtherInvoice(ilObj);
return(RedirectToAction("Details", "OtherInvoice", new { id = InvoiceId }));
}
#endregion
#region Update the agent of an invoice
else if (col["trigger"].ToString() == "ChangeAgent")
{
int AgentId = (string.IsNullOrEmpty(col["AgentId"])) ? 0 : Convert.ToInt32(col["AgentId"]);
string userID = User.Identity.GetUserId();
new OtherInvoiceDA().UpdateOtherInvoiceAgent(userID, InvoiceId, AgentId);
return(RedirectToAction("Details", "OtherInvoice", new { id = InvoiceId }));
}
#endregion
#region Update the vendor of an invoice
else if (col["trigger"].ToString() == "ChangeVendor")
{
int VendorId = (string.IsNullOrEmpty(col["VendorId"])) ? 0 : Convert.ToInt32(col["VendorId"]);
string userID = User.Identity.GetUserId();
new OtherInvoiceDA().UpdateOtherInvoiceVendor(userID, InvoiceId, VendorId);
return(RedirectToAction("Details", "OtherInvoice", new { id = InvoiceId }));
}
#endregion
#region Update invoice basic information
else if (col["trigger"].ToString() == "ChangeInvoiceInfo")
{
string UserID = User.Identity.GetUserId();
int OtherInvoiceTypeId = (string.IsNullOrEmpty(col["OtherInvoiceTypeId"])) ? 0 : Convert.ToInt32(col["OtherInvoiceTypeId"]);
string ExpectedPayDate = (string.IsNullOrEmpty(col["ExpectedPayDate"])) ? string.Empty : Convert.ToString(col["ExpectedPayDate"]);
string Reference = (string.IsNullOrEmpty(col["Reference"])) ? string.Empty : Convert.ToString(col["Reference"]);
string VendorInvNo = (string.IsNullOrEmpty(col["VendorInvNo"])) ? string.Empty : Convert.ToString(col["VendorInvNo"]);
string Details = (string.IsNullOrEmpty(col["Details"])) ? string.Empty : Convert.ToString(col["Details"]);
double Amount = (string.IsNullOrEmpty(col["Amount"])) ? 0 : Convert.ToDouble(col["Amount"]);
double PaidAmount = (string.IsNullOrEmpty(col["PaidAmount"])) ? 0 : Convert.ToDouble(col["PaidAmount"]);
if (PaidAmount > Amount)
{
return(RedirectToAction("Details", "OtherInvoice", new { id = InvoiceId }));
}
else
{
new OtherInvoiceDA().UpdateOtherInvoiceBasicInfo(UserID, InvoiceId, OtherInvoiceTypeId, ExpectedPayDate, Reference, VendorInvNo, Details, Amount);
return(RedirectToAction("Details", "OtherInvoice", new { id = InvoiceId }));
}
}
#endregion
#region Change User of the Invoice
else if (col["trigger"].ToString() == "ChangeUser")
{
string NewUserID = (string.IsNullOrEmpty(col["ApplicationUserId"])) ? string.Empty : col["ApplicationUserId"];
new OtherInvoiceDA().UpdateOtherInvoiceCurrentUser(NewUserID, InvoiceId);
return(RedirectToAction("Details", "OtherInvoice", new { id = InvoiceId }));
}
#endregion
#region When nothing found
else
{
return(RedirectToAction("Details", "OtherInvoice", new { id = InvoiceId }));
}
#endregion
}
catch (Exception ex)
{
return(RedirectToAction("Details", "OtherInvoice", new { id = InvoiceId }));
}
}
