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