public People_manager(People _input, CommuteManager _Main) { InitializeComponent(); Main = _Main; PersonalData = _input; txtName.Text = PersonalData.Name; txtPhoto.Text = PersonalData.Photo; txtTagID.Text = PersonalData.TagID; txtBlood.Text = PersonalData.Blood; txtJob.Text = PersonalData.Job; txtCompany.Text = PersonalData.Company; txtPerNum.Text = PersonalData.PK; txtPhone.Text = PersonalData.Phone; txtAddress.Text = PersonalData.Address; txtYear.Text = PersonalData.Year; // txtInsure.Text = PersonalData.Insure; picPhoto.ImageLocation = PersonalData.Photo; if (_input.Edu == "Y") { radEduY.Checked = true; } else { radEduN.Checked = true; } }
public People_manager(CommuteManager _Main) { InitializeComponent(); Main = _Main; PersonalData = new People(); string strqry = "SELECT COUNT(*) FROM PersonalData"; server.GetDBTable(strqry); server.sdr.Read(); PersonIndex = server.sdr.GetInt32(0); PersonIndexStatic = PersonIndex; server.sdr.Close(); strqry = "SELECT Names,PK FROM PersonalData"; server.GetDBTable(strqry); names = new string[PersonIndex]; PK = new string[PersonIndex]; int i = 0; while (server.sdr.Read()) { names[i] = server.sdr.GetString(0); PK[i] = server.sdr.GetString(1); //if (names[i] == txtName.Text && PK[i] == txtPerNum.Text) DoubleFlag = true; i++; } server.sdr.Close(); }
//string name, tag, blood, job, comp, PK, phone, emer, add, year, insu, edu; public People_manager(string t0, string t1, string t2, string t3, string t4, string t5, string t6, string t7, string t8, string t9, string t10, string t11, CommuteManager _Main) { InitializeComponent(); chkModify.Checked = true; Main = _Main; txtName.Text = t0; txtTagID.Text = t1; txtBlood.Text = t2; txtJob.Text = t3; txtCompany.Text = t4; txtPerNum.Text = t5; txtPhone.Text = t6; txtEmer.Text = t7; txtAddress.Text = t8; txtYear.Text = t9; txtInsu.Text = t10; if (t11 == "Y") { radEduY.Checked = true; } else { radEduN.Checked = true; } PersonalData = new People(); string strqry = "SELECT COUNT(*) FROM PersonalData"; server.GetDBTable(strqry); server.sdr.Read(); PersonIndex = server.sdr.GetInt32(0); PersonIndexStatic = PersonIndex; server.sdr.Close(); strqry = "SELECT Names,PK FROM PersonalData"; server.GetDBTable(strqry); names = new string[PersonIndex]; PK = new string[PersonIndex]; int i = 0; while (server.sdr.Read()) { names[i] = server.sdr.GetString(0); PK[i] = server.sdr.GetString(1); //if (names[i] == txtName.Text && PK[i] == txtPerNum.Text) DoubleFlag = true; i++; } server.sdr.Close(); }