public ActionResult Create(Teacher teacher)
{
try
{
if (ModelState.IsValid)
{
int tcount = db.Teachers.Where(a => a.Initial == teacher.Initial).Count();
if (tcount == 0)
{
try
{
aParseHelper.createIdForTeacher(teacher.Initial);
}
catch { }
db.Teachers.Add(teacher);
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
ViewBag.M = "This Teacher Initial already exists";
ViewBag.TeacherDeptId = new SelectList(db.Departments, "DepartmentId", "Name", teacher.TeacherDeptId);
return(View(teacher));
}
}
ViewBag.TeacherDeptId = new SelectList(db.Departments, "DepartmentId", "Name", teacher.TeacherDeptId);
return(View(teacher));
}
catch
{
ViewBag.M = "Unable to load Create TeacherController";
return(View());
}
}
public ActionResult Create(EveRoutine everoutine)
{
try
{
everoutine.RoutineTypeId = db.RoutineTypes.Where(a => a.TypeName == "Evening").Select(a => a.RoutineTypeId).FirstOrDefault();
if (ModelState.IsValid)
{
db.EveRoutines.Add(everoutine);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.RoutineCourseId = new SelectList(db.Courses, "CourseId", "Name", everoutine.RoutineCourseId);
ViewBag.RoutineDepartmentId = new SelectList(db.Departments, "DepartmentId", "Name", everoutine.RoutineDepartmentId);
ViewBag.RoutineClassroomId = new SelectList(db.ClassRooms, "ClassRoomId", "RoomNo", everoutine.RoutineClassroomId);
ViewBag.RoutineTeacherId = new SelectList(db.Teachers, "TeacherId", "Name", everoutine.RoutineTeacherId);
ViewBag.RoutineSemesterId = new SelectList(db.Semesters, "SemesterId", "Name", everoutine.RoutineSemesterId);
ViewBag.DayName = new SelectList(db.Days, "DayName", "DayName");
//ViewBag.RoutineTypeId = new SelectList(db.RoutineTypes, "RoutineTypeId", "TypeName", everoutine.RoutineTypeId);
return(View(everoutine));
}
catch
{
ViewBag.M = "Unable to load Create EveRoutineController";
return(View());
}
}
public ActionResult Create(Department department)
{
try
{
if (ModelState.IsValid)
{
db.Departments.Add(department);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(department));
}
catch
{
ViewBag.M = "Unable to load Create DepartmentController";
return(View());
}
}
public ActionResult Create(ClassRoom classroom)
{
try
{
if (ModelState.IsValid)
{
db.ClassRooms.Add(classroom);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(classroom));
}
catch
{
ViewBag.M = "Unable to load Create ClassroomController";
return(View());
}
}
public ActionResult Create(Course course)
{
try
{
if (ModelState.IsValid)
{
db.Courses.Add(course);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CourseDeptId = new SelectList(db.Departments, "DepartmentId", "Name", course.CourseDeptId);
return(View(course));
}
catch
{
ViewBag.M = "Unable to load Create CourseController";
return(View());
}
}
public ActionResult Index(string Body)
{
try
{
string textAreaData = Body;
string[] delimeter = { Environment.NewLine };
if (textAreaData != null)
{
string[] aString = textAreaData.Split(delimeter, StringSplitOptions.None);
int q = aString.Length;
for (int i = 0; i < q; i++)
{
string[] delimeter1 = new string[1];
delimeter1[0] = "\t";
string[] word = aString[i].Split(delimeter1, StringSplitOptions.None);
int k = word.Length;
if (k == 4)
{
Teacher aTeacher = new Teacher();
aTeacher.Name = word[0];
aTeacher.Initial = word[1];
aTeacher.Designation = word[2];
string deptCode = word[3];
aTeacher.TeacherDeptId = db.Departments.Where(a => a.Code == deptCode).Select(a => a.DepartmentId).FirstOrDefault();
if (db.Teachers.Where(a => a.Initial == aTeacher.Initial).Count() < 1)
{
try
{
aParseHelper.createIdForTeacher(aTeacher.Initial);
}
catch { }
db.Teachers.Add(aTeacher);
db.SaveChanges();
}
//ViewBag.Message ="Data Successfully Updated";
}
}
return(RedirectToAction("Index", "Teacher"));
}
return(View());
//return RedirectToAction("Index","Teacher");
}
catch
{
ViewBag.M = "Unable to load Index UploadManagementController";
return(View());
}
}
public ActionResult Index(string Body)
{
try
{
string textAreaData = Body;
string[] delimeter = { Environment.NewLine };
if (textAreaData != null)
{
string[] aString = textAreaData.Split(delimeter, StringSplitOptions.None);
int q = aString.Length;
for (int i = 0; i < q; i++)
{
string[] delimeter1 = new string[1];
delimeter1[0] = "\t";
string[] word = aString[i].Split(delimeter1, StringSplitOptions.None);
int k = word.Length;
if (k == 6)
{
Course aCourse = new Course();
aCourse.Name = word[0];
aCourse.Code = word[1];
aCourse.Credit = word[2];
aCourse.Level = word[3];
aCourse.Term = word[4];
string deptCode = word[5];
aCourse.CourseDeptId = db.Departments.Where(a => a.Code == deptCode).Select(a => a.DepartmentId).FirstOrDefault();
if (db.Courses.Where(a => a.Code == aCourse.Code).Count() < 1)
{
db.Courses.Add(aCourse);
db.SaveChanges();
}
//ViewBag.Message ="Data Successfully Updated";
}
}
return(RedirectToAction("Index", "Course"));
}
return(View());
}
catch
{
ViewBag.M = "Unable to load Index UploadCourseController";
return(View());
}
}
private static void timer_Elapsed(object state, EventArgs e)
{
AllEntitiesContext db = new AllEntitiesContext();
//Routine aRoutine = db.Routines.Where(a => a.Day == "Saturday").Select(a => a).FirstOrDefault();
List <TempRoutine> tempList = db.TempRoutines.Where(a => a.TempRoutineDate < DateTime.Now).Select(a => a).ToList();
try
{
foreach (var a in tempList)
{
BackupHelper aBackupHelper = new BackupHelper();
db.TempRoutineBackupModels.Add(aBackupHelper.GetTempRoputineBackupData(a));
db.TempRoutines.Remove(a);
db.SaveChanges();
}
}
catch
{
}
}
public ActionResult Create(TempRoutine temproutine)
{
try
{
//temproutine.UserName = User.Identity.Name;
if (ModelState.IsValid)
{
if (checkPossibilitywithDate(temproutine) == true)
{
if (CheckPossibilityWithUser(temproutine) == true)
{
if (CheckPossibilityWithUser2(temproutine) == true)
{
if (checkPossibilitywithDay(temproutine) == true)
{
if (CheckPossibilityWithTimeSlot(temproutine) == true)
{
temproutine.RoutineTypeId = db.RoutineTypes.Where(a => a.TypeName == "Temporary").Select(a => a.RoutineTypeId).FirstOrDefault();
db.TempRoutines.Add(temproutine);
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
string ft = temproutine.Time_From.TimeOfDay.ToString();
string tt = temproutine.Time_To.TimeOfDay.ToString();
string room = db.ClassRooms.Where(a => a.ClassRoomId == temproutine.RoutineClassroomId).Select(a => a.RoomNo).FirstOrDefault();
string givendate = temproutine.TempRoutineDate.Date.ToShortDateString();
string chosenDay = temproutine.TempRoutineDate.DayOfWeek.ToString();
string msg = "Room " + room + " is not available at " + givendate + " ( " + chosenDay + " )" + " from " + ft + " to " + tt;
ViewBag.message = msg;
ViewBag.RoutineCourseId = new SelectList(db.Routines.Where(a => a.Teacher.Initial == User.Identity.Name).Select(a => a.Course).Distinct(), "CourseId", "Code");
ViewBag.RoutineDepartmentId = new SelectList(db.Departments, "DepartmentId", "Code", temproutine.RoutineDepartmentId);
ViewBag.RoutineClassroomId = new SelectList(db.ClassRooms, "ClassRoomId", "RoomNo", temproutine.RoutineClassroomId);
ViewBag.RoutineTeacherId = new SelectList(db.Teachers, "TeacherId", "Initial", temproutine.RoutineTeacherId);
ViewBag.RoutineSemesterId = new SelectList(db.Semesters, "SemesterId", "Name", temproutine.RoutineSemesterId);
ViewBag.RoutineTypeId = new SelectList(db.RoutineTypes, "RoutineTypeId", "TypeName", temproutine.RoutineTypeId);
ViewBag.DayName = new SelectList(db.Days, "DayName", "DayName");
return(View(temproutine));
}
}
else
{
var name = User.Identity.Name;
DateTime day = temproutine.TempRoutineDate;
DateTime FromDate = GetFromDate(day);
DateTime ToDate = GetToDate(day);
string msg = "You have already Booked 3 or more classes from ''" + FromDate.GetDateTimeFormats()[3].ToString() + "'' to ''" + ToDate.GetDateTimeFormats()[3].ToString() + "''";
ViewBag.message = msg;
ViewBag.RoutineCourseId = new SelectList(db.Routines.Where(a => a.Teacher.Initial == User.Identity.Name).Select(a => a.Course).Distinct(), "CourseId", "Code");
ViewBag.RoutineDepartmentId = new SelectList(db.Departments, "DepartmentId", "Code", temproutine.RoutineDepartmentId);
ViewBag.RoutineClassroomId = new SelectList(db.ClassRooms, "ClassRoomId", "RoomNo", temproutine.RoutineClassroomId);
ViewBag.RoutineTeacherId = new SelectList(db.Teachers, "TeacherId", "Initial", temproutine.RoutineTeacherId);
ViewBag.RoutineSemesterId = new SelectList(db.Semesters, "SemesterId", "Name", temproutine.RoutineSemesterId);
ViewBag.RoutineTypeId = new SelectList(db.RoutineTypes, "RoutineTypeId", "TypeName", temproutine.RoutineTypeId);
ViewBag.DayName = new SelectList(db.Days, "DayName", "DayName");
return(View(temproutine));
}
}
else
{
string chosenDay = temproutine.TempRoutineDate.DayOfWeek.ToString();
string msg = "The Day you choose is " + chosenDay + " which Does not match with make up slot day " + temproutine.Day;
ViewBag.message = msg;
ViewBag.RoutineCourseId = new SelectList(db.Routines.Where(a => a.Teacher.Initial == User.Identity.Name).Select(a => a.Course).Distinct(), "CourseId", "Code");
ViewBag.RoutineDepartmentId = new SelectList(db.Departments, "DepartmentId", "Code", temproutine.RoutineDepartmentId);
ViewBag.RoutineClassroomId = new SelectList(db.ClassRooms, "ClassRoomId", "RoomNo", temproutine.RoutineClassroomId);
ViewBag.RoutineTeacherId = new SelectList(db.Teachers, "TeacherId", "Initial", temproutine.RoutineTeacherId);
ViewBag.RoutineSemesterId = new SelectList(db.Semesters, "SemesterId", "Name", temproutine.RoutineSemesterId);
ViewBag.RoutineTypeId = new SelectList(db.RoutineTypes, "RoutineTypeId", "TypeName", temproutine.RoutineTypeId);
ViewBag.DayName = new SelectList(db.Days, "DayName", "DayName");
return(View(temproutine));
}
}
else
{
string msg = "You have already Assigned a Class at " + temproutine.TempRoutineDate.Date.ToShortDateString();
ViewBag.message = msg;
ViewBag.RoutineCourseId = new SelectList(db.Routines.Where(a => a.Teacher.Initial == User.Identity.Name).Select(a => a.Course).Distinct(), "CourseId", "Code");
ViewBag.RoutineDepartmentId = new SelectList(db.Departments, "DepartmentId", "Code", temproutine.RoutineDepartmentId);
ViewBag.RoutineClassroomId = new SelectList(db.ClassRooms, "ClassRoomId", "RoomNo", temproutine.RoutineClassroomId);
ViewBag.RoutineTeacherId = new SelectList(db.Teachers, "TeacherId", "Initial", temproutine.RoutineTeacherId);
ViewBag.RoutineSemesterId = new SelectList(db.Semesters, "SemesterId", "Name", temproutine.RoutineSemesterId);
ViewBag.RoutineTypeId = new SelectList(db.RoutineTypes, "RoutineTypeId", "TypeName", temproutine.RoutineTypeId);
ViewBag.DayName = new SelectList(db.Days, "DayName", "DayName");
return(View(temproutine));
}
}
else
{
ViewBag.message = "Assigned Date have to be greater than Today";
ViewBag.RoutineCourseId = new SelectList(db.Routines.Where(a => a.Teacher.Initial == User.Identity.Name).Select(a => a.Course).Distinct(), "CourseId", "Code");
ViewBag.RoutineDepartmentId = new SelectList(db.Departments, "DepartmentId", "Code", temproutine.RoutineDepartmentId);
ViewBag.RoutineClassroomId = new SelectList(db.ClassRooms, "ClassRoomId", "RoomNo", temproutine.RoutineClassroomId);
ViewBag.RoutineTeacherId = new SelectList(db.Teachers, "TeacherId", "Initial", temproutine.RoutineTeacherId);
ViewBag.RoutineSemesterId = new SelectList(db.Semesters, "SemesterId", "Name", temproutine.RoutineSemesterId);
ViewBag.RoutineTypeId = new SelectList(db.RoutineTypes, "RoutineTypeId", "TypeName", temproutine.RoutineTypeId);
ViewBag.DayName = new SelectList(db.Days, "DayName", "DayName");
return(View(temproutine));
}
}
ViewBag.RoutineCourseId = new SelectList(db.Routines.Where(a => a.Teacher.Initial == User.Identity.Name).Select(a => a.Course).Distinct(), "CourseId", "Code");
ViewBag.RoutineDepartmentId = new SelectList(db.Departments, "DepartmentId", "Code", temproutine.RoutineDepartmentId);
ViewBag.RoutineClassroomId = new SelectList(db.ClassRooms, "ClassRoomId", "RoomNo", temproutine.RoutineClassroomId);
ViewBag.RoutineTeacherId = new SelectList(db.Teachers, "TeacherId", "Initial", temproutine.RoutineTeacherId);
ViewBag.RoutineSemesterId = new SelectList(db.Semesters, "SemesterId", "Name", temproutine.RoutineSemesterId);
ViewBag.RoutineTypeId = new SelectList(db.RoutineTypes, "RoutineTypeId", "TypeName", temproutine.RoutineTypeId);
ViewBag.DayName = new SelectList(db.Days, "DayName", "DayName");
return(View(temproutine));
}
catch
{
ViewBag.M = "Unable to load Create TempRoutineController";
return(View());
}
}
public ActionResult Index(HttpPostedFileBase csvFile)
{
try
{
List <string[]> timeList = new List <string[]>();
if (csvFile != null)
{
List <Routine> routineList = new List <Routine>();
Routine aRoutine = new Routine();
StreamReader CsvReader = new StreamReader(csvFile.InputStream);
string inputLine = "";
var values = new List <string>();
var values1 = new List <string>();
while ((inputLine = CsvReader.ReadLine()) != null)
{
values.Add(inputLine.Trim());
values1.Add(inputLine.Trim().Replace(",", "").Replace(" ", ""));
}
CsvReader.Close();
char[] semester = new char[8];
char[] year = new char[5];
char[] dept = new char[10];
char[] RoutineType = new char[10];
//string day;
if (values1[1].StartsWith("Semester"))
{
int y = values1[1].Length - 4 - 9;
values1[1].CopyTo(9, semester, 0, y);
y += 9;
values1[1].CopyTo(y, year, 0, 4);
aRoutine.Year = new string(year);
int semesterFound = db.Semesters.Where(a => a.Name == new string(semester)).Count();
if (semesterFound < 1)
{
db.Semesters.Add(new Semester {
Name = new string(semester)
});
}
string semname = new string(semester);
aRoutine.RoutineSemesterId = db.Semesters.Where(a => a.Name == semname).Select(a => a.SemesterId).FirstOrDefault();
if (values1[3].StartsWith("Effective"))
{
string deptcode = null;
string[] delimeter1 = new string[1];
delimeter1[0] = ",";
string[] word = values[3].Split(delimeter1, StringSplitOptions.None);
foreach (var a in word)
{
if (a.StartsWith("CLASS ROUTINE FOR"))
{
y = a.LastIndexOf("PROG") - 19;
a.CopyTo(18, dept, 0, y);
for (int i = 0; dept[i] != '\0'; i++)
{
deptcode += dept[i];
}
// deptcode = new string(dept);
int x = a.LastIndexOf("(") + 1;
y = a.LastIndexOf(")") - x;
a.CopyTo(x, RoutineType, 0, y);
if (db.Departments.Where(b => b.Code == deptcode).Count() < 1)
{
Department aDepartment = new Department();
aDepartment.Code = new string(dept);
aDepartment.Name = "Unknown";
db.Departments.Add(aDepartment);
db.SaveChanges();
}
break;
}
}
aRoutine.RoutineDepartmentId = db.Departments.Where(a => a.Code == deptcode).Select(a => a.DepartmentId).FirstOrDefault();
string RT = null;
for (int i = 0; RoutineType[i] != '\0'; i++)
{
RT += RoutineType[i];
}
//RT = Convert.ToString(RoutineType);
int RoutineId = db.RoutineTypes.Where(a => a.TypeName == RT).Select(a => a.RoutineTypeId).FirstOrDefault();
if (db.Routines.Where(a => (a.RoutineSemesterId == aRoutine.RoutineSemesterId) && (a.Year == aRoutine.Year) && (a.RoutineDepartmentId == aRoutine.RoutineDepartmentId) && (a.RoutineTypeId == RoutineId)).Select(a => a.RoutineId).Count() > 10)
{
//ViewBag.Messsage("This Routine already exists. You can not upload The same again.");
ViewData["adata"] = "This Routine already exists. You can not upload The same again.";
return(View("UploadComplete"));
}
else
{
if ((RT == "Day") || (RT == "DAY"))
{
word = null;
word = values[6].Split(delimeter1, StringSplitOptions.None);
timeList = aParseHelper.GetTime(word);
aRoutine.RoutineTypeId = db.RoutineTypes.Where(a => a.TypeName == "Day").Select(a => a.RoutineTypeId).FirstOrDefault();
int count = values.Count;
for (int i = 5; i < count; i++)
{
if (values1[5].ToString().EndsWith("day"))
{
aRoutine.Day = values1[i].ToString();
i += 3;
while (values1[i].ToString() != "" && i < count)
{
word = null;
word = values[i].Split(delimeter1, StringSplitOptions.None);
if (word[0].StartsWith("L") || word[0].StartsWith("1") || word[0].StartsWith("2") || word[0].StartsWith("3") || word[0].StartsWith("4") || word[0].StartsWith("5") || word[0].StartsWith("6") || word[0].StartsWith("7") || word[0].StartsWith("8"))
{
int timecount = 0;
for (int k = 0; k < (timeList.Count * 3); k += 3)
{
Routine routine = new Routine();
routine.RoutineTypeId = aRoutine.RoutineTypeId;
routine.RoutineSemesterId = aRoutine.RoutineSemesterId;
routine.RoutineDepartmentId = aRoutine.RoutineDepartmentId;
routine.Year = aRoutine.Year;
routine.Day = aRoutine.Day;
routine.Time_From = Convert.ToDateTime(timeList[timecount][0]);
routine.Time_To = Convert.ToDateTime(timeList[timecount][1]);
timecount += 1;
//if (k < 3)
//{
// routine.Time_From = Convert.ToDateTime(timeList[0][0]);
// routine.Time_To = Convert.ToDateTime(timeList[0][1]);
//}
//else if (k < 6)
//{
// routine.Time_From = Convert.ToDateTime(timeList[1][0]);
// routine.Time_To = Convert.ToDateTime(timeList[1][1]);
//}
//else if (k < 9)
//{
// routine.Time_From = Convert.ToDateTime(timeList[2][0]);
// routine.Time_To = Convert.ToDateTime(timeList[2][1]);
//}
//else if (k < 12)
//{
// routine.Time_From = Convert.ToDateTime(timeList[3][0]);
// routine.Time_To = Convert.ToDateTime(timeList[3][1]);
//}
//else if (k < 15)
//{
// routine.Time_From = Convert.ToDateTime(timeList[4][0]);
// routine.Time_To = Convert.ToDateTime(timeList[4][1]);
//}
//else
//{
// routine.Time_From = Convert.ToDateTime(timeList[5][0]);
// routine.Time_To = Convert.ToDateTime(timeList[5][1]);
//}
//******************************************************
string roomNo = word[k];
roomNo = Regex.Replace(roomNo, @"\s", "");
roomNo = Regex.Replace(roomNo, @" ", "");
roomNo = Regex.Replace(roomNo, @"-", "");
routine.RoutineClassroomId = aParseHelper.GetRoutineClassroomId(roomNo);
//******************************************************
string astring = word[k + 1];
string corscode = Regex.Replace(astring, @"\s", "");
corscode = Regex.Replace(corscode, @" ", "");
corscode = Regex.Replace(corscode, @"-", "");
routine.RoutineCourseId = aParseHelper.GetRoutineCourseId(corscode, deptcode);
routine.Section = aParseHelper.GetSection(corscode);
//********************************************
string teacherIni = word[k + 2];
routine.RoutineTeacherId = aParseHelper.GetTeacherId(teacherIni);
routineList.Add(routine);
db.Routines.Add(routine);
db.SaveChanges();
}
}
i++;
}
}
}
ViewBag.Message = "CSV has been parsed Successfully";
return(View("UploadComplete"));
}
else if (RT == "Evening" || RT == "EVENING")
{
EveRoutine aEveRoutine = new EveRoutine();
aRoutine.RoutineTypeId = db.RoutineTypes.Where(a => a.TypeName == "Evening").Select(a => a.RoutineTypeId).FirstOrDefault();
//List<string[]> timeList = new List<string[]>();
timeList = null;
try
{
word = null;
word = values[5].Split(delimeter1, StringSplitOptions.None);
timeList = aParseHelper.GetTime(word);
}
catch
{
ViewBag.Message = "CSV File Format Does not meet the specification";
return(View("UploadComplete"));
}
int count = values.Count;
for (int i = 7; i < count; i++)
{
word = null;
word = values[i].Split(delimeter1, StringSplitOptions.None);
if (word[0].EndsWith("day"))
{
aRoutine.Day = word[0];
while (values1[i].ToString() != "" && i < count)
{
word = null;
word = values[i].Split(delimeter1, StringSplitOptions.None);
if (word[1].StartsWith("L") || word[1].StartsWith("1") || word[1].StartsWith("2") || word[1].StartsWith("3") || word[1].StartsWith("4") || word[1].StartsWith("5") || word[1].StartsWith("6") || word[1].StartsWith("7") || word[1].StartsWith("8"))
{
int timecount = 0;
for (int k = 1; k < (timeList.Count * 5); k += 5)
{
if (word[k] != "")
{
Routine routine = new Routine();
aEveRoutine.RoutineTypeId = aRoutine.RoutineTypeId;
aEveRoutine.RoutineSemesterId = aRoutine.RoutineSemesterId;
aEveRoutine.RoutineDepartmentId = aRoutine.RoutineDepartmentId;
aEveRoutine.Year = aRoutine.Year;
aEveRoutine.Day = aRoutine.Day;
//*************************************************
aEveRoutine.Time_From = Convert.ToDateTime(timeList[timecount][0]);
aEveRoutine.Time_To = Convert.ToDateTime(timeList[timecount][1]);
timecount += 1;
//if (k < 5)
//{
// aEveRoutine.Time_From = Convert.ToDateTime(timeList[0][0]);
// aEveRoutine.Time_To = Convert.ToDateTime(timeList[0][1]);
//}
//else
//{
// aEveRoutine.Time_From = Convert.ToDateTime(timeList[1][0]);
// aEveRoutine.Time_To = Convert.ToDateTime(timeList[1][1]);
//}
//*************************************************
string roomNo = word[k];
roomNo = Regex.Replace(roomNo, @"\s", "");
roomNo = Regex.Replace(roomNo, @" ", "");
roomNo = Regex.Replace(roomNo, @"-", "");
aEveRoutine.RoutineClassroomId = aParseHelper.GetRoutineClassroomId(roomNo);
//*************************************************
string astring = word[k + 1];
string corscode = Regex.Replace(astring, @"\s", "");
corscode = Regex.Replace(corscode, @" ", "");
corscode = Regex.Replace(corscode, @"-", "");
//corscode = word[k + 1];
string corsname = word[k + 2];
aEveRoutine.RoutineCourseId = aParseHelper.GetRoutineCourseId(corscode, deptcode, corsname);
aEveRoutine.Section = aParseHelper.GetSection(corscode);
//*************************************************
if (word[k + 3] != "")
{
aEveRoutine.BatchNumber = Convert.ToInt16(word[k + 3]);
}
else
{
aEveRoutine.BatchNumber = 0;
}
string teacherIni = word[k + 4];
aEveRoutine.RoutineTeacherId = aParseHelper.GetTeacherId(teacherIni);
routineList.Add(routine);
db.EveRoutines.Add(aEveRoutine);
db.SaveChanges();
}
}
}
i++;
}
}
else
{
if (values1[i] == "")
{
i++;
}
else if (values1[i].EndsWith("0"))
{
word = null;
word = values[i].Split(delimeter1, StringSplitOptions.None);
timeList = aParseHelper.GetTime(word);
//i++;
}
else
{
ViewBag.Message = "CSV File Format Does not meet the specification2";
return(View("UploadComplete"));
}
}
}
//word = null;
//word = values[7].Split(delimeter1, StringSplitOptions.None);
//word = null;
//word = values[8].Split(delimeter1, StringSplitOptions.None);
ViewBag.Message = "CSV has been parsed Successfully";
return(View("UploadComplete"));
}
else
{
ViewBag.Message = "CSV File Format Does not meet the specification3";
return(View("UploadComplete"));
}
}
}
else
{
ViewBag.Message = "CSV File Format Does not meet the specification5";
return(View("UploadComplete"));
}
}
else
{
ViewBag.Message = "Only CSV file with specified format is allowed to upload";
return(View("UploadComplete"));
}
}
ViewBag.message = "File can not be empty";
return(View("UploadComplete"));
}
catch
{
ViewBag.M1 = "Only CSV file is allowed to upload";
return(View("UploadComplete"));
}
}