public async Task <IActionResult> Put(int id, InstitutionModelUpdate model)
{
var username = ApplicationUtility.GetTokenAttribute(Request.Headers["Authorization"], "sub");
model.Actor = username;
var service = new InstituteRepositoryService(connString);
await service.UpdateInstitute(model, id);
var response = new GenericResponse <string>()
{
IsSuccess = true,
Message = "Institute updated successfully.",
ResponseCode = 200,
Result = "Success"
};
return(Ok(response));
}
public async Task UpdateInstitute(InstitutionModelUpdate model, int ID)
{
try
{
await _connection.OpenAsync();
var cmd = new MySqlCommand("Update_Institute", _connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("instituteId", ID);
cmd.Parameters.AddWithValue("InstituteName", model.Name);
cmd.Parameters.AddWithValue("InstituteBranch", model.BranchName);
cmd.Parameters.AddWithValue("InstituteDescription", model.Description);
cmd.Parameters.AddWithValue("BoardId", model.BoardId);
cmd.Parameters.AddWithValue("TypeId", model.TypeId);
cmd.Parameters.AddWithValue("ModifiedBy", model.Actor);
cmd.ExecuteNonQuery();
}
catch { throw; }
finally { await _connection.CloseAsync(); }
}
