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