public int AssignCourseToTeacher(CourseAssignTeacher assignCourse)
{
Query = "INSERT INTO CourseAssignTeacher Values('" + assignCourse.DepartmentId + "','" + assignCourse.TeacherId + "','" + assignCourse.CourseId + "','1')";
Command = new SqlCommand(Query, Connection);
Connection.Open();
int rowAffected = Command.ExecuteNonQuery();
Connection.Close();
UpdateTeacherRemainingCredit(assignCourse);
return(rowAffected);
}
public int AssignCourse(CourseAssignTeacher courseAssignTeacher)
{
//string query = "INSERT INTO CourseAssignTeacher VALUES('Assign',@TeacherId,@CourseId)";
//string query = "INSERT INTO CourseAssignTeacher VALUES('Assign','"+courseAssignTeacher.TeacherId+"','"+courseAssignTeacher.CourseId+"')";
string query = "INSERT INTO CourseAssignToTeacher VALUES('" + courseAssignTeacher.TeacherId + "','" + courseAssignTeacher.CourseId + "','Assigned')";
Command = new SqlCommand(query, Connection);
Connection.Open();
int rowAffect = Command.ExecuteNonQuery();
Connection.Close();
return(rowAffect);
}
public string SaveCourseAssignTeacher(CourseAssignTeacher aCourseAssignTeacher)
{
if (aCourseAssignTeacherGateway.IsCourseAssigned(aCourseAssignTeacher.CourseId) != null)
{
return("course already assigned");
}
if (aCourseAssignTeacherGateway.SaveCourseAssignTeacher(aCourseAssignTeacher) > 0)
{
return("yes");
}
else
{
return("no");
}
}
public int Save(CourseAssignTeacher assingTeacher)
{
string query = "Insert into CourseAssignTeacher" +
"Values(@teacherId,@courseId,@action,@deptId)";
command = new SqlCommand(query, connection);
command.Parameters.AddWithValue("@teacherId", assingTeacher.TeacherId);
command.Parameters.AddWithValue("@courseId", assingTeacher.CourseId);
command.Parameters.AddWithValue("@action", assingTeacher.Action);
command.Parameters.AddWithValue("@deptId", assingTeacher.DeptId);
connection.Open();
int rowAffect = command.ExecuteNonQuery();
connection.Close();
return(rowAffect);
}
public CourseAssignTeacher IsCourseAssigned(int courseId)
{
Query = "SELECT * FROM CourseAssignTeacher WHERE CourseId='" + courseId + "' AND Valid='True'";
Command = new SqlCommand(Query, Connection);
CourseAssignTeacher assignTeacher = new CourseAssignTeacher();
Connection.Open();
Reader = Command.ExecuteReader();
if (!Reader.HasRows)
{
assignTeacher = null;
}
Reader.Close();
Connection.Close();
return(assignTeacher);
}
public string Save(CourseTeacherViewModel aCourseTeacherViewModel)
{
CourseAssignTeacher aCourseAssignTeacher = new CourseAssignTeacher();
aCourseAssignTeacher.TeacherId = aCourseTeacherViewModel.TeacherId;
aCourseAssignTeacher.DepartmentId = aCourseTeacherViewModel.DepartmentId;
aCourseAssignTeacher.CourseId = aCourseTeacherViewModel.CourseId;
aCourseAssignTeacher.CreditTaken = aCourseTeacherViewModel.CourseCredit;
aCourseAssignTeacher.IsActive = true;
bool flag = aUnitOfWork.Repository <CourseAssignTeacher>().InsertModel(aCourseAssignTeacher);
aUnitOfWork.Save();
return("Assigned Successfully");
}
public string AssignCourseToTeacher(CourseAssignTeacher assignCourse)
{
if (aCourseAssignGateway.IsCourseAlreadyAssigned(assignCourse))
{
return("Course Already Assigned");
}
int rowAffected = aCourseAssignGateway.AssignCourseToTeacher(assignCourse);
if (rowAffected > 0)
{
return("Course assign successful");
}
else
{
return("Course assign failed");
}
}
public string AssignCourseToTeacher(CourseAssignTeacher courseAssignTeacher)
{
SqlConnection con = new SqlConnection(connectionString);
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "UPDATE Course SET AssignTo='" + courseAssignTeacher.TeacherId + "' WHERE Id='" + courseAssignTeacher.CourseId + "'";
cmd.CommandType = CommandType.Text;
cmd.Connection = con;
con.Open();
int rowAffected = cmd.ExecuteNonQuery();
if (rowAffected > 0)
{
return("Course Assigned");
}
con.Close();
return("Course Assign Failed");
}
public JsonResult GetCourseList(int departmentId)
{
IEnumerable <Course> coursesList = aCourseManager.GetCourseByDeptId(departmentId);
IEnumerable <CourseAssignTeacher> assingList =
aCourseAssignToTeacherManager.GetListByDepartmentId(departmentId);
List <Course> courses = new List <Course>();
foreach (var list in coursesList)
{
CourseAssignTeacher assign = assingList.FirstOrDefault(x => x.CourseId == list.Id);
if (assign == null)
{
courses.Add(list);
}
}
return(Json(courses, JsonRequestBehavior.AllowGet));
}
public int UpdateTeacherRemainingCredit(CourseAssignTeacher courseAssign)
{
double courseCredit = 0;
Query = "SELECT Credit FROM Course Where Id = '" + courseAssign.CourseId + "'";
Command = new SqlCommand(Query, Connection);
Connection.Open();
Reader = Command.ExecuteReader();
while (Reader.Read())
{
courseCredit = Convert.ToDouble(Reader["Credit"]);
}
Reader.Close();
Connection.Close();
Query = "Update Teacher Set RemainingCredit = RemainingCredit - '" + courseCredit + "' Where Id = '" + courseAssign.TeacherId + "'";
return(GetRowAffect(Query));
}
//************************* For Assign *******************
public string AssignCourse(CourseAssignTeacher courseAssignTeacher)
{
if (courseAssignGateway.IsCourseExists(courseAssignTeacher.CourseId))
{
return("This Course already has been taken");
}
else
{
int rowAffect = courseAssignGateway.AssignCourse(courseAssignTeacher);
if (rowAffect > 0)
{
return("Assign Successful");
}
else
{
return("Assign Failed");
}
}
}
public int SaveCourseAssignTeacherInfo(CourseAssignTeacher aCourseAssignTeacher)
{
_query = "INSERT INTO CourseAssignTeacher(TeacherId ,CourseId) values(@TeacherId, @CourseId)";
_command = new SqlCommand(_query, _connection);
_command.Parameters.AddWithValue("@TeacherId", aCourseAssignTeacher.TeacherId);
_command.Parameters.AddWithValue("@CourseId", aCourseAssignTeacher.CourseId);
_connection.Open();
int rowAffect = _command.ExecuteNonQuery();
_connection.Close();
return(rowAffect);
}
public int AssignCourseToTeacher(CourseAssignTeacher courseAssignTeacher)
{
Query = "INSERT INTO CourseAssignTeacher(TeacherId,CourseId,CourseCredit,IsActive) VALUES(@TeacherId,@CourseId,@CourseCredit,1)";
Command.CommandText = Query;
Command.Connection = Connection;
Command.Parameters.Clear();
Command.Parameters.Add("TeacherId", SqlDbType.Int);
Command.Parameters["TeacherId"].Value = courseAssignTeacher.TeacherId;
Command.Parameters.Add("CourseId", SqlDbType.Int);
Command.Parameters["CourseId"].Value = courseAssignTeacher.CourseId;
Command.Parameters.Add("CourseCredit", SqlDbType.Decimal);
Command.Parameters["CourseCredit"].Value = courseAssignTeacher.Credit;
Connection.Open();
int rowsAffected = Command.ExecuteNonQuery();
Query = "UPDATE Course SET IsActive=1 WHERE Id='" + courseAssignTeacher.CourseId + "' ";
Command.CommandText = Query;
Command.ExecuteNonQuery();
Connection.Close();
return(rowsAffected);
}
public bool IsExistAssign(CourseAssignTeacher assignExist)
{
_query = "SELECT * FROM CourseAssignTeacher WHERE TeacherId = @TeacherId AND CourseId = @CourseId";
_command = new SqlCommand(_query, _connection);
_command.Parameters.AddWithValue("@TeacherId", assignExist.TeacherId);
_command.Parameters.AddWithValue("@CourseId", assignExist.CourseId);
_connection.Open();
_reader = _command.ExecuteReader();
bool isExist = _reader.HasRows;
_reader.Close();
_connection.Close();
return(isExist);
}
public int UpdateTeacherRemainingCredit(CourseAssignTeacher aCourseAssignTeacher)
{
double courseCredit = 0;
Query = "SELECT Credit FROM Course Where Id = '" + aCourseAssignTeacher.CourseId + "'";
Command = new SqlCommand(Query, Connection);
Connection.Open();
Reader = Command.ExecuteReader();
while (Reader.Read())
{
courseCredit = Convert.ToDouble(Reader["Credit"]);
}
Reader.Close();
Connection.Close();
Query = "UPDATE Teacher SET RemainingCredit=RemainingCredit-'" + courseCredit +
"' WHERE Id='" + aCourseAssignTeacher.TeacherId + "'";
Command = new SqlCommand(Query, Connection);
Connection.Open();
int rowAffected = Command.ExecuteNonQuery();
Connection.Close();
return(rowAffected);
}
public ActionResult Index(CourseAssignTeacher assignTeacher)
{
ViewBag.Message = _courseAssignTeacherManager.AssignCourseToTeacher(assignTeacher);
ViewBag.Departments = _departmentManager.GetAllDepartment();
return(View());
}
public bool IsCourseAlreadyAssigned(CourseAssignTeacher courseAssign)
{
Query = "SELECT * FROM CourseAssignTeacher Where CourseId = '" + courseAssign.CourseId + "' AND Assign = 'Yes'";
return(GetIsExist(Query));
}
public ActionResult Save(CourseAssignTeacher courseAssign)
{
ViewBag.Message = courseAssignTeacherManager.Save(courseAssign);
ViewBag.Departments = departmentManager.GetSelectListItemsForDropdown();
return(View());
}
public ActionResult Save(CourseAssignTeacher courseAssignTeacher)
{
ViewBag.Departments = departmentManager.ShowAllDepartments();
ViewBag.Message = teacherManager.AssignCourseToTeacher(courseAssignTeacher) ? "Course Assigned" : "Course Assign Failed";
return(View());
}
public bool AssignCourseToTeacher(CourseAssignTeacher courseAssignTeacher)
{
return(teacherGateway.AssignCourseToTeacher(courseAssignTeacher) > 0);
}
