public async Task <IActionResult> register(RegDTO regUser)
{
if (ModelState.IsValid)
{
if (unitWork.Users.GetByEmail(regUser.Email) == null)
{
User user = new User
{
Name = regUser.Name,
Surname = regUser.Surname,
Email = regUser.Email,
Password = regUser.Password,
IsAdmin = true
};
unitWork.Users.Create(user);
unitWork.SaveChanges();
await Authenticate(user);
if (user.IsAdmin)
{
return(RedirectToAction("home", "admin"));
}
return(RedirectToAction("home", "user"));
}
}
return(View());
}
public Regs RegsGrid(String CemexId)
{
Regs userse = new Regs();
var param = new List<SqlParameter>();
param.Add(new SqlParameter("@CemexId", CemexId));
IRdmsConnection cnn = new SqlRdmsConnection<UserIdDTO>(UtilSh.strCnn2, "dbo.GetPermission", param);
var result = cnn.Execute(true, CommandType.StoredProcedure);
var res = (from r in result
select (UserIdDTO)r).ToArray();
param.Clear();
string connectionString = UtilSh.strCnn2;/* System.Configuration.ConfigurationManager.ConnectionStrings["cnnSql2"].ToString();*/
using (SqlConnection connection = new SqlConnection(connectionString))
{
using (SqlCommand command = new SqlCommand())
{
command.Connection = connection;
command.CommandText = "Exec dbo.RegsGrid @User="******"ID"]);
user.Llave = Convert.ToString(dataReader["Llave"]);
user.CodCliente = Convert.ToString(dataReader["CodCliente"]);
user.NCliente = Convert.ToString(dataReader["NCliente"]);
user.Pais = Convert.ToString(dataReader["Pais"]);
user.Cupo = Convert.ToString(dataReader["Cupo"]);
user.CupoOtorgado = Convert.ToString(dataReader["CupoOtorgado"]);
user.Plazo = Convert.ToString(dataReader["Plazo"]);
user.PlazoOtorgado = Convert.ToString(dataReader["PlazoOtorgado"]);
user.Tipo = Convert.ToString(dataReader["Tipo"]);
user.Estado = Convert.ToString(dataReader["Estado"]);
user.Vice = Convert.ToString(dataReader["Vice"]);
user.SolCre = Convert.ToString(dataReader["SolCre"]);
user.Pagare = Convert.ToString(dataReader["Pagare"]);
user.Cedula = Convert.ToString(dataReader["Cedula"]);
user.Camara = Convert.ToString(dataReader["Camara"]);
user.Rut = Convert.ToString(dataReader["Rut"]);
user.Comentarios = Convert.ToString(dataReader["Comentarios"]);
user.Fecha = Convert.ToString(dataReader["Fecha"]);
user.Hora = Convert.ToString(dataReader["Hora"]);
user.ComentarioCredito = Convert.ToString(dataReader["ComentarioCredito"]);
user.Comercial = Convert.ToString(dataReader["Comercial"]);
userse.Add(user);
}
}
//Convert.ToInt32(paramTotalRecords.Value);
}
}
/* param = new List<SqlParameter>();
param.Add(new SqlParameter("@User", CemexId));
cnn = new SqlRdmsConnection<RegDTO>(UtilSh.strCnn2, "dbo.RegsGrid",param);//Procedimiento almacenado para inserción de solicitudes.
var result2 = cnn.Execute(true, CommandType.StoredProcedure);
var res2 = (from r in result2
select (RegDTO)r).ToArray();
foreach(var x in res2)
{
userse.Add(x);
}*/
return userse;
}
