protected void btn_AddUsers_Click(object sender, EventArgs e)
{
var userIdTxt = userid.Text.Trim();
if (!password.Text.Trim().Equals(string.Empty) && !userIdTxt.Equals(string.Empty))
{
if (new TPSDataHandling().IsUserExists(userIdTxt))
{
lblMessage.Text = "UserId(" + userIdTxt + ") already exists.";
return;
}
bool Done = new TPSDataHandling().addUser(userIdTxt, password.Text, DropDownList_Level.SelectedValue);
if (Done)
{
if (DropDownList_Level.SelectedValue.Equals("S"))
{
userDatabase.addStaff(userIdTxt, "", "", "", "", "", "", "", "");
}
lblMessage.Text = "User(" + userIdTxt + ") was successfully added!";
ds = userDatabase.grabDataSet("SELECT * FROM [login]");
user_grid.DataSource = ds;
user_grid.DataBind();
}
else
{
lblMessage.Text = "The user could not be added!";
}
}
else
{
lblMessage.Text = "Please enter valid userName and password!";
}
}
protected void btn_Update_Click(object sender, EventArgs e)
{
var tps = new TPSDataHandling();
var userIdTxt = userid.Text.Trim();
if (!userIdTxt.Equals(string.Empty))
{
if (!new TPSDataHandling().IsUserExists(userIdTxt))
{
lblMessage.Text = "Update :: UserId(" + userIdTxt + ") not found.";
return;
}
if (tps.updateUser(userIdTxt, password.Text, DropDownList_Level.SelectedValue))
{
lblMessage.Text = "UserId(" + userIdTxt + ") successfully updated.";
ds = userDatabase.grabDataSet("SELECT * FROM [login]");
user_grid.DataSource = ds;
user_grid.DataBind();
}
else
{
lblMessage.Text = "Failed to update UserId(" + userIdTxt + ").";
}
}
else
{
lblMessage.Text = "Invalid UserId.";
}
}
protected void btnDeleteUser_Click(object sender, EventArgs e)
{
var tps = new TPSDataHandling();
if (!userid.Text.Trim().Equals(string.Empty))
{
var userIdTxt = userid.Text.Trim();
if (tps.deleteUser(userIdTxt))
{
if (DropDownList_Level.SelectedValue.Equals("S"))
{
tps.deleteStaff(userIdTxt);
}
lblMessage.Text = "UserId(" + userIdTxt + ") was successfully deleted.";
ds = userDatabase.grabDataSet("SELECT * FROM [login]");
user_grid.DataSource = ds;
user_grid.DataBind();
}
}
else
{
lblMessage.Text = "Invalid UserId.";
}
userid.Text = "";
password.Text = "";
}
// Handles when the pages loads
protected void Page_Load(object sender, EventArgs e)
{
// Security Check
if (Session["SecurityLevel"].ToString() == "S")
{
Server.Transfer("index.aspx", true);
}
else if (Session["SecurityLevel"].ToString() == "M" || Session["SecurityLevel"].ToString() == "C")
{
// Do nothing
}
else
{
Server.Transfer("login.aspx", true);
}
// Grab a dataset
tpsData = new TPSDataHandling();
ds = tpsData.grabDataSet("SELECT staff.[userid] AS [ID], [full_name] AS [Name], [experience] AS [Experience (Years)], [degree] AS [Degree], [salary] AS [Salary], [city] AS [City], [state] AS [State] FROM staff, login WHERE login.[userid] = staff.[userid] AND [security] = 'S'");
// Check for postback data in case of changes
if (!Page.IsPostBack)
{
Session["DataView"] = new DataView(ds.Tables[0]);
staff_grid.DataSource = ds;
Session["Staff"] = "";
}
else
{
selectedStaff = Session["Staff"].ToString();
staff_grid.DataSource = (DataView)Session["DataView"];
}
// Bind data
staff_grid.DataBind();
}
// Method for when page loads
protected void Page_Load(object sender, EventArgs e)
{
if (Session["SecurityLevel"].ToString() == "C")
{
Server.Transfer("index.aspx", true);
}
else if (Session["SecurityLevel"].ToString() == "S" || Session["SecurityLevel"].ToString() == "M")
{
// Do nothing
}
else
{
Server.Transfer("login.aspx", true);
}
tpsDataHandling = new TPSDataHandling();
if (!IsPostBack)
{
myDict = tpsDataHandling.getStaff(Session["UserID"].ToString());
txtName.Text = myDict["full_name"];
if (ddlDegree.Items.Contains(new ListItem(myDict["degree"])))
{
ddlDegree.SelectedValue = myDict["degree"];
}
txtExperience.Text = myDict["experience"];
txtSalary.Text = myDict["salary"];
txtStreet.Text = myDict["street"];
txtCity.Text = myDict["city"];
txtState.Text = myDict["state"];
txtZipcode.Text = myDict["zipcode"];
}
string[] dirs = Directory.GetFiles(Server.MapPath("Pictures") + "\\");
foreach (string dir in dirs)
{
if (dir.Contains(Session["UserID"].ToString()))
{
imgProfile.ImageUrl = "~/Pictures/" + Session["UserID"].ToString() + "." + Path.GetExtension(dir).Substring(1);
imgProfile.Visible = true;
}
}
dirs = Directory.GetFiles(Server.MapPath("Resume") + "\\");
foreach (string dir in dirs)
{
if (dir.Contains(Session["UserID"].ToString()))
{
lbResume.Visible = true;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["SecurityLevel"].ToString() == "M")
{
//Do nothing
}
else if (Session["SecurityLevel"].ToString() == "S" || Session["SecurityLevel"].ToString() == "C")
{
Server.Transfer("index.aspx", true);
}
else
{
Server.Transfer("login.aspx", true);
}
userDatabase = new TPSDataHandling();
ds = userDatabase.grabDataSet("SELECT * FROM login");
user_grid.DataSource = ds;
user_grid.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["SecurityLevel"].ToString() == "M")
{
// Do nothing
}
else if (Session["SecurityLevel"].ToString() == "S" || Session["SecurityLevel"].ToString() == "C")
{
Server.Transfer("index.aspx", true);
}
else
{
Server.Transfer("login.aspx", true);
}
tpsData = new TPSDataHandling();
ds = tpsData.grabDataSet("SELECT * FROM requests");
if (!IsPostBack)
{
staff_grid.DataSource = ds;
staff_grid.DataBind();
selectedValue = "";
}
}
protected void Page_Load(object sender, EventArgs e)
{
useDatabase = new TPSDataHandling();
Session["UserID"] = "";
Session["SecurityLevel"] = "";
}