public IActionResult RiddleList(int?idCategory)
{
UserConnect(ViewBag);
ViewBag.Category = Category.LoadCategory();
List <Riddle1> liste = Riddle1.RiddleLoad(idCategory);
return(View(liste));
}
public IActionResult RiddleDeposit()
{
UserConnect(ViewBag);
Riddle1 r = new Riddle1();
ViewBag.CategoryList = Category.LoadCategory();
return(View());
}
public async Task <IActionResult> AddRiddlePost(string titre, string enonce, string indice, string solution, int?category, List <IFormFile> image)
{
Riddle1 r = new Riddle1()
{
Titre = titre, Enonce = enonce, Indice = indice, Solution = solution, IdCategory = (int)category
};
r.IdUser = Convert.ToInt32(HttpContext.Session.GetString("idUser"));
List <string> errors = new List <string>();
if (titre == null)
{
errors.Add("Merci d'indiquer un titre");
}
if (enonce == null)
{
errors.Add("Merci d'indiquer un énoncé");
}
if (indice == null)
{
errors.Add("Merci d'indiquer un indice");
}
if (solution == null)
{
errors.Add("Merci d'indiquer la solution");
}
if (category == 0)
{
errors.Add("Merci d'indiquer la catégorie de l'énigme");
}
ViewBag.errors = errors;
if (errors.Count > 0)
{
//ViewBag.error = true;
//ViewBag.errors = errors;
//return RedirectToAction("RiddleDeposit", r);
//return View("RiddleDeposit", r);
}
else
{
foreach (IFormFile f in image)
{
if (f.FileName.Contains(".png") || f.FileName.Contains(".jpg"))
{
var path = Path.Combine(Directory.GetCurrentDirectory(), "wwwroot/Images/Enigme/", r.IdUser.ToString() + "-" + f.FileName);
var stream = new FileStream(path, FileMode.Create);
await f.CopyToAsync(stream);
r.Image.Add(new RiddleImage {
Url = "Images/Enigme/" + r.IdUser.ToString() + "-" + f.FileName
});
}
}
r.AddRiddle();
}
return(RedirectToAction("RiddleList", r));
//return View("RiddleList", r);
}
public void DeleteRiddleDb(Riddle1 r)
{
SqlCommand command = new SqlCommand("DELETE FROM Riddle WHERE Id = @id", Connection.Instance);
command.Parameters.Add(new SqlParameter("@id", r.Id));
Connection.Instance.Open();
command.ExecuteNonQuery();
Connection.Instance.Close();
}
public IActionResult DeleteRiddle(int id)
{
UserConnect(ViewBag);
Riddle1 r = new Riddle1 {
Id = id
};
r.DeleteRiddle();
return(RedirectToRoute(new { controller = "Riddle", action = "RiddleList" }));
}
public IActionResult AddRiddle()
{
UserConnect(ViewBag);
bool connected = Convert.ToBoolean(HttpContext.Session.GetString("logged"));
if (connected)
{
Riddle1 r = new Riddle1();
ViewBag.CategoryList = Category.LoadCategory();
return(View("RiddleDeposit", r));
}
else
{
return(RedirectToRoute(new { controller = "User", action = "Login" }));
}
}
public IActionResult RiddleDetail(int Id)
{
UserConnect(ViewBag);
bool connected = Convert.ToBoolean(HttpContext.Session.GetString("logged"));
if (connected)
{
Riddle1 r = new Riddle1();
List <Riddle1> liste = Riddle1.GetRiddle(Id);
return(View("RiddleDetail", liste));
}
else
{
return(RedirectToRoute(new { controller = "User", action = "Login" }));
}
}
public List <Riddle1> RiddleLoadDb(int?idCategory)
{
List <Riddle1> liste = new List <Riddle1>();
SqlCommand command;
if (idCategory == null)
{
command = new SqlCommand("SELECT Id, Titre, Enonce, Indice, Solution, DatePublication, IdCategory, IdUser From Riddle", Connection.Instance);
}
else
{
command = new SqlCommand("SELECT Id, Titre, Enonce, Indice, Solution, DatePublication, IdCategory, IdUser From Riddle WHERE IdCategory = @idcategory", Connection.Instance);
command.Parameters.Add(new SqlParameter("@idcategory", idCategory));
}
Connection.Instance.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
Riddle1 r = new Riddle1 {
Id = reader.GetInt32(0), Titre = reader.GetString(1), Enonce = reader.GetString(2), Indice = reader.GetString(3), Solution = reader.GetString(4), DatePublication = reader.GetDateTime(5), IdCategory = reader.GetInt32(6), IdUser = reader.GetInt32(7)
};
liste.Add(r);
}
reader.Close();
command.Dispose();
for (int i = 0; i < liste.Count; i++)
{
command = new SqlCommand("SELECT Id, Url from RiddleImage WHERE idRiddle = @idRiddle", Connection.Instance);
command.Parameters.Add(new SqlParameter("@idRiddle", liste[i].Id));
reader = command.ExecuteReader();
while (reader.Read())
{
liste[i].Image.Add(new RiddleImage {
Id = reader.GetInt32(0), Url = reader.GetString(1)
});
}
reader.Close();
command.Dispose();
}
Connection.Instance.Close();
return(liste);
}
public List <Riddle1> GetRiddleDb(int Id)
{
List <Riddle1> liste = new List <Riddle1>();
SqlCommand command = new SqlCommand("SELECT * FROM Riddle WHERE Id=@Id", Connection.Instance);
command.Parameters.Add(new SqlParameter("@Id", SqlDbType.Int)
{
Value = Id
});
Connection.Instance.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
Riddle1 r = new Riddle1 {
Id = reader.GetInt32(0), Titre = reader.GetString(1), Enonce = reader.GetString(2), Indice = reader.GetString(3), Solution = reader.GetString(4)
};
liste.Add(r);
}
reader.Close();
command.Dispose();
for (int i = 0; i < liste.Count; i++)
{
command = new SqlCommand("SELECT Id, Url from RiddleImage WHERE idRiddle = @Id", Connection.Instance);
command.Parameters.Add(new SqlParameter("@Id", liste[i].Id));
reader = command.ExecuteReader();
while (reader.Read())
{
liste[i].Image.Add(new RiddleImage {
Id = reader.GetInt32(0), Url = reader.GetString(1)
});
}
reader.Close();
command.Dispose();
}
Connection.Instance.Close();
return(liste);
}
//RIDDLE
public void AddRiddleDb(Riddle1 r)
{
SqlCommand command = new SqlCommand("INSERT INTO Riddle (Titre, Enonce, Indice, Solution, DatePublication, IdCategory, IdUser) OUTPUT INSERTED.ID VALUES (@Titre, @Enonce, @Indice, @Solution, @DatePublication, @IdCategory, @IdUser)", Connection.Instance);
command.Parameters.Add(new SqlParameter("@Titre", r.Titre));
command.Parameters.Add(new SqlParameter("@Enonce", r.Enonce));
command.Parameters.Add(new SqlParameter("@Indice", r.Indice));
command.Parameters.Add(new SqlParameter("@Solution", r.Solution));
command.Parameters.Add(new SqlParameter("@DatePublication", r.DatePublication));
command.Parameters.Add(new SqlParameter("@IdCategory", r.IdCategory));
command.Parameters.Add(new SqlParameter("@IdUser", r.IdUser));
Connection.Instance.Open();
r.Id = (int)command.ExecuteScalar();
command.Dispose();
foreach (RiddleImage img in r.Image)
{
command = new SqlCommand("INSERT INTO RiddleImage (Url,idRiddle) values(@Url,@idRiddle)", Connection.Instance);
command.Parameters.Add(new SqlParameter("@Url", img.Url));
command.Parameters.Add(new SqlParameter("@idRiddle", r.Id));
command.ExecuteNonQuery();
command.Dispose();
}
Connection.Instance.Close();
}
