void AddOrUpdateUser(PTMContex context, string ProjectName, string FirstName)
{
var prjct = context.Projects.SingleOrDefault(p => p.ProjectName == ProjectName);
var usr = context.Users.SingleOrDefault(u => u.FirstName == FirstName);
if (usr != null)
{
prjct.users.Add(context.Users.Single(u => u.FirstName == FirstName));
}
}
void AddorUpdatePart(PTMContex contex, string projectName, string partName)
{
var prjct = contex.Projects.SingleOrDefault(p => p.ProjectName == projectName);
var prt = contex.parts.SingleOrDefault(i => i.PartName == partName);
if (prt != null)
{
prjct.parts.Add(contex.parts.Single(p => p.PartName == partName));
}
}
void AddOrUpdateProject_Level(PTMContex context, string ProjectName, string levelId)
{
var prjct = context.Projects.SingleOrDefault(p => p.ProjectName == ProjectName);
var level = context.Levels.SingleOrDefault(l => l.levelId == levelId);
if (level != null)
{
prjct.Levels.Add(context.Levels.Single(u => u.levelId == levelId));
}
}
void AddOrUpdateLevel_Part(PTMContex context, string levelId, string PartName)
{
var level = context.Levels.SingleOrDefault(p => p.levelId == levelId);
var part = context.Parts.SingleOrDefault(u => u.PartName == PartName);
if (part != null)
{
level.parts.Add(context.Parts.Single(u => u.PartName == PartName));
}
}
public ActionResult Index()
{
PTMContex ptmContex = new PTMContex();
var getProjectList = ptmContex.Projects.ToList();
SelectList Idlist = new SelectList(getProjectList, "ProjectId", "ProjectId");
SelectList Namelist = new SelectList(getProjectList, "ProjectName", "ProjectName");
ViewBag.projectListId = Idlist;
ViewBag.projectListName = Namelist;
return(View());
}
public ActionResult Register(User account)
{
if (ModelState.IsValid)
{
using (PTMContex db = new PTMContex())
{
db.Users.Add(account);
db.SaveChanges();
}
ModelState.Clear();
ViewBag.Message = account.FirstName + " " + account.LastName + " successfully registered.";
}
return(View());
}
public ActionResult Index()
{
PTMContex ptmContex = new PTMContex();
//List<SelectListItem> items = new List<SelectListItem>();
//items.Add(new SelectListItem { Text = "option1", Value = "option2" });
//items.Add(new SelectListItem { Text = "option2", Value = "option2" });
var getProjectList = ptmContex.Projects.ToList();
SelectList Idlist = new SelectList(getProjectList, "ProjectId", "ProjectId");
SelectList Namelist = new SelectList(getProjectList, "ProjectName", "ProjectName");
ViewBag.projectListId = Idlist;
ViewBag.projectListName = Namelist;
//ViewBag.selectedItemList = items;
return(View());
}
public ActionResult Login(User user)
{
using (PTMContex db = new PTMContex())
{
var usr = db.Users.Where(u => u.FirstName == user.FirstName && u.LastName == user.LastName).FirstOrDefault();
if (usr != null)
{
Session["UserId"] = usr.UserId.ToString();
Session["FirstName"] = usr.FirstName.ToString();
return(RedirectToAction("Index", "Home"));
}
else
{
ModelState.AddModelError("", "Username or Password is wrong.");
}
}
return(View());
}
