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(); } }