Beispiel #1
0
 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);
 }
Beispiel #2
0
 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);
 }
Beispiel #3
0
        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);
        }