// 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));
}
