//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()); }