// View et post de projet detail les methodes //recupere la liste des membre qui sont pas dans le projet private static IQueryable <Member> NewMethod2(DbCaimanContext _context, List <Member> MemberNoINPro) { List <int> tempIdList = MemberNoINPro.Select(q => q.MemberId).ToList(); var temp = _context.Members.Where(q => !tempIdList.Contains(q.MemberId)); return(temp); }
public ActionResult DetailsNote(int id) { var _context = new DbCaimanContext(); var note = _context.NotePs.Include(c => c.Projet).FirstOrDefault(no => no.NotePId == id); return(View(note)); }
public ActionResult FinishProjet(int id) { var _context = new DbCaimanContext(); Projet projetF = _context.Projets.FirstOrDefault(proId => proId.ProjetId == id); return(View(projetF)); }
//Recupere tous les projets et les membre qui y ont taffer private static Projet NewMethod(int id, DbCaimanContext _context) { return(_context.Projets.Include(c => c.ProjetMembers) .ThenInclude(m => m.Member) .Include(no => no.NotePs) .SingleOrDefault(c => c.ProjetId == id)); }
public ActionResult AdminInfo(User user) { var db = new DbCaimanContext(); var ds = db.Users.SingleOrDefault(x => x.UserMail == User.Identity.Name); var dr = db.Users.Find(ds.UserId); if (user.ConfirmPassword == user.Password) { dr.Password = user.Password; dr.ConfirmPassword = user.ConfirmPassword; db.Users.Update(dr); db.SaveChanges(); ViewBag.Message = "Succès"; return(RedirectToAction("AdminInfo")); } else { ViewBag.Error = "Error"; } return(RedirectToAction("AdminInfo")); }
// GET: Home public ActionResult Index() { var _context = new DbCaimanContext(); /*var allProjet = GetAllProjets();*/ var VmAllP = new AllProjets(); /* var ctx = _context.Projets.Include(MP => MP.ProjetMembers) * .ThenInclude(mem => mem.Member).SingleOrDefault(c=>c.ProjetId == 1);*/ /* var ctx1 = Mapper.DynamicMap<Projet, ProjetsDTO>(ctx); */ var idallPr = _context.Projets.ToList(); List <ProjetsDTO> allProjetMembers = new List <ProjetsDTO>(); foreach (var item in idallPr) { var ctx2 = _context.Projets.Include(MP => MP.ProjetMembers) .ThenInclude(mem => mem.Member).FirstOrDefault(c => c.ProjetId == item.ProjetId); if (ctx2 != null) { ProjetsDTO monMApp = Mapper.Map <Projet, ProjetsDTO>(ctx2); allProjetMembers.Add(monMApp); } } ViewBag.Alls = allProjetMembers.Where(c => c.IsArchieved == false).OrderByDescending(x => x.ProjetId);; VmAllP.Specialites = GetSpecilites(); return(View(VmAllP)); }
[ValidateAntiForgeryToken] // permet d'envoyer un nouveau formulaire a chaque actualisation public ActionResult Login(LoginViewModel model) { if (ModelState.IsValid) { var isValidUser = IsValidUser(model); if (isValidUser != null) { FormsAuthentication.SetAuthCookie(model.UserMail, false); //Ticket d'authentification, valeur false pur empêcher l'enregistrement des cookies sur le navigation ou true pour activer l'enregistrement return(RedirectToAction("Index", "Home")); } else { using (var db = new DbCaimanContext()) { var user = db.Users.ToList(); foreach (var item in user) { if (!model.UserMail.Equals(item.UserMail) && !model.Password.Equals(item.Password)) { ViewData["MessageError"] = "Verifiez vos identifiants"; } } } ModelState.AddModelError("Echec de connexion", "Tentative de connexion non valide"); return(View()); } } else { return(View(model)); } }
private List <User> GetAdmin() { var db = new DbCaimanContext(); var bd = db.Users.ToList(); return(bd); }
public ActionResult Register([Bind(Include = "UserName, UserPnom, UserMail, UserPhone, UserSexe, Password, ConfirmPassword")] RegisterViewMode model) { if (ModelState.IsValid) { using (var db = new DbCaimanContext()) { User user = new User(); user.UserName = model.UserName; user.UserPnom = model.UserPnom; user.UserMail = model.UserMail; user.UserSexe = model.UserSexe; user.UserPhone = model.UserPhone; user.Password = model.Password; user.ConfirmPassword = model.ConfirmPassword; db.Users.Add(user); db.SaveChanges(); } ViewBag.Message = "Utilisateur Enregistré"; ModelState.Clear(); //Nettoyage des champs du formulaire return(View("Register")); } else { return(View("Register", model)); } }
public ActionResult AdminInfo() { var db = new DbCaimanContext(); var ad = GetAdmin(); var bs = new ViewModelAdmin(); bs.Users = ad; return(View(bs)); }
public ActionResult NotesOnProjet(int id) { var _context = new DbCaimanContext(); var AllNotesForPro = _context.Projets.Include(no => no.NotePs) .SingleOrDefault(c => c.ProjetId == id); var NotePro = Mapper.Map <Projet, NoteAddProDetailDTO>(AllNotesForPro); NoteAddProDetailDTO NoteDTO = new NoteAddProDetailDTO(); NoteDTO = NotePro; return(View(NoteDTO)); }
private Projet GetProDetails(int?idPro) { var _context = new DbCaimanContext(); var projet = _context.Projets .Where(pro => pro.ProjetId == idPro) .Include(no => no.NotePs .OrderByDescending(noId => noId.NotePId) .Take(2)) .Include(mPro => mPro.ProjetMembers) .ThenInclude(mem => mem.Member) .ThenInclude(sp => sp.SpecialiteMember) .SingleOrDefault(); return(projet); }
public ActionResult NewMember() { var _context = new DbCaimanContext(); var spe = _context.Specialites.ToList(); var Tra = _context.Transports.ToList(); var pm = new SaveMemberViewModel() { Specialites = spe, Transports = Tra }; _context.Dispose(); return(View(pm)); }
//fin des methodes projet detail public ActionResult Directive(int id) { var _context = new DbCaimanContext(); var proDirective = _context.Projets.FirstOrDefault(p => p.ProjetId == id); if (proDirective != null) { var mapProjetDirect = Mapper.Map <Projet, ProjetDirectiveDTO>(proDirective); return(View(mapProjetDirect)); } else { return(RedirectToAction("Index", "NotFound")); } }
//Fonction de Vérification de l'existance d'un utilisateur public User IsValidUser(LoginViewModel model) { using (var db = new DbCaimanContext()) { User user = db.Users.Where(q => q.UserMail.Equals(model.UserMail) && q.Password.Equals(model.Password)).SingleOrDefault(); if (user == null) { return(null); } else { return(user); } } }
public ActionResult AddNotes(int id) { var _context = new DbCaimanContext(); var bd = _context.Projets.Include(Projet => Projet.NotePs) .SingleOrDefault(c => c.ProjetId == id); if (bd != null) { var NotePro = Mapper.Map <Projet, NoteAddProDetailDTO>(bd); NoteAddProDetailDTO NoteDTO = new NoteAddProDetailDTO(); NoteDTO = NotePro; return(View(NoteDTO)); } return(View()); }
public ActionResult Index() { var _context = new DbCaimanContext(); var viewModel = new ProVm { Members = _context.Members.Select(c => new NewMemberVM { MemberId = c.MemberId, MemberName = c.MemberName, MemberMissionActive = c.MemberMissionActive, SpecialiteId = c.SpecialiteId, MemberImageName = c.MemberImageName, IsChecked = false }).ToList(), Specialites = _context.Specialites.ToList() }; return(View(viewModel)); }
public ActionResult OldMembers(int page = 0) { const int PageSize = 6; var _context = new DbCaimanContext(); var oldMember = _context.Members.Where(m => m.MemberIsArchived == true).ToList(); var count = oldMember.Count(); var data = oldMember.Skip(page * PageSize).Take(PageSize).OrderByDescending(c => c.MemberId).ToList(); ViewBag.MaxPage = (count / PageSize) - (count % PageSize == 0 ? 1 : 0); ViewBag.Page = page; var oldVM = new OldVm(); oldVM.OldMembers = data; oldVM.Specialites = GetSpecilites(); return(View(oldVM)); }
public ActionResult AddNotes(NoteP note, int id) { if (ModelState.IsValid) { var _context = new DbCaimanContext(); if (note.NotePDescription != null) { Projet projetAdd = new Projet(); projetAdd = _context.Projets.FirstOrDefault(c => c.ProjetId == id); projetAdd.NotePs = new List <NoteP>(); NoteP notepAdd = new NoteP(); notepAdd.NotePDate = DateTime.Now; notepAdd.NotePDescription = note.NotePDescription; projetAdd.NotePs.Add(notepAdd); _context.Projets.Update(projetAdd); _context.SaveChanges(); return(RedirectToAction("ProjetDetail", "Projet", new { id = id })); } else { var bd = _context.Projets.Include(Projet => Projet.NotePs) .SingleOrDefault(c => c.ProjetId == id); if (bd != null) { ViewData["Errors"] = "Veuillez ajouter une note s'il vous plait"; var NotePro = Mapper.Map <Projet, NoteAddProDetailDTO>(bd); NoteAddProDetailDTO NoteDTO = new NoteAddProDetailDTO(); NoteDTO = NotePro; return(View(NoteDTO)); } } } return(View()); }
public ActionResult ProfilMember(int id) { var _context = new DbCaimanContext(); var memberDtail = _context.Members .Include(mem => mem.Competences) .Include(mem => mem.SocialNetworks) .FirstOrDefault(m => m.MemberId == id); var memSpecialite = _context.Specialites.ToList(); var membTrans = _context.Transports.ToList(); var memberWithAllDetails = Mapper.Map <Member, ProfilMemberDTO>(memberDtail); ProfilMVM profilMVM = new ProfilMVM(); profilMVM.ProfilMemberDTO = memberWithAllDetails; profilMVM.Specialites = memSpecialite; profilMVM.Transports = membTrans; return(View(profilMVM)); }
public ActionResult ArchiveAllProjet(int page = 0) { var _context = new DbCaimanContext(); /*var allProjet = GetAllProjets();*/ var VmAllP = new AllProjets(); var ctx = _context.Projets.Include(MP => MP.ProjetMembers) .ThenInclude(mem => mem.Member).SingleOrDefault(c => c.ProjetId == 1); var ctx1 = Mapper.DynamicMap <Projet, ProjetsDTO>(ctx); var idallPr = _context.Projets.ToList(); List <ProjetsDTO> allProjetMembers = new List <ProjetsDTO>(); foreach (var item in idallPr) { var ctx2 = _context.Projets.Include(MP => MP.ProjetMembers) .ThenInclude(mem => mem.Member).FirstOrDefault(c => c.ProjetId == item.ProjetId); if (ctx2 != null) { ProjetsDTO monMApp = Mapper.Map <Projet, ProjetsDTO>(ctx2); allProjetMembers.Add(monMApp); } } var bedroom = allProjetMembers.Where(c => c.IsArchieved == true); const int PageSize = 3; // you can always do something more elegant to set this var count = bedroom.Count(); var data = bedroom.Skip(page * PageSize).Take(PageSize).ToList().OrderByDescending(x => x.ProjetId); ViewBag.MaxPage = (count / PageSize) - (count % PageSize == 0 ? 1 : 0); ViewBag.Page = page; ViewBag.Alls = data; VmAllP.Specialites = GetSpecilites(); return(View(VmAllP)); }
// GET: Projet public ActionResult ProjetDetail(int id) { var _context = new DbCaimanContext(); _context.ChangeTracker.QueryTrackingBehavior = QueryTrackingBehavior.NoTracking; ProDetailVm proDetailVm = new ProDetailVm(); var projetDetail = _context.Projets.Include(c => c.ProjetMembers) .ThenInclude(m => m.Member) .Include(no => no.NotePs) .SingleOrDefault(c => c.ProjetId == id); ViewBag.Specialites = _context.Specialites.ToList(); var db = new DbCaimanContext(); var Members = db.Members.ToList(); var projetDe = Mapper.Map <Projet, ProjetDetailDTO>(projetDetail); ProjetDetailDTO projetDetailDTO = new ProjetDetailDTO(); projetDetailDTO = projetDe; List <Member> MemberNoINPro = new List <Member>(); foreach (var item in projetDe.MembersDTOs) { Member monMApp = Mapper.Map <MembersDTO, Member>(item); MemberNoINPro.Add(monMApp); } List <int> tempIdList = MemberNoINPro.Select(q => q.MemberId).ToList(); var temp = _context.Members.Where(q => !tempIdList.Contains(q.MemberId)); /* var meminNO = _context.Members.Intersect(MemberNoINPro);*/ proDetailVm.projetDetailDTO = projetDetailDTO; proDetailVm.Members = temp; return(View(proDetailVm)); }
public ActionResult ProjetDetail(int id, FormCollection formCollectionMember, string ProjetProgressBar) { var _context = new DbCaimanContext(); _context.ChangeTracker.QueryTrackingBehavior = QueryTrackingBehavior.NoTracking; ProDetailVm proDetailVm = new ProDetailVm(); Projet projetDetail = NewMethod(id, _context); ViewBag.Specialites = _context.Specialites.ToList(); var Members = _context.Members.ToList(); var projetDe = Mapper.Map <Projet, ProjetDetailDTO>(projetDetail); ProjetDetailDTO projetDetailDTO = new ProjetDetailDTO(); projetDetailDTO = projetDe; List <Member> MemberNoINPro = new List <Member>(); NewMethod1(projetDe, MemberNoINPro); IQueryable <Member> temp = NewMethod2(_context, MemberNoINPro); /* var meminNO = _context.Members.Intersect(MemberNoINPro);*/ proDetailVm.projetDetailDTO = projetDetailDTO; proDetailVm.Members = temp; /* var meminNO = _context.Members.Intersect(MemberNoINPro);*/ /* _context.Dispose();*/ ViewBag.ProgressSous = ""; ViewBag.Progress = ""; List <string> lisMembers = new List <string>(); List <Member> memberSelect = new List <Member>(); if (formCollectionMember != null && id != 0) { if (ProjetProgressBar == null) { for (int i = 0; i < formCollectionMember.Count; i++) { lisMembers.Add(formCollectionMember[i]); } foreach (var item in lisMembers) { Member addMem = new Member(); addMem = _context.Members.FirstOrDefault(c => c.MemberId == int.Parse(item)); addMem.IsChecked = false; memberSelect.Add(addMem); } } var contextNoTrack = new DbCaimanContext(); contextNoTrack.ChangeTracker.QueryTrackingBehavior = QueryTrackingBehavior.NoTracking; var listMemberIsSelected = contextNoTrack.Projets.FirstOrDefault(c => c.ProjetId == id); if (ProjetProgressBar != null) { int progress = int.Parse(ProjetProgressBar); // verifier si la progression depasse 97% et ramene un message d'erreur if (progress > 97) { ViewData["NameError"] = "La progression ne dois peut pas acceler 97 %"; ViewData["NameError"] = "Svp veuillez entrer une valeur inferieur a 97.01 %"; return(View(proDetailVm)); } if (listMemberIsSelected.ProjetProgressBar < progress && progress < 97) { listMemberIsSelected.ProjetProgressBar = progress; } contextNoTrack.Projets.Update(listMemberIsSelected); } listMemberIsSelected.ProjetMembers = new List <ProjetMember>(); if (memberSelect != null) { foreach (var mem in memberSelect) { var member = new Member { MemberId = mem.MemberId }; contextNoTrack.Members.Attach(member); var projetMember = new ProjetMember { Member = member }; listMemberIsSelected.ProjetMembers.Add(projetMember); } } contextNoTrack.Projets.Update(listMemberIsSelected); contextNoTrack.SaveChanges(); return(RedirectToAction("ProjetDetail", "Projet", new { id = id })); } return(View(proDetailVm)); }
public ActionResult Register([Bind(Include = "UserName, UserPnom, UserMail, UserPhone, UserSexe, Password, ConfirmPassword")] RegisterViewModel model) { if (ModelState.IsValid) { using (var db = new DbCaimanContext()) { var dr = db.Users.ToList(); //Verifier si l'email n'existe deja pas #region Verifier si l'email n'existe deja pas if (dr.Count() >= 1) { foreach (var item in dr) { if (model.UserMail != item.UserMail) { User user = new User(); user.UserName = model.UserName; user.UserPnom = model.UserPnom; user.UserMail = model.UserMail; user.UserSexe = model.UserSexe; user.UserPhone = model.UserPhone; user.Password = model.Password; user.ConfirmPassword = model.ConfirmPassword; db.Users.Add(user); db.SaveChanges(); } else { ViewData["ErrorMail"] = "Mail déja utilisé ; choisissez un autre mail"; } } } #endregion else { User user = new User(); user.UserName = model.UserName; user.UserPnom = model.UserPnom; user.UserMail = model.UserMail; user.UserSexe = model.UserSexe; user.UserPhone = model.UserPhone; user.Password = model.Password; user.ConfirmPassword = model.ConfirmPassword; db.Users.Add(user); db.SaveChanges(); } } ViewBag.Message = "Utilisateur Enregistré"; ModelState.Clear(); //Nettoyage des champs du formulaire return(View("Register")); } else { return(View("Register", model)); } }
public ActionResult NewMember(Member member) { var _context = new DbCaimanContext(); var specialites = _context.Specialites.ToList(); var Tra = _context.Transports.ToList(); var vM = new SaveMemberViewModel { Specialites = specialites, Transports = Tra }; if (!ModelState.IsValid) { vM.Member = member; return(View(vM)); } var tar = new Transport(); if (member.SpecialiteId == 0) { ViewBag.PasSpe = "Veuillez d'abord cree une specialite !"; vM.Member = member; return(View(vM)); } if (ModelState.IsValid) { var date = DateTime.Today.Year; if (member.MemberNaissance.Year >= date) { ViewData["errordate"] = "L'année doit etre inférieure a l'année actuelle"; vM.Member = member; return(View(vM)); } Specialite _Specialite = _context.Specialites.FirstOrDefault(Sp => Sp.SpecialiteId == member.SpecialiteId); _Specialite.Members = new List <Member>(); var memberAdd = new Member(); memberAdd = member; /*memberAdd.MemberCommune = member.MemberCommune; * memberAdd.MemberName = member.MemberName; * memberAdd.MemberPnom = member.MemberPnom; * memberAdd.MemberDescription = member.MemberDescription; * memberAdd.MemberLieuNaissance = member.MemberLieuNaissance; * memberAdd.MemberNaissance = member.MemberNaissance; * memberAdd.MemberPhone = member.MemberPhone; * memberAdd.MemberQuartier = member.MemberQuartier; * memberAdd.MemberMail = member.MemberMail; * memberAdd.MemberTransport = member.MemberTransport; * memberAdd.MemberSex = member.MemberSex;*/ Transport _Transport = _context.Transports.FirstOrDefault(Tr => Tr.TransportId == member.TransportId); _Transport.Members = new List <Member>(); if (_Specialite != null) { _Specialite.Members.Add(memberAdd); _context.Specialites.Update(_Specialite); } _Transport.Members.Add(memberAdd); _context.Transports.Add(_Transport); _context.SaveChanges(); _context.Dispose(); return(RedirectToAction("ProfilMember", "Departement", new { id = memberAdd.MemberId })); } return(View()); }
public ActionResult FinishProjet(Projet proFUp, int id) { var _contextNoTrack = new DbCaimanContext(); var projetF = _contextNoTrack.Projets.Include(c => c.ProjetMembers) .ThenInclude(m => m.Member) .SingleOrDefault(c => c.ProjetId == id); if (ModelState.IsValid) { projetF.IsArchieved = true; projetF.ProjetDateFin = DateTime.Now; projetF.ProjetMoney = proFUp.ProjetMoney; projetF.ProjetObservationFinal = proFUp.ProjetObservationFinal; projetF.ProjetProgressBar = 100; _contextNoTrack.Projets.Update(projetF); _contextNoTrack.SaveChanges(); var _con = new DbCaimanContext(); List <int> tempIdList = projetF.ProjetMembers.Select(q => q.MemberId).ToList(); var temp = _con.Members.Where(q => tempIdList.Contains(q.MemberId)).AsNoTracking(); _contextNoTrack.ChangeTracker.QueryTrackingBehavior = QueryTrackingBehavior.NoTracking; foreach (var selectMember in temp) { var _contextF = new DbCaimanContext(); var memUPDATE = _contextF.Members.SingleOrDefault(m => m.MemberId == selectMember.MemberId); _contextF.Dispose(); memUPDATE.MemberMissionActive -= 1; memUPDATE.MemberMissonFin += 1; _con.Members.Update(memUPDATE); } _con.SaveChanges(); return(RedirectToAction("ArchiveAllProjet", "Home")); } else { ViewData["MessageError"] = "Le bilan est requis s'il vous plait *"; return(View(projetF)); } /* return View(projetF);*/ /* var _contextNoTrack = new DbCaimanContext(); * * var projetF = _contextNoTrack.Projets.Include(c => c.ProjetMembers) * .ThenInclude(m => m.Member).AsNoTracking() * .SingleOrDefault(c => c.ProjetId == id); * if (ModelState.IsValid) * { * if (proFUp.ProjetObservationFinal != null) * { * projetF.IsArchieved = true; * projetF.ProjetDateFin = DateTime.Now; * projetF.ProjetMoney = proFUp.ProjetMoney; * projetF.ProjetObservationFinal = proFUp.ProjetObservationFinal; * projetF.ProjetProgressBar = 100; * var _con = new DbCaimanContext(); * List<int> tempIdList = projetF.ProjetMembers.Select(q => q.MemberId).ToList(); * var temp = _con.Members.Where(q => !tempIdList.Contains(q.MemberId)).AsNoTracking(); * _contextNoTrack.ChangeTracker.QueryTrackingBehavior = QueryTrackingBehavior.NoTracking; * foreach (var memProjet in temp) * { * if (memProjet.MemberMissionActive >= 0) * { * Member memUp = new Member * { * MemberId = memProjet.MemberId, * SpecialiteId = memProjet.SpecialiteId, * TransportId = memProjet.TransportId * }; * * var ds = _contextNoTrack.Members.SingleOrDefault(s => s.MemberId == memProjet.MemberId); * var up = _contextNoTrack.Members.Find(ds.MemberId); * up.MemberMissionActive -= 1; * up.MemberMissonFin += 1; * up.SpecialiteId = memProjet.SpecialiteId; * up.TransportId = memProjet.TransportId; * _contextNoTrack.Members.Update(up); * * _contextNoTrack.SaveChanges(); * var proMP = new ProjetMember * { * Member = memUp * }; * projetF.ProjetMembers.Add(proMP); * } * else * { * Member memUp = new Member * { * MemberId = memProjet.MemberId, * SpecialiteId = memProjet.SpecialiteId, * TransportId = memProjet.TransportId * * }; * * var ds = _contextNoTrack.Members.SingleOrDefault(s => s.MemberId == memUp.MemberId); * var up = _contextNoTrack.Members.Find(ds.MemberId); * up.MemberMissonFin += 1; * up.SpecialiteId = memUp.SpecialiteId; * up.TransportId = memUp.TransportId; * _contextNoTrack.Members.Update(up); * var proMP = new ProjetMember * { * Member = memUp * }; * projetF.ProjetMembers.Add(proMP); * } * * * } * projetF.ProjetProgressBar = 100; * _con.Projets.Update(projetF); * _con.SaveChanges(); * * return RedirectToAction("ArchiveAllProjet", "Home"); * } * else * { * ViewData["MessageError"] = "Le bilan est requis s'il vous plait *"; * return View(projetF); * } * * } * return View(projetF);*/ }
public ActionResult ProfilMember(Member member, Competence competence, SocialNetwork socialNetwork, int id) { var _context = new DbCaimanContext(); var memberDtail = _context.Members .Include(mem => mem.Competences) .Include(mem => mem.SocialNetworks) .FirstOrDefault(m => m.MemberId == id); var memSpecialite = _context.Specialites.ToList(); var membTrans = _context.Transports.ToList(); var memberWithAllDetails = Mapper.Map <Member, ProfilMemberDTO>(memberDtail); ProfilMVM profilMVM = new ProfilMVM(); profilMVM.ProfilMemberDTO = memberWithAllDetails; profilMVM.Specialites = memSpecialite; profilMVM.Transports = membTrans; var bd = db.Members.Find(id); if (Request.Files.Count > 0) { var file = Request.Files[0]; if (file != null && file.ContentLength > 0) //Vérifie que le fichier existe { var fileName = Path.GetFileName(file.FileName); //Récupération du nom du fichier var path = Path.Combine(Server.MapPath("/Fichier"), fileName); //Enregistrement du fichier dans le dossier Fichier member.MemberImageName = fileName; file.SaveAs(path); bd.MemberImageName = fileName; db.Members.Update(bd); db.SaveChanges(); } } else if (member.MemberPnom != null) { bd.MemberName = member.MemberName; bd.MemberPnom = member.MemberPnom; bd.MemberCommune = member.MemberCommune; bd.MemberDescription = member.MemberDescription; bd.MemberMail = member.MemberMail; bd.MemberQuartier = member.MemberQuartier; bd.MemberCommune = member.MemberCommune; bd.MemberPhone = member.MemberPhone; bd.MemberSex = member.MemberSex; bd.MemberStatus = member.MemberStatus; bd.TransportMember = member.TransportMember; db.Members.Update(bd); db.SaveChanges(); } else if (member.MemberNote != 0) { bd.MemberNote = member.MemberNote; db.Members.Update(bd); db.SaveChanges(); } else { bd.MemberIsArchived = member.MemberIsArchived; bd.MemberDateArchive = DateTime.Now; db.Members.Update(bd); db.SaveChanges(); } if (competence.CompetenceName != null) { var _con = new DbCaimanContext(); Member memberAdd = new Member(); memberAdd = _context.Members.FirstOrDefault(c => c.MemberId == id); memberAdd.Competences = new List <Competence>(); Competence addCompetence = new Competence(); addCompetence.CompetenceName = competence.CompetenceName; memberAdd.Competences.Add(addCompetence); _con.Members.Update(memberAdd); _con.SaveChanges(); _con.Dispose(); /* _Transport.Members = new List<Member>(); * if (_Specialite != null) * { * _Specialite.Members.Add(mem); * _context.Specialites.Update(_Specialite); * } * _Transport.Members.Add(mem); * * _context.Transports.Add(_Transport); * _context.SaveChanges(); * _context.Dispose();*/ } if (socialNetwork.NetworkName != null) { var _con = new DbCaimanContext(); Member memberAdd = new Member(); memberAdd = _context.Members.FirstOrDefault(c => c.MemberId == id); memberAdd.SocialNetworks = new List <SocialNetwork>(); SocialNetwork socialNetwork1 = new SocialNetwork(); socialNetwork1.NetworkName = socialNetwork.NetworkName; socialNetwork1.NetworkLink = socialNetwork.NetworkLink; memberAdd.SocialNetworks.Add(socialNetwork1); _con.Members.Update(memberAdd); _con.SaveChanges(); /* db.SocialNetworks.Add(socialNetwork); * db.SaveChanges();*/ } return(RedirectToAction("ProfilMember", profilMVM)); }
private List <Specialite> GetSpecilites() { var _context = new DbCaimanContext(); return(_context.Specialites.ToList()); }
/*[ValidateAntiForgeryToken]*/ public ActionResult Index(FormCollection fromEnnui) { var _context = new DbCaimanContext(); var viewModel = new ProVm { Members = _context.Members.Select(c => new NewMemberVM { MemberId = c.MemberId, MemberName = c.MemberName, MemberMissionActive = c.MemberMissionActive, SpecialiteId = c.SpecialiteId, IsChecked = false }).ToList(), Specialites = _context.Specialites.ToList(), memerBySpe = _context.Members.ToList() }; List <string> lisMembers = new List <string>(); List <Member> memberSelect = new List <Member>(); for (int i = 0; i < fromEnnui.Count; i++) { if (i >= 2) { lisMembers.Add(fromEnnui[i]); } } foreach (var item in lisMembers) { Member addMem = new Member(); addMem = _context.Members.FirstOrDefault(c => c.MemberId == int.Parse(item)); memberSelect.Add(addMem); } _context.Members.UpdateRange(memberSelect); _context.SaveChanges(); var prName = fromEnnui[0]; var prDescription = fromEnnui["ProjetDescription"]; var file = Request.Files[0]; if (prName == "" && prDescription == "" && file == null) { ViewData["ProjetName"] = "Svp veuillez rentrer le nom du projet"; ViewData["Description"] = "Svp veuillez rentrer la description du projet"; ViewData["Error"] = "Veuillez choisir un document pdf"; return(View(viewModel)); } else if (prName == "" && prDescription == "") { ViewData["ProjetName"] = "Svp veuillez rentrer le nom du projet"; ViewData["Description"] = "Svp veuillez rentrer la description du projet"; return(View(viewModel)); } else if (prName == "") { ViewData["ProjetName"] = "Svp veuillez rentrer le nom du projet"; return(View(viewModel)); } else if (prDescription == "") { ViewData["Description"] = "Svp veuillez rentrer la description du projet"; return(View(viewModel)); } if (file != null) { string projetCahier = ""; var fileName = Path.GetFileName(file.FileName); //Récupération du nom du fichier; var ext = Path.GetExtension(fileName); if (ext == ".pdf" || ext == ".PDF" || ext == ".docx") { if (prName == "" && prDescription == "") { ViewData["ProjetName"] = "Svp veuillez rentrer le nom du projet"; ViewData["Description"] = "Svp veuillez rentrer la description du projet"; return(View(viewModel)); } else if (prName == "") { ViewData["ProjetName"] = "Svp veuillez rentrer le nom du projet"; return(View(viewModel)); } else if (prDescription == "") { ViewData["Description"] = "Svp veuillez rentrer la description du projet"; return(View(viewModel)); } var path = Path.Combine(Server.MapPath("/Fichier"), fileName);//Enregistrement du fichier dans le dossier Fichier file.SaveAs(path); projetCahier = fileName; } else { ViewData["Error"] = "Le cahier de charge doit etre un fichier PDF ou WORD"; return(View(viewModel)); } //une fois le model est valide if (ModelState.IsValid) { var addProjetMembers = new Projet { ProjetCahierCharge = projetCahier, ProjetName = fromEnnui[0], ProjetDateDebut = DateTime.Now, ProjetDescription = fromEnnui[1], ProjetMembers = new List <ProjetMember>() }; var contextNoTrack = new DbCaimanContext(); contextNoTrack.ChangeTracker.QueryTrackingBehavior = QueryTrackingBehavior.NoTracking; /* var listMemberIsSelected = contextNoTrack.Members.Where(c => c.IsChecked == true).ToList();*/ foreach (var selectMember in memberSelect) { var member = new Member { MemberId = selectMember.MemberId }; var ds = _context.Members.SingleOrDefault(s => s.MemberId == member.MemberId); var up = _context.Members.Find(ds.MemberId); up.MemberMissionActive += 1; _context.Members.Update(up); _context.SaveChanges(); contextNoTrack.Members.Attach(member); var projetMember = new ProjetMember { Member = member }; addProjetMembers.ProjetMembers.Add(projetMember); } contextNoTrack.Projets.Add(addProjetMembers); contextNoTrack.SaveChanges(); contextNoTrack.Dispose(); //remet tout les memebres a false foreach (var item in lisMembers) { Member addMem = new Member(); addMem = _context.Members.FirstOrDefault(c => c.MemberId == int.Parse(item)); memberSelect.Add(addMem); _context.Members.UpdateRange(memberSelect); } _context.SaveChanges(); ViewBag.Message = "Succès"; RedirectToAction("Index", "Home"); } } return(View(viewModel)); }