public DisasterB GetDisasterByName(string name) { DisasterB disData = null; using (var NWEntities = new SaveWorldEntities()) { var dis = (from p in NWEntities.Disasters where p.disasterName == name select p).FirstOrDefault(); if (dis != null) { disData = new DisasterB() { DisasterId = dis.id, Name = dis.disasterName, Description = dis.description, Priority = dis.priority, Region = dis.region, Victims = dis.victims, CategoryId = (int)dis.categoryId, DisasterBankAccountId = (int)dis.accountId, } } ; } return(disData); }
public bool CreateDisaster(DisasterB newDisaster) { using (SaveWorldEntities dbEntities = new SaveWorldEntities()) { if (dbEntities.Disasters.Any(o => o.disasterName == newDisaster.Name)) { return(false); } disaster disaster = new disaster() { disasterName = newDisaster.Name, categoryId = newDisaster.CategoryId, description = newDisaster.Description, priority = newDisaster.Priority, region = newDisaster.Region, victims = newDisaster.Victims, accountId = newDisaster.DisasterBankAccountId, }; dbEntities.Disasters.Add(disaster); dbEntities.SaveChanges(); } return(true); }
public bool UpdateDisaster(DisasterB disaster) { var updated = true; using (var NWEntities = new SaveWorldEntities()) { var disasterId = disaster.DisasterId; var disasterDatabse = (from p in NWEntities.Disasters where p.id == disasterId select p).FirstOrDefault(); if (disasterDatabse == null) { throw new Exception("No disaster with ID " + disaster.DisasterId); } disasterDatabse.disasterName = disaster.Name; disasterDatabse.description = disaster.Description; disasterDatabse.priority = disaster.Priority; disasterDatabse.region = disaster.Region; disasterDatabse.victims = disaster.Victims; NWEntities.Disasters.Attach(disasterDatabse); NWEntities.Entry(disasterDatabse).State = System.Data.Entity.EntityState.Modified; var num = NWEntities.SaveChanges(); } return(updated); }
public List <DisasterB> GetAllDisasters() { List <DisasterB> list = new List <DisasterB>(); using (SaveWorldEntities NWEntities = new SaveWorldEntities()) { var allRows = NWEntities.Disasters.ToList(); for (int i = 0; i < allRows.Count; i++) { DisasterB dis = new DisasterB(); dis.Name = allRows[i].disasterName; dis.DisasterId = allRows[i].id; dis.Description = allRows[i].description; dis.CategoryId = (int)allRows[i].categoryId; dis.Region = allRows[i].region; dis.Victims = allRows[i].victims; dis.Priority = allRows[i].priority; dis.DisasterBankAccountId = (int)allRows[i].accountId; list.Add(dis); } } return(list); }
public bool CreateDisaster(DisasterB newDisaster) { return(disCtr.CreateDisaster(newDisaster)); }
public bool UpdateDisaster(DisasterB disaster) { return(disCtr.UpdateDisaster(disaster)); }