/// <summary>
/// Obtains location informations from the Database creates LocationTable instances.
/// </summary>
/// <returns>
/// Returns Observable collections which accept LocationTables as their type.
/// </returns>
public ObservableCollection <LocationTable> GetLocations()
{
try
{
ObservableCollection <LocationTable> locations = new ObservableCollection <LocationTable>();
SQLQueryModel queryBuilder = new SQLQueryModel();
string query = string.Format("SELECT locationID, zipCode, locationName FROM location;");
DataTable locDataTable = new DataTable();
locDataTable = queryBuilder.ExecuteMySQLQuery(query);
foreach (DataRow row in locDataTable.Rows)
{
_locationTable = new LocationTable();
_locationTable.LocationID = Convert.ToInt32(row["locationID"]);
_locationTable.LocationName = row["locationName"].ToString();
_locationTable.ZipCode = Convert.ToInt32(row["zipCode"]);
locations.Add(_locationTable);
}
return(locations);
}
catch (ArgumentNullException nullex)
{
Protocol.WriteToProtocol(0, "RegisterNewUser() :" + nullex.Message + nullex.StackTrace, "Location is null Error");
return(null);
}
}
public async Task <IHttpActionResult> PostStudent(LocationTable location)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.Locations.Add(location);
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateException)
{
if (LocationExists(location.ID))
{
return(Conflict());
}
else
{
throw;
}
}
return(CreatedAtRoute("DefaultApi", new { id = location.ID }, location));
}
public async Task <IHttpActionResult> PutStudent(string id, LocationTable location)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != location.ID)
{
return(BadRequest());
}
db.Entry(location).State = EntityState.Modified;
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!LocationExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public Pprof()
{
Profile = new Profile();
_stringTable = new StringTable(Profile);
_functionTable = new FunctionTable(Profile, _stringTable);
_locationTable = new LocationTable(Profile, _functionTable);
}
public LocationProfileController()
{
this._locationprofileTable = new LocationProfileTable();
this._locationTable = new LocationTable();
//this._common = new CommonFunctions();
validatepermissions = new validatePermissions();
}
public CircuitController()
{
profileTable = new LocationProfileTable();
HardwareModel = new HardwareTable();
locationTable = new LocationTable();
circuitTable = new CircuitTable();
circuitLocationTable = new CircuitLocationTable();
}
public InventoryController()
{
this._inventoryTable = new InventoryTable();
this._userTable = new UserTable();
this._locationTable = new LocationTable();
this._profileTable = new ProfileTable();
this._hardwareTable = new HardwareTable();
this._logTable = new LogBook.Controllers.LogBookController();
}
public MonitorController()
{
locationTable = new LocationTable();
// _fieldsTable = new CustomFieldsTable("LocationCustomFields");
_processesTable = new ProcessesTable();
_diagramTable = new DiagramTable();
_circuitTable = new CircuitTable();
_usertable = new UserTable();
_monitorTable = new ObjectRealMonitorTable();
}
public ProcessController()
{
processesTable = new ProcessesTable();
movementTable = new MovementTable();
authorizationTable = new AuthorizationTable();
locationTable = new LocationTable();
hardwareTable = new HardwareTable();
rulesTable = new RulesTable();
hardwareReferenceTable = new HardwareReferenceTable();
validatepermissions = new validatePermissions();
}
public async Task <IHttpActionResult> GetStudent(string id)
{
LocationTable location = await db.Locations.FindAsync(id);
if (location == null)
{
return(NotFound());
}
return(Ok(location));
}
public LabelingController()
{
locationTable = new LocationTable();
userprofileTable = new UserProfileTable();
userTable = new UserTable();
objectTable = new ObjectTable();
objectRealTable = new ObjectReal();
notificationObject = new Notifications();
classNotifications = new Notifications();
_logTable = new LogBook.Controllers.LogBookController();
}
public static string GetLocationForID(string id)
{
DataRow[] rows = LocationTable.Select(COL_LOCATION_OBJECTNAME + "='" + id + "'");
if (rows.Length > 0)
{
return(Convert.ToString(rows[0][COL_LOCATION_NAME]));
}
else
{
return(id);
}
}
public async Task <IHttpActionResult> DeleteStudent(string id)
{
LocationTable location = await db.Locations.FindAsync(id);
if (location == null)
{
return(NotFound());
}
db.Locations.Remove(location);
await db.SaveChangesAsync();
return(Ok(location));
}
private ModulePackageDirectoryEntry CreateEntry(ModulePackageFile file)
{
ModulePackageDirectoryEntry entry = new ModulePackageDirectoryEntry();
int fileLocationIndex = LocationTable.IndexOf(file.FileLocation);
if (fileLocationIndex == -1)
{
fileLocationIndex = LocationTable.Count;
LocationTable.Add(file.FileLocation);
}
entry.FileLocationIndex = (byte)fileLocationIndex;
entry.FileName = file.FileName;
entry.FileSize = (uint)file.FileContents.Length;
return(entry);
}
public static void AddOrReplaceLocationData(string city, string postal, string cityCode, string country, string language, string state)
{
try
{
using (SQLiteConnection dbConn = new SQLiteConnection(new SQLitePlatformWinRT(), path))
{
LocationTable newRow = new LocationTable
{
Id = 0,
City = city,
Postal = postal,
CityCode = cityCode,
Country = country,
Language = language,
State = state
};
// ReSharper disable once AccessToDisposedClosure
dbConn.RunInTransaction(() => { dbConn.InsertOrReplace(newRow); });
TableQuery <ModuleTable> query = dbConn.Table <ModuleTable>();
foreach (ModuleTable moduleTable in query)
{
Module.Module module = (Module.Module)DeserializeModule(moduleTable.ModuleConfig);
module.City = city;
module.Postal = postal;
module.CityCode = cityCode;
module.Country = country;
module.Language = language;
module.NewsCountry = (Countries)Enum.Parse(typeof(Countries), country.ToUpper());
module.NewsLanguage = (Languages)Enum.Parse(typeof(Languages), language.ToUpper());
AddOrReplaceModule(moduleTable.ModuleName, module);
}
}
}
catch (Exception exception)
{
Log.Log.WriteException(exception);
}
}
#pragma warning disable 1998
private static async Task <Module> getModule(string value)
#pragma warning restore 1998
{
ModuleType moduleType = ModuleType.NONE;
string city = string.Empty;
string country = string.Empty;
string language = string.Empty;
LatitudeCoords latitudeCoords = null;
LongitudeCoords longitudeCoords = null;
Categories categories = Categories.Business;
Countries countries = Countries.AE;
Languages languages = Languages.AF;
if (value != string.Empty)
{
if (!value.Contains("news"))
{
LocationTable locationTable = DataAccess.GetLocationData()?[0];
moduleType = (ModuleType)Enum.Parse(typeof(ModuleType), value.ToUpper());
if (locationTable != null)
{
switch (moduleType)
{
case ModuleType.NONE:
break;
case ModuleType.TIME:
Coordinates coordinates = await GoogleMapsGeocoding.GetCoordinatesForCity(locationTable.City, locationTable.State, locationTable.Country);
latitudeCoords = coordinates.Latitude;
longitudeCoords = coordinates.Longitude;
break;
case ModuleType.WEATHER:
city = locationTable.City;
country = locationTable.Country;
language = locationTable.Language;
break;
case ModuleType.WEATHERFORECAST:
city = locationTable.City;
country = locationTable.Country;
language = locationTable.Language;
break;
case ModuleType.NEWS:
break;
case ModuleType.QUOTE:
break;
case ModuleType.JOKE:
break;
}
}
}
else
{
moduleType = ModuleType.NEWS;
value = value.Remove(0, 4);
// To UppperCamelCase
value = value.First().ToString().ToUpper() + value.Substring(1);
categories = (Categories)Enum.Parse(typeof(Categories), value);
LocationTable locationTable = DataAccess.GetLocationData()?[0];
// ReSharper disable once InvertIf
if (locationTable != null)
{
countries = (Countries)Enum.Parse(typeof(Countries), locationTable.Country.ToUpper());
languages = (Languages)Enum.Parse(typeof(Languages), locationTable.Language.ToUpper());
}
}
}
return(new Module
{
ModuleType = moduleType,
City = city,
Country = country,
Language = language,
LatitudeCoords = latitudeCoords,
LongitudeCoords = longitudeCoords,
NewsCategory = categories,
NewsCountry = countries,
NewsLanguage = languages
});
}
private void CreateModel(ref LayoutModel model)
{
iRstSrv.TableData[] data = null;
/*
* check:
* - TablePositionText = null -> post from location page or location-list-(edit-layout) page
* - TablePositionText != null -> back from table-numbering page or refresh the page
*/
if (string.IsNullOrEmpty(model.TablePositionText))
{
switch (model.Mode)
{
case Mode.CreateAfterRegistering:
case Mode.CreateFromLocationList:
case Mode.Create:
case Mode.EditFromLocation:
if (model.IsReload)
{
break;
}
/*
* TODO:
* - Get table list from database
* - Compare with input (if from location)
* - Delete tables or add new table
*/
// create from data that passed from location page
List <TableInfo> tableInfo = CreateTableInfo(model.TableText);
Dictionary <int, int> addDict = new Dictionary <int, int>();
List <int> deleteIDQueue = new List <int>();
var response = iRstSrvClient.Get().LocationGetTablesList_00_00_001(Common.Restaurant.RestaurantID.ToString(), model.LocationID.ToString(), Common.Token);
List <int> checkList = new List <int>();
foreach (var info in tableInfo)
{
checkList.Add(info.ChairNo);
LocationTable matched = null;
if (response.LocationTablesList != null)
{
var findQuery = response.LocationTablesList.Where(table => table.TableType == info.ChairNo);
if (findQuery.Count() > 0)
{
matched = findQuery.Single();
if (matched.TableIDs.Length > info.TableNo)
{
// delete exist table
for (int i = info.TableNo; i < matched.TableIDs.Length; i++)
{
deleteIDQueue.Add(matched.TableIDs[i]);
}
}
else if (matched.TableIDs.Length < info.TableNo)
{
int addingAmount = info.TableNo - matched.TableIDs.Length;
addDict[matched.TableType] = addingAmount;
}
}
}
if (matched == null)
{
addDict[info.ChairNo] = info.TableNo;
}
}
if (response.LocationTablesList != null)
{
foreach (var e in response.LocationTablesList)
{
if (checkList.Contains(e.TableType))
{
continue;
}
else
{
foreach (var id in e.TableIDs)
{
deleteIDQueue.Add(id);
}
}
}
}
// delete table from delete-id-queue
if (deleteIDQueue.Count > 0)
{
StringBuilder xml = new StringBuilder();
xml.Append("<tablelist>");
foreach (var id in deleteIDQueue)
{
xml.AppendFormat("<table><tableid>{0}</tableid></table>", id);
}
xml.Append("</tablelist>");
var deleteTableResponse = iRstSrvClient.Get().TableDeleteList_00_00_001(Common.Restaurant.RestaurantID.ToString(),
model.LocationID.ToString(), xml.ToString(), Common.Token);
}
// create table-data from add-dict
iRstSrv.TableData[] tableData = CreateTableData(addDict);
if (tableData.Length > 0)
{
StringBuilder xml = new StringBuilder();
xml.Append("<tablelist>");
foreach (var table in tableData)
{
xml.Append("<table>");
xml.AppendFormat("<tablenumber>{0}</tablenumber>", table.LayoutCode);
xml.AppendFormat("<noofchairs>{0}</noofchairs>", table.NoOfChairs);
xml.AppendFormat("<post>{0}</post>", table.PosT);
xml.AppendFormat("<posl>{0}</posl>", table.PosL);
xml.AppendFormat("<tableid>{0}</tableid>", table.TableID);
xml.Append("</table>");
}
xml.Append("</tablelist>");
var addTablesResponse = iRstSrvClient.Get().TableAddUpdateList_00_00_001(Common.Restaurant.RestaurantID.ToString(),
model.LocationID.ToString(), xml.ToString(), Common.Token);
}
break;
}
data = iRstSrvClient.Get().TableGetList_01_03_092(Common.Restaurant.RestaurantID.ToString(), model.LocationID.ToString(), Common.Token).Tables;
}
else
{
data = Utils.ParseFullInfo(model.TablePositionText);
}
if (model.IsReload)
{
data = ResetPosition(data);
}
//CreateModel(ref model);
model.Tables = Utils.CalculateTableWidth(data);
}
#pragma warning disable 1998
private static async Task <Module> GetModule(string value)
#pragma warning restore 1998
{
try
{
ModuleType moduleType = ModuleType.None;
string city = string.Empty;
string postal = string.Empty;
string cityCode = string.Empty;
string country = string.Empty;
string language = string.Empty;
LatitudeCoords latitudeCoords = null;
LongitudeCoords longitudeCoords = null;
Categories categories = Categories.Business;
Countries countries = Countries.AE;
Languages languages = Languages.AF;
if (value != string.Empty)
{
if (!value.Contains("news"))
{
LocationTable locationTable = DataAccess.GetLocationData()?[0];
moduleType = (ModuleType)Enum.Parse(typeof(ModuleType), Regex.Replace(value, @"[\d-]", string.Empty).ToUpper());
if (locationTable != null)
{
switch (moduleType)
{
case ModuleType.None:
break;
case ModuleType.Time:
Coordinates coordinates = await GoogleMapsGeocoding.GetCoordinatesForPostal(locationTable.Postal, locationTable.Country);
if (coordinates == null)
{
break;
}
latitudeCoords = coordinates.Latitude;
longitudeCoords = coordinates.Longitude;
break;
case ModuleType.Weather:
city = locationTable.City;
postal = locationTable.Postal;
cityCode = locationTable.CityCode;
country = locationTable.Country;
language = locationTable.Language;
break;
case ModuleType.Weatherforecast:
city = locationTable.City;
postal = locationTable.Postal;
cityCode = locationTable.CityCode;
country = locationTable.Country;
language = locationTable.Language;
break;
case ModuleType.News:
break;
case ModuleType.Quote:
break;
case ModuleType.Joke:
break;
}
}
}
else
{
moduleType = ModuleType.News;
value = value.Remove(0, 4);
// To UppperCamelCase
value = value.First().ToString().ToUpper() + value.Substring(1);
categories = (Categories)Enum.Parse(typeof(Categories), Regex.Replace(value, @"[\d-]", string.Empty));
LocationTable locationTable = DataAccess.GetLocationData()?[0];
// ReSharper disable once InvertIf
if (locationTable != null)
{
countries = (Countries)Enum.Parse(typeof(Countries), locationTable.Country.ToUpper());
languages = (Languages)Enum.Parse(typeof(Languages), locationTable.Language.ToUpper());
}
}
}
return(new Module
{
ModuleType = moduleType,
City = city,
Postal = postal,
CityCode = cityCode,
Country = country,
Language = language,
LatitudeCoords = latitudeCoords,
LongitudeCoords = longitudeCoords,
NewsCategory = categories,
NewsCountry = countries,
NewsLanguage = languages
});
}
catch (Exception exception)
{
Log.Log.WriteException(exception);
return(new Module());
}
}
