public void Copy(Jobtitle Source)
{
ID = Source.ID;
Code = Source.Code;
Name = Source.Name;
Sallary = Source.Sallary;
Dollar_per_hour = Source.Dollar_per_hour;
Dep = Source.Dep;
}
private void JTFill()
{
Jobtitle.Select("select * from JOB_TITLE",
(r)=>{
Jobtitle jt = new Jobtitle(r);
if (jt.ID == emp.JT.ID) jt = emp.JT;
combobJobtitle.Items.Add(jt);
});
if (combobJobtitle.Items.Count > 0)
combobJobtitle.SelectedIndex = (emp.ID == Guid.Empty)? 0 : combobJobtitle.Items.IndexOf(emp.JT);
}
public Employers()
: base()
{
TableName = "EMPLOYERS";
Birthday = DateTime.Now.AddYears(-18);
Date_of_assigment = Date_of_dismissal = DateTime.Now;
Gender = "ч";
JT = new Jobtitle();
cmd.Parameters.Add("@CODE", FbDbType.Integer, 50, "CODE");
cmd.Parameters.Add("@NAME", FbDbType.VarChar, 50, "NAME");
cmd.Parameters.Add("@BIRTHDAY", FbDbType.Date, 8, "BIRTHDAY");
cmd.Parameters.Add("@GENDER", FbDbType.Char, 1, "GENDER");
cmd.Parameters.Add("@CONTRACT", FbDbType.VarChar, 300, "CONTRACT");
cmd.Parameters.Add("@DATE_OF_ASSIGMENT", FbDbType.Date, 8, "DATE_OF_ASSIGMENT");
cmd.Parameters.Add("@DATE_OF_DISMISSAL", FbDbType.Date, 8, "DATE_OF_DISMISSAL");
cmd.Parameters.Add("@ID_JOBTITLE", FbDbType.Char, 38, "ID_JOBTITLE");
cmd.Parameters.Add("@SKILLS", FbDbType.VarChar, 200, "SKILLS");
}
private void bsJT_CurrentChanged(object sender, EventArgs e)
{
jt = (bsJT.Current as Jobtitle);
Binding();
}