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);
}
}
/// <summary>
/// //////////
/// </summary>
/// <param name="Apartement"></param>
public void AddApartement(Apartements Apartement)
{
MyConnexion.ExecuteNonQueryMyC("insert into Apartements values(" + Apartement.IdApartment + "," + Apartement.Price + ",'" + Apartement.AparAddress + "'," + Apartement.Aparfloor + "," + Apartement.NbrRooms + ");");
}
/// <summary>
/// /////////////////
/// </summary>
/// <param name="Contract"></param>
public void AddContract(Contracts Contract)
{
MyConnexion.ExecuteNonQueryMyC("insert into Contracts values (" + Contract.Id + "," + Contract.IdCustomer + ",'" + Contract.CntType + "'," + Contract.FirstBatch + "," + Contract.Installement + ",'" + Contract.ContDate + "');");
}
public void UpdateCustomer(int id, string firstName, string lastName, int age, string phone, string occupation, int idOffice)
{
MyConnexion.ExecuteNonQueryMyC(@"Update Customers set FirstName='" + firstName + "',LastName='" + lastName + "',Age=" + age + ",phone='" + phone + "',Occupation='" + occupation + "',IdOffice=" + idOffice
+ "where Id=" + id);
}
public void DeleteCustomer(int id)
{
MyConnexion.ExecuteNonQueryMyC(@"delete from Customers where Id=" + id);
}
public void AddCustomer(Customers Customer)
{
MyConnexion.ExecuteNonQueryMyC("insert into Customers values(" + Customer.Id + ",'" + Customer.FirstName + "','" + Customer.LastName + "'," + Customer.Age + ",'"
+ Customer.Phone + "','" + Customer.Occupation + "'," + Customer.IdOffice + ")");
}
/// <summary>
/// /
/// </summary>
/// <param name="IdOffice"></param>
/// <param name="NameOffice"></param>
public void AddOffice(int IdOffice, string NameOffice)
{
MyConnexion.ExecuteNonQueryMyC("Insert into OfficesSales values(" + IdOffice + ",'" + NameOffice + "')");
}
public void AddRelationContractApartemet(int IdContact, int IdApartement)
{
MyConnexion.ExecuteNonQueryMyC("insert into Contract_Apartement values(" + IdContact + "," + IdApartement + ");");
}
