public override void Load() { IDbManager dbManager = ObjectPool.Instance.Resolve <IDbManager>(); IDataCommand db = dbManager.GetDatabase(ApplicationSettings.Instance.Database.DefaultConnection.Name); List <InvoiceDataValue> result = db.Query <InvoiceDataValue>("GetDashboardInvoiceMonth", new { Year = this.Year }); Total = 0; Order = 0; MutableObservableCollection <SeriesData <InvoiceDataValue> > model = new MutableObservableCollection <SeriesData <InvoiceDataValue> >(); InvoiceDataValue item; for (int i = 1; i <= 12; i++) { item = result.Where(x => x.Name == i.ToString()).SingleOrDefault(); model.Add(new SeriesData <InvoiceDataValue>() { SeriesDisplayName = DateTimeFormatInfo.CurrentInfo.GetMonthName(i) }); if (item != null) { model[i - 1].Items.Add(new InvoiceDataValue() { Name = DateTimeFormatInfo.CurrentInfo.GetMonthName(i), Number = item.Number }); Total += item.Number; Order += item.Order; OrderInstallment = item.OrderInstallment; TotalInstallment = item.TotalInstallment; } else { model[i - 1].Items.Add(new InvoiceDataValue() { Name = DateTimeFormatInfo.CurrentInfo.GetMonthName(i), Number = 0 }); } } this.Source = model; db.Close(); }
public override void Load() { IDbManager dbManager = ObjectPool.Instance.Resolve<IDbManager>(); IDataCommand db = dbManager.GetDatabase(ApplicationSettings.Instance.Database.DefaultConnection.Name); List<DataValue> result = db.Query<DataValue>("GetDashboardRemainingPerMonth", new { Year = this.Year, Month = this.Month }); MutableObservableCollection<SeriesData<DataValue>> model = new MutableObservableCollection<SeriesData<DataValue>>(); for (int i = 0; i < result.Count; i++) { model.Add(new SeriesData<DataValue>() { SeriesDisplayName = result[i].Name }); model[i].Items.Add(new DataValue() { Name = result[i].Name, Number = result[i].Number }); } this.Source = model; db.Close(); }
public override void Load() { IDbManager dbManager = ObjectPool.Instance.Resolve <IDbManager>(); IDataCommand db = dbManager.GetDatabase(ApplicationSettings.Instance.Database.DefaultConnection.Name); List <DataValue> result = db.Query <DataValue>("GetDashboardTopConsumer", new { Year = this.Year }); MutableObservableCollection <SeriesData <DataValue> > model = new MutableObservableCollection <SeriesData <DataValue> >(); for (int i = 0; i < result.Count; i++) { model.Add(new SeriesData <DataValue>() { SeriesDisplayName = result[i].Name }); model[i].Items.Add(new DataValue() { Name = result[i].Name, Number = result[i].Number }); } this.Source = model; db.Close(); }
public override void Load() { IDbManager dbManager = ObjectPool.Instance.Resolve<IDbManager>(); IDataCommand db = dbManager.GetDatabase(ApplicationSettings.Instance.Database.DefaultConnection.Name); List<InvoiceDataValue> result = db.Query<InvoiceDataValue>("GetDashboardInvoiceMonth", new { Year = this.Year }); Total = 0; Order = 0; MutableObservableCollection<SeriesData<InvoiceDataValue>> model = new MutableObservableCollection<SeriesData<InvoiceDataValue>>(); InvoiceDataValue item; for (int i = 1; i <= 12; i++) { item = result.Where(x => x.Name == i.ToString()).SingleOrDefault(); model.Add(new SeriesData<InvoiceDataValue>() { SeriesDisplayName = DateTimeFormatInfo.CurrentInfo.GetMonthName(i) }); if (item != null) { model[i - 1].Items.Add(new InvoiceDataValue() { Name = DateTimeFormatInfo.CurrentInfo.GetMonthName(i), Number = item.Number }); Total += item.Number; Order += item.Order; OrderInstallment = item.OrderInstallment; TotalInstallment = item.TotalInstallment; } else { model[i - 1].Items.Add(new InvoiceDataValue() { Name = DateTimeFormatInfo.CurrentInfo.GetMonthName(i), Number = 0 }); } } this.Source = model; db.Close(); }
protected void GetQueue(string sql, params object[] args) { IDbManager dbManager = ObjectPool.Instance.Resolve <IDbManager>(); IDataCommand db = dbManager.GetDatabase(DatabaseNames.SMSGW); List <QueueWork> workItem = db.Query <QueueWork>(sql, args); MutableObservableCollection <ComposeMessageModel> buffer = new MutableObservableCollection <ComposeMessageModel>(); if (workItem.Any()) { List <DailyTrigger> daily; List <WeeklyTrigger> weekly; List <MonthlyTrigger> monthly; CommandParser parser; Dictionary <string, string> parsingCommand; DynamicData parameters; ComposeMessageModel model; foreach (QueueWork item in workItem) { model = new ComposeMessageModel(); parser = new CommandParser(); parsingCommand = parser.Parse(item.Command); parameters = new DynamicData(); foreach (string key in parsingCommand.Keys) { if (!key.Equals("Command")) { parameters.Add(key, parsingCommand[key]); } } model.Source = item.Source; model.SeqNbr = item.SeqNbr; model.Phonenumber = (string)parameters.GetDictionary()["number"]; model.Message = (string)parameters.GetDictionary()["message"]; model.Date = item.Created.ToString("dd/MM/yyyy"); model.Time = item.Created.ToString("HH:mm"); model.Enabled = item.Enabled; if (item.NextExecuted.Ticks > 0) { model.NextExecuted = DateTime.Parse(item.NextExecuted.ToString("dd/MM/yyyy HH:mm")); } string triggerPrefix = string.Empty; if (!string.IsNullOrEmpty(item.ScheduleID)) { triggerPrefix = item.ScheduleID.Substring(0, 1); } switch (triggerPrefix) { case "D": daily = db.Query <DailyTrigger>("GetDailyTriggerByID", new { ID = item.ScheduleID }); if (daily.Any()) { model.TriggerOptions = TriggerOptions.Daily; model.RecursDay = daily[0].RecursEvery; } break; case "W": weekly = db.Query <WeeklyTrigger>("GetWeeklyTriggerByID", new { ID = item.ScheduleID }); if (weekly.Any()) { model.TriggerOptions = TriggerOptions.Weekly; model.RecursWeek = weekly[0].RecursEvery; model.WeeklyOptions.Monday = weekly[0].Monday; model.WeeklyOptions.Tuesday = weekly[0].Tuesday; model.WeeklyOptions.Wednesday = weekly[0].Wednesday; model.WeeklyOptions.Thursday = weekly[0].Thursday; model.WeeklyOptions.Friday = weekly[0].Friday; model.WeeklyOptions.Saturday = weekly[0].Saturday; model.WeeklyOptions.Sunday = weekly[0].Sunday; } break; case "M": monthly = db.Query <MonthlyTrigger>("GetMonthlyTriggerByID", new { ID = item.ScheduleID }); if (monthly.Any()) { model.TriggerOptions = TriggerOptions.Monthly; model.Months[0].IsSelected = monthly[0].January; model.Months[1].IsSelected = monthly[0].February; model.Months[2].IsSelected = monthly[0].March; model.Months[3].IsSelected = monthly[0].April; model.Months[4].IsSelected = monthly[0].May; model.Months[5].IsSelected = monthly[0].June; model.Months[6].IsSelected = monthly[0].July; model.Months[7].IsSelected = monthly[0].August; model.Months[8].IsSelected = monthly[0].September; model.Months[9].IsSelected = monthly[0].October; model.Months[10].IsSelected = monthly[0].November; model.Months[11].IsSelected = monthly[0].December; string[] days = monthly[0].Days.Split(','); foreach (string day in days) { model.Days[Convert.ToInt32(day)].IsSelected = 1; } } break; case "O": model.TriggerOptions = TriggerOptions.OneTime; break; } buffer.Add(model); } } Source = buffer; }