public static List <Markdetail> marks(int stddetail, int batchid) { Database DB = new Database(); List <Markdetail> MarkList = new List <Markdetail>(); var subjects = DB.Subjects.Where(i => i.BID == batchid); foreach (var n in subjects) { int Mark = DB.Marks.Where(i => i.SDID == stddetail && n.SUBID == i.SUBID).Select(i => i.Marks).First(); Markdetail subMark = new Markdetail(); subMark.SubName = n.SubjectName; subMark.Mark = Mark; MarkList.Add(subMark); } return(MarkList); }
public static List <Markdetail> subjects(int bid, int sid) { Database DB = new Database(); List <Markdetail> MarkList = new List <Markdetail>(); var subject = DB.Subjects.Where(i => i.BID == bid).Select(i => i.SUBID); int SDID = DB.StudentDetails.Where(i => i.BID == bid && i.SID == sid).Select(i => i.SDID).FirstOrDefault(); foreach (var n in subject) { Markdetail subMark = new Markdetail(); subMark.Subid = n; subMark.SDID = SDID; subMark.SubName = DB.Subjects.Where(i => i.SUBID == n).Select(i => i.SubjectName).FirstOrDefault(); subMark.Mark = 0; MarkList.Add(subMark); } return(MarkList); }
public ActionResult AddMark(Marks MarkModel) { int BatchID = int.Parse(Request["hidBatch"]); int StdID = int.Parse(Request["hidStd"]); List <Markdetail> SubMark = Data.subjects(BatchID, StdID); List <Markdetail> markdetail = new List <Markdetail>(); foreach (Markdetail obj in SubMark) { Markdetail mobj = new Markdetail(); mobj.SDID = obj.SDID; mobj.Subid = obj.Subid; int Marks = int.Parse(Request["sub_" + obj.Subid]); mobj.Mark = Marks; markdetail.Add(mobj); } Data.Addition(markdetail); return(Redirect("/Teacher/MarkAddition")); }