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