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