public IEnumerable <ContractOfSale> GetAll()
{
using (SqlConnection connection = new SqlConnection(Settings.Default.DBConnect))
{
connection.Open();
string sql = "SELECT * FROM ContractOfSale";
SqlCommand command = new SqlCommand(sql, connection);
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
ContractOfSale new_cos = new ContractOfSale();
new_cos.ContractOfSaleID = (Int32)reader.GetValue(0);
new_cos.ContractOfSaleBuyerID = (Int32)reader.GetValue(1);
new_cos.ContractOfSaleEstateID = (Int32)reader.GetValue(2);
new_cos.ContractOfSaleNumber = (string)reader.GetValue(3);
new_cos.ContractOfSaleDate = (DateTime)reader.GetValue(4);
new_cos.ContractOfSaleOwner = (string)reader.GetValue(5);
new_cos.ContractOfSaleBuyer = (string)reader.GetValue(6);
new_cos.ContractOfSaleCost = (double)reader.GetValue(7);
new_cos.ContractOfSaleEstateInventoryNumber = (string)reader.GetValue(8);
_cosCollection.Add(new_cos);
}
connection.Close();
}
return(_cosCollection);
}
}
public void UpdateContractOfSale(ContractOfSale cos)
{
using (SqlConnection connection = new SqlConnection(Settings.Default.DBConnect))
{
using (SqlCommand updateCommand = new SqlCommand("UPDATE ContractOfSale " +
"SET " +
"ContractOfSaleBuyerID = @ContractOfSaleBuyerID, " +
"ContractOfSaleEstateID = @ContractOfSaleEstateID, " +
"ContractOfSaleNumber = @ContractOfSaleNumber, " +
"ContractOfSaleDate = @ContractOfSaleDate, " +
"ContractOfSaleOwner = @ContractOfSaleOwner, " +
"ContractOfSaleBuyer = @ContractOfSaleBuyer, " +
"ContractOfSaleCost = @ContractOfSaleCost, " +
"WHERE ContractOfSaleID = @ContractOfSaleID", connection))
{
updateCommand.Parameters.Clear();
updateCommand.Parameters.AddWithValue("@ContractOfSaleBuyerID", typeof(string)).Value = cos.ContractOfSaleBuyerID;
updateCommand.Parameters.AddWithValue("@ContractOfSaleEstateID", typeof(string)).Value = cos.ContractOfSaleEstateID;
updateCommand.Parameters.AddWithValue("@ContractOfSaleNumber", typeof(string)).Value = cos.ContractOfSaleNumber;
updateCommand.Parameters.AddWithValue("@ContractOfSaleDate", typeof(string)).Value = cos.ContractOfSaleDate;
updateCommand.Parameters.AddWithValue("@ContractOfSaleOwner", typeof(string)).Value = cos.ContractOfSaleOwner;
updateCommand.Parameters.AddWithValue("@ContractOfSaleBuyer", typeof(string)).Value = cos.ContractOfSaleBuyer;
updateCommand.Parameters.AddWithValue("@ContractOfSaleCost", typeof(string)).Value = cos.ContractOfSaleCost;
connection.Open();
updateCommand.ExecuteNonQuery();
connection.Close();
}
}
}
public void AddContractOfSale(ContractOfSale cos)
{
using (SqlConnection connection = new SqlConnection(Settings.Default.DBConnect))
{
using (SqlCommand insertCommand = new SqlCommand("INSERT INTO ContractOfSale " +
"(ContractOfSaleID, ContractOfSaleBuyerID, ContractOfSaleEstateID, " +
"ContractOfSaleNumber, ContractOfSaleDate, ContractOfSaleOwner, " +
"ContractOfSaleBuyer, ContractOfSaleCost, ContractOfSaleEstateInventoryNumber) " +
"Values(@ContractOfSaleID, @ContractOfSaleBuyerID, @ContractOfSaleEstateID, " +
"@ContractOfSaleNumber, @ContractOfSaleDate, " +
"@ContractOfSaleOwner, @ContractOfSaleBuyer, " +
"@ContractOfSaleCost, @ContractOfSaleEstateInventoryNumber);", connection))
{
insertCommand.Parameters.Clear();
insertCommand.Parameters.AddWithValue("@ContractOfSaleID", typeof(string)).Value = cos.ContractOfSaleID;
insertCommand.Parameters.AddWithValue("@ContractOfSaleBuyerID", typeof(string)).Value = cos.ContractOfSaleBuyerID;
insertCommand.Parameters.AddWithValue("@ContractOfSaleEstateID", typeof(string)).Value = cos.ContractOfSaleEstateID;
insertCommand.Parameters.AddWithValue("@ContractOfSaleNumber", typeof(string)).Value = cos.ContractOfSaleNumber;
insertCommand.Parameters.AddWithValue("@ContractOfSaleDate", typeof(string)).Value = cos.ContractOfSaleDate;
insertCommand.Parameters.AddWithValue("@ContractOfSaleOwner", typeof(string)).Value = cos.ContractOfSaleOwner;
insertCommand.Parameters.AddWithValue("@ContractOfSaleBuyer", typeof(string)).Value = cos.ContractOfSaleBuyer;
insertCommand.Parameters.AddWithValue("@ContractOfSaleCost", typeof(string)).Value = cos.ContractOfSaleCost;
insertCommand.Parameters.AddWithValue("@ContractOfSaleEstateInventoryNumber", typeof(string)).Value = cos.ContractOfSaleEstateInventoryNumber;
connection.Open();
insertCommand.ExecuteNonQuery();
connection.Close();
}
}
}
private void GetData(ContractOfSale contractOfSale)
{
counterID = contractOfSale.ContractOfSaleID;
TextBoxUpdateCOSNumber.Text = contractOfSale.ContractOfSaleNumber;
DPUpdateCOSDate.Text = contractOfSale.ContractOfSaleDate.ToString();
ComboBoxUpdateCOSOwner.SelectedItem = contractOfSale.ContractOfSaleOwner;
ComboBoxUpdateCOSBuyer.SelectedItem = contractOfSale.ContractOfSaleBuyer;
TextBoxUpdateCOSCost.Text = contractOfSale.ContractOfSaleCost.ToString();
ComboBoxUpdateCOSEstateInventoryNumber.SelectedItem = contractOfSale.ContractOfSaleEstateInventoryNumber;
}
public void DeleteContractOfSale(ContractOfSale cos)
{
using (SqlConnection connection = new SqlConnection(Settings.Default.DBConnect))
{
using (SqlCommand deleteCommand = new SqlCommand("DELETE FROM ContractOfSale " +
"WHERE ContractOfSaleID = @ContractOfSaleID", connection))
{
deleteCommand.Parameters.Clear();
deleteCommand.Parameters.AddWithValue("@ContractOfSaleID", typeof(string)).Value = cos.ContractOfSaleID;
connection.Open();
deleteCommand.ExecuteNonQuery();
connection.Close();
}
}
}
public WindowChangeContractOfSale(ContractOfSale contractOfSale)
{
InitializeComponent();
GetData(contractOfSale);
}
