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