Пример #1
0
        public IHttpActionResult Putproduct(int id, LocationVM location)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            if (id != location.Id)
            {
                return(BadRequest());
            }

            try
            {
                var task = repository.Update(location);
                task.Wait();
            }
            catch (DbUpdateConcurrencyException)
            {
                if (repository.GetLocation(id) == null)
                {
                    return(NotFound());
                }
                else
                {
                    throw;
                }
            }
            return(StatusCode(HttpStatusCode.NoContent));
        }
Пример #2
0
        public static List <LocationVM> GetLocation(string term)
        {
            SqlCommand cmd = new SqlCommand();

            cmd.Connection  = new SqlConnection(CommanFunctions.GetConnectionString);
            cmd.CommandText = "SP_QryGetLocation";
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@term", term);
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            DataSet        ds = new DataSet();

            da.Fill(ds);

            List <LocationVM> objList = new List <LocationVM>();

            if (ds != null && ds.Tables.Count > 0)
            {
                for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                {
                    LocationVM obj = new LocationVM();
                    obj.LocationID  = CommanFunctions.ParseInt(ds.Tables[0].Rows[i]["LocationID"].ToString());
                    obj.CityID      = CommanFunctions.ParseInt(ds.Tables[0].Rows[i]["CityID"].ToString());
                    obj.CountryID   = CommanFunctions.ParseInt(ds.Tables[0].Rows[i]["CountryID"].ToString());
                    obj.Location    = ds.Tables[0].Rows[i]["Location"].ToString();
                    obj.CityName    = ds.Tables[0].Rows[i]["City"].ToString();
                    obj.CountryName = ds.Tables[0].Rows[i]["CountryName"].ToString();
                    objList.Add(obj);
                }
            }
            return(objList);
        }
Пример #3
0
        public ActionResult DeleteLocation(long LocationID)
        {
            ActionResult oResponse      = null;
            LocationVM   removeLocation = new LocationVM();

            if (Session["UserName"] != null && (int)Session["UserLevel"] == 1)
            {
                try
                {
                    _LocationAccess.DeleteLocation(LocationID);
                }
                catch (Exception)
                {
                    removeLocation.ErrorMessage = "There was a problem deleting the record from the database, please try again later";
                }
                finally
                {
                    //error is kicked to user, return must be outside this scope.
                }

                oResponse = RedirectToAction("ViewLocations", "Location");
            }
            else
            {
                oResponse = RedirectToAction("Login", "User");
            }

            return(oResponse);
        }
        public void EditTest()
        {
            Location v = new Location();

            using (var context = new DataContext(_seed, DBTypeEnum.Memory))
            {
                v.Name = "bhVtNC";
                context.Set <Location>().Add(v);
                context.SaveChanges();
            }

            PartialViewResult rv = (PartialViewResult)_controller.Edit(v.ID.ToString());

            Assert.IsInstanceOfType(rv.Model, typeof(LocationVM));

            LocationVM vm = rv.Model as LocationVM;

            v    = new Location();
            v.ID = vm.Entity.ID;

            v.Name    = "GV9Ll";
            vm.Entity = v;
            vm.FC     = new Dictionary <string, object>();

            vm.FC.Add("Entity.Name", "");
            _controller.Edit(vm);

            using (var context = new DataContext(_seed, DBTypeEnum.Memory))
            {
                var data = context.Set <Location>().FirstOrDefault();

                Assert.AreEqual(data.Name, "GV9Ll");
            }
        }
        public IHttpActionResult PostLocation(LocationVM location)
        {
            AuthenticationHeaderValue authenticationHeaderValue = Request.Headers.Authorization;
            var    userNamePasswordString = Encoding.UTF8.GetString(Convert.FromBase64String(authenticationHeaderValue.Parameter));
            string usrename = userNamePasswordString.Split(':')[0];
            string password = userNamePasswordString.Split(':')[1];

            int userId = GetUserId(usrename);

            var loc = db.Location.Where(x => x.Name == location.Name && x.UserId == userId).FirstOrDefault();

            if (loc != null)
            {
                return(Ok());
            }

            loc             = new Location();
            loc.Name        = location.Name;
            loc.Long        = location.Long;
            loc.Lat         = location.Lat;
            loc.CreatedDate = DateTime.Now;
            loc.UserId      = userId;

            db.Location.Add(loc);

            db.SaveChanges();


            return(CreatedAtRoute("DefaultApi", new { controller = "locations", id = loc.Id }, loc));
        }
        public ActionResult Edit(int id)
        {
            LocationVM v = new LocationVM();

            ViewBag.country = db.CountryMasters.ToList();
            var data = (from c in db.LocationMasters where c.LocationID == id select c).FirstOrDefault();

            int countryid = (from c in db.CityMasters where c.CityID == data.CityID select c.CountryID).FirstOrDefault().Value;

            ViewBag.city = (from c in db.CityMasters where c.CountryID == countryid select c).ToList();

            if (data == null)
            {
                return(HttpNotFound());
            }
            else
            {
                v.LocationID = data.LocationID;
                v.Location   = data.Location;
                v.CityID     = data.CityID.Value;
                v.CountryID  = countryid;
            }

            return(View(v));
        }
        public void DeleteTest()
        {
            Location v = new Location();

            using (var context = new DataContext(_seed, DBTypeEnum.Memory))
            {
                v.Name = "bhVtNC";
                context.Set <Location>().Add(v);
                context.SaveChanges();
            }

            PartialViewResult rv = (PartialViewResult)_controller.Delete(v.ID.ToString());

            Assert.IsInstanceOfType(rv.Model, typeof(LocationVM));

            LocationVM vm = rv.Model as LocationVM;

            v         = new Location();
            v.ID      = vm.Entity.ID;
            vm.Entity = v;
            _controller.Delete(v.ID.ToString(), null);

            using (var context = new DataContext(_seed, DBTypeEnum.Memory))
            {
                Assert.AreEqual(context.Set <Location>().Count(), 0);
            }
        }
