Пример #1
0
 /// <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;
 }
Пример #2
0
 /// <summary>
 /// Deprecated Method for adding a new object to the Times EntitySet. Consider using the .Add method of the associated ObjectSet&lt;T&gt; property instead.
 /// </summary>
 public void AddToTimes(Time time)
 {
     base.AddObject("Times", time);
 }
Пример #3
0
        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);
        }