/// <summary>
/// Filters the source by the specified search text.
/// </summary>
/// <param name="source">The songs to search.</param>
/// <param name="searchText">The search text.</param>
/// <returns>The filtered sequence of songs.</returns>
public static MutableObservableCollection <CreateOrderModel> Filter(MutableObservableCollection <CreateOrderModel> source, string searchText)
{
if (String.IsNullOrWhiteSpace(searchText))
{
return(source);
}
IEnumerable <string> keyWords = searchText.Split(' ');
return(source
.AsParallel()
.Where
(
item => keyWords.All
(
keyword =>
item.PoNumber.ContainsIgnoreCase(keyword) ||
item.CustomerName.ContainsIgnoreCase(keyword) ||
item.CustomerPhone.ContainsIgnoreCase(keyword) ||
item.TotalPayment.LessThanOrEqual(keyword) ||
item.CreatedDate.ToString("dd-MMM-YYYY").ContainsIgnoreCase(keyword) ||
item.Details.Source.Any(detail =>
(
detail.Title.ContainsIgnoreCase(keyword) ||
detail.SelectedMaterial.ContainsIgnoreCase(keyword) ||
detail.SelectedFinishing.ContainsIgnoreCase(keyword) ||
detail.SelectedQuality.ContainsIgnoreCase(keyword) ||
detail.Deadline.ToString() == (keyword)
)
)
)
)
.Convert <CreateOrderModel>());
}
/// <summary>
/// Filters the source by the specified search text.
/// </summary>
/// <param name="source">The songs to search.</param>
/// <param name="searchText">The search text.</param>
/// <returns>The filtered sequence of songs.</returns>
public static MutableObservableCollection <TransactionStock> Filter(MutableObservableCollection <TransactionStock> source, string searchText)
{
if (String.IsNullOrWhiteSpace(searchText))
{
return(source);
}
IEnumerable <string> keyWords = searchText.Split(' ');
return(source
.AsParallel()
.Where
(
item => keyWords.All
(
keyword =>
item.MaterialName.ContainsIgnoreCase(keyword) ||
item.QualityName.ContainsIgnoreCase(keyword) ||
item.SupplierName.ContainsIgnoreCase(keyword) ||
item.Qty.LessThanOrEqual(keyword) ||
item.CreatedDate.ToString("dd-MMM-YYYY").ContainsIgnoreCase(keyword)
)
)
.Convert <TransactionStock>());
}
private void OnCheckedHeader(object args)
{
bool check = false;
MutableObservableCollection <object> listArgs = new MutableObservableCollection <object>((IEnumerable <BaseDataRow>)args);
if (listArgs.Count > 0)
{
check = !((BaseDataRow)listArgs[0]).SelectAll;
}
Task.Factory.StartNew(() =>
{
SelectableRow.Clear();
foreach (BaseDataRow message in listArgs)
{
message.IsSelected = check;
message.SelectAll = check;
if (message.IsSelected)
{
SelectableRow.Add(message);
}
else
{
SelectableRow.Remove(message);
}
}
});
}
public BaseMasterCollectionViewModel()
{
Source = new MutableObservableCollection <T>();
EditCommand = new DelegateCommand <object>(new Action <object>(OnEdit));
DeleteCommand = new DelegateCommand <object>(new Action <object>(OnDelete));
CreateCommand = new DelegateCommand(new Action(OnCreate));
}
/// <summary>
/// Filters the source by the specified search text.
/// </summary>
/// <param name="source">The songs to search.</param>
/// <param name="searchText">The search text.</param>
/// <returns>The filtered sequence of songs.</returns>
public static MutableObservableCollection<CreateOrderModel> Filter(MutableObservableCollection<CreateOrderModel> source, string searchText)
{
if (String.IsNullOrWhiteSpace(searchText))
return source;
IEnumerable<string> keyWords = searchText.Split(' ');
return source
.AsParallel()
.Where
(
item => keyWords.All
(
keyword =>
item.PoNumber.ContainsIgnoreCase(keyword) ||
item.CustomerName.ContainsIgnoreCase(keyword) ||
item.CustomerPhone.ContainsIgnoreCase(keyword) ||
item.TotalPayment.LessThanOrEqual(keyword) ||
item.CreatedDate.ToString("dd-MMM-YYYY").ContainsIgnoreCase(keyword) ||
item.Details.Source.Any(detail =>
(
detail.Title.ContainsIgnoreCase(keyword) ||
detail.SelectedMaterial.ContainsIgnoreCase(keyword) ||
detail.SelectedFinishing.ContainsIgnoreCase(keyword) ||
detail.SelectedQuality.ContainsIgnoreCase(keyword) ||
detail.Deadline.ToString() == (keyword)
)
)
)
)
.Convert<CreateOrderModel>();
}
public PrintOrderCollectionViewSource()
{
Source = new MutableObservableCollection <CreateOrderModel>();
UpdateQueueOrderCommand = ReactiveUI.ReactiveCommand.Create();
UpdateQueueOrderCommand.Subscribe(x =>
{
OnUpdateQueueOrder(x.ToString());
});
}
public void Pull()
{
IDbManager dbManager = ObjectPool.Instance.Resolve <IDbManager>();
IDataCommand db = dbManager.GetDatabase(ApplicationSettings.Instance.Database.DefaultConnection.Name);
MutableObservableCollection <CreateOrderModel> newPaymentOrder = new MutableObservableCollection <CreateOrderModel>();
MutableObservableCollection <CreateOrderModel> newPrintOrder = new MutableObservableCollection <CreateOrderModel>();
MutableObservableCollection <CreateOrderModel> newQueue = new MutableObservableCollection <CreateOrderModel>();
KeyValueOption selectedRange = this.SelectedRange;
if (IndexRefreshing == -1 || IndexRefreshing == 1)
{
newPrintOrder = new MutableObservableCollection <CreateOrderModel>();
newPrintOrder = db.Query <CreateOrderModel>("GetPrintOrder", new { Between = Convert.ToInt32(selectedRange.Id) * -1 }).Convert <CreateOrderModel>();
PrintOrderMaster.Source = newPrintOrder.Convert <CreateOrderModel>();
GetDetails(PrintOrderMaster.Source, db);
}
if (IndexRefreshing == -1 || IndexRefreshing == 2)
{
newPaymentOrder = new MutableObservableCollection <CreateOrderModel>();
newPaymentOrder = db.Query <CreateOrderModel>("GetFinishedOrder", new { Between = Convert.ToInt32(selectedRange.Id) * -1 }).Convert <CreateOrderModel>();
PaymentOrderMaster.Source = newPaymentOrder.Convert <CreateOrderModel>();
GetDetails(PaymentOrderMaster.Source, db);
}
if (IndexRefreshing == -1 || IndexRefreshing == 3)
{
newQueue = new MutableObservableCollection <CreateOrderModel>();
newQueue = db.Query <CreateOrderModel>("GetQueue", new { Between = Convert.ToInt32(selectedRange.Id) * -1 }).Convert <CreateOrderModel>();
QueueMaster.Source = newQueue.Convert <CreateOrderModel>();
GetDetails(QueueMaster.Source, db);
}
if (string.IsNullOrEmpty(searchInput))
{
if (IndexRefreshing == -1 || IndexRefreshing == 1)
{
PaymentOrder.CheckedHeader = false;
PrintOrder.Source = newPrintOrder;
GetDetails(PrintOrder.Source, db);
}
if (IndexRefreshing == -1 || IndexRefreshing == 1)
{
PrintOrder.CheckedHeader = false;
PaymentOrder.Source = newPaymentOrder;
GetDetails(PaymentOrder.Source, db);
}
if (IndexRefreshing == -1 || IndexRefreshing == 1)
{
Queue.CheckedHeader = false;
Queue.Source = newQueue;
GetDetails(Queue.Source, db);
}
}
db.Close();
}
public BaseMessageViewModel()
{
MarkAsUnreadCommand = new DelegateCommand <object>(new Action <object>(OnMarkAsUnread));
MarkAsReadCommand = new DelegateCommand <object>(new Action <object>(OnMarkAsRead));
MouseDoubleClickCommand = new DelegateCommand <object>(new Action <object>(OnMouseDoubleClick));
DeleteCommand = new DelegateCommand <string>(new Action <string>(OnDelete));
MarkAsSpamCommand = new DelegateCommand <string>(new Action <string>(OnMarkAsSpam));
ReplyCommand = new DelegateCommand <object>(new Action <object>(OnReply));
CheckedHeaderCommand = new DelegateCommand <object>(new Action <object>(OnCheckedHeader));
CheckedRowCommand = new DelegateCommand <object>(new Action <object>(OnCheckedRow));
SelectionChangedCommand = new DelegateCommand <IList>(new Action <IList>(OnSelectionChangedCommand));
PermanentlyDeleteCommand = new DelegateCommand(new Action(OnPermanentlyDelete));
RestoreCommand = new DelegateCommand(new Action(OnRestore));
ForwardCommand = new DelegateCommand <object>(new Action <object>(OnForward));
SelectableRow = new MutableObservableCollection <BaseDataRow>();
}
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();
}
private void OnCheckedRow(object args)
{
MutableObservableCollection <object> listArgs;
if (args.GetType() == typeof(List <ComposeMessageModel>))
{
listArgs = new MutableObservableCollection <object>((MutableObservableCollection <BaseBindableModel>)args);
}
else if (args.GetType() == typeof(MutableObservableCollection <Inbox>))
{
listArgs = new MutableObservableCollection <object>((MutableObservableCollection <Inbox>)args);
}
else if (args.GetType() == typeof(MutableObservableCollection <ComposeMessageModel>))
{
listArgs = new MutableObservableCollection <object>((MutableObservableCollection <ComposeMessageModel>)args);
}
else if (args.GetType() == typeof(MutableObservableCollection <Outbox>))
{
listArgs = new MutableObservableCollection <object>((MutableObservableCollection <Outbox>)args);
}
else if (args.GetType() == typeof(MutableObservableCollection <Trash>))
{
listArgs = new MutableObservableCollection <object>((MutableObservableCollection <Trash>)args);
}
else
{
listArgs = new MutableObservableCollection <object>((MutableObservableCollection <BaseMessageModel>)args);
}
SelectableRow.Clear();
foreach (BaseDataRow message in listArgs.ToList())
{
if (message.IsSelected)
{
SelectableRow.Add(message);
}
else
{
SelectableRow.Remove(message);
}
}
}
private void GetDetails(MutableObservableCollection <CreateOrderModel> source, IDataCommand db)
{
List <CreateOrderDetailModel> details;
foreach (CreateOrderModel order in source.ToList())
{
order.NewOrder = false;
details = db.Query <CreateOrderDetailModel>("GetOrderDetail", new { OrderId = order.PoNumber });
if (details.Any())
{
order.Details.Source = details.Convert <CreateOrderDetailModel>();
foreach (CreateOrderDetailModel detail in order.Details.Source.ToList())
{
detail.Finishing = db.Query <KeyValueOption>("GetFinishing");
detail.Size = db.Query <KeyValueOption>("GetSize");
detail.Quality = ObjectPool.Instance.Resolve <List <QualityType> >();
detail.MaterialMaster = db.Query <MaterialType>("GetMaterial");
detail.Material = detail.MaterialMaster.GroupBy(x => x.Id).Select(d => d.First()).ToList();
}
}
}
}
/// <summary>
/// Filters the source by the specified search text.
/// </summary>
/// <param name="source">The songs to search.</param>
/// <param name="searchText">The search text.</param>
/// <returns>The filtered sequence of songs.</returns>
public static MutableObservableCollection<TransactionStock> Filter(MutableObservableCollection<TransactionStock> source, string searchText)
{
if (String.IsNullOrWhiteSpace(searchText))
return source;
IEnumerable<string> keyWords = searchText.Split(' ');
return source
.AsParallel()
.Where
(
item => keyWords.All
(
keyword =>
item.MaterialName.ContainsIgnoreCase(keyword) ||
item.QualityName.ContainsIgnoreCase(keyword) ||
item.SupplierName.ContainsIgnoreCase(keyword) ||
item.Qty.LessThanOrEqual(keyword) ||
item.CreatedDate.ToString("dd-MMM-YYYY").ContainsIgnoreCase(keyword)
)
)
.Convert<TransactionStock>();
}
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();
}
private void Details_DataChanged(object sender, MutableObservableCollection <CreateOrderDetailModel> e)
{
NotifyDetailHeader();
}
public CreateOrderDetailCollectionViewSource()
{
Source = new MutableObservableCollection <CreateOrderDetailModel>();
}
public FinishedOrderCollectionViewSource()
{
Source = new MutableObservableCollection <CreateOrderModel>();
}
public InboxCollectionViewSource()
{
Source = new MutableObservableCollection <Inbox>();
}
public void Pull()
{
IDbManager dbManager = ObjectPool.Instance.Resolve<IDbManager>();
IDataCommand db = dbManager.GetDatabase(ApplicationSettings.Instance.Database.DefaultConnection.Name);
MutableObservableCollection<CreateOrderModel> newPaymentOrder = new MutableObservableCollection<CreateOrderModel>();
MutableObservableCollection<CreateOrderModel> newPrintOrder = new MutableObservableCollection<CreateOrderModel>();
MutableObservableCollection<CreateOrderModel> newQueue = new MutableObservableCollection<CreateOrderModel>();
KeyValueOption selectedRange = this.SelectedRange;
if (IndexRefreshing == -1 || IndexRefreshing == 1)
{
newPrintOrder = new MutableObservableCollection<CreateOrderModel>();
newPrintOrder = db.Query<CreateOrderModel>("GetPrintOrder", new { Between = Convert.ToInt32(selectedRange.Id) * -1 }).Convert<CreateOrderModel>();
PrintOrderMaster.Source = newPrintOrder.Convert<CreateOrderModel>();
GetDetails(PrintOrderMaster.Source, db);
}
if (IndexRefreshing == -1 || IndexRefreshing == 2)
{
newPaymentOrder = new MutableObservableCollection<CreateOrderModel>();
newPaymentOrder = db.Query<CreateOrderModel>("GetFinishedOrder", new { Between = Convert.ToInt32(selectedRange.Id) * -1 }).Convert<CreateOrderModel>();
PaymentOrderMaster.Source = newPaymentOrder.Convert<CreateOrderModel>();
GetDetails(PaymentOrderMaster.Source, db);
}
if (IndexRefreshing == -1 || IndexRefreshing == 3)
{
newQueue = new MutableObservableCollection<CreateOrderModel>();
newQueue = db.Query<CreateOrderModel>("GetQueue", new { Between = Convert.ToInt32(selectedRange.Id) * -1 }).Convert<CreateOrderModel>();
QueueMaster.Source = newQueue.Convert<CreateOrderModel>();
GetDetails(QueueMaster.Source, db);
}
if (string.IsNullOrEmpty(searchInput))
{
if (IndexRefreshing == -1 || IndexRefreshing == 1)
{
PaymentOrder.CheckedHeader = false;
PrintOrder.Source = newPrintOrder;
GetDetails(PrintOrder.Source, db);
}
if (IndexRefreshing == -1 || IndexRefreshing == 1)
{
PrintOrder.CheckedHeader = false;
PaymentOrder.Source = newPaymentOrder;
GetDetails(PaymentOrder.Source, db);
}
if (IndexRefreshing == -1 || IndexRefreshing == 1)
{
Queue.CheckedHeader = false;
Queue.Source = newQueue;
GetDetails(Queue.Source, db);
}
}
db.Close();
}
private void Details_DataChanged(object sender, MutableObservableCollection<CreateOrderDetailModel> e)
{
NotifyDetailHeader();
}
public SpamCollectionViewSource()
{
Source = new MutableObservableCollection <Spam>();
}
public TrashCollectionViewSource()
{
Source = new MutableObservableCollection <Trash>();
}
private void GetDetails(MutableObservableCollection<CreateOrderModel> source, IDataCommand db)
{
List<CreateOrderDetailModel> details;
foreach (CreateOrderModel order in source.ToList())
{
order.NewOrder = false;
details = db.Query<CreateOrderDetailModel>("GetOrderDetail", new { OrderId = order.PoNumber });
if (details.Any())
{
order.Details.Source = details.Convert<CreateOrderDetailModel>();
foreach (CreateOrderDetailModel detail in order.Details.Source.ToList())
{
detail.Finishing = db.Query<KeyValueOption>("GetFinishing");
detail.Size = db.Query<KeyValueOption>("GetSize");
detail.Quality = ObjectPool.Instance.Resolve<List<QualityType>>();
detail.MaterialMaster = db.Query<MaterialType>("GetMaterial");
detail.Material = detail.MaterialMaster.GroupBy(x => x.Id).Select(d => d.First()).ToList();
}
}
}
}
public BaseQueueCollectionSource(string sql, params object[] args)
{
Source = new MutableObservableCollection <ComposeMessageModel>();
this.sql = sql;
this.args = args;
}
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;
}
public SeriesData()
{
Items = new MutableObservableCollection <T>();
}
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();
}
