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"));
}
}
}
