public JsonResult RegistrarUsuario(string user, string pass, int typeuser, int typeadmin)
{
LoginBean logBean = new LoginBean();
LoginDao logDao = new LoginDao();
string result = "";
logBean = logDao.sp_ValidaUsuario(user);
if (logBean.sMensaje == "notexists")
{
logBean = logDao.sp_RegistroUsuario(user, pass, typeuser, typeadmin);
if (logBean.sMensaje == "success")
{
result = "goodinsert";
}
else
{
result = "errorinsert";
}
}
else
{
result = "existsuser";
}
var data = new { resp = result };
return(Json(data));
}
public LoginBean sp_RegistraCentroTrabajo(int clvemp, string centro, string ubicacion)
{
LoginBean logBean = new LoginBean();
try
{
this.Conectar();
SqlCommand cmd = new SqlCommand("sp_RegistraCentroTrabajo", this.conexion)
{
CommandType = CommandType.StoredProcedure
};
cmd.Parameters.Add(new SqlParameter("@IdEmpresa", clvemp));
cmd.Parameters.Add(new SqlParameter("@Centro", centro));
cmd.Parameters.Add(new SqlParameter("@Ubicacion", ubicacion));
if (cmd.ExecuteNonQuery() > 0)
{
logBean.sMensaje = "success";
}
else
{
logBean.sMensaje = "error";
}
cmd.Dispose(); cmd.Parameters.Clear(); conexion.Close();
}
catch (Exception exc)
{
Console.WriteLine(exc);
}
return(logBean);
}
public List <LoginBean> sp_UsersSinEmpresa()
{
List <LoginBean> listLogBean = new List <LoginBean>();
try
{
this.Conectar();
SqlCommand cmd = new SqlCommand("sp_UsersSinEmpresa", this.conexion)
{
CommandType = CommandType.StoredProcedure
};
SqlDataReader data = cmd.ExecuteReader();
if (data.HasRows)
{
while (data.Read())
{
LoginBean logBean = new LoginBean();
logBean.iIdUsuario = Convert.ToInt32(data["IdUsuario"].ToString());
logBean.sUsuario = data["Usuario"].ToString();
listLogBean.Add(logBean);
}
}
cmd.Dispose(); cmd.Parameters.Clear(); data.Close(); conexion.Close();
}
catch (Exception exc)
{
Console.WriteLine(exc);
}
return(listLogBean);
}
public LoginBean sp_CambiarContrasenaUsuarios(int user, string pass)
{
LoginBean logBean = new LoginBean();
try
{
this.Conectar();
SqlCommand cmd = new SqlCommand("sp_CambiarContraseñaUsuarios", this.conexion)
{
CommandType = CommandType.StoredProcedure
};
string encrypt = SHA512(pass);
cmd.Parameters.Add(new SqlParameter("@IdUsuario", user));
cmd.Parameters.Add(new SqlParameter("@Password", encrypt));
if (cmd.ExecuteNonQuery() > 0)
{
logBean.sMensaje = "success";
}
else
{
logBean.sMensaje = "error";
}
cmd.Dispose(); cmd.Parameters.Clear(); conexion.Close();
}
catch (Exception exc)
{
Console.WriteLine(exc);
}
return(logBean);
}
public LoginBean TOTALBBS_ADMIN_SEL(string AdminId, string AdminPw)
{
DataRow drRow = null;
SqlParameter[] parameter = new SqlParameter[]
{
new SqlParameter("@AdminId", AdminId),
new SqlParameter("@AdminPw", AdminPw)
};
LoginBean Bean = new LoginBean();
using (DataSet dsView = SQLHelper.ExecuteDataset(Global.DataBaseConnection, "[dbo].[UP_TOTALBBS_ADMIN_INFO_SEL_SP]", parameter))
{
drRow = dsView.Tables[0].Rows.Count == 0 ? null : dsView.Tables[0].Rows[0];
}
if (drRow != null)
{
Bean.intIdx = Convert.ToInt32(drRow["intIdx"]);
Bean.strAdminId = Convert.ToString(drRow["strAdminId"]);
Bean.strAdminName = Convert.ToString(drRow["strAdminName"]);
Bean.chrAdminAuth = Convert.ToString(drRow["chrAdminAuth"]);
Bean.chrCheckLogin = Convert.ToString(drRow["chrCheckLogin"]);
Bean.dateRegDate = Convert.ToString(drRow["dateRegDate"]);
}
return(Bean);
}
public LoginBean sp_ValidaUsuario(string user)
{
LoginBean logBean = new LoginBean();
try
{
this.Conectar();
SqlCommand cmd = new SqlCommand("sp_ValidaUsuario", this.conexion)
{
CommandType = CommandType.StoredProcedure
};
cmd.Parameters.Add(new SqlParameter("@Usuario", user));
SqlDataReader data = cmd.ExecuteReader();
if (data.Read())
{
logBean.sMensaje = "exists";
}
else
{
logBean.sMensaje = "notexists";
}
cmd.Dispose(); cmd.Parameters.Clear(); data.Close(); conexion.Close();
}
catch (Exception exc)
{
Console.WriteLine(exc);
}
return(logBean);
}
public LoginBean sp_RegistrarUsuarioEmpresa(int user, int empresa)
{
LoginBean logBean = new LoginBean();
try
{
this.Conectar();
SqlCommand cmd = new SqlCommand("sp_RegistrarUsuarioEmpresa", this.conexion)
{
CommandType = CommandType.StoredProcedure
};
cmd.Parameters.Add(new SqlParameter("@IdUsuario", user));
cmd.Parameters.Add(new SqlParameter("@IdEmpresa", empresa));
if (cmd.ExecuteNonQuery() > 0)
{
logBean.sMensaje = "success";
}
else
{
logBean.sMensaje = "error";
}
cmd.Dispose(); cmd.Parameters.Clear(); conexion.Close();
}
catch (Exception exc)
{
Console.WriteLine(exc);
}
return(logBean);
}
public LoginBean sp_BloquearActivar_Usuarios(int keyuser, int status)
{
LoginBean logBean = new LoginBean();
try
{
this.Conectar();
SqlCommand cmd = new SqlCommand("sp_BloquearActivar_Usuarios", this.conexion)
{
CommandType = CommandType.StoredProcedure
};
cmd.Parameters.Add(new SqlParameter("@Estado", status));
cmd.Parameters.Add(new SqlParameter("@IdUsuario", keyuser));
if (cmd.ExecuteNonQuery() > 0)
{
logBean.sMensaje = "success";
}
else
{
logBean.sMensaje = "error";
}
cmd.Dispose(); cmd.Parameters.Clear(); conexion.Close();
}
catch (Exception exc)
{
Console.WriteLine(exc);
}
return(logBean);
}
public JsonResult DesbloquearUsuario(int keyuser, int status, string passactive)
{
int user = Convert.ToInt32(Session["keyUser"]);
LoginBean logBean = new LoginBean();
LoginDao logDao = new LoginDao();
string result = "";
logBean = logDao.sp_ValidaUsuario_EnSesion(passactive, user);
if (logBean.sMensaje == "success")
{
logBean = logDao.sp_BloquearActivar_Usuarios(keyuser, status);
if (logBean.sMensaje == "success")
{
result = "correct";
}
else
{
result = "incorrect";
}
}
else
{
result = "errorpass";
}
var resp = new { resp = result };
return(Json(resp));
}
// Use this for initialization
private void Start1()
{
Debug.logger.logEnabled = true; // 关闭日志输出
Mafia.Instance.InitPlugin();
var plugin = Mafia.Instance.GetPlugin <MafiaPlugin>();
Debug.Log("Plugin is " + plugin);
// 测试pb
var info = new LoginBean
{
OpenId = "1998"
};
Debug.Log(info);
var m_data = info.ToByteArray();
//
var tgt_bean = LoginBean.Parser.ParseFrom(m_data);
Debug.Log(tgt_bean);
//
Debug.Log(GameClock.Now());
Debug.Log(GameClock.Timestamp);
Debug.Log(DateTime.Now);
Debug.Log(DateTime.Now.ToFileTimeUtc());
}
public LoginBean sp_ValidaUsuario_EnSesion(string pass, int user)
{
LoginBean logBean = new LoginBean();
try
{
this.Conectar();
SqlCommand cmd = new SqlCommand("sp_ValidaUsuario_EnSesion", this.conexion)
{
CommandType = CommandType.StoredProcedure
};
string encrypt = SHA512(pass);
cmd.Parameters.Add(new SqlParameter("@IdUsuario", user));
cmd.Parameters.Add(new SqlParameter("@Password", encrypt));
SqlDataReader data = cmd.ExecuteReader();
if (data.Read())
{
logBean.sMensaje = "success";
}
else
{
logBean.sMensaje = "error";
}
cmd.Dispose(); cmd.Parameters.Clear(); data.Close(); conexion.Close();
}
catch (Exception exc)
{
Console.WriteLine(exc);
}
return(logBean);
}
public List <LoginBean> sp_Datos_Usuarios(int tipo, int user)
{
List <LoginBean> listUsersBean = new List <LoginBean>();
try
{
this.Conectar();
SqlCommand cmd = new SqlCommand("sp_Datos_Usuarios", this.conexion)
{
CommandType = CommandType.StoredProcedure
};
cmd.Parameters.Add(new SqlParameter("@TipoUsuario", tipo));
cmd.Parameters.Add(new SqlParameter("@IdUsuario", user));
SqlDataReader data = cmd.ExecuteReader();
if (data.HasRows)
{
while (data.Read())
{
LoginBean logBean = new LoginBean();
logBean.iIdUsuario = Convert.ToInt32(data["IdUsuario"]);
logBean.sUsuario = data["Usuario"].ToString();
logBean.iEstado = Convert.ToInt32(data["Estado"]);
logBean.sEmpresa = data["Nombre"].ToString();
listUsersBean.Add(logBean);
}
}
cmd.Dispose(); cmd.Parameters.Clear(); data.Close(); conexion.Close();
}
catch (Exception exc)
{
Console.WriteLine(exc);
}
return(listUsersBean);
}
public ActionResult Login(LoginBean bean)
{
Usertable user = FactoryDao.GetUsertableDao().SelectId(bean.id, bean.password);
if (user == null)
{
return(Index());
}
Session[Define.USER_SESSION_NAME] = user;
return(Main());
}
public new ActionResult Redirect(String code)
{
try
{
base.Logger.Info("Redirect Open");
string data = HttpConnector.GetInstance().GetRequest("https://accounts.google.com/o/oauth2/token",
HttpConnector.HttpMethod.POST,
new Dictionary <String, Object>()
{
{ "code", code },
{ "client_id", HtmlUtil.GetClientID() },
{ "client_secret", HtmlUtil.GetClientSecret() },
{ "redirect_uri", HtmlUtil.GetRedirectUrl() },
{ "grant_type", "authorization_code" }
});
base.Logger.Info("Google account auth : " + code);
LoginToken token = JsonConvert.DeserializeObject <LoginToken>(data);
data = HttpConnector.GetInstance().GetRequest("https://www.googleapis.com/oauth2/v1/userinfo",
HttpConnector.HttpMethod.GET,
new Dictionary <String, Object>()
{
{ "access_token", token.Access_token }
});
base.Logger.Info("Google access_token : " + token.Access_token);
LoginBean login = JsonConvert.DeserializeObject <LoginBean>(data);
login.Token = token;
String usercheck = HttpConnector.GetInstance().GetDataRequest("CheckUser.php",
new Dictionary <String, Object>()
{
{ "GID", login.Id }
});
Session["USER_BUFFER"] = login;
if (usercheck == null)
{
base.Logger.Info("usercheck == null");
return(base.Redirect("/Home/ApplyConfirm"));
}
base.Logger.Info("Redirect -> Apply");
return(Apply());
}
catch (Exception e)
{
base.Logger.Error(e);
return(base.Redirect("/"));
}
}
private void Login(LoginBean bean, bool md5Crypt)
{
UsrNf user = usrNfDao.SelectForSign(bean.InputGroup, bean.InuptId, md5Crypt ? Util.MD5HashCrypt(bean.InputPassword) : bean.InputPassword);
if (user == null)
{
bean.ErrorMessage = Message.LOGIN_ERROR;
}
else
{
UserSession = user;
FormsAuthentication.SetAuthCookie(user.Nm, false);
if (!String.IsNullOrEmpty(bean.Remember))
{
SetInfoToCookie();
}
}
}
public JsonResult CentroDeTrabajo(int clvemp, string centro, string ubicacion)
{
LoginBean logBean = new LoginBean();
LoginDao logDao = new LoginDao();
string result = "";
logBean = logDao.sp_RegistraCentroTrabajo(clvemp, centro, ubicacion);
if (logBean.sMensaje == "success")
{
result = "correct";
}
else
{
result = "incorrect";
}
var data = new { resp = result };
return(Json(data));
}
public JsonResult CambiarContrasena(int user, string pass)
{
LoginBean logBean = new LoginBean();
LoginDao logDao = new LoginDao();
string result = "";
logBean = logDao.sp_CambiarContrasenaUsuarios(user, pass);
if (logBean.sMensaje == "success")
{
result = "correct";
}
else
{
result = "incorrect";
}
var data = new { resp = result };
return(Json(data));
}
public JsonResult RegistrarUsuarioEmpresa(int user, int empresa)
{
LoginBean logBean = new LoginBean();
LoginDao logDao = new LoginDao();
logBean = logDao.sp_RegistrarUsuarioEmpresa(user, empresa);
string result = "";
if (logBean.sMensaje == "success")
{
result = "correct";
}
else
{
result = "incorrect";
}
var data = new { resp = result };
return(Json(data));
}
public ActionResult Index(LoginBean bean)
{
if (String.Equals(bean.Post, Define.POST_PAGE))
{
if (String.IsNullOrEmpty(bean.InputGroup))
{
bean.ErrorMessage = Message.LOGIN_ERROR_NOT_GROUPID;
}
else if (String.IsNullOrEmpty(bean.InuptId))
{
bean.ErrorMessage = Message.LOGIN_ERROR_NOT_ID;
}
else if (String.IsNullOrEmpty(bean.InputPassword))
{
bean.ErrorMessage = Message.LOGIN_ERROR_NOT_PWD;
}
else
{
Login(bean, true);
}
}
else
{
DateTime time;
if (GetInfoByCookie(ref bean, out time))
{
bean.Remember = "1";
if (DateTime.Compare(DateTime.Now.AddDays(-7), time) <= 0)
{
Login(bean, false);
}
}
}
if (UserSession != null)
{
cnctLgDao.InsertToSignin(UserSession.Grpd, UserSession.Usrd);
return(Redirect("/Home/Main"));
}
ViewBag.ModelView = bean;
return(View("~/Views/login.cshtml", "~/Views/master.cshtml"));
}
protected void btnLogin_Click(object sender, EventArgs e)
{
try
{
Login_NTx_Dac oView = new Login_NTx_Dac();
string strTxtLoginId = string.Empty;
string strTxtLoginPw = string.Empty;
if (Request.Form["TxtLoginId"] != null)
{
strTxtLoginId = Request.Form["TxtLoginId"].ToString();
}
if (Request.Form["TxtLoginPw"] != null)
{
strTxtLoginPw = Request.Form["TxtLoginPw"].ToString();
}
LoginBean Bean = oView.TOTALBBS_ADMIN_SEL(strTxtLoginId, strTxtLoginPw);
if (!string.IsNullOrEmpty(Bean.strAdminId) && Bean.chrCheckLogin.Equals("0"))
{
CookieInfo AdminInfo = new CookieInfo();
CookieInfo.setAdminCookieSetting(Bean, ".totalbbs.com");
StringBuilder sbLoginOk = new StringBuilder();
sbLoginOk.Append("alert('" + LoginBeen + "');");
sbLoginOk.Append("location.href=\"/BackOffice/Board/BoardList.aspx\"");
this.LoginOK_Process(sbLoginOk);
}
}
catch (Exception ex)
{
StringBuilder sbLoginError = new StringBuilder();
sbLoginError.Append("alert('" + LoginFailed + "');");
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "LoginError", sbLoginError.ToString(), true);
return;
}
}
public ActionResult Index_Post()
{
LoginBean loginBean = new LoginBean();
TryUpdateModel(loginBean);
if (ModelState.IsValid)
{
ShopingContext shopingContext = new ShopingContext();
RegisterPro loginsuccess = shopingContext.registerPro.Single(x => x.email == loginBean.email && x.password == loginBean.password && x.UserType == "user");
loginsuccess = loginsuccess == null ? null : loginsuccess;
Session["userId"] = loginsuccess;
}
if (Session["userId"] == null)
{
return(View());
}
else
{
return(RedirectToAction("Index", "Home"));
}
}
public JsonResult ValidarLogin(string user, string pass)
{
LoginBean logBean = new LoginBean();
LoginDao logDao = new LoginDao();
logBean = logDao.sp_Datos_Usuarios_Retrieve_Usuario(user, pass);
Session["keyUser"] = logBean.iIdUsuario;
Session["nameUser"] = logBean.sUsuario;
Session["typeUser"] = logBean.iTipoUsuario;
if (logBean.iTipoUsuario != 1)
{
EmpresasBean empBean = new EmpresasBean();
EmpresasDao empDao = new EmpresasDao();
empBean = empDao.sp_DatosEmpresa_UsuarioSession(logBean.iTipoUsuario, logBean.iIdUsuario);
if (empBean.sMensaje == "success")
{
Session["keyEmpresa"] = empBean.iIdEmpresa;
Session["nameEmpresa"] = empBean.sNombre;
}
}
return(Json(logBean));
}
public static void setAdminCookieSetting(LoginBean Bean, string strDomain)
{
string strCookieName = "LoginInfo";
string FormNameSettoing = Bean.strAdminId;
string data = string.Concat(new object[]
{
"MemberId=", Bean.strAdminId,
"&MemberNm=", Bean.strAdminName,
"&MemberAuth=", Bean.chrAdminAuth,
"&Expire=", DateTime.Now.AddDays(1)
});
FormsAuthenticationTicket ticket = new FormsAuthenticationTicket(1, strCookieName, DateTime.Now, DateTime.Now.AddDays(1), true, data, FormsAuthentication.FormsCookiePath);
string hash = FormsAuthentication.Encrypt(ticket);
HttpCookie cookie = new HttpCookie(FormsAuthentication.FormsCookieName, hash);
cookie.Expires = ticket.Expiration;
cookie.Domain = strDomain;
HttpContext.Current.Response.Cookies.Add(cookie);
}
private bool GetInfoByCookie(ref LoginBean bean, out DateTime connectDate)
{
bean.InputGroup = GetCookie("inputgroupid");
bean.InuptId = GetCookie("inpuid");
bean.InputPassword = GetCookie("inputpw");
String year = GetCookie("date_year");
String month = GetCookie("date_month");
String day = GetCookie("date_day");
if (!String.IsNullOrEmpty(year) && !String.IsNullOrEmpty(month) && !String.IsNullOrEmpty(day))
{
try
{
connectDate = new DateTime(Convert.ToInt32(year), Convert.ToInt32(month), Convert.ToInt32(day));
return(true);
}
catch { }
}
connectDate = new DateTime();
return(false);
}
public LoginBean sp_Datos_Usuarios_Retrieve_Usuario(string user, string pass)
{
LoginBean logBean = new LoginBean();
try
{
this.Conectar();
SqlCommand cmd = new SqlCommand("sp_Datos_Usuarios_Retrieve_Usuario", this.conexion)
{
CommandType = CommandType.StoredProcedure
};
string encrypt = SHA512(pass);
cmd.Parameters.Add(new SqlParameter("@sUsuario", user));
cmd.Parameters.Add(new SqlParameter("@sContrasena", encrypt));
SqlDataReader data = cmd.ExecuteReader();
if (data.Read())
{
logBean.iIdUsuario = Convert.ToInt32(data["IdUsuario"]);
logBean.sUsuario = data["Usuario"].ToString();
logBean.iEstado = Convert.ToInt32(data["Estado"]);
logBean.iTipoUsuario = Convert.ToInt32(data["TipoUsuario"]);
logBean.iSpAdmin = (String.IsNullOrEmpty(data["SpAdmin"].ToString())) ? 0 : Convert.ToInt32(data["SpAdmin"]);
logBean.sMensaje = "success";
}
else
{
logBean.sMensaje = "error";
}
cmd.Dispose(); cmd.Parameters.Clear(); data.Close(); conexion.Close();
}
catch (Exception exc)
{
logBean.sMensaje = exc.ToString();
//Console.WriteLine(exc);
}
return(logBean);
}
public ActionResult Apply()
{
try
{
base.Logger.Info("Apply Open");
LoginBean login = Session["USER_BUFFER"] as LoginBean;
Session["USER_BUFFER"] = null;
HttpConnector.GetInstance().GetDataRequest("ApplyUser.php",
new Dictionary <String, Object>()
{
{ "GID", login.Id },
{ "NAME", login.Name },
{ "EMAIL", "" }
});
UserSession = login;
FormsAuthentication.SetAuthCookie(login.Id, false);
return(base.Redirect("/Home/Main"));
}
catch (Exception e)
{
base.Logger.Error(e);
return(base.Redirect("/"));
}
}