Пример #8
0
 public void Update(int id, LocationVM locationVM)
 {
     this.Id            = locationVM.Id;
     this.Name_Location = locationVM.Name_Location;
     this.Floor         = locationVM.Floor;
     this.UpdateDate    = DateTimeOffset.Now.ToLocalTime();
 }
        public ActionResult Create(LocationVM v)
        {
            if (ModelState.IsValid)
            {
                LocationMaster ob = new LocationMaster();


                int max = (from c in db.LocationMasters orderby c.LocationID descending select c.LocationID).FirstOrDefault();

                if (max == null)
                {
                    ob.LocationID = 1;
                    ob.Location   = v.Location;
                    ob.CityID     = v.CityID;
                }
                else
                {
                    ob.LocationID = max + 1;
                    ob.Location   = v.Location;
                    ob.CityID     = v.CityID;
                }

                db.LocationMasters.Add(ob);
                db.SaveChanges();
                TempData["SuccessMsg"] = "You have successfully added Location.";
                return(RedirectToAction("Index"));
            }


            return(View(v));
        }
Пример #10
0
        private location ParseModel(LocationVM vm)
        {
            var locModel = new location();

            locModel.id            = vm.Id;
            locModel.location_name = vm.LocationName;
            return(locModel);
        }
Пример #11
0
        public ActionResult UpdateLocation(long LocationID)
        {
            LocationVM      updateVM = new LocationVM();
            ILocationInfoDO location = _LocationAccess.ViewLocationByID(LocationID);

            updateVM.Location = LocationMap.MapDOtoPO(location);

            return(View(updateVM));
        }
Пример #12
0
        public void MixedCaseFilter()
        {
            var vm = new LocationVM();

            vm.Filter("LoNDon");

            Assert.IsTrue(vm.Locations != null);
            Assert.IsTrue(vm.Locations.ContainsKey("London"));
        }
Пример #13
0
        public void AllLowerFilter()
        {
            var vm = new LocationVM();

            vm.Filter("london");

            Assert.IsTrue(vm.Locations != null);
            Assert.IsTrue(vm.Locations.ContainsKey("London"));
        }
Пример #14
0
        public void EmptryFilter()
        {
            var vm = new LocationVM();

            vm.Filter("");

            Assert.IsTrue(vm.Locations != null);
            Assert.IsTrue(vm.Locations.Count > 0);
        }
Пример #15
0
        public ActionResult Index()
        {
            var model = new LocationVM();

            model.Locations    = _locationService.GetLocations();
            model.Content      = _contentService.GetByAlias("rental-companies");
            model.Destinations = _locationService.GetAllDestination();

            return(View(model));
        }
Пример #16
0
        // PUT: api/Locations/5
        public HttpResponseMessage UpdateLocation(int id, LocationVM locationVM)
        {
            var message = Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Bad Request");
            var result  = iLocationService.Update(id, locationVM);

            if (result)
            {
                message = Request.CreateResponse(HttpStatusCode.OK);
            }
            return(message);
        }
Пример #17
0
        // POST: api/Locations
        public HttpResponseMessage InsertLocation(LocationVM locationVM)
        {
            var message = Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Bad Request");
            var result  = iLocationService.Insert(locationVM);

            if (result)
            {
                message = Request.CreateResponse(HttpStatusCode.Created);
            }
            return(message);
        }
 public bool Update(int id, LocationVM locationVM)
 {
     if (string.IsNullOrWhiteSpace(locationVM.Id.ToString()))
     {
         return(status);
     }
     else
     {
         return(iLocationRepository.Update(id, locationVM));
     }
 }
Пример #19
0
        public IHttpActionResult PostProduct(LocationVM location)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }
            var task = repository.Add(location);

            task.Wait();

            return(CreatedAtRoute("DefaultApi", new { id = location.Id }, location));
        }
