public SelectProfilePage()
{
InitializeComponent();
Profile profile = DatabaseHelper.GetProfile(App.Os_Folder);
List <App_Con> lstConf = DatabaseHelper.getConfiguration(App.Os_Folder);
App_Con isUserAdmin = lstConf.Find(x => x.Name == "EmailAdmin" && x.Value == profile.Email.Trim());
if (isUserAdmin != null)
{
bt_traveler.IsVisible = true;
}
else
{
bt_traveler.IsVisible = false;
}
}
private async void OnCommand()
{
bool updateCatalogs = false;
App_Con nSetting = new App_Con();
ObservableCollection<App_Con> ConfDateFromWs;
ApiService apiService = new ApiService();
using (UserDialogs.Instance.Loading(Translator.getText("LookingForUpdates"), null, null, true, MaskType.Black))
{
List<App_Con> lstSetting = DatabaseHelper.getConfiguration(Os_Folder);
// detect country
strCurrency = " USD";
// if Settins table is empty get configuration date (catalogs) from web service and save it to the database and asign it to
// updateDateStored and nSettings
ConfDateFromWs = await apiService.getConfAsync();
if (ConfDateFromWs.Count > 0)
{
string DateFromWebService = ConfDateFromWs.Where(x => x.Name == Constants.UpdateCatalog).First().Value;
string strDatabaseDate = "";
if (lstSetting == null) lstSetting = new List<App_Con>();
if (lstSetting.Count > 0)
{
strDatabaseDate = lstSetting.Where(x => x.Name == Constants.UpdateCatalog).First().Value;
int day = int.Parse(DateFromWebService.Split('/')[0]);
int month = int.Parse(DateFromWebService.Split('/')[1]);
int year = int.Parse(DateFromWebService.Split('/')[2]);
DateTime fromwebservice = new DateTime(year,month,day);
DateTime fromDatabase = new DateTime(1970, month, day);
if (fromwebservice > fromDatabase)
{
updateCatalogs = true;
}else
{ updateCatalogs = false; }
}
else
{
updateCatalogs = true;
}
}
}
if (updateCatalogs)
{
using (UserDialogs.Instance.Loading(Translator.getText("LoadingResources"), null, null, true, MaskType.Black))
{
DatabaseHelper.Delete(ref nSetting, Os_Folder, "App_Con", "");
foreach (App_Con item in ConfDateFromWs)
{
nSetting = item;
DatabaseHelper.Insert(ref nSetting, Os_Folder);
}
// Delete UserTypes, UserDelivery, UserCategories
DatabaseHelper.Delete(ref nSetting, Os_Folder, "Categories", "");
DatabaseHelper.Delete(ref nSetting, Os_Folder, "Types", "");
DatabaseHelper.Delete(ref nSetting, Os_Folder, "DeliveryTypes", "");
DatabaseHelper.Delete(ref nSetting, Os_Folder, "CollectTypes", "");
DatabaseHelper.Delete(ref nSetting, Os_Folder, "Countries", "");
ObservableCollection<Categories> oc_Categories = await apiService.getCategoriesAsync();
ObservableCollection<Types> oc_Types = await apiService.getTypesAsync();
ObservableCollection<DeliveryTypes> oc_DeliveryTypes = await apiService.getDeliveryTypesAsync();
ObservableCollection<CollectTypes> oc_CollectTypes = await apiService.getCollectTypesAsync();
ObservableCollection<Countries> oc_Countries= await apiService.getCountriesAsync();
// Insert UserTypes, UserDelivery, UserCategories
foreach (Categories item in oc_Categories)
{
Categories nCategorie = new Categories();
nCategorie = item;
DatabaseHelper.Insert(ref nCategorie, Os_Folder);
}
foreach (Types item in oc_Types)
{
Types nType = new Types();
nType = item;
DatabaseHelper.Insert(ref nType, Os_Folder);
}
foreach (DeliveryTypes item in oc_DeliveryTypes)
{
DeliveryTypes nDeliType = new DeliveryTypes();
nDeliType = item;
DatabaseHelper.Insert(ref nDeliType, Os_Folder);
}
foreach (CollectTypes item in oc_CollectTypes)
{
CollectTypes nCollType = new CollectTypes();
nCollType = item;
DatabaseHelper.Insert(ref nCollType, Os_Folder);
}
foreach (Countries item in oc_Countries)
{
Countries nCountryType = new Countries();
nCountryType = item;
DatabaseHelper.Insert(ref nCountryType, Os_Folder);
}
}
}
}
