public int InsertSchedule(ExamTranModel model) { try { Mapper.CreateMap <ExamTranModel, ExamTran>(); ExamTran objUser = Mapper.Map <ExamTran>(model); Dbcontext.ExamTrans.Add(objUser); return(Dbcontext.SaveChanges()); } catch (Exception ex) { throw ex; } }
public ActionResult Schedule(ExamModel model, ExamTranModel model1) { ExamService objService = new ExamService(); int did = 0; int acid = 0; if (Session["DID"] != null) { did = Convert.ToInt32(Session["DID"].ToString()); acid = Convert.ToInt32(Session["ACID"].ToString()); } int eid = model.ExamDetails.EID; int?schoolID = model.ExamDetails.SchoolID; int?stdID = model.ExamDetails.StdID; var lstSchedule = Dbcontext.ExamTrans.Where(m => m.EID == eid && m.SchoolID == schoolID && m.StdID == stdID).ToList(); if (lstSchedule.Count > 0) { foreach (var s in model.ListSub) { ExamTran et = Dbcontext.ExamTrans.Where(u => u.ETID == s.ETID).SingleOrDefault(); et.Date = s.Date; et.Timing = s.Timing; et.TotalMarks = s.TotalMarks; et.PassingMarks = s.PassingMarks; Dbcontext.SaveChanges(); } } else { model1.EID = eid; model1.SchoolID = schoolID; model1.StdID = stdID; model1.ACID = acid; foreach (var i in model.ListSub) { model1.SubID = i.SubID; model1.Date = i.Date; model1.Timing = i.Timing; model1.TotalMarks = i.TotalMarks; model1.PassingMarks = i.PassingMarks; objService.InsertSchedule(model1); } } return(RedirectToAction("Index")); }