public void loadUserDetails()
{
try
{
DataManager.user selectedUsers = new DataManager.user();
foreach (DataManager.user temp in users)
{
if (temp.user_name.Equals(UserName.SelectedItem.ToString()))
{
selectedUsers = temp;
}
}
Password.Text = selectedUsers.password;
ConfirmPassword.Text = selectedUsers.password;
TextBox2.Text = selectedUsers.email;
if (selectedUsers.type.Trim().Equals("STAFF"))
{
return;
}
DataManager.costumer selectetCostumer = new DataManager.costumer();
foreach (DataManager.costumer temp in costumers)
{
if (temp.user_name.Equals(selectedUsers.user_name))
{
selectetCostumer = temp;
}
}
Address.Text = selectetCostumer.address;
phno.Text = selectetCostumer.phone;
site.Text = selectetCostumer.website;
Name1.Text = selectetCostumer.name;
Image1.ImageUrl = selectetCostumer.img;
}
catch (Exception) { }
}
protected void CreateUser_Click(object sender, EventArgs e)
{
DataManager.user updateUser = new DataManager.user();
updateUser.user_name = UserName.SelectedItem.ToString();
updateUser.password = Password.Text;
updateUser.email = TextBox2.Text;
if (RadioButton1.Checked)
{
updateUser.type = "STAFF";
}
else
{
updateUser.type = "COSTUMER";
}
ts.updateUser(updateUser);
if (RadioButton2.Checked)
{
DataManager.costumer updateCost = new DataManager.costumer();
updateCost.name = Name1.Text;
updateCost.phone = phno.Text;
updateCost.website = site.Text;
if (FileUpload1.FileName != null && FileUpload1.FileName.Length > 0)
{
string folderPath = Server.MapPath("~/CompanyLogo/");
FileUpload1.SaveAs(folderPath + Path.GetFileName(FileUpload1.FileName));
updateCost.img = "CompanyLogo/" + Path.GetFileName(FileUpload1.FileName);
}
else
{
updateCost.img = Image1.ImageUrl;
}
ts.updateCostumer(updateCost);
Response.Redirect("AdminHome.aspx");
}
}
protected void CreateUser_Click(object sender, EventArgs e)
{
DataManager.user user = new DataManager.user();
user.user_name = UserName.Text;
user.password = Password.Text;
user.email = TextBox2.Text;
if (RadioButton1.Checked)
{
user.type = "STAFF";
}
else
{
user.type = "COSTUMER";
}
TaskManager ts = new TaskManager();
if (ts.registerUser(user))
{
if (RadioButton1.Checked)
{
Response.Redirect("AdminHome.aspx");
}
else
{
Session["Costumer"] = user.user_name;
Response.Redirect("AddCostumer.aspx");
}
}
else
{
ErrorMessage.Text = "The Username Already Exist";
}
}
public bool registerUser(DataManager.user user)
{
string command = "SELECT * FROM User WHERE user_name='" + user.user_name + "'";
try
{
SqlCommand com = new SqlCommand(command, con);
SqlDataReader reader;
con.Open();
reader = com.ExecuteReader();
if (reader.Read())
{
reader.Close();
return(false);
}
reader.Close();
}
catch (Exception ex)
{
}
command = "INSERT INTO [User] (user_name,password,email,type) VALUES('" + user.user_name + "','" + user.password + "','" + user.email + "','" + user.type + "')";
// con.Open();
SqlCommand com2 = new SqlCommand(command, con);
com2.ExecuteNonQuery();
con.Close();
return(true);
}
public void updateUser(DataManager.user user)
{
string command = "UPDATE [User] SET password='******',email='" + user.email + "' WHERE user_name='" + user.user_name + "'";
SqlCommand com2 = new SqlCommand(command, con);
con.Open();
com2.ExecuteNonQuery();
con.Close();
}
protected void CreateUser_Click(object sender, EventArgs e)
{
TaskManager ts = new TaskManager();
DataManager.user user = new DataManager.user();
user.user_name = UserName.Text;
user.password = Password.Text;
user.email = TextBox2.Text;
user.type = "CLIENT";
if (ts.registerUser(user))
{
}
else
{
ErrorMessage.Text = "The Username Already Exist";
}
}
public List <DataManager.user> getUsers()
{
List <DataManager.user> retVal = new List <DataManager.user>();
string command = "SELECT * FROM [User]";
SqlCommand com = new SqlCommand(command, con);
SqlDataReader reader;
con.Open();
reader = com.ExecuteReader();
while (reader.Read())
{
DataManager.user temp = new DataManager.user();
temp.user_name = reader.GetString(0);
temp.password = reader.GetString(1);
temp.email = reader.GetString(2);
temp.type = reader.GetString(3);
retVal.Add(temp);
}
reader.Close();
con.Close();
return(retVal);
}
