//
// GET: /Cource/Create
public ActionResult Create()
{
Course objCourse = new Course();
objCourse.OrganizationList = LoadSelectLists();
objCourse.OrganisationId = ViewBag.OrganizationId == null ? 0 : Convert.ToInt32(ViewBag.OrganizationId);
return PartialView(objCourse);
}
//public List<Course> GetCourses()
//{
// string sql = "select CourseId,CourseName,CourseDescription,Courses.CreatedBy,Courses.InsertedOn,Courses.ModifiedBy,ModifiedOn,Courses.OrganisationId,Organizations.OrganizationName, Users.Username as InsertedByName,Users_1.Username as ModifiedByName ";
// sql += "from Courses join Organizations on Courses.OrganisationId=Organizations.OrganizationId join Users on Courses.CreatedBy=Users.UserId left join Users as Users_1 on Courses.ModifiedBy=Users_1.UserId";
// List<Course> modelList = db.Query<Course>(sql).ToList();
// return modelList;
//}
//public Course GetCourses(long id)
//{
// string sql = "select CourseId,CourseName,CourseDescription,Courses.CreatedBy,Courses.InsertedOn,Courses.ModifiedBy,ModifiedOn,Courses.OrganisationId,Organizations.OrganizationName, Users.Username as InsertedByName,Users_1.Username as ModifiedByName ";
// sql += "from Courses join Organizations on Courses.OrganisationId=Organizations.OrganizationId join Users on Courses.CreatedBy=Users.UserId left join Users as Users_1 on Courses.ModifiedBy=Users_1.UserId ";
// sql += "where CourseId=@0";
// Course objModel = db.Query<Course>(sql, id).FirstOrDefault();
// return objModel;
//}
public bool Create(Course objCourse)
{
int recAffected = 0;
DBConnectionString.Course Course = new DBConnectionString.Course();
Course.CourseName = objCourse.CourseName;
Course.CourseDescription = objCourse.CourseDescription;
Course.OrganisationId = objCourse.OrganisationId;
Course.CreatedBy = objCourse.CreatedBy;
Course.InsertedOn = DateTime.Now;
recAffected = Convert.ToInt32(Course.Insert());
if (recAffected > 0)
{
return true;
}
return false;
}
public string Create(Course course, string token)
{
try
{
if (ModelState.IsValid)
{
course.CreatedBy = _userStatistics.UserId;
if (objRep.CreateCourse(course))
{
SaveFiles(token, this.GetType().Name, course.CourseId);
return Convert.ToString(true);
}
return Convert.ToString(false);
}
return Convert.ToString(false);
}
catch (Exception ex)
{
return ex.Message.ToString();
}
}
public bool CreateCourse(Course objCourse)
{
var parameters = new
{
CourseName = objCourse.CourseName,
CourseDescription = objCourse.CourseDescription,
OrganisationId = objCourse.OrganisationId,
CreatedBy = objCourse.CreatedBy,
InsertedOn = DateTime.Now,
};
using (IDbConnection connection = OpenConnection())
{
const string storedProcedure = "usp_addCourse";
int rowsAffected = connection.Execute(storedProcedure, parameters, commandType: CommandType.StoredProcedure);
SetIdentity<int>(connection, id => objCourse.CourseId = id);
if (rowsAffected > 0)
{
return true;
}
return false;
}
}
public string Edit(Course course, string token)
{
try
{
if (ModelState.IsValid)
{
course.ModifiedBy = _userStatistics.UserId;
course.ModifiedOn = DateTime.UtcNow;
if (objRep.Update(course))
{
SaveFiles(token, this.GetType().Name, course.CourseId);
return Convert.ToString(true);
}
return Convert.ToString(false);
}
return Convert.ToString(false);
}
catch (Exception ex)
{
return ex.Message.ToString();
}
}
public Schedule LoadScheduleLists(string userRole, long organizationId = -1, long scheduleId = -1)
{
Schedule schedule = null;
if (scheduleId != -1)
{
schedule = this.GetSchedule(scheduleId);
}
if (schedule == null)
{
schedule = new Schedule();
}
//list class objects
List<Organization> listOrganizations = new List<Organization>();
List<Course> courseList = new List<Course>();
List<Class> classList = new List<Class>();
List<Subject> subjectList = new List<Subject>();
List<Department> departmentList = new List<Department>();
List<ClassRoom> classRoomList = new List<ClassRoom>();
//class objects
Organization objOrganization = null;
Course objCourse = null;
Class objClass = null;
Subject objSubject = null;
Department objDep = null;
ClassRoom objRoom = null;
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["StudentContext"].ConnectionString);
if (con.State == ConnectionState.Closed)
{
con.Open();
}
using (SqlCommand cmd = new SqlCommand("usp_getSchedules", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@userRole", SqlDbType.VarChar, 50).Value = userRole;
cmd.Parameters.Add("@organizationId", SqlDbType.BigInt).Value = schedule.OrganizationId;
cmd.Parameters.Add("@courseId", SqlDbType.BigInt).Value = schedule.CourseId;
cmd.Parameters.Add("@departmentId", SqlDbType.BigInt).Value = schedule.DepartmentId;
cmd.Parameters.Add("@classId", SqlDbType.BigInt).Value = schedule.ClassId;
cmd.Parameters.Add("@createdByOrganization", SqlDbType.BigInt, 50).Value = organizationId;
SqlDataAdapter adp = new SqlDataAdapter();
adp.SelectCommand = cmd;
DataSet dataSet = new DataSet();
adp.Fill(dataSet);
foreach (DataRow row in dataSet.Tables[0].Rows)
{
objOrganization = new Organization();
objOrganization.OrganizationId = Convert.ToInt64(row["OrganizationId"]);
objOrganization.OrganizationName = Convert.ToString(row["OrganizationName"]);
listOrganizations.Add(objOrganization);
if (userRole != "SiteAdmin")
{
schedule.OrganizationName = objOrganization.OrganizationName;
}
}
foreach (DataRow row in dataSet.Tables[1].Rows)
{
objCourse = new Course();
objCourse.CourseId = Convert.ToInt64(row["CourseId"]);
objCourse.CourseName = Convert.ToString(row["CourseName"]);
courseList.Add(objCourse);
}
foreach (DataRow row in dataSet.Tables[2].Rows)
{
objClass = new Class();
objClass.ClassId = Convert.ToInt64(row["ClassId"]);
objClass.ClassName = Convert.ToString(row["ClassName"]);
classList.Add(objClass);
}
foreach (DataRow row in dataSet.Tables[3].Rows)
{
objSubject = new Subject();
objSubject.SubjectId = Convert.ToInt64(row["SubjectId"]);
objSubject.SubjectName = Convert.ToString(row["SubjectName"]);
subjectList.Add(objSubject);
}
foreach (DataRow row in dataSet.Tables[4].Rows)
{
objDep = new Department();
objDep.DepartmentId = Convert.ToInt64(row["DepartmentId"]);
objDep.DepartmentName = Convert.ToString(row["DepartmentName"]);
departmentList.Add(objDep);
}
foreach (DataRow row in dataSet.Tables[5].Rows)
{
objRoom = new ClassRoom();
objRoom.ClassRoomId = Convert.ToInt64(row["ClassRoomId"]);
objRoom.Name = Convert.ToString(row["Name"]);
classRoomList.Add(objRoom);
}
}
schedule.OrganizationList = new SelectList(listOrganizations, "OrganizationId", "OrganizationName", schedule.OrganizationId);
schedule.CourseList = new SelectList(courseList, "CourseId", "CourseName", schedule.CourseId);
schedule.ClassList = new SelectList(classList, "ClassId", "ClassName", schedule.ClassId);
schedule.SubjectList = new SelectList(subjectList, "SubjectId", "SubjectName", schedule.SubjectId);
schedule.DepartmentList = new SelectList(departmentList, "DepartmentId", "DepartmentName", schedule.DepartmentId);
schedule.ClassRoomList = new SelectList(classRoomList, "ClassRoomId", "Name", schedule.ClassRoomId);
List<SelectListItem> daysList = Enum.GetValues(typeof(StudentTracker.Core.Utilities.Days)).Cast<StudentTracker.Core.Utilities.Days>().Select(v => new SelectListItem
{
Text = v.ToString(),
Value = ((int)v).ToString()
}).ToList();
schedule.DayList = new SelectList(daysList, "Value", "Text");
return schedule;
}
public Staff LoadStaffLists(string userRole, long organizationId = -1, long scheduleId = -1)
{
Staff objStaff = null;
if (scheduleId != -1)
{
//objStaff = this.GetSchedule(scheduleId);
}
if (objStaff == null)
{
objStaff = new Staff();
}
//list class objects
List<Organization> listOrganizations = new List<Organization>();
List<Course> courseList = new List<Course>();
List<Class> classList = new List<Class>();
List<Subject> subjectList = new List<Subject>();
List<Department> departmentList = new List<Department>();
List<Section> sectionList = new List<Section>();
//class objects
Organization objOrganization = null;
Course objCourse = null;
Class objClass = null;
Subject objSubject = null;
Department objDep = null;
Section objSection = null;
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["StudentContext"].ConnectionString);
if (con.State == ConnectionState.Closed)
{
con.Open();
}
using (SqlCommand cmd = new SqlCommand("usp_getSchedules", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@userRole", SqlDbType.VarChar, 50).Value = userRole;
cmd.Parameters.Add("@organizationId", SqlDbType.BigInt).Value = objStaff.OrganizationId;
cmd.Parameters.Add("@courseId", SqlDbType.BigInt).Value = objStaff.CourseId;
cmd.Parameters.Add("@departmentId", SqlDbType.BigInt).Value = objStaff.DepartmentId;
cmd.Parameters.Add("@classId", SqlDbType.BigInt).Value = objStaff.ClassId;
cmd.Parameters.Add("@createdByOrganization", SqlDbType.BigInt, 50).Value = organizationId;
SqlDataAdapter adp = new SqlDataAdapter();
adp.SelectCommand = cmd;
DataSet dataSet = new DataSet();
adp.Fill(dataSet);
foreach (DataRow row in dataSet.Tables[0].Rows)
{
objOrganization = new Organization();
objOrganization.OrganizationId = Convert.ToInt64(row["OrganizationId"]);
objOrganization.OrganizationName = Convert.ToString(row["OrganizationName"]);
listOrganizations.Add(objOrganization);
if (userRole != "SiteAdmin")
{
objStaff.OrganizationName = objOrganization.OrganizationName;
}
}
foreach (DataRow row in dataSet.Tables[1].Rows)
{
objCourse = new Course();
objCourse.CourseId = Convert.ToInt64(row["CourseId"]);
objCourse.CourseName = Convert.ToString(row["CourseName"]);
courseList.Add(objCourse);
}
foreach (DataRow row in dataSet.Tables[2].Rows)
{
objClass = new Class();
objClass.ClassId = Convert.ToInt64(row["ClassId"]);
objClass.ClassName = Convert.ToString(row["ClassName"]);
classList.Add(objClass);
}
foreach (DataRow row in dataSet.Tables[3].Rows)
{
objSubject = new Subject();
objSubject.SubjectId = Convert.ToInt64(row["SubjectId"]);
objSubject.SubjectName = Convert.ToString(row["SubjectName"]);
subjectList.Add(objSubject);
}
foreach (DataRow row in dataSet.Tables[4].Rows)
{
objDep = new Department();
objDep.DepartmentId = Convert.ToInt64(row["DepartmentId"]);
objDep.DepartmentName = Convert.ToString(row["DepartmentName"]);
departmentList.Add(objDep);
}
foreach (DataRow row in dataSet.Tables[6].Rows)
{
objSection = new Section();
objSection.SectionId = Convert.ToInt32(row["SectionId"]);
objSection.SectionName = Convert.ToString(row["SectionName"]);
sectionList.Add(objSection);
}
}
objStaff.OrganizationList = new SelectList(listOrganizations, "OrganizationId", "OrganizationName", objStaff.OrganizationId);
objStaff.CourseList = new SelectList(courseList, "CourseId", "CourseName", objStaff.CourseId);
objStaff.ClassList = new SelectList(classList, "ClassId", "ClassName", objStaff.ClassId);
objStaff.SubjectList = new SelectList(subjectList, "SubjectId", "SubjectName", objStaff.SubjectId);
objStaff.DepartmentList = new SelectList(departmentList, "DepartmentId", "DepartmentName", objStaff.DepartmentId);
objStaff.SectionList = new SelectList(sectionList, "SectionId", "SectionName", objStaff.SectionId);
return objStaff;
}
public long GetCourseId(StudentContext context, string courseName, int organizationId)
{
var course = context.Courses.Where(c => c.CourseName == courseName && c.OrganisationId == organizationId);
if (course == null || course.ToList().Count() == 0)
{
Course newCourse = new Course();
newCourse.CourseName = courseName;
newCourse.OrganisationId = _userStatistics.OrganizationId == 0 ? 1 : Convert.ToInt32(_userStatistics.OrganizationId);
newCourse.CourseDescription = "Created by Code";
newCourse.CreatedBy = _userStatistics.UserId;
newCourse.InsertedOn = DateTime.Now;
context.Courses.Add(newCourse);
context.SaveChanges();
return newCourse.CourseId;
}
else
{
return course.FirstOrDefault().CourseId;
}
}