//When user clicks search, pull selected dates, project, and employee //from SQL and pass data to the graph via json object protected void btSubmit_Click(object sender, EventArgs e) { try { DataAccessLayer DAL = new DataAccessLayer(); List<string> Employees = new List<string>(); List<string> Projects = new List<string>(); String startDate = tbStartDate.Text; String enddate = tbEndDate.Text; foreach (ListItem item in lbEmployee.Items) { if (item.Selected) { Employees.Add(item.Value.ToString()); } } foreach (ListItem item in lbProjects.Items) { if (item.Selected) { Projects.Add(item.Value.ToString()); } } DataTable dt = DAL.GetReportData(startDate, enddate, Projects, Employees); string json = JsonConvert.SerializeObject(dt, Formatting.Indented); hdnData.Value = json; } catch { throw; } }
/// <summary> /// calls add new user in data access layer /// </summary> protected void btSignUp_Click(object sender, EventArgs e) { try { String empId = tbEmployeeId.Text.Trim(); String firstName = tbFirstName.Text.Trim(); String lastName = tbLastName.Text.Trim(); String emailId = tbEmailId.Text.Trim(); String password = tbPassword.Text; DataAccessLayer dal = new DataAccessLayer(); int? ret = dal.AddNewUser(empId, firstName, lastName, emailId, password); switch (ret) { case -1: { loginbox.Style.Add("display", "none"); signupbox.Style.Add("display", "inline"); signupalert.Style.Add("display", "inline"); signupalert.Attributes.Add("class", "alert-danger"); signupalert.InnerText = "Account with this Employee ID already exists."; break; } case 0: { loginbox.Style.Add("display", "none"); signupbox.Style.Add("display", "inline"); signupalert.Style.Add("display", "inline"); signupalert.Attributes.Add("class", "alert-danger"); signupalert.InnerText = "Some Error Occured. Try Again Later."; break; } case 1: { signupbox.Style.Add("display", "none"); loginbox.Style.Add("display", "inline"); loginAlert.Style.Add("display", "inline"); loginAlert.Attributes.Add("class", "alert-success"); loginAlert.InnerText = "Account Created. Please Sign In to Continue."; break; } } } catch { throw; } }
protected void btAddNewEntry_Click(object sender, EventArgs e) { messageDiv.CssClass = "alert alert-dismissible alert-danger"; DataAccessLayer dal = new DataAccessLayer(); int? ret = dal.addTimeSheet(Session["EmployeeId"].ToString(),Convert.ToInt32(ddlProject.SelectedItem.Value), ddlProject.SelectedItem.Text, ddlTask.SelectedItem.Value,calMonthView.SelectedDate.ToString("MM/dd/yyyy"),float.Parse(tbHours.Text), tbComments.Text); switch (ret) { case -2: { messageDiv.CssClass = "alert alert-dismissible alert-danger"; messageDiv.Visible = true; lbMessage.Text = "Already submitted 24 hours for this date"; lbMessage.Visible = true; break; } case -1: { messageDiv.CssClass = "alert alert-dismissible alert-danger"; lbMessage.Text = "Cannot submit "+tbHours.Text +". Total hours getting > 24"; messageDiv.Visible = true; lbMessage.Visible = true; break; } case 0: { messageDiv.CssClass = "alert alert-dismissible alert-danger"; lbMessage.Text = "Some Error Occured. Could not save data in database"; messageDiv.Visible = true; lbMessage.Visible = true; break; } case 1: { messageDiv.CssClass = "alert alert-dismissible alert-success"; lbMessage.Text = "Timesheet Entry submitted successfully"; grvTimeEntriesForDay.DataBind(); messageDiv.Visible = true; lbMessage.Visible = true; break; } } }
protected void btUpdateUserType_Click(object sender, EventArgs e) { string employeeIdUser = hdEmpUSerId.Value; string adminId = Session["EmployeeId"].ToString(); bool isAdmin = bool.Parse(ddlUserType.SelectedItem.Value); string adminPass = tbAdminPassUsserType.Text; string adminGUID = Session["USER_GUID"].ToString(); DataAccessLayer dal = new DataAccessLayer(); int? ret = dal.UpdateUserTypeByAdmin(employeeIdUser, isAdmin, adminId, adminPass, adminGUID); switch (ret) { case 1: { //show success message adminEditUserAlert.Style.Add("display", "inline"); adminEditUserAlert.Attributes.Add("class", "alert-success"); adminEditUserAlert.InnerText = "User Type updated for " + employeeIdUser; grvUsers.DataBind(); } break; case -1: { //invalid password adminEditUserAlert.Style.Add("display", "inline"); adminEditUserAlert.Attributes.Add("class", "alert-danger"); adminEditUserAlert.InnerText = "Incorrect Admin Password"; } break; case 0: { //invalid password adminEditUserAlert.Style.Add("display", "inline"); adminEditUserAlert.Attributes.Add("class", "alert-danger"); adminEditUserAlert.InnerText = "Database Error Occured. Information could not be saved."; } break; } }
protected void btChPassSave_Click(object sender, EventArgs e) { hfTab.Value = "profile"; string oldPass = tbChPassCurr.Text; string newPass = tbChPassNew.Text; string empId = Session["EmployeeId"].ToString(); string oldHashedPassword = AppSecurity.HashSHA1(oldPass + Session["USER_GUID"].ToString()); string newHashedPassword = AppSecurity.HashSHA1(newPass + Session["USER_GUID"].ToString()); DataAccessLayer dal = new DataAccessLayer(); int? ret = dal.UpdatePasswordUser(empId, oldHashedPassword, newHashedPassword); switch (ret) { case 1: { //show success message editAlert.Style.Add("display", "inline"); editAlert.Attributes.Add("class", "alert-success"); editAlert.InnerText = "Password Reset Successfully"; } break; case -1: { //invalid password editAlert.Style.Add("display", "inline"); editAlert.Attributes.Add("class", "alert-danger"); editAlert.InnerText = "Incorrect Old Password"; } break; case 0: { //invalid password editAlert.Style.Add("display", "inline"); editAlert.Attributes.Add("class", "alert-danger"); editAlert.InnerText = "Database Error Occured. Information could not be saved."; } break; } }
protected void btLogin_Click(object sender, EventArgs e) { try { String empId = tbLoginUserName.Text.Trim(); String password = tbLoginPassword.Text.Trim(); DataAccessLayer dal = new DataAccessLayer(); Employee emp = null; int ret = dal.ValidateUserLogin(empId, password, ref emp); if (ret == 1) { loginAlert.Style.Add("display", "none"); if (chbRememberMe.Checked) { // Encode cookie for username HttpCookie cookieUserName = new HttpCookie("UserName"); cookieUserName.Value = AppSecurity.Base64Encode(empId); cookieUserName.Expires = DateTime.Now.AddDays(7); //Encode cookie for password HttpCookie cookiePassword = new HttpCookie("Password"); cookiePassword.Value = AppSecurity.Base64Encode(password); cookiePassword.Expires = DateTime.Now.AddDays(7); //Add cookies to response Response.Cookies.Add(cookieUserName); Response.Cookies.Add(cookiePassword); } else { Response.Cookies["UserName"].Expires = DateTime.Now.AddDays(-1); Response.Cookies["Password"].Expires = DateTime.Now.AddDays(-1); } if (emp != null) { Session["EmployeeId"] = empId; Session["FirstName"] = emp.FirstName; Session["LastName"] = emp.LastName; Session["EMAIL"] = emp.Email; Session["USER_GUID"] = emp.GUID; if (emp.IsAdmin) { Session["isAdmin"] = true; Response.Redirect("AdminHomePage.aspx"); } else { Session["isAdmin"] = false; Response.Redirect("UserHomePage.aspx"); } } } else if (ret == -1) { signupbox.Style.Add("display", "none"); loginbox.Style.Add("display", "inline"); loginAlert.Style.Add("display", "inline"); loginAlert.Attributes.Add("class", "alert-danger"); loginAlert.InnerText = "Incorrect Login Credentials"; } } catch { throw; } }
protected void btResetPass_Click(object sender, EventArgs e) { string employeeIdUser = hdEmpUSerId.Value; string adminId = Session["EmployeeId"].ToString(); string newUserPass = tbResetPassNew.Text; string adminPass = tbAdminPassReset.Text; string adminGUID = Session["USER_GUID"].ToString(); DataAccessLayer dal = new DataAccessLayer(); int? ret = dal.ResetUserPasswordByAdmin(employeeIdUser, newUserPass, adminId, adminPass, adminGUID); switch (ret) { case 1: { //show success message adminEditUserAlert.Style.Add("display", "inline"); adminEditUserAlert.Attributes.Add("class", "alert-success"); adminEditUserAlert.InnerText = "Password Reset Successfully For "+employeeIdUser; } break; case -1: { //invalid password adminEditUserAlert.Style.Add("display", "inline"); adminEditUserAlert.Attributes.Add("class", "alert-danger"); adminEditUserAlert.InnerText = "Incorrect Admin Password"; } break; case 0: { //invalid password adminEditUserAlert.Style.Add("display", "inline"); adminEditUserAlert.Attributes.Add("class", "alert-danger"); adminEditUserAlert.InnerText = "Database Error Occured. Information could not be saved."; } break; } }
protected void btChangeProfSave_Click(object sender, EventArgs e) { hfTab.Value = "home"; Employee emp = new Employee(); emp.EmployeeId = Session["EmployeeId"].ToString(); emp.FirstName = tbFirstName.Text; emp.LastName = tbLastName.Text; emp.Email = tbEmailId.Text; string pass = tbChangeProfPass.Text; string hashedPassword = AppSecurity.HashSHA1(pass + Session["USER_GUID"].ToString()); DataAccessLayer dal = new DataAccessLayer(); int? ret = dal.UpdateAccountInfo(emp, hashedPassword); switch (ret) { case 1: { // update session information Session["FirstName"] = emp.FirstName; Session["LastName"] = emp.LastName; Session["EMAIL"] = emp.Email; ((Label)Master.FindControl("lbUserName")).Text = emp.FirstName + " " + emp.LastName; //show success message editAlert.Style.Add("display", "inline"); editAlert.Attributes.Add("class", "alert-success"); editAlert.InnerText = "Account Information Successfully Updated"; } break; case -1: { //invalid password editAlert.Style.Add("display", "inline"); editAlert.Attributes.Add("class", "alert-danger"); editAlert.InnerText = "Incorrect Password"; } break; case 0: { //invalid password editAlert.Style.Add("display", "inline"); editAlert.Attributes.Add("class", "alert-danger"); editAlert.InnerText = "Database Error Occured. Information could not be saved."; } break; } }