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