public void BuildLocationShouldSucceed()
{
//Arrange
var locationsModel = new LocationsModel
{
Value = new List <LocationLocalModel>
{
new LocationLocalModel {
Warehouse = "Warehouse B",
Gate = "DB",
Row = "3",
Position = "001",
Site = "LB1227"
}
}
};
//Act
var service = new LocationBuildService();
var result = service.BuildLocation(locationsModel);
//Assert
result.Should().NotBeNull();
result.Should().BeOfType <LocationSiteModel>();
}
public async Task <IActionResult> Search(string q)
{
LocationsModel locationsInfo = new LocationsModel();
string Baseurl = "https://localhost:44326/";
var loactionsResponse = "";
var zomatoApiKey = _config["ZomatoApiKey"];
var latitude = HttpContext.Session.GetString("latitude");
var longitude = HttpContext.Session.GetString("longitude");
if (latitude != null && longitude != null)
{
using (var client = new HttpClient())
{
//Passing service base url
client.BaseAddress = new Uri(Baseurl);
client.DefaultRequestHeaders.Clear();
//Define request data format
client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
client.DefaultRequestHeaders.Add("user-key", zomatoApiKey);
//Sending request to find web api REST service resource using HttpClient
HttpResponseMessage Res = await client.GetAsync("https://developers.zomato.com/api/v2.1/locations?q=" + q + "&lat=" + latitude + "&lon=" + longitude);
//Checking the response is successful or not which is sent using HttpClient
if (Res.IsSuccessStatusCode)
{
//Storing the response details recieved from web api
loactionsResponse = Res.Content.ReadAsStringAsync().Result;
//Deserializing the response recieved from web api and storing into the Model
locationsInfo = JsonConvert.DeserializeObject <LocationsModel>(loactionsResponse);
}
}
}
return(View(locationsInfo));
}
public async Task <IActionResult> Edit(int id, [Bind("LocationId,LocationName,LocationTitle,LocationDescription,LocationMap,ImageFile,LocationRating")] LocationsModel locationsModel)
{
if (id != locationsModel.LocationId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(locationsModel);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!LocationsModelExists(locationsModel.LocationId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(locationsModel));
}
public NoticeModel(
VersionConfiguration versionConfig,
IServiceStateProvider serviceStateProvider,
LocationsModel locationsModel,
ServiceModel serviceModel
)
{
this.IsRelevant = versionConfig.ExistingVersionInstalled;
this.LocationsModel = locationsModel;
this.ServiceModel = serviceModel;
this.Header = "Notice";
this.ExistingVersion = versionConfig.UpgradeFromVersion;
this.CurrentVersion = versionConfig.CurrentVersion;
this.ReadMoreOnUpgrades = ReactiveCommand.Create();
this.ReadMoreOnXPackOpening = ReactiveCommand.Create();
this._serviceStateProvider = serviceStateProvider;
this.Refresh();
if (!string.IsNullOrWhiteSpace(this.CurrentVersion?.Prerelease))
{
if (versionConfig.ExistingVersionInstalled)
{
this.UpgradeTextHeader = TextResources.NoticeModel_ToPrerelease_Header;
this.UpgradeText = TextResources.NoticeModel_ToPrerelease;
}
else
{
this.UpgradeTextHeader = TextResources.NoticeModel_Prerelease_Header;
this.UpgradeText = TextResources.NoticeModel_Prerelease;
}
this.IsRelevant = true; //show prerelease notice always
}
else if (!string.IsNullOrWhiteSpace(this.ExistingVersion?.Prerelease))
{
this.UpgradeTextHeader = TextResources.NoticeModel_FromPrerelease_Header;
this.UpgradeText = TextResources.NoticeModel_FromPrerelease;
this.IsRelevant = true; //show prerelease notice always
}
else
{
var v = Enum.GetName(typeof(VersionChange), versionConfig.VersionChange);
var d = Enum.GetName(typeof(InstallationDirection), versionConfig.InstallationDirection);
var prefix = nameof(NoticeModel) + "_" + v + d;
this.UpgradeTextHeader = TextResources.ResourceManager.GetString(prefix + "_Header");
this.UpgradeText = TextResources.ResourceManager.GetString(prefix);
}
if (!string.IsNullOrWhiteSpace(this.UpgradeTextHeader))
{
this.UpgradeTextHeader = string.Format(this.UpgradeTextHeader, versionConfig.UpgradeFromVersion, versionConfig.CurrentVersion);
}
this.ShowOpeningXPackBanner = this.ExistingVersion < XPackModel.XPackInstalledByDefaultVersion;
this.ShowUpgradeDocumentationLink = versionConfig.VersionChange == VersionChange.Major || versionConfig.VersionChange == VersionChange.Minor;
this.ExistingVersionInstalled = versionConfig.ExistingVersionInstalled;
}
public List <LocationsModel> GetAll()
{
//SQL command for selecting all from customers table
string sqlQuery = "SELECT * FROM Locations";
//Empty list of customersModel to add and return
List <LocationsModel> locations = new List <LocationsModel>();
//Using SqlConnection to establish connection to database
//using SqlCommand passing in the SqlConnection and the sqlQuery
using (SqlConnection con = new SqlConnection(_connectionString))
using (SqlCommand cmd = new SqlCommand(sqlQuery, con))
{
//open the connection
con.Open();
//SqlDataReader is used because we are reading data from the database
using (SqlDataReader reader = cmd.ExecuteReader())
{
//while there are records in the database
while (reader.Read())
{
//store each value into the properties of customersViewModel
LocationsModel temp = new LocationsModel()
{
locationID = Convert.ToInt64(reader["locationID"]),
locationName = reader["locationName"].ToString(),
locationPhone = Convert.ToInt64(reader["locationPhone"].ToString()),
locationCity = reader["locationCity"].ToString(),
locationState = reader["locationState"].ToString(),
locationDistrict = reader["locationDistrict"].ToString()
};
//Add the customers object to the List of customers
locations.Add(temp);
Console.WriteLine(" +================================================================+");
Console.WriteLine(" +----------------------------------------------------------------+");
Console.WriteLine(" LOCATION ID " + " | " + temp.locationID);
Console.WriteLine(" LOCATION NAME " + " | " + temp.locationName);
Console.WriteLine(" LOCATION PHONE" + " | " + temp.locationPhone);
Console.WriteLine(" LOCATION CITY " + " | " + temp.locationCity);
Console.WriteLine(" LOCATION STATE" + " | " + temp.locationState);
Console.WriteLine(" LOCATION DISTRICT " + " | " + temp.locationDistrict);
Console.WriteLine(" +----------------------------------------------------------------+");
}
}
}
return(locations);
}
public int Edit(int id, LocationsModel ObjLocationsModel)
{
try
{
if (id > 0)
{
if (ObjLocationsModel != null)
{
Location ObjLocations = DBContext.Locations.Where(a => a.Location_ID == id).FirstOrDefault();
if (ObjLocations != null)
{
//LocationsModel Edit Properties mapping here.
//ObjLocations.Profile_Name = ObjLocationsModel.Profile_Name;
//ObjLocations.Password = ObjLocationsModel.Password;
//ObjLocations.First_Name = ObjLocationsModel.First_Name;
//ObjLocations.Middle_Name = ObjLocationsModel.Middle_Name;
//ObjLocations.Last_Name = ObjLocationsModel.Last_Name;
//ObjLocations.Email_Address = ObjLocationsModel.Email_Address;
//ObjLocations.Contact_Number = ObjLocationsModel.Contact_Number;
//ObjLocations.Cell_Number = ObjLocationsModel.Cell_Number;
//ObjLocations.Location_ID = ObjLocationsModel.Location_ID;
//ObjLocations.PickUp_Address = ObjLocationsModel.PickUp_Address;
//ObjLocations.Drop_Address = ObjLocationsModel.Drop_Address;
//ObjLocations.QR_Code = ObjLocationsModel.QR_Code;
//ObjLocations.Rating = ObjLocationsModel.Rating;
//ObjLocations.Created_DateTime = ObjLocationsModel.Created_DateTime;
//ObjLocations.Created_By = ObjLocationsModel.Created_By;
//ObjLocations.Modified_DateTime = ObjLocationsModel.Modified_DateTime;
//ObjLocations.Modified_By = ObjLocationsModel.Modified_By;
//ObjLocations.Deleted = ObjLocationsModel.Deleted;
DBContext.SubmitChanges();
return(ObjLocations.Location_ID);
}
else
{
return(WebApiResponse.NoRecordFound);
}
}
else
{
return(WebApiResponse.InputObjectIsNull);
}
}
else
{
return(WebApiResponse.InputIdInvalid);
}
}
catch (Exception ex)
{
throw ex;
}
}
public LocationSiteModel BuildLocation(LocationsModel locationsModel)
{
var locations = locationsModel.Value;
var warehouses = locations.GroupBy(x => x.Warehouse)
.Select(loc => new { Name = loc.Key, Items = loc.ToList() });
var location = new LocationSiteModel();
location.Warehouses = new List <WarehouseModel>();
foreach (var warehouse in warehouses)
{
var warehouseLocal = new WarehouseModel();
warehouseLocal.Name = warehouse.Name;
warehouseLocal.Gates = new List <GateModel>();
var gates = warehouse.Items.GroupBy(x => x.Gate)
.Select(g => new { Name = g.Key, Items = g.ToList() });
foreach (var gate in gates)
{
var gateLocal = new GateModel {
Name = gate.Name
};
gateLocal.Rows = new List <RowModel>();
var rows = gate.Items.GroupBy(x => x.Row)
.Select(r => new { Name = r.Key, Items = r.ToList() });
foreach (var row in rows)
{
var rowLocal = new RowModel
{
Name = row.Name
};
var positions = row.Items.GroupBy(x => x.Position)
.Select(p => new PositionModel {
Name = p.Key
});
rowLocal.Positions = new List <PositionModel>(positions);
gateLocal.Rows.Add(rowLocal);
}
warehouseLocal.Gates.Add(gateLocal);
}
location.Warehouses.Add(warehouseLocal);
}
return(location);
}
public NoticeModel(
VersionConfiguration versionConfig,
IServiceStateProvider serviceStateProvider,
LocationsModel locationsModel,
ServiceModel serviceModel
)
{
this.IsRelevant = versionConfig.ExistingVersionInstalled;
this.LocationsModel = locationsModel;
this.ServiceModel = serviceModel;
this.Header = "Notice";
this.ExistingVersion = versionConfig.ExistingVersion;
this.CurrentVersion = versionConfig.CurrentVersion;
this.ReadMoreOnUpgrades = ReactiveCommand.Create();
var e = versionConfig.ExistingVersion;
var c = versionConfig.CurrentVersion;
if (!string.IsNullOrWhiteSpace(c?.Prerelease))
{
this.UpgradeTextHeader = TextResources.NoticeModel_ToPrerelease_Header;
this.UpgradeText = TextResources.NoticeModel_ToPrerelease;
this.IsRelevant = true; //show prerelease notice always
}
else if (!string.IsNullOrWhiteSpace(e?.Prerelease))
{
this.UpgradeTextHeader = TextResources.NoticeModel_FromPrerelease_Header;
this.UpgradeText = TextResources.NoticeModel_FromPrerelease;
this.IsRelevant = true; //show prerelease notice always
}
else
{
var v = Enum.GetName(typeof(VersionChange), versionConfig.VersionChange);
var d = Enum.GetName(typeof(InstallationDirection), versionConfig.InstallationDirection);
var prefix = nameof(NoticeModel) + "_" + v + d;
this.UpgradeTextHeader = TextResources.ResourceManager.GetString(prefix + "_Header");
this.UpgradeText = TextResources.ResourceManager.GetString(prefix);
}
// TODO: We should show the upgrade notice, even for a patch upgrade.
if (this.IsRelevant &&
versionConfig.VersionChange == VersionChange.Patch &&
versionConfig.InstallationDirection == InstallationDirection.Up)
{
this.IsRelevant = false;
}
this.ExistingVersionInstalled = versionConfig.ExistingVersionInstalled;
this.InstalledAsService = serviceStateProvider.SeesService;
this.Refresh();
}
public ActionResult Locations(int?tagId, string tag)
{
IPublishedContent recommendationRespository = Helper.TypedContentAtRoot().FirstOrDefault()
.FirstChild(x => x.DocumentTypeAlias == Constants.NodeAlias.RECOMMENDATIONS_REPOSITORY);
LocationsModel model = new LocationsModel(
CurrentPage,
recommendationRespository,
Site.IsEnglish,
tagId,
tag,
Services.ContentService);
return(CurrentTemplate(model));
}
public ActionResult Edit(int id, LocationsModel ObjInputLocationsModel)
{
//Customized try catch block by Imran Khan. CodeSnippet
try
{
string JsonString = string.Empty;
string ApiURL = OTS.GlobalSettings.WebAPIURL + this.GetType().Name.Replace("Controller", string.Empty) + "/" + System.Reflection.MethodBase.GetCurrentMethod().Name + "/" + id;
int UpdatedLocationsId = 0;
UpdatedLocationsId = (int)iWebServiceConsumer.ConsumeJsonWebService(ApiURL, ObjInputLocationsModel, UpdatedLocationsId, OTS.GlobalSettings.WebAPITimeout, out JsonString);
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
ViewBag.Error = ex.ToString();
return(View("Error"));
}
}
public async Task <LocationsModel> GetLocations()
{
var locations = (await _unitOfWork.LocationRepository.All()).ToList();
var locationsModel = new LocationsModel
{
LocationModels = new List <LocationModel>()
};
foreach (var location in locations)
{
locationsModel.LocationModels.Add(new LocationModel
{
LocationId = location.Id,
LocationName = location.Name
});
}
return(locationsModel);
}
public MainViewModel()
{
_core = new CoreLib();
_windowService = new WindowService();
//LocationsModel = new LocationsModel(_core);
LocationsModel = LocationsModel.Load(_core);
Options = new Option(_core);
_ignoreStorage = IgnoreStorage.Load();
_configuration = TinyIoCContainer.Current.Resolve <IConfigurationModel>();
_configuration.PropertyChanged += OnConfigurationPropertyChanged;
UndoRedoEngine undoRedoEngine = new UndoRedoEngine(_configuration);
_undoRedoEngine = undoRedoEngine;
_undoRedoEngine.PropertyChanged += OnUndoRedoEnginePropertyChanged;
TinyIoCContainer.Current.Register <IUndoRedoEngine, UndoRedoEngine>(undoRedoEngine);
ThumbnailProvider.Instance.PropertyChanged += OnThumbnailProviderPropertyChanged;
}
public int Delete(int id, LocationsModel ObjInputLocationsModel)
{
try
{
//Just keep ObjInputLocationsModel as parameter for Deleted Log.
Location ObjLocations = DBContext.Locations.Where(a => a.Location_ID == id).FirstOrDefault();
if (ObjLocations != null)
{
DBContext.Locations.DeleteOnSubmit(ObjLocations);
DBContext.SubmitChanges();
return(ObjLocations.Location_ID);
}
else
{
return(0);
}
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <IActionResult> Create([Bind("LocationId,LocationName,LocationTitle,LocationDescription,LocationMap,ImageFile,LocationRating")] LocationsModel locationsModel)
{
if (ModelState.IsValid)
{
//Save image to wwwroot/image
string wwwRootPath = iweb.WebRootPath;
string fileName = Path.GetFileNameWithoutExtension(locationsModel.ImageFile.FileName);
string extension = Path.GetExtension(locationsModel.ImageFile.FileName);
locationsModel.ImageName = fileName = fileName + DateTime.Now.ToString("yymmssfff") + extension;
string path = Path.Combine(wwwRootPath + "/Image/", fileName);
using (var fileStream = new FileStream(path, FileMode.Create))
{
await locationsModel.ImageFile.CopyToAsync(fileStream);
}
//Insert record
_context.Add(locationsModel);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(locationsModel));
}
public async Task <Result> Handle(ListLocationQuery request, CancellationToken cancellationToken)
{
Result result;
try
{
int?skip = request.Skip.ToNullableInt();
int?top = request.Top.ToNullableInt();
var locationDomains = await _locationReadRepository.ListAsync(request.Filter, skip, top);
var locationModels = _mapper.Map <IEnumerable <LocationModel> >(locationDomains);
var count = locationModels.Count();
var locationModel = new LocationsModel {
Value = locationModels, Count = count, NextLink = null
};
result = Result.Ok(locationModel);
}
catch (FilterODataException)
{
result = Result.Fail(new System.Collections.Generic.List <Failure>()
{
new HandlerFault()
{
Code = HandlerFaultCode.InvalidQueryFilter.Name,
Message = HandlerFailures.InvalidQueryFilter,
Target = "$filter"
}
}
);
}
catch
{
result = Result.Fail(CustomFailures.ListLocationFailure);
}
return(result);
}
// GET: /Address/Locations/
public async Task <IActionResult> Locations([FromBody] Options options)
{
IQueryable <Address> query;
long count;
if (string.IsNullOrWhiteSpace(options.SearchBy))
{
query = await context.Addresses.GetAsync();
count = await context.Addresses.CountAsync();
}
else
{
var search = SearchManager.GenerateWhere <Address>(options.SearchBy);
query = await context.Addresses.GetAsync(search);
count = await context.Addresses.CountAsync(search);
}
if (!string.IsNullOrEmpty(options.SortDirection))
{
query = query.OrderByField(options.SortBy, options.SortDirection == "asc");
}
query = query.Skip(options.PageIndex * options.PageSize).Take(options.PageSize);
var model = new LocationsModel(count, query.Select(adr => new AddressTableModel
{
Id = adr.Id,
Country = adr.Country,
Region = adr.Region,
City = adr.City,
Street = adr.Street,
Postal = adr.Postal
}).ToList());
return(model.ToJsonResult());
}
public LocationsFilter(LocationsModel model)
: base(new TreeModelAdapter( model ),null)
{
LocationsModel = model;
}
private void ApplyLocationsModel(ElasticsearchYamlSettings settings, LocationsModel locations)
{
this.Session.SendProgress(1000, "updating elasticsearch.yml with values from locations model");
settings.LogsPath = locations.LogsDirectory;
settings.DataPath = locations.DataDirectory;
}
public PathViewModel(Model.LocationsModel LocationsModel)
{
// TODO: Complete member initialization
this._locationsModel = LocationsModel;
}
public LocationsModel GetInventoryByLocationID()
{
LocationsModel location = new LocationsModel();
ProductsModel inventory = new ProductsModel();
Console.WriteLine(" +----------------------------------------------------------------+");
Console.WriteLine(" Enter your Location ID Number ");
Console.WriteLine(" +----------------------------------------------------------------+");
long productID = Convert.ToInt64(Console.ReadLine());
Console.WriteLine(" +----------------------------------------------------------------+");
Console.WriteLine(" Enter your Product ID Number ");
Console.WriteLine(" +----------------------------------------------------------------+");
long locationID = Convert.ToInt64(Console.ReadLine());
string sqlQuerys = "Select * from locations where locationID=@ID";
string sqlQuery = "SELECT * FROM Products INNER JOIN Locations ON Locations.locationID = Products.productLocationID" + "WHERE locationID=@locationID" + "AND productID=@productID";
//Using SqlConnection to establish connection to database
//using SqlCommand passing in the SqlConnection and the sqlQuery
using (SqlConnection con = new SqlConnection(_connectionString))
using (SqlCommand cmd = new SqlCommand(sqlQuery, con))
{
con.Open();
cmd.Parameters.Add("@locationID", SqlDbType.Int).Value = locationID;
cmd.Parameters.Add("@productID", SqlDbType.Int).Value = productID;
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
location.locationID = Convert.ToInt32(reader["locationID"]);
location.locationName = reader["locationName"].ToString();
location.locationPhone = Convert.ToInt32(reader["locationID"]);
location.locationCity = reader["locationName"].ToString();
location.locationState = reader["locationName"].ToString();;
location.locationDistrict = reader["locationDistrict"].ToString();
inventory.productID = Convert.ToInt32(reader["productID"]);
inventory.productQuantity = Convert.ToInt32(reader["productQuantity"]);
}
{
Console.WriteLine();
Console.WriteLine(" +================================================================+");
Console.WriteLine(" +----------------------------------------------------------------+");
Console.WriteLine(" LOCATION ID " + " | " + locationID);
Console.WriteLine(" LOCATION NAME " + " | " + location.locationName);
Console.WriteLine(" LOCATION PHONE " + " | " + location.locationPhone);
Console.WriteLine(" LOCATION STATE " + " | " + location.locationState);
Console.WriteLine();
Console.WriteLine(" PRODUCT ID " + " | " + productID);
Console.WriteLine(" PRODUCT NAME " + " | " + inventory.productName);
Console.WriteLine(" PRODUCT QUANTITY " + " | " + inventory.productQuantity);
Console.WriteLine(" +----------------------------------------------------------------+");
Console.WriteLine();
}
}
return(location);
}
}
public void OnClosing(object sender, System.ComponentModel.CancelEventArgs e)
{
LocationsModel.Save();
_core.Dispose();
}
public LocationsModel GetLocations() //TO BE REFACTORED SOON
{
var provinceList = new LocationsModel();
return(provinceList);
}
