public ActionResult AddSection(mst_section mst)
{
try
{
mst_sectionMain mstMain = new mst_sectionMain();
mstMain.AddSection(mst);
return(RedirectToAction("AllSectionList"));
}
catch (Exception ex)
{
mst_classMain mstClass = new mst_classMain();
mst_sessionMain sess = new mst_sessionMain();
var class_list = mstClass.AllClassList(sess.findActive_Session());
IEnumerable <SelectListItem> list = new SelectList(class_list, "class_id", "class_name");
ViewData["class_id"] = list;
if (mst.Section_name == null || mst.class_id == 0)
{
ModelState.AddModelError(String.Empty, "Fields cannot be empty.");
}
else
{
ModelState.AddModelError(String.Empty, "Section Already Created.");
}
return(View(mst));
}
}
public ActionResult DeleteSection(int id, FormCollection collection)
{
using (MySqlConnection con = new MySqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()))
{
mst_sectionMain stdMain = new mst_sectionMain();
string query = @"SELECT
COUNT(*)
FROM
sr_register a,
mst_std_section c
WHERE
c.section_id = @section_id
AND c.sr_num = a.sr_number
AND c.session = (SELECT
session
FROM
mst_session
WHERE
session_finalize = 'Y'
AND session_active = 'Y')";
int count = con.Query <int>(query, new { section_id = id }).SingleOrDefault();
if (count == 0)
{
stdMain.DeleteSection(id);
return(RedirectToAction("AllSectionList"));
}
else
{
ModelState.AddModelError(String.Empty, "Students assigned cannot delete section");
return(View(stdMain.FindSection(id)));
}
}
}
public ActionResult DeleteSection(int id)
{
mst_sectionMain stdMain = new mst_sectionMain();
return(View(stdMain.FindSection(id)));
}
public ActionResult AllSectionList()
{
mst_sectionMain stdMain = new mst_sectionMain();
return(View(stdMain.AllSectionList()));
}
