public int BacklogCourseSave(BacklogRegistration aBacklogRegistration) { Query = "INSERT INTO BacklogRegistration VALUES (@sid,@cid, @batch)"; Command = new SqlCommand(Query, Connection); Command.Parameters.Clear(); Command.Parameters.Add("sid", SqlDbType.VarChar); Command.Parameters["sid"].Value = aBacklogRegistration.StudentId; Command.Parameters.Add("cid", SqlDbType.Int); Command.Parameters["cid"].Value = aBacklogRegistration.CourseId; Command.Parameters.Add("batch", SqlDbType.VarChar); Command.Parameters["batch"].Value = aBacklogRegistration.BacklogBatch; Connection.Open(); int rowAffected = Command.ExecuteNonQuery(); Connection.Close(); return(rowAffected); }
public List <BacklogRegistration> ShowBacklogRegistrationbyStudentId(string studentId) { Query = "SELECT * FROM BacklogRegistration,Course WHERE BacklogRegistration.StudentId='" + studentId + "' AND Course.CourseId=BacklogRegistration.courseid"; Command = new SqlCommand(Query, Connection); Connection.Open(); Reader = Command.ExecuteReader(); List <BacklogRegistration> backlogInformation = new List <BacklogRegistration>(); while (Reader.Read()) { BacklogRegistration aBacklogStudentInformation = new BacklogRegistration(); aBacklogStudentInformation.BacklogRegistrationId = (int)Reader["BacklogRegistrationId"]; aBacklogStudentInformation.StudentId = Reader["StudentId"].ToString(); aBacklogStudentInformation.CourseId = (int)Reader["courseid"]; aBacklogStudentInformation.BacklogBatch = Reader["BacklogBatch"].ToString(); aBacklogStudentInformation.CourseCode = Reader["CourseCode"].ToString(); aBacklogStudentInformation.CourseName = Reader["CourseName"].ToString(); aBacklogStudentInformation.CourseCredit = Convert.ToDouble(Reader["CourseCredit"]); backlogInformation.Add(aBacklogStudentInformation); } Reader.Close(); Connection.Close(); return(backlogInformation); }
public List <BacklogRegistration> StudentEnrollinParticularCourse(int courseId, string batch) { Query = "SELECT * FROM BacklogRegistration,StudentInformation WHERE courseid='" + courseId + "' AND BacklogBatch='" + batch + "' AND BacklogRegistration.StudentId=StudentInformation.StudentId"; Command = new SqlCommand(Query, Connection); Connection.Open(); Reader = Command.ExecuteReader(); List <BacklogRegistration> aBacklogRegistrations = new List <BacklogRegistration>(); while (Reader.Read()) { BacklogRegistration aBacklogRegistration = new BacklogRegistration(); aBacklogRegistration.StudentId = Reader["StudentId"].ToString(); aBacklogRegistration.StudentName = Reader["StudentName"].ToString(); aBacklogRegistrations.Add(aBacklogRegistration); } Reader.Close(); Connection.Close(); return(aBacklogRegistrations); }
public string BacklogCourseSave(BacklogRegistration aBacklogRegistration) { bool isExist = aBacklogGateway.IsStudentExists(aBacklogRegistration); if (isExist) { int updateCTAttendance = aBacklogGateway.UpdateCTAttendanceStatus(aBacklogRegistration); int rowAffected = aBacklogGateway.BacklogCourseSave(aBacklogRegistration); if (rowAffected > 0) { return("You have Successfully Registered with the Course"); } else { return("Sorry Your Registration have failed."); } } else { return ("Sorry Your Registration have failed.You may not be Enrolled this Course Before.So Enroll New Registration."); } }
public int UpdateCTAttendanceStatus(BacklogRegistration aBacklogRegistration) { Query = "UPDATE InputCTAttendence SET CT1='0',CT2='0',CT3='0',CT4='0',CT5='0',Attendence='0' WHERE InputCTAttendence.courseid='" + aBacklogRegistration.CourseId + "' AND InputCTAttendence.StudentId='" + aBacklogRegistration.StudentId + "'"; Command = new SqlCommand(Query, Connection); Connection.Open(); int rowAffected = Command.ExecuteNonQuery(); Connection.Close(); return(rowAffected); }
public bool IsStudentExists(BacklogRegistration aBacklogRegistration) { Query = "SELECT * FROM EnrollCourse WHERE EnrollCourse.StudentId='" + aBacklogRegistration.StudentId + "' AND EnrollCourse.courseid='" + aBacklogRegistration.CourseId + "'"; Command = new SqlCommand(Query, Connection); Connection.Open(); Reader = Command.ExecuteReader(); bool isExist = Reader.HasRows; Reader.Close(); Connection.Close(); return(isExist); }
public ActionResult BacklogRegistration(BacklogRegistration aBacklogRegistration) { ViewBag.message = aBacklogManager.BacklogCourseSave(aBacklogRegistration); ViewBag.getCourse = aCourseManager.GetAllCourses().ToList(); return(View()); }