public static List <Ads> List() { //conection ConnectionStringSettings connectionStringSettings = ConfigurationManager.ConnectionStrings["megacasting"]; SqlConnection connection = new SqlConnection(connectionStringSettings.ToString()); //Commande SqlCommand commande = new SqlCommand(); commande.Connection = connection; commande.CommandText = @"SELECT Id, Title, PhoneNumber, Email, Addres, CP, City, ReleaseDate, StartDate, DescriptionJob, DescriptionProfile, DescriptionAgreement, NameCompany, Ref FROM Ads"; //Execution connection.Open(); SqlDataReader dataReader = commande.ExecuteReader(); List <Ads> listCompanies = new List <Ads>(); while (dataReader.Read()) { String Title = dataReader.GetString(1); Ads ads = new Ads(Title); ads.Id = dataReader.GetInt64(0); ads.PhoneNumber = dataReader.GetString(2); ads.Email = dataReader.GetDateTime(3); ads.Address = dataReader.GetString(4); ads.CP = dataReader.GetString(5); ads.City = dataReader.GetString(6); ads.ReleaseDate = dataReader.GetInt64(7); ads.StartDate = dataReader.GetDateTime(8); ads.DescriptionJob = dataReader.GetString(9); ads.DescriptionProfile = dataReader.GetString(10); ads.DescriptionAgreement = dataReader.GetString(11); ads.NameCompany = dataReader.GetString(12); ads.Ref = dataReader.GetString(13); listCompanies.Add(ads); } dataReader.Close(); connection.Close(); return(listCompanies); }
public static Ads Get(Int64 id) { //Récupération de la chaine de connexion //Connection ConnectionStringSettings connectionStringSettings = ConfigurationManager.ConnectionStrings["megacasting"]; SqlConnection connection = new SqlConnection(connectionStringSettings.ToString()); //Commande SqlCommand commande = new SqlCommand(); commande.Connection = connection; commande.CommandText = @"SELECT Id, Title, PhoneNumber, Email, Addres, CP, City, ReleaseDate, StartDate, DescriptionJob, DescriptionProfile, DescriptionAgreement, NameCompany, Ref FROM Ads WHERE Id = @Id"; //Parametre commande.Parameters.AddWithValue("Id", id); //Execution connection.Open(); SqlDataReader dataReader = commande.ExecuteReader(); dataReader.Read(); Ads ads = new Ads(dataReader.GetString(1)); ads.Id = dataReader.GetInt64(0); ads.PhoneNumber = dataReader.GetString(2); ads.Email = dataReader.GetDateTime(3); ads.Address = dataReader.GetString(4); ads.CP = dataReader.GetString(5); ads.City = dataReader.GetString(6); ads.ReleaseDate = dataReader.GetInt64(7); ads.StartDate = dataReader.GetDateTime(8); ads.DescriptionJob = dataReader.GetString(9); ads.DescriptionProfile = dataReader.GetString(10); ads.DescriptionAgreement = dataReader.GetString(11); ads.NameCompany = dataReader.GetString(12); ads.Ref = dataReader.GetString(13); dataReader.Close(); connection.Close(); return(ads); }
public static Ads Insert(Ads ads) { //connection ConnectionStringSettings connectionStringSettings = ConfigurationManager.ConnectionStrings["megacasting"]; SqlConnection connection = new SqlConnection(connectionStringSettings.ToString()); //commande SqlCommand commande = new SqlCommand(); commande.Connection = connection; commande.CommandText = @"INSERT INTO Ads(Title, PhoneNumber, Email, Address, CP, City, ReleaseDate, StartDate, DescriptionJob, DescriptionProfile, DescriptionAgreement, NameCompany, Ref) VALUES(@Title, @PhoneNumber, @Email, @Address, @CP, @City, @ReleaseDate, @StartDate, @DescriptionJob, @DescriptionProfile, @DescriptionAgreement, @NameCompany, @Ref); SELECT SCOPE_IDENTITY();"; //paramètre commande.Parameters.AddWithValue("Title", ads.Title); commande.Parameters.AddWithValue("PhoneNumber", ads.PhoneNumber); commande.Parameters.AddWithValue("Email", ads.Email); commande.Parameters.AddWithValue("Address", ads.Address); commande.Parameters.AddWithValue("CP", ads.CP); commande.Parameters.AddWithValue("City", ads.City); commande.Parameters.AddWithValue("ReleaseDate", ads.ReleaseDate); commande.Parameters.AddWithValue("StartDate", ads.StartDate); commande.Parameters.AddWithValue("DescriptionJob", ads.DescriptionJob); commande.Parameters.AddWithValue("DescriptionProfile", ads.DescriptionProfile); commande.Parameters.AddWithValue("DescriptionAgreement", ads.DescriptionAgreement); commande.Parameters.AddWithValue("NameCompany", ads.NameCompany); commande.Parameters.AddWithValue("Ref", ads.Ref); try { //execution connection.Open(); Decimal IdLastAdd = (Decimal)commande.ExecuteScalar(); return(AdsDB.Get((Int64)IdLastAdd)); } catch (Exception) { throw; } finally { connection.Close(); } }
public static Boolean Update(Ads ads) { Boolean isUpdateOK = false; //Connection ConnectionStringSettings connectionStringSettings = ConfigurationManager.ConnectionStrings["megacasting"]; SqlConnection connection = new SqlConnection(connectionStringSettings.ToString()); //Commande SqlCommand commande = new SqlCommand(); commande.Connection = connection; String requete = @"UPDATE ads SET Title = @Title, PhoneNumber = @PhoneNumber, Email = @Email, Address = @Adress, CP = @CP, City = @City, ReleaseDate = @ReleaseDate, StartDate = @StartDate, DescriptionJob = @DescriptionJob, DescriptionProfile = @DescriptionProfile, DescriptionAgreement = @DescriptionAgreement, NameCompany = @NameCompany, Ref = @Ref WHERE Id = @Id;"; commande.CommandText = requete; //Paramètres commande.Parameters.AddWithValue("Title", ads.Title); commande.Parameters.AddWithValue("PhoneNumber", ads.PhoneNumber); commande.Parameters.AddWithValue("Email", ads.Email); commande.Parameters.AddWithValue("Address", ads.Address); commande.Parameters.AddWithValue("CP", ads.CP); commande.Parameters.AddWithValue("City", ads.City); commande.Parameters.AddWithValue("ReleaseDate", ads.ReleaseDate); commande.Parameters.AddWithValue("StartDate", ads.StartDate); commande.Parameters.AddWithValue("DescriptionJob", ads.DescriptionJob); commande.Parameters.AddWithValue("DescriptionProfile", ads.DescriptionProfile); commande.Parameters.AddWithValue("DescriptionAgreement", ads.DescriptionAgreement); commande.Parameters.AddWithValue("NameCompany", ads.NameCompany); commande.Parameters.AddWithValue("Ref", ads.Ref); commande.Parameters.AddWithValue("Id", ads.Id); //Execution try { connection.Open(); commande.ExecuteNonQuery(); isUpdateOK = true; } catch (Exception) { isUpdateOK = false; } finally { connection.Close(); } return(isUpdateOK); }