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");
}
}
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) { }
}
public List <DataManager.costumer> getCompaniesDetails()
{
List <DataManager.costumer> retVal = new List <DataManager.costumer>();
string command = "SELECT * FROM Costumer";
SqlCommand com = new SqlCommand(command, con);
SqlDataReader reader;
con.Open();
reader = com.ExecuteReader();
while (reader.Read())
{
DataManager.costumer temp = new DataManager.costumer();
temp.user_name = reader.GetString(0);
temp.name = reader.GetString(1);
temp.address = reader.GetString(2);
temp.phone = reader.GetString(3);
temp.img = reader.GetString(4);
try
{
temp.website = reader.GetString(5);
}catch (Exception) {}
retVal.Add(temp);
}
reader.Close();
con.Close();
return(retVal);
}
public void updateCostumer(DataManager.costumer costumer)
{
string command = "UPDATE [Costumer] SET address='" + costumer.address + "',phone_number='" + costumer.phone + "',logo='" + costumer.img + "',website='" + costumer.website + "' WHERE user_name='" + costumer.user_name + "'";
SqlCommand com2 = new SqlCommand(command, con);
con.Open();
com2.ExecuteNonQuery();
con.Close();
}
public bool addCostumer(DataManager.costumer costumer)
{
string command = "INSERT INTO Costumer (user_name,company_name,address,phone_number,logo,website) VALUES('" + costumer.user_name + "','" + costumer.name + "','" + costumer.address + "','" + costumer.phone + "','" + costumer.img + "','" + costumer.website + "')";
SqlCommand com2 = new SqlCommand(command, con);
con.Open();
com2.ExecuteNonQuery();
con.Close();
return(true);
}
protected void CreateUser_Click(object sender, EventArgs e)
{
string folderPath = Server.MapPath("~/CompanyLogo/");
if (!Directory.Exists(folderPath))
{
Directory.CreateDirectory(folderPath);
}
FileUpload1.SaveAs(folderPath + Path.GetFileName(FileUpload1.FileName));
DataManager.costumer costumer = new DataManager.costumer();
costumer.name = UserName.Text;
costumer.address = Address.Text;
costumer.phone = phno.Text;
costumer.img = "CompanyLogo/" + Path.GetFileName(FileUpload1.FileName);
costumer.user_name = Session["Costumer"].ToString().Trim();
costumer.website = site.Text;
TaskManager ts = new TaskManager();
ts.addCostumer(costumer);
Response.Redirect("AdminHome.aspx");
}
