public ActionResult Action(string guid, string openid, string uid, string password)
{
Orm.Orm_conf_all_users orm_Conf_All_Users = new Orm.Orm_conf_all_users();
orm_Conf_All_Users.guid = guid;
orm_Conf_All_Users.openid = openid;
orm_Conf_All_Users.uid = uid;
orm_Conf_All_Users.password = password;
string query = "select * from conf_all_users where openid=@openid or guid=@guid";
Orm.Orm_conf_all_users orm_Conf_All_Users_Selected = dbConnection.Query <Orm.Orm_conf_all_users>(query).SingleOrDefault();
Conf_ResponseMessage conf_ResponseMessageObj;
if (orm_Conf_All_Users_Selected != null)
{
query = "update conf_all_users set uid=@uid,password=@password where openid=@openid or guid=@guid";
dbConnection.Execute(query);
conf_ResponseMessageObj = new Conf_ResponseMessage();
conf_ResponseMessageObj.code = "200";
conf_ResponseMessageObj.status = "ok";
conf_ResponseMessageObj.message = "Executed";
HttpContext.Response.StatusCode = 200;
return(Json(conf_ResponseMessageObj));
}
else
{
conf_ResponseMessageObj = new Conf_ResponseMessage();
conf_ResponseMessageObj.code = "500";
conf_ResponseMessageObj.status = "error";
conf_ResponseMessageObj.message = "faild to reset user";
HttpContext.Response.StatusCode = 500;
return(Json(conf_ResponseMessageObj));
}
}
public ActionResult Action(string guid)
{
Orm.Orm_conf_all_users orm_Conf_All_Users = new Orm.Orm_conf_all_users();
orm_Conf_All_Users.guid = guid;
string query = "select * from conf_all_users where guid='" + guid + "'";
orm_Conf_All_Users = dbConnection.Query <Orm.Orm_conf_all_users>(query).SingleOrDefault();
return(Json(orm_Conf_All_Users));
}
public ActionResult Action(string uid, string password)
{
if (string.IsNullOrEmpty(uid) || string.IsNullOrEmpty(password))
{
Conf_ResponseMessage conf_ResponseMessageObj = new Conf_ResponseMessage();
conf_ResponseMessageObj.code = "424";
conf_ResponseMessageObj.status = "Error";
conf_ResponseMessageObj.message = "Empty uid or password";
HttpContext.Response.StatusCode = 424;
return(Json(conf_ResponseMessageObj));
}
else
{
Orm.Orm_conf_all_users orm_Conf_All_Users = new Orm.Orm_conf_all_users();
orm_Conf_All_Users.uid = uid;
orm_Conf_All_Users.password = password;
string query = "select * from conf_all_users where uid=@uid and password = @password";
Orm.Orm_conf_all_users orm_Conf_All_Users_Selected = dbConnection.Query <Orm.Orm_conf_all_users>(query, orm_Conf_All_Users).SingleOrDefault();
if (orm_Conf_All_Users_Selected == null)
{
Conf_ResponseMessage conf_ResponseMessageObj = new Conf_ResponseMessage();
conf_ResponseMessageObj.code = "424";
conf_ResponseMessageObj.status = "Error";
conf_ResponseMessageObj.message = "No reg unionid";
HttpContext.Response.StatusCode = 424;
return(Json(conf_ResponseMessageObj));
}
else
{
string sessionID = HttpContext.Session.Id.ToString();
HttpContext.Session.SetString("guid", orm_Conf_All_Users_Selected.guid);
HttpContext.Session.SetString("regdt", DateTime.Now.ToString());
HttpContext.Session.SetString("openid", orm_Conf_All_Users_Selected.openid);
HttpContext.Response.Cookies.Append("guid", orm_Conf_All_Users_Selected.guid);
return(Json(orm_Conf_All_Users_Selected));
}
}
}
