public ActionResult EnrollStudentInCourse(EnrollCourse aEnrollCourse)
{
List <Student> aStudents = aStudentManager.GetAllStudent();
ViewBag.StudentList = aStudents;
int deptId = aDepartmentManager.GetDepatmentIdByCode(aEnrollCourse.Code);
aEnrollCourse.DepartmentId = deptId;
string message = aEnrollCourseManager.EnrollCourse(aEnrollCourse);
ViewBag.message = message;
return(View());
}
////public ActionResult SendSMS()
////{
//// var accountSid = "AC906cf3e15a58e843bd25e9298e88e043";
//// var authToken = "18504a6d2779d2a1971ebe0cb669b11e";
//// TwilioClient.Init(accountSid, authToken);
//// var to = new PhoneNumber();
//// var from = new PhoneNumber("+13343924931");
//// var message = MessageResource.Create(to: to, from: from, body: "");
//// return message;
////}
// GET: /EnrollCourse/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
EnrollCourse enrollcourse = db.EnrollCourses.Find(id);
if (enrollcourse == null)
{
return(HttpNotFound());
}
return(View(enrollcourse));
}
public int EnrollCourse(EnrollCourse enrollCourse)
{
Qurey = "INSERT INTO enrollCourse VALUES(@regNo, @courseId, @enrollDate)";
Command = new SqlCommand(Qurey, Connection);
Command.Parameters.AddWithValue("@regNo", enrollCourse.RegNo);
Command.Parameters.AddWithValue("@courseId", enrollCourse.CourseId);
Command.Parameters.AddWithValue("@enrollDate", enrollCourse.Date);
Connection.Open();
RowAffected = Command.ExecuteNonQuery();
Connection.Close();
return(RowAffected);
}
public int Save(EnrollCourse enrollCourse)
{
string query = "INSERT INTO EnrollCourse VALUES(@registrationNo,@courseId,@date)";
Command = new SqlCommand(query, Connection);
Command.Parameters.AddWithValue("@registrationNo", enrollCourse.RegistrationNo);
Command.Parameters.AddWithValue("@courseId", enrollCourse.CourseId);
Command.Parameters.AddWithValue("@date", enrollCourse.Date.ToShortDateString());
Connection.Open();
int rowAffect = Command.ExecuteNonQuery();
Connection.Close();
return(rowAffect);
}
public int EnrollInCourse(EnrollCourse enrollCourse)
{
SqlConnection connection = new SqlConnection(connectionString);
string query = "INSERT INTO t_EnrollInCourse(StudentId,CourseId,Date,IsStudentActive) VALUES(@StudentId,@CourseId,@Date,@IsStudentActive)";
SqlCommand command = new SqlCommand(query, connection);
command.Parameters.AddWithValue("@StudentId", enrollCourse.StudentId);
command.Parameters.AddWithValue("@CourseId", enrollCourse.CourseId);
command.Parameters.AddWithValue("@Date", enrollCourse.Date);
command.Parameters.AddWithValue("@IsStudentActive", 1);
connection.Open();
int rowAffected = command.ExecuteNonQuery();
return(rowAffected);
}
// GET: /EnrollCourse/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
EnrollCourse enrollcourse = db.EnrollCourses.Find(id);
if (enrollcourse == null)
{
return(HttpNotFound());
}
ViewBag.CourseId = new SelectList(db.Courses, "Id", "CourseCode", enrollcourse.CourseId);
return(View(enrollcourse));
}
public bool IsUniqEnrollCourse(EnrollCourse aEnrollCourse)
{
SqlConnection connection = new SqlConnection(connectionString);
string query = "SELECT * FROM EnrollCourse WHERE StudentId=" + aEnrollCourse.StudentId + " AND CourseId=" + aEnrollCourse.CourseId;
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
return(true);
}
connection.Close();
return(false);
}
internal dynamic EnrollCourse(EnrollCourse aEnrollCourse)
{
if (aStudentGateway.EnrolledCourseExist(aEnrollCourse.CourseId))
{
return("Course Already Enrolled");
}
else if (aStudentGateway.EnrollCourse(aEnrollCourse) > 0)
{
return("Enrolled Successfull");
}
else
{
return("Enrolled failed");
}
}
public int Save(EnrollCourse enroll)
{
string query = "INSERT INTO EnrollCourse VALUES(@studentId,@courseId,@date,@status)";
Command = new SqlCommand(query, Connection);
Command.Parameters.AddWithValue("@studentId", enroll.StudentId);
Command.Parameters.AddWithValue("@courseId", enroll.CourseId);
Command.Parameters.AddWithValue("@date", enroll.Date);
Command.Parameters.AddWithValue("@status", enroll.Status);
Connection.Open();
int rowAffect = Command.ExecuteNonQuery();
Connection.Close();
return(rowAffect);
}
public int Save(EnrollCourse enrollCourse)
{
if (enrollCourse.StudenId != 0 && enrollCourse.CourseId != 0)
{
if (IsCourseExist(enrollCourse.StudenId, enrollCourse.CourseId))
{
throw new Exception("This Course has already been enrolled by this student!");
}
return(enrollCourseGateway.Save(enrollCourse));
}
else
{
throw new Exception("Please Select Student and Course");
}
}
public ActionResult Enroll(EnrollCourse enrollCourse)
{
if (ModelState.IsValid)
{
ViewBag.StudentRegNo = studentManager.GetSelectListItemsForDropdown();
string message = enrollManager.Save(enrollCourse);
ViewBag.Message = message;
ModelState.Clear();
return(View());
}
else
{
ViewBag.Message = "Model Is not Valid";
return(View());
}
}
public bool Insert(EnrollCourse aEnrollCourse)
{
SqlConnection connection = new SqlConnection(connectionString);
string query = "INSERT INTO EnrollCourse(StudentId,CourseId,Date)VALUES('" + aEnrollCourse.StudentId + "','" + aEnrollCourse.CourseId + "','" + aEnrollCourse.Date + "')";
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
int rowAffected = command.ExecuteNonQuery();
if (rowAffected > 0)
{
return(true);
}
connection.Close();
return(false);
}
protected void StudentRegNoDropDownList_SelectedIndexChanged(object sender, EventArgs e)
{
EnrollCourse _EnrollCourse = new EnrollCourse();
_EnrollCourse.Id = Convert.ToInt32(StudentRegNoDropDownList.SelectedValue);
var StudentData = _EnrollCourseManager.GetStudentData(_EnrollCourse.Id);
if (StudentData != null)
{
txtStudentName.Text = StudentData.StudentName.ToString();
txtStudentEmail.Text = StudentData.StudentEmail.ToString();
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Do Not have Anydata');", true);
}
}
public bool IsCourseEnrolled(EnrollCourse enroll)
{
string query = "SELECT * FROM EnrollCourse WHERE StudentId=@studentId AND CourseId=@courseId";
Command = new SqlCommand(query, Connection);
Command.Parameters.AddWithValue("@studentId", enroll.StudentId);
Command.Parameters.AddWithValue("@courseId", enroll.CourseId);
Connection.Open();
Reader = Command.ExecuteReader();
bool isExists = Reader.HasRows;
Connection.Close();
return(isExists);
}
public ActionResult Save(EnrollCourse enroll)
{
if (ModelState.IsValid)
{
enroll.Status = "Allocate";
string message = enrollCourseManager.Save(enroll);
ViewBag.Message = message;
ViewBag.Students = enrollCourseManager.GetStudentsForDropDown();
}
else
{
ViewBag.Students = enrollCourseManager.GetStudentsForDropDown();
return(View());
}
return(View());
}
public int Save(EnrollCourse aAssignCourse)
{
aAssignCourse.GradeId = 0;
string query = "INSERT INTO EnrollCourses(StudentId,CourseId,Date,GradeId) VALUES(@studentId,@coureId,@date,@gradeId)";
SqlCommand command = new SqlCommand(query, connection);
command.Parameters.AddWithValue("@studentId", aAssignCourse.StudentId);
command.Parameters.AddWithValue("@coureId", aAssignCourse.CourseId);
command.Parameters.AddWithValue("@date", aAssignCourse.FullDate);
command.Parameters.AddWithValue("@gradeId", aAssignCourse.GradeId);
connection.Open();
int rowAffect = command.ExecuteNonQuery();
connection.Close();
return(rowAffect);
}
// GET: UCRMS/Edit/5
public ActionResult EditEnrollCourse(int?id)
{
ViewBag.Student = new SelectList(db.Students.ToList().OrderBy(s => s.Id), "Id", "RegNo");
ViewBag.Course = new SelectList(db.Courses.ToList().OrderBy(s => s.Id), "Id", "Name");
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
EnrollCourse enroll = db.EnrollCourses.Find(id);
if (enroll == null)
{
return(HttpNotFound());
}
return(View(enroll));
}
// GET: UCRMS/Delete/5
public ActionResult DeleteEnrollCourse(int?id)
{
VM_EnrollCourse ec = new VM_EnrollCourse();
ViewBag.enrolled = ec.EnrollCourse(id);
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
EnrollCourse enrollCourse = db.EnrollCourses.Find(id);
if (enrollCourse == null)
{
return(HttpNotFound());
}
return(View(enrollCourse));
}
public bool IsExist(EnrollCourse aEnrollCourse)
{
Query = "SELECT* FROM EnrollCourse WHERE StudentId='" + aEnrollCourse.StudentId + "' AND CourseId='" + aEnrollCourse.CourseId + "' AND Status='True'";
Command = new SqlCommand(Query, Connection);
Connection.Open();
Reader = Command.ExecuteReader();
if (Reader.HasRows)
{
Connection.Close();
return(true);
}
else
{
Connection.Close();
return(false);
}
}
public ActionResult EnrollCourse(EnrollCourse aCourse)
{
if (ModelState.IsValid)
{
ViewBag.Message = aEnrollCourseManager.Save(aCourse);
ViewBag.RegNoList = aStudentManager.GetAllStudentRegNoForDropdown();
ModelState.Clear();
return(View());
}
else
{
ViewBag.Message = "Please Fill All Field Correctly";
ViewBag.RegNoList = aStudentManager.GetAllStudentRegNoForDropdown();
return(View());
}
}
public EnrollCourse GetStudentData(int Id)
{
EnrollCourse _EnrollCourse = null;
string query = "select *From Students Where Id='" + Id + "'";
var reader = _MainRepository.Reader(query, _MainRepository.ConnectionString());
if (reader.HasRows)
{
reader.Read();
_EnrollCourse = new EnrollCourse();
_EnrollCourse.StudentName = reader["StudentName"].ToString();
_EnrollCourse.StudentEmail = reader["StudentEmail"].ToString();
}
reader.Close();
return(_EnrollCourse);
}
public ActionResult Enroll(EnrollCourse aEnrollCourse)
{
StudentsManagersrb aManagersrb = new StudentsManagersrb();
ViewBag.students = aManagersrb.GetallStudent();
EnrollCourseManagersrb aenEnrollCourseManagersrb = new EnrollCourseManagersrb();
string result = aenEnrollCourseManagersrb.EnrollCourse(aEnrollCourse);
if (result == "Save Successful")
{
ViewBag.success = result;
}
else if (result == "This Course has been Already Taken by this Student")
{
ViewBag.failed = result;
}
return(View());
}
public int SaveEnrollCourseGateway(EnrollCourse aEnrollCourse)
{
_query = "INSERT INTO EnrollCourse(StudentRegId, CourseId, EnrollDate) values(@StudentRegId, @CourseId, @EnrollDate)";
_command = new SqlCommand(_query, _connection);
_command.Parameters.AddWithValue("@StudentRegId", aEnrollCourse.StudentRegId);
_command.Parameters.AddWithValue("@CourseId", aEnrollCourse.CourseId);
_command.Parameters.AddWithValue("@EnrollDate", aEnrollCourse.Date);
_connection.Open();
int rowAffect = _command.ExecuteNonQuery();
_connection.Close();
return(rowAffect);
}
public string EnrollInCourse(EnrollCourse enrollCourse)
{
if (GetCourses(enrollCourse.StudentId).Find(a => a.StudentId == enrollCourse.StudentId && a.CourseId == enrollCourse
.CourseId) != null)
{
return("Already Enrolled");
}
int rowAffected = enrollCourseGateway.EnrollInCourse(enrollCourse);
if (rowAffected > 0)
{
return("Saved");
}
else
{
return("Not Saved");
}
}
public string Save(EnrollCourse aAssignCourse)
{
if (aEnrollCourseGateway.IsExistsCourse(aAssignCourse))
{
return("Course Already Enrolled of That Student");
}
else
{
int rowAffect = aEnrollCourseGateway.Save(aAssignCourse);
if (rowAffect == 1)
{
return("Course Enrolled Succesfuly");
}
else
{
return("Course Enrolled Failed");
}
}
}
public string Save(EnrollCourse enrollCourse)
{
if (enrollGateway.IsNameExsists(enrollCourse))
{
return("This Course Already Exist");
}
else
{
int rowAffect = enrollGateway.Save(enrollCourse);
if (rowAffect > 0)
{
return("Save Successfuly");
}
else
{
return("Save Failed");
}
}
}
public ActionResult Create([Bind(Include = "EnrollCourseId,StudentId,CourseId,Date")] EnrollCourse enrollcourse)
{
if (ModelState.IsValid)
{
//EnrollCourse courseAlreadyEnrolled = new EnrollCourse();
var courseAlreadyEnrolled = db.EnrollCourses.Include(ec => ec.Course).Include(ec => ec.Student).Where(ec => ec.StudentId == enrollcourse.StudentId).Where(ec => ec.CourseId == enrollcourse.CourseId).Select(es => es.EnrollCourseId).DefaultIfEmpty(0).Single();
if (courseAlreadyEnrolled <= 0)
{
db.EnrollCourses.Add(enrollcourse);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
ViewBag.CourseId = new SelectList(db.Courses, "CourseId", "Code", enrollcourse.CourseId);
ViewBag.StudentId = new SelectList(db.Students, "StudentId", "RegNo", enrollcourse.StudentId);
TempData["ThisCourseAlreadyAssigned"] =
"Hi, " + db.Students.Where(s => s.StudentId == enrollcourse.StudentId).Select(s => s.Name).Single() + " You are already enrolled/added this course, Choose another course";
return(View(enrollcourse));
}
public List <EnrollCourse> GetStudentByRegNo(string regNo)
{
string query = "select r.Name as StudentName,r.Id as StudentId, r.Email as StudentEmail," +
"d.DepartmentName as DepartmentName ,d.Id as DepartmentId, c.Id as CourseId," +
"c.CourseName as CourseName from RegisterStudent as r " +
"full join Department as d " +
"on r.DeptId= d.Id " +
"full join Course as c " +
"on c.DeptId=d.Id where r.RegNo='" + regNo + "'";
Command = new SqlCommand(query, Connection);
Connection.Open();
Reader = Command.ExecuteReader();
List <EnrollCourse> students = new List <EnrollCourse>();
while (Reader.Read())
{
EnrollCourse student = new EnrollCourse();
student.StudentName = Reader["StudentName"].ToString();
student.StudentEmail = Reader["StudentEmail"].ToString();
student.StudentId = Convert.ToInt32(Reader["StudentId"]);
student.DepartmentName = Reader["DepartmentName"].ToString();
string checkCourseId = Reader["CourseId"].ToString();
if (checkCourseId != "")
{
student.CourseId = Convert.ToInt32(Reader["CourseId"]);
student.CourseName = Reader["CourseName"].ToString();
}
else
{
student.CourseId = 0;
//student.CourseName = null;
}
student.DepartmentId = Convert.ToInt32(Reader["DepartmentId"]);
//student.CourseName = Reader["CourseName"].ToString();
students.Add(student);
}
Reader.Close();
Connection.Close();
return(students);
}
public int CousreEnrollSave(EnrollCourse courseEnroll)
{
string query = "INSERT INTO EnrollCourse(StudentRegistrationNo, Name,Department,CourseId,Date) VALUES " +
"(@StudentRegistrationNo,@Name,@Department,@CourseId,@Date)";
command = new SqlCommand(query, connection);
command.Parameters.AddWithValue("@StudentRegistrationNo", courseEnroll.StudentRegistrationNo);
command.Parameters.AddWithValue("@Name", courseEnroll.Name);
command.Parameters.AddWithValue("@Department", courseEnroll.Department);
command.Parameters.AddWithValue("@CourseId", courseEnroll.CourseId);
command.Parameters.AddWithValue("@Date", courseEnroll.Date);
connection.Open();
int rowAffect = command.ExecuteNonQuery();
connection.Close();
return(rowAffect);
}
public string Save(EnrollCourse enrollCourse)
{
if (aEnrollCourseGateway.AlreadyEnrolledInCourse(enrollCourse))
{
return("Course already enrolled");
}
else
{
int rowAffected = aEnrollCourseGateway.Save(enrollCourse);
if (rowAffected > 0)
{
return("Enrolled Successfully");
}
else
{
return("Enrolled Failed");
}
}
}
