public static void Main(string[] args)
{
using (var context = new PetitesAnnoncesContext())
{
if (context.Database != null)
{
context.Database.EnsureDeleted();
context.Database.EnsureCreated();
}
User user1 = new User
{
FirstName = "Jean-Michel",
LastName = "Animaler",
};
Annonce annonce1 = new Annonce
{
Title = "Chien à vendre",
ObjectForSale = "Chien de cinéma",
Description = "Très peu joué, a fait qq pubs pour Canikro",
Owner = "DogMaster31",
Price = 5000,
Date = DateTime.Now,
user = user1,
};
context.Add(user1);
context.Add(annonce1);
context.SaveChanges();
}
CreateHostBuilder(args).Build().Run();
}
public IHttpActionResult Post()
{
var httpRequest = HttpContext.Current.Request;
if (httpRequest.Files.Count < 1)
{
return(BadRequest());
}
Annonce annonce = new Annonce();
JObject json = JObject.Parse(httpRequest.Form[0]);
annonce = json.ToObject <Annonce>();
String filePath = "";
foreach (string file in httpRequest.Files)
{
var postedFile = httpRequest.Files[file];
filePath = HttpContext.Current.Server.MapPath("~/assets/" + postedFile.FileName);
postedFile.SaveAs(filePath);
// NOTE: To store in memory use postedFile.InputStream
filePath = "http://localhost:59825/Assets/" + postedFile.FileName;
}
annonce.UrlPhoto = filePath;
db.Annonce.Add(annonce);
db.SaveChanges();
return(Ok(annonce));
}
public async Task <IActionResult> PutAnnonce(int id, [FromBody] Annonce annonce)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != annonce.Id)
{
return(BadRequest());
}
_context.Entry(annonce).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!AnnonceExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public /*IHttpActionResult*/ Annonce PostAnnonce(AnnonceModel annonce)
{
// int max = 0;
if (!ModelState.IsValid)
{
return(null);// BadRequest(ModelState);
}
int max = db.Annonces.Count();
Annonce annonceAjoutee = new Annonce();
//annonceAjoutee.Id = max + 1;
annonceAjoutee.UserId = db1.Users.FirstOrDefault(p => p.UserName == annonce.UserName).Id;
annonceAjoutee.UserName = annonce.UserName;
annonceAjoutee.ContenuAnnonce = annonce.ContenuAnnonce;
annonceAjoutee.DateAnnonce = DateTime.Now;
db.Annonces.Add(annonceAjoutee);
try
{
db.SaveChanges();
//annonceAjoutee.Id=db.Annonces.Last().Id;
}
catch (Exception ex)
{
throw ex;
return(null);
}
return(annonceAjoutee);// CreatedAtRoute("DefaultApi", new { id = annonceAjoutee.Id }, annonceAjoutee);
}
public ActionResult EditAnnounce(int id)
{
Annonce announceToUpdate = announceBL.GetAnnounce(id);
if (announceToUpdate != null)
{
AnnounceVM annonceVM = new AnnounceVM()
{
description = announceToUpdate.description,
estActive = announceToUpdate.estActive,
idAnnonce = announceToUpdate.idAnnonce,
idCategorie = announceToUpdate.idCategorie,
idUtilisateur = announceToUpdate.idUtilisateur,
nbSlot = announceToUpdate.nbSlot,
nbSlotUtilise = announceToUpdate.nbSlotUtilise,
titre = announceToUpdate.titre
};
annonceVM.lesCategories = categoryBL.GetAllCategories();
return(View(annonceVM));
}
else
{
return(RedirectToAction("GetAllAnnounces", "Announce"));
}
}
public ActionResult edit(int idx)
{
using (ProductChimiqueEntities3 dbModel = new ProductChimiqueEntities3())
{
Annonce record =
(
from x in dbModel.Annonces
where x.Id == idx
select x
).Single();
ProductChimiqueEntities2 dbModeld = new ProductChimiqueEntities2();
var GetProductsList = dbModeld.Produits.ToList();
SelectList list = new SelectList(GetProductsList, "Id", "Label");
ViewData["Products"] = list;
//delete old product
Annonce dept = dbModel.Annonces.Single(x => x.Id == idx);
System.Diagnostics.Debug.WriteLine(dept.Id);
dbModel.Annonces.Remove(dept);
dbModel.SaveChanges();
//product deleted
return(View("ModificationAnnonce", record));
}
}
public async Task <IActionResult> Edit(int id, [Bind("Id,Title,Body,Price")] Annonce annonce)
{
if (id != annonce.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(annonce);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!AnnonceExists(annonce.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(annonce));
}
public ActionResult EditAnnounce(AnnounceVM pAnnounce)
{
try
{
Annonce newAnnounce = new Annonce()
{
description = pAnnounce.description,
estActive = pAnnounce.estActive,
idAnnonce = Convert.ToInt16(pAnnounce.idAnnonce),
idCategorie = pAnnounce.idCategorie,
idUtilisateur = pAnnounce.idUtilisateur,
nbSlot = pAnnounce.nbSlot,
nbSlotUtilise = pAnnounce.nbSlotUtilise,
titre = pAnnounce.titre
};
if (announceBL.EditAnnounce(newAnnounce))
{
return(RedirectToAction("GetAllAnnounces", "Announce"));
}
else
{
return(View(pAnnounce));
}
}
catch (Exception)
{
return(View(pAnnounce));
}
}
public ActionResult Add(Annonce annonce, HttpPostedFileBase[] file)
{
if (ModelState.IsValid)
{
annonce.Id = Guid.NewGuid().ToString();
try
{
foreach (var item in file)
{
if (file != null)
{
annonce.Photos += item.FileName + "&";
string path = Path.Combine(Server.MapPath("~/Photos"), Path.GetFileName(annonce.Id + "_" + item.FileName));
item.SaveAs(path);
}
}
annonce.Date = DateTime.Now;
db.Annonces.Add(annonce);
db.SaveChanges();
return(View("Success"));
}
catch (Exception)
{
}
}
return(View("Error"));
}
public async Task <Annonce> AddAsync(Annonce annonce)
{
context.Add(annonce);
await context.SaveChangesAsync();
return(annonce);
}
/// <summary>
/// Ajoute une nouvelle annonce
/// </summary>
public void AddAnnonce()
{
if (!this.Entities.Annonce
.Any(type => type.Nom == "Nouveau")//Si l'intitulée de l'annonce n'est pas égale à "Nouveau"
//Si l'intitulée est différent de l'un de la liste
)
{
Annonce annonce = new Annonce();
annonce.Nom = "Nouveau";
annonce.Date_Publication = DateTime.Now;
annonce.Date_Debut = DateTime.Now;
annonce.Date_Fin = DateTime.Now;
annonce.Contrat = this.Entities.Contrat.FirstOrDefault();
annonce.IdPro = 1;
annonce.IdEmp = 1;
annonce.IdVille = 1;
annonce.IdMetier = 1;
this.Annonces.Add(annonce);
this.SaveChanges();
}
else
{
MessageBox.Show("Libellé déjà existant");
}
}
public IHttpActionResult PutAnnonce(int id, Annonce annonce)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != annonce.Id)
{
return(BadRequest());
}
db.Entry(annonce).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!AnnonceExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IActionResult DetailAnnonce(int id)
{
ViewBag.BaseUrl = "https://localhost:44301/";
//List<Annonce> annonces = GetAnnoncesFromSessionOrCookies();
//List<Annonce> annonces = _favorisService.GetFavoris();
ViewBag.isFavoris = _favorisService.IsFavoris(id);
return(View(Annonce.GetAnnonce(id)));
}
public IActionResult Post([FromBody] Annonce annonce)
{
DataContext db = new DataContext();
db.Annonce.Add(annonce);
db.SaveChanges();
return(Ok(new { annonceId = annonce.Id }));
}
public IActionResult Detail(int id)
{
Annonce annonce = Annonce.GetAnnonceById(id);
annonce.Image = $"{Request.Scheme}://{Request.Host.Value}/{annonce.Image}";
ViewBag.isFavoris = LookForFavoris(id);
return(View(annonce));
}
public ActionResult DeleteConfirmed(int id)
{
Annonce annonce = db.annonces.Find(id);
db.annonces.Remove(annonce);
db.SaveChanges();
return(RedirectToAction("MesAnnonces", "Utilisateurs"));
}
public ActionResult Annonce()
{
ViewBag.Message = "Page d'annonce";
var ann = new Annonce();
return(View(ann));
}
public Annonce Post(Annonce annonce)
{
MyService.Add(annonce);
MyService.Commit();
return annonce;
}
public ActionResult DeleteConfirmed(int id)
{
Annonce annonce = db.Annonces.Find(id);
db.Annonces.Remove(annonce);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult ConfirmDelete(int id)
{
Annonce an = AnnonceService.GetById(id);
AnnonceService.Delete(an);
AnnonceService.Commit();
return(RedirectToAction("MesAnnonce"));
}
public ActionResult Avis(int id)
{
Annonce avis = _annonceService.Get(id);
if (avis == null)
{
RedirectToAction("Index");
}
return(View(avis));
}
// GET: AjoutAnnonce
public ActionResult AjoutAnnonce(int id = 0)
{
Annonce AnnonceModel = new Annonce();
ProductChimiqueEntities2 dbModel = new ProductChimiqueEntities2();
var GetProductsList = dbModel.Produits.ToList();
SelectList list = new SelectList(GetProductsList, "Id", "Label");
ViewData["Products"] = list;
return(View(AnnonceModel));
}
public ActionResult <Annonce> Post(Annonce annonce)
{
var res = _service.Add(annonce);
if (res == null)
{
return(BadRequest("invalid title"));
}
return(res);
}
public IActionResult Index(string search)
{
List <Annonce> annonces = null;
if (search != null)
{
annonces = Annonce.Search(search);
}
return(View());
}
public IHttpActionResult GetAnnonce(int id)
{
Annonce annonce = db.Annonce.Find(id);
if (annonce == null)
{
return(NotFound());
}
return(Ok(annonce));
}
public IActionResult Index(string search)
{
//ViewBag.Email = _login.GetEmail();
List <Annonce> annonces = null;
if (search != null)
{
annonces = Annonce.Search(search);
}
return(View(annonces));
}
public async Task <IActionResult> Create([Bind("Id,Title,Body,Price")] Annonce annonce)
{
if (ModelState.IsValid)
{
_context.Add(annonce);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(annonce));
}
public ActionResult DeleteAnnonce(int idx)
{
ProductChimiqueEntities3 sqlObj = new ProductChimiqueEntities3();
Annonce dept = sqlObj.Annonces.Single(x => x.Id == idx);
sqlObj.Annonces.Remove(dept);
sqlObj.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "ID,Label,Description,DateCreation,Statut,CategorieID")] Annonce annonce)
{
if (ModelState.IsValid)
{
db.Entry(annonce).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CategorieID = new SelectList(db.Categories, "ID", "Nom", annonce.CategorieID);
return(View(annonce));
}
public IActionResult SubmitFormAnnonce(Annonce annonce, IFormFile[] images)
{
foreach (IFormFile image in images)
{
annonce.Images.Add(new Image()
{
Url = Upload(image)
});
}
annonce.Save();
return(RedirectToAction("index"));
}
protected string LoadRappel(DataRow drRappel)
{
string tmpInnerHtml = "";
DataTable dtann = SQL.GetTable("select * from annonces_r where id=" + drRappel["id_annonce"]);
if (dtann != null && dtann.Rows.Count >= 0)
{
DataRow dr=dtann.Rows[0];
Annonce ann = new Annonce(dr["poste"].ToString(), dr["entreprise"].ToString(), dr["localisation"].ToString(), (DateTime)dr["date"], dr["description"].ToString());
tmpInnerHtml = "<div> Mon Rappel " + drRappel["id"] + "<br /><div class='divposte'>" + drRappel["id_annonce"] + "</div><div>"+dr["poste"].ToString()+"</div></div><br />";
}
return tmpInnerHtml;
//document.getElementById('<%= myDiv.ClientID %>');
}
private void PushIntoDB(string[][] result, String type)
{
iCampusViewModel VM = App.ViewModel;
Cours coursToUpdate;
switch (type)
{
#region CASE COURS
case "Cours":
foreach (string[] array in result)
{
Cours toPushC = new Cours { sysCode = array[0], title = array[1], titular = array[3], notified = (array[4] == "hot") };
VM.AddCours(toPushC);
}
VM.ClearCoursList();
if (RefreshAll)
{
RefreshAll = false;
Connect cx = new Connect();
foreach (Cours item in VM.AllCours)
{
//cx.Sync(item.url);
}
}
break;
#endregion
#region CASE SECTION
case "Section":
coursToUpdate = (from Cours _cours in VM.AllCours where _cours.sysCode == result[0][4] select _cours).First();
foreach (string[] array in result)
{
switch (array[0])
{
case "Documents et liens":
Connect cx = new Connect();
coursToUpdate.isDnL = true;
coursToUpdate.dnlNotif = (array[4] == "hot");
cx.Sync(array[1].Replace("&","&"));
break;
case "Annonces":
coursToUpdate.isAnn = true;
coursToUpdate.annNotif = (array[4] == "hot");
(new Connect()).Sync(array[1].Replace("&", "&"));
break;
default:
break;
}
}
//VM.AddCours(coursToUpdate);
break;
#endregion
#region CASE DOC
case "Docs":
coursToUpdate = (from Cours _cours in VM.AllCours where _cours.sysCode == result[0][7] select _cours).First();
foreach (string[] array in result)
{
string[] name = array[0].Split('.');
Documents toPush = new Documents()
{
url = array[1],
Description = array[5],
notified = (array[6] == "hot"),
Cours = coursToUpdate
};
switch (array[2])
{
case "document": //Dossier
toPush.path = array[0].Trim();
toPush.IsFolder = true;
toPush.date = DateTime.Today;
(new Connect()).Sync(array[1].Replace("&", "&"));
break;
case "backends": //Fichier
string[] date = array[4].Split('.');
string[] partialSize = array[3].Replace(" ", " ").Replace('.', ',').Split(' ');
switch (partialSize[1])
{
case "Ko":
partialSize[1] = "E+3";
break;
case "Mo":
partialSize[1] = "E+6";
break;
case "Go":
partialSize[1] = "E+9";
break;
default:
partialSize[1] = "";
break;
}
if (name.Length > 2)
{
for (int i = 1; i < name.Length - 1; i++)
{
name[0] += " "+name[i];
}
}
toPush.path = name[0].Trim();
toPush.IsFolder = false;
toPush.Extension = name.Last().Trim();
toPush.size = Double.Parse(partialSize[0] + partialSize[1]);
toPush.date = new DateTime(int.Parse(date[2]), int.Parse(date[1]), int.Parse(date[0]));
break;
default:
break;
}
if (array[8] != null)
{
toPush.RootFolder = (from Documents _root in VM.AllFolders where _root.path == result[0][8] select _root).First();
toPush.IsRoot = false;
}
else
{
toPush.IsRoot = true;
}
//Debug.WriteLine("Adding Document" + toPush.Name + "\r" + toPush.IsRoot);
VM.AddDocument(toPush);
}
//VM.AddCours(coursToUpdate);
break;
#endregion
#region CASE ANNONCE
case "Annonces":
coursToUpdate = (from Cours _cours in VM.AllCours where _cours.sysCode == result[0][4] select _cours).First();
foreach (string[] array in result)
{
Annonce AnnToPush = new Annonce()
{
title = array[0],
content = array[1],
notified = (array[3] == "hot"),
Cours = coursToUpdate,
date = DateTime.Parse(array[2])
};
//Debug.WriteLine("Adding "+ AnnToPush.title +" to DB (depend of " + AnnToPush.Cours.sysCode);
VM.AddAnnonce(AnnToPush);
}
VM.ClearAnnsOfCours(coursToUpdate);
break;
#endregion
default:
break;
}
}
public void LancerLaMiseAJour(Annonce annonce){
AnnonceMiseEnFavori.Invoke(annonce);
}
public void LancerLaMiseAJour(Annonce annonce){
}
