public List <Bussiness_Logic.Contract> GetAllContracts(int clientID)
{
List <Bussiness_Logic.Contract> contracts = new List <Bussiness_Logic.Contract>();
string query = $"SELECT * FROM [Contract] WHERE ClientID = {clientID}";
SqlConnection conn = new SqlConnection(connect);
SqlCommand command = new SqlCommand(query, conn);
try
{
conn.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
Bussiness_Logic.Contract contract = new Bussiness_Logic.Contract(reader.GetBoolean(3), reader.GetInt32(1), reader.GetInt32(2), reader.GetInt32(0));
contracts.Add(contract);
}
}
catch (Exception ex)
{
MessageBox.Show("Could not find contracts for this client " + ex.Message);
}
finally
{
conn.Close();
}
return(contracts);
}
private void btnSearch_Click(object sender, EventArgs e)
{
int searchID = int.Parse(txtSearchContract.Text);
Bussiness_Logic.Contract contract = new Bussiness_Logic.Contract();
bsContracts.DataSource = contract.SearchContract(searchID);
dgvClientContract.DataSource = bsContracts;
}
private void btnAddContract_Click(object sender, EventArgs e)
{
int packageId = int.Parse(txtPackageID.Text);
int clientID = int.Parse(txtClientID.Text);
int state = cmbAdd.Text == "Active" ? 1 : 0;
Bussiness_Logic.Contract contract = new Bussiness_Logic.Contract();
contract.CreateContract(packageId, clientID, state);
}
private void btnUpdateContract_Click(object sender, EventArgs e)
{
int contractID = int.Parse(txtContractID.Text);
int state = cmbUpdate.Text == "Active" ? 1 : 0;
Bussiness_Logic.Contract contract = new Bussiness_Logic.Contract();
contract.UpdateContract(contractID, state);
int searchID = int.Parse(txtSearchContract.Text);
bsContracts.DataSource = contract.SearchContract(searchID);
bsContracts.ResetBindings(true);
}
