public static List <Item> findItemBySearchQuery(string motCle, int categorie)
{
EcommerceDb db = new EcommerceDb();
List <Item> item = db.Items.Where(s => s.itemName == motCle).ToList();
Categorie c = db.Categories.Where(s => s.nomCategorie == motCle).FirstOrDefault();
Categorie c2 = db.Categories.Where(s => s.CategorieId == categorie).FirstOrDefault();
List <Item> listFinale = null;
if (c != null)
{
listFinale = item.Union(c.item.ToList()).ToList();
if (c2 != null)
{
listFinale.Union(c2.item).ToList();
}
}
else if (c2 != null)
{
listFinale = item.Union(c2.item).ToList();
}
else
{
listFinale = item;
}
return(listFinale);
}
public static Item findItemById(int id)
{
EcommerceDb ecommerceDb = new EcommerceDb();
var item = ecommerceDb.Items.Where(s => s.itemId == id).FirstOrDefault();
return(item);
}
public static Client AuthentifiedClient()
{
EcommerceDb db = new EcommerceDb();
int currentClientId = Int32.Parse(System.Web.HttpContext.Current.User.Identity.Name);
var client = db.Clients.Where(s => s.clientId == currentClientId).FirstOrDefault();
return(client);
}
public static Commande nouvelleCommande()
{
EcommerceDb db = new EcommerceDb();
var clientConnecter = ClientUtilitaire.FindClientParId(db, Int32.Parse(HttpContext.Current.User.Identity.Name));
Commande c = new Commande();
c.Items = clientConnecter.Panier.ToList();
return(c);
}
public static Dictionary <int, string> categoryToDictionnary()//permet de creer un dropdown list pour
{
EcommerceDb db = new EcommerceDb();
var allCategory = db.Categories.ToList();
Dictionary <int, string> dictionnary = new Dictionary <int, string>();
dictionnary.Add(0, "Categories");
foreach (var category in allCategory)
{
dictionnary.Add(category.CategorieId, category.nomCategorie);
}
return(dictionnary);
}
public static Client TrouverClientConnection(EcommerceDb db, Connection connection)//verifie la connection d'un client
{
var client = TrouverClientParEmail(db, connection.EmailAdress);
if (client != null)
{
if (!(client.Password == connection.Password))
{
client = null;
}
}
return(client);//retour afin de determiner si on envoi message d'erreur,set cookie,etc
}
public static void EditClient(EcommerceDb db, ClientEditView clientEditView)
{
var client = db.Clients.Where(s => s.clientId == clientEditView.clientId).FirstOrDefault();
client.Adresse = clientEditView.Adresse;
client.EmailAdresse = clientEditView.EmailAdresse;
client.Nom = clientEditView.Nom;
client.Password = clientEditView.Password;
client.Prenom = clientEditView.Prenom;
client.Province = clientEditView.Province;
client.Ville = clientEditView.Ville;
db.SaveChanges();
}
public static Client AjouterClient(EcommerceDb db, Inscription inscription)
{
var client = TrouverClientParEmail(db, inscription.EmailAdresse);
if (client == null)
{
client = DataManipulation.copyInscriptionToClient(inscription);
db.Clients.Add(client);
db.SaveChanges();
}
else
{
client = null; //on reset le client a null afin de pouvoir envoyer le message d'errur car il existe deja dans la bd
}
return(client); //retour afin de determiner si on envoi message d'erreur,set cookie,etc
}
public static double panierTotalPrice(int clientId)
{
EcommerceDb db = new EcommerceDb();
var client = db.Clients.Where(s => s.clientId == clientId).FirstOrDefault();
double prixTotal = 0;
foreach (var item in client.Panier)
{
int i = 0;
do//ajuste le prix en fonction du nombre d'articles commandés
{
prixTotal = prixTotal + item.itemPrice;
i++;
} while (i < item.Quantite);
}
return(prixTotal);
}
public static void AjouterItemPanier(EcommerceDb db, int clientId, int itemId, int?nombreArticle = null)
{
var client = db.Clients.Where(s => s.clientId == clientId).FirstOrDefault();
var item = db.Items.Where(s => s.itemId == itemId).FirstOrDefault();
if (nombreArticle == null)
{
nombreArticle = 1;
}
var itemPanier = itemToItemVendu(item);
itemPanier.Quantite = (int)nombreArticle;
client.Panier.Add(itemPanier);
item.quantite = (int)(item.quantite - nombreArticle);
db.SaveChanges();
}
public static List <ItemDetails> featuredInitialisation()
{
EcommerceDb db = new EcommerceDb();//on cherche 3 item
var allItems = db.Items.ToList();
ItemDetails[] featuredItems = new ItemDetails[3];
int i = 0;//compteur
while (true)
{
Random random = new Random();
int radomItem = random.Next(allItems.Count());
featuredItems[i] = DataManipulation.copyItemToItemDetails(allItems.ElementAt(radomItem));
i = ++i;
if (i == 3)
{
break;
}
}
return(featuredItems.ToList());
}
public static List <Categorie> subFeaturedInitialisation()
{
EcommerceDb db = new EcommerceDb();
var x = db.Items.ToList();
var allCategorie = db.Categories.ToList();
Categorie[] subFeaturedCategorie = new Categorie[3];
int i = 0;
while (true)
{
Random random = new Random();
int randomCategorie = random.Next(allCategorie.Count());
var categorieEnvoye = allCategorie.ElementAt(randomCategorie);
subFeaturedCategorie[i] = allCategorie.ElementAt(randomCategorie);
Item[] subFeaturedCategoryItem = new Item[4];
int i2 = 0;
while (true)
{
int randomItem = random.Next(categorieEnvoye.item.Count());
var item = categorieEnvoye.item.ElementAt(randomItem);
subFeaturedCategoryItem[i2] = item;
i2 = ++i2;
if (i2 == 4)
{
break;
}
}
categorieEnvoye.item = subFeaturedCategoryItem.ToList();
subFeaturedCategorie[i] = categorieEnvoye;
i = ++i;
if (i == 3)
{
break;
}
}
return(subFeaturedCategorie.ToList());
}
public static List <Categorie> ItemDisplayInitialisation()
{
EcommerceDb db = new EcommerceDb();
var x = db.Items.ToList();
var allCategorie = db.Categories.ToList();
Categorie[] subFeaturedCategorie = new Categorie[5];
int i = 0;
while (true)
{
Random random = new Random();
int randomCategorie = random.Next(allCategorie.Count());
var categorieEnvoye = allCategorie.ElementAt(randomCategorie);
subFeaturedCategorie[i] = allCategorie.ElementAt(randomCategorie);
subFeaturedCategorie[i] = categorieEnvoye;
i = ++i;
if (i == subFeaturedCategorie.Length)
{
break;
}
}
return(subFeaturedCategorie.ToList());
}
public static void ConfirmerCommande(Commande commande, string CardNumber, string MoisExpiration, string AnneExpiration, string Cvv)
{
EcommerceDb db = new EcommerceDb();
commande.dateCommande = DateTime.Now;
commande.Client = ClientUtilitaire.FindClientParId(db, Int32.Parse(HttpContext.Current.User.Identity.Name));
commande.Items = commande.Client.Panier.ToList();
foreach (var i in commande.Items)
{
int compt = 0;
do
{
commande.MontantCommande = i.itemPrice;
compt = ++compt;
} while (compt < i.Quantite);
}
CreditCard creditCard = new CreditCard();
creditCard.CardNumber = Int64.Parse(CardNumber); //changer cardnumber en long
creditCard.Cvv = Int32.Parse(Cvv);
creditCard.DateExpiration = new DateTime(Int32.Parse(AnneExpiration), Int32.Parse(MoisExpiration), 1); //sa expire le premierdu mois donc le dernier argument est 1
commande.CreditCard = creditCard;
db.CreditCards.Add(creditCard);
db.Commande.Add(commande);
//db.Commande.Add(new Commande());
var didi = db.Commande.ToList();
commande.Client.Panier = null;
db.SaveChanges();
}
public CartsDb(EcommerceDb db)
{
_db = db;
}
public static void DeleteClient(EcommerceDb db, int id)
{
db.Clients.Remove(FindClientParId(db, id));
db.SaveChanges();
}
public static Client FindClientParId(EcommerceDb db, int id)
{
return(db.Clients.Where(s => s.clientId == id).FirstOrDefault());
}
public static Client TrouverClientParEmail(EcommerceDb db, string emailAdresse)
{
var client = db.Clients.Where(s => s.EmailAdresse == emailAdresse).FirstOrDefault();
return(client);//retourne client afin de set le cookie
}
public CommandeController()
{
db = new EcommerceDb();
}
public Productsdb(EcommerceDb db)
{
_db = db;
}
public ItemController()
{
db = new EcommerceDb();
}
public BaseRepository()
{
_db = new EcommerceDb();
}
public OrdersDb(EcommerceDb db)
{
_db = db;
}
public ClientController()
{
db = new EcommerceDb();
}
public static Categorie findCategorieByiD(EcommerceDb db, int id)
{
return(db.Categories.Where(s => s.CategorieId == id).FirstOrDefault());
}