public ActionResult MettreEnVente(Encher encher)
{
if (ModelState.IsValid)
{
encher.Id = Utility.IdGenerator.getEncherenId();
encher.Etat = -1;
EnchereRequette.insertEncher(encher);
string formatString = "yyyyMMddHHmmss";
string sample1 = "20180524121900";
string sample2 = "20180917102230";
DateTime dt1 = DateTime.ParseExact(sample1, formatString, null);
DateTime dt2 = DateTime.ParseExact(sample2, formatString, null);
StartScheduler sch1 = new StartScheduler();
ObjetRequette.setObjetEnVente(encher.IdObjet, 1);
//Encher en = EnchereRequette.getEnchereById(encher.Id);
//en.Etat = 0;
//EnchereRequette.updateEnchere(en);
//sch1.Start(encher.DateDepart, encher.IdObjet, encher.Id);
sch1.Start(dt1, encher.IdObjet, encher.Id);
FinishScheduler sch2 = new FinishScheduler();
//sch2.Start(encher.DateFin, encher.IdObjet, encher.Id);
sch2.Start(dt2, encher.IdObjet, encher.Id);
return(RedirectToAction("gestionObjetMembre", "Objet"));
}
return(View(encher));
}
public static Encher getEnchereById(string Id)
{
string connectionString = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
SqlConnection connection = new SqlConnection(connectionString);
string request = "SELECT * FROM Enchere WHERE Id = '" + Id.Trim() + "'";
SqlCommand command = new SqlCommand(request, connection);
try {
connection.Open();
SqlDataReader reader = command.ExecuteReader();
Encher en = null;
if (reader.Read())
{
en = new Encher((string)reader["Id"], (string)reader["IdObjet"], (string)reader["IdVendeur"], (string)reader["IdAcheteur"], (decimal)reader["PrixAchat"], (decimal)reader["PasDePrix"], (DateTime)reader["DateDepart"], (DateTime)reader["DateFin"], (int)reader["Etat"]);
}
reader.Close();
return(en);
} catch (Exception e) {
System.Console.WriteLine(e.Message);
} finally {
connection.Close();
}
return(null);
}
public ActionResult MettreEnVente(string idObjet, string idVendeur, bool vente)
{
Encher en = new Encher("0", idObjet, idVendeur, idVendeur, 0, 0, DateTime.Now, DateTime.Now, 0);
// LangueController.CreateCulture(getLangue());
CreateCulture(getLangue());
return(View(en));
}
public ActionResult UpdateEnchere(UpdateEnchereViewModel en)
{
if (ModelState.IsValid)
{
Encher model = new Encher();
Encher enOld = EnchereRequette.getEnchereById(en.Id);
Objet obj = ObjetRequette.getObjetById(en.IdObjet);
if ((enOld.PrixAchat + enOld.PasDePrix) > en.Prix)
{
ViewBag.err = "Au moins augmenter le prix par " + enOld.PasDePrix + "$!";
return(View(en));
}
Historique his = EnchereRequette.getHistorique(en.Id);
if (his.Prix > en.Prix + en.PasDePrix)
{
model.PrixAchat = en.Prix + en.PasDePrix;
model.IdAcheteur = his.IdMembre;
//// Send Email to en.IdAcheteur
}
else if (his.Prix >= en.Prix)
{
model.PrixAchat = his.Prix;
model.IdAcheteur = his.IdMembre;
//// Send Email to en.IdAcheteur
}
else
{
model.PrixAchat = his.Prix + en.PasDePrix;
model.IdAcheteur = en.IdAcheteur;
//// Send Email to his.IdMembre
}
Membre mb = MembreRequette.GetUserByNumero(model.IdAcheteur);
Utility.Mail.SendEmail(obj.Nom, model.PrixAchat, mb.Adresse);
model.Id = en.Id;
model.IdObjet = en.IdObjet;
//model.IdAcheteur = en.IdAcheteur;
model.IdVendeur = en.IdVendeur;
//model.PrixAchat = en.Prix;
model.PasDePrix = en.PasDePrix;
model.DateDepart = en.DateDepart;
model.DateFin = en.DateFin;
model.Etat = en.Etat;
EnchereRequette.updateEnchere(model);
his = new Historique(0, en.IdAcheteur, en.Id, en.Prix, DateTime.Now);
EnchereRequette.insertHistorique(his);
////// send E_mail to add //////
return(RedirectToAction("Index", "Home"));
}
return(View(en));
}
public static void updateEnchere(Encher en)
{
string connectionString = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
SqlConnection connection = new SqlConnection(connectionString);
string request = "UPDATE Enchere SET IdAcheteur = '" + en.IdAcheteur + "', PrixAchat = '" + en.PrixAchat + "', Etat = " + en.Etat + " WHERE id = '" + en.Id + "'";
SqlCommand command = new SqlCommand(request, connection);
try {
connection.Open();
command.ExecuteNonQuery();
} catch (Exception e) {
System.Console.WriteLine(e.Message);
} finally {
connection.Close();
}
}
public static void insertEncher(Encher encher)
{
string connectionString = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
SqlConnection connection = new SqlConnection(connectionString);
string request = "INSERT INTO Enchere VALUES ('" + encher.Id.Trim() + "','" + encher.IdObjet.Trim() + "', '" + encher.IdVendeur.Trim() + "', '" + encher.IdAcheteur.Trim() + "', '" + encher.PrixAchat + "', '" + encher.PasDePrix + "', '" + encher.DateDepart.ToString("yyyy-MM-dd") + "', '" + encher.DateFin.ToString("yyyy-MM-dd") + "', '" + encher.Etat + "')";
SqlCommand command = new SqlCommand(request, connection);
try {
connection.Open();
command.ExecuteNonQuery();
} catch (Exception e) {
System.Console.WriteLine(e.Message);
} finally {
connection.Close();
}
}
public ActionResult Create(Evaluation ev)
{
if (ModelState.IsValid)
{
Encher en = EnchereRequette.getEnchereById(ev.IdEnchere);
int etat = en.Etat;
string id = "";
if (ModelState.IsValid)
{
if (ev.Id == "acheteur")
{
if (etat == 1)
{
EnchereRequette.setEnchereEtat(ev.IdEnchere, 3);
}
else if (etat == 4)
{
EnchereRequette.setEnchereEtat(ev.IdEnchere, 5);
}
id = en.IdVendeur;
}
else if (ev.Id == "vendeur")
{
if (etat == 1)
{
EnchereRequette.setEnchereEtat(ev.IdEnchere, 4);
}
else if (etat == 3)
{
EnchereRequette.setEnchereEtat(ev.IdEnchere, 5);
}
id = en.IdAcheteur;
}
ev.Id = Utility.IdGenerator.getEvaluationId();
EvaluationRequette.insertEvaluation(ev);
Membre mb = MembreRequette.GetUserByNumero(id);
mb.Cote += ev.Cote;
MembreRequette.UpdateCote(mb);
////// update cote d'utilisateur /////////////////
return(RedirectToAction("Index", "Home"));
}
}
return(View(ev));
}
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 ActionResult List(string idEnchere, string op, string rtnUrl)
{
// LangueController.CreateCulture(getLangue());
CreateCulture(getLangue());
Encher en = EnchereRequette.getEnchereById(idEnchere);
Evaluation ev = null;
if (op == "acheteur")
{
ev = EvaluationRequette.getEvaluation(idEnchere, en.IdAcheteur);
}
else if (op == "vendeur")
{
ev = EvaluationRequette.getEvaluation(idEnchere, en.IdAcheteur);
}
ViewBag.rtn = rtnUrl;
return(View(ev));
}
