public IUser UserData(string query, CommandType type, string pwd) { DataTable dt = new DataTable(); dt.Columns.Add("password"); dt.Columns.Add("saltpassword"); using (SqlConnection sqlcon = new SqlConnection(strcon)) { try { sqlcon.Open(); SqlCommand sqlcmd = new SqlCommand(); sqlcmd.CommandType = type; sqlcmd.Connection = sqlcon; sqlcmd.CommandText = query; SqlDataReader dr; dr = sqlcmd.ExecuteReader(); if (dr.HasRows) { dr.Read(); if ((BCrypt.CheckBytePassword(pwd, dr["PasswordSalt"].ToString(), (byte[])dr["Password"]) == true) || pwd.Length == 0) { IUser user = new AV.Development.Core.User.User(); user.Email = dr["Email"].ToString(); user.FirstName = System.Uri.UnescapeDataString(dr["FirstName"].ToString()); user.Id = (int)dr["Id"]; user.Image = (dr["Image"] == null ? "" : dr["Image"].ToString()); user.LastName = System.Uri.UnescapeDataString(dr["LastName"].ToString()); user.Password = (byte[])dr["Password"]; user.SaltPassword = dr["PasswordSalt"].ToString(); user.UserName = dr["UserName"].ToString(); return user; } } } catch (Exception ex) { } } return null; }
public static Guid GetSystemSession() { if (_systemSessionId == Guid.Empty) { IUser user = new User.User(); user.UserName = "******"; _systemSessionId = Guid.NewGuid();// /* A generated session key */ 1; _sessions[_systemSessionId] = new DevelopmentManager(_eventManager, _pluginManager); _sessions[_systemSessionId].User = user; return _systemSessionId; } else return _systemSessionId; throw new Exception("Invalid Opeartion"); }
public IUser GetUserByID(string query, CommandType type) { using (SqlConnection sqlcon = new SqlConnection(strcon)) { try { sqlcon.Open(); SqlCommand sqlcmd = new SqlCommand(); sqlcmd.CommandType = type; sqlcmd.Connection = sqlcon; sqlcmd.CommandText = query; SqlDataReader dr; dr = sqlcmd.ExecuteReader(); if (dr.HasRows) { dr.Read(); IUser user = new AV.Development.Core.User.User(); user.Email = dr["Email"].ToString(); user.FirstName = System.Uri.UnescapeDataString(dr["FirstName"].ToString()); user.Id = (int)dr["Id"]; user.Image = (dr["Image"] == null ? "" : dr["Image"].ToString()); user.LastName = System.Uri.UnescapeDataString(dr["LastName"].ToString()); user.Password = (byte[])dr["Password"]; user.SaltPassword = dr["PasswordSalt"].ToString(); user.UserName = dr["UserName"].ToString(); user.Currentwebid = (int)dr["au_current_webid"]; user.UserType = (int)dr["au_usertype"]; return user; } } catch (Exception ex) { } } return null; }