Файл: Разработка информационной системы по работе с клиентами организации (на примере ооо стаффджет).pdf

71
DBDataSet.APPLICANTSDataTable ADT = ATAdapter.GetDataByID(ID); if (ADT.Count > 0)
{ object[] RowArray = ADT.Rows[0].ItemArray;
SecondName = (string)RowArray[1];
FirstName = (string)RowArray[2];
Furname = (string)RowArray[3];
City = (string)RowArray[4];
BirthDate = (DateTime)RowArray[5];
Sex = (string)RowArray[6];
ID_Edu = (int)RowArray[7];
ID_Spec = (int)RowArray[8];
Expierence = (byte)RowArray[9];
WishSalary = (int)RowArray[10];
ReadyToMove = (bool)RowArray[11];
PrivateVihicle = (bool)RowArray[12];
PCKnowledge = (bool)RowArray[13];
WishHolidayMonth = (string)RowArray[14];
Children = (byte)RowArray[15];
Phone = (string)RowArray[16];
ID_Agent = (int)RowArray[17];
Status = (string)RowArray[18];
ProcessDate = (DateTime)RowArray[19];
}
}
}
// ----------------------------------------- public void AddMeToDB()
{
DBDataSetTableAdapters.APPLICANTSTableAdapter ATAdapter;
ATAdapter = new DBDataSetTableAdapters.APPLICANTSTableAdapter();
ATAdapter.InsertQuery(SecondName,
FirstName,
Furname,
City,
BirthDate,
Sex,
ID_Edu,
ID_Spec,
Expierence,
WishSalary,
ReadyToMove,
PrivateVihicle,
PCKnowledge,
WishHolidayMonth,

72
Children,
Phone,
ID_Agent,
Status,
ProcessDate);
ALF.dBDataSet.AcceptChanges();
ATAdapter.Dispose();
}
// ----------------------------------------- public void DeleteMeFromDB()
{
DBDataSetTableAdapters.APPLICANTSTableAdapter ATAdapter;
ATAdapter = new DBDataSetTableAdapters.APPLICANTSTableAdapter();
ATAdapter.DeleteQuery(ID);
ALF.dBDataSet.AcceptChanges();
ATAdapter.Dispose();
}
// ----------------------------------------- public void UpdateMeInDB()
{
DBDataSetTableAdapters.APPLICANTSTableAdapter ATAdapter;
ATAdapter = new DBDataSetTableAdapters.APPLICANTSTableAdapter();
ATAdapter.UpdateQuery(SecondName,
FirstName,
Furname,
City,
BirthDate,
Sex,
ID_Edu,
ID_Spec,
Expierence,
WishSalary,
ReadyToMove,
PrivateVihicle,
PCKnowledge,
WishHolidayMonth,
Children,
Phone,
ID_Agent,
Status,
ProcessDate,
ID);
ALF.dBDataSet.AcceptChanges();
ATAdapter.Dispose();
}

73
#endregion
}
}