public ActionResult Create(AddCourseViewModels course)
{
try
{
SqlConnection con = new SqlConnection(connection);
con.Open();
string filename = Path.GetFileNameWithoutExtension(course.ImageFile.FileName);
string extension = Path.GetExtension(course.ImageFile.FileName);
filename = filename + DateTime.Now.ToString("yymmssfff") + extension;
course.CourseImage = "~/images/" + filename;
filename = Path.Combine(Server.MapPath("~/images/"), filename);
course.ImageFile.SaveAs(filename);
string query = "INSERT INTO Course(Title,Credits,Fee,DepartmentId,CourseImage)VALUES ('" + course.Title + "','" + course.Credits + "','" + course.Fee + "','" + DeptId + "','" + course.CourseImage + "')";
SqlCommand cmd = new SqlCommand(query, con);
cmd.ExecuteNonQuery();
// ViewBag.Message("Successfull");
return(RedirectToAction("Index", new { id = DeptId }));
}
catch (Exception ex)
{
return(View(ex));
}
}
// GET: AddCourse
public ActionResult Index(int id)
{
SqlConnection conn = new SqlConnection(connection);
string query;
SqlCommand SqlCommand;
List <AddCourseViewModels> lists = new List <AddCourseViewModels>();
//Open the connection to db
conn.Open();
//Generating the query to fetch the contact details
query = " SELECT * FROM Course where DepartmentId= ' " + id + "' ";
SqlCommand = new SqlCommand(query, conn);
SqlDataReader rdr = SqlCommand.ExecuteReader();
while (rdr.Read())
{
var dpt = new AddCourseViewModels();
dpt.Id = Convert.ToInt32(rdr[0]);
dpt.Title = rdr[1].ToString();
dpt.Credits = rdr[2].ToString();
dpt.Fee = Convert.ToInt32(rdr[3]);
dpt.DepartmentId = Convert.ToInt32(rdr[4]);
dpt.CourseImage = rdr[5].ToString();
lists.Add(dpt);
}
return(View(lists));
}
public ActionResult AllCourses(int id)
{
SqlConnection conn = new SqlConnection(connection);
string query;
SqlCommand SqlCommand;
instructorId = id;
List <AddCourseViewModels> lists = new List <AddCourseViewModels>();
SqlDataAdapter adapter = new SqlDataAdapter();
//Open the connection to db
conn.Open();
//Generating the query to fetch the contact details
query = " select * from Course where not exists (select * from AssignInstructor where Course.Id=AssignInstructor.CourseId) ";
SqlCommand = new SqlCommand(query, conn);
SqlDataReader rdr = SqlCommand.ExecuteReader();
while (rdr.Read())
{
var dpt = new AddCourseViewModels();
dpt.Id = Convert.ToInt32(rdr[0]);
dpt.Title = rdr[1].ToString();
dpt.Credits = rdr[2].ToString();
dpt.Fee = Convert.ToInt32(rdr[3]);
dpt.DepartmentId = Convert.ToInt32(rdr[4]);
dpt.CourseImage = rdr[5].ToString();
lists.Add(dpt);
}
return(View(lists));
}
public ActionResult DetailsForStudents(int CID)
{
SqlConnection con = new SqlConnection(connection);
con.Open();
List <AddCourseViewModels> lists = new List <AddCourseViewModels>();
string query = "SELECT * from Course where Id='" + CID + "'";
SqlCommand cmd = new SqlCommand(query, con);
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
var course = new AddCourseViewModels();
course.Id = Convert.ToInt32(rdr[0]);
course.Title = rdr[1].ToString();
course.Credits = rdr[2].ToString();
course.Fee = Convert.ToInt32(rdr[3]);
course.DepartmentId = Convert.ToInt32(rdr[4]);
course.CourseImage = rdr[5].ToString();
lists.Add(course);
}
rdr.Close();
return(View(lists));
}
public ActionResult RegisteredCourses()
{
SqlConnection conn = new SqlConnection(connection);
string query;
SqlCommand SqlCommand;
List <AddCourseViewModels> lists = new List <AddCourseViewModels>();
//Open the connection to db
conn.Open();
//Generating the query to fetch the contact details
query = " select Course.Id,StudentRegisterCourse.DepartmentId,Course.Title,Course.Fee,Course.Credits,Course.CourseImage from Course inner join StudentRegisterCourse on Course.Id=StudentRegisterCourse.CourseId and StudentRegisterCourse.StudentId='" + loginId + "'";
SqlCommand = new SqlCommand(query, conn);
SqlDataReader rdr = SqlCommand.ExecuteReader();
while (rdr.Read())
{
var course = new AddCourseViewModels();
course.Id = Convert.ToInt32(rdr[0]);
course.DepartmentId = Convert.ToInt32(rdr[1]);
course.Title = rdr[2].ToString();
course.Fee = Convert.ToInt32(rdr[3]);
course.Credits = rdr[4].ToString();
course.CourseImage = rdr[5].ToString();
lists.Add(course);
}
return(View(lists));
}
public ActionResult Edit(int id, AddCourseViewModels course)
{
try
{
SqlConnection con = new SqlConnection(connection);
con.Open();
// TODO: Add update logic here
string query = "UPDATE Course SET Title='" + course.Title + "', Credits='" + course.Credits + "',Fee='" + course.Fee + "' where Id='" + id + "'";
SqlCommand cmd = new SqlCommand(query, con);
cmd.ExecuteNonQuery();
return(RedirectToAction("Details", new { CId = id }));
}
catch
{
return(View());
}
}
// GET: Course/Edit/5
public ActionResult Edit(int id)
{
SqlConnection con = new SqlConnection(connection);
con.Open();
string query = "SELECT * from Course where Id='" + id + "'";
SqlCommand cmd = new SqlCommand(query, con);
SqlDataReader rdr = cmd.ExecuteReader();
var course = new AddCourseViewModels();
while (rdr.Read())
{
course.Id = Convert.ToInt32(rdr[0]);
course.Title = rdr[1].ToString();
course.Credits = rdr[2].ToString();
course.Fee = Convert.ToInt32(rdr[3]);
course.DepartmentId = Convert.ToInt32(rdr[4]);
course.CourseImage = rdr[5].ToString();
}
rdr.Close();
return(View(course));
}
