public IActionResult MemberDetail(int Id) { TblMembers _TblMembers = UnitOfWork.Repository <DevelopersHub.Models.TblMembers>().Get(x => x.Id == Id); MemberDetailViewModel _MemberDetailViewModel = new MemberDetailViewModel(); _MemberDetailViewModel.Member = _TblMembers; return(View(_MemberDetailViewModel)); }
public ActionResult Register(TblMembers user) { if (ModelState.IsValid) { _context.TblMembers.Add(user); _context.SaveChanges(); ModelState.Clear(); ViewBag.Message = user.FirstName + " " + user.LastName + " is successfully registered."; } return(View()); }
public IActionResult Index() { List <Models.TblMembers> _TblMembers = UnitOfWork.Repository <DevelopersHub.Models.TblMembers>().GetAll().ToList <Models.TblMembers>(); int _Count = _TblMembers.Count(); QueryParameters _queryparameters = new QueryParameters(); _queryparameters.SqlSourceObjectName = "Tbl_Members"; _queryparameters.PageIndex = 0; _queryparameters.PageSize = 11; Microsoft.EntityFrameworkCore.Storage.RelationalDataReader _RelationalDataReader = UnitOfWork.GetResult <DevelopersHub.Models.TblMembers>(_queryparameters); IndexViewModel __indexViewModel = new ViewModels.IndexViewModel(); __indexViewModel.Members = new List <TblMembers>(); while ( _RelationalDataReader.DbDataReader.Read()) { TblMembers tblmembers = new TblMembers(); tblmembers.Fname = _RelationalDataReader.DbDataReader["FName"].ToString(); tblmembers.Sname = _RelationalDataReader.DbDataReader["SName"].ToString(); tblmembers.Id = Convert.ToInt32(_RelationalDataReader.DbDataReader["Id"].ToString()); __indexViewModel.Members.Add(tblmembers); } UnitOfWork.CloseReader(); List <TblProposals> __list_proposals = UnitOfWork.Repository <TblProposals>().GetAll().ToList(); __indexViewModel.Proposals = __list_proposals; foreach (TblProposals item in __indexViewModel.Proposals) { item.M = UnitOfWork.Repository <DevelopersHub.Models.TblMembers>().Get(x => x.Id == item.Id); } ViewModel = __indexViewModel; ViewData["Message"] = "Forums " + _Count.ToString(); return(View(__indexViewModel)); }
public IActionResult MemberProposals(int Id) { TblMembers _member = UnitOfWork.Repository <DevelopersHub.Models.TblMembers>().Get(x => x.Id == Id); //List<TblProposals> _list_TblProposals = //UnitOfWork.Repository<DevelopersHub.Models.TblProposals>().GetAll(x => x.Mid == MemberId).ToList(); //int _Count = _TblMembers.Count(); QueryParameters _queryparameters = new QueryParameters(); _queryparameters.SqlSourceObjectName = "Tbl_Proposals"; _queryparameters.Where = "mid=@mid"; _queryparameters.SqlParams.Add(new System.Data.SqlClient.SqlParameter("@mid", Id)); _queryparameters.PageIndex = Convert.ToInt32(RouteParams["Page"].value); _queryparameters.PageSize = 2; Microsoft.EntityFrameworkCore.Storage.RelationalDataReader _RelationalDataReader = UnitOfWork.GetResult <DevelopersHub.Models.TblProposals>(_queryparameters); MemberProposalsViewModel __MemberProposalsViewModel = new ViewModels.MemberProposalsViewModel(); __MemberProposalsViewModel.PageCount = _queryparameters.PageCount; __MemberProposalsViewModel.PageNumber = Convert.ToInt32(RouteParams["Page"].value); __MemberProposalsViewModel.Proposals = new List <TblProposals>(); ViewModel = __MemberProposalsViewModel; while ( _RelationalDataReader.DbDataReader.Read()) { TblProposals tblproposals = new TblProposals(); tblproposals.Title = _RelationalDataReader.DbDataReader["Title"].ToString(); tblproposals.Technologies = _RelationalDataReader.DbDataReader["Technologies"].ToString(); tblproposals.SnapshotFile = _RelationalDataReader.DbDataReader["SnapshotFile"].ToString(); tblproposals.Id = Convert.ToInt32(_RelationalDataReader.DbDataReader["Id"].ToString()); __MemberProposalsViewModel.Proposals.Add(tblproposals); } __MemberProposalsViewModel.Member = _member; return(View(__MemberProposalsViewModel)); }
public async Task <IActionResult> OnGetAsync(int?id) { if (id == null) { return(NotFound()); } TblMembers = await _context.TblMembers.FirstOrDefaultAsync(m => m.MemberId == id); if (TblMembers == null) { return(NotFound()); } return(Page()); }
public async Task <IActionResult> OnGetAsync(int?id) { if (User.Identity.IsAuthenticated) { tblMembers = Services.CurrentMember; if (id == null || tblMembers == null) { return(RedirectToPage("/Error")); } if (Services.CurrentMember == null) { tblMembers = await _context.TblMembers.FirstOrDefaultAsync(m => m.MemberId == id); } } return(Page()); }
public async Task OnGetAsync() { if (User.Identity.IsAuthenticated) { if (Services.CurrentMember != null) { TblMembers = await _context.TblMembers.Where(m => m.MemberId == Services.UserMemberId).SingleOrDefaultAsync(); Services.CurrentMember = TblMembers; } } else { RedirectToPage("/Index"); } }
public async Task <IActionResult> OnPostAsync(int?id) { if (id == null) { return(NotFound()); } TblMembers = await _context.TblMembers.FindAsync(id); if (TblMembers != null) { _context.TblMembers.Remove(TblMembers); await _context.SaveChangesAsync(); } return(RedirectToPage("./Index")); }
public async Task <IActionResult> OnGetAsync(int?id) { if (User.Identity.IsAuthenticated) { if (id == null) { return(NotFound()); } if (Services.CurrentMember != null) { tblMembers = Services.CurrentMember; } else { tblMembers = await _context.TblMembers.FirstOrDefaultAsync(m => m.MemberId == id); } } return(Page()); }
public IActionResult Index() { List <Models.TblMembers> _TblMembers = UnitOfWork.Repository <DevelopersHub.Models.TblMembers>().GetAll().ToList <Models.TblMembers>(); int _Count = _TblMembers.Count(); QueryParameters _queryparameters = new QueryParameters(); _queryparameters.SqlSourceObjectName = "Tbl_Members"; _queryparameters.PageIndex = Convert.ToInt32(RouteParams["Page"].value);; _queryparameters.PageSize = 2; Microsoft.EntityFrameworkCore.Storage.RelationalDataReader _RelationalDataReader = UnitOfWork.GetResult <DevelopersHub.Models.TblMembers>(_queryparameters); MembersViewModel __membersViewModel = new ViewModels.MembersViewModel(); __membersViewModel.PageCount = _queryparameters.PageCount; __membersViewModel.PageNumber = Convert.ToInt32(RouteParams["Page"].value); __membersViewModel.Members = new List <TblMembers>(); ViewModel = __membersViewModel; while ( _RelationalDataReader.DbDataReader.Read()) { TblMembers tblmembers = new TblMembers(); tblmembers.Fname = _RelationalDataReader.DbDataReader["FName"].ToString(); tblmembers.Sname = _RelationalDataReader.DbDataReader["SName"].ToString(); tblmembers.Bdate = _RelationalDataReader.DbDataReader["Bdate"].ToString(); tblmembers.Id = Convert.ToInt32(_RelationalDataReader.DbDataReader["Id"].ToString()); __membersViewModel.Members.Add(tblmembers); } ViewData["Message"] = "Forums " + _Count.ToString(); return(View(__membersViewModel)); }
public ActionResult Login(TblMembers user) { var account = _context.TblMembers.Where(u => u.EmailId == user.EmailId && u.Password == user.Password).FirstOrDefault(); if (account != null) { HttpContext.Session.SetString("UserID", account.MemberId.ToString()); HttpContext.Session.SetString("Username", account.FirstName); HttpContext.Session.SetString("id", account.MemberId.ToString()); return(RedirectToAction("Index", "Home")); } else if (user.EmailId == "*****@*****.**" && user.Password == "Admin123") { HttpContext.Session.SetString("UserID", "Admin"); // HttpContext.Session.SetString("id", "1"); HttpContext.Session.SetString("Username", "Admin"); return(RedirectToAction("Category", "Admin")); } else { ModelState.AddModelError("", "Username or password is wrong."); } return(View()); }
public void OnGet() { Parvande = Services.CurrentMember.وضعیتپرونده; Members = Services.CurrentMember; }