public ActionResult NewAdjustment(BudgetAdjustmentViewModel bavm)
{
ViewBag.Title = Constant.BUDGET_ADJUSTMENT;
bavm.BudgetList = BudgetAdjustmentCommon();
try
{
if (ModelState.IsValid)
{
bavm.Status = 1;
bavm.CreatedDate = DateTime.Now;
_repAnnualBudget.CreateAnnualBudget(bavm);
var budgetObj = _repAnnualBudget.GetBudgetList().OrderByDescending(x => x.Id).Take(1).SingleOrDefault();
if (budgetObj != null)
{
return(RedirectToAction("Dashboard", "Home"));
}
}
}
catch (IOException e)
{
if (e.Source != null)
{
Console.WriteLine("IOException source: {0}", e.Source);
throw;
}
}
return(View(bavm));
}
/// <summary>
/// Creates Annual Budget
/// </summary>
/// <param name="bvm">BudgetViewModel</param>
public void CreateAnnualBudget(BudgetAdjustmentViewModel bavm)
{
string QueryString = String.Format(
@" INSERT INTO {0}
([Year], BudgetProvision, StartDate, EndDate, CreatedDate, [Status])
VALUES
('{1}', {2}, '{3}', '{4}', '{5}', {6})",
TableConstant.TBL_ANNUAL_BUDGET,
bavm.Year,
bavm.BudgetProvision,
bavm.StartDate,
bavm.EndDate,
bavm.CreatedDate,
bavm.Status
);
ado.ExecNonQuery(QueryString);
}
public ActionResult NewAdjustment()
{
ViewBag.Title = Constant.BUDGET_ADJUSTMENT;
var bavm = new BudgetAdjustmentViewModel();
bavm.BudgetList = BudgetAdjustmentCommon();
/*if (String.IsNullOrEmpty(SessionHelper.Username) ||
* String.IsNullOrEmpty(SessionHelper.UserEmail) ||
* String.IsNullOrEmpty(SessionHelper.UserImage))
* {
* return RedirectToAction("Login");
* }*/
if (String.IsNullOrEmpty(SessionHelper.Username))
{
return(RedirectToAction("Login"));
}
//var abvm = new AddBudgetViewModel();
return(View(bavm));
}
