// 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));
}
