public static void InsertTrainingRequest(TrainingRequest TrainingRequest) { using (SqlConnection connection = new SqlConnection(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString)) { SqlCommand insertCommand = new SqlCommand("INSERT INTO TrainingRequests (TrainingID, UserID, Status) VALUES (@TrainingID, @UserID, 0)", connection); insertCommand.Parameters.AddWithValue("@UserID", TrainingRequest.UserID); insertCommand.Parameters.AddWithValue("@TrainingID", TrainingRequest.TrainingID); connection.Open(); insertCommand.ExecuteNonQuery(); } }
public static void UpdateTrainingRequest(TrainingRequest TrainingRequest) { using (SqlConnection connection = new SqlConnection(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString)) { SqlCommand updateCommand = new SqlCommand("UPDATE [TrainingRequests] SET [TrainingID] = @TrainingID, [UserID] = @UserID, Status = @Status WHERE [ID] = @ID", connection); updateCommand.Parameters.AddWithValue("@UserID", TrainingRequest.UserID); updateCommand.Parameters.AddWithValue("@TrainingID", TrainingRequest.TrainingID); updateCommand.Parameters.AddWithValue("@Status", TrainingRequest.Status); updateCommand.Parameters.AddWithValue("@ID", TrainingRequest.ID); connection.Open(); updateCommand.ExecuteNonQuery(); } }