private void frmOrderedList_Load(object sender, EventArgs e)
{
wTypeList.Properties.DataSource = new List <object>()
{
new { Id = 0, Name = "Усі" }
}.Concat(new BaseEntities().DocType.Where(w => w.Id == 16 || w.Id == -16).Select(s => new { s.Id, s.Name })).ToList();
wTypeList.EditValue = _w_type;
KagentComboBox.Properties.DataSource = DBHelper.KagentsList;// new List<object>() { new { KaId = 0, Name = "Усі" } }.Concat(new BaseEntities().Kagent.Where(w => w.Archived == null || w.Archived == 0).Select(s => new { s.KaId, s.Name }));
KagentComboBox.EditValue = _ka_id;
MatComboBox.Properties.DataSource = new List <object>()
{
new { MatId = 0, Name = "Усі" }
}.Concat(new BaseEntities().Materials.Where(w => w.Deleted == 0).Select(s => new { s.MatId, s.Name }).ToList());
MatComboBox.EditValue = _mat_id;
wbStatusList.Properties.DataSource = new List <object>()
{
new { Id = 0, Name = "Усі замовлення" }, new { Id = 1, Name = "Тільки активні" }
};
wbStatusList.EditValue = 0;
wbStartDate.DateTime = DateTimeDayOfMonthExtensions.FirstDayOfMonth(DateTime.Now);
wbEndDate.DateTime = DateTime.Now.AddDays(1);
GetOrderedList();
}
private void frmKABalans_Load(object sender, EventArgs e)
{
wTypeList.Properties.DataSource = new List <object>()
{
new { Id = 0, Name = "Усі" }
}.Concat(new BaseEntities().DocType.Select(s => new { s.Id, s.Name })).ToList();
wTypeList.EditValue = 0;
wbStartDate.DateTime = DateTimeDayOfMonthExtensions.FirstDayOfMonth(DateTime.Now);
wbEndDate.DateTime = DateTime.Now.AddDays(1);
GetBalans();
}
public async Task <IEnumerable <UrlStatistic> > GetCountFromActualMonthForUserAsync(string userid)
{
var results = await _appDbContext.UrlStatistics.Where
(
stat =>
(
(DateTimeDayOfMonthExtensions.Between(stat.EventDate, DateTimeDayOfMonthExtensions.FirstDayOfMonth(stat.EventDate), DateTimeDayOfMonthExtensions.LastDayOfMonth(stat.EventDate)))
&&
(stat.Link.AdOwner.Id == userid)
)
).ToListAsync();
return(results);
}
private void SetDate()
{
switch (xtraTabControl1.SelectedTabPageIndex)
{
case 1:
StartDateEdit.DateTime = DateTime.Parse("01." + Convert.ToString(MonthEdit.SelectedIndex + 1) + "." + Convert.ToString(YearEdit.Value));
EndDateEdit.DateTime = DateTimeDayOfMonthExtensions.LastDayOfMonth(StartDateEdit.DateTime);
break;
case 2:
string year = Convert.ToString(YearEdit2.Value);
switch (comboBoxEdit3.SelectedIndex)
{
case 0:
StartDateEdit.DateTime = DateTime.Parse("01.01." + year);
EndDateEdit.DateTime = DateTime.Parse("31.03." + year).SetEndDay();
break;
case 1:
StartDateEdit.DateTime = DateTime.Parse("01.04." + year);
EndDateEdit.DateTime = DateTime.Parse("30.06." + year).SetEndDay();
break;
case 2:
StartDateEdit.DateTime = DateTime.Parse("01.07." + year);
EndDateEdit.DateTime = DateTime.Parse("30.09." + year).SetEndDay();
break;
case 3:
StartDateEdit.DateTime = DateTime.Parse("01.10." + year);
EndDateEdit.DateTime = DateTime.Parse("31.12." + year).SetEndDay();
break;
}
break;
case 3:
StartDateEdit.DateTime = DateTime.Parse("01.01." + Convert.ToString(YearEdit3.Value));
EndDateEdit.DateTime = DateTime.Parse("31.12." + Convert.ToString(YearEdit3.Value)).SetEndDay();
break;
}
}
private void frmMatRSV_Load(object sender, EventArgs e)
{
on_load_form = true;
wTypeList.Properties.DataSource = new List <object>()
{
new { Id = 0, Name = "Усі" }
}.Concat(DBHelper.DocTypeList.Select(s => new { s.Id, s.Name })).ToList();
wTypeList.EditValue = 0;
KagentComboBox.Properties.DataSource = DBHelper.KagentsList;
KagentComboBox.EditValue = 0;
wbStartDate.DateTime = DateTimeDayOfMonthExtensions.FirstDayOfMonth(DateTime.Now);
wbEndDate.DateTime = DateTime.Now.AddDays(1);
Text = Text + "[ " + _db.Materials.Where(w => w.MatId == _mat_id).Select(s => s.Name).First() + " ]";
on_load_form = false;
GetRsv();
}
private void frmMatTurn_Load(object sender, EventArgs e)
{
wTypeList.Properties.DataSource = new List <object>()
{
new { Id = 0, Name = "Усі" }
}.Concat(new BaseEntities().DocType.Select(s => new { s.Id, s.Name })).ToList();
wTypeList.EditValue = 0;
KAgentEdit.Properties.DataSource = DBHelper.KagentsList;// new List<object>() { new { KaId = 0, Name = "Усі" } }.Concat(new BaseEntities().Kagent.Select(s => new { s.KaId, s.Name }));
KAgentEdit.EditValue = 0;
wbStartDate.DateTime = DateTimeDayOfMonthExtensions.FirstDayOfMonth(DateTime.Now);
wbEndDate.DateTime = DateTime.Now.AddDays(1);
var mat = new BaseEntities().Materials.Find(_mat_id);
if (mat != null)
{
this.Text = "Рух товару: " + mat.Name;
}
GetTurns();
}
