public async Task <ActionResult> Create(CourseAssignModel model)
{
try
{
var courses = new List <Course>();
var teachId = model.TeacherId;
courses = model.Courses;
for (int i = 0; i < courses.Count(); i++)
{
if (courses[i].CheckboxAnswer == true)
{
var csa = new CourseAssignement();
csa.CourseId = courses[i].Id;
csa.TeacherId = teachId;
crsa.Add(csa);
}
}
await crsa.SaveChangesAsync();
return(RedirectToAction("Details", new RouteValueDictionary(
new { controller = "Teacher", action = "Details", Id = model.TeacherId })));
}
catch (Exception)
{
throw;
}
}
public List <CourseAssignModel> GatAllViewCourseStaticGateway()
{
SqlConnection con = new SqlConnection(conectionStirng);
string query = "select * from vAssignedCourse";
SqlCommand cmd = new SqlCommand(query, con);
con.Open();
SqlDataReader dataReader = cmd.ExecuteReader();
List <CourseAssignModel> courseAssignModels = new List <CourseAssignModel>();
if (dataReader.HasRows)
{
while (dataReader.Read())
{
CourseAssignModel courseAssignModel = new CourseAssignModel();
courseAssignModel.DepartmentId = Convert.ToInt32(dataReader["DepartmentID"]);
courseAssignModel.CourseCode = dataReader["CourseCode"].ToString();
courseAssignModel.CourseName = dataReader["CourseName"].ToString();
courseAssignModel.SemesterName = dataReader["SemiName"].ToString();
courseAssignModel.TeacherName = dataReader["AssignedTo"].ToString();
courseAssignModels.Add(courseAssignModel);
}
dataReader.Close();
}
con.Close();
return(courseAssignModels);
}
//GET :
public PartialViewResult Create(int id)
{
var model = new CourseAssignModel();
model.Teacher = th.GetById(id);
model.Courses = crs.GetAll();
model.TeacherId = model.Teacher.Id;
return(PartialView(model));
}
public int SaveCourseAssignGateway(CourseAssignModel courseAssignModel)
{
SqlConnection con = new SqlConnection(conectionStirng);
string query = "insert into CourseAssign values ('" + courseAssignModel.DepartmentId + "','" +
courseAssignModel.TeacherId + "', '" + courseAssignModel.CourseId + "')";
SqlCommand cmd = new SqlCommand(query, con);
con.Open();
int rowAffect = cmd.ExecuteNonQuery();
con.Close();
return(rowAffect);
}
public string IsExistCourseGateway(CourseAssignModel courseAssignModel)
{
string message = null;
SqlConnection con = new SqlConnection(conectionStirng);
string query = "Select * from CourseAssign where CourseID='" + courseAssignModel.CourseId + "'";
SqlCommand cmd = new SqlCommand(query, con);
con.Open();
SqlDataReader dataReader = cmd.ExecuteReader();
if (dataReader.HasRows)
{
message = "This Course Already Assign Another Teacher";
}
con.Close();
return(message);
}
public PartialViewResult Edit(int id)
{
var model = new CourseAssignModel();
model.Teacher = th.GetById(id);
model.Courses = crs.GetAll();
model.TeacherId = model.Teacher.Id;
foreach (var item in model.Courses)
{
if (crsa.IfExists(item.Id, model.TeacherId))
{
item.CheckboxAnswer = true;
}
}
return(PartialView(model));
}
public string SaveCourseAssignManager(CourseAssignModel courseAssignModel)
{
if (courseAssignGateway.IsExistCourseGateway(courseAssignModel) == null)
{
if (courseAssignGateway.SaveCourseAssignGateway(courseAssignModel) > 0)
{
return("Save Successfull");
}
else
{
return("Save Fail");
}
}
else
{
return(courseAssignGateway.IsExistCourseGateway(courseAssignModel));
}
}
public async Task <ActionResult> Edit(CourseAssignModel model)
{
try
{
var courses = new List <Course>();
var teacherId = model.TeacherId;
courses = model.Courses;
for (int i = 0; i < courses.Count(); i++)
{
if (courses[i].CheckboxAnswer == true)
{
if (!crsa.IfExists(courses[i].Id, teacherId))
{
var csa = new CourseAssignement();
csa.CourseId = courses[i].Id;
csa.TeacherId = teacherId;
crsa.Add(csa);
}
}
else
{
if (crsa.IfExists(courses[i].Id, teacherId))
{
var csa = await crsa.GetByIdAsync(courses[i].Id, teacherId);
if (csa == null)
{
return(NotFound());
}
crsa.Remove(csa);
}
}
}
await crsa.SaveChangesAsync();
return(RedirectToAction("Details", new RouteValueDictionary(
new { controller = "Teacher", action = "Details", Id = model.TeacherId })));
}
catch (Exception)
{
throw;
}
}
public CourseAssignModel GateCourseCredit(int?courseId)
{
SqlConnection con = new SqlConnection(conectionStirng);
string query = "Select * from Course where CourseID='" + courseId + "'";
SqlCommand cmd = new SqlCommand(query, con);
con.Open();
SqlDataReader dataReader = cmd.ExecuteReader();
CourseAssignModel courseAssignModel = new CourseAssignModel();
if (dataReader.HasRows)
{
dataReader.Read();
courseAssignModel.CourseId = Convert.ToInt32(dataReader["CourseID"]);
courseAssignModel.CourseName = dataReader["CourseName"].ToString();
courseAssignModel.CourseCredit = Convert.ToDecimal(dataReader["CourseCredit"]);
dataReader.Close();
}
con.Close();
return(courseAssignModel);
}
public CourseAssignModel GatTeacherCreditGateway(int?teacherId)
{
SqlConnection con = new SqlConnection(connectionString);
string query = "Select * from vTeacherCourse where TeacherID='" + teacherId + "'";
SqlCommand cmd = new SqlCommand(query, con);
con.Open();
CourseAssignModel courseAssignModel = new CourseAssignModel();
SqlDataReader dataReader = cmd.ExecuteReader();
if (dataReader.HasRows)
{
dataReader.Read();
courseAssignModel.CourseId = Convert.ToInt32(dataReader["TeacherID"]);
courseAssignModel.TeacherCreditToTaken = Convert.ToDecimal(dataReader["CreditTaken"]);
courseAssignModel.TeacherRemainingCredit = Convert.ToDecimal(dataReader["RemCredit"]);
dataReader.Close();
}
con.Close();
return(courseAssignModel);
}
public JsonResult CreditTakenByCourseId(int?passCourse)
{
CourseAssignModel courseCredit = courseManager.GateCourseCredit(passCourse);
return(Json(courseCredit, JsonRequestBehavior.AllowGet));
}
public JsonResult CreditTakenByTeacher(int?teacherId)
{
CourseAssignModel courseTeacher = teacherManager.GatTeacherCreditManger(teacherId);
return(Json(courseTeacher, JsonRequestBehavior.AllowGet));
}
public ActionResult SaveCourseAssign(CourseAssignModel courseAssignModel)
{
ViewBag.message = courseManager.SaveCourseAssignManager(courseAssignModel);
ViewBag.DepartmentList = departmentManager.GateAllDepertmentManager();
return(View());
}
