예제 #1
0
        public E_TA_USUA_SIST buscar_usuarioSistema_por_codigo(string P_FS_COD_USUA)
        {
            E_TA_USUA_SIST O_TA_USUA_SIST = new E_TA_USUA_SIST();

            s_sql_action.Data_Base_Name = s_sql_action.val_BD_SEGU;
            var cmd = s_sql_action.GetProcedure("PR_USUA_SIST_BUS01", P_FS_COD_USUA);

            ds = new DataSet();
            ds = s_sql_action.ExecuteDataSet(cmd);
            if (ds.Tables[0].Rows.Count == 0)
            {
                O_TA_USUA_SIST.FS_COD_USUA = "";
            }
            else
            {
                O_TA_USUA_SIST.FS_COD_USUA = ds.Tables[0].Rows[0]["FS_COD_USUA"].ToString();
                O_TA_USUA_SIST.FS_IND_PERS = ds.Tables[0].Rows[0]["FS_IND_PERS"].ToString();
                O_TA_USUA_SIST.FS_NOM_PRIM = ds.Tables[0].Rows[0]["FS_NOM_PRIM"].ToString();
                O_TA_USUA_SIST.FS_NOM_SECU = ds.Tables[0].Rows[0]["FS_APE_PATE"].ToString();
                O_TA_USUA_SIST.FS_APE_PATE = ds.Tables[0].Rows[0]["FS_APE_PATE"].ToString();
                O_TA_USUA_SIST.FS_APE_MATE = ds.Tables[0].Rows[0]["FS_APE_MATE"].ToString();
                O_TA_USUA_SIST.FS_USU_NOPE = ds.Tables[0].Rows[0]["FS_USU_NOPE"].ToString();
                O_TA_USUA_SIST.FS_CLA_USUA = ds.Tables[0].Rows[0]["FS_CLA_USUA"].ToString();
            }
            return(O_TA_USUA_SIST);
        }
예제 #2
0
 public JsonResult validaExistenciaCOD_USUA(E_TA_USUA_SIST obj)
 {
     obj = sql.buscar_usuarioSistema_por_codigo(obj.FS_COD_USUA);
     if (obj.FS_COD_USUA != "")
     {
         return(Json(true));
     }
     else
     {
         return(Json("Usuario no existe"));
     }
 }
예제 #3
0
        public JsonResult Ingresar(E_TA_USUA_SIST model)
        {
            var resp = new ResponseModel
            {
                response = true,
                redirect = "Index",
                error    = null
            };

            E_TA_USUA_SIST obj = new E_TA_USUA_SIST();

            obj = sql.buscar_usuarioSistema_por_codigo(model.FS_COD_USUA);
            if (obj.FS_CLA_USUA != cryption(model.FS_CLA_USUA))
            {
                resp.response = false;
                resp.error    = "Contraseña incorrecta";
            }

            if (!ModelState.IsValid)
            {
                resp.response = false;
            }
            else
            {
                var G_TA_USUA_SIST = new E_TA_USUA_SIST()
                {
                    FS_COD_USUA = model.FS_COD_USUA, FS_CLA_USUA = cryption(model.FS_CLA_USUA)
                };
                var serializedUser = Newtonsoft.Json.JsonConvert.SerializeObject(model);

                var ticket          = new FormsAuthenticationTicket(1, model.FS_COD_USUA, DateTime.Now, DateTime.Now.AddHours(3), false, serializedUser);
                var encryptedTicket = FormsAuthentication.Encrypt(ticket);
                var isSsl           = Request.IsSecureConnection; // if we are running in SSL mode then make the cookie secure only

                var cookie = new HttpCookie(FormsAuthentication.FormsCookieName, encryptedTicket)
                {
                    HttpOnly = true, // always set this to true!
                    Secure   = isSsl,
                };

                Response.Cookies.Set(cookie);
                // FormsAuthentication.SetAuthCookie(model.FS_COD_USUA, false);
            }
            return(Json(resp));
        }