public ViewResult UserPage(Guid id)
{
var userPageView = new UserPageView
{
Updates = _socialMediaRepo.GetTenLatestUpdatesForUser(id),
User = _socialMediaRepo.GetUserById(id)
};
return(View(userPageView));
}
private void InitializePages()
{
WelcomePV = new WelcomePageView();
FirstSWV = new FirstSetupWizardView();
RecentPV = new RecentProjectView();
ProjectWV = new ProjectWizardView();
WikitPV = new WikiPageView();
AboutPV = new AboutPageView();
SettingsPV = new SettingsPageView();
WebsitePV = new WebsitePageView();
UserPV = new UserPageView();
GithubPV = new GithubPageView();
IntegratedTPV = new IntegratedToolsPageView();
}
public JsonResult CreateUserPageView()
{
errordata data = new errordata();
data.type = "error";
try
{
int userid = 0;
try { userid = Convert.ToInt16(System.Web.HttpContext.Current.Session["UserID"].ToString()); } catch { }
string pageurl = Request.UrlReferrer.AbsolutePath;
UserPageView userpageview = new UserPageView();
userpageview.UserID = userid;
userpageview.PageUrl = pageurl;
userpageview.DateAccessed = DateTime.Now;
db.UserPageViews.Add(userpageview);
db.SaveChanges();
}
catch { data.message = "Error"; }
return(Json(data, JsonRequestBehavior.AllowGet));
}
private void UpdateUserSession(string Controller, string Action, string ID)
{
string UserIP = Request.UserHostAddress;
//List<UserSessions> ExistingVisitorSession = System.Web.HttpContext.Current.Application[Sessions.VisitorSessions] as List<UserSessions>;
List<UserPageView> ExistingVisitorSession = System.Web.HttpContext.Current.Application[Sessions.VisitorSessions] as List<UserPageView>;
//System.Web.HttpContext.Current.Application["Name"] = "Value";
if (ExistingVisitorSession == null) // First User
{
List<UserPageView> ListSes = new List<UserPageView>();
UserPageView sess = new UserPageView
{
CreatedOn = DateTime.UtcNow,
LastActivityOn = DateTime.UtcNow,
UserIP = UserIP,
Action = Action,
Controller = Controller,
ID = ID,
Count = 1
};
ListSes.Add(sess);
ExistingVisitorSession = ListSes;
//Session.Add(Sessions.VisitorSessions, ListSes);
System.Web.HttpContext.Current.Application.Lock();
System.Web.HttpContext.Current.Application.Add(Sessions.VisitorSessions, ListSes); // Adding first user into Visitor Lists
System.Web.HttpContext.Current.Application.UnLock();
}
else
{
if (ExistingVisitorSession.Where(m => m.UserIP == UserIP).Any()) // Existing User
{
//List<UserPageView> UserSes = ExistingVisitorSession.Where(m => m.UserIP == UserIP).ToList();
//UserPageView PageView = UserSes.UserPageViews.Where(m => m.ID == ID && m.Controller == m.Controller && m.Action == Action).FirstOrDefault();
UserPageView PageView = ExistingVisitorSession.Where(m => m.UserIP == UserIP && m.ID == ID && m.Controller == m.Controller && m.Action == Action).FirstOrDefault();
if (PageView != null)
{
// Update the page count if user last visit time is more than 1 hour
if (PageView.LastActivityOn < DateTime.UtcNow.AddMinutes(-1))
{
PageView.Count += 1;
}
PageView.LastActivityOn = DateTime.UtcNow;
ExistingVisitorSession.Remove(ExistingVisitorSession.Where(m => m.ID == ID && m.Controller == m.Controller && m.Action == Action && m.UserIP == UserIP).FirstOrDefault());
ExistingVisitorSession.Add(PageView);
}
else
{
ExistingVisitorSession.Add(new UserPageView { UserIP = UserIP, Action = Action, Controller = Controller, ID = ID, Count = 1, CreatedOn = DateTime.UtcNow, LastActivityOn = DateTime.UtcNow });
}
}
else // New User
{
ExistingVisitorSession.Add(
new UserPageView
{
UserIP = UserIP,
Action = Action,
Controller = Controller,
Count = 1,
ID = ID,
CreatedOn = DateTime.UtcNow,
LastActivityOn = DateTime.UtcNow
}
);
}
//Session.Add(Sessions.VisitorSessions, ExistingVisitorSession); // Updating Existing User Session with current page view request
System.Web.HttpContext.Current.Application.Lock();
System.Web.HttpContext.Current.Application.Add(Sessions.VisitorSessions, ExistingVisitorSession); // Updating Existing User Session with current page view request
System.Web.HttpContext.Current.Application.UnLock();
}
UserAvtivitHub hub = new UserAvtivitHub();
hub.UserAcvititySend(UserSessionsToView(ExistingVisitorSession));
// Timer
HttpCookie cookie = Request.Cookies[Cookies.TimezoneOffset];
int TimeZoneOffset = 0;
if (cookie != null)
TimeZoneOffset = Convert.ToInt32(cookie.Value);
HostingEnvironment.RegisterObject(new BackgroundUptimeServerTimer(TimeZoneOffset));
}
public async Task <UserPageView> GetPageList(UserParm parm)
{
return(await WithConnection(async c =>
{
StringBuilder sql = new StringBuilder();
sql.Append($@" SELECT
a.id,
a.acc_name,
a.password,
a.random_num,
a.user_name,
a.job_number,
a.role_id,
a.age,
a.nation,
a.nativeplace,
a.edu,
a.job_title,
a.position,
a.id_card,
a.birth,
a.sex,
a.mobile,
a.mobile_short,
a.email,
a.address,
a.id_photo,
a.out_man,
a.created_time,
a.created_by,
a.updated_time,
a.updated_by,
a.is_del,
a.is_super,
b.`user_name` AS created_name,
c.`user_name` AS updated_name
FROM USER a
LEFT JOIN USER b ON a.`created_by` = b.id
LEFT JOIN USER c ON a.`updated_by`= c.id
");
sql.Append(" WHERE a.is_del = 0 ");
if (!string.IsNullOrEmpty(parm.UserName))
{
sql.Append(" and a.user_name like '%" + parm.UserName.Trim() + "%' ");
}
if (!string.IsNullOrEmpty(parm.JobNumber))
{
sql.Append(" and a.job_number like '%" + parm.JobNumber.Trim() + "%' ");
}
var data = await c.QueryAsync <User>(sql.ToString());
var total = data.ToList().Count;
sql.Append(" order by a." + parm.sort + " " + parm.order)
.Append(" limit " + (parm.page - 1) * parm.rows + "," + parm.rows);
var ets = await c.QueryAsync <User>(sql.ToString());
await GetRefList(ets.ToList());
UserPageView ret = new UserPageView();
ret.rows = ets.ToList();
ret.total = total;
return ret;
}));
}
