/// <summary> /// get invoice approval record on edit /// </summary> /// <param name="id"></param> /// <returns></returns> public InvoiceApprovalOrderModel EditPage(int id) { InvoiceApprovalOrderModel objInvoiceApprovalModels = new InvoiceApprovalOrderModel(); try { RepositoryService <InvoiceApprovalOrderModel> objInvoiceApprovalOrderModel = new RepositoryService <InvoiceApprovalOrderModel>(_vContext); ICollection <SqlParameter> parameters = new List <SqlParameter>(); parameters.Add(SQLHelper.SqlInputParam("@ApprovalID", id, System.Data.SqlDbType.Int)); var data = objInvoiceApprovalOrderModel.ExecWithStoreProcedure("proc_EditInvoiceApproved @ApprovalID", parameters.ToArray()); IEnumerable <InvoiceApprovalOrderModel> lstInvoiceApproval = data.ToList(); foreach (var v in lstInvoiceApproval) { objInvoiceApprovalModels.ApprovalID = lstInvoiceApproval.ElementAt(0).ApprovalID; objInvoiceApprovalModels.FromAmount = lstInvoiceApproval.ElementAt(0).FromAmount; objInvoiceApprovalModels.ToAmount = lstInvoiceApproval.ElementAt(0).ToAmount; objInvoiceApprovalModels.ApprovedBy = lstInvoiceApproval.ElementAt(0).ApprovedBy; objInvoiceApprovalModels.ApprovedByName = lstInvoiceApproval.ElementAt(0).ApprovedByName; objInvoiceApprovalModels.Users = lstInvoiceApproval.ElementAt(0).Users; } } catch (Exception ex) { throw ex; } return(objInvoiceApprovalModels); }
/// <summary> /// Edit and get Invoice Approval record /// </summary> /// <param name="id"></param> /// <returns></returns> public ActionResult EditInvoiceApprovalPage(int id) { string ActionName = this.ControllerContext.RouteData.Values["action"].ToString(); string ControllerName = this.ControllerContext.RouteData.Values["controller"].ToString(); Int32? UserID = HttpContext.Session.GetInt32("UserID"); string ErrorMessage = string.Empty; InvoiceApprovalOrderModel objInvoiceApprovalModel = new InvoiceApprovalOrderModel(); try { objInvoiceApprovalModel = _adminRepository.EditPage(id); IEnumerable <User> lstUsers = _adminRepository.GetUserList(); IEnumerable <LookupDetails> lookupDetails = _lookUpRepository.getLookupDetailByKey("InvoiceApproved"); Tuple <InvoiceApprovalOrderModel, IEnumerable <LookupDetails>, IEnumerable <User> > objAdminModelData = new Tuple <InvoiceApprovalOrderModel, IEnumerable <LookupDetails>, IEnumerable <User> >(objInvoiceApprovalModel, lookupDetails, lstUsers); return(View("AddInvoiceApproval", objAdminModelData)); } catch (Exception ex) { var st = new StackTrace(ex, true); var frame = st.GetFrame(0); int ErrorLine = frame.GetFileLineNumber(); var Result = _CommonRepository.LogManagement(ControllerName, ActionName, ex.Message, ErrorLine, UserID); return(RedirectToAction("ErrorPage", "Common")); } }
/// <summary> /// save and update invoice approval record /// </summary> /// <param name="objUserPage"></param> /// <returns></returns> public int InsertUpdateApprovalRecord(InvoiceApprovalOrderModel objUserPage) { int result = 0; try { RepositoryService <InvoiceApprovalOrderModel> objInvoiceApprovalOrderModel = new RepositoryService <InvoiceApprovalOrderModel>(_vContext); ICollection <SqlParameter> parameters = new List <SqlParameter>(); parameters.Add(SQLHelper.SqlInputParam("@ApprovalID", objUserPage.ApprovalID, System.Data.SqlDbType.Int)); parameters.Add(SQLHelper.SqlInputParam("@FromAmount", objUserPage.FromAmount, System.Data.SqlDbType.Decimal)); parameters.Add(SQLHelper.SqlInputParam("@ToAmount", objUserPage.ToAmount, System.Data.SqlDbType.Decimal)); parameters.Add(SQLHelper.SqlInputParam("@ApprovedBy", objUserPage.ApprovedBy, System.Data.SqlDbType.Int)); parameters.Add(SQLHelper.SqlInputParam("@Users", objUserPage.Users, System.Data.SqlDbType.VarChar)); result = objInvoiceApprovalOrderModel.ExecuteSqlCommand("proc_AddUpdateInvoiceApproved @ApprovalID,@FromAmount, @ToAmount, @ApprovedBy, @Users", parameters.ToArray()); } catch (Exception ex) { throw ex; } return(result); }
//[ValidateAntiForgeryToken] public ActionResult AddInvoiceApproval(InvoiceApprovalOrderModel objInvoiceApprovalPage) { string ActionName = this.ControllerContext.RouteData.Values["action"].ToString(); string ControllerName = this.ControllerContext.RouteData.Values["controller"].ToString(); Int32? UserID = HttpContext.Session.GetInt32("UserID"); string ErrorMessage = string.Empty; try { var Result = _adminRepository.InsertUpdateApprovalRecord(objInvoiceApprovalPage); } catch (Exception ex) { TempData["FailureMessage"] = "We are sorry, something went wrong. Please try again later"; var st = new StackTrace(ex, true); var frame = st.GetFrame(0); int ErrorLine = frame.GetFileLineNumber(); var Result = _CommonRepository.LogManagement(ControllerName, ActionName, ex.Message, ErrorLine, UserID); return(RedirectToAction("ErrorPage", "Common")); } return(RedirectToAction("InvoiceApprovedList", "Admin")); }