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