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"); } } }