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