public void Load()
{
IDBInterface db = DBInterface.CreatePointer();
db.StoredProcedure("mile_card_select_by_id");
db.AddParameter("@inIdMileCard", MySql.Data.MySqlClient.MySqlDbType.Int32, ID);
db.AddOutParameter("@outIdMileCardStatus", MySql.Data.MySqlClient.MySqlDbType.Int32);
db.AddOutParameter("@outNumber", MySql.Data.MySqlClient.MySqlDbType.String);
db.AddOutParameter("@outPassword", MySql.Data.MySqlClient.MySqlDbType.String);
db.AddOutParameter("@outMilesCount", MySql.Data.MySqlClient.MySqlDbType.Int32);
db.AddOutParameter("@outIdAviaCompanyUnion", MySql.Data.MySqlClient.MySqlDbType.Int32);
db.AddOutParameter("@outIdAviaCompany", MySql.Data.MySqlClient.MySqlDbType.Int32);
db.AddOutParameter("@outIdRespondedPerson", MySql.Data.MySqlClient.MySqlDbType.Int32);
db.AddOutParameter("@outIdOwnerPerson", MySql.Data.MySqlClient.MySqlDbType.Int32);
db.AddOutParameter("@outNote", MySql.Data.MySqlClient.MySqlDbType.String);
db.Execute();
mileCardStatus.ID = db.GetOutParameterInt("@outIdMileCardStatus");
mileCardStatus.Load();
Silent = true;
Number = db.GetOutParameterStr("@outNumber");
Password = db.GetOutParameterStr("@outPassword");
MilesCount = db.GetOutParameterInt("@outMilesCount");
AviaCompanyUnionID = db.GetOutParameterInt("@outIdAviaCompanyUnion");
AviaCompanyID = db.GetOutParameterInt("@outIdAviaCompany");
PersonRespondedID = db.GetOutParameterInt("@outIdRespondedPerson");
Note = db.GetOutParameterStr("@outNote");
Silent = false;
Changed = false;
if (personOwner.ID != db.GetOutParameterInt("@outIdOwnerPerson"))
{
throw new DataException("Mile card doesnt relates to current person");
}
}
