public static void LoadData(string start, string end) { _roles = new List <Roles>(Roles.ListRoles()); _patients = new List <Patient>(Patient.ListPatients()); _users = new List <Users>(Users.ListUsers()); _events = new List <Events>(Events.ListEvents()); _clinics = new List <Clinics>(Clinics.ListClinic()); _branch = new List <Branch>(Branch.ListBranch()); _queues = new List <Queue>(Queue.ListQueue()); _admit = new List <Admission>(Admission.ListAdmission()); _wards = new List <Wards>(Wards.ListWards()); _departments = new List <Departments>(Departments.ListDepartment()); _procedures = new List <Procedures>(Procedures.ListProcedures()); _operations = new List <Operations>(Operations.ListOperations()); _specimens = new List <Specimens>(Specimens.ListSpecimens()); _tests = new List <Tests>(Tests.ListTests()); _disciplines = new List <Discipline>(Discipline.ListDiscipline()); _beds = new List <Beds>(Beds.ListBeds()); _categories = new List <Category>(Category.ListCategory()); _cds = new List <Cd10>(Cd10.ListCd10()); _items = new List <Item>(Item.ListItem()); _stocks = new List <Stock>(Stock.ListStock()); _dosages = new List <Dosage>(Dosage.ListDosage()); _transactors = new List <Transactor>(Transactor.ListTransactors()); // _services = new List<Services>(Services.ListServices()); // _diagnosis = new List<Diagnosis>(Diagnosis.ListDiagnosis()); _rooms = new List <Room>(Room.ListRoom()); // _vitals = new List<Vitals>(Vitals.ListVitals()); _org = new List <Organisation>(Organisation.ListOrganisation()); }
private void saveBtn_Click(object sender, EventArgs e) { if (nameTxt.Text == "") { nameTxt.BackColor = Color.Red; return; } string id = Guid.NewGuid().ToString(); _ward = new Wards(id, nameTxt.Text, codeTxt.Text, capacityTxt.Text, costTxt.Text, depositTxt.Text, wingTxt.Text, periodTxt.Text, DateTime.Now.ToString("dd-MM-yyyy H:mm:ss"), Helper.orgID); if (DBConnect.Insert(_ward) != "") { Global._wards.Add(_ward); nameTxt.Text = ""; codeTxt.Text = ""; capacityTxt.Text = ""; MessageBox.Show("Information Saved"); LoadData(); } else { return; } }
public Wards GetByID(int _wardId) { WardsDAC _wardsComponent = new WardsDAC(); IDataReader reader = _wardsComponent.GetByIDWards(_wardId); Wards _wards = null; while (reader.Read()) { _wards = new Wards(); if (reader["WardId"] != DBNull.Value) { _wards.WardId = Convert.ToInt32(reader["WardId"]); } if (reader["WardCode"] != DBNull.Value) { _wards.WardCode = Convert.ToString(reader["WardCode"]); } if (reader["WardDescription"] != DBNull.Value) { _wards.WardDescription = Convert.ToString(reader["WardDescription"]); } if (reader["WardTypeId"] != DBNull.Value) { _wards.WardTypeId = Convert.ToInt32(reader["WardTypeId"]); } if (reader["WardForId"] != DBNull.Value) { _wards.WardForId = Convert.ToInt32(reader["WardForId"]); } if (reader["BedsNumber"] != DBNull.Value) { _wards.BedsNumber = Convert.ToInt32(reader["BedsNumber"]); } if (reader["WardCapacity"] != DBNull.Value) { _wards.WardCapacity = Convert.ToInt32(reader["WardCapacity"]); } if (reader["RoomsNumber"] != DBNull.Value) { _wards.RoomsNumber = Convert.ToInt32(reader["RoomsNumber"]); } if (reader["WardPhone"] != DBNull.Value) { _wards.WardPhone = Convert.ToString(reader["WardPhone"]); } if (reader["WardColor"] != DBNull.Value) { _wards.WardColor = Convert.ToString(reader["WardColor"]); } if (reader["WardOrder"] != DBNull.Value) { _wards.WardOrder = Convert.ToInt32(reader["WardOrder"]); } _wards.NewRecord = false; } reader.Close(); return(_wards); }
private void dtGrid_CellEndEdit(object sender, DataGridViewCellEventArgs e) { updateID = dtGrid.Rows[e.RowIndex].Cells[2].Value.ToString(); _ward = new Wards(dtGrid.Rows[e.RowIndex].Cells[2].Value.ToString(), dtGrid.Rows[e.RowIndex].Cells[4].Value.ToString(), dtGrid.Rows[e.RowIndex].Cells[5].Value.ToString(), dtGrid.Rows[e.RowIndex].Cells[6].Value.ToString(), dtGrid.Rows[e.RowIndex].Cells[7].Value.ToString(), dtGrid.Rows[e.RowIndex].Cells[8].Value.ToString(), dtGrid.Rows[e.RowIndex].Cells[9].Value.ToString(), dtGrid.Rows[e.RowIndex].Cells[10].Value.ToString(), DateTime.Now.ToString("dd-MM-yyyy H:mm:ss"), Helper.orgID); DBConnect.Update(_ward, updateID); Global._wards.RemoveAll(x => x.Id == updateID); Global._wards.Add(_ward); }
public HospitalViewModel(DataStoreItem item) : base(item) { foreach (Ward w in ((Hospital)Item).Wards) { Wards.Add(new DataStoreItemViewModel(w)); } AddNewWardCommand = new RelayCommand(AddWard); }
private void LoadWardsData() { Wards oWards = new Wards(); cboWard.DataBindings.Clear(); m_oDS = oWards.GetData(); cboWard.DataSource = m_oDS.Tables["Wards"]; cboWard.DisplayMember = "Name"; cboWard.ValueMember = "Name"; }
public override void Start() { base.Start(); try { SelectedCounty = Counties.FirstOrDefault(x => x.Id == 0); SelectedSubCounty = SubCounties.FirstOrDefault(x => x.Id == 0); SelectedWard = Wards.FirstOrDefault(x => x.Id == 0); } catch { } }
public bool Insert(Wards wards) { int autonumber = 0; WardsDAC wardsComponent = new WardsDAC(); bool endedSuccessfuly = wardsComponent.InsertNewWards(ref autonumber, wards.WardCode, wards.WardDescription, wards.WardTypeId, wards.WardForId, wards.BedsNumber, wards.WardCapacity, wards.RoomsNumber, wards.WardPhone, wards.WardColor, wards.WardOrder); if (endedSuccessfuly) { wards.WardId = autonumber; } return(endedSuccessfuly); }
public ShadowShaman(Unit9 owner, MultiSleeper abilitySleeper, Sleeper orbwalkSleeper, ControllableUnitMenu menu) : base(owner, abilitySleeper, orbwalkSleeper, menu) { this.ComboAbilities = new Dictionary <AbilityId, Func <ActiveAbility, UsableAbility> > { { AbilityId.shadow_shaman_ether_shock, x => this.shock = new NukeAbility(x) }, { AbilityId.shadow_shaman_voodoo, x => this.hex = new DisableAbility(x) }, { AbilityId.shadow_shaman_shackles, x => this.shackles = new DisableAbility(x) }, { AbilityId.shadow_shaman_mass_serpent_ward, x => this.wards = new Wards(x) }, { AbilityId.item_force_staff, x => this.force = new ForceStaff(x) }, { AbilityId.item_blink, x => this.blink = new BlinkAbility(x) }, { AbilityId.item_cyclone, x => this.euls = new EulsScepterOfDivinity(x) }, }; this.MoveComboAbilities.Add(AbilityId.shadow_shaman_voodoo, _ => this.hex); }
internal static void OnLoad(EventArgs args) { Config = new Menu(Menuname, Menuname, true); Orbwalker = new Orbwalking.Orbwalker(Menu.root); ActivatorMenu.LoadActivator(); DamagesMenu.LoadDamagesMenu(); EnviormentMenu.LoadEnviormentMenu(); JungleMenu.LoadJungleMenu(); DrawingsMenu.DrawingsMenus(); SummonersMenu.LoadSummonersMenu(); AutoLevelMenu.OnLoad(); Config.Item("useautolevel").SetValue(false); Config.AddToMainMenu(); // Activator Defensive.OnLoad(); Offensive.OnLoad(); Consumables.OnLoad(); // Summoners Ignite.OnLoad(); Heal.OnLoad(); Cleanse.OnLoad(); Barrier.OnLoad(); //Drawings //todo DtoP EnemyRanges.OnLoad(); AllyRanges.OnLoad(); Wards.OnLoad(); TrackerSpell.OnLoad(); //DtoT.OnLoad();s // DtoP.OnLoad(); //Jungle (yes smite contains everything in jungle) //todo Jungle timers Smite.OnLoad(); //Enviormenet //todo Ult Manager, Inhibs, Turn Around, Turrets AntiRengar.OnLoad(); Auto_Level_Manager.AutoLevel.OnLoad(); //UltManager.OnLoad(); //Inhibitors.OnLoad(); //TurnAround.OnLoad(); //Turrets.OnLoad(); }
public JsonResult LoadWard(int id) { var ward = db.Wards.Where(s => s.DistrictID == id).ToList(); List <Wards> listWards = new List <Wards>(); Wards tmp = null; foreach (var item in ward) { tmp = new Wards(); tmp.Id = item.Id; tmp.Name = item.Name; tmp.Type = item.Type; listWards.Add(tmp); } return(Json(new { data = listWards, status = true })); }
private static void Drawing_OnDraw(EventArgs args) { if (!menu.CheckBoxValue("enable")) { return; } foreach (var ward in Detectedwards) { Circle.Draw(Wards.color(ward), 125, ward.Position); var endtime = (int)(ward.EndTime - Game.Time); Extensions.text.TextValue = endtime.ToString(CultureInfo.InvariantCulture); Extensions.text.Position = ward.Position.WorldToScreen(); if (ward.EndTime > 0) { Extensions.text.Draw(); } } }
public override void LoadFromStore(VMStore modelStore) { try { ContactAddress = JsonConvert.DeserializeObject <ClientContactAddressDTO>(modelStore.Store); PersonId = ContactAddress.PersonId; Downloaded = ContactAddress.Downloaded; Telephone = ContactAddress.Phone; Landmark = ContactAddress.Landmark; ContactId = ContactAddress.ContactId; AddressId = ContactAddress.AddressId; SelectedCounty = Counties.FirstOrDefault(x => x.Id == 0); SelectedSubCounty = SubCounties.FirstOrDefault(x => x.Id == 0); SelectedWard = Wards.FirstOrDefault(x => x.Id == 0); if (ContactAddress.CountyId.HasValue && ContactAddress.CountyId.Value > 0) { SelectedCounty = Counties.FirstOrDefault(x => x.Id == ContactAddress.CountyId); GetSubCounties(); } if (ContactAddress.SubCountyId.HasValue && ContactAddress.SubCountyId.Value > 0) { SelectedSubCounty = SubCounties.FirstOrDefault(x => x.Id == ContactAddress.SubCountyId); GetWards(); } if (ContactAddress.WardId.HasValue && ContactAddress.WardId.Value > 0) { SelectedWard = Wards.FirstOrDefault(x => x.Id == ContactAddress.WardId); } } catch (Exception e) { Mvx.Error(e.Message); } }
private void updateBtn_Click(object sender, EventArgs e) { if (updateID == "") { return; } if (MessageBox.Show("YES or No?", "Are you sure you want to update this information? ", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes) { _ward = new Wards(updateID, nameTxt.Text, codeTxt.Text, capacityTxt.Text, costTxt.Text, depositTxt.Text, wingTxt.Text, periodTxt.Text, DateTime.Now.ToString("dd-MM-yyyy H:mm:ss"), Helper.orgID); DBConnect.Update(_ward, updateID); Global._wards.RemoveAll(x => x.Id == updateID); Global._wards.Add(_ward); // DBConnect.Execute(SQL); MessageBox.Show("Information updated"); saveBtn.Visible = true; updateBtn.Visible = false; updateID = ""; nameTxt.Text = ""; codeTxt.Text = ""; capacityTxt.Text = ""; LoadData(); } }
public bool Update(Wards wards, int old_wardId) { WardsDAC wardsComponent = new WardsDAC(); return(wardsComponent.UpdateWards(wards.WardCode, wards.WardDescription, wards.WardTypeId, wards.WardForId, wards.BedsNumber, wards.WardCapacity, wards.RoomsNumber, wards.WardPhone, wards.WardColor, wards.WardOrder, old_wardId)); }
public double CalcCorrectionFactor() { var totalPopulation = Wards.Sum(w => w.Population); return(totalPopulation / Convert.ToDouble(Scenario.NumberOfAgents)); }
public Parishioner(string _firstName, string _lastName, Wards _ward) { this.firstName = !string.IsNullOrEmpty(_firstName) ? _firstName : "FIRSTNAME"; this.lastName = !string.IsNullOrEmpty(_lastName) ? _lastName : "LASTNAME"; this.ward = _ward; }
public override async Task ExecuteAsync(CancellationToken token) { Target = this.TargetSelector.Active.GetTargets().FirstOrDefault(x => !x.IsInvulnerable()); var silenced = UnitExtensions.IsSilenced(this.Owner); var sliderValue = this.Config.UseBlinkPrediction.Item.GetValue <Slider>().Value; var isChanneling = UnitExtensions.IsChanneling(this.Owner); if (!silenced) { try { if ((this.BlinkDagger != null) && (this.BlinkDagger.Item.IsValid) && Target != null && Owner.Distance2D(Target) <= 1200 + sliderValue && !(Owner.Distance2D(Target) <= sliderValue) && this.BlinkDagger.Item.CanBeCasted() && this.Config.ItemToggler.Value.IsEnabled(this.BlinkDagger.Item.Name) && !isChanneling) { var l = (this.Owner.Distance2D(Target) - sliderValue) / sliderValue; var posA = this.Owner.Position; var posB = Target.Position; var x = (posA.X + (l * posB.X)) / (1 + l); var y = (posA.Y + (l * posB.Y)) / (1 + l); var position = new Vector3((int)x, (int)y, posA.Z); Log.Debug("Using BlinkDagger"); this.BlinkDagger.UseAbility(position); await Await.Delay(this.GetItemDelay(position), token); } if ((this.Euls != null) && this.Euls.Item.IsValid && Target != null && this.Owner.Distance2D(Target) <= this.Euls.CastRange && this.Euls.Item.CanBeCasted(Target) && this.Config.ItemToggler.Value.IsEnabled(this.Euls.Item.Name)) { Log.Debug($"Using Eul"); this.Euls.UseAbility(this.Target); await Await.Delay(this.GetItemDelay(Target), token); } if (Hex != null && Hex.IsValid && Hex.CanBeCasted(Target) && !isChanneling && this.Config.AbilityToggler.Value.IsEnabled(this.Hex.Name)) { Log.Debug($"Using Hex"); Hex.UseAbility(Target); await Await.Delay(GetAbilityDelay(this.Owner, Hex), token); } if (Ethershock != null && Ethershock.IsValid && Ethershock.CanBeCasted(Target) && !isChanneling && this.Config.AbilityToggler.Value.IsEnabled(this.Ethershock.Name)) { Log.Debug($"Using Ethershock!"); Ethershock.UseAbility(Target); await Await.Delay(GetAbilityDelay(this.Owner, Ethershock), token); } } catch (TaskCanceledException) { // ignore } catch (Exception e) { Log.Error($"{e}"); } } if (!silenced) { try { var invulTargetsToo = this.TargetSelector.Active.GetTargets().FirstOrDefault(); if (Wards != null && Wards.IsValid && Wards.CanBeCasted() && !isChanneling && invulTargetsToo != null && invulTargetsToo.IsValid && this.Config.AbilityToggler.Value.IsEnabled(this.Wards.Name)) { var delay = Wards.GetCastPoint(); var wardsCastRange = Wards.CastRange; var input = new PredictionInput(this.Owner, invulTargetsToo, delay, float.MaxValue, wardsCastRange, 30, PredictionSkillshotType.SkillshotCircle) { CollisionTypes = CollisionTypes.None }; output = Prediction.GetPrediction(input); if (output.HitChance >= HitChance.Medium) { Log.Debug($"Casting Wards"); this.Wards.UseAbility(output.CastPosition); if (this.Config.FailSwitch.Value.Equals(true) && (Target.IsRotating() && Target.MovementSpeed >= 300 || Ensage.SDK.Extensions.EntityExtensions.Distance2D(Target, output.CastPosition) >= 200)) { Log.Error($"stopping"); this.Owner.Stop(); await Await.Delay(100, token); } await Await.Delay(GetAbilityDelay(output.CastPosition, this.Wards), token); } } } catch (TaskCanceledException) { // ignored } catch (Exception e) { Log.Error($"{e}"); } } if (this.BloodThorn != null && this.BloodThorn.Item.IsValid && Target != null && !isChanneling && this.BloodThorn.Item.CanBeCasted(Target) && this.Config.ItemToggler.Value.IsEnabled(this.BloodThorn.Item.Name)) { Log.Debug("Using Bloodthorn"); this.BloodThorn.UseAbility(Target); await Await.Delay(this.GetItemDelay(Target), token); } if ((this.SheepStick != null) && (this.SheepStick.Item.IsValid) && Target != null && !isChanneling && this.SheepStick.Item.CanBeCasted(Target) && this.Config.ItemToggler.Value.IsEnabled("item_sheepstick")) { Log.Debug("Using Sheepstick"); this.SheepStick.UseAbility(Target); await Await.Delay(this.GetItemDelay(Target), token); } if (this.Dagon != null && this.Dagon.Item.IsValid && Target != null && !isChanneling && this.Dagon.Item.CanBeCasted(Target) && this.Config.ItemToggler.Value.IsEnabled(Dagon5.Item.Name)) { Log.Debug("Using Dagon"); this.Dagon.UseAbility(Target); await Await.Delay(this.GetItemDelay(Target), token); } if (this.Orchid != null && this.Orchid.Item.IsValid && Target != null && !isChanneling && this.Orchid.Item.CanBeCasted(Target) && this.Config.ItemToggler.Value.IsEnabled("item_orchid")) { Log.Debug("Using Orchid"); this.Orchid.UseAbility(Target); await Await.Delay(this.GetItemDelay(Target), token); } if (this.RodofAtos != null && this.RodofAtos.Item.IsValid && Target != null && !isChanneling && this.RodofAtos.Item.CanBeCasted(Target) && this.Config.ItemToggler.Value.IsEnabled("item_rod_of_atos")) { Log.Debug("Using RodofAtos"); this.RodofAtos.UseAbility(Target); await Await.Delay(this.GetItemDelay(Target), token); } if (this.VeilofDiscord != null && this.VeilofDiscord.Item.IsValid && Target != null && !isChanneling && this.VeilofDiscord.Item.CanBeCasted() && this.Config.ItemToggler.Value.IsEnabled("item_veil_of_discord")) { Log.Debug("Using VeilofDiscord"); this.VeilofDiscord.UseAbility(Target.Position); await Await.Delay(this.GetItemDelay(Target), token); } if (this.HurricanePike != null && this.HurricanePike.Item.IsValid && Target != null && !isChanneling && this.HurricanePike.Item.CanBeCasted() && this.Config.ItemToggler.Value.IsEnabled("item_hurricane_pike")) { Log.Debug("Using HurricanePike"); this.HurricanePike.UseAbility(Target); await Await.Delay(this.GetItemDelay(Target), token); } if (this.ShivasGuard != null && this.ShivasGuard.Item.IsValid && Target != null && !isChanneling && this.ShivasGuard.Item.CanBeCasted() && Owner.Distance2D(Target) <= 900 && this.Config.ItemToggler.Value.IsEnabled("item_shivas_guard")) { Log.Debug("Using Shiva's Guard"); this.ShivasGuard.UseAbility(); await Await.Delay((int)Game.Ping, token); } if (this.Mjollnir != null && this.Mjollnir.Item.IsValid && Target != null && !isChanneling && this.Mjollnir.Item.CanBeCasted() && this.Config.ItemToggler.Value.IsEnabled("item_mjollnir")) { Log.Debug("Using Mjollnir"); this.Mjollnir.UseAbility(Owner); await Await.Delay(this.GetItemDelay(Target), token); } try { if (Shackles != null && Shackles.IsValid && Shackles.CanBeCasted(Target) && !isChanneling && (Wards == null || !Wards.IsValid || !Wards.CanBeCasted() || !this.Config.AbilityToggler.Value.IsEnabled(this.Wards.Name)) && HexSync() && this.Config.AbilityToggler.Value.IsEnabled(this.Shackles.Name)) { Log.Debug($"Using Shackles!"); Shackles.UseAbility(Target); await Await.Delay(GetAbilityDelay(this.Target, Shackles) + 1000, token); } } catch (TaskCanceledException) { // ignore } catch (Exception e) { Log.Error(e); } /*if (Refresher != null && Refresher.Item.IsValid && Target != null && * !isChanneling && this.Refresher.Item.CanBeCasted() && !this.Wards.CanBeCasted() && !this.Shackles.CanBeCasted() && * this.Config.ItemToggler.Value.IsEnabled(Refresher.Item.Name)) * { * Log.Debug($"Using Refresher Orb"); * Refresher.UseAbility(); * await Await.Delay(100, token); * }*/ if (Target != null && Owner.IsValidOrbwalkingTarget(Target) && !isChanneling) { this.Context.Orbwalker.Active.OrbwalkTo(Target); Log.Debug($"Orbwalking"); } await Await.Delay(100, token); }
public void Run() { string log = String.Empty; ReplaceString replaceString = new ReplaceString(); DirectoryInfo dir = Directory.GetParent(Environment.CurrentDirectory).Parent.Parent; string dirPath = dir.FullName; string templateReport = System.IO.Path.Combine(dirPath, @"Json\Ward.json"); using (StreamReader r = new StreamReader(templateReport)) { string json = r.ReadToEnd(); List <Ward> items = JsonConvert.DeserializeObject <List <Ward> >(json); using (var context = new quickbeedev1Context()) { var translator = context.Translators.Where(x => x.DataKey == "VTP.DISTRICT").ToList(); foreach (var i in translator) { int? districtOriginId = Convert.ToInt32(i.OriginalValue); string districtJsId = i.TranslatedValue; //List Ward var wardJsList = items.Where(x => x.DISTRICT_ID == districtJsId).ToList(); var wardOriginalList = (from d in context.Wards.Where(x => x.DistrictId == districtOriginId) select new { Id = d.Id, Name = replaceString.Replace(d.Name, "WARD") }).ToList(); foreach (var itemW in wardJsList) { var wardOriginalObj = wardOriginalList.Where(x => x.Name == replaceString.Replace(itemW.WARDS_NAME, "WARD")).FirstOrDefault(); if (wardOriginalObj != null) { var translators = new Translators() { DataKey = "VTP.WARD", OriginalValue = Convert.ToString(wardOriginalObj.Id), TranslatedValue = Convert.ToString(itemW.WARDS_ID) }; var wardExists = context.Translators.Where(x => x.DataKey == translators.DataKey && x.TranslatedValue == translators.TranslatedValue); if (wardExists.Count() == 0) { context.Translators.Add(translators); context.SaveChanges(); log += wardOriginalObj.Name + "-" + itemW.WARDS_NAME + "\n"; } } else { var wardNew = new Wards() { Name = replaceString.ConverToUpper(itemW.WARDS_NAME), DistrictId = districtOriginId ?? 0 }; context.Wards.Add(wardNew); context.SaveChanges(); var translators = new Translators() { DataKey = "VTP.WARD", OriginalValue = Convert.ToString(wardNew.Id), TranslatedValue = Convert.ToString(itemW.WARDS_ID) }; context.Translators.Add(translators); context.SaveChanges(); log += itemW.WARDS_NAME + "\n"; } } } } } Console.WriteLine(log); }
public List <Wards> GetAll() { WardsDAC _wardsComponent = new WardsDAC(); IDataReader reader = _wardsComponent.GetAllWards().CreateDataReader(); List <Wards> _wardsList = new List <Wards>(); while (reader.Read()) { if (_wardsList == null) { _wardsList = new List <Wards>(); } Wards _wards = new Wards(); if (reader["WardId"] != DBNull.Value) { _wards.WardId = Convert.ToInt32(reader["WardId"]); } if (reader["WardCode"] != DBNull.Value) { _wards.WardCode = Convert.ToString(reader["WardCode"]); } if (reader["WardDescription"] != DBNull.Value) { _wards.WardDescription = Convert.ToString(reader["WardDescription"]); } if (reader["WardTypeId"] != DBNull.Value) { _wards.WardTypeId = Convert.ToInt32(reader["WardTypeId"]); } if (reader["WardForId"] != DBNull.Value) { _wards.WardForId = Convert.ToInt32(reader["WardForId"]); } if (reader["BedsNumber"] != DBNull.Value) { _wards.BedsNumber = Convert.ToInt32(reader["BedsNumber"]); } if (reader["WardCapacity"] != DBNull.Value) { _wards.WardCapacity = Convert.ToInt32(reader["WardCapacity"]); } if (reader["RoomsNumber"] != DBNull.Value) { _wards.RoomsNumber = Convert.ToInt32(reader["RoomsNumber"]); } if (reader["WardPhone"] != DBNull.Value) { _wards.WardPhone = Convert.ToString(reader["WardPhone"]); } if (reader["WardColor"] != DBNull.Value) { _wards.WardColor = Convert.ToString(reader["WardColor"]); } if (reader["WardOrder"] != DBNull.Value) { _wards.WardOrder = Convert.ToInt32(reader["WardOrder"]); } _wards.NewRecord = false; _wardsList.Add(_wards); } reader.Close(); return(_wardsList); }