public string GetTOPAgents(MainDashboard obj)
{
try
{
SqlParameter[] Parameters =
{
new SqlParameter("@AirlineSno", obj.Airline),
new SqlParameter("@FromDate", obj.FromDate),
new SqlParameter("@ToDate", obj.ToDate),
new SqlParameter("@CountrySNo", obj.Country),
new SqlParameter("@CitySNo", obj.City == "" ? "0": obj.City),
new SqlParameter("@CurrencySno", obj.Currency == "" ? "0": obj.Currency),
new SqlParameter("@Mode", obj.Mode),
new SqlParameter("@AccountSNo", obj.AccountSNo == "0" ? "": obj.AccountSNo),
new SqlParameter("@UserSNo", obj.UserSNo == "0" ? "": obj.UserSNo)
};
DataSet ds = SqlHelper.ExecuteDataset(ReadConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, "Dashboard_GetTOP10AgentContributionRecord", Parameters);
return(CargoFlash.Cargo.Business.Common.CompleteDStoJSON(ds));
}
catch (Exception ex)
{
throw ex;
}
}
private async void UserLogin()
{
var isEmpty = ValidateFields(LoginModel.UserUsername, LoginModel.UserPassword);
if (!isEmpty)
{
return;
}
MemberServiceProvider memberService = new MemberServiceProvider();
UserAccountModel userAccountModel = new UserAccountModel();
CancellationTokenSource cancellationTokenSource = new CancellationTokenSource();
userAccountModel.Username = LoginModel.UserUsername;
userAccountModel.Password = LoginModel.UserPassword;
try
{
var result = await memberService.AuthenticateUserAsync(userAccountModel, cancellationTokenSource.Token);
if (result != null)
{
MainDashboard mainDashboard = new MainDashboard();
App.Current.MainWindow.Close();
mainDashboard.Owner = App.Current.MainWindow;
mainDashboard.ShowDialog();
ClearFields();
}
}
catch (Exception ex)
{
ShowGenericMessage(ex.Message);
}
}
private void button13_Click(object sender, EventArgs e)
{
MainDashboard mm = new MainDashboard(userName);
mm.Show();
this.Close();
}
static void Main(string[] args)
{
IDashboard dashboard = new MainDashboard();
dashboard.ShowDashboard();
Console.Read();
}
public MainDashboard GetBase()
{
var mainDashboard = new MainDashboard();
// Datum a čas sestavení boardu
mainDashboard.GenerationDateTime = DateTime.Now.ToString("dd.MM.yyyy HH:mm");
return(mainDashboard);
}
void DefaultDashboardController_CustomShowNavigationItem(object sender, CustomShowNavigationItemEventArgs e)
{
if (e.ActionArguments.SelectedChoiceActionItem.Id == $"{nameof(MainDashboard)}_ListView")
{
IObjectSpace objectSpace = Application.CreateObjectSpace();
var objectToShow = new MainDashboard();
e.ActionArguments.ShowViewParameters.CreatedView = Application.CreateDetailView(objectSpace, objectToShow, true);
e.ActionArguments.ShowViewParameters.TargetWindow = TargetWindow.Current;
e.ActionArguments.ShowViewParameters.CreatedView.QueryCanClose += CreatedView_QueryCanClose;
e.Handled = true;
}
}
public async Task <IActionResult> Index()
{
var dashboard = new MainDashboard();
var client = _controllerAPI.Initialize(_configuration);
var response = await client.GetAsync("api/MainDashboard");
if (response.IsSuccessStatusCode)
{
string jsonResult = response.Content.ReadAsStringAsync().Result;
dashboard = JsonConvert.DeserializeObject <MainDashboard>(jsonResult);
}
return(View(dashboard));
}
public void TechnicianListPageViewModel_PropertyChanged(object sender, System.ComponentModel.PropertyChangedEventArgs e)
{
TechnicianListPageViewModel vm = sender as TechnicianListPageViewModel;
switch (e.PropertyName)
{
case "IsLoading":
IHud hud = DependencyService.Get <IHud>();
if (vm.IsLoading)
{
//XHUD.HUD.Show("Loading data...", -1, XHUD.MaskType.Black);
hud.Show("Loading data...");
}
else
{
hud.Dismiss();
}
break;
case "IsSignedIn":
if (vm.IsSignedIn)
{
Device.BeginInvokeOnMainThread(() =>
MainPage = new MainDashboard());
//MainPage = new MainDashboard(this);
}
else
{
if (!(MainPage is TechnicianListPage))
{
MainPage = new TechnicianListPage(vm);
}
}
break;
default:
break;
}
}
/// <summary>
/// 0-parameter constructor for the LoginForm object
/// </summary>
public LoginForm()
{
InitializeComponent();
this.dashboard = new MainDashboard();
}
private void btnCreate_Click(object sender, EventArgs e)
{
try
{
if (txt999.Text == string.Empty)
{
errorProvider1.Clear();
errorProvider1.SetError(txt999, "Enter Value.");
txt999.Focus();
panel3.Visible = true;
lblError.Text = "Enter Value.";
}
else if (txtHallMark.Text == string.Empty)
{
errorProvider1.Clear();
errorProvider1.SetError(txtHallMark, "Enter Value.");
txtHallMark.Focus();
panel3.Visible = true;
lblError.Text = "Enter Value.";
}
else if (txtBuyBack.Text == string.Empty)
{
errorProvider1.Clear();
errorProvider1.SetError(txtBuyBack, "Enter Value.");
txtBuyBack.Focus();
panel3.Visible = true;
lblError.Text = "Enter Value.";
}
else if (txt22c.Text == string.Empty)
{
errorProvider1.Clear();
errorProvider1.SetError(txt22c, "Enter Value.");
txt22c.Focus();
panel3.Visible = true;
lblError.Text = "Enter Value.";
}
else if (txt23c.Text == string.Empty)
{
errorProvider1.Clear();
errorProvider1.SetError(txt23c, "Enter Value.");
txt23c.Focus();
panel3.Visible = true;
lblError.Text = "Enter Value.";
}
else if (txt18c.Text == string.Empty)
{
errorProvider1.Clear();
errorProvider1.SetError(txt18c, "Enter Value.");
txt18c.Focus();
panel3.Visible = true;
lblError.Text = "Enter Value.";
}
else if (txtSilver.Text == string.Empty)
{
errorProvider1.Clear();
errorProvider1.SetError(txtSilver, "Enter Value.");
txtSilver.Focus();
panel3.Visible = true;
lblError.Text = "Enter Value.";
}
else
{
if (passedId == 0)
{
var todaysDate = DateTime.Now.Date;
_entities = new MicroAccountsEntities1();
var data = _entities.DailyRates.Where(x => x.date == todaysDate).FirstOrDefault();
if (data == null)
{
_entities = new MicroAccountsEntities1();
DailyRate rates = new DailyRate();
rates.fineGold = Convert.ToDecimal(txt999.Text);
rates.hallmark = Convert.ToDecimal(txtHallMark.Text);
rates.hallmarkBuyBack = Convert.ToDecimal(txtBuyBack.Text);
rates.twentyTwoC = Convert.ToDecimal(txt22c.Text);
rates.twentyThreeC = Convert.ToDecimal(txt23c.Text);
rates.eighteenC = Convert.ToDecimal(txt18c.Text);
rates.silver = Convert.ToDecimal(txtSilver.Text);
rates.date = DateTime.Now.Date;
rates.createdDate = DateTime.Now;
rates.updatedDate = DateTime.Now;
_entities.DailyRates.Add(rates);
_entities.SaveChanges();
MessageBox.Show("Record SuccessFully Added!");
clear();
MainDashboard mm = new MainDashboard(userName);
mm.Show();
}
else
{
DialogResult myResult;
myResult = MessageBox.Show("Are you really wnat to update the Rates?", "Update Confirmation", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
if (myResult == DialogResult.OK)
{
btnCreate.Text = "Update";
data.fineGold = Convert.ToDecimal(txt999.Text);
data.hallmark = Convert.ToDecimal(txtHallMark.Text);
data.hallmarkBuyBack = Convert.ToDecimal(txtBuyBack.Text);
data.twentyTwoC = Convert.ToDecimal(txt22c.Text);
data.twentyThreeC = Convert.ToDecimal(txt23c.Text);
data.eighteenC = Convert.ToDecimal(txt18c.Text);
data.silver = Convert.ToDecimal(txtSilver.Text);
data.date = DateTime.Now.Date;
data.createdDate = DateTime.Now;
_entities.SaveChanges();
MessageBox.Show("Record SuccessFully Updated!");
clear();
MainDashboard mm = new MainDashboard(userName);
mm.Show();
}
else
{
MainDashboard mm = new MainDashboard(userName);
mm.Show();
this.Close();
}
}
}
else
{
btnCreate.Text = "Update";
_entities = new MicroAccountsEntities1();
var rates = _entities.DailyRates.Where(x => x.id == passedId).FirstOrDefault();
rates.fineGold = Convert.ToDecimal(txt999.Text);
rates.hallmark = Convert.ToDecimal(txtHallMark.Text);
rates.hallmarkBuyBack = Convert.ToDecimal(txtBuyBack.Text);
rates.twentyTwoC = Convert.ToDecimal(txt22c.Text);
rates.twentyThreeC = Convert.ToDecimal(txt23c.Text);
rates.silver = Convert.ToDecimal(txtSilver.Text);
rates.eighteenC = Convert.ToDecimal(txt18c.Text);
rates.date = DateTime.Now.Date;
rates.createdDate = DateTime.Now;
_entities.SaveChanges();
MessageBox.Show("Record SuccessFully Updated!");
clear();
}
}
}
catch (Exception c)
{
}
}
protected async override void OnStart()
{
// Handle when your app starts
bool hasValidSetup = false;
App_Settings appSettings = App.Database.GetApplicationSettings();
string loggiedintechnicianno;
JT_Technician technician = null;
bool tableExists = false;
try
{
hasValidSetup = await Database.HasValidSetup(appSettings);
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex.Message);
await MainPage.DisplayAlert("Error!", ex.Message, "OK");
throw;
}
tableExists = App.Database.TableExists <JT_Technician>();
// Are the settings valid?
if (hasValidSetup)
{
// Yes, so move on to the technician login
//App_Settings appSettings = App.Database.GetApplicatioinSettings();
loggiedintechnicianno = (appSettings.LoggedInTechnicianNo != null) ? appSettings.LoggedInTechnicianNo : "";
if (tableExists && loggiedintechnicianno.Length > 0) // we've already established we do && Database.HasDataConnection())
{
technician = App.Database.GetTechnician(appSettings.LoggedInTechnicianDeptNo, appSettings.LoggedInTechnicianNo);
if (technician != null)
{
App.Database.SaveTechnicianAsCurrent(technician);
App.Database.CreateDependentTables(technician);
MainPage = new MainDashboard();
}
else
{
if (Database.HasDataConnection())
{
Database.CreateGlobalTables();
}
Thread.Sleep(5000);
TechnicianListPageViewModel viewModel = new TechnicianListPageViewModel();
viewModel.PropertyChanged += TechnicianListPageViewModel_PropertyChanged;
MainPage = new TechnicianListPage(viewModel);
}
}
else
{
if (Database.HasDataConnection())
{
Database.CreateGlobalTables();
}
Thread.Sleep(5000);
TechnicianListPageViewModel viewModel = new TechnicianListPageViewModel();
viewModel.PropertyChanged += TechnicianListPageViewModel_PropertyChanged;
MainPage = new TechnicianListPage(viewModel);
}
}
else
{
// Invalid settings, so show the settings page.
// Otherwise, data calls will never work.
AppSettingsPage settingsPage = new AppSettingsPage();
settingsPage.SettingsSaved += AppSettingsPage_SettingsSaved;
MainPage = settingsPage;
return;
}
}
public MainDashboard Get()
{
var mainDashboard = new MainDashboard();
if (_context.Dashboards.Count() > 0)
{
var dashboard = _context.Dashboards.Include(t => t.OutdoorCollector.Sensors)
.First();
if (dashboard != null)
{
// Venkovní senzory
var outdoorSensors = new List <SensorValue>();
foreach (var sensor in dashboard.OutdoorCollector.Sensors)
{
var sv = new SensorValue();
sv.Sensor = sensor;
sv.Value = _context.SensorRecords.Where(t => t.SensorId == sensor.Id).LastOrDefault().Value;
outdoorSensors.Add(sv);
}
mainDashboard.OutdoorSensorsValue = outdoorSensors.ToArray();
// Vnitřní senzory
var IndoorCollectors = new List <CollectorValues>();
foreach (var collector in _context.Collectors.Where(t => t.Id != dashboard.OutdoorCollector.Id).Include(t => t.Sensors))
{
var collectorValues = new CollectorValues();
var IndoorSensorValues = new List <SensorValue>();
foreach (var sensor in collector.Sensors)
{
var sv = new SensorValue();
sv.Sensor = sensor;
sv.Value = _context.SensorRecords.Where(t => t.SensorId == sensor.Id).LastOrDefault().Value;
IndoorSensorValues.Add(sv);
}
collectorValues.Sensors = IndoorSensorValues;
collectorValues.Location = collector.Name;
IndoorCollectors.Add(collectorValues);
}
mainDashboard.IndoorCollectors = IndoorCollectors.ToArray();
// Přepověď teploty a srážek
if (_context.WeatherForecast != null)
{
var weatherForecastId = _context.WeatherForecast.LastOrDefault().Id;
var hourlyForecast = _context.WeatherForecastHourlyState.Where(t => t.WeatherForecastId == weatherForecastId)
.OrderBy(m => m.DateTime);
if (hourlyForecast != null)
{
mainDashboard.TemperatureForecast = new HourlyForecast();
mainDashboard.TemperatureForecast.Hour = hourlyForecast.Select(t => t.DateTime.Hour.ToString()).ToArray();
mainDashboard.TemperatureForecast.Values = hourlyForecast.Select(t => t.Temperature).ToArray();
mainDashboard.PrecipitationForecast = new HourlyForecast();
mainDashboard.PrecipitationForecast.Hour = hourlyForecast.Select(t => t.DateTime.Hour.ToString()).ToArray();
mainDashboard.PrecipitationForecast.Values = hourlyForecast.Select(t => t.Rain + t.Snow).ToArray();
}
var currentState = _context.WeatherForecastCurrentState.LastOrDefault();
if (currentState != null)
{
mainDashboard.Sunrise = currentState.SunriseTime.ToString("HH:mm");
mainDashboard.Sunset = currentState.SunsetTime.ToString("HH:mm");
}
}
// Teplota rosného bodu - v jídelně
var indoorDewPointCollector = _context.Collectors.Where(t => t.Id == 1).Include(t => t.Sensors).FirstOrDefault();
if (indoorDewPointCollector != null)
{
var indoorTemperatureSensor = indoorDewPointCollector.Sensors.Where(t => t.Type == CMLSmartHomeCommon.Enums.SensorType.Temperature).FirstOrDefault();
var indoorHumaditySensor = indoorDewPointCollector.Sensors.Where(t => t.Type == CMLSmartHomeCommon.Enums.SensorType.Humidity).FirstOrDefault();
var indoorTemperature = _context.SensorRecords.Where(t => t.SensorId == indoorTemperatureSensor.Id).LastOrDefault().Value;
var indoorHumadity = _context.SensorRecords.Where(t => t.SensorId == indoorHumaditySensor.Id).LastOrDefault().Value;
mainDashboard.IndoorDewpointTemperature = Weather.DewpointTemperatureCalculate(indoorHumadity, indoorTemperature);
}
// Teplota rosného bodu - venkovní
var outdoorTemperatureSensor = dashboard.OutdoorCollector.Sensors.Where(t => t.Type == CMLSmartHomeCommon.Enums.SensorType.Temperature).FirstOrDefault();
var outdoorHumaditySensor = dashboard.OutdoorCollector.Sensors.Where(t => t.Type == CMLSmartHomeCommon.Enums.SensorType.Humidity).FirstOrDefault();
var outdoorTemperature = _context.SensorRecords.Where(t => t.SensorId == outdoorTemperatureSensor.Id).LastOrDefault().Value;
var outdoorHumadity = _context.SensorRecords.Where(t => t.SensorId == outdoorHumaditySensor.Id).LastOrDefault().Value;
mainDashboard.OutdoorDewpointTemperature = Weather.DewpointTemperatureCalculate(outdoorHumadity, outdoorTemperature);
// Datum a čas sestavení boardu
mainDashboard.GenerationDateTime = DateTime.Now.ToString("dd.MM.yyyy HH:mm");
}
}
return(mainDashboard);
}
