public ActionResult CoursesEnroll(CourseEnroll aCourseEnroll)
{
ViewBag.allStudentRegNo = aCourseEnrollManager.GetAllStudents();
ViewBag.Message = aCourseEnrollManager.SaveEnroll(aCourseEnroll);
return(View());
}
public List <CourseEnroll> GetCourseByStudentId()
{
Query = "SELECT * FROM CourseEnroll";
Command = new SqlCommand(Query, Connection);
List <CourseEnroll> aList = new List <CourseEnroll>();
Connection.Open();
Reader = Command.ExecuteReader();
while (Reader.Read())
{
CourseEnroll aCourseEnroll = new CourseEnroll()
{
Id = (int)Reader["Id"],
StudentId = (int)Reader["StudentId"],
CourseId = (int)Reader["CourseId"]
};
aList.Add(aCourseEnroll);
}
Reader.Close();
Connection.Close();
foreach (CourseEnroll t in aList)
{
Query = "SELECT Code FROM Course WHERE Id=" + t.CourseId;
Command = new SqlCommand(Query, Connection);
Connection.Open();
Reader = Command.ExecuteReader();
while (Reader.Read())
{
t.CourseCode = Reader["Code"].ToString();
}
Reader.Close();
Connection.Close();
}
return(aList);
}
public ActionResult EnrollCourse(CourseEnroll courseEnroll)
{
ViewBag.listOfStudentRegNo = studentManager.GetAllStudents.ToList();
ViewBag.message = courseEnrollManager.EnrollCourse(courseEnroll);
ModelState.Clear();
return(View());
}
public async Task <string> Update(int Id, CourseEnroll courseEnroll)
{
try
{
using (SqlConnection conn = new SqlConnection(con.DatabaseConnection))
{
conn.Open();
var result = await conn.ExecuteScalarAsync <int>(CourseEnroll_query.Update, new
{
pCourse_ID = courseEnroll.Course_Id,
pStudent_ID = courseEnroll.Student_Id,
pStartDate = courseEnroll.StartDate,
pEndDate = courseEnroll.EndDate,
pUserId = courseEnroll.UserID,
pId = Id
}, commandTimeout : 0);
return(result.ToString());
};
}
catch (Exception ex)
{
throw ex;
}
}
public JsonResult GetStudentInfoByStudentId(Student student)
{
var getAllstudent = db.Students.ToList();
var studentDetails = getAllstudent.FirstOrDefault(a => a.Id == student.Id);
CourseEnroll aCourseEnroll = new CourseEnroll();
int deptId;
if (studentDetails != null)
{
aCourseEnroll.Name = studentDetails.Name;
aCourseEnroll.Email = studentDetails.Email;
deptId = studentDetails.DepartmentId;
var department = db.Departments.FirstOrDefault(x => x.Id == deptId);
if (department != null)
{
aCourseEnroll.Department = department.Name;
}
}
//string value = string.Empty;
//value = JsonConvert.SerializeObject(takenAndRemainingCredit, Formatting.Indented, new JsonSerializerSettings
//{
// ReferenceLoopHandling = ReferenceLoopHandling.Ignore
//});
return(Json(aCourseEnroll, JsonRequestBehavior.AllowGet));
}
public ActionResult DeleteConfirmed(int id)
{
CourseEnroll courseenroll = db.CourseEnrolls.Find(id);
db.CourseEnrolls.Remove(courseenroll);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public int EnrollCourse(CourseEnroll courseEnroll)
{
Query = "INSERT INTO EnrollCourse VALUES('" + courseEnroll.StudentId + "','" + courseEnroll.CourseId + "','" + courseEnroll.EnrollDate + "')";
Command.CommandText = Query;
Connection.Open();
int rowAffected = Command.ExecuteNonQuery();
Connection.Close();
return(rowAffected);
}
public int SaveCourseEnroll(CourseEnroll aCourseEnroll)
{
Query = "INSERT INTO CourseEnroll VALUES('" + aCourseEnroll.StudentId + "','" + aCourseEnroll.CourseId +
"','" + aCourseEnroll.Date + "')";
Command = new SqlCommand(Query, Connection);
Connection.Open();
int rowAffected = Command.ExecuteNonQuery();
Connection.Close();
return(rowAffected);
}
public ActionResult Enroll(CourseEnroll courseEnroll)
{
ViewBag.Students = studentManager.GetAllStudents();
if (ModelState.IsValid)
{
ViewBag.Message = courseEnrollManager.SaveStudentEnrollment(courseEnroll);
}
return(View());
}
public ActionResult SaveResult(CourseEnroll studentResult)
{
ViewBag.Students = studentManager.GetAllStudents();
ViewBag.Grades = studentManager.GetAllGrades();
if (ModelState.IsValid)
{
ViewBag.Message = studentManager.SaveStudentResult(studentResult);
}
return(View());
}
public ActionResult Edit([Bind(Include = "CourseEnrollId,StudentRegNo,CourseId,EnrollDate")] CourseEnroll courseenroll)
{
if (ModelState.IsValid)
{
db.Entry(courseenroll).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CourseId = new SelectList(db.Courses, "CourseId", "CourseCode", courseenroll.CourseId);
return(View(courseenroll));
}
public int EnrollCourse(CourseEnroll courseEnroll)
{
SqlConnection connection = new SqlConnection(connectionString);
string Query = "INSERT INTO EnrollInACourse(StudentId,CourseId,Date,Status) VALUES('" + courseEnroll.StudentId + "','" + courseEnroll.CourseId + "','" + courseEnroll.EnrollDate + "','True')";
SqlCommand Command = new SqlCommand(Query, connection);
connection.Open();
int rowAffected = Command.ExecuteNonQuery();
connection.Close();
return(rowAffected);
}
public ActionResult Enroll(CourseEnroll aCourseEnroll)
{
List <SelectListItem> getSelectRegNo = aStudentManager.GetSelectRegNo();
ViewBag.GetSelectRegNo = getSelectRegNo;
ViewBag.Message = aCourseEnrollManager.SaveCourseEnroll(aCourseEnroll);
if (ViewBag.Message == "yes")
{
ModelState.Clear();
}
return(View());
}
public string SaveStudentResult(CourseEnroll studentResult)
{
int rowAffected = studentGateway.SaveStudentResult(studentResult);
if (rowAffected < 1)
{
return("Sorry! Student Result Save Failed");
}
else
{
return("Saved Successfully!!");
}
}
// GET: /CourseEnroll/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
CourseEnroll courseenroll = db.CourseEnrolls.Find(id);
if (courseenroll == null)
{
return(HttpNotFound());
}
return(View(courseenroll));
}
public string SaveCourseEnroll(CourseEnroll aCourseEnroll)
{
if (aEnrollGateway.IsStudentInCourseExist(aCourseEnroll.StudentId, aCourseEnroll.CourseId) != null)
{
return("enroll not unique");
}
if (aEnrollGateway.SaveCourseEnroll(aCourseEnroll) > 0)
{
return("yes");
}
else
{
return("no");
}
}
// GET: /CourseEnroll/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
CourseEnroll courseenroll = db.CourseEnrolls.Find(id);
if (courseenroll == null)
{
return(HttpNotFound());
}
ViewBag.CourseId = new SelectList(db.Courses, "CourseId", "CourseCode", courseenroll.CourseId);
return(View(courseenroll));
}
public async Task <IActionResult> Post([FromBody] CourseEnroll courses)
{
var resulr = await dal.Create(courses);
if (resulr != null)
{
return(Ok(new
{
message = "Successfully create course enroll",
}));
}
else
{
return(BadRequest(new { message = "Invalid Input" }));
}
}
public int GetIdForStudent(CourseEnroll enrollCourse)
{
int sId = 0;
Query = "SELECT Id FROM Student WHERE Name='" + enrollCourse.StudentName + "'";
Command = new SqlCommand(Query, Connection);
Connection.Open();
Reader = Command.ExecuteReader();
if (Reader.Read())
{
sId = (int)Reader["Id"];
}
Reader.Close();
Connection.Close();
return(sId);
}
public string FindSameCourseForAStudent(CourseEnroll courseEnroll)
{
Query = "SELECT * FROM EnrollCourse WHERE StudentId='" + courseEnroll.StudentId + "' AND CourseId='" + courseEnroll.CourseId + "'";
Command.CommandText = Query;
string message = null;
Connection.Open();
Reader = Command.ExecuteReader();
if (Reader.HasRows)
{
message = "This Course Already Enroll by This Student";
}
Reader.Close();
Connection.Close();
return(message);
}
public CourseEnroll IsStudentInCourseExist(int studentId, int courseId)
{
Query = "SELECT * FROM CourseEnroll WHERE StudentId='" + studentId + "' AND CourseId=" + courseId;
Command = new SqlCommand(Query, Connection);
CourseEnroll aCourseEnroll = new CourseEnroll();
Connection.Open();
Reader = Command.ExecuteReader();
if (!Reader.HasRows)
{
aCourseEnroll = null;
}
Reader.Close();
Connection.Close();
return(aCourseEnroll);
}
public int SaveStudentResult(CourseEnroll studentResult)
{
string query = "UPDATE CourseEnroll SET CourseGrade = @grade WHERE " +
"StudentId=@id AND CourseId=@courseId";
Command = new SqlCommand(query, Connection);
Command.Parameters.AddWithValue("@grade", studentResult.CourseGrade);
Command.Parameters.AddWithValue("@id", studentResult.StudentId);
Command.Parameters.AddWithValue("@courseId", studentResult.CourseId);
Connection.Open();
int rowAffect = Command.ExecuteNonQuery();
Connection.Close();
return(rowAffect);
}
public async Task <IActionResult> Put(int Id, [FromBody] CourseEnroll courses)
{
var resulr = await dal.Update(Id, courses);
if (resulr != null)
{
return(Ok(new
{
StatusCode = true,
message = "Successfully update the user",
}));
}
else
{
return(BadRequest(new { StatusCode = false, message = "Invalid Input" }));;
}
}
public bool CourseCheck(CourseEnroll courseId)
{
string query = "SELECT * FROM CourseEnroll WHERE CourseId = @courseId and StudentId = @id and Flag = @flag";
Command = new SqlCommand(query, Connection);
Command.Parameters.AddWithValue("@courseId", courseId.CourseId);
Command.Parameters.AddWithValue("@id", courseId.StudentId);
Command.Parameters.AddWithValue("@flag", 1);
Connection.Open();
SqlDataReader reader = Command.ExecuteReader();
reader.Read();
bool isExist = reader.HasRows;
Connection.Close();
return(isExist);
}
public string FindSameCourseForAStudent(CourseEnroll courseEnroll)
{
SqlConnection connection = new SqlConnection(connectionString);
string Query = "SELECT * FROM EnrollInACourse WHERE StudentId='" + courseEnroll.StudentId + "' AND CourseId='" + courseEnroll.CourseId + "'";
SqlCommand Command = new SqlCommand(Query, connection);
string message = null;
connection.Open();
SqlDataReader Reader = Command.ExecuteReader();
if (Reader.HasRows)
{
message = "This Course Already Enroll by This Student";
}
Reader.Close();
connection.Close();
return(message);
}
public string SaveStudentEnrollment(CourseEnroll courseEnroll)
{
if (courseEnrollGateway.CourseCheck(courseEnroll))
{
return("Sorry! Course Enrollment Failed");
}
int rowAffected = courseEnrollGateway.SaveStudentEnrollmen(courseEnroll);
if (rowAffected > 0)
{
return("Saved Successfully!!");
}
else
{
return("Sorry! Course Enrollment Failed");
}
}
public string EnrollCourse(CourseEnroll courseEnroll)
{
if (courseEnrollGateway.FindSameCourseForAStudent(courseEnroll) == null)
{
if (courseEnrollGateway.EnrollCourse(courseEnroll) > 0)
{
return("Course Enroll Successfully.");
}
else
{
return("Sory! Course Enroll Fail.");
}
}
else
{
return(courseEnrollGateway.FindSameCourseForAStudent(courseEnroll));
}
}
public int EnrollSave(CourseEnroll aEnrollCourse)
{//StudentId,CourseId,EnrollDate,EnrollmentStatus,CourseEnroll]
Query = "INSERT INTO CourseEnroll Values(@StudentId, @CourseId, @EnrollDate, @EnrollmentStatus)";
Command = new SqlCommand(Query, Connection);
Command.Parameters.Clear();
Command.Parameters.Add("StudentId", SqlDbType.Int);
Command.Parameters["StudentId"].Value = aEnrollCourse.StudentId;
Command.Parameters.Add("CourseId", SqlDbType.Int);
Command.Parameters["CourseId"].Value = aEnrollCourse.CourseId;
Command.Parameters.Add("EnrollDate", SqlDbType.Date);
Command.Parameters["EnrollDate"].Value = aEnrollCourse.Date;
Command.Parameters.Add("EnrollmentStatus", SqlDbType.VarChar);
Command.Parameters["EnrollmentStatus"].Value = "Enrolled";
Connection.Open();
int rowAffected = Command.ExecuteNonQuery();
Connection.Close();
return(rowAffected);
}
public string SaveEnroll(CourseEnroll enrollCourse)
{
int sId = aStudentGateway.GetIdForStudent(enrollCourse);
enrollCourse.StudentId = sId;
bool EnrollExist = aCourseEnrollGateway.DoesEnrollExist(enrollCourse);
if (EnrollExist)
{
return("This student has been already Enrolled in this course");
}
else
{
int rowAffected = aCourseEnrollGateway.EnrollSave(enrollCourse);
if (rowAffected > 0)
{
return("Enrollment Successful");
}
return("Enrollment Failed");
}
}
public CourseEnroll GetStudentInfoByRegNo(string regNo)
{// [Id,Name,Email,ContactNo,Date,Address,DepartmentID,DepartmentCode,Roll,RegNo,Student]
Query = "SELECT s.Id, s.Name,Email,d.Name deptName FROM Student s join Department d on S.DepartmentID=D.Id " +
"WHERE RegNo='" + regNo + "'";
Command = new SqlCommand(Query, Connection);
Connection.Open();
Reader = Command.ExecuteReader();
CourseEnroll aStudentDetails = new CourseEnroll();
if (Reader.Read())
{
aStudentDetails.StudentId = (int)Reader["Id"];
aStudentDetails.StudentName = Reader["Name"].ToString();
aStudentDetails.Email = Reader["Email"].ToString();
aStudentDetails.DepartmentName = Reader["deptName"].ToString();
}
Reader.Close();
Connection.Close();
return(aStudentDetails);
}
