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