IEnumerable <Member> GetAllMember() { using (SampleProjectEntities db = new SampleProjectEntities()) { // return db.Members.ToList<Member>(); int user = (int)Session["UserID"]; return(db.Members.Where(x => x.UserID == user).ToList <Member>()); } }
public ActionResult AddOrEdit(Models.Member member) { using (SampleProjectEntities db = new SampleProjectEntities()) { Member mem = new Member(); mem.UserID = (int)Session["UserID"]; mem.MemberName = member.MemberName; mem.MemberRelation = member.MemberRelation; mem.MemberAddress = member.MemberAddress; db.Members.Add(mem); db.SaveChanges(); } return(RedirectToAction("index", "DashBoard")); }
public ActionResult Delete(int id) { try { using (SampleProjectEntities db = new SampleProjectEntities()) { Member member = db.Members.Where(x => x.MemberID == id).FirstOrDefault <Member>(); db.Members.Remove(member); db.SaveChanges(); } } catch (Exception) { } return(RedirectToAction("index", "DashBoard")); }
public ActionResult Login(Models.User user) { using (SampleProjectEntities db = new SampleProjectEntities()) { var userDetails = db.Users.Where(x => x.UserName == user.UserName && x.UserPassword == user.UserPassword).FirstOrDefault(); if (userDetails == null) { user.LoginErrorMsg = "you have enter an incorrect password or user name"; return(View("index", user)); } else { Session["UserID"] = userDetails.UserID; Session["Name"] = userDetails.UserName; return(RedirectToAction("index", "DashBoard")); } } }