protected void btnInsert_Click(object sender, EventArgs e) { try { usersLogin = new UsersLogin(); teachers = new Teacher(); scDao = new SchoolDao(); string strTeacherLastName = txtLastName.Text; string strTeacherFirstName = txtFirstName.Text; string strTeacherDepartment = txtDepartament.Text; string strUserEmail = inputEmail.Text; string strPassword = inputPassword.Text; teachers.TeacherLastName = strTeacherLastName; teachers.TeacherFirstName = strTeacherFirstName; teachers.TeacherDepartment = strTeacherDepartment; usersLogin.UserEmail = strUserEmail; usersLogin.UserPassword = scDao.CreatePasswordHash(strPassword); scDao.InsetTeachers(teachers, usersLogin); lblMsg.Text = "Teacher Inserted!"; btnInsert.Enabled = false; } catch (Exception ex) { lblMsg.Text = ex.Message.ToString(); } }
protected void btnLogin_Click(object sender, EventArgs e) { bool passwordVerified = false; try { scDao = new SchoolDao(); passwordVerified = scDao.VerifyPassword(inputEmail.Text, inputPassword.Text); } catch (Exception ex) { lblMsg.Text = ex.Message.ToString(); return; } if (passwordVerified) { FormsAuthentication.RedirectFromLoginPage(inputEmail.Text, true); } else { lblMsg.Text = "Invalid email or password"; scDao.GravaLog("Invalid email or password"); } }
protected void gvTeachers_RowDeleting(object sender, GridViewDeleteEventArgs e) { teachers = new Teacher(); scDao = new SchoolDao(); int intID = Convert.ToInt32(gvTeachers.DataKeys[e.RowIndex].Value.ToString()); teachers.TeacherID = intID; scDao.DeleteTeachers(teachers); FillGrid(); }
public void TestGet() { ISchoolDao dao = new SchoolDao(); IList <School> list = dao.Get(""); foreach (School item in list) { Console.WriteLine(item.Name); } }
public void TestAdd() { ISchoolDao dao = new SchoolDao(); School s = new School() { ShortName = "st", Name = "s", AreaId = 123 }; dao.Add(s); }
public void FillGrid() { try { scDao = new SchoolDao(); DataTableReader reader = scDao.ListTeachers().CreateDataReader(); DataTable dtTeachers = new DataTable(); dtTeachers.Load(reader); DataView dvTeachers = dtTeachers.DefaultView; dvTeachers.Sort = ViewState["SortExpr"].ToString(); //if (ViewState["FilterLastName"] !=null) //{ // dvTeachers.RowFilter = "TeacherLastName LIKE '*" + ViewState["FilterLastName"] + "*'"; //} if (ViewState["FilterLastName"] != null || ViewState["FilterDepartment"] != null) { string strFilter = ""; if (ViewState["FilterLastName"] != null) { strFilter = "TeacherLastName LIKE '*" + ViewState["FilterLastName"] + "*'"; if (ViewState["FilterDepartment"] != null) { strFilter = strFilter + " AND TeacherDepartment LIKE '*" + ViewState["FilterDepartment"].ToString() + "*'"; } } else if (ViewState["FilterDepartment"] != null) { strFilter = strFilter + "TeacherDepartment LIKE '*" + ViewState["FilterDepartment"].ToString() + "*'"; } dvTeachers.RowFilter = strFilter; } gvTeachers.DataSource = dvTeachers; gvTeachers.DataBind(); } catch (Exception ex) { throw ex; } }
protected void gvTeachers_RowUpdating(object sender, GridViewUpdateEventArgs e) { teachers = new Teacher(); scDao = new SchoolDao(); int intID = Convert.ToInt32(gvTeachers.DataKeys[e.RowIndex].Value.ToString()); string strLastName = ((TextBox)gvTeachers.Rows[e.RowIndex].FindControl("txtLastName")).Text; string strFirstName = ((TextBox)gvTeachers.Rows[e.RowIndex].FindControl("txtFirstName")).Text; string strDateJoin = ((TextBox)gvTeachers.Rows[e.RowIndex].FindControl("txtDateJoin")).Text; string strDepartment = ((TextBox)gvTeachers.Rows[e.RowIndex].FindControl("txtDepartment")).Text; teachers.TeacherID = intID; teachers.TeacherLastName = strLastName; teachers.TeacherFirstName = strFirstName; teachers.TeacherDateJoin = Convert.ToDateTime(strDateJoin); teachers.TeacherDepartment = strDepartment; scDao.AlterTeachers(teachers); gvTeachers.EditIndex = -1; FillGrid(); }
public SchoolService() { _SchoolDao = new SchoolDao(); BaseCrudDao = _SchoolDao; }
public void TestGetById() { School s = new SchoolDao().Get(2); Console.WriteLine(s.AreaName); }