public int Save(AssignedCourse assignedCourse)
{
string query = "INSERT INTO AssignedCourse VALUES(@departmentId,@teacherId,@courseId,@status)";
Command = new SqlCommand(query, Connection);
Command.Parameters.Clear();
Command.Parameters.Add("departmentId", SqlDbType.Int);
Command.Parameters["departmentId"].Value = assignedCourse.DepartmentId;
Command.Parameters.Add("teacherId", SqlDbType.Int);
Command.Parameters["teacherId"].Value = assignedCourse.TeacherId;
Command.Parameters.Add("courseId", SqlDbType.Int);
Command.Parameters["courseId"].Value = assignedCourse.CourseId;
Command.Parameters.Add("status", SqlDbType.Bit);
Command.Parameters["status"].Value = assignedCourse.Status;
Connection.Open();
int rowAffected = Command.ExecuteNonQuery();
Connection.Close();
return(rowAffected);
}
public ActionResult AssignedCourse(AssignedCourse assignedCourse)
{
assignedCourse.Status = true;
ViewBag.Update = aAssignedCourseManager.Update(assignedCourse);
ViewBag.Message = aAssignedCourseManager.Save(assignedCourse);
ViewBag.Departments = aDepartmentManager.GetAllDepartments();
return(View());
}
public ActionResult Edit(int id)
{
var repository = new AssignedRepository(context);
var includes = new Expression <Func <AssignedCourse, object> >[] { x => x.Course, x => x.Individual };
var criteria = new AssignedCourse {
Id = id
};
var courses = repository.QueryByExampleIncludig(criteria, includes).SingleOrDefault();
var model = MapperHelpers.Map <EditAssignmentViewModel>(courses);
return(View(model));
}
private object m_CargaModeloEdit(int id)
{
var repository = new AssignedCourseRepository(context);
//Expression<>[]
//Expression<Func<Type,object>>[]{ x=>x.Propiedad }
var includes = new Expression <Func <AssignedCourse, object> >[] { x => x.Course, x => x.Individual };
var criteria = new AssignedCourse {
Id = id
};
var courses = repository.QueryByExampleIncludig(criteria, includes).SingleOrDefault();
var model = MapperHelper.Map <EditAssignedCourseViewModels>(courses);
return(model);
}
public int Update(AssignedCourse assignedCourse)
{
string query =
"UPDATE Teacher SET RemainingCredit = " + assignedCourse.RemainingCredit + " - " + assignedCourse.Credit + " WHERE Id = '" + assignedCourse.TeacherId + "'";
Command = new SqlCommand(query, Connection);
Connection.Open();
var rowAffected = Command.ExecuteNonQuery();
Connection.Close();
return(rowAffected);
}
public string Save(AssignedCourse assignedCourse)
{
if (aAssignedCourseGateway.IsCourseExists(assignedCourse))
{
return("This course is already assigned");
}
else
{
int rowAffected = aAssignedCourseGateway.Save(assignedCourse);
if (rowAffected > 0)
{
return("Course saved");
}
return("Save failed");
}
}
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Student student = db.Students.Find(id);
if (student == null)
{
return(HttpNotFound());
}
ICollection <Course> courses = student.Courses;
List <AssignedCourse> assignedCourses = new List <AssignedCourse>();
foreach (var item in courses)
{
var assignedCourse = new AssignedCourse
{
CourseId = item.CourseId,
CourseName = item.CourseName,
Assigned = true
};
assignedCourses.Add(assignedCourse);
}
StudentViewModel model = new StudentViewModel
{
StudentId = student.StudentId,
FirstName = student.FirstName,
LastName = student.LastName,
ParentName = student.ParentName,
Phone = student.Phone,
Address = student.Address,
Grade = student.Grade,
EMail = student.EMail,
Courses = assignedCourses
};
List <Grade> grades = db.Grades.Where(m => m.StudentId == id).ToList();
ViewBag.grades = grades;
return(View(model));
}
public decimal Update(AssignedCourse assignedCourse)
{
if (aAssignedCourseGateway.IsCourseExists(assignedCourse))
{
return(assignedCourse.RemainingCredit);
}
else
{
var rowAffected = aAssignedCourseGateway.Update(assignedCourse);
if (rowAffected > 0)
{
return(assignedCourse.RemainingCredit - assignedCourse.Credit);
}
else
{
return(assignedCourse.RemainingCredit);
}
}
}
public bool IsCourseExists(AssignedCourse assignedCourse)
{
string query = "SELECT * FROM AssignedCourse WHERE CourseId = '" + assignedCourse.CourseId + "' ";
Command = new SqlCommand(query, Connection);
Connection.Open();
Reader = Command.ExecuteReader();
bool hasRow = false;
if (Reader.HasRows)
{
hasRow = true;
}
Reader.Close();
Connection.Close();
return(hasRow);
}
