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