/*_______________________________________________________________________________________________________________________________________________________ * JISHNU*/ public static List <checkfeesmodel> checkfees(int year, int sem) { Database DB = new Database(); List <checkfeesmodel> FeeDefault = new List <checkfeesmodel>(); var BatchList = DB.Batches.Where(i => i.Year == year && i.Semester == sem); foreach (var n in BatchList) { var SDIDs = DB.StudentDetails.Where(i => i.BID == n.BID).Select(i => i.SDID); foreach (int k in SDIDs) { var feesid = DB.Feess.Where(i => i.SDID == k).FirstOrDefault(); if (feesid == null) { checkfeesmodel fees = new checkfeesmodel(); fees.SID = DB.StudentDetails.Where(i => i.SDID == k).Select(i => i.SID).First(); fees.name = DB.Logins.Where(i => i.LoginId == fees.SID).Select(i => i.UserName).First(); fees.branch = DB.Departments.Where(i => i.DID == n.DID).Select(i => i.DepartmentName).First(); fees.year = n.Year; fees.sem = n.Semester; FeeDefault.Add(fees); } } } return(FeeDefault); }
public ActionResult Checkfee(checkfeesmodel cfm) { try { int j = (int)Session["id"]; var role = Data.roles(j); if (role == "Management") { List <checkfeesmodel> cf = Data.checkfees(cfm.year, cfm.sem); return(View(cf)); } else { return(Redirect("/Teacher/Access")); } } catch { return(Redirect("/Login/Login")); } }