public EnrollCourseModel GateRegisterNumberByStudentId(int StudentId)
{
SqlConnection con = new SqlConnection(connectingString);
string query = "select * from EnrollByDepartment where StudentId = '" + StudentId + "'";
SqlCommand cmd = new SqlCommand(query, con);
con.Open();
SqlDataReader dataReader = cmd.ExecuteReader();
EnrollCourseModel enrollCourseModel = new EnrollCourseModel();
if (dataReader.HasRows)
{
while (dataReader.Read())
{
enrollCourseModel.DepartmentId = Convert.ToInt32(dataReader["DepartmentID"]);
enrollCourseModel.RegistationNumber = dataReader["RegistationNumber"].ToString();
enrollCourseModel.StudentName = dataReader["StudentName"].ToString();
enrollCourseModel.StudentEmail = dataReader["StudentEmail"].ToString();
enrollCourseModel.DepartmentName = dataReader["DepartName"].ToString();
}
dataReader.Close();
}
con.Close();
return(enrollCourseModel);
}
public IActionResult Put(string userId, [FromBody] EnrollCourseModel model)
{
if (!Guid.TryParse(userId, out var parsedUserId))
{
return(BadRequest());
}
var user = _userService.GetUser(parsedUserId);
if (user == null)
{
return(NotFound($"User {userId} was not found"));
}
var status = _courseService.AddCourseForUser(user.Id, model.CourseId);
if (status == ActionStatus.CourseNotFound)
{
return(NotFound($"Course {model.CourseId} was not found"));
}
var courses = _courseService.GetCoursesForUser(user.Id);
return(Ok(_mapper.Map <IEnumerable <CourseModel> >(courses)));
}
public int GateAllEnrollCourseGateway(EnrollCourseModel enrollCourseModel)
{
SqlConnection con = new SqlConnection(connectingString);
string query = "insert into EnrollCourse values('" + enrollCourseModel.StudentId + "','" + enrollCourseModel.CourseId + "','" + enrollCourseModel.Date + "')";
SqlCommand cmd = new SqlCommand(query, con);
con.Open();
int rowAffect = cmd.ExecuteNonQuery();
con.Close();
return(rowAffect);
}
//-----------------------------------------------------------
public string Enroll(EnrollCourseModel student)
{
int rowEffect = enrollCourseGateway.Enroll(student);
if (rowEffect > 0)
{
return("Save Success");
}
else
{
return("Save Faild");
}
}
public ActionResult Enroll(EnrollCourseModel enrollcourse)
{
ViewBag.Title = "Enroll Courses";
ViewBag.studentRegNos = enrollCoursesManager.RegNoDropdown();
if (enrollCoursesManager.IsCourseAvailable(enrollcourse.StudentId, enrollcourse.CourseId) == false)
{
ViewBag.message = enrollCoursesManager.Enroll(enrollcourse);
}
else
{
ViewBag.message = "Already Enrolled This course";
}
return(View());
}
//-------------------------------------------------------------------------
public int Enroll(EnrollCourseModel student)
{
query = "INSERT INTO EnrollCourseTable VALUES(@studentId,@courseId,@date,1)";
Command = new SqlCommand(query, Connection);
Command.Parameters.AddWithValue("@studentId", student.StudentId);
Command.Parameters.AddWithValue("@courseId", student.CourseId);
Command.Parameters.AddWithValue("@date", student.Date);
Connection.Open();
int rowEffect = Command.ExecuteNonQuery();
Connection.Close();
return(rowEffect);
}
public string GateAllEnrollCourseManager(EnrollCourseModel enrollCourseModel)
{
if (enrollCourseGateway.IsExist(enrollCourseModel) == null)
{
if (enrollCourseGateway.GateAllEnrollCourseGateway(enrollCourseModel) > 0)
{
return("Save Successfull");
}
else
{
return("Save Fail");
}
}
else
{
return(enrollCourseGateway.IsExist(enrollCourseModel));
}
}
public string IsExist(EnrollCourseModel enrollCourseModel)
{
string message = null;
SqlConnection con = new SqlConnection(connectingString);
string query = "select * from EnrollCourse Where StudentId='" + enrollCourseModel.StudentId +
"' AND CourseId='" + enrollCourseModel.CourseId + "' ";
SqlCommand cmd = new SqlCommand(query, con);
con.Open();
SqlDataReader dataReader = cmd.ExecuteReader();
if (dataReader.HasRows)
{
message = "Sorry, Already Enrolled";
}
con.Close();
return(message);
}
//-----------------------------------------------------------
public List <EnrollCourseModel> Courses(int studentId)
{
query = "SELECT * FROM EnrollCourseView where studentId=" + studentId;
Command = new SqlCommand(query, Connection);
List <EnrollCourseModel> CourseList = new List <EnrollCourseModel>();
Connection.Open();
Reader = Command.ExecuteReader();
while (Reader.Read())
{
EnrollCourseModel course = new EnrollCourseModel();
course.CourseId = Convert.ToInt32(Reader["Id"]);
course.CoursesName = Reader["Name"].ToString();
CourseList.Add(course);
}
Connection.Close();
return(CourseList);
}
public JsonResult GateRegisterNumberByStudentId(int StudentId)
{
EnrollCourseModel register = enrollCourseManager.GateRegisterNumberByStudentId(StudentId);
return(Json(register, JsonRequestBehavior.AllowGet));
}
public IActionResult Enroll([FromBody] EnrollCourseModel model)
{
_courseService.EnrollCourse(model.StudentId, model.CourseId);
return(Ok());
}
public ActionResult EnrollCourseSave(EnrollCourseModel enrollCourseModel)
{
ViewBag.message = enrollCourseManager.GateAllEnrollCourseManager(enrollCourseModel);
TempData["Msg"] = ViewBag.message;
return(RedirectToAction("EnrollCourseSave"));
}
