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