protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { var result = Request.QueryString.ToString(); int a = Convert.ToInt32(result); InvolvingDB involvingDB = new InvolvingDB(); HumanBeing Updatehuman = new HumanBeing(); involvingDB.GetfromDB(Updatehuman, a); Label1.Text = "Hello " + Updatehuman.Firstname1 + ""; Fname.Text = Updatehuman.Firstname1; LName.Text = Updatehuman.Lastname1; MiddleName.Text = Updatehuman.Middlename1; Roles.SelectedValue = $"{Updatehuman.Role1}"; Calendar1.SelectedDate = Updatehuman.DateOfBirth1; email.Text = Updatehuman.Email1; AltEmail.Text = Updatehuman.AlternateEmail1; Pnumber.Text = Updatehuman.PhoneNumber1; AltPnumber.Text = Updatehuman.AlternateNumber1; } }
protected void btnUpdate_Click(object sender, EventArgs e) { var result = Request.QueryString.ToString(); int a = Convert.ToInt32(result); HumanBeing UpdateHuman = new HumanBeing(); InvolvingDB involvingDB = new InvolvingDB(); UpdateHuman.Firstname1 = Fname.Text; UpdateHuman.Lastname1 = LName.Text; UpdateHuman.Middlename1 = MiddleName.Text; UpdateHuman.DateOfBirth1 = Calendar1.SelectedDate; UpdateHuman.AlternateEmail1 = AltEmail.Text; UpdateHuman.Email1 = email.Text; UpdateHuman.AlternateNumber1 = AltPnumber.Text; UpdateHuman.PhoneNumber1 = Pnumber.Text; if (Roles.SelectedValue == "1") { UpdateHuman.Role1 = 1; } else if (Roles.SelectedValue == "2") { UpdateHuman.Role1 = 2; } else if (Roles.SelectedValue == "3") { UpdateHuman.Role1 = 3; } involvingDB.UpdateUser(UpdateHuman, a); CleaningUp(); }
public void GetfromDB(HumanBeing dataBase, int ID) { using (SqlConnection connection = new SqlConnection("Data Source=LAPTOP-MD52G2CP;Initial Catalog=AppFactory;Persist Security Info=True;User ID=sa;Password=Nomfundo")) { try { connection.Open(); SqlCommand command = new SqlCommand($"select Person.FirstName, Person.LastName, Person.MiddleName,Roles.RoleID,Person.DateofBirth,ContactDetails.Work_Email,ContactDetails.AlternateEmail,ContactDetails.PrimaryPhone_No,ContactDetails.AlternatePhone_No,Person.PersonID from Person inner join Roles on Person.RoleID = Roles.RoleID inner join ContactDetails on Person.PersonID=ContactDetails.PersonID where Person.IsActive = 1 and Person.PersonID={ID};", connection); var data = command.ExecuteReader(); while (data.Read()) { dataBase.Firstname1 = data[0].ToString(); dataBase.Lastname1 = data[1].ToString(); dataBase.Middlename1 = data[2].ToString(); dataBase.Role1 = Convert.ToInt32(data[3].ToString()); dataBase.DateOfBirth1 = DateTime.Parse(data[4].ToString()); dataBase.Email1 = data[5].ToString(); dataBase.AlternateEmail1 = data[6].ToString(); dataBase.PhoneNumber1 = data[7].ToString(); dataBase.AlternateNumber1 = data[8].ToString(); } } catch (SqlException sqlException) { System.Diagnostics.Debug.WriteLine(sqlException); } } }
private void readEmployeeCSV(string path) { StreamReader sr = new StreamReader(path); String line; while ((line = sr.ReadLine()) != null) { string[] parts = line.Split(','); HumanBeing hmn = new HumanBeing(parts[0], parts[1]); ppl.Add(hmn); } }
protected void Button1_Click(object sender, EventArgs e) { HumanBeing Human = new HumanBeing(); InvolvingDB involvingDB = new InvolvingDB(); Human.Firstname1 = FirstName.Text; Human.Lastname1 = Surname.Text; Human.Middlename1 = MiddleName.Text; Human.DateOfBirth1 = Calendar1.SelectedDate; Human.AlternateEmail1 = AltEmail.Text; Human.Email1 = Email.Text; Human.AlternateNumber1 = AltPhoneNumber.Text; Human.PhoneNumber1 = PhoneNumber.Text; if (IsbusinessEmail.Checked) { Human.IsBusiness1 = 1; } else { Human.IsBusiness1 = 0; } if (IsnoActive.Checked) { Human.IsActive1 = 1; } else { Human.IsActive1 = 0; } if (Roles.SelectedValue == "1") { Human.Role1 = 1; } else if (Roles.SelectedValue == "2") { Human.Role1 = 2; } else if (Roles.SelectedValue == "3") { Human.Role1 = 3; } involvingDB.SentToDB(Human); CleaningUp(); }
public void SentToDB(HumanBeing dataBase) { using (SqlConnection connection = new SqlConnection("Data Source=LAPTOP-MD52G2CP;Initial Catalog=AppFactory;Persist Security Info=True;User ID=sa;Password=Nomfundo")) { try { connection.Open(); SqlCommand command = new SqlCommand("Insert into Person (LastName,FirstName,MiddleName,DateofBirth,RoleID)values('" + dataBase.Lastname1 + "','" + dataBase.Firstname1 + "','" + dataBase.Middlename1 + "','" + dataBase.DateOfBirth1 + "'," + dataBase.Role1 + ");Insert into ContactDetails values('" + dataBase.Email1 + "'," + dataBase.IsBusiness1 + ",'" + dataBase.AlternateEmail1 + "','" + dataBase.PhoneNumber1 + "'," + dataBase.IsActive1 + ",'" + dataBase.AlternateNumber1 + "',SCOPE_IDENTITY())", connection); command.ExecuteNonQuery(); } catch (SqlException sqlException) { System.Diagnostics.Debug.WriteLine(sqlException); } } }
public void UpdateUser(HumanBeing dataBase, int ID) { using (SqlConnection connection = new SqlConnection("Data Source=LAPTOP-MD52G2CP;Initial Catalog=AppFactory;Persist Security Info=True;User ID=sa;Password=Nomfundo")) { try { connection.Open(); SqlCommand command = new SqlCommand("Update person set LastName='" + dataBase.Lastname1 + "',FirstName='" + dataBase.Firstname1 + "',MiddleName='" + dataBase.Middlename1 + "',DateofBirth='" + dataBase.DateOfBirth1 + "',RoleID=" + dataBase.Role1 + " where PersonID=" + ID + ";UPDATE ContactDetails set Work_Email='" + dataBase.Email1 + "',AlternateEmail='" + dataBase.AlternateEmail1 + "',PrimaryPhone_No='" + dataBase.PhoneNumber1 + "',AlternatePhone_No='" + dataBase.AlternateNumber1 + "' WHERE PersonID=" + ID + ";", connection); command.ExecuteNonQuery(); } catch (SqlException sqlException) { System.Diagnostics.Debug.WriteLine(sqlException); } } }