public ActionResult Shifts(int id)
{
List <Models.Shift> shifts = new List <Models.Shift>();
using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString))
{
connection.Open();
String sql = "Select * From Shift WHERE EventId = " + id;
using (SqlCommand command = new SqlCommand(sql, connection))
{
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
var s = new Models.Shift();
s.Id = Convert.ToInt32(reader["id"]);
s.EventId = Convert.ToInt32(reader["EventId"]);
s.UserId = Convert.ToInt32(reader["UserId"]);
s.StartTime = Convert.ToDateTime(reader["StartTime"]);
s.EndTime = s.StartTime.AddHours(2); //Convert.ToDateTime(reader["EndTime"]);
shifts.Add(s);
}
}
}
}
return(View());
}
/// <summary>
/// Initializes a new instance of the <see cref="GetShiftResponse"/> class.
/// </summary>
/// <param name="shift">shift.</param>
/// <param name="errors">errors.</param>
public GetShiftResponse(
Models.Shift shift = null,
IList <Models.Error> errors = null)
{
this.Shift = shift;
this.Errors = errors;
}
/// <summary>
/// Initializes a new instance of the <see cref="CreateShiftRequest"/> class.
/// </summary>
/// <param name="shift">shift.</param>
/// <param name="idempotencyKey">idempotency_key.</param>
public CreateShiftRequest(
Models.Shift shift,
string idempotencyKey = null)
{
this.IdempotencyKey = idempotencyKey;
this.Shift = shift;
}
public decimal GetHourlyWage(Models.Shift shift)
{
var hours = GetHoursWorked(shift);
// Prevent division by zero.
if (hours > 0)
{
return(shift.TotalTips / (decimal)GetHoursWorked(shift));
}
// Return the total tips if there was zero hours worked.
return(shift.TotalTips);
}
/// <summary>
/// Shift.
/// </summary>
/// <param name="shift"> shift. </param>
/// <returns> Builder. </returns>
public Builder Shift(Models.Shift shift)
{
this.shift = shift;
return(this);
}
public UpdateShiftResponse(Models.Shift shift = null,
IList <Models.Error> errors = null)
{
Shift = shift;
Errors = errors;
}
public Builder(Models.Shift shift)
{
this.shift = shift;
}
public UpdateShiftRequest(Models.Shift shift)
{
Shift = shift;
}
public Builder Shift(Models.Shift value)
{
shift = value;
return(this);
}
public double GetHoursWorked(Models.Shift shift)
{
return((shift.End - shift.Start).TotalHours);
}
public decimal GetTipout(Models.Shift shift, int percentage = 10)
{
return(Math.Round((shift.TotalTips * percentage) / 100, 2, MidpointRounding.AwayFromZero));
}
