//Función Para Probar el Acceso
public string uIsUserAccess(int vUserId, string vPass)
{
using (var tmpContext = new SGPPEntities())
{
var rowafect = tmpContext.Database.ExecuteSqlCommand(
"UC.IsUserAccess @PrmUserID= " + vUserId + ", @PrmPass= "******"Contraseña fallida";
}
return(rowafect.ToString());
}
}
public string uChangePass(int vPrmUsrId, string vPrmPass, int vPrmModifId)
{
using (var tmpContext = new SGPPEntities())
{
var rowafect = tmpContext.Database.ExecuteSqlCommand(
"UC.ChangeUserPassword @PrmUserId= " + vPrmUsrId + ", @PrmPass = "******", @PrmModifierUserId=" + vPrmModifId);
if (rowafect > 0)
{
message = "Contraseña creada";
}
else
{
message = "Contraseña fallida";
}
}
return(message);
}
public string uInserAuth(CLogin vLogin)
{
string message = "";
using (var tmpContext = new SGPPEntities())
{
var rowafect = tmpContext.Database.ExecuteSqlCommand(
"UC.ChangeUserPassword @PrmUserId= " + vLogin.UserId + ", @PrmPass = "******", ,@PrmModifierUserId =" + vLogin.CreateById);
if (rowafect > 0)
{
message = "Usuario Correcto";
}
else
{
message = "Usuario Incorrecto";
}
return(message);
}
}
//
// GET: /Public/
public ActionResult StartView()
{
SGPPEntities db = new SGPPEntities();
return(View());
}
