public List <SelectListItem> GetCourseListItem()
{
CourseBL objUserBL = new CourseBL();
List <SelectListItem> lstSelectItem = new List <SelectListItem>();
try
{
CourseMaster obj = new CourseMaster();
List <CourseMaster> lstUserType = objUserBL.CRUDCourses(obj, "L");
if (lstUserType != null)
{
lstSelectItem.Add(new SelectListItem {
Text = "Select Course", Value = ""
});
foreach (var u in lstUserType)
{
lstSelectItem.Add(new SelectListItem {
Text = Convert.ToString(u.CourseName), Value = Convert.ToString(u.CourseId)
});
}
}
}
catch (Exception)
{
throw;
}
return(lstSelectItem);
}
public ActionResult AddCourse(Course c, CrsRelation cr, HttpPostedFileBase file)
{
var path = "";
string ImageName = "";
//for checking uploaded
if (Path.GetExtension(file.FileName).ToLower() == ".jpg" ||
Path.GetExtension(file.FileName).ToLower() == ".png" ||
Path.GetExtension(file.FileName).ToLower() == ".gif" ||
Path.GetExtension(file.FileName).ToLower() == ".jpeg")
{
ImageName = file.FileName;
path = Path.Combine(Server.MapPath("~/Images/"), file.FileName);
file.SaveAs(path);
ViewBag.UploadSuccess = true;
}
cr.cid = c.cid;
CourseBL.InsertToCrs(c, ImageName);
CourseBL.InsertToCrsRelation(cr);
Session["CourseID"] = c.cid;
return(RedirectToAction("AddCourse"));
}
public void PopulateDatagridview()
{
DataTable dt = new DataTable();
CourseBL aCourseBL = new CourseBL();
dt = aCourseBL.GetExistingCoursesBL();
CoursedataGridView1.DataSource = dt;
}
public ActionResult rateQuesTable(int cid = -1)
{
ViewBag.getCrs = CourseBL.DisplayAll();
ViewBag.getRateQues = submitBL.getRateQuestionVal(cid);
ViewBag.getTitlesForCourse = submitBL.getTitlesForCourse(cid);
ViewBag.getSumittionCount = submitBL.getSumittionCount(cid);
return(View());
}
public ActionResult AddCourse()
{
ViewBag.getLev = CourseBL.GetAllLevel();
ViewBag.getDoc = CourseBL.GetAllDoctors("دكتور");
ViewBag.getAssistant = CourseBL.GetAllDoctors("معيد");
ViewBag.getSem = CourseBL.GetAllSemesters();
ViewBag.getSpe = CourseBL.GetAllSpecializations();;
return(View());
}
public ActionResult EditCourse(int id)
{
ViewBag.Model = CourseBL.getCourseById(id);
ViewBag.getLev = CourseBL.GetAllLevel();
ViewBag.getDoc = CourseBL.GetAllDoctors("دكتور");
ViewBag.getAssistant = CourseBL.GetAllDoctors("معيد");
ViewBag.getSem = CourseBL.GetAllSemesters();
ViewBag.getSpe = CourseBL.GetAllSpecializations();
return(View());
}
public ActionResult courses(string search)
{
if (search != null)
{
return(View(CourseBL.GetByCode(search)));
}
else
{
return(View(CourseBL.GetAll()));
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
try
{
CourseBL course = new CourseBL();
grid.ItemsSource = course.GetCourses();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
public ActionResult Add_course(Course ob)
{
ModelState.Remove("ID");
if (ModelState.IsValid)
{
CourseBL.Add(ob);
return(RedirectToAction("Course"));
}
else
{
return(View());
}
}
public ActionResult Course(string search)
{
ModelState.Remove("ID");
if (search != null)
{
return(View(CourseBL.GetByCode(search)));
}
else
{
return(View(CourseBL.GetAll()));
}
}
private void LoadCourseComboBox()
{
try
{
CourseBL courseBL = new CourseBL();
coursecmbbox.ItemsSource = courseBL.GetCourses();
coursecmbbox.SelectedValuePath = "CourseID";
coursecmbbox.DisplayMemberPath = "Name";
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
private void Button_Click_1(object sender, RoutedEventArgs e)
{
try
{
Course course = new Course();
course.Name = txtCName.Text.ToString();
CourseBL courseBL = new CourseBL();
User user = new User();
grid.ItemsSource = courseBL.GetCourseByName(course.Name);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
public async Task <ActionResult> Delete(Cours c)
{
CourseBL courseBL = new CourseBL();
string userData = JsonConvert.SerializeObject(c.CourseID);
string result = await courseBL.DeleteC(c.CourseID);
if (result == "true")
{
string courses = await courseBL.GetCourses();
List <Cours> userList = JsonConvert.DeserializeObject <List <Cours> >(courses);
return(View("Index", userList));
}
return(View());
}
//private void backbutton1_Click(object sender, EventArgs e)
//{
// Courses CoursesUI = new Courses();
// CoursesUI.Show();
// this.Hide();
//}
private void confirmbutton1_Click(object sender, EventArgs e)
{
DAL.DAO.CourseO aCourseInfo = new DAL.DAO.CourseO();
aCourseInfo.Name = coursenametextBox.Text;
aCourseInfo.Id = courseidtextBox.Text;
aCourseInfo.Credit = 0;
double.TryParse(CredittextBox.Text, out aCourseInfo.Credit);
aCourseInfo.Semister = semistertextBox.Text;
aCourseInfo.Teacher = teachertextBox.Text;
aCourseInfo.CourseFee = coursefeetextBox.Text;
CourseBL CourseBLOBJ = new CourseBL();
bool result = CourseBLOBJ.ValidateNewCourseandSendToDA(aCourseInfo);
if (result)
{
MessageBox.Show("A NEW COURSE ADDED");
//this.populateDataGriedview();
this.PopulateDatagridview();
Updatebutton.Enabled = true;
deletcoursebutton.Enabled = true;
CANCELbutton1.Enabled = true;
confirmbutton1.Enabled = true;
coursenametextBox.Text = " ";
courseidtextBox.Text = " ";
CredittextBox.Text = " ";
semistertextBox.Text = " ";
teachertextBox.Text = " ";
coursefeetextBox.Text = " ";
}
else
{
MessageBox.Show("RESULT: " + CourseBLOBJ.Message);
}
}
public ActionResult Edit_Course(Course ob)
{
//ModelState.Remove("CourseTypeID");
//ModelState.Remove("Teaching_Hours_Lecture");
//ModelState.Remove("Teching_Hours_Tutorial");
//ModelState.Remove("TeachingHours_Practical");
//ModelState.Remove("Midterm");
//ModelState.Remove("Year_Work_Grades_O");
//ModelState.Remove("Year_Work_Grades_PE");
//ModelState.Remove("Year_Work_Grades_G");
//ModelState.Remove("CurriculumID");
if (ModelState.IsValid)
{
CourseBL.Update(ob);
return(RedirectToAction("Course"));
}
else
{
return(View());
}
}
private void deletcoursebutton_Click(object sender, EventArgs e)
{
DAL.DAO.CourseO aCourseInfo = new DAL.DAO.CourseO();
aCourseInfo.Name = coursenametextBox.Text;
aCourseInfo.Id = courseidtextBox.Text;
aCourseInfo.Credit = 0;
double.TryParse(CredittextBox.Text, out aCourseInfo.Credit);
aCourseInfo.Semister = semistertextBox.Text;
aCourseInfo.Teacher = teachertextBox.Text;
aCourseInfo.CourseFee = coursefeetextBox.Text;
CourseBL CourseBLOBJ = new CourseBL();
bool result = CourseBLOBJ.DeletACourseBL(aCourseInfo);
if (result)
{
MessageBox.Show("The Course is Delete FromDB...!!!");
this.PopulateDatagridview();
Updatebutton.Enabled = true;
deletcoursebutton.Enabled = true;
CANCELbutton1.Enabled = true;
confirmbutton1.Enabled = true;
coursenametextBox.Text = " ";
courseidtextBox.Text = " ";
CredittextBox.Text = " ";
semistertextBox.Text = " ";
teachertextBox.Text = " ";
coursefeetextBox.Text = " ";
}
else
{
MessageBox.Show("RESULT: " + CourseBLOBJ.Message);
}
}
public ActionResult user(int id = -1)
{
if (Session["UserId"] == null)
{
return(RedirectToAction("LogIn"));
}
else
{
ViewBag.getCrs = CourseBL.DisplayAll();
ViewBag.Model = CourseBL.getCourseById(id);
ViewBag.Doc = CourseBL.getInsByCid(id, "دكتور");
ViewBag.Assistant = CourseBL.getInsByCid(id, "معيد");
ViewBag.getSpe = CourseBL.GetSpecializationsByCid(id);
ViewBag.getSec = SectionBL.DisplayAllSections();
ViewBag.getQues = SectionBL.DisplayAllQuestions();
ViewBag.SelectedItemDDL = id;
// UserInfo u = new UserInfo();
//Session["UserId"] = u.userId;
ViewBag.UserId = Session["userId"];
return(View());
}
}
private void Button_Click_1(object sender, RoutedEventArgs e)
{
try
{
Course course = new Course();
course.Name = CName.Text.ToString();
course.StartDate = StartDate.SelectedDate.GetValueOrDefault();
course.EndDate = EndDate.SelectedDate.GetValueOrDefault();
CourseBL courseBL = new CourseBL();
bool courseAdd = courseBL.AddNewCourse(course);
if (courseAdd == true)
{
MessageBox.Show("Course Added Successfully...");
}
else
{
MessageBox.Show("Course not Added", "Error", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
public ActionResult EditCourse(Course c, CrsRelation cr, HttpPostedFileBase file)
{
var path = "";
string ImageName = "";
//for checking uploaded
if (file != null && (Path.GetExtension(file.FileName).ToLower() == ".jpg" ||
Path.GetExtension(file.FileName).ToLower() == ".png" ||
Path.GetExtension(file.FileName).ToLower() == ".gif" ||
Path.GetExtension(file.FileName).ToLower() == ".jpeg"))
{
ImageName = file.FileName;
path = Path.Combine(Server.MapPath("~/Images/"), file.FileName);
file.SaveAs(path);
c.img = file.FileName;
ViewBag.UploadSuccess = true;
}
CourseBL.UpdateCourse(c);
CourseBL.UpdateCrsRelation(cr);
return(RedirectToAction("EditCourse"));
}
public List <CourseDTO> GetAllCourse(int teacherid)
{
return(CourseBL.GetAllCourse(teacherid));
}
public bool createCourse(CourseDTO course)
{
return(CourseBL.createCourse(course));
}
public ActionResult EditActivation_Cr_general(int id, int StatusID)
{
CourseBL.EditActive(id, StatusID);
return(RedirectToAction("Cr_general"));
}
public ActionResult EditActivation_ALLCourses(int id, int StatusID)
{
CourseBL.EditActive(id, StatusID);
return(RedirectToAction("Course"));
}
public ActionResult Cr_IS()
{
return(View(CourseBL.GetAll_IS()));
}
// filtered Courses
public ActionResult Cr_general()
{
return(View(CourseBL.GetAll_General()));
}
public ViewResult Edit_Course(int id)
{
var ob = CourseBL.GetByID(id);
return(View(ob));
}
public ActionResult CourseManagement()
{
return(View(CourseBL.DisplayAll()));
}
public ActionResult DeactiveCourse(int cid, int active)
{
CourseBL.DeactiveCourse(cid, active);
return(RedirectToAction("CourseManagement"));
}
