public IEnumerable <Cities> Get()

        {
            using (var db = new appointmentxContext())
            {
                return(db.Cities.ToList());
            }
        }
        public IEnumerable <Area> Get(int id)

        {
            using (var db = new appointmentxContext())
            {
                return(db.Area.Where(x => x.AreaId == id & x.IsDeleted != true).ToList());
            }
        }
        public IEnumerable <Area> Get()

        {
            var a = new MAppTable(_context);

            //a.BringData("119850540652");
            using (var db = new appointmentxContext())
            {
                return(db.Area.ToList());
            }
        }
        public int Post([FromBody] Cities c)
        {
            using (var db = new appointmentxContext())
            {
                var cntxt = db.Cities.Where(x => x.CityName == c.CityName).ToList();
                if (cntxt.Count == 1)
                {
                    return(0);
                }
                else

                {
                    Cities cities = new Cities();
                    cities.CityName  = c.CityName;
                    cities.CreatedBy = "saleh add cities";
                    db.Cities.Add(cities);
                    db.SaveChanges();
                    return(1);
                }
            }
        }
        public int Post([FromBody] Area a)
        {
            using (var db = new appointmentxContext())
            {
                var cntxt = db.Area.Where(x => x.AreaName == a.AreaName && x.CityId == a.CityId).ToList();
                if (cntxt.Count == 1)
                {
                    return(0);
                }
                else

                {
                    Area area = new Area();
                    area.AreaName  = a.AreaName;
                    area.CityId    = a.CityId;
                    area.CreatedBy = "saleh add area";
                    db.Area.Add(area);
                    db.SaveChanges();
                    return(1);
                }
            }
        }
Exemple #6
0
 public CompanyController(appointmentxContext context)
 {
     _context = context;
 }
 public AreaController(appointmentxContext context)
 {
     _context = context;
 }
Exemple #8
0
 public MAppTable(appointmentxContext context)
 {
     _context = context;
 }
Exemple #9
0
 public AppTableController(appointmentxContext context)
 {
     _context = context;
 }