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