public ActionResult AddFin(mst_fin mst) { using (MySqlConnection con = new MySqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString())) { String query = "select count(*) from mst_fin where fin_close = 'N'"; int id = con.ExecuteScalar <int>(query); if (id > 0) { ModelState.AddModelError(String.Empty, "Financial Year is already open"); return(View()); } if (mst.fin_end_date < System.DateTime.Now.AddMinutes(dateTimeOffSet) && mst.fin_close == "N") { ModelState.AddModelError(String.Empty, "You cannot open financial year in previous year"); return(View(mst)); } mst_finMain mstMain = new mst_finMain(); mstMain.AddFin(mst); return(RedirectToAction("AllFinList")); } }
public ActionResult EditFin(mst_fin mst) { if (mst.fin_end_date < System.DateTime.Now.AddMinutes(dateTimeOffSet) && mst.fin_close == "N") { ModelState.AddModelError(String.Empty, "Financial year already expire"); return(View(mst)); } mst_finMain stdMain = new mst_finMain(); stdMain.EditFin(mst); return(RedirectToAction("AllFinList")); }