private void submit_Click(object sender, EventArgs e) { Person_v2 newEmp = new Person_v2(); // DateTime dt1 = dTime1.Value; // DateTime dt2 = dTime2.Value; newEmp.FName = fName.Text; newEmp.LName = lName.Text; newEmp.EmpId = empID.Text; newEmp.DTime1 = dTime1.Text; newEmp.DTime2 = dTime2.Text; newEmp.States = states.Text; newEmp.Comment = comment.Text; FillLabel(newEmp); if (newEmp.Feedback.Contains("Error: ")) { lblfeedback.Text = newEmp.Feedback; } else if ((dTime1.Value) > (dTime2.Value)) { lblfeedback.Text = "ERROR: Unvalid vacation request"; } else { FillLabel(newEmp); lblfeedback.Text = newEmp.AddContact(); } }
private void btnUpdate_Click(object sender, EventArgs e) { //Declaration Person_v2 temp = new Person_v2(); temp.FName = fName.Text; temp.LName = lName.Text; temp.EmpId = empID.Text; temp.DTime1 = dTime1.Text; temp.DTime2 = dTime2.Text; temp.Comment = comment.Text; temp.States = states.Text; temp.Person_ID = Convert.ToInt32(lblPerson_ID.Text); if (temp.Feedback.Contains("ERROR:")) { lblfeedback.Text = temp.Feedback; } else if (temp.FName.Length > 0 && temp.LName.Length > 0) { DisplayInfo(temp); Int32 intRocords = temp.UpdateAContact(); lblfeedback.Text = intRocords.ToString() + " Records Updated."; } else { DisplayInfo(temp); } }
private void btnSearch_Click_1(object sender, EventArgs e) { //Call the search function in Person_v2 Person_v2 temp = new Person_v2(); DataSet ds = temp.SearchRecords(txtfName.Text, txtlName.Text, txtEmpID.Text, comment.Text, states.Text); //Get the results and display gvResults.DataSource = ds; gvResults.DataMember = "CopyOfPersons"; //gvResults. }
private void btnDelete_Click(object sender, EventArgs e) { //create a person so we can use the delete methode Person_v2 temp = new Person_v2(); //convert the label text holding the ID to an integer Int32 intPerson_ID = Convert.ToInt32(lblPerson_ID.Text); //Use the Person ID and pass it to the delete function and get the number of records deleted Int32 intRecords = temp.DeleteOnePerson(intPerson_ID); //Display feedback to the user lblfeedback.Text = intRecords.ToString() + "Records Deleted"; }
public Form1(Int32 intPerson_ID) { InitializeComponent(); Person_v2 temp = new Person_v2(); SqlDataReader dr = temp.FindOnePerson(intPerson_ID); while (dr.Read()) { fName.Text = dr["FName"].ToString(); lName.Text = dr["LName"].ToString(); empID.Text = dr["EmpId"].ToString(); dTime1.Text = dr["DTime1"].ToString(); dTime2.Text = dr["DTime2"].ToString(); comment.Text = dr["Comment"].ToString(); states.Text = dr["States"].ToString(); lblPerson_ID.Text = dr["Person_ID"].ToString(); } }