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