public int SaveAssignCourse(AssignCourse assignCourse)
{
connection.ConnectionString = connectionString;
string sqlQuery = "INSERT INTO assigned_course_tbl VALUES(@teachersId,@courseId,@departmentId,@credit,1)";
SqlCommand command = new SqlCommand(sqlQuery, connection);
command.Parameters.Clear();
command.Parameters.Add("teachersId", SqlDbType.Int);
command.Parameters["teachersId"].Value = assignCourse.TeachersId;
command.Parameters.Add("courseId", SqlDbType.Int);
command.Parameters["courseId"].Value = assignCourse.CourseId;
command.Parameters.Add("departmentId", SqlDbType.Int);
command.Parameters["departmentId"].Value = assignCourse.DepartmentId;
command.Parameters.Add("credit", SqlDbType.Decimal);
command.Parameters["credit"].Value = assignCourse.CourseCredit;
connection.Open();
int isInserted = command.ExecuteNonQuery();
connection.Close();
return(isInserted);
}
public ActionResult AssignCourseToTeachers(AssignCourse assignCourse)
{
ViewBag.Message = courseAssignManager.SaveAssignCourse(assignCourse);
List <Department> departmentsList = departmentManager.GetDepartmentsList();
return(View(departmentsList));
}
public PartialViewResult TeacherInfoLoad(int?teacherId)
{
if (teacherId != null)
{
Teacher aTeacher = db.Teachers.FirstOrDefault(s => s.TeacherId == teacherId);
ViewBag.Credit = aTeacher.CraditTaken;
List <AssignCourse> assignTeachers =
db.AssignCourses.Where(t => t.TeacherId == teacherId).ToList();
AssignCourse assign = null;
if (assignTeachers.Count != 0)
{
assign = assignTeachers.Last();
}
if (assign == null)
{
ViewBag.RemainingCredit = aTeacher.CraditTaken;
}
else
{
ViewBag.RemainingCredit = assign.RemaingCredit;
}
return(PartialView("~/Views/Shared/_TeachersCreditInfo.cshtml"));
}
else
{
return(PartialView("~/Views/Shared/_TeachersCreditInfo.cshtml"));
}
}
public ActionResult AssignConfirmed()
{
Teacher aTeacher = (Teacher)Session["Teacher"];
AssignCourse assigncourse = (AssignCourse)Session["AssignedCourse"];
AssignCourse assign = (AssignCourse)Session["AssigneddCourseCheck"];
Course aCourse = db.Courses.FirstOrDefault(c => c.CourseId == assigncourse.CourseId);
assigncourse.CreditTaken = aTeacher.CraditTaken;
if (assign == null)
{
assigncourse.RemaingCredit = aTeacher.CraditTaken - aCourse.CourseCradit;
}
else
{
assigncourse.RemaingCredit = assign.RemaingCredit - aCourse.CourseCradit;
}
aCourse.AssignTo = aTeacher.TeacherName;
db.AssignCourses.Add(assigncourse);
db.SaveChanges();
TempData["success"] = "Course Is Assigned";
return(View());
}
public bool IsCourseCodeExist(AssignCourse assignCourse)
{
SqlConnection connection = new SqlConnection(connectionString);
string query = "Select * from CourseAssign where CourseCodeId =(@courseCodeId)";
connection.Open();
SqlCommand command = new SqlCommand(query, connection);
command.Parameters.Add("courseCodeId", SqlDbType.Int);
command.Parameters["courseCodeId"].Value = assignCourse.CourseCodeId;
command.CommandText = query;
command.Connection = connection;
SqlDataReader reader = command.ExecuteReader();
if (reader.Read())
{
return(true);
}
else
{
return(false);
}
}
public ActionResult AskToAssign()
{
Teacher aTeacher = (Teacher)Session["Teacher"];
Course aCourse = (Course)Session["Course"];
AssignCourse assign = (AssignCourse)Session["AssigneddCourseCheck"];
double remainingCredite = 0.0;
if (assign == null)
{
remainingCredite = aTeacher.CraditTaken;
}
else
{
remainingCredite = assign.RemaingCredit;
}
if (remainingCredite < 0)
{
ViewBag.Message = aTeacher.TeacherName
+ " Credit Limit Is Over. And The Course Credit : " + aCourse.CourseCode
+ " Is " + aCourse.CourseCradit
+ " ! Still You Want To Assign This Course To This Teacher ?";
}
else
{
ViewBag.Message = aTeacher.TeacherName
+ " has only " + remainingCredite
+ " Credits Remaining . But, The Credit : " + aCourse.CourseCode
+ " Is " + aCourse.CourseCradit
+ " ! Still You Want To Assign This Course To This Teacher ?";
}
return(View());
}
public string SaveAssignedCourse(AssignCourse assignCourse)
{
if (assignCourseGateway.IsCourseAssigned(assignCourse.Course_Id))
{
int rowAfeected = assignCourseGateway.SaveAssignedCourse(assignCourse);
if (rowAfeected > 0)
{
decimal tempCredit = assignCourse.Creditremain - assignCourse.Credit;
int rowAfeectedbyUpdate = aTeacherGateway.UpdateCredittoremain(tempCredit, assignCourse.Teacher_Id);
if (rowAfeectedbyUpdate > 0)
{
return("Course Assigend sucessfull");
}
else
{
return("Credit no updated");
}
//return "Course Assigend sucessfull";
}
else
{
return("Course Assigend not sucessfull");
}
}
else
{
return("Course Already Assigned");
}
}
public ActionResult AssignCourse(AssignCourse assignCourse)
{
bool isAssignedCourseExist = false;
if (ModelState.IsValid)
{
string message;
isAssignedCourseExist = assignCourseManager.IsAssignedCourseExist(assignCourse);
if (isAssignedCourseExist)
{
message = "Course already assigned!";
ViewBag.Message = message;
}
else
{
message = assignCourseManager.Save(assignCourse);
ViewBag.Message = message;
}
ModelState.Clear();
}
else
{
ViewBag.Message = "Model state is invalid!";
}
ViewBag.IsAssignedCourseExist = isAssignedCourseExist;
ViewBag.Departments = departmentManager.GetAllDepartments();
return(View());
}
public int Save(AssignCourse assignCourse)
{
if (assignCourse.RemainingCredit - assignCourse.Credit < 0)
{
assignCourse.RemainingCredit = 0;
}
else
{
assignCourse.RemainingCredit = assignCourse.RemainingCredit - assignCourse.Credit;
}
string query = "Update Course set AssignTo = @teacher where Id = @courseId;Update Teacher set RemainingCredit = @remainUpdate where Id=@teacher";
SqlCommand command = new SqlCommand(query, connection);
command.Parameters.Clear();
command.Parameters.Add("courseId", SqlDbType.Int);
command.Parameters["courseId"].Value = assignCourse.CourseId;
command.Parameters.Add("teacher", SqlDbType.Int);
command.Parameters["teacher"].Value = assignCourse.TeacherId;
command.Parameters.Add("remainUpdate", SqlDbType.Int);
command.Parameters["remainUpdate"].Value = assignCourse.RemainingCredit;
connection.Open();
int rowAffected = command.ExecuteNonQuery();
connection.Close();
return(rowAffected);
}
public int Save(AssignCourse aAssignCourse)
{
aAssignCourse.Type = 1;
string query = "INSERT INTO AssignCourses(TeacherId,CourseId,AssignType) VALUES(@teacherId,@coureId,@type)";
SqlCommand command = new SqlCommand(query, connection);
command.Parameters.AddWithValue("@teacherId", aAssignCourse.TeacherId);
command.Parameters.AddWithValue("@coureId", aAssignCourse.CourseId);
command.Parameters.AddWithValue("@type", aAssignCourse.Type);
connection.Open();
int rowAffect = command.ExecuteNonQuery();
connection.Close();
double a = aAssignCourse.CreditLeft - aAssignCourse.CourseCredit;
string queryTwo = "UPDATE Teachers SET CreditLeft=@cLeft WHERE Id=@teacherId";
SqlCommand commandTwo = new SqlCommand(queryTwo, connection);
commandTwo.Parameters.AddWithValue("@cLeft", a);
commandTwo.Parameters.AddWithValue("@teacherId", aAssignCourse.TeacherId);
connection.Open();
commandTwo.ExecuteNonQuery();
connection.Close();
string queryOne = "UPDATE Courses SET Type=1 WHERE Id=@courseId";
SqlCommand commandOne = new SqlCommand(queryOne, connection);
commandOne.Parameters.AddWithValue("@courseId", aAssignCourse.CourseId);
connection.Open();
commandOne.ExecuteNonQuery();
connection.Close();
return(rowAffect);
}
public bool IsCourseAssignExists(AssignCourse assignCourse)
{
string query = "Select * from Course where Id = @id and AssignTo >0";
SqlCommand command = new SqlCommand(query, connection);
command.Parameters.Clear();
command.Parameters.Add("id", SqlDbType.Int);
command.Parameters["id"].Value = assignCourse.CourseId;
connection.Open();
SqlDataReader reader = command.ExecuteReader();
bool hasRow = false;
if (reader.HasRows)
{
hasRow = true;
}
reader.Close();
connection.Close();
return(hasRow);
}
public async Task <ActionResult> Create([Bind(Include = "AssignCourseId,DepartmentId,TeacherId,CreditToBeTaken,RemainingCredit,CourseId")] AssignCourse assignCourse)
{
if (ModelState.IsValid)
{
if (IsAssigned(assignCourse))
{
FlashMessage.Danger("This Course is Already Assigned!");
return(RedirectToAction("Create"));
}
//assignCourse.Course.IsAssigned = true;
db.AssignCourses.Add(assignCourse);
await db.SaveChangesAsync();
FlashMessage.Confirmation("Successfully Assigned");
return(RedirectToAction("Create"));
}
ViewBag.DepartmentId = new SelectList(db.Departments, "DepartmentId", "DepartmentCode", assignCourse.DepartmentId);
//ViewBag.TeacherId = new SelectList(db.Teachers, "TeacherId", "TeacherName", assignCourse.TeacherId);
//ViewBag.CourseId = new SelectList(db.Courses, "CourseId", "CourseCode", assignCourse.CourseId);
return(View(assignCourse));
}
public ActionResult CourseAssignToTeacher(AssignCourse assignCourse)
{
//CourseAssignToTeacher();
ViewBag.departments = aDepartmentManager.ViewAllDepartments();
ViewBag.message = aAssignCourseManager.Save(assignCourse);
return(View());
}
private void btnAdd_Click(object sender, EventArgs e)
{
try
{
var teacher = cbSelectTeacher.SelectedItem as Teacher;
var course = cbSelectCourse.SelectedItem as CourseOffering;
var assignCourse = new AssignCourse
{
TeacherID = teacher.TeacherId,
CourseID = course.CourseID
};
var added = assignCourseCRUD.AddAssignCourse(assignCourse);
if (added)
{
MessageBox.Show("Course assigned successfully");
}
else
{
MessageBox.Show("Error while assigning the course!");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public List <AssignCourse> GetCoursesInformation(int departmentId)
{
List <AssignCourse> assignCourses = new List <AssignCourse>();
string query = "Select C.CourseId,C.CourseCode, C.CourseName,S.SemesterName From Course C " +
"Inner Join Semester S On S.SemesterId = C.SemesterId " +
"Where C.DepartmentId = @departmentId";
Gateway gateway = new Gateway(query);
gateway.SqlCommand.Parameters.Clear();
gateway.SqlCommand.Parameters.AddWithValue("@departmentId", departmentId);
SqlDataReader reader = gateway.SqlCommand.ExecuteReader();
while (reader.Read())
{
AssignCourse assignCourse = new AssignCourse();
Course course = new Course();
course.CourseId = (int)reader["CourseId"];
course.CourseCode = reader["CourseCode"].ToString();
course.CourseName = reader["CourseName"].ToString();
assignCourse.Course = course;
Semester semester = new Semester();
semester.SemesterName = reader["SemesterName"].ToString();
assignCourse.Semester = semester;
assignCourses.Add(assignCourse);
}
reader.Close();
gateway.Connection.Close();
return(assignCourses);
}
public ActionResult DeleteConfirmed(int id)
{
AssignCourse assignCourse = db.AssignCourses.Find(id);
db.AssignCourses.Remove(assignCourse);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult AssignCourse(AssignCourse assignCourse)
{
if (ModelState.IsValid)
{
ViewBag.Result = aTeacherManager.AssignCourse(assignCourse);
}
ViewBag.Departments = departmentManager.ViewDepartment();
return(View());
}
public async Task <ActionResult> DeleteConfirmed(int id)
{
AssignCourse assignCourse = await db.AssignCourses.FindAsync(id);
db.AssignCourses.Remove(assignCourse);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public string AssignCourse(AssignCourse assignCourse)
{
if (aTeacherGatway.IsExitsCourse(assignCourse.Course))
{
return("Course Already Assigned");
}
aTeacherGatway.AssignCourse(assignCourse);
return("Course Assigne Successful");
}
public ActionResult AssignCourse(AssignCourse assignCourse)
{
if (ModelState.IsValid)
{
ViewBag.message = courseManager.AssignToTeacher(assignCourse);
}
ViewBag.Departments = departmentManager.GetAllDepartmentForDropdown();
return(View());
}
//
// GET: /AssignCourse/Details/5
public ActionResult Details(int id = 0)
{
AssignCourse assigncourse = db.AssignCourses.Find(id);
if (assigncourse == null)
{
return(HttpNotFound());
}
return(View(assigncourse));
}
public ActionResult Assign(AssignCourse assignCourse)
{
if (assignCourse.RemainingCredit - assignCourse.Credit < 0)
{
ViewBag.Messages = "Credit Over Load";
}
DepartmentBind();
ViewBag.Message = assignCourseManager.Save(assignCourse);
return(View());
}
public int SaveAssignedCourse(AssignCourse assignCourse)
{
Query = "INSERT INTO AssignedCourse(Department_Id,Teacher_Id,Course_Id,Status_Id) Values('" + assignCourse.Department_Id + "','" + assignCourse.Teacher_Id + "','" + assignCourse.Course_Id + "','1')";
Connection.Open();
Command = new SqlCommand(Query, Connection);
int rowAffected = Command.ExecuteNonQuery();
Connection.Close();
return(rowAffected);
}
public ActionResult CourseAssign(AssignCourse assignCourse)
{
ViewBag.listOfDepartments = assignCourseManager.GetAllDepartment();
ViewBag.listOfTeachers = assignCourseManager.GetAllTeacher();
ViewBag.listOfCourse = assignCourseManager.GetAllCourse();
string message = assignCourseManager.InsertAssignedCourse(assignCourse);
ViewBag.Message = message;
return(View());
}
public ActionResult Edit([Bind(Include = "StudentId,CourseId")] AssignCourse assignCourse)
{
if (ModelState.IsValid)
{
db.Entry(assignCourse).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(assignCourse));
}
public bool IsAssigned(AssignCourse assign)
{
var assignedCourses = db.AssignCourses.ToList();
if (assignedCourses.Any(c => (c.CourseId == assign.CourseId)))
{
return(true);
}
return(false);
}
public ActionResult Assign(AssignCourse assignCourse)
{
string msg = aTeacherManager.AssignCourseToTeacher(assignCourse);
ModelState.Clear();
ViewBag.Message = msg;
List <Department> departments = aDepartmentManager.GetAllDepartmentsInfo();
ViewBag.Departments = departments;
return(View());
}
public ActionResult AssignCourse(AssignCourse assignCourse)
{
List <Department> aDepartments = aDepartmentManager.GetAllDepartment();
ViewBag.DepatmentList = aDepartments;
string message = assignCourseManager.SaveAssignedCourse(assignCourse);
ViewBag.message = message;
return(View());
}
public ActionResult Create([Bind(Include = "StudentId,CourseId")] AssignCourse assignCourse)
{
if (ModelState.IsValid)
{
db.AssignCourses.Add(assignCourse);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(assignCourse));
}
public bool IsCourseAlreadyAssigned(AssignCourse assignCourse)
{
Query = "SELECT * FROM AssignCourse Where CourseId = '" + assignCourse.CourseId + "' AND Flag = '1'";
Command = new SqlCommand(Query, Connection);
Connection.Open();
Reader = Command.ExecuteReader();
bool result = Reader.HasRows;
Reader.Close();
Connection.Close();
return(result);
}
