public ActionResult Edit([Bind(Include = "IdInterview,Date,Name,Comment,Canceled,Suspended,Description,Completion,IdCampaign,Id")] Interview.Interview interview)
{
var b = Request.Form["Consultant"];
interview.Id = b;
if (ModelState.IsValid)
{
db.Entry(interview).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
var idcamp = interview.IdCampaign;
var consultants =
db.ConsultantCampaigns.Include(cc => cc.ApplicationUsers)
.Where(cc => cc.IdCampaign == idcamp)
.Where(z => z.ApplicationUsers.Roles.Select(y => y.RoleId)
.Contains("1f468580-90bc-4e5b-b959-73082975919e") ||
z.ApplicationUsers.Roles.Select(y => y.RoleId)
.Contains("1ede4f9a-6f89-4a52-b81d-9ab127beaccf"))
.Select(x => new { Id = x.Id, FullName = x.ApplicationUsers.FirstName + " " + x.ApplicationUsers.LastName });;
ViewBag.Consultant = new SelectList(consultants, "Id", "FullName", interview.Id);
ViewBag.IdCampaign = db.Campaigns.Single(c => c.IdCampaign == idcamp).Name;
int year = (DateTime.Now.Year) - 1;
ViewBag.MinDateDay = "" + DateTime.Now.Day + "/" + DateTime.Now.Month + "/" + year;
return(View(interview));
}
public ActionResult DeleteConfirmed(int id)
{
//foreach (Answer a in db.Answers.Where(x => x.IdInterview == id)) // Soft delete
//{
// db.Answers.Remove(a);
//}
Interview.Interview interview = db.Interviews.Find(id);
//db.Interviews.Remove(interview); // Soft delete
interview.Deleted = true;
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Create([Bind(Include = "IdInterview,Date,Name,Comment,Canceled,Suspended,Description,Completion,Id,IdCampaign")] Interview.Interview interview, string Command)
{
var idcampaign = interview.IdCampaign;
if (ModelState.IsValid)
{
var c = Request.Form["Candidates"];
if (c != null)
{
Array candidats = c.Split(new [] { ',' });
foreach (var i in from string s in candidats select new Interviewee {
IdInterview = interview.IdInterview, IdCandidate = int.Parse(s)
})
{
db.Interviewees.Add(i);
}
}
interview.Completion = 0;
interview.Suspended = false;
interview.Canceled = false;
db.Interviews.Add(interview);
db.SaveChanges();
idcampaign = db.Interviews.Find(interview.IdInterview).IdCampaign;
if (Command == "Create")
{
return(RedirectToAction("Index"));
}
else
{
return(RedirectToAction("Index", "ConductInterview", new { idinterview = interview.IdInterview }));
}
}
//ViewBag.Id = new SelectList(db.Users, "Id", "FullName", interview.Id);
//var idfirm = db.Campaigns.Find(idcampaign).ApplicationUsers.IdFirm;
//ViewBag.Consultant = new SelectList(db.Users.Where(u => u.IdFirm == idfirm), "Id", "FullName");
ViewBag.Consultant = new SelectList(db.ConsultantCampaigns.Include(cc => cc.ApplicationUsers)
.Where(cc => cc.IdCampaign == idcampaign)
.Select(cc => cc.ApplicationUsers).ToList(), "Id", "FullName");
ViewBag.IdCampaign = new SelectList(db.Campaigns.Where(c => c.Deleted == false), "IdCampaign", "Name", interview.IdCampaign);
//ViewBag.IdQuestionnaire = new SelectList(db.Questionnaires, "IdQuestionnaire", "Name", interview.Campaign.IdQuestionnaire);
var candidates = from cc in db.CandidateCampaigns
join c in db.Candidates on cc.IdCandidate equals c.IdCandidate
where cc.IdCampaign == idcampaign
orderby c.LastName
select new { IdCandidate = c.IdCandidate, FullName = c.FirstName + " " + c.LastName };
ViewBag.Candidates = new MultiSelectList(candidates, "IdCandidate", "FullName");
return(View(interview));
}
public ActionResult Create([Bind(Include = "IdInterview,Date,Name,Comment,Canceled,Suspended,Description,Completion,Id,IdCampaign")] Interview.Interview interview, string Command)
{
var idcampaign = interview.IdCampaign;
if (ModelState.IsValid)
{
var c = Request.Form["Candidates"];
if (c != null)
{
Array candidats = c.Split(new[] { ',' });
foreach (var i in from string s in candidats select new Interviewee {
IdInterview = interview.IdInterview, IdCandidate = int.Parse(s)
})
{
db.Interviewees.Add(i);
}
}
interview.Completion = 0;
interview.Suspended = false;
interview.Canceled = false;
db.Interviews.Add(interview);
db.SaveChanges();
//idcampaign = db.Interviews.Find(interview.IdInterview).IdCampaign;
ConductInterviewController cic = new ConductInterviewController();
cic.SaveCoverageCompletion(idcampaign);
return(Command == "Create" ? RedirectToAction("Details", "Campaigns", new { id = idcampaign })
: RedirectToAction("Index", "ConductInterview", new { idinterview = interview.IdInterview }));
}
ViewBag.Consultant = new SelectList(db.ConsultantCampaigns.Include(cc => cc.ApplicationUsers)
.Where(cc => cc.IdCampaign == idcampaign)
.Select(cc => cc.ApplicationUsers).ToList(), "Id", "FullName");
ViewBag.IdCampaign = new SelectList(db.Campaigns.Where(c => c.Deleted == false), "IdCampaign", "Name", interview.IdCampaign);
var candidates = from cc in db.CandidateCampaigns
join c in db.Candidates on cc.IdCandidate equals c.IdCandidate
where cc.IdCampaign == idcampaign
orderby c.LastName
select new { IdCandidate = c.IdCandidate, FullName = c.FirstName + " " + c.LastName + " - " + c.Function };
ViewBag.Candidates = new MultiSelectList(candidates, "IdCandidate", "FullName");
int year = (DateTime.Now.Year) - 1;
ViewBag.MinDateDay = "" + DateTime.Now.Day + "/" + DateTime.Now.Month + "/" + year;
return(View(interview));
}
public ActionResult DeleteConfirmed(int id)
{
//foreach (Answer a in db.Answers.Where(x => x.IdInterview == id)) // Soft delete
//{
// db.Answers.Remove(a);
//}
Interview.Interview interview = db.Interviews.Find(id);
var idcampaign = interview.IdCampaign;
//db.Interviews.Remove(interview); // Soft delete
interview.Deleted = true;
db.SaveChanges();
var cic = new ConductInterviewController();
cic.SaveCoverageCompletion(idcampaign);
return(RedirectToAction("Details", "Campaigns", new { id = interview.IdCampaign }));
}
public ActionResult Edit([Bind(Include = "IdInterview,Date,Name,Comment,Canceled,Suspended,Description,Completion,IdCampaign")] Interview.Interview interview)
{
var b = Request.Form["Consultant"];
interview.Id = b;
if (ModelState.IsValid)
{
db.Entry(interview).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
var idcamp = interview.IdCampaign;
//var idfirm = db.Campaigns.Find(idcamp).ApplicationUsers.IdFirm;
//ViewBag.Consultant = new SelectList(db.Users.Where(u => u.IdFirm == idfirm), "Id", "FullName", interview.Id);
ViewBag.Consultant = new SelectList(db.ConsultantCampaigns.Include(cc => cc.ApplicationUsers).Where(cc => cc.IdCampaign == interview.IdCampaign).Select(cc => cc.ApplicationUsers), "Id", "FullName", interview.Id);
ViewBag.IdCampaign = new SelectList(db.Campaigns.Where(c => c.Deleted == false), "IdCampaign", "Name", interview.IdCampaign);
return(View(interview));
}