// Methode pour get les evenements de la data base public IEnumerable <EvenementModel> GetLesEvents() { List <EvenementModel> listeEvenement = new List <EvenementModel>(); using (SqlConnection connection = new SqlConnection(ConnexionClass.SetConnexion())) { string query = "SELECT * FROM tEvenement"; SqlCommand commande = new SqlCommand(query, connection); commande.CommandType = CommandType.Text; connection.Open(); SqlDataReader reader = commande.ExecuteReader(); while (reader.Read()) { EvenementModel eventModel = new EvenementModel(); eventModel.IdEvenement = Convert.ToInt32(reader["idEvent"]); eventModel.ImageEvenement = reader["imageEvent"].ToString(); eventModel.TitreEvenement = reader["titleEvenent"].ToString(); eventModel.DescriptionEvenement = reader["descriptionEvent"].ToString(); listeEvenement.Add(eventModel); } connection.Close(); } return(listeEvenement); }
// Methode pour retrieve les menus dans la base des donnees public IEnumerable <MenuModel> GetLesMenus() { List <MenuModel> listeMenu = new List <MenuModel>(); using (SqlConnection connection = new SqlConnection(ConnexionClass.SetConnexion())) { string query = "SELECT * FROM tMenu"; SqlCommand commande = new SqlCommand(query, connection); commande.CommandType = CommandType.Text; connection.Open(); SqlDataReader reader = commande.ExecuteReader(); while (reader.Read()) { MenuModel menuModel = new MenuModel(); menuModel.IdMenu = Convert.ToInt32(reader["idMenu"]); menuModel.ImageMenu = reader["imageMenu"].ToString(); menuModel.DescriptionMenu = reader["descriptionMenu"].ToString(); menuModel.PrixMenu = reader["prixMenu"].ToString(); listeMenu.Add(menuModel); } connection.Close(); } return(listeMenu); }
public String GetDernierDUCodeMenU() { using (SqlConnection connexion = new SqlConnection(ConnexionClass.SetConnexion())) { connexion.Open(); string query = "SELECT MAX(idMenu) AS MaxIdMenu FROM tMenu"; SqlCommand commande = new SqlCommand(query, connexion); string NomImage; NomImage = "Image" + (Convert.ToInt64(commande.ExecuteScalar()) + 1).ToString(); return(NomImage); } }
//Methode pour select les utilisateurs public tUser GetUsers(string username, string password) { using (SqlConnection Conn = new SqlConnection(ConnexionClass.SetConnexion())) try { Conn.Open(); tUser objCust = new tUser(); if (Conn.State != System.Data.ConnectionState.Open) { Conn.Open(); } string s = "select * from tUser where UserName = @username and PassWord = @password"; //where UserName = @a and PassWord = @b SqlCommand objCommand = new SqlCommand(s, Conn); objCommand.Parameters.AddWithValue("@username", username); objCommand.Parameters.AddWithValue("@password", password); SqlDataReader _Reader = objCommand.ExecuteReader(); while (_Reader.Read()) { objCust.IdUser = Convert.ToInt32(_Reader["IdUser"].ToString()); objCust.UserName = _Reader["UserName"].ToString(); objCust.PassWord = _Reader["PassWord"].ToString(); } return(objCust); } catch { throw; } finally { if (Conn != null) { if (Conn.State == ConnectionState.Open) { Conn.Close(); Conn.Dispose(); } } } }
// Methode pour enregistrement un evenement public int SaveEvent(EvenementModel eventModel, string path) { using (SqlConnection connection = new SqlConnection(ConnexionClass.SetConnexion())) { connection.Open(); string query = "INSERT INTO tEvenement" + " (imageEvent, titleEvenent, descriptionEvent)" + " VALUES(@imageEvent, @titleEvenent, @descriptionEvent)"; SqlCommand commande = new SqlCommand(query, connection); commande.Parameters.AddWithValue("@imageEvent", path); commande.Parameters.AddWithValue("@titleEvenent", eventModel.TitreEvenement); commande.Parameters.AddWithValue("@descriptionEvent", eventModel.DescriptionEvenement); return(commande.ExecuteNonQuery()); } }
//Test enregistrement public int TestSave(MenuModel menu, string path) { using (SqlConnection connection = new SqlConnection(ConnexionClass.SetConnexion())) { connection.Open(); string requette = "INSERT INTO tMenu" + " (imageMenu, descriptionMenu, prixMenu)" + " VALUES(@imageMenu, @descriptionMenu, @prixMenu)"; SqlCommand commande = new SqlCommand(requette, connection); commande.Parameters.AddWithValue("@imageMenu", path); commande.Parameters.AddWithValue("@descriptionMenu", menu.DescriptionMenu); commande.Parameters.AddWithValue("@prixMenu", menu.PrixMenu); return(commande.ExecuteNonQuery()); } }
// Methode pour recuperer le dernier element de la table public String GetDernierDUCodeEvent() { using (SqlConnection connexion = new SqlConnection(ConnexionClass.SetConnexion())) { connexion.Open(); //string query = "SELECT MAX(idEvent) AS MaxIdEvent FROM tEvenement"; string query = "SELECT MAX(idEvent) AS [@idEvent] FROM tEvenement"; SqlCommand commande = new SqlCommand(query, connexion); string NomImage; NomImage = "Image" + (Convert.ToInt64(commande.ExecuteScalar()) + 1).ToString(); return(NomImage); } }
// Methode pour inserer les menus dans la base des donnees public int InsertMenu(MenuModel menuModel, string PathName) { using (SqlConnection connexion = new SqlConnection(ConnexionClass.SetConnexion())) { connexion.Open(); string query = "INSERT INTO tMenu" + " (imageMenu, descriptionMenu, prixMenu)" + " VALUES(@imageMenu, @descriptionMenu, @prixMenu)"; SqlCommand commande = new SqlCommand(query, connexion); commande.Parameters.AddWithValue("@imageMenu", PathName); commande.Parameters.AddWithValue("@descriptionMenu", menuModel.DescriptionMenu); commande.Parameters.AddWithValue("@prixMenu", menuModel.PrixMenu); //commande.Parameters.AddWithValue("@imageMenu", "steve"); //commande.Parameters.AddWithValue("@descriptionMenu", "oko"); //commande.Parameters.AddWithValue("@prixMenu", "ok"); return(commande.ExecuteNonQuery()); // connexion.Close(); } }