//Loads the available contracts form and closes the selection form
private void available_contracts_btn_Click(object sender, EventArgs e)
{
AvailableContracts newAvailableContractsForm = new AvailableContracts();
newAvailableContractsForm.Show();
this.Close();
}
//Close this form and return the user to the Available Contracts form
private void exit_btn_Click_1(object sender, EventArgs e)
{
AvailableContracts newAvailableContracts = new AvailableContracts();
newAvailableContracts.Show();
this.Close();
}
//Constructor used to load from the Contract table
public ContractInfo(String contractNumber)
{
InitializeComponent();
selectedContractNumber = contractNumber;
source = @"Data Source=(LocalDB)\v11.0;AttachDbFilename=" + dbPath + ";Integrated Security=True;Connect Timeout=30";
conn = new SqlConnection(source);
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "spLoadContractDetails";
SqlDataReader reader;
cmd.Parameters.AddWithValue("@ContractNumber", selectedContractNumber).Direction = ParameterDirection.Input;
cmd.Parameters.Add("@DueDate", SqlDbType.Date).Direction = ParameterDirection.Output;
cmd.Parameters.Add("@EntryDate", SqlDbType.Date).Direction = ParameterDirection.Output;
cmd.Parameters.Add("@ExpectedCompletionDate", SqlDbType.Date).Direction = ParameterDirection.Output;
cmd.Parameters.Add("@CurrentLocation", SqlDbType.VarChar, 3).Direction = ParameterDirection.Output;
cmd.Parameters.Add("@StartLocation", SqlDbType.VarChar, 3).Direction = ParameterDirection.Output;
cmd.Parameters.Add("@NecessaryProcesses", SqlDbType.VarChar, 100).Direction = ParameterDirection.Output;
cmd.Parameters.Add("@Selected", SqlDbType.VarChar, 1).Direction = ParameterDirection.Output;
{
conn.Open();
reader = cmd.ExecuteReader();
if (reader.HasRows)
{
//Load all of the details into the form
reader.Read();
selectedDueDate = (System.DateTime)reader.GetValue(0);
selectedEntryDate = (System.DateTime)reader.GetValue(1);
selectedExpectedCompletionDate = (System.DateTime)reader.GetValue(2);
selectedCurrentLocation = (String)reader.GetValue(3);
selectedStartLocation = (String)reader.GetValue(4);
selectedProcesses = (String)reader.GetValue(5);
selectedBusy = (String)reader.GetValue(6);
conn.Close();
cmd.Parameters.Clear();
reader.Close();
this.Show();
}
else
{
MessageBox.Show("Contract Not Found");
AvailableContracts newAvailableContracts = new AvailableContracts();
newAvailableContracts.Show();
conn.Close();
cmd.Parameters.Clear();
}
}
}
