public static bool AddNewUser(RichUser newLogin)
{
const string QUARY = @"Exec dbo.AddNewUser @EMail, @Login, @Password ";
var connectionString = GetConnectionString();
using (var connection = new SqlConnection(connectionString))
{
using (var command = new SqlCommand(QUARY, connection))
{
command.Parameters.Add("@EMail", SqlDbType.NVarChar);
command.Parameters["@EMail"].Value = newLogin.EMail;
command.Parameters.Add("@Login", SqlDbType.NVarChar);
command.Parameters["@Login"].Value = newLogin.Login;
command.Parameters.Add("@Password", SqlDbType.NVarChar);
command.Parameters["@Password"].Value = newLogin.Password;
command.Connection.Open();
int count;
try
{
count = command.ExecuteNonQuery();
}
catch (InvalidCastException)
{
return false;
}
if (count == 1)
{
return true;
}
return false;
}
}
}
public static void SendNewPass(RichUser user)
{
var mailMessage = new MailMessage();
mailMessage.To.Add(user.EMail);
mailMessage.Subject = "Reset password";
var message = new StringBuilder();
message.Append("Hello, ");
message.Append(user.Login);
message.Append(". Your new password is \"");
message.Append(user.Password);
message.Append("\"");
mailMessage.Body = message.ToString();
var smptClient = new SmtpClient();
smptClient.Send(mailMessage);
}
public static bool AddNewUser(RichUser newLogin)
{
var addLogin = newLogin.Clone();
addLogin.Password = Hash(newLogin.Password);
return UserAccess.AddNewUser(addLogin);
}
public static RichUser GetUserByLogin(string login)
{
const string QUARY = @"Exec dbo.GetUserByLogin @Login";
var connectionString = GetConnectionString();
using (var connection = new SqlConnection(connectionString))
{
using (var command = new SqlCommand(QUARY, connection))
{
command.Parameters.Add("@Login", SqlDbType.NVarChar);
command.Parameters["@Login"].Value = login;
command.Connection.Open();
RichUser result = null;
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
result = new RichUser
{
EMail = reader["EMail"].ToString(),
Login = reader["Login"].ToString(),
Password = reader["Password"].ToString(),
IsAdmin = (bool)reader["IsAdmin"]
};
}
reader.Close();
}
return result;
}
}
}
