//
// GET: /Researchgroup/AddMember
public ActionResult AddResearchgroupMember(int researchgroupid = 0)
{
Researchgroup researchgroup = db.Researchgroups.Find(researchgroupid);
if (researchgroup == null)
{
return(HttpNotFound());
}
ResearchgroupMemberViewModel RGMemberVM = new ResearchgroupMemberViewModel()
{
ResearchgroupID = researchgroup.ResearchgroupID,
InstitutionID = researchgroup.InstitutionInstitutionID
};
var users = db.UserProfiles
.Where(c => c.Status == "Current" && db.Careerhistories.Where(ch => ch.InstitutionInstitutionID == RGMemberVM.InstitutionID && ch.Status == "Current" && (ch.EndTime == null || ch.EndTime > DateTime.Now)).Select(ch => ch.UserProfileUserId).Contains(c.UserId))
.ToList()
.OrderBy(c => c.UserName)
.Select(s => new
{
UserId = s.UserId,
Name = string.Format("{0} {1} ({2})", s.ForeName, s.SurName, s.Email)
});
ViewBag.UserList = new SelectList(users.AsEnumerable(), "UserId", "Name");
ViewBag.ResearchgroupRoleList = new SelectList(db.Options.Where(o => o.OptionFields.OptionFieldName == "User Role In Research group" && o.Status == "Current").AsEnumerable(), "OptionID", "OptionValue");
return(View(RGMemberVM));
}
public ActionResult Delete(int id)
{
Researchgroup researchgroup = db.Researchgroups.Find(id);
researchgroup.Status = "Deleted";
researchgroup.LastUpdatedBy = (int)Membership.GetUser().ProviderUserKey;
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit(ResearchgroupViewModel ResearchgroupVM)
{
if (!ModelState.IsValid)
{
ViewBag.InstitutionList = new SelectList(db.Institutions.Where(c => c.Status == "Current").OrderBy(c => c.InstitutionName).AsEnumerable(), "InstitutionID", "InstitutionName", ResearchgroupVM.InstitutionID);
return(View());
}
Researchgroup researchgroup = db.Researchgroups.Find(ResearchgroupVM.ResearchgroupID);
researchgroup.ResearchgroupName = ResearchgroupVM.ResearchgroupName;
researchgroup.InstitutionInstitutionID = ResearchgroupVM.InstitutionID;
researchgroup.LastUpdatedBy = (int)Membership.GetUser().ProviderUserKey;
db.Entry(researchgroup).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
//
// GET: /Researchgroup/Edit/5
public ActionResult Edit(int id)
{
Researchgroup researchgroup = db.Researchgroups.Find(id);
if (researchgroup == null)
{
return(HttpNotFound());
}
ResearchgroupViewModel ResearchgroupVM = new ResearchgroupViewModel()
{
ResearchgroupID = researchgroup.ResearchgroupID,
ResearchgroupName = researchgroup.ResearchgroupName,
InstitutionID = researchgroup.InstitutionInstitutionID,
CreatedOn = researchgroup.CreatedOn
};
ViewBag.InstitutionList = new SelectList(db.Institutions.Where(c => c.Status == "Current").OrderBy(c => c.InstitutionName).AsEnumerable(), "InstitutionID", "InstitutionName", ResearchgroupVM.InstitutionID);
return(View(ResearchgroupVM));
}
public ActionResult Create(ResearchgroupViewModel ResearchgroupVM)
{
if (!ModelState.IsValid)
{
ViewBag.InstitutionList = new SelectList(db.Institutions.Where(c => c.Status == "Current").OrderBy(c => c.InstitutionName).AsEnumerable(), "InstitutionID", "InstitutionName", ResearchgroupVM.InstitutionID);
return(View(ResearchgroupVM));
}
Researchgroup researchgroup = new Researchgroup()
{
ResearchgroupName = ResearchgroupVM.ResearchgroupName,
InstitutionInstitutionID = ResearchgroupVM.InstitutionID,
LastUpdatedBy = (int)Membership.GetUser().ProviderUserKey,
CreatedOn = DateTimeOffset.Now,
CreatedBy = (int)Membership.GetUser().ProviderUserKey,
};
db.Researchgroups.Add(researchgroup);
db.SaveChanges();
return(RedirectToAction("Index"));
}
