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"); }