public void AddUser(SharedModels.Models.UserModel user)
{
using (SqlConnection sqlConnection = new SqlConnection(_connectionString))
{
sqlConnection.Open();
try
{
int insertedID = 0;
using (SqlCommand command = new SqlCommand("INSERT INTO USERS OUTPUT INSERTED.ID VALUES(@name, @email, @password, @dob, @country, @avatar)", sqlConnection))
{
command.Parameters.Add(new SqlParameter("name", user.Name));
command.Parameters.Add(new SqlParameter("email", user.Email));
command.Parameters.Add(new SqlParameter("password", user.Password));
command.Parameters.Add(new SqlParameter("dob", user.BirthDay));
command.Parameters.Add(new SqlParameter("country", user.Country));
command.Parameters.Add(new SqlParameter("avatar", DBNull.Value));
insertedID = (int)command.ExecuteScalar();
}
/*if (insertedID > 0)
* {
* AddRegister(insertedID, sessionID, user.IP);
* }*/
}
catch (Exception e)
{
Console.WriteLine("Can't insert de new User");
throw new Exception(@"Can't insert a new User", e);
}
}
}
public ActionResult logIn(SharedModels.Models.UserModel user)
{
Helpers.Utils.validateUser(user);
ConnectionsManager.Users conn = new ConnectionsManager.Users(CONNECTIONSTRING);
int idUser = conn.existUser(user.Email, user.Password);
if (idUser > 0)
{
if (_session == null)
{
_session = new Helpers.SessionManager();
_session.setIsLoggedIn(user.Email);
FormsAuthentication.SetAuthCookie(user.Email, false);
}
else
{
_session.setIsLoggedIn(user.Email);
FormsAuthentication.SetAuthCookie(user.Email, false);
}
conn.AddRegister(idUser, _session.GetSessionId(), Request.UserHostAddress);
return(RedirectToAction("List", "User"));
}
else
{
ModelState.AddModelError("", "Login data in incorrect");
}
return(View(user));
}
public ActionResult Registration(SharedModels.Models.UserModel user)
{
if (ModelState.IsValid)
{
Helpers.Utils.validateUser(user);
user.IP = Request.UserHostAddress;
ConnectionsManager.Users conn = new ConnectionsManager.Users(CONNECTIONSTRING);
if (conn.existUser(user.Email, user.Password) > 0)
{
ModelState.AddModelError("", "User exist with the same email and password");
return(View());
}
else
{
conn.AddUser(user);
}
}
else
{
ModelState.AddModelError("", "Login data is incorrect.");
return(View());
}
return(RedirectToAction("logIn", "User"));
}
public static void validateUser(SharedModels.Models.UserModel user)
{
user.Password = Helpers.SHA1.Encode(user.Password);
user.Email = user.Email.ToLower();
}
