public async Task AssignDuty([Required, FromBody] DutyAssignmentDTO dutyAssignmentDto)
{
List <Duty> dutyTypes = await DutyModel.GetDutyTypes();
dutyAssignmentDto.DateAssigned = DateTime.Now;
DutyAssignment dutyAssignment = DutyAssignment.ConvertDTO(dutyAssignmentDto, dutyTypes);
await DutyModel.AssignDuty(dutyAssignment);
}
/// <summary>
///
/// </summary>
/// <param name="dutyAssignment"></param>
/// <returns></returns>
public static async Task AssignDuty(DutyAssignment dutyAssignment)
{
using (LocalDB db = new LocalDB())
{
await db.OpenConnectionAsync();
MySqlCommand cmd = db.CreateCommand();
string query = "INSERT INTO duty_assignment (ResidentID, DutyType, DateStart, DateEnd, DateAssigned) " +
"VALUES (@ResidentID, @DutyType, @DateStart, @DateEnd, @DateAssigned)";
cmd.Parameters.AddWithValue("@ResidentID", dutyAssignment.ResidentID);
cmd.Parameters.AddWithValue("@DutyType", dutyAssignment.Duty.DutyType);
cmd.Parameters.AddWithValue("@DateStart", dutyAssignment.DateStart);
cmd.Parameters.AddWithValue("@DateEnd", dutyAssignment.DateEnd);
cmd.Parameters.AddWithValue("@DateAssigned", dutyAssignment.DateAssigned);
cmd.CommandText = query;
await cmd.ExecuteNonQueryAsync();
}
}