public async Task <IActionResult> Create(OptionalGroupModel model)
{
var username = ApplicationUtility.GetTokenAttribute(Request.Headers["Authorization"], "sub");
var service = new StudentClassificationRepository(connString);
await service.CreateGroup(model, username);
var response = new GenericResponse <string>()
{
IsSuccess = true,
Message = "Optional group created successfully.",
ResponseCode = 200,
Result = "Success"
};
return(Ok(response));
}
/// <summary>
///
/// </summary>
/// <param name="model"></param>
/// <param name="actor"></param>
/// <returns></returns>
public async Task CreateGroup(OptionalGroupModel model, string actor)
{
try
{
await _connection.OpenAsync();
var cmd = new MySqlCommand("Create_OptionalGroup", _connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("InstititueIdVal", model.InstituteId);
cmd.Parameters.AddWithValue("NameVal", model.Name);
cmd.Parameters.AddWithValue("DescriptionVal", model.Description);
cmd.Parameters.AddWithValue("CreatedByValue", actor);
cmd.ExecuteNonQuery();
}
catch { throw; }
finally { await _connection.CloseAsync(); }
}