private void AddMedicalDoc() { var MedicalDoc = new MedicalDoc(); MedicalDoc.Comment = Comment; MedicalDoc.DateStart = DateStart; MedicalDoc.DateEnd = DateEnd; MedicalDoc.Person_ID = SelectedStudent.Person.ID; using (var _context = new ApplicationContext()) { var newEndDate = DateEnd.AddDays(1).Date; Journals = new ObservableCollection <Journal>(_context.Journals .Where(x => x.Date >= DateStart.Date && x.Date < newEndDate) .Where(x => x.Student.Person_ID == SelectedStudent.Person.ID) .Where(x => x.Assessment.Type == 1) .Include(x => x.Student) .Include(x => x.Assessment)); var RespectfulReason = _context.Assessments.Where(x => x.Type == 2).FirstOrDefault(); foreach (var item in Journals) { item.Assessment = RespectfulReason; _context.Entry(item).State = EntityState.Modified; } _context.MedicalDocs.Add(MedicalDoc); _context.SaveChanges(); EventsManager.RaiseObjectChangedEvent(MedicalDoc, ChangeType.Added); } }
private void ButtonDateSelect_Click(object sender, RoutedEventArgs e) { string param = (sender as Button).Tag.ToString(); if (param.Equals("EquateEndDateToBeginDate")) { DateEnd = DateBegin; } else if (param.Equals("SetDatesToCurrentDay")) { DateBegin = DateTime.Now; DateEnd = DateBegin; } else if (param.Equals("SetDatesToCurrentWeek")) { DateEnd = DateTime.Now; int dayOfWeek = (int)DateEnd.DayOfWeek; if (dayOfWeek == 0) { dayOfWeek = 7; } DateBegin = DateEnd.AddDays(-1 * (dayOfWeek - 1)); } else if (param.Equals("SetDatesToCurrentMonth")) { DateBegin = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1); DateEnd = DateBegin.AddDays(DateTime.DaysInMonth(DateTime.Now.Year, DateTime.Now.Month) - 1); } else if (param.Equals("SetDatesToCurrentYear")) { DateBegin = new DateTime(DateTime.Now.Year, 1, 1); DateEnd = new DateTime(DateTime.Now.Year, 12, DateTime.DaysInMonth(DateTime.Now.Year, 12)); } else if (param.Equals("GoToPreviousMonth")) { DateEnd = new DateTime(DateBegin.Year, DateBegin.Month, 1).AddDays(-1); DateBegin = DateEnd.AddDays(-1 * (DateTime.DaysInMonth(DateEnd.Year, DateEnd.Month) - 1)); } else if (param.Equals("GoToPreviousDay")) { DateBegin = DateBegin.AddDays(-1); DateEnd = DateBegin; } else if (param.Equals("GoToNextDay")) { DateBegin = DateBegin.AddDays(1); DateEnd = DateBegin; } else if (param.Equals("GoToNextMonth")) { DateBegin = new DateTime(DateBegin.Year, DateBegin.Month, DateTime.DaysInMonth(DateBegin.Year, DateBegin.Month)).AddDays(1); DateEnd = DateBegin.AddDays((DateTime.DaysInMonth(DateBegin.Year, DateBegin.Month) - 1)); } }
public void Load(SqlConnection connection) { Clear(); if (DateBegin == DateEnd) { DateEnd = DateEnd.AddDays(1); } var param = new List <KeyValuePair <string, object> >(); param.Add(new KeyValuePair <string, object>("(GoodsDate >= @0", DateBegin)); param.Add(new KeyValuePair <string, object>("and GoodsDate <= @1)", DateEnd)); if (!string.IsNullOrEmpty(ShopCode)) { param.Add(new KeyValuePair <string, object>(string.Format("and (ShopCode == @{0})", param.Count), ShopCode)); } if (!string.IsNullOrEmpty(Group)) { param.Add(new KeyValuePair <string, object>(string.Format("and (Group == @{0})", param.Count), Group)); } if (!string.IsNullOrEmpty(Supplier)) { param.Add(new KeyValuePair <string, object>(string.Format("and (Supplier == @{0})", param.Count), Supplier)); } if (!string.IsNullOrEmpty(Barcode)) { param.Add(new KeyValuePair <string, object>(string.Format("and (Barcode == @{0})", param.Count), Barcode)); } var arr = param.Select(p => p.Value).ToArray(); var str = string.Join(" ", param.Select(p => p.Key).ToArray()); using (var cn = ReportData.GetContext(connection)) { var dt = cn.vReportOrdersByShops.Where(str, arr); foreach (var item in dt) { Add(item); } } }