public ActionResult CreateUser(WebPlastic.Models.User model)
{
ConnectionDataBase.StoreProcediur data = new ConnectionDataBase.StoreProcediur();
CredencialesDeAcceso access = new CredencialesDeAcceso();
string password = access.CreatePassword();
RijndaelManaged myRijndael = new RijndaelManaged();
myRijndael.GenerateKey();
myRijndael.GenerateIV();
string user = access.CreateUserName(model.Name, model.Last).ToLower();
model.UserName = user;
Byte[] contrasenaEncriptada = access.EncryptStringToBytes(password, myRijndael.Key, myRijndael.IV);
DataTable dt = data.SaveUser(model, contrasenaEncriptada, myRijndael.Key, myRijndael.IV);
DataRow row = dt.Rows[0];
if (dt.Rows.Count > 0)
{
SentEmail correoCreacion = new SentEmail();
string bodyCorreo = correoCreacion.EmailForNewUser(model.Name, model.Last, model.UserName, password);
correoCreacion.SendEmailForNewUser(model.Email, "Creación de Usuario", "*****@*****.**", bodyCorreo, "*****@*****.**", "*****@*****.**", "hola1234", "");
}
return(RedirectToAction("Index"));
}
public DataTable UpdateUser(WebPlastic.Models.User model)
{
try
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["webplasticEntities"].ConnectionString);
SqlDataAdapter da = new SqlDataAdapter("SP_UpdateProfile", con);
da.SelectCommand.Parameters.Add("@pidUser", SqlDbType.Int).Value = model.idUser;
da.SelectCommand.Parameters.Add("@pName", SqlDbType.VarChar).Value = model.Name;
da.SelectCommand.Parameters.Add("@pLast", SqlDbType.VarChar).Value = model.Last;
da.SelectCommand.Parameters.Add("@pUserName", SqlDbType.VarChar).Value = model.UserName;
da.SelectCommand.Parameters.Add("@pEmail", SqlDbType.VarChar).Value = model.Email;
da.SelectCommand.Parameters.Add("@pAddress", SqlDbType.VarChar).Value = model.Address;
da.SelectCommand.CommandType = CommandType.StoredProcedure;
DataTable dt = new DataTable();
da.Fill(dt);
return(dt);
}
catch (Exception)
{
throw;
}
}
public DataTable SaveUser(WebPlastic.Models.User model, byte[] password, Byte[] pKEY, Byte[] pIV)
{
try
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["webplasticEntities"].ConnectionString);
SqlDataAdapter da = new SqlDataAdapter("SP_SaveUser", con);
da.SelectCommand.Parameters.Add("@name", SqlDbType.VarChar).Value = model.Name;
da.SelectCommand.Parameters.Add("@last", SqlDbType.VarChar).Value = model.Last;
da.SelectCommand.Parameters.Add("@email", SqlDbType.VarChar).Value = model.Email;
da.SelectCommand.Parameters.Add("@userName", SqlDbType.VarChar).Value = model.UserName;
da.SelectCommand.Parameters.Add("@password", SqlDbType.VarBinary).Value = password;
da.SelectCommand.Parameters.Add("@Key", SqlDbType.VarBinary).Value = pKEY;
da.SelectCommand.Parameters.Add("@IV", SqlDbType.VarBinary).Value = pIV;
da.SelectCommand.CommandType = CommandType.StoredProcedure;
DataTable dt = new DataTable();
da.Fill(dt);
return(dt);
}
catch (Exception)
{
throw;
}
}