public CityVM EditCity(CityVM c) { DB.tblCity City = IMSDB.tblCities.Find(c.CityId); if (City != null) { City.CityName = c.CityName; City.StateId = c.State.StateId; //City.CityCode = c.CityCode; City.IsActive = c.IsActive; IMSDB.Entry(City).State = EntityState.Modified; IMSDB.SaveChanges(); } return(c); }
public CityVM AddCity(CityVM c) { DB.tblCity City = IMSDB.tblCities.Add( new DB.tblCity { //CityCode = c.CityCode, CityName = c.CityName, StateId = c.State.StateId, IsActive = c.IsActive }); IMSDB.SaveChanges(); c.CityId = City.CityId; return(c); }
public CityVM GetCityById(int CityId) { DB.tblCity City = IMSDB.tblCities.Where(p => p.CityId == CityId).FirstOrDefault(); if (City != null) { return(new CityVM() { CityId = City.CityId, CityName = City.CityName, //CityCode = City.CityCode, State = new StateVM { StateId = City.tblState.StateId, StateName = City.tblState.StateName, IsActive = City.tblState.IsActive }, IsActive = City.IsActive }); } return(null); }