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