public ActionResult Edit(NoteTable notetable) { if (ModelState.IsValid) { db.Entry(notetable).State = EntityState.Modified; db.SaveChanges(); return RedirectToAction("Index"); } ViewBag.AdresseId = new SelectList(db.AdresseTables, "AdresseId", "AptNo", notetable.AdresseId); ViewBag.UserId = new SelectList(db.UserTables, "UserId", "Nom", notetable.UserId); return View(notetable); }
public ActionResult Create(NoteTable notetable) { if (ModelState.IsValid) { db.NoteTables.Add(notetable); db.SaveChanges(); return RedirectToAction("Index"); } ViewBag.AdresseId = new SelectList(db.AdresseTables, "AdresseId", "AptNo", notetable.AdresseId); ViewBag.UserId = new SelectList(db.UserTables, "UserId", "Nom", notetable.UserId); return View(notetable); }
public virtual void SaveNote(NoteTable note, out string resultMessage) { using (var ctx = new notetalocEntities()) { var noteToAdd = ctx.NoteTables.Where(n => n.AdresseId == note.AdresseId && n.UserId == note.UserId).FirstOrDefault(); if (noteToAdd == null) { note.NoteId = GetNoteId(DateTime.Now); ctx.NoteTables.Add(note); ctx.SaveChanges(); resultMessage = "Add"; } else { note.NoteId = noteToAdd.NoteId; noteToAdd.Note = note.Note; ctx.SaveChanges(); resultMessage = "Update"; } } }
public virtual void UpdateNoteStatus(NoteTable note) { using (var ctx = new notetalocEntities()) { var noteToUpdate = ctx.NoteTables.Where(n => n.NoteId == note.NoteId).FirstOrDefault(); noteToUpdate.StatutNote = 1; ctx.SaveChanges(); } }
public ActionResult Index(SaisiNoteForm form) { if (ModelState.IsValid) { var address = ConcatenationAddress(form); try { var geocoder = new Geocoder(); var response = geocoder.Locate(address); if (response != null) { var longititude = response.Longitude; var lat = response.Latitude; var formatted_address = response.Formatted_address; var addressToSave = new AdresseTable(); addressToSave.AptNo = form.Appartement; addressToSave.CodePostal = form.CodePostal; addressToSave.Ville = form.Localite; addressToSave.Pays = form.Pays; addressToSave.Province = form.Region; addressToSave.GeoCodeResponse = formatted_address; addressToSave.Lattitude = (decimal)lat; addressToSave.Longitude = (decimal)longititude; var saisiNoteWriter = new SaisiNoteWriter(new MailSender(), new SaisiNoteContext()); saisiNoteWriter.SaveAddresNoteSaisi(addressToSave); var id = saisiNoteWriter.GetAddressId(addressToSave); var noteToSave = new NoteTable(); noteToSave.Note = form.Note; noteToSave.AdresseId = id; noteToSave.UserId = 1; noteToSave.StatutNote = 0; //saisiNoteWriter.SaveNoteSaisi(noteToSave); ViewBag.Message = "Enregistrement reussie!"; ViewBag.NumTimes = 1; ViewData["color"] = "green"; } else { ViewBag.Message = "vous devez inserez une adresse valide!"; ViewBag.NumTimes = 1; ViewData["color"] = "red"; } } catch (Exception ex) { ViewBag.Message = "La note n'a pas été enregistrée. Réessayer plus tard!"; ViewBag.NumTimes = 1; ViewData["color"] = "red"; } } return View(form); }
// // POST: /SaisiNote/NoterAppartement public ActionResult NoterAppartement(string address, string country, string zip, string provincia, string citta, string appart, string lng, string lat, string nota) { //SaisiNoteForm form = new SaisiNoteForm(); var data = new { indirizzo = address, Pays = country, zip = zip, province = provincia, ville = citta, appartement = appart, longitude = lng, latitude = lat, note = nota }; string resultMessage = ""; var result = new { returnValue = "" }; try { var valLng = Double.Parse(lng, CultureInfo.InvariantCulture); var valLat = Double.Parse(lat, CultureInfo.InvariantCulture); var addressToSave = new AdresseTable(); addressToSave.RueNo = int.Parse(GetRueAndNumero(address)[0]); addressToSave.Rue = GetRueAndNumero(address)[1]; addressToSave.AptNo = appart; addressToSave.CodePostal = zip; addressToSave.Ville = citta; addressToSave.Pays = country; addressToSave.Province = provincia; addressToSave.GeoCodeResponse = address; addressToSave.Lattitude = (decimal)valLat; addressToSave.Longitude = (decimal)valLng; var saisiNoteWriter = new SaisiNoteWriter(new MailSender(), new SaisiNoteContext()); saisiNoteWriter.SaveAddresNoteSaisi(addressToSave); var id = saisiNoteWriter.GetAddressId(addressToSave); var noteToSave = new NoteTable(); noteToSave.Note = int.Parse(nota); noteToSave.AdresseId = id; UserTable userVariable = (UserTable)HttpContext.Session["UserSessionObject"]; noteToSave.UserId = userVariable.UserId; noteToSave.StatutNote = 0; saisiNoteWriter.SaveNoteSaisi(noteToSave, out resultMessage); result = new { returnValue = resultMessage }; } catch (Exception ex) { result = new { returnValue = " Error" }; } return Json(result); //return RedirectToAction("SearchNoted", "AdresseTable", "searchPhrase=7060 Rue Hutchison, Montréal, QC H3N 1Y6, Canada"); }
public void SaveNoteSaisi(NoteTable note, out string resultMessage) { var config = WebConfigurationManager.OpenWebConfiguration("~"); string receiverMail = config.AppSettings.Settings["ReceiverMail"].Value; string senderMail = config.AppSettings.Settings["SenderMail"].Value; var mailTo = receiverMail; var mailFrom = senderMail; var msg = "Cher Administrateur, \nUn appartement [avec une note] dont la note est égale à zéro vient d'être ajouté.\nLes informations de l’appartement sont disponibles ici : [lien vers une page d’administration de l’appartement].\n\nBonne journée.\n"; var obj = "NoteTaLoc - Notification : note à 0"; _SaisiNoteContext.SaveNote(note, out resultMessage); if (note.Note == 0) { _MailSender.SendMail(mailTo, mailFrom, obj, msg); } else { _SaisiNoteContext.UpdateNoteStatus(note); } }