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