//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;
}
}
