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