private async void SaveInvoiceBtn_Click(object sender, EventArgs e)
{
using (var context = new Models.TimeTrackerDBContext())
{
var invoice = new Models.TrackingInvoice();
invoice.Description = this.InvoiceDescription.Text;
invoice.IsPaid = false;
invoice.PeriodStartDate = this.FromDatePicker.Value.Value;
invoice.PeriodEndDate = this.ToDatePicker.Value.Value;
invoice.UserID = Tools.CurrentUser.ID;
context.TrackingInvoices.Add(invoice);
await context.SaveChangesAsync();
await context.Database.ExecuteSqlCommandAsync("UPDATE TimeTracking SET TrackingInvoiceID={0} where Date>={1} and Date<={2}", invoice.ID, invoice.PeriodStartDate, invoice.PeriodEndDate);
}
}
public void GetInvoiceList()
{
using (var context = new Models.TimeTrackerDBContext())
{
var list = (from invoice in context.TrackingInvoices
join user in context.Users on invoice.UserID equals user.ID
select new DataModel.InvoiceModel
{
ID = invoice.ID,
Description = invoice.Description,
IsPaid = invoice.IsPaid == false?"No":"Yes",
PeriodEndDateTime = invoice.PeriodEndDate,
PeriodStartDateTime = invoice.PeriodStartDate,
User = user.Username
}).ToList();
this.InvoiceGrid.DataSource = list;
}
}
private void SaveManualTracker()
{
using (var context = new Models.TimeTrackerDBContext())
{
var tracker = new Models.TimeTracking();
tracker.CreateDate = DateTime.Now;
tracker.Date = ManualDate.Value.Value;
var project = context.Projects.Where(o => o.ProjectName == this.ManualProjectCombo.SelectedItem.ToString()).FirstOrDefault();
tracker.ProjectID = project.ID;
tracker.HourCount = Convert.ToDouble(HoursNumeric.Value);
tracker.MinutesCount = Convert.ToDouble(MinutesNumeric.Value);
tracker.UserID = Tools.CurrentUser.ID;
tracker.Description = this.ManualDescTxt.Text;
context.TimeTrackings.Add(tracker);
context.SaveChanges();
MessageBox.Show("Tracker is saved.");
makefieldsEmptyInManual();
}
}
private void SaveAutoTracker()
{
using (var context = new Models.TimeTrackerDBContext())
{
TimeSpan elapsed = (DateTime.Now - StartTime) - PausedElapsedTime;
var tracker = new Models.TimeTracking();
tracker.CreateDate = DateTime.Now;
tracker.Date = DateTime.Now.Date;
var project = context.Projects.Where(o => o.ProjectName == this.ProjectComboBox.SelectedItem.ToString()).FirstOrDefault();
tracker.ProjectID = project.ID;
tracker.HourCount = elapsed.Hours;
tracker.MinutesCount = elapsed.Minutes;
tracker.UserID = Tools.CurrentUser.ID;
tracker.Description = this.DescriptionTxtBox.Text;
context.TimeTrackings.Add(tracker);
context.SaveChanges();
MessageBox.Show("Tracker is saved.");
makefieldsEmptyInAuto();
}
}
public void SetInvoiceFromDate()
{
using (var context = new Models.TimeTrackerDBContext())
{
var lastInvoice = context.TrackingInvoices.ToList().OrderByDescending(o => o.ID).FirstOrDefault();
if (lastInvoice != null)
{
this.FromDatePicker.Value = lastInvoice.PeriodEndDate;
this.ToDatePicker.Value = lastInvoice.PeriodEndDate.AddMonths(1);
}
else
{
var firsttrack = context.TimeTrackings.ToList().OrderBy(o => o.Date).FirstOrDefault();
if (firsttrack != null)
{
this.FromDatePicker.Value = firsttrack.Date;
this.ToDatePicker.Value = firsttrack.Date.AddMonths(1);
}
}
}
}