Пример #20
0
        public async Task <ActionResult> Create(LocationVM location)
        {
            if (ModelState.IsValid)
            {
                var loc = location.ToLocation();
                db.Locations.Add(loc);
                await db.SaveChangesAsync();

                return(RedirectToAction("Index"));
            }

            return(View(location));
        }
        public IActionResult SelectLoc()
        {
            LocationVM objItemView = new LocationVM();

            objItemView.LocationList = (from objCat in _context.Locations
                                        select new SelectListItem()
            {
                Text = objCat.locationName,
                Value = objCat.id.ToString(),
                Selected = true
            });
            return(View(objItemView));
        }
 public bool Insert(LocationVM locationVM)
 {
     if (string.IsNullOrWhiteSpace(Convert.ToString(locationVM.Name_Location)))
     {
         return(status);
     }
     else if (string.IsNullOrWhiteSpace(Convert.ToString(locationVM.Floor)))
     {
         return(status);
     }
     else
     {
         return(iLocationRepository.Insert(locationVM));
     }
 }
        public ActionResult Index()
        {
            List <LocationVM> lst = new List <LocationVM>();
            var data = db.LocationMasters.ToList();

            foreach (var item in data)
            {
                LocationVM obj = new LocationVM();
                obj.LocationID = item.LocationID;
                obj.Location   = item.Location;
                obj.CityID     = item.CityID.Value;
                lst.Add(obj);
            }
            return(View(data));
        }
Пример #24
0
        public ActionResult AddLocation(LocationVM viewModel)
        {
            ActionResult oResponse = null;

            if (Session["UserName"] != null && (int)Session["UserLevel"] == 1)
            {
                if (ModelState.IsValid)
                {
                    try
                    {
                        ILocationInfoDO locationform = LocationMap.MapPOtoDO(viewModel.Location);
                        _LocationAccess.InsertLocation(locationform);
                    }
                    catch (Exception e)
                    {
                        if (e.Message.Contains("duplicate"))
                        {
                            viewModel.ErrorMessage = String.Format("There is already a {0} in the database.", viewModel.Location.LocationName);
                        }
                        else
                        {
                            viewModel.ErrorMessage = "We apologize but we were unable to handle your request at this time.";
                        }
                    }
                    finally
                    {
                        //nothing to do here
                    }
                    if (viewModel.ErrorMessage == null)
                    {
                        oResponse = RedirectToAction("ViewLocations", "Location");
                    }
                    else
                    {
                        oResponse = View(viewModel);
                    }
                }
                else
                {
                    oResponse = View(viewModel);
                }
            }
            else
            {
                oResponse = RedirectToAction("Login", "User");
            }
            return(oResponse);
        }
        public bool Update(int id, LocationVM LocationVM)
        {
            var get = Get(id);

            if (get != null)
            {
                get.Update(id, LocationVM);
                myContext.Entry(get).State = EntityState.Modified;
                myContext.SaveChanges();
                return(true);
            }
            else
            {
                return(false);
            }
        }
Пример #26
0
        public ActionResult AddLocation()
        {
            ActionResult oResponse = null;

            if (Session["Username"] == null || (int)Session["UserLevel"] != 1)
            {
                oResponse = RedirectToAction("Login", "User");
                return(oResponse);
            }
            else
            {
                LocationVM newVM = new LocationVM();
                oResponse = View(newVM);
                return(oResponse);
            }
        }
    public List <LocationVM> GetAllATMS()
    {
        List <LocationVM> locations = new List <LocationVM>();

        var atms = context.ATMs;

        foreach (var a in atms)
        {
            LocationVM atm = new LocationVM {
                Lat  = a.Lat,
                Long = a.Long
            };
            locations.Add(atm);
        }
        return(locations);
    }
Пример #28
0
        public ActionResult EditLocation(int id)
        {
            ILocationRepo locorepo = LocationRepoFactory.Create();
            var           location = locorepo.GetLocationById(id);
            var           model    = new LocationVM
            {
                LocationID          = location.LocationID,
                LocationName        = location.LocationName,
                LocationAddress     = location.LocationAddress,
                LocationDescription = location.LocationDescription,
                LatitudeCoordinate  = location.LatitudeCoordinate,
                LongitudeCoordinate = location.LongitudeCoordinate,
            };

            locorepo.EditLocation(location);
            return(View(model));
        }
        public bool Insert(LocationVM LocationVM)
        {
            var push = new Location(LocationVM);

            myContext.Locations.Add(push);
            var result = myContext.SaveChanges();

            if (result > 0)
            {
                status = true;
            }
            else
            {
                return(status);
            }
            return(status);
        }
Пример #30
0
        public List <LocationVM> GetLocations()
        {
            var locationList = (from l in db.Location
                                select l).ToList();

            List <LocationVM> locList = new List <LocationVM>();

            foreach (var loc in locationList)
            {
                LocationVM location = new LocationVM();
                location.LocationId  = loc.LocationId;
                location.LocatioName = loc.LocationName;
                location.Type        = loc.Type;
                locList.Add(location);
            }

            return(locList);
        }
Пример #31
0
 public bool ImportLocation(LocationVM location)
 {
     throw new NotImplementedException();
 }
Пример #32
0
 public bool SaveLocation(LocationVM newTag)
 {
     throw new NotImplementedException();
 }