public ActionResult getEnchereVendeur(int etat)
{
// LangueController.CreateCulture(getLangue());
CreateCulture(getLangue());
if (ModelState.IsValid)
{
string currentUser = @User.Identity.Name;
Membre mb = MembreRequette.GetUserByEmail(currentUser);
List <Encher> list = EnchereRequette.getEncheresVendeur(mb.Numero, etat);
List <EnchereViewModel> listObj = new List <EnchereViewModel>();
foreach (Encher en in list)
{
Objet obj = ObjetRequette.getObjetById(en.IdObjet);
EnchereViewModel model = new EnchereViewModel(obj.Id, obj.Nom, obj.Description, obj.DateInscri, obj.IdCategorie, obj.Photo, obj.Piece, obj.IdMembre, obj.Nouveau, obj.EnVent, obj.PrixDepart, en.PrixAchat, en.Id, en.Etat);
listObj.Add(model);
}
if (etat == 0)
{
ViewBag.option = "Les encheres en cours:";
}
else if (etat == 1)
{
ViewBag.option = "Les encheres remportes:";
}
else if (etat == 2)
{
ViewBag.option = "Les encheres perdues:";
}
//if ()
return(View(listObj));
}
return(View());
}
public ActionResult UpdateEnchere(string id)
{
// LangueController.CreateCulture(getLangue());
CreateCulture(getLangue());
Membre mb = MembreRequette.GetUserByEmail(@User.Identity.Name);
Encher en = EnchereRequette.getEnchereById(id);
UpdateEnchereViewModel model = new UpdateEnchereViewModel();
model.Id = en.Id;
model.IdObjet = en.IdObjet;
model.IdAcheteur = mb.Numero;
model.IdVendeur = en.IdVendeur;
model.PrixAchat = en.PrixAchat;
model.PasDePrix = en.PasDePrix;
model.DateDepart = en.DateDepart;
model.DateFin = en.DateFin;
model.Etat = en.Etat;
return(View(model));
}
public static List <Objet> getObjetMembre(string courriel, string ordre)
{
Membre mb = new Membre();
mb = MembreRequette.GetUserByEmail(courriel);
List <Objet> obj = new List <Objet>();
string connectionString = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
SqlConnection connection = new SqlConnection(connectionString);
string request;
if (ordre == "none")
{
request = "SELECT o.Id, o.Nom, o.Description, o.DateInscri, c.Nom Categorie, o.Photo, o.Piece, o.IdMembre, o.Nouveau, o.EnVente, o.PrixDepart FROM Objet o, Categorie c WHERE o.IdMembre = '" + mb.Id.Trim() + "' AND c.Id = o.IdCategorie";
}
else
{
request = "SELECT o.Id, o.Nom, o.Description, o.DateInscri, c.Nom Categorie, o.Photo, o.Piece, o.IdMembre, o.Nouveau, o.EnVente, o.PrixDepart FROM Objet o, Categorie c WHERE o.IdMembre = '" + mb.Id.Trim() + "' AND c.Id = o.IdCategorie ORDER BY " + ordre;
}
SqlCommand command = new SqlCommand(request, connection);
try {
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
obj.Add(new Objet((string)reader["Id"], (string)reader["Nom"], (string)reader["Description"], (DateTime)reader["DateInscri"], (string)reader["Categorie"], (string)reader["photo"], (string)reader["piece"], (string)reader["IdMembre"], (bool)reader["Nouveau"], (bool)reader["EnVente"], (decimal)reader["PrixDepart"]));
}
reader.Close();
return(obj);
} catch (Exception e) {
System.Console.WriteLine(e.Message);
} finally {
connection.Close();
}
return(null);
}
