public void Load() { if (ID != -1) { IDBInterface db = DBInterface.CreatePointer(); db.StoredProcedure("mile_card_status_select_by_id"); db.AddParameter("@inIdMileCardStatus", MySql.Data.MySqlClient.MySqlDbType.Int32, ID); db.AddOutParameter("@outStatus", MySql.Data.MySqlClient.MySqlDbType.String); db.AddOutParameter("@outMinMiles", MySql.Data.MySqlClient.MySqlDbType.Int32); db.AddOutParameter("@outMaxMiles", MySql.Data.MySqlClient.MySqlDbType.Int32); db.AddOutParameter("@outIdAviaCompanyUnion", MySql.Data.MySqlClient.MySqlDbType.Int32); db.AddOutParameter("@outIdAviaCompany", MySql.Data.MySqlClient.MySqlDbType.Int32); db.AddOutParameter("@outNote", MySql.Data.MySqlClient.MySqlDbType.String); db.Execute(); Name = db.GetOutParameterStr("@outStatus"); MinVal = db.GetOutParameterInt("@outMinMiles"); MaxVal = db.GetOutParameterInt("@outMaxMiles"); Note = db.GetOutParameterStr("@outNote"); AviaCompanyID = db.GetOutParameterInt("@outIdAviaCompany"); AviaCompanyUnionID = db.GetOutParameterInt("@outIdAviaCompanyUnion"); Changed = false; } }
public void Load() { if (ID != -1) { IDBInterface db = DBInterface.CreatePointer(); db.StoredProcedure("Visa_select_by_id"); db.AddParameter("@inVisa", MySql.Data.MySqlClient.MySqlDbType.Int32, ID); db.AddOutParameter("@outIdPassport", MySql.Data.MySqlClient.MySqlDbType.Int32); db.AddOutParameter("@outName", MySql.Data.MySqlClient.MySqlDbType.String); db.AddOutParameter("@outVisaNumber", MySql.Data.MySqlClient.MySqlDbType.String); db.AddOutParameter("@outDateOn", MySql.Data.MySqlClient.MySqlDbType.DateTime); db.AddOutParameter("@outdateFrom", MySql.Data.MySqlClient.MySqlDbType.DateTime); db.AddOutParameter("@outDateUntil", MySql.Data.MySqlClient.MySqlDbType.DateTime); db.AddOutParameter("@outIdCountry", MySql.Data.MySqlClient.MySqlDbType.Int32); db.AddOutParameter("@outIdCountryUnion", MySql.Data.MySqlClient.MySqlDbType.Int32); db.AddOutParameter("@outIdCountryEsquire", MySql.Data.MySqlClient.MySqlDbType.Int32); db.AddOutParameter("@outTypeVisa", MySql.Data.MySqlClient.MySqlDbType.String); db.AddOutParameter("@outEntriesNumber", MySql.Data.MySqlClient.MySqlDbType.Int32); db.AddOutParameter("@outDaysCount", MySql.Data.MySqlClient.MySqlDbType.Int32); db.AddOutParameter("@outUsedDays", MySql.Data.MySqlClient.MySqlDbType.Int32); db.AddOutParameter("@outIssuedIn", MySql.Data.MySqlClient.MySqlDbType.String); db.AddOutParameter("@outIdDocument", MySql.Data.MySqlClient.MySqlDbType.Int32); db.AddOutParameter("@outNote", MySql.Data.MySqlClient.MySqlDbType.String); db.Execute(); PassportID = db.GetOutParameterInt("@outIdPassport"); int countryID = db.GetOutParameterInt("@outIdCountry"); int unionID = db.GetOutParameterInt("@outIdCountryUnion"); CountryOfEmmitationID = db.GetOutParameterInt("@outIdCountryEsquire"); EntriesNumber = db.GetOutParameterInt("@outEntriesNumber"); DaysCount = db.GetOutParameterInt("@outDaysCount"); DaysUsed = db.GetOutParameterInt("@outUsedDays"); OwnerName = db.GetOutParameterStr("@outName"); Number = db.GetOutParameterStr("@outVisaNumber"); VizaType = db.GetOutParameterStr("@outTypeVisa"); Issued = db.GetOutParameterStr("@outIssuedIn"); Description = db.GetOutParameterStr("@outNote"); DateApproved = db.GetOutParameterDateTime("@outDateOn"); ValidFrom = db.GetOutParameterDateTime("@outdateFrom"); ValidTill = db.GetOutParameterDateTime("@outDateUntil"); SetTargetCountryOrUnion(countryID, unionID); Changed = false; } }
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"); } }
public void Load() { if (ID != -1) { IDBInterface db = DBInterface.CreatePointer(); db.StoredProcedure("Country_union_select_by_id"); db.AddParameter("@inIdCountryUnion", MySql.Data.MySqlClient.MySqlDbType.Int32, ID); db.AddOutParameter("@outUnionName", MySql.Data.MySqlClient.MySqlDbType.String); db.AddOutParameter("@outShortUnionName", MySql.Data.MySqlClient.MySqlDbType.String); db.AddOutParameter("@outNote", MySql.Data.MySqlClient.MySqlDbType.String); db.Execute(); Name = db.GetOutParameterStr("@outUnionName"); ShortName = db.GetOutParameterStr("@outShortUnionName"); Note = db.GetOutParameterStr("@outNote"); Changed = false; } }