protected void SimulateBtn_Click(object sender, EventArgs e)
{
CourseHandler ch = new CourseHandler();
Course course = ch.GetCourse(Convert.ToInt32(CoursesDDL.SelectedValue));
if (Convert.ToInt32(CompletionDDL.SelectedValue) >= course.CompletionPercentage)
{
ScoreHandler sh = new ScoreHandler();
int score = sh.AddScore(Convert.ToInt32(CompletionDDL.SelectedValue), course.MaxScore, course.Id, Convert.ToInt32(UsersDDL.SelectedValue));
if (course.AchievementID > 0)
{
AchievementHandler ah = new AchievementHandler();
ah.GrantAchievement(Convert.ToInt32(UsersDDL.SelectedValue), course.AchievementID);
Page.ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('Du har gennemført " + course.Name + " og dermed optjent en ny achievement. Du scorede " + score + " point ud af " + course.MaxScore + ".');", true);
}
else
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('Du har gennemført " + course.Name + ". Du scorede " + score + " point ud af " + course.MaxScore + ".');", true);
}
}
else
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('Du opfylder ikke kravene til at kunne gennemføre dette kursus.');", true);
}
}
protected void btnLogin_Click(object sender, EventArgs e)
{
LoginDAL course = new LoginDAL();
course.email = txtEmail.Text;
course.password = txtPassword.Text;
CourseHandler courseHandler = new CourseHandler();
if (courseHandler.VerifyUser(course) == true)
{
Session["user"] = txtEmail.Text;
Session["pass"] = txtPassword.Text;
Response.Redirect("Home.aspx");
}
else if (courseHandler.VerifyAdmin(course) == true)
{
Session["user"] = txtEmail.Text;
string id = txtPassword.Text;
Session["pass"] = txtPassword.Text;
Response.Redirect("Home.aspx");
}
else
{
Response.Write(@"<script language='javascript'>alert('Wrong Email or Password!.')</script>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
courseHandler = new CourseHandler();
int ccid = Convert.ToInt32(Request.QueryString["id"]);
if (courseHandler.QuizStat(ccid) == true)
{
Session["setq"] = "1";
}
try{
if (!IsPostBack)
{
if (Session["user"] == null)
{
Response.Redirect("Home.aspx");
}
else
{
int NId = Convert.ToInt32(Request.QueryString["id"]);
BindData(NId);
BindData1(NId);
}
}
}
catch {
throw;
}
}
int userID;//this is proffesor id that has to come from session
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Session[sessionNames.userID_StudentOstad] != null)
{
userID = Convert.ToInt32(Session[sessionNames.userID_StudentOstad]);
CourseHandler corH = new CourseHandler();
courselist = corH.GetCourseListByUserID(userID);
if (courselist == null)
{
string scrp = "استاد محترم در ترم جاری شما کلاسی برای برگزاری ندارید";
string address = "../../CommonUI/TeacherIntro.aspx";
string resdirectFunc = "function redirectToLast(){ window.location= '" + address + "' ; }";
RadWindowManager1.RadAlert(scrp, 300, 100, "پیام سیستم", resdirectFunc);
}
else
{
BindData(userID);
}
}
else
{
Response.Redirect("../~/CommonUI/login.aspx");
}
//RadTimePicker1.Culture = new System.Globalization.CultureInfo("en-GB");
//RadTimePicker2.Culture = new System.Globalization.CultureInfo("en-GB");
}
Page.LoadComplete += new EventHandler(Page_LoadComplete);
}
protected void AddBtn_Click(object sender, EventArgs e)
{
if (ChbxListScoreSettings.SelectedItems.Count > 0 && PointBox.Value > 0)
{
CourseHandler ch = new CourseHandler();
int percentageCompletion = Convert.ToInt32(CompletionDDL.SelectedValue);
int time = 0;
int completion = 0;
foreach (ButtonListItem item in ChbxListScoreSettings.SelectedItems)
{
if (item.Value.Equals("0"))
{
time = 1;
}
if (item.Value.Equals("1"))
{
completion = 1;
}
}
ch.AddCourse(NameBox.Text, Convert.ToInt32(CustomersDDL.SelectedValue), percentageCompletion, time, completion, PointBox.Value);
CurrentCourses.DataBind();
}
else
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('Du skal udfylde alle scoreboard indstillinger, minimum 1 af parameterne skal vælges til.');", true);
}
}
// GET: Course/Edit/5
public ActionResult Edit(long id)
{
IDataAccess <Course> dataAccess = new CourseEFDataAccess();
CourseHandler handler = new CourseHandler(dataAccess);
CourseEditModel vm = handler.QueryById(id);
return(View(vm));
}
public void GetCourseById2GetsAngular5()
{
// Arrange
var courseHandler = new CourseHandler()
// Act
// Assert
}
public ActionResult Delete(long id)
{
IDataAccess <Course> dataAccess = new CourseEFDataAccess();
CourseHandler handler = new CourseHandler(dataAccess);
handler.Delete(id);
return(RedirectToAction("Index"));
}
// GET: Course
public ActionResult Index()
{
IDataAccess <Course> dataAccess = new CourseEFDataAccess();
CourseHandler handler = new CourseHandler(dataAccess);
List <CourseViewModel> models = handler.List();
return(View(models));
}
public void ShouldReturnValidWhenDeleteCommandValid()
{
var command = new DeleteCourseCommand();
command.Id = Guid.NewGuid();
var handler = new CourseHandler(new CourseRepositoryMock());
var result = handler.Handle(command);
Assert.AreEqual(true, result.Status);
}
public void ShouldReturnInvalidWhenCreateCommandNull()
{
var command = new CreateCourseCommand();
command.Description = null;
command.IdCollege = Guid.NewGuid();
var handler = new CourseHandler(new CourseRepositoryMock());
var result = handler.Handle(command);
Assert.AreEqual(false, result.Status);
}
public void ShouldReturnValidWhenCreateCommandValid()
{
var command = new CreateCourseCommand();
command.Description = "Computer Science";
command.IdCollege = Guid.NewGuid();
var handler = new CourseHandler(new CourseRepositoryMock());
var result = handler.Handle(command);
Assert.AreEqual(true, result.Status);
}
/// <summary>
/// Deletes courses
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void BtnDelete_Click(object sender, RoutedEventArgs e)
{
var dialogResult = MessageBox.Show("Do you wish to delete", "Delete?", MessageBoxButton.YesNo);
if (dialogResult == MessageBoxResult.Yes)
{
var selectedMajor = CourseHandler.GetCourseFromId(((ListBox)sender).SelectedItems[0].ToString());
CourseList.Remove(selectedMajor);
LbxCourses.Items.Remove(selectedMajor.Name);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["user"] == null || (string)Session["pass"] != "123")
{
Response.Redirect("Home.aspx");
}
courseHandler = new CourseHandler();
if (!IsPostBack)
{
int NId = Convert.ToInt32(Request.QueryString["id"]);
BindData(NId);
}
}
public void Test_List_All_Course_Use_Case()
{
IDataAccess <Course> dataAccess = new FakeCourseDataAccess(dataBase);
CourseHandler handler = new CourseHandler(dataAccess);
List <CourseViewModel> vms = handler.List();
int actual = vms.Count;
int expected = 3;
Assert.AreEqual(expected, actual);
}
private void BindData()
{
CourseHandler courseHandler = new CourseHandler();
int cid = Convert.ToInt32(Request.QueryString["cid"]);
int sid = Convert.ToInt32(Request.QueryString["sid"]);
int id = 1;
id = id + 1;
GridView1.DataSource = courseHandler.GetQuestionListscript(cid, sid);
GridView1.DataBind();
}
public void Test_Query_Course_Use_Case_By_Given_Id_2()
{
IDataAccess <Course> dataAccess = new FakeCourseDataAccess(dataBase);
CourseHandler handler = new CourseHandler(dataAccess);
CourseEditModel vm = handler.QueryById(2);
string actual = vm.Name;
string expected = "Test2";
Assert.AreEqual(expected, actual);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["user"] == null)
{
Response.Redirect("Home.aspx");
}
CourseHandler courseHandler = new CourseHandler();
if (IsPostBack == false)
{
BindData();
}
}
public ActionResult Edit(CourseEditModel vm)
{
try
{
IDataAccess <Course> dataAccess = new CourseEFDataAccess();
CourseHandler handler = new CourseHandler(dataAccess);
handler.Update(vm);
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public TransactionDetailModel(Transaction transaction)
{
Textbook textbook = TextbookHandler.getTextbook(transaction.TextbookId);
SellerPost = PostHandler.getPost(transaction.SellerPostId);
BuyerPost = PostHandler.getPost(transaction.BuyerPostId);
this.BookTitle = textbook.BookTitle;
this.ISBN = textbook.ISBN;
this.Price = SellerPost.Price;
this.FinalPrice = transaction.FinalPrice;
this.Condition = SellerPost.BookCondition;
this.CourseName = CourseHandler.getCourseName(textbook.CourseId);
this.StorePrice = textbook.StorePrice;
this.transaction = transaction;
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["user"] == null || (string)Session["pass"] != "123")
{
Response.Redirect("Home.aspx");
}
CourseHandler courseHandler = new CourseHandler();
int cid = Convert.ToInt32(Request.QueryString["id"]);
courseHandler.EndQuizz(cid);
Session["setq"] = null;
Response.Redirect("DetailCourse.aspx?id=" + cid);
}
protected void Page_Load(object sender, EventArgs e)
{
courseHandler = new CourseHandler();
try{
if (!IsPostBack)
{
Session["id"] = Session["user"];
BindData();
}
}
catch {
throw;
}
}
private void NextPage_OnClick(object sender, RoutedEventArgs e)
{
var output = new List <Course>();
foreach (var year in semestersLabels)
{
foreach (var semester in year)
{
foreach (var course in semester)
{
output.Add(CourseHandler.GetCourseFromId(course.Content.ToString()));
}
}
}
PrintControl.Save(output.ToArray());
}
//gets courses from database
private void GetCourses()
{
using (var con = new SqlConnection(Properties.Settings.Default.AvocadaConnectionString))
{
con.Open();
const string sqlQuery = "select * from Courses";
var cmd = new SqlCommand(sqlQuery, con);
var adp = new SqlDataAdapter(cmd);
var dt = new DataTable();
adp.Fill(dt);
if (dt.Rows.Count <= 0)
{
return;
}
for (var i = 0; i < dt.Rows.Count; i++)
{
var required = dt.Rows[i]["Prereq"].ToString().Split(',');
if (!int.TryParse(dt.Rows[i]["Year"].ToString(), out var year) ||
!bool.TryParse(dt.Rows[i]["Compulsory"].ToString(), out var compulsory))
{
continue;
}
var newCourse = new Course(
dt.Rows[i]["Id"].ToString(),
dt.Rows[i]["Name"].ToString(),
dt.Rows[i]["Description"].ToString(),
year,
dt.Rows[i]["Semester"].ToString(),
required,
compulsory
);
CourseHandler.Add(newCourse);
}
}
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
if (Session["setq"] != null)
{
Label lblID = GridView1.Rows[e.RowIndex].FindControl("lblID") as Label;
TextBox txtLastName = GridView1.Rows[e.RowIndex].FindControl("txtLastName") as TextBox;
Label lblI1 = GridView1.Rows[e.RowIndex].FindControl("lblI1") as Label;
Label lblI2 = GridView1.Rows[e.RowIndex].FindControl("lblI2") as Label;
Label lblI3 = GridView1.Rows[e.RowIndex].FindControl("lblI3") as Label;
CourseHandler courseHandler = new CourseHandler();
Student user = new Student();
user.studentName = "";
user.idNumber = "";
user.email = (string)Session["user"];
user.password = (string)Session["pass"];
CourseDBAccess courseDB = new CourseDBAccess();
courseDB.GetStudentDetails(user);
QuizAns quiz = new QuizAns();
quiz.courseID = Convert.ToInt32(Request.QueryString["id"]);
quiz.studentID = user.studentID;
quiz.questionID = Convert.ToInt32(lblID.Text.Trim());
quiz.Ans = txtLastName.Text;
//Let us now update the database
courseHandler.UpdateQuizAns(quiz);
//end the editing and bind with updated records.
GridView1.EditIndex = -1;
BindData();
}
else
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('Login First');", true);
}
}
protected void btnPost_Click(object sender, EventArgs e)
{
Discussion course = new Discussion();
Student user = new Student();
Teacher user1 = new Teacher();
user.studentName = "";
user.idNumber = "";
user.email = (string)Session["user"];
user.password = (string)Session["pass"];
user1.email = (string)Session["user"];
user1.password = (string)Session["pass"];
CourseHandler courseHandler = new CourseHandler();
CourseDBAccess courseDB = new CourseDBAccess();
courseDB.GetStudentDetails(user);
courseDB.GetTeacherDetails(user1);
if (user.studentName != "")
{
course.post = txtPost.Text;
course.name = user.studentName;
course.email = user.email;
course.courseID = Convert.ToInt32(Request.QueryString["id"]);
}
else
{
course.post = txtPost.Text;
course.name = user1.teacherName;
course.email = user1.email;
course.courseID = Convert.ToInt32(Request.QueryString["id"]);
}
if (courseHandler.AddNewDiscussion(course) == true)
{
int idd = Convert.ToInt32(Request.QueryString["id"]);
Response.Redirect("DetailCourse.aspx?id=" + idd);
}
}
protected void btnSubmit1_Click(object sender, EventArgs e)
{
Student course = new Student();
course.studentName = txtName.Text;
course.idNumber = txtId.Text;
course.email = txtEmail.Text;
course.password = txtPassword.Text;
CourseHandler courseHandler = new CourseHandler();
if (courseHandler.AddNewStudent(course) == true)
{
Response.Redirect("Login.aspx");
}
}
protected void btnSubmit1_Click(object sender, EventArgs e)
{
Student course = new Student();
course.studentName = txtName.Text;
course.idNumber = txtId.Text;
course.email = txtEmail.Text;
course.password = txtPassword.Text;
course.studentID = Convert.ToInt32(txtStudentID.Text);
CourseHandler courseHandler = new CourseHandler();
if (courseHandler.UpdateStudentInfo(course) == true)
{
Response.Redirect("Logout.aspx");
}
}
public Majors()
{
InitializeComponent();
if (Instance == null)
{
Instance = this;
}
Year1Controls = new List <CourseControl>();
Year2Controls = new List <CourseControl>();
Year3Controls = new List <CourseControl>();
GetCourses();
GetMajors();
SetCourses();
RedrawCourses();
CourseHandler.SetPrereq();
}
/// <summary>
/// Edits the currently selected course
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void BtnEditSelected_Click(object sender, RoutedEventArgs e)
{
var selectedCourse = CourseHandler.GetCourseFromId(((ListBox)sender).SelectedItem.ToString());
TbxId.Text = selectedCourse.Id;
TbxId.IsEnabled = false;
TbxName.Text = selectedCourse.Name;
TbxDescription.Text = selectedCourse.Description;
ChbxCompulsory.IsChecked = selectedCourse.Compulsory;
CbxSemester.SelectedItem = selectedCourse.Semester[0];
CbxYear.SelectedItem = selectedCourse.Year;
foreach (var prereq in selectedCourse.Prerequisite)
{
LbxPrereq.Items.Add(prereq);
}
_updateCheck = true;
}
// Use this for initialization
void Start()
{
ch = this.GetComponentInChildren<CourseHandler>();
}
