public async Task <IActionResult> Create(GroupSubscriptionModel model)
{
var username = ApplicationUtility.GetTokenAttribute(Request.Headers["Authorization"], "sub");
var service = new StudentClassificationRepository(connString);
await service.CreateGroupSubscription(model, username);
var response = new GenericResponse <string>()
{
IsSuccess = true,
Message = "Group subscription created successfully.",
ResponseCode = 200,
Result = "Success"
};
return(Ok(response));
}
/// <summary>
///
/// </summary>
/// <param name="model"></param>
/// <param name="actor"></param>
/// <returns></returns>
public async Task CreateGroupSubscription(GroupSubscriptionModel model, string actor)
{
try
{
await _connection.OpenAsync();
var cmd = new MySqlCommand("Create_GroupSubscription", _connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("UserIdVal", model.Userid);
cmd.Parameters.AddWithValue("GroupIdVal", model.GroupId);
cmd.Parameters.AddWithValue("StartDateVal", model.StartDate);
cmd.Parameters.AddWithValue("CreatedByValue", actor);
cmd.ExecuteNonQuery();
}
catch { throw; }
finally { await _connection.CloseAsync(); }
}
