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