// GET: CourseGroup/Create public ActionResult Create() { ViewCourseGroup objViewCourseGroup = new ViewCourseGroup(); List <ViewCourseGroupSchedule> objViewCourseGroupSchedule = new List <ViewCourseGroupSchedule>(); var data = (from s in db.ScheduleInformations select new { ScheduleId = s.ShScheduleId, roomNo = s.RoomInformation.RmRoomNo, SHDay = s.ShDay, FromTime = s.ShFromTime, ToTime = s.ShToTime }); foreach (var item in data) { var fromTime = item.FromTime.Value.ToString("h:mm tt", CultureInfo.CreateSpecificCulture("en-BD")); var toTime = item.ToTime.Value.ToString("h:mm tt", CultureInfo.CreateSpecificCulture("en-BD")); var schedule = item.roomNo + " " + item.SHDay + " " + fromTime + "-" + toTime; objViewCourseGroupSchedule.Add(new ViewCourseGroupSchedule()); objViewCourseGroupSchedule[objViewCourseGroupSchedule.Count - 1].ScheduleId = item.ScheduleId; objViewCourseGroupSchedule[objViewCourseGroupSchedule.Count - 1].Schedule = schedule; } objViewCourseGroup.CourseGroupScheduleList = objViewCourseGroupSchedule; objViewCourseGroup.ScheduleIno = new SelectList(objViewCourseGroupSchedule, "ScheduleId", "Schedule"); objViewCourseGroup.ClassId = new SelectList(db.ClassOrYears, "Code", "Name"); objViewCourseGroup.CourseId = new SelectList(db.CourseContents.Where(s => s.ClassId == "").ToList(), "CourseId", "CourseName"); objViewCourseGroup.TeacherId = new SelectList(db.EmployeeAccounts, "AccountId", "EmployeeCatagoryId"); // objViewCourseGroup.ScheduleInformationT = db.ScheduleInformations.ToList(); return(View(objViewCourseGroup)); }
public ActionResult Create([Bind(Include = "CourseGroup")] ViewCourseGroup viewCoursegroup) { if (ModelState.IsValid) { var data = db.ScheduleInformations.Find(Convert.ToInt64(viewCoursegroup.CourseGroup.DayTimeSlot)); if (data.ShCourse != null) { TempData["Message"] = " Schedule Assign "; return(RedirectToAction("Index")); } db.CourseGroups.Add(viewCoursegroup.CourseGroup); db.SaveChanges(); data.ShCourse = viewCoursegroup.CourseGroup.CourseId; data.ShSection = viewCoursegroup.CourseGroup.GroupId; db.Entry(data).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); //db.CourseGroups.Add(courseGroup); //db.SaveChanges(); //return RedirectToAction("Index"); } viewCoursegroup.ClassId = new SelectList(db.ClassOrYears, "Code", "Name", viewCoursegroup.ClassId); viewCoursegroup.CourseId = new SelectList(db.CourseContents, "CourseId", "CourseName", viewCoursegroup.CourseId); viewCoursegroup.TeacherId = new SelectList(db.EmployeeAccounts, "AccountId", "EmployeeCatagoryId", viewCoursegroup.TeacherId); return(View(viewCoursegroup)); }