public static bool IsLoggedIn(long id)
{
bool result = false;
TimeSpan?ts = UserLoggedInTimespan(id);
if (ts != null)
{
if (ts.Value.TotalMinutes < 1)
{
result = true;
}
S_User user = UserManager.GetUserById(id);
if (user != null)
{
if (result)
{
user.logindatetime = DateTime.Now.Ticks;
}
else
{
user.logindatetime = null;
}
Update(user);
}
}
return(result);
}
protected void buttonSubmitForm_Click(object sender, EventArgs e)
{
logger.Debug("We hebben op de knop gedrukt...");
try
{
buttonSubmitForm.Style["visibility"] = "hidden";
S_User user = UserManager.GetUserByEmail(forgottenEmail.Text);
if (!string.IsNullOrEmpty(forgottenEmail.Text) && user != null)
{
logger.Debug("Gebruikler gevonden...");
Mail.SendForgottenMessage(user.email, user.name, user.username, user.frequentbowlernumber);
meldSuccess.InnerHtml = "Er is een mail gestuurd naar het e-mail adres " + forgottenEmail.Text + "<br/>Klik in de e-mail op de link om je wachtwoord opnieuw in te stellen.<br/>(E-mail niet ontvangen? controleer je spam folder).<br/><br/>";
forgottenEmail.Text = string.Empty;
forgottenEmail.Visible = false;
}
else
{
logger.Debug("Gebruiker NIET gevonden op basis van email ades ..." + forgottenEmail.Text);
meldSuccess.InnerHtml = "Er is iets fout gegaan bij het versturen van de e-mail, klopt het e-mailadres?";
}
}
catch (Exception ex)
{
logger.Error(ex.Message);
meldSuccess.InnerHtml = "Er is iets fout gegaan bij het versturen van de e-mail, klopt het e-mailadres?";
}
}
//请求薪水列表数据
public ActionResult GetSalary(int pageIndex = 0, int pageSize = 10)
{
S_User user = Session["CurrentUser"] as S_User;
PageResult <Salary> list = salaryService.GetResList <Salary, DateTime>(o => o.SalaryTime, o => o.UserId == user.id, pageIndex * pageSize, pageSize, false);
return(Json(list));
}
public FrmModelSet(Config config, S_User u)
{
InitializeComponent();
this._config = config;
this._user = u;
this.Load += new EventHandler(FrmModelSet_Load);
}
public static User user(S_User item)
{
if (item == null)
{
return(null);
}
var data = new User()
{
userId = item.userId,
createBy = item.createBy,
createDate = item.createDate,
displayName = item.displayName,
email = item.email,
isActive = item.isActive,
password = item.password,
updateBy = item.updateBy,
updateDate = item.updateDate
};
if (item.S_RoleMapping != null)
{
data.roleMappings = new List <RoleMapping>();
foreach (var r in item.S_RoleMapping)
{
data.roleMappings.Add(roleMapping(r));
}
}
return(data);
}
public ActionResult Insert(AccountModel model)
{
if (ModelState.IsValid)
{
// Attempt to register the contact
try
{
S_User user = new S_User();
user.name = model.Name;
user.email = model.Email;
user.address = model.Address;
user.city = model.City;
user.username = model.UserName;
user.password = model.Password;
user.roleid = Role.ADMINISTRATOR;
user.isMember = model.IsMember;
user.memberNumber = model.MemberNumber;
user.isRegistrationConfirmed = true;
user.frequentbowlernumber = model.FrequentBowlerNumber;
UserManager.Insert(user);
return(RedirectToAction("Index", "Account", new { name = user.name }));
}
catch (MembershipCreateUserException e)
{
ModelState.AddModelError("", ErrorCodeToString(e.StatusCode));
}
}
// If we got this far, something failed, redisplay form
return(View(model));
}
public Favorit[] GetFavorites(string id)
{
logger.Debug(Settings.MethodName());
List <Favorit> favoritsList = new List <Favorit>();
long userid;
if (isCorrectUser(id))
{
try
{
long.TryParse(id, out userid);
List <S_Favorit> favorits = FavoritManager.GetFavoritsByUserId(userid);
foreach (S_Favorit favorit in favorits)
{
S_User user = UserManager.GetUserById(favorit.favorituserId);
Favorit myFavorit = new Favorit();
myFavorit.userid = user.id;
myFavorit.name = user.name;
myFavorit.scores = GameManager.GetScoresByUser(user);
favoritsList.Add(myFavorit);
}
}
catch
{
}
}
return(favoritsList.ToArray());
}
public LogoutResponse Logout(string id)
{
logger.Debug(Settings.MethodName());
logger.Trace("Parameters: id: " + id);
long userid;
long.TryParse(id, out userid);
S_User user = UserManager.GetUserById(userid);
if (user != null)
{
user.logindatetime = null;
UserManager.Update(user);
logger.Trace("Return: Status: OK");
return(new LogoutResponse {
status = "OK"
});
}
else
{
LogoutResponse r = new LogoutResponse();
r.status = "NOTOK";
logger.Trace("Return: Status: " + r.status);
return(r);
}
}
public UserGames GetGames(string id, string otheruserid)
{
logger.Debug(Settings.MethodName());
if (isCorrectUser(id))
{
// voor het opvragen van games van een andere gebruiker, gebruiken we het andere id
if (!String.IsNullOrEmpty(otheruserid))
{
id = otheruserid;
}
UserGames userGames = new UserGames();
long userid;
long.TryParse(id, out userid);
S_User user = UserManager.GetUserById(userid);
if (user != null)
{
userGames = GameManager.GetGamesByUser(user);
}
return(userGames);
}
return(null);
}
public LoginResponse Login(LoginRequest loginRequest)
{
logger.Debug(Settings.MethodName());
logger.Trace("Parameters: login: "******" password: "******" frequentbowlernumber:" + loginRequest.frequentbowlernumber);
S_User user = UserManager.GetUserByNamePasswordAndFrequentbowlernumber(loginRequest.username, loginRequest.password, loginRequest.frequentbowlernumber);
if (user != null)
{
user.logindatetime = DateTime.Now.Ticks;
UserManager.Update(user);
LoginResponse r = new LoginResponse {
userid = user.id, status = "OK"
};
logger.Trace("Return: userid: " + r.userid + " status: " + r.status);
return(r);
}
else
{
LoginResponse r = new LoginResponse();
r.status = "NOTOK";
logger.Trace("Return: Status: " + r.status);
return(r);
}
}
public ActionResult competitionplayers(long id, long challengeid)
{
ObservableCollection <PlayerGridModel> playerModelList = new ObservableCollection <PlayerGridModel>();
List <S_CompetitionPlayers> playerList;
playerList = CompetitionManager.GetPlayersByCompetition(id);
foreach (S_CompetitionPlayers player in playerList)
{
S_User user = UserManager.GetUserById(player.userid);
PlayerGridModel pgm = new PlayerGridModel();
pgm.Id = player.id;
pgm.Name = user.name;
pgm.FrequentBowlernumber = user.frequentbowlernumber;
pgm.competitionId = id;
playerModelList.Add(pgm);
}
ViewBag.competitionid = id;
ViewBag.challengeid = challengeid;
return(View(playerModelList));
}
protected void Page_Load(object sender, EventArgs e)
{
Page.MaintainScrollPositionOnPostBack = true;
if (!this.IsPostBack)
{
List <S_Competition> competitions = CompetitionManager.GetRunningCompetitions(true);
ListItem item = new ListItem();
item.Value = "0";
item.Text = "-- Selecteer een competitie --";
compCompetitie.Items.Add(item);
foreach (S_Competition competition in competitions)
{
S_Challenge challenge = ChallengeManager.GetChallenge(competition.challengeid);
item = new ListItem();
item.Value = competition.id.ToString();
item.Text = Conversion.DateToTitle(competition.startdate, competition.enddate) + " : " + challenge.name;
compCompetitie.Items.Add(item);
}
bool auth = Convert.ToBoolean(Session["auth"]);
if (auth)
{
long id = Convert.ToInt64(Session["uid"]);
S_User user = UserManager.GetUserById(id);
compFrequentBowlerNaam.Text = user.username;
compFrequentBowlerNummer.Text = user.frequentbowlernumber.ToString();
}
}
}
public ActionResult Insert(AccountModel model)
{
if (ModelState.IsValid)
{
// Attempt to register the user
try
{
S_User user = new S_User();
user.name = model.Name;
user.email = model.Email;
user.address = model.Address;
user.city = model.City;
user.username = model.UserName;
user.password = model.Password;
user.roleid = Role.ADMINISTRATOR;
long?userid = UserManager.Insert(user);
if (userid != null)
{
Mail.SendMessage(model.Email, model.Name, Crypt.Encrypt(userid.ToString()));
}
return(RedirectToAction("Index", "Account", new { name = user.name }));
}
catch (MembershipCreateUserException e)
{
ModelState.AddModelError("", ErrorCodeToString(e.StatusCode));
}
}
// If we got this far, something failed, redisplay form
return(View(model));
}
private void buildCompetitions(S_User user)
{
List <S_Competition> competitions = CompetitionManager.GetCompetitionsByPlayer(user.id);
_competitions = "<div class='col-lg-8 col-lg-offset-2'>";
_competitions += " <h2>Jouw Competities</h2>";
if (competitions.Count() > 0)
{
foreach (S_Competition competition in competitions)
{
S_Challenge challenge = ChallengeManager.GetChallenge(competition.challengeid);
List <S_CompetitonBowlingcenter> competitonBowlingcenters = CompetitionManager.GetBowlingcentersByCompetition(competition.id);
_competitions += " <h3>" + challenge.name + "</h3>";
_competitions += " <p> Van " + competition.startdate.ToString("dd-MM-yyyy") + " tot " + competition.enddate.ToString("dd-MM-yyyy") + " bij de volgende bowlingcentra: ";
foreach (S_CompetitonBowlingcenter competitonBowlingcenter in competitonBowlingcenters)
{
S_BowlingCenter bowlingCenter = BowlingCenterManager.GetBowlingCenterById(competitonBowlingcenter.bowlingcenterid);
_competitions += "<br/><br/>" + bowlingCenter.name;
}
_competitions += "</p>";
}
}
else
{
_competitions += " <p>Je doet nog niet mee aan een competitie</p>";
}
_competitions += "</div>";
}
protected void btnRemoveAccount_Click(object sender, EventArgs e)
{
bool auth = Convert.ToBoolean(Session["auth"]);
if (!auth)
{
Response.Redirect("~/Login.aspx");
}
else
{
// find the user
long id = Convert.ToInt64(Session["uid"]);
S_User user = UserManager.GetUserById(id);
// remove favorits
FavoritManager.DeleteFavoritsByUserId(user.id);
// remove competitionplayers
CompetitionManager.DeleteCompetitionPlayer(user.id);
// remove user
UserManager.Delete(user.id);
Response.Redirect("~/Logout.aspx");
}
}
//Insert statement
public static long?Insert(S_User user)
{
long?lastInsertedId = null;
try
{
DatabaseConnection databaseconnection = new DatabaseConnection();
if (!UserExistByEmail(user.email))
{
if (!UserExistByFrequentBowlerNumber(user.frequentbowlernumber))
{
//open connection
if (databaseconnection.OpenConnection())
{
//create command and assign the query and connection from the constructor
MySqlCommand command = new MySqlCommand();
command.Connection = databaseconnection.getConnection();
command.CommandText = "INSERT INTO user (name, password, roleid, logindatetime, email, address, username, city, ismember, membernumber, isregistrationconfirmed, frequentbowlernumber) VALUES (@name, @password, @roleid, @logindatetime, @email, @address, @username, @city, @ismember, @membernumber, @isregistrationconfirmed, @frequentbowlernumber)";
command.Parameters.AddWithValue("@name", Conversion.StringToSql(user.name));
command.Parameters.AddWithValue("@password", Conversion.StringToSql(user.password));
command.Parameters.AddWithValue("@roleid", Conversion.IntToSql((int)user.roleid));
command.Parameters.AddWithValue("@logindatetime", Conversion.DoubleToSql(user.logindatetime));
command.Parameters.AddWithValue("@email", Conversion.StringToSql(user.email));
command.Parameters.AddWithValue("@address", Conversion.StringToSql(user.address));
command.Parameters.AddWithValue("@username", Conversion.StringToSql(user.username));
command.Parameters.AddWithValue("@city", Conversion.StringToSql(user.city));
command.Parameters.AddWithValue("@ismember", Conversion.BoolToSql(user.isMember));
command.Parameters.AddWithValue("@membernumber", Conversion.IntToSql(user.memberNumber));
command.Parameters.AddWithValue("@isregistrationconfirmed", Conversion.BoolToSql(user.isRegistrationConfirmed));
command.Parameters.AddWithValue("@frequentbowlernumber", Conversion.LongToSql(user.frequentbowlernumber));
//Execute command
command.ExecuteNonQuery();
lastInsertedId = command.LastInsertedId;
//close connection
databaseconnection.CloseConnection();
}
}
else
{
throw (new Exception("Frequent bowler nummer is reeds in gebruik"));
}
}
else
{
throw (new Exception("Email adres is reeds in gebruik"));
}
}
catch (Exception ex)
{
logger.Error(string.Format("Insert, Error inserting uUser data: {0}", ex.Message));
throw;
}
return(lastInsertedId);
}
public void ShowUser(S_User u)
{
this._user = u;
this.txbRealname.Text = this._user.realName;
this.txbEmail.Text = this._user.email;
this.txbPhone.Text = this._user.tel;
this.ShowDialog();
}
public static bool UserCanPredict(S_User u)
{
if (u == null)
{
return(false);
}
;
return(u.HasRole(RoleEnum.Administrator) || u.HasRole(RoleEnum.Engineer) || u.HasRole(RoleEnum.Operator));
}
// GET: Static 统计图表页面加载
public ActionResult Index()
{
S_User user = Session["CurrentUser"] as S_User;
List <Salary> list = salaryService.GetEntityList <Salary>(s => s.UserId == user.id);
ViewBag.TotalSalary = list.Sum(s => s.TotalSalary);
ViewBag.FinalSalary = list.Sum(s => s.FinalSalary);
return(View());
}
public ActionResult InsertUser(UserModels.UserModel user_model)
{
GetisMultiBranch();
if (ViewBag.isMultiBranch == true)
{
var branches = Entities.S_Branch.ToList();
ViewBag.Branches = new SelectList(branches, "BranchID", "BranchName");
}
var locations = Entities.S_Location.ToList();
ViewBag.Locations = new SelectList(locations, "LocationID", "LocationName");
try
{
S_User tbl_user = new S_User();
tbl_user.UserName = user_model.UserName;
tbl_user.UserPassword = user_model.UserPassword;
if (user_model.BranchID != 0)
{
tbl_user.BranchID = user_model.BranchID;
}
else
{
tbl_user.BranchID = null;
}
if (user_model.IsDefaultLocation == true)
{
tbl_user.IsDefaultLocation = true;
}
else
{
tbl_user.IsDefaultLocation = false;
}
if (user_model.LocationID != 0)
{
tbl_user.LocationID = user_model.LocationID;
}
else
{
tbl_user.LocationID = null;
}
Entities.S_User.Add(tbl_user);
Entities.SaveChanges();
ModelState.Clear();
ViewBag.Message = "New User Inserted Successful...";
ViewBag.AlertType = "1";
}
catch (Exception ex)
{
ViewBag.Message = "Please Enter UserName and Password.";
ViewBag.AlertType = "2";
ModelState.Clear();
return(View("CreateUser"));
}
return(View("CreateUser"));
}
protected void buttonSubmitForm_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
bool auth = Convert.ToBoolean(Session["auth"]);
if (!auth)
{
Response.Redirect("~/Login.aspx");
}
else
{
bool validUser = true;
string result = string.Empty;
if (profilewachtwoord.Text.CompareTo(profilecontrole.Text) != 0)
{
result = "Het wachtwoord is niet twee keer hetzelfde ingevuld!"; validUser = false;
}
if (validUser)
{
long id = Convert.ToInt64(Session["uid"]);
S_User user = UserManager.GetUserById(id);
user.name = profilenaam.Text;
user.address = profileadres.Text;
user.city = profileplaats.Text;
if (!string.IsNullOrEmpty(profilewachtwoord.Text))
{
user.password = profilewachtwoord.Text;
}
UserManager.Update(user);
result = "De gegevens zijn opgeslagen!";
buildCompetitions(user);
buildScores(user);
}
if (!validUser)
{
profileSuccess.Attributes.Add("style", "color:red");
}
else
{
profileSuccess.Attributes.Add("style", "color:black");
}
profileSuccess.InnerHtml = result;
}
}
}
public ActionResult Edit(int?id)
{
ViewBag.Nav = new Models.LeftNavEntity()
{
Panel = Models.LeftNavPanel.User
};
if (!Common.IsLogin)
{
return(new HttpUnauthorizedResult());
}
if (!id.HasValue)
{
id = Common.Get_UserID;
}
using (var db = new RIPPWebEntities())
{
//if (!Permission.Check(ModelEnum.Users, id.Value > 0 ? PermissionEnum.Edit : PermissionEnum.Add, Common.Get_User.Roles, out role, Common.Get_UserID, id.Value))
// return RedirectToAction("Forbid", "Home");
S_User u = null;
if (id.HasValue)
{
u = db.S_User.Where(d => d.ID == id && !d.Deleted).FirstOrDefault();
if (!Common.Get_User.HasRole(RoleEnum.Administrator) && !(Common.Get_User.GroupID == u.GroupID && Common.Get_User.HasRole(RoleEnum.GroupMaster)))
{
return(RedirectToAction("Forbid", "Home"));
}
}
else
{
u = Common.Get_User;
}
if (u == null)
{
u = new S_User()
{
GroupID = 0
};
}
ViewBag.Groups = db.S_Group.Where(d => !d.Deleted).ToList().Select(d => new SelectListItem()
{
Text = d.Names, Value = d.ID.ToString(), Selected = d.ID == u.GroupID
}).ToList();
ViewBag.Models = db.model.Where(d => d.gid == u.GroupID).ToList().Select(d => new SelectListItem()
{
Text = d.name, Value = d.id.ToString(), Selected = d.id == u.modelid
}).ToList();
return(View(u));
}
}
// GET: Account
public ActionResult Login()
{
S_User s_user = new S_User();
var memberValidation = Request.Cookies.Get("_token");//使用cookie
if (memberValidation != null && memberValidation.HasKeys)
{
s_user = JsonConvert.DeserializeObject <S_User>(memberValidation["name"]);
s_user.Password = DEncrypt.Decrypt(s_user.Password, "zhang");
}
return(View(s_user));
}
public ActionResult Register(string usernamesignup, string passwordsignup)
{
S_User user = new S_User()
{
UserName = usernamesignup,
Password = DEncrypt.Encrypt(passwordsignup, "zhang"),
CreateTime = DateTime.Now
};
_iUserService.AddEntity(user);
return(RedirectToAction("Index", "Home"));
}
public FrmUsers(S_User u)
{
this._user = u;
InitializeComponent();
this.Load += new EventHandler(FrmUsers_Load);
cellCmbBind();
_cellCmb.Visible = false; // 设置下拉列表框不可见
_cellCmb.SelectedIndexChanged += new EventHandler(cmb_Temp_SelectedIndexChanged); // 添加下拉列表框事件
this.dataGridView1.Controls.Add(_cellCmb); // 将下拉列表框加入到DataGridView控件中
// this.dataGridView1.CellEnter += new DataGridViewCellEventHandler(dgdView_CellEnter);
}
public Profile GetProfile(string id, string otheruserid)
{
long thisUserId;
long userid;
logger.Debug(Settings.MethodName());
logger.Trace("Parameters: id: " + id + "otheruserid: " + otheruserid);
if (isCorrectUser(id))
{
long.TryParse(id, out thisUserId);
// voor het opvragen van een profiel van een andere gebruiker, gebruiken we het andere id
if (!String.IsNullOrEmpty(otheruserid))
{
id = otheruserid;
}
long.TryParse(id, out userid);
S_User user = UserManager.GetUserById(userid);
if (user != null)
{
Profile profile = new Profile();
profile.user = new User();
profile.user.userid = user.id;
profile.user.city = user.city;
profile.user.name = user.name;
profile.user.username = user.username;
profile.user.scores = GameManager.GetProfileScores(user.username, user.frequentbowlernumber);
if (String.IsNullOrEmpty(otheruserid))
{
profile.user.is_favorite = false;
}
else
{
profile.user.is_favorite = FavoritManager.IsUserFavoritOfUser(thisUserId, userid);
}
logger.Trace("Return: userid: " + profile.user.userid);
logger.Trace("Return: city: " + profile.user.city);
logger.Trace("Return: email: " + profile.user.name);
logger.Trace("Return: username: "******"Return: is_favorite: " + profile.user.is_favorite);
return(profile);
}
}
return(null);
}
public ActionResult Confirm(string id)
{
long userId;
long.TryParse(Crypt.Decrypt(id), out userId);
S_User user = UserManager.GetUserById(userId);
user.isRegistrationConfirmed = true;
UserManager.Update(user);
return(View());
}
/// <summary>
/// 重写连接事件
/// </summary>
/// <returns></returns>
public override Task OnConnected()
{
//查询用户
var user = users.Where(w => w.ConnectionID == Context.ConnectionId).SingleOrDefault();
//判断用户是否存在，否则添加集合
if (user == null)
{
user = new S_User("", Context.ConnectionId);
users.Add(user);
}
return(base.OnConnected());
}
public ActionResult Create(Salary salary)
{
S_User user = Session["CurrentUser"] as S_User;
salary.CreateTime = DateTime.Now;
salary.UserId = user.id;
bool result = salaryService.AddEntity(salary);
if (!result)
{
return(RedirectToAction("/Create", result));
}
return(RedirectToAction("/Index"));
}
public ActionResult Login(LoginModel model, string returnUrl)
{
if (ModelState.IsValid)
{
S_User user = UserManager.GetUserByNameAndPassword(model.UserName, model.Password);
if (user != null) // && user.roleid == 0)
{
FormsAuthentication.SetAuthCookie(user.name, false);
return(RedirectToLocal(returnUrl));
}
}
// If we got this far, something failed, redisplay form
ModelState.AddModelError("", "De gebruikersnaam of het wachtwoord is niet correct.");
return(View(model));
}
