/// <summary> /// Create a new Time object. /// </summary> /// <param name="timeId">Initial value of the TimeId property.</param> /// <param name="timeGuid">Initial value of the TimeGuid property.</param> /// <param name="dateCreated">Initial value of the DateCreated property.</param> /// <param name="dateModified">Initial value of the DateModified property.</param> /// <param name="createdBy">Initial value of the CreatedBy property.</param> /// <param name="modifiedBy">Initial value of the ModifiedBy property.</param> /// <param name="timeDate">Initial value of the TimeDate property.</param> /// <param name="clientWeekId">Initial value of the ClientWeekId property.</param> /// <param name="studentId">Initial value of the StudentId property.</param> /// <param name="hoursWorked">Initial value of the HoursWorked property.</param> /// <param name="payRate">Initial value of the PayRate property.</param> public static Time CreateTime(global::System.Int32 timeId, global::System.Guid timeGuid, global::System.DateTime dateCreated, global::System.DateTime dateModified, global::System.String createdBy, global::System.String modifiedBy, global::System.DateTime timeDate, global::System.Int32 clientWeekId, global::System.Int32 studentId, global::System.Decimal hoursWorked, global::System.Decimal payRate) { Time time = new Time(); time.TimeId = timeId; time.TimeGuid = timeGuid; time.DateCreated = dateCreated; time.DateModified = dateModified; time.CreatedBy = createdBy; time.ModifiedBy = modifiedBy; time.TimeDate = timeDate; time.ClientWeekId = clientWeekId; time.StudentId = studentId; time.HoursWorked = hoursWorked; time.PayRate = payRate; return time; }
/// <summary> /// Deprecated Method for adding a new object to the Times EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddToTimes(Time time) { base.AddObject("Times", time); }
protected void btnSave_Click(object sender, EventArgs e) { DateTime weekEnding = DateTime.Parse(tbWeekEnding.Text); int studentId = int.Parse(hidEmployeeID.Value); int clientId = int.Parse(hidClientID.Value); Client cl; Week wk; if (cw.ClientId != clientId) { cl = t.Clients.Single(f => f.ClientId == clientId); wk = setupWeek(weekEnding); setupClientWeek(cl, wk); removeOldTimes(studentId, cw); } else if (Request.QueryString.AllKeys.Contains("ClientWeek")) { Guid cwGuid = Guid.Parse(Request.QueryString["ClientWeek"]); cw = t.ClientWeeks.Single(f => f.ClientWeekGuid == cwGuid); cl = cw.Client; wk = cw.Week; } else { wk = setupWeek(weekEnding); int selectedClientId = int.Parse(hidClientID.Value); cl = t.Clients.Single(f => f.ClientId == selectedClientId); setupClientWeek(cl, wk); } decimal payRate = 0.0m; decimal.TryParse(tbPayRate.Text, out payRate); Time mon = t.Times.SingleOrDefault(f => f.ClientWeekId == cw.ClientWeekId && f.StudentId == studentId && f.DayOfWeek == 1); if (mon == default(Time)) { mon = new Time(); mon.ClientWeekId = cw.ClientWeekId; mon.CreatedBy = "davide"; mon.ModifiedBy = "davide"; mon.DateModified = DateTime.Now; mon.DateCreated = DateTime.Now; mon.StudentId = studentId; mon.TimeDate = weekEnding.AddDays(-6); mon.DayOfWeek = 1; mon.TimeGuid = Guid.NewGuid(); t.Times.AddObject(mon); } decimal hoursMonday = 0.0m; decimal.TryParse(tbHoursMonday.Text, out hoursMonday); mon.HoursWorked = hoursMonday; mon.PayRate = payRate; Time tue = t.Times.SingleOrDefault(f => f.ClientWeekId == cw.ClientWeekId && f.StudentId == studentId && f.DayOfWeek == 2); if (tue == default(Time)) { tue = new Time(); tue.ClientWeekId = cw.ClientWeekId; tue.CreatedBy = "davide"; tue.ModifiedBy = "davide"; tue.DateModified = DateTime.Now; tue.DateCreated = DateTime.Now; tue.StudentId = studentId; tue.TimeDate = weekEnding.AddDays(-5); tue.DayOfWeek = 2; tue.TimeGuid = Guid.NewGuid(); t.Times.AddObject(tue); } decimal hoursTuesday = 0.0m; decimal.TryParse(tbHoursTuesday.Text, out hoursTuesday); tue.HoursWorked = hoursTuesday; tue.PayRate = payRate; Time wed = t.Times.SingleOrDefault(f => f.ClientWeekId == cw.ClientWeekId && f.StudentId == studentId && f.DayOfWeek == 3); if (wed == default(Time)) { wed = new Time(); wed.ClientWeekId = cw.ClientWeekId; wed.CreatedBy = "davide"; wed.ModifiedBy = "davide"; wed.DateModified = DateTime.Now; wed.DateCreated = DateTime.Now; wed.StudentId = studentId; wed.TimeDate = weekEnding.AddDays(-4); wed.DayOfWeek = 3; wed.TimeGuid = Guid.NewGuid(); t.Times.AddObject(wed); } decimal hoursWednesday = 0.0m; decimal.TryParse(tbHoursWednesday.Text, out hoursWednesday); wed.HoursWorked = hoursWednesday; wed.PayRate = payRate; Time thur = t.Times.SingleOrDefault(f => f.ClientWeekId == cw.ClientWeekId && f.StudentId == studentId && f.DayOfWeek == 4); if (thur == default(Time)) { thur = new Time(); thur.ClientWeekId = cw.ClientWeekId; thur.CreatedBy = "davide"; thur.ModifiedBy = "davide"; thur.DateModified = DateTime.Now; thur.DateCreated = DateTime.Now; thur.StudentId = studentId; thur.TimeDate = weekEnding.AddDays(-3); thur.DayOfWeek = 4; thur.TimeGuid = Guid.NewGuid(); t.Times.AddObject(thur); } decimal hoursThursday = 0.0m; decimal.TryParse(tbHoursThursday.Text, out hoursThursday); thur.HoursWorked = hoursThursday; thur.PayRate = payRate; Time fri = t.Times.SingleOrDefault(f => f.ClientWeekId == cw.ClientWeekId && f.StudentId == studentId && f.DayOfWeek == 5); if (fri == default(Time)) { fri = new Time(); fri.ClientWeekId = cw.ClientWeekId; fri.CreatedBy = "davide"; fri.ModifiedBy = "davide"; fri.DateModified = DateTime.Now; fri.DateCreated = DateTime.Now; fri.StudentId = studentId; fri.TimeDate = weekEnding.AddDays(-2); fri.DayOfWeek = 5; fri.TimeGuid = Guid.NewGuid(); t.Times.AddObject(fri); } decimal hoursFriday = 0.0m; decimal.TryParse(tbHoursFriday.Text, out hoursFriday); fri.HoursWorked = hoursFriday; fri.PayRate = payRate; Time sat = t.Times.SingleOrDefault(f => f.ClientWeekId == cw.ClientWeekId && f.StudentId == studentId && f.DayOfWeek == 6); if (sat == default(Time)) { sat = new Time(); sat.ClientWeekId = cw.ClientWeekId; sat.CreatedBy = "davide"; sat.ModifiedBy = "davide"; sat.DateModified = DateTime.Now; sat.DateCreated = DateTime.Now; sat.StudentId = studentId; sat.TimeDate = weekEnding.AddDays(-1); sat.DayOfWeek = 6; sat.TimeGuid = Guid.NewGuid(); t.Times.AddObject(sat); } decimal hoursSaturday = 0.0m; decimal.TryParse(tbHoursSaturday.Text, out hoursSaturday); sat.HoursWorked = hoursSaturday; sat.PayRate = payRate; Time sun = t.Times.SingleOrDefault(f => f.ClientWeekId == cw.ClientWeekId && f.StudentId == studentId && f.DayOfWeek == 7); if (sun == default(Time)) { sun = new Time(); sun.ClientWeekId = cw.ClientWeekId; sun.CreatedBy = "davide"; sun.ModifiedBy = "davide"; sun.DateModified = DateTime.Now; sun.DateCreated = DateTime.Now; sun.StudentId = studentId; sun.TimeDate = weekEnding; sun.DayOfWeek = 7; sun.TimeGuid = Guid.NewGuid(); t.Times.AddObject(sun); } decimal hoursSunday = 0.0m; decimal.TryParse(tbHoursSunday.Text, out hoursSunday); sun.HoursWorked = hoursSunday; sun.PayRate = payRate; t.SaveChanges(); initSearch(); initTimes(); Response.Redirect(string.Format("TimeSheetEntry.aspx?ClientWeek={0}", cw.ClientWeekGuid),false); }