/// <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 + "');");
}
/// <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 + ");");
}
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 + ");");
}
