public void Update(CourseAssign entity)
{
var CourseAssign = CourseAssignRepository.Find(entity.Id);
CourseAssign.CourseId = entity.CourseId;
CourseAssign.TeacherId = entity.TeacherId;
CourseAssign.DepartmentId = entity.DepartmentId;
CourseAssignRepository.Update(CourseAssign);
unitOfWork.SaveChanges();
}
//
// GET: /CourseAssign/Details/5
public ActionResult Details(int id = 0)
{
CourseAssign courseassign = db.CourseAssigns.Find(id);
if (courseassign == null)
{
return(HttpNotFound());
}
return(View(courseassign));
}
public int Save(CourseAssign courseAssign)
{
string query = "INSERT INTO CourseAssign VALUES('" + courseAssign.DepartmentId + "','" + courseAssign.TeacherId + "','" + courseAssign.CourseId + "','" + 1 + "')";
Command = new SqlCommand(query, Connection);
Connection.Open();
int rowAffect = Command.ExecuteNonQuery();
Connection.Close();
return(rowAffect);
}
public string AssignSave(CourseAssign courseAssign)
{
if (TeacherGateway.AssignSave(courseAssign) > 0)
{
return("Saved");
}
else
{
return("Not saved");
}
}
public int AssignNewCourse(CourseAssign courseAssign)
{
string query = @"INSERT INTO TeacherAsign Values('Assign','" + courseAssign.TeacherId + "','" + courseAssign.CourseId + "')";
cmd = new SqlCommand(query, connection);
connection.Open();
int rowAffect = cmd.ExecuteNonQuery();
connection.Close();
return(rowAffect);
}
public ActionResult AssignCourse(CourseAssign courseAssign)
{
if (Session["username"] == null)
{
return(RedirectToAction("Login", "Account"));
}
ViewBag.response = aTeacherManager.AssignCourse(courseAssign);
ViewBag.Departments = aDepartmentManager.GetAllDepartments();
return(View());
}
public int Save(CourseAssign aCourseAssign)
{
Query = "Insert into AssignCourse Values('" + aCourseAssign.Id + "','" + aCourseAssign.CourseId + "','" + aCourseAssign.RemainingCredit + "','Assign') ";
Command = new SqlCommand(Query, Connection);
Connection.Open();
int rowAffected = Command.ExecuteNonQuery();
Connection.Close();
return(rowAffected);
}
public string SaveAssignTeacher(CourseAssign course)
{
if (courseGateway.SaveAssignTeacher(course) > 0)
{
return("Save");
}
else
{
return("Error");
}
}
public int AssignNewCourse(CourseAssign courseAssign)
{
string query = "INSERT INTO AssignTeacherTable Values('Assign','" + courseAssign.TeacherId + "','" + courseAssign.CourseId + "')";
_command = new SqlCommand(query, _connection);
_connection.Open();
int rowAffect = _command.ExecuteNonQuery();
_connection.Close();
return(rowAffect);
}
public ActionResult AssignTeacher(CourseAssign courseAssign)
{
if (!ModelState.IsValid)
{
ViewBag.Departments = departmentBll.GetDepartments();
return(View("AssignTeacher"));
}
ViewBag.Message = courseBll.SaveAssignTeacher(courseAssign);
ViewBag.Departments = departmentBll.GetDepartments();
return(View());
}
public bool IsSubjectExsists(CourseAssign courseAssign)
{
string query = "SELECT * FROM CourseAssign WHERE CourseCode='" + courseAssign.CourseCode + "' AND TeacherId='" + courseAssign.TeacherId + "'";
Command = new SqlCommand(query, Connection);
Connection.Open();
Reader = Command.ExecuteReader();
bool IsExsists = Reader.HasRows;
Connection.Close();
return(IsExsists);
}
//To unassign course//
public bool UnassignCourse(CourseAssign courseAssign)
{
var CourseAssigns = dbContext.CourseAssigns.Where(x => x.Assign == true);
foreach (var item in CourseAssigns)
{
item.Assign = false;
}
int rowaffected = dbContext.SaveChanges();
return(rowaffected > 0);
}
public ActionResult Edit(CourseAssign courseassign)
{
if (ModelState.IsValid)
{
db.Entry(courseassign).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.TeacherId = new SelectList(db.Teachers, "TeacherId", "Name", courseassign.TeacherId);
ViewBag.CourseId = new SelectList(db.Courses, "CourseId", "Code", courseassign.CourseId);
return(View(courseassign));
}
//
// GET: /CourseAssign/Edit/5
public ActionResult Edit(int id = 0)
{
CourseAssign courseassign = db.CourseAssigns.Find(id);
if (courseassign == null)
{
return(HttpNotFound());
}
ViewBag.TeacherId = new SelectList(db.Teachers, "TeacherId", "Name", courseassign.TeacherId);
ViewBag.CourseId = new SelectList(db.Courses, "CourseId", "Code", courseassign.CourseId);
return(View(courseassign));
}
public ActionResult Edit([Bind(Include = "id,DepartmentId,TeacherId,CreditToBeTaken,RemainingCredit,CourseId,CourseName")] CourseAssign courseAssign)
{
if (ModelState.IsValid)
{
db.Entry(courseAssign).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CourseId = new SelectList(db.Courses, "Id", "CourseCode", courseAssign.CourseId);
ViewBag.DepartmentId = new SelectList(db.Departments, "Id", "DepartmentName", courseAssign.DepartmentId);
ViewBag.TeacherId = new SelectList(db.Teachers, "Id", "Name", courseAssign.TeacherId);
return(View(courseAssign));
}
public string AssignCourse(CourseAssign courseAssign)
{
var rowAffected = courseGateway.AssignCourse(courseAssign);
if (rowAffected[0] > 0 && rowAffected[1] > 0 && rowAffected[2] > 0)
{
return("Course Assigned.");
}
else
{
return("Course Assign failed.");
}
}
public bool Add(CourseAssign courseAssign)
{
bool IsSaved = _repository.Add(courseAssign);
if (IsSaved)
{
return(true);
}
else
{
return(false);
}
}
internal string SaveCourseAssain(CourseAssign courseAssign)
{
if (courseAssign.CourseName == "")
{
throw new Exception("Enter Email ....!!!!!");
}
//int aTest = _courseAssignGetway.GetValidation(courseAssign.CourseName);
//if (aTest > 0)
//{
// throw new Exception("this Code already Existed....!!!!!");
//}
return(_courseAssignGetway.SaveCourseAssain(courseAssign));
}
public dynamic SaveAssignCourse(CourseAssign courseAssign)
{
int rowAffect = anCourseAssignGateway.SaveAssignCourse(courseAssign);
if (rowAffect > 0)
{
return("Saved");
}
else
{
return("Failed");
}
}
//save
public string Save(CourseAssign courseAssign)
{
if (unitofWork.CourseAssign.IsExists(x => x.TeacherId == courseAssign.TeacherId && x.CourseId == courseAssign.CourseId && x.IsDelete == 0))
{
return(Message.Warning("Course" + courseAssign.Course.Name + "was already assign by" + courseAssign.Teacher.Name + "Teacher"));
}
else
{
unitofWork.CourseAssign.Add(courseAssign);
int rowAffect = unitofWork.Completed();
return((rowAffect > 0) ? Message.Success("Save Successful") : Message.Failed("Save Failed"));
}
}
public string InsertNewCourse(CourseAssign courseAssign)
{
int rowAffected = aCourseAssignGateway.AssignNewCourse(courseAssign);
if (rowAffected > 0)
{
return("Teacher Course Assign Successfully Done!!!");
}
else
{
return("Course Assign Failed!!");
}
}
// update
public string Update(CourseAssign courseAssign)
{
if (unitofWork.CourseAssign.IsExists(x => x.TeacherId == courseAssign.TeacherId && x.CourseId == courseAssign.CourseId && x.IsDelete == 0 && x.Id == courseAssign.Id))
{
return(Message.Warning("Course Already Exists"));
}
else
{
unitofWork.CourseAssign.Update(courseAssign);
int updated = unitofWork.Completed();
return((updated > 0) ? "1" : Message.Failed("Update Failed"));
}
}
public ActionResult Edit([Bind(Include = "CourseAssignID,DepartmentID,CourseID,TeacherID")] CourseAssign courseassign)
{
if (ModelState.IsValid)
{
db.Entry(courseassign).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CourseID = new SelectList(db.CoursesDbset, "CourseID", "CourseCredit", courseassign.CourseID);
ViewBag.DepartmentID = new SelectList(db.DepartmentsDbset, "DepartmentID", "DepartmentCode", courseassign.DepartmentID);
ViewBag.TeacherID = new SelectList(db.TeachersDcset, "TeacherID", "TeacherName", courseassign.TeacherID);
return(View(courseassign));
}
public string AssignCourse(CourseAssign courseassign)
{
int assignCourse = courseAssignGateway.AssignCourse(courseassign.TeacherId, courseassign.CourseId);
if (assignCourse > 0)
{
double remainingCredit = courseassign.ReaminingCredit - courseassign.Credit;
int updateRemainingCredit = courseAssignGateway.UpdateRemainingCreditOfTeacher(remainingCredit,
courseassign.TeacherId);
}
return("Course Assign Successfully.");
}
public ActionResult Assigning(CourseAssign courseassignto)
{
if (ModelState.IsValid)
{
db.CourseAssigns.Add(courseassignto);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Departments = db.Departments.ToList();
ViewBag.CourseID = new SelectList(db.Courses, "Id", "CourseCode", courseassignto.CourseID);
ViewBag.DepartmentId = new SelectList(db.Departments, "Id", "DeptCode", courseassignto.DepartmentId);
ViewBag.TeacherId = new SelectList(db.Teachers, "Id", "TeacherName", courseassignto.TeacherId);
return(View(courseassignto));
}
public bool IsCourseAssigned(CourseAssign courseAssign)
{
string query = "SELECT * FROM CourseAssign WHERE Active = '" + 1 + "' AND DepartmentId = '" +
courseAssign.DepartmentId + "' AND TeacherId = '" + courseAssign.TeacherId +
"' AND CourseId = '" + courseAssign.CourseId + "' ";
Command = new SqlCommand(query, Connection);
Connection.Open();
Reader = Command.ExecuteReader();
bool isExists = Reader.HasRows;
Connection.Close();
return(isExists);
}
// GET: /CourseAssign/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
CourseAssign courseassign = db.CourseAssigns.Find(id);
if (courseassign == null)
{
return(HttpNotFound());
}
return(View(courseassign));
}
public ActionResult Create([Bind(Include = "Id,DepartmentId,TeacherId,CreditTaken,CreditLeft,CourseID,Name,Credit")] CourseAssign courseassign)
{
if (ModelState.IsValid)
{
db.CourseAssigns.Add(courseassign);
db.SaveChanges();
// return RedirectToAction("Index");
}
ViewBag.CourseID = new SelectList(db.Courses, "Id", "CourseCode", courseassign.CourseID);
ViewBag.DepartmentId = new SelectList(db.Departments, "Id", "DeptCode", courseassign.DepartmentId);
ViewBag.TeacherId = new SelectList(db.Teachers, "Id", "TeacherName", courseassign.TeacherId);
return(View(courseassign));
}
public JsonResult CourseAssign(CourseAssign courseAssign)
{
courseAssign.ReaminingCredit = courseAssign.ReaminingCredit - courseAssign.Credit;
string log = anCourseAssignManager.SaveAssignCourse(courseAssign);
anCourseAssignManager.UpdateReaminingCredit(courseAssign.ReaminingCredit, courseAssign.TeacherId);
ViewBag.Department = aSaveTeacherManager.TakeAllDeparment();
return(Json(log));
}
public bool IsCourseNotAssigned(CourseAssign aCourseAssign)
{
Command = new SqlCommand();
Command.CommandText = "SELECT * FROM t_course WHERE course_id = '" + aCourseAssign.CourseId + "' AND course_status = 'Not Assigned Yet' ";
Command.Connection = Connection;
Connection.Open();
Reader = Command.ExecuteReader();
while (Reader.Read())
{
return(true);
}
Reader.Close();
Connection.Close();
return(false);
}
