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 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(); }