public List <Office> OfficesList()
{
List <Office> list = new List <Office>();
SqlDataReader data = MyConnexion.ExecuteReaderMyC("Select * from OfficesSales;");
while (data.Read())
{
list.Add(new Office(data.GetInt32(0), data.GetString(1)));
}
MyConnexion.Close();
return(list);
}
public List <Apartements> ApartementsList()
{
List <Apartements> list = new List <Apartements>();
SqlDataReader data = MyConnexion.ExecuteReaderMyC("select * from Apartements ");
while (data.Read())
{
//list.Add(new Group(int.Parse(data["Id"].ToString()),data["Nom"].ToString()));
list.Add(new Apartements(data.GetInt32(0), data.GetFloat(1), data.GetString(2), data.GetInt32(3),
data.GetInt32(4)));
}
MyConnexion.Close();
return(list);
}
public List <Customers> CustomerList()
{
List <Customers> list = new List <Customers>();
SqlDataReader data = MyConnexion.ExecuteReaderMyC("select * from Customers ");
while (data.Read())
{
//list.Add(new Group(int.Parse(data["Id"].ToString()),data["Nom"].ToString()));
list.Add(new Customers(data.GetInt32(0), data.GetString(1), data.GetString(2), data.GetInt32(3),
data.GetString(4), data.GetString(5), data.GetInt32(6)));
}
MyConnexion.Close();
return(list);
}
private void btnAddApartement_Click(object sender, EventArgs e)
{
try
{
MyConnexion.open();
Apartements A = new Apartements();
A.IdApartment = int.Parse(idApartmentTextBox.Text);
A.Price = float.Parse(priceTextBox.Text);
A.AparAddress = aparAddressTextBox.Text;
A.Aparfloor = int.Parse(aparfloorTextBox.Text);
A.NbrRooms = int.Parse(nbrRoomsTextBox.Text);
officeSales.AddApartement(A);
OfficeSalesApartList.Add(A);
idApartmentTextBox1.Enabled = false;
idApartmentTextBox1.Text = idApartmentTextBox.Text;
MyConnexion.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnAddCustomer_Click(object sender, EventArgs e)
{
try
{
MyConnexion.open();
Contracts Co = new Contracts();
Co.Id = int.Parse(idTextBox.Text);
Co.IdCustomer = int.Parse(idCustomerTextBox.Text);
Co.CntType = cntTypeTextBox.Text;
Co.FirstBatch = float.Parse(firstBatchTextBox.Text);
Co.Installement = float.Parse(installementTextBox.Text);
Co.ContDate = contDateTextBox.Text;
officeSales.AddContract(Co);
OfficeSalesContrList.Add(Co);
idTextBox1.Enabled = false; //IDContract
idTextBox1.Text = idTextBox.Text;
MyConnexion.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
