/// <summary>
/// 将Dataset的数据导入数据库
/// </summary>
/// <param name="pds">数据集</param>
/// <returns></returns>
public static bool AddDatasetToUsers(DataSet pds)
{
int ic, ir;
ic = pds.Tables[0].Columns.Count;
ir = pds.Tables[0].Rows.Count;
if (pds != null && pds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < pds.Tables[0].Rows.Count; i++)
{
Users user = new Users();
String xmpy = "";
String truename = "";
if (pds.Tables[0].Rows[i][0] != null)
xmpy = pds.Tables[0].Rows[i][0].ToString().Trim();
if (pds.Tables[0].Rows[i][1] != null)
truename = pds.Tables[0].Rows[i][1].ToString().Trim();
CreatUser(truename, xmpy);
}
}
else
{
throw new Exception("导入数据为空！");
}
return true;
}
public MessageReceivedEventArgs(Core.JabberConnection objConnection, Users.JabberContact objContact,
string strSubject, string strBody)
: base(objConnection, objContact)
{
Subject = strSubject;
Body = strBody;
}
public ActionResult Register(User mUser)
{
try
{
if (ModelState.IsValid)
{
var users = new Users
{
ID = mUser.Id,
FName = mUser.FName,
LName = mUser.LName,
E_Mail = mUser.EMail,
Username = mUser.Username,
Password = mUser.Password
};
ModelsContainer db = new ModelsContainer();
db.Users.Add(users);
db.SaveChanges();
User u = new User();
return RedirectToAction("OperationResult");
}
}
catch (Exception ex)
{
return RedirectToAction("OperationResult");
}
return View();
}
protected void imgBtnSave_Click(object sender, ImageClickEventArgs e)
{
if (Page.IsValid)
{
Users user = new Users(); //����Users����
user.UserID = txtUserID.Text.Trim();
if (!user.CheckUser(user.UserID))//ʹ��CheckUser������֤�û��Ƿ����
{
user.UserName = txtUserName.Text;
user.UserPwd = FormsAuthentication.HashPasswordForStoringInConfigFile(txtUserPwd.Text, "MD5");
user.RoleId = Convert.ToInt16(ddlRole.SelectedValue);
if (user.InsertByProc())
{
lblMessage.Text = "�ɹ�������û���Ϣ��";
Server.Transfer("UserManage.aspx");
}
else
{
lblMessage.Text = "����û�ʧ�ܣ�";
}
}
else//�û����ڣ�������ʾ
{
lblMessage.Text = "���ݿ��д��ھ��иñ�ŵ��û������������룡";
}
}
}
public static Users getUserByUserID(string userID)
{
Users user = new Users();
Database db = DatabaseFactory.CreateDatabase();
string sqlCommand = "UI_GetUserByUserID";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "userID", DbType.String, userID);
// DataSet that will hold the returned results
DataSet userDataset = null;
userDataset = db.ExecuteDataSet(dbCommand);
// Note: connection was closed by ExecuteDataSet method call
if(userDataset.Tables[0].Rows.Count==1)
{
DataRow dr = userDataset.Tables[0].Rows[0];
user.UserId = dr["UserId"].ToString();
user.FirstName = dr["FirstName"].ToString();
user.LastName = dr["LastName"].ToString();
user.SubscriptionEndDate =DateTime.Parse(dr["SubscriptionEndDate"].ToString());
user.SubscriptionStartDate = DateTime.Parse(dr["SubscriptionStartDate"].ToString());
user.IsPaidSubscriber = (bool)dr["IsPaidSubscriber"];
}
return user ;
}
public static string getAddPatientQuery(Users.Patient patient)
{
StringBuilder query = new StringBuilder();
query.Append("Insert into patients values(").Append(patient.ID).Append(", ");
query.Append((int)patient.BloodGroup).Append(")");
return query.ToString();
}
public string GetUserInfoByName(string UserName)
{
if (string.IsNullOrEmpty(UserName))
{
return "";
}
Users u = new Users(1);
u.Name = UserName;
string ReturnDescption = "";
int Result = u.GetUserInformationByName(ref ReturnDescption);
if (Result < 0 || ReturnDescption != "")
{
return "获取会员信息错误!";
}
if (ReturnDescption != "")
{
return ReturnDescption;
}
return u.ID.ToString();
}
void SeedData()
{
Users u = new Users() { Email = "*****@*****.**", Login = "******", Password = "******" };
Taxonomy t = new Taxonomy() { Name = "Health" };
Taxonomy t2 = new Taxonomy() { Name = "Health.Doctor" };
t2.Parent = t;
Taxonomy t3 = new Taxonomy() { Name = "Health.Doctor.Dentist" };
t3.Parent = t2;
NHibernateHelper.Save(u);
NHibernateHelper.Save(t);
NHibernateHelper.Save(t2);
NHibernateHelper.Save(t3);
Logging l = new Logging() { Message = "this is a test", Date = DateTime.UtcNow };
l.User = u;
l.Taxonomy = t3;
NHibernateHelper.Save(l);
l.Message = "second message";
l.Date = DateTime.UtcNow;
NHibernateHelper.Save(l);
}
public static string getAddDoctorQuery(Users.Doctor doctor)
{
StringBuilder query = new StringBuilder();
query.Append("Insert into patients values(").Append(doctor.ID).Append(", ");
query.Append(doctor.DepartmentID).Append(", \'").Append(doctor.Qualification).Append("\')");
return query.ToString();
}
/// <summary>
/// Вход в систему
/// </summary>
/// <param name="Login"></param>
/// <param name="Password"></param>
public bool Login(string Login, string Password)
{
if (CheckLogin(Login) == false)
throw new ArgumentException("Такого логина не существует, перепроверьте данные.");
using (var connection = new SqlConnection(ConnectionString()))
{
var command = new SqlCommand(
"SELECT Login, Password FROM dbo.Users" +
" WHERE Login = '******'", connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
var userDB = new Users();
while (reader.Read())
{
userDB.Login = Convert.ToString(reader.GetValue(0));
userDB.Password = Convert.ToString(reader.GetValue(1));
}
if (userDB.Password == Password)
return true;
else return false;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["userID"] == null)
{
Page.RegisterStartupScript("", "<script>location='../default.aspx';</script>");
}
if (Convert.ToInt32(Session["roleID"]) == 5)
{
Page.RegisterStartupScript("", "<script>alert('你登录的用户权限不够！');location='../default.aspx'</script>");
}
else
{
if (!Page.IsPostBack)
{
try
{
string loginName = Session["userID"].ToString();
Users user = new Users();
user.LoadData(loginName);
labUser.Text = user.UserName;
}
catch
{
Page.RegisterStartupScript("", "<script>location='../default.aspx'</script>");
}
}
}
}
public ActionResult Edit(int id)
{
var user = new Users().CreateInMemoryDataSource().FirstOrDefault(x => x.Id == id);
if (user == null)
return View("Error");
return View(user); // Shows the Edit view.
}
/// <summary>
/// Constructor with 2 parameters
/// </summary>
/// <param name="loginForm"></param>
/// <param name="student"></param>
public LibraryForm(LoginForm loginForm, Users.Student student)
{
InitializeComponent();
this.loginForm = loginForm;
this.student = student;
InitializeGUI();
}
public void ResponseToDistination(Users user, string id)
{
if (Shove._Web.Cache.GetCache("UserQQBind_" + user.ID.ToString()) != null)
{
Shove._Web.Cache.ClearCache("UserQQBind_" + user.ID.ToString());
if (_Convert.StrToLong(id, 0L) < 1L)
{
JavaScript.Alert(this.Page, "您输入的 QQ 号码不合法！");
}
else
{
Thread.Sleep(500);
string returnDescription = "";
user.isQQValided = true;
user.QQ = id;
if (user.EditByID(ref returnDescription) < 0)
{
JavaScript.Alert(this.Page, returnDescription);
}
else
{
JavaScript.Alert(this.Page, "QQ号码绑定成功。", "UserQQBind.aspx");
}
}
}
else
{
base.Response.Redirect("../../Default.aspx", true);
}
}
//[Route("~/")]
//[Route("")]
public ActionResult Index()
{
List<ArticleModel> articles = new List<ArticleModel>();
user = (Users)Session["User"];
// if (ModelState.IsValid)
// {
ConnManager connManager = new ConnManager();
if(user!= null && user.UserId == 1)
articles = connManager.GetArticles("Select * from VwArticles order by articleId desc");
else
articles = connManager.GetArticles("Select * from VwArticles where IsDisplay =1 order by articleId desc");
// }
PagingInfo info = new PagingInfo();
info.SortField = " ";
info.SortDirection = " ";
info.PageSize = 7;
info.PageCount = Convert.ToInt32(Math.Ceiling((double)(articles.Count/info.PageSize)));
info.CurrentPageIndex = 0;
// var query = articles.OrderByDescending(c => c.ArticleID).Take(info.PageSize);
var query = articles.AsQueryable();
query = query.Skip(info.CurrentPageIndex * info.PageSize).Take(info.PageSize);
ViewBag.PagingInfo = info;
return View(query.ToList());
}
public TwitterClient(IRestClient client, string consumerKey, string consumerSecret, string callback)
: base(client)
{
Encode = true;
Statuses = new Statuses(this);
Account = new Account(this);
DirectMessages = new DirectMessages(this);
Favourites = new Favourites(this);
Block = new Block(this);
Friendships = new Friendship(this);
Lists = new List(this);
Search = new Search(this);
Users = new Users(this);
FriendsAndFollowers = new FriendsAndFollowers(this);
OAuthBase = "https://api.twitter.com/oauth/";
TokenRequestUrl = "request_token";
TokenAuthUrl = "authorize";
TokenAccessUrl = "access_token";
Authority = "https://api.twitter.com/";
Version = "1";
#if !SILVERLIGHT
ServicePointManager.Expect100Continue = false;
#endif
Credentials = new OAuthCredentials
{
ConsumerKey = consumerKey,
ConsumerSecret = consumerSecret,
};
if (!string.IsNullOrEmpty(callback))
((OAuthCredentials)Credentials).CallbackUrl = callback;
}
public ActionResult Index(string tbLogin, string tbPassword, string tbPassword2, string tbEmail, string tbFirstName, string tbLastName)
{
StringBuilder sb = new StringBuilder();
if (tbPassword != tbPassword2)
{
sb.Append("Паролі не співпадають!");
}
if (_usersRepository.GetUserByLogin(tbLogin) != null)
{
sb.Append("Користувач з таким логіном вже існує!");
}
string message = sb.ToString();
if (!string.IsNullOrWhiteSpace(message))
{
ViewBag.Message = message;
return View();
}
var user = new Users()
{
Email = tbEmail,
Firstname = tbFirstName,
Lastname = tbLastName,
Login = tbLogin,
Password = tbPassword
};
_usersRepository.AddUser(user);
return Redirect("/");
}
public AuthModule(ITokenizer tokenizer, Users users)
: base("/auth")
{
Post["/"] = x =>
{
var request = this.Bind<AuthRequest>();
if (string.IsNullOrEmpty(request.Identifier))
{
return HttpStatusCode.Unauthorized;
}
var user = users.ValidateUsernameOrEmail(request.Identifier, request.Password);
if (user == null)
{
return HttpStatusCode.Unauthorized;
}
var userIdentity = new UserIdentity(user);
var token = tokenizer.Tokenize(userIdentity, Context);
return new
{
Token = token,
Username = user.Username,
UserId = user.Id
};
};
Get["/"] = _ =>
{
this.RequiresAuthentication();
return Context.CurrentUser;
};
}
protected void Page_Load(object sender, EventArgs e)
{
// string id = Request.QueryString["id"];
// if (id != null)
// SessionControl.setVar("id", id);
Users u = new Users();
bool Error = false;
if (!string.IsNullOrEmpty(Request.Form["name"]))
u.Email = Request.Form["name"];
else
Error = true;
if (!string.IsNullOrEmpty(Request.Form["pass"]))
u.Password = Request.Form["pass"];
else
Error = true;
if ( !Error)
{
u = Users.checkExixts(Request.Form["name"],Request.Form["pass"]);
if (u == null)
info = "Error";
else
{
info = "OK";
SessionControl.setVar("id", u.Id);
}
}
}
protected void btnQuash_Click(object sender, EventArgs e)
{
int chaseID = _Convert.StrToInt(this.labChase_id.Text, 0);
if (chaseID < 1)
{
PF.GoError(7, "没有记录!", "Admin_ChaseDetail");
}
else
{
long num2 = _Convert.StrToLong(this.tbInitiateUserID.Value, -1L);
Users users = new Users(base._Site.ID)[base._Site.ID, num2];
if (users == null)
{
PF.GoError(4, "数据库繁忙，请重试", "Admin_ChaseDetail");
}
else
{
string returnDescription = "";
int num3 = users.QuashChaseTask((long)chaseID, true, ref returnDescription);
if ((returnDescription != "") || (num3 != 0))
{
PF.GoError(4, returnDescription, "Admin_ChaseDetail");
}
else
{
this.BindData(chaseID);
}
}
}
}
protected void g_ItemCommand(object source, DataListCommandEventArgs e)
{
if (e.CommandName == "btnQuash")
{
long siteid = _Convert.StrToLong(((HtmlInputHidden)e.Item.FindControl("tbSiteID")).Value, -1L);
long num2 = _Convert.StrToLong(((HtmlInputHidden)e.Item.FindControl("tbInitiateUserID")).Value, -1L);
long schemeID = _Convert.StrToLong(((HtmlInputHidden)e.Item.FindControl("tbSchemeID")).Value, -1L);
if (((siteid < 0L) || (num2 < 0L)) || (schemeID < 0L))
{
PF.GoError(1, "参数错误", "Admin_SchemeQuash");
}
else
{
Users users = new Users(siteid)[siteid, num2];
if (users == null)
{
PF.GoError(4, "数据库繁忙，请重试", "Admin_SchemeQuash");
}
else
{
string returnDescription = "";
if (users.QuashScheme(schemeID, true, ref returnDescription) < 0)
{
PF.GoError(1, returnDescription, "Admin_SchemeQuash");
}
else
{
new Tables.T_UserDetails { Memo = { Value = "投注通讯故障撤单" } }.Update("SchemeID = " + schemeID.ToString() + " and OperatorType = 9");
this.BindData();
}
}
}
}
}
protected void btnGO_Click(object sender, EventArgs e)
{
string input = "LtnyeFVjxGloveshove19791130ea8g502shove!@#$%^&*()__";
try
{
input = this.ViewState["MobileValidNumber_" + base._User.ID.ToString()].ToString();
input = Encrypt.UnEncryptString(PF.GetCallCert(), Encrypt.Decrypt3DES(PF.GetCallCert(), input, PF.DesKey));
}
catch
{
}
if (input != this.tbValidPassword.Text.Trim())
{
JavaScript.Alert(this.Page, "验证串错误。");
}
else
{
Users user = new Users(base._Site.ID);
base._User.Clone(user);
base._User.Mobile = this.tbUserMobile.Text;
base._User.isMobileValided = true;
string returnDescription = "";
if (base._User.EditByID(ref returnDescription) < 0)
{
user.Clone(base._User);
JavaScript.Alert(this.Page, returnDescription);
}
else
{
JavaScript.Alert(this.Page, "手机绑定成功。", "UserMobileBind.aspx");
}
}
}
private void UpdatePwd(ref string errMsg)
{
string lotteryUserId = Request.Form["lotUserId"];
string pwd = Request.Form["pwd"];
var userId = 0L;
long.TryParse(lotteryUserId,out userId);
if (userId <= 0)
{
errMsg = string.Format("请求参数不正确lotUserId={0}",userId);
return ;
}
var _User = new Users(1);
_User.ID = userId;
var rs = string.Empty;
_User.GetUserInformationByID(ref rs);
_User.Password = pwd;
string ReturnDescription = "";
if (_User.EditByID(ref ReturnDescription) < 0)
{
new Log("Users").Write("同步修改密码失败：" + ReturnDescription);
errMsg = "同步修改密码失败：" + ReturnDescription;
}
}
public Cps(Users user)
{
this.User = user;
this.ID = -1L;
this.SiteID = user.SiteID;
this.OwnerUserID = user.ID;
this.Name = "";
this.Url = "";
this.LogoUrl = "";
this.BonusScale = 0.0;
this.ON = false;
this.IsShow = true;
this.Company = "";
this.Address = "";
this.PostCode = "";
this.ResponsiblePerson = "";
this.ContactPerson = "";
this.Telephone = "";
this.Fax = "";
this.Mobile = "";
this.Email = "";
this.QQ = "";
this.ServiceTelephone = "";
this.MD5Key = "";
this.Type = -1;
this.DomainName = "";
this.ParentID = -1L;
this.OperatorID = 1L;
this.CommendID = -1L;
this.DateTime = System.DateTime.Now;
this.Content = null;
}
/// <summary>
/// Method which loads the gridview with all the Users.
/// </summary>
protected void loadGridView()
{
Users user = new Users();
GridView1.DataSource = user.getAllUsers();
GridView1.DataBind();
}
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
Users user = new Users();//创建Users对象user
string uid = TxtUserName.Text.Trim();
string pwd = FormsAuthentication.HashPasswordForStoringInConfigFile(TxtUserPwd.Text.Trim(), "MD5");
if (user.CheckPassword(uid))//根据用户编号查询用户密码
{
if (user.UserPwd == pwd)//输入密码与用户密码相同
{
CreateCookie();
Session["userID"] = uid;//存储用户编号
user.LoadData(uid);
Session["UserName"] = user.UserName;
Session["roleID"] = user.RoleId;
RedirectPage(user.RoleName);
}
else//密码错误，给出提示
{
lblMessage.Text = "您输入的密码错误！";
}
}
else//用户不存在，给出提示
{
lblMessage.Text = "该用户不存在！";
}
Page.RegisterStartupScript("", "<script>alert('" + lblMessage.Text + "');</script>");
}
public ReturnMessage Rate(string userName, uint place, uint rating)
{
if (rating > 10)
{
throw new FormatException("Rating was beyond acceptable value (10)");
}
AspNetUser user = new Users().FindByUserName(userName);
if (user == null)
{
return new ReturnMessage { Success = false, Message = "User does not exist" };
}
if (DB.Ratings.FirstOrDefault(x => x.AspNetUser.UserName == userName && x.LugarId == (int)place) != null)
{
return new ReturnMessage { Success = false, Message = "Rating already exists for this user/place combination" };
}
try
{
DB.Ratings.Add(new Rating
{
UserId = user.Id,
Date = DateTime.Now,
LugarId = (int)place,
Rating1 = (int)rating
});
#if Release
DB.SaveChanges();
#endif
}
catch (Exception e)
{
return new ReturnMessage { Success = false, Message = e.Message };
}
return new ReturnMessage { Success = true, Message = "Rating saved successfully" };
}
private void GetID()
{
LotteryID = Shove._Convert.StrToInt(tbLotteryID.Value, -1);
PlayTypeID = Shove._Convert.StrToInt(tbPlayTypeID.Value, -1);
UserID = Shove._Convert.StrToInt(tbUserID.Value, -1);
SLS.Lottery lottery = new SLS.Lottery();
if (!lottery.ValidID(LotteryID))
{
PF.GoError(ErrorNumber.Unknow, "参数错误，系统异常。", this.GetType().FullName);
return;
}
if (!lottery[LotteryID].CheckPlayType(PlayTypeID))
{
PF.GoError(ErrorNumber.Unknow, "参数错误，系统异常。", this.GetType().FullName);
return;
}
LotteryName = lottery[LotteryID].name;
PlayTypeName = lottery.GetPlayTypeName(PlayTypeID);
Name = new Users(1)[1, UserID].Name;
}
/// <summary>
/// Add new user id field will be ignored
/// </summary>
private static void AddNewUser(string name, string pass, int admin, string desc, string uOptions, string aOptions)
{
try
{
db_config_users dcu = new db_config_users();
dcu.Open(); // open connection
// user with name or pass empty
if (name == string.Empty || pass == string.Empty) { Generic.JavaScriptInjector("NewUserError", "alert('name or pass are empty');"); return; }
Users user = new Users
{
Name = name,
Pass = pass,
AdMIn = admin,
Description = desc,
UserOptions = uOptions,
AdMInOptions = aOptions
};
dcu.AddUser(user);
dcu.Close(); // close connection
Generic.JavaScriptInjector("alert('New user added'); window.location.reload();");
}
catch (Exception ex)
{
Generic.JavaScriptInjector("alert('" + ex.Message + "');");
}
}
public string UserRegister(string Name, string Password, string Email, string RealityName)
{
long CpsID = -1;
long CommenderID = -1;
string Memo = "";
Users user = new Users(1);
user.Name = Name;
user.Password = Password;
user.Email = Email;
user.RealityName = RealityName;
user.UserType = 2;
user.CommenderID = CommenderID;
user.CpsID = CpsID;
user.Memo = Memo;
string ReturnDescription=string.Empty;
int Result = user.Add(ref ReturnDescription);
if (Result < 0)
{
new Log("Users").Write("会员注册不成功：" + ReturnDescription);
return "会员注册不成功：" + ReturnDescription;
}
Result = user.Login(ref ReturnDescription);
if (Result < 0)
{
new Log("Users").Write("注册成功后登录失败：" + ReturnDescription);
return "注册成功后登录失败：" + ReturnDescription;
}
return "1";
}
public IQueryable <User> FindAll(Expression <Func <User, bool> >?predicate = null) => Users .Where(u => !u.IsDeleted) .WhereIf(predicate != null, predicate !);
private static async void BotOnMessageReceived(object sender, MessageEventArgs messageEventArgs)
{
var message = messageEventArgs.Message;
if (message == null || message.Type != MessageType.Text)
{
return;
}
switch (message.Text.Split(' ').First())
{
case "/auth":
const string getVkCodeUrl = @"https://oauth.vk.com/authorize?client_id=" + Consts.VkAppId +
@"&display=page&redirect_uri=https://oauth.vk.com/blank.html&display=page&scope=messages,offline&response_type=code";
await Bot.SendTextMessageAsync(message.Chat.Id, getVkCodeUrl);
break;
case "/setToken=":
var vkTokenUrl = @"https://oauth.vk.com/access_token?client_id=" + Consts.VkAppId +
@"&client_secret=" + Consts.VkAppSecureKey +
@"&redirect_uri=https://oauth.vk.com/blank.html&code=";
var vkCode = message.Text.Replace("/setToken= ", "");
vkTokenUrl += vkCode;
var vkResult = await Client.GetStringAsync(vkTokenUrl);
var jObject = JObject.Parse(vkResult);
Consts.VkAccessToken = (string)jObject.SelectToken("access_token");
await Bot.SendTextMessageAsync(message.Chat.Id, Consts.VkAccessToken);
break;
case "/getmessages":
if (!EnableGetMessages)
{
return;
}
EnableGetMessages = false;
VkConnect = true;
while (VkConnect)
{
var conversationsUrl =
@"https://api.vk.com/method/messages.getConversations?v=5.80&access_token=" +
Consts.VkAccessToken +
@"&offset=0&count=200&extended=0&filter=unread";
var conversationsJson = await Client.GetStringAsync(conversationsUrl);
var conversations = Conversations.FromJson(JObject.Parse(conversationsJson).ToString());
foreach (var conversation in conversations.Response.Items)
{
var historyUrl =
@"https://api.vk.com/method/messages.getHistory?v=5.80&access_token=" + Consts.VkAccessToken +
"&offset=0&user_id=" + conversation.Conversation.Peer.Id + "&count=" +
conversation.Conversation.UnreadCount;
var historyJson = await Client.GetStringAsync(historyUrl);
var unreadMessages = History.FromJson(JObject.Parse(historyJson).ToString());
var messageList = new List <MessageObject>();
var i = 0;
foreach (var unreadMessage in unreadMessages.Response.Items)
{
var messageObj = new MessageObject
{
Id = i,
Text = unreadMessage.Text,
FromId = unreadMessage.FromId
};
messageList.Add(messageObj);
i++;
}
foreach (var messageObj in messageList)
{
var userUrl =
@"https://api.vk.com/method/users.get?v=5.80&access_token=" +
Consts.VkAccessToken +
@"&user_ids=" + messageObj.FromId;
var userJson = await Client.GetStringAsync(userUrl);
var user = Users.FromJson(userJson);
await Bot.SendChatActionAsync(message.Chat.Id, ChatAction.Typing);
await Task.Delay(500); // simulate longer running task
var inlineKeyboard = new InlineKeyboardMarkup(new[]
{
new [] // first row
{
InlineKeyboardButton.WithCallbackData("Send"),
}
});
await Bot.SendTextMessageAsync(message.Chat.Id, "от: " + user.Response[0].FirstName + " "
+ user.Response[0].LastName + " текст: "
+ messageObj.Text, replyMarkup : inlineKeyboard);
}
}
Thread.Sleep(300000);
}
break;
case "/send":
var sendUrl = @"https://api.vk.com/method/messages.send?v=5.80&access_token=" +
Consts.VkAccessToken +
@"&user_id=290761122" + @"&random_id=" + new DateTime().Millisecond +
@"&message=" + message.Text.Replace("/send ", "");
await Client.GetStringAsync(sendUrl);
break;
case "/stop":
VkConnect = false;
EnableGetMessages = true;
break;;
}
}
public async Task <IHttpActionResult> Validate(SummonerModel model)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
try
{
// Summoner MUST exist.
var riotSummoner = await Riot.FindSummonerAsync(model.Region, model.SummonerName);
var user = await Users.GetUserAsync();
if (riotSummoner == null)
{
return(Conflict("Summoner not found."));
}
// Summoner MUST NOT be registered.
if (await Summoners.IsSummonerRegistered(model.Region, model.SummonerName))
{
return(Conflict("Summoner is already registered."));
}
var runePages = await Riot.GetRunePagesAsync(model.Region, riotSummoner.Id);
var code = await Validation.GenerateAsync(User.Identity.Name, riotSummoner.Id, model.Region);
if (!runePages.Any(page => string.Equals(page.Name, code, StringComparison.InvariantCultureIgnoreCase)))
{
return(StatusCode(HttpStatusCode.ExpectationFailed));
}
// Create the data entity and associate it with the current user
var currentSummoner =
await Summoners.AddSummonerAsync(user, riotSummoner.Id, model.Region, riotSummoner.Name);
// If the user doesn't have an active summoner, assign the new summoner as active.
if (await Summoners.GetActiveSummonerAsync(user) == null)
{
await Summoners.SetActiveSummonerAsync(currentSummoner);
}
// Send confirmation mail.
Trace.WriteLine($"user.id={user.Id}, user.name={user.Name}, summoner.Id={currentSummoner.Id}");
BackgroundJob.Enqueue <ConfirmRegistrationMailJob>(job => job.Execute(user.Id, currentSummoner.Id));
// Queue up the league update.
var jobId = BackgroundJob.Enqueue <LeagueUpdateJob>(job => job.Execute(currentSummoner.Id));
// Queue up flair update.
jobId = BackgroundJob.ContinueWith <FlairUpdateJob>(jobId, job => job.Execute(user.Id));
// Queue up confirmation mail.
//jobId = BackgroundJob.ContinueWith<ConfirmFlairUpdatedMailJob>(jobId,
// job => job.Execute(user.Id, currentSummoner.Id));
return(Ok());
}
catch (RiotHttpException e)
{
switch ((int)e.StatusCode)
{
case 500:
case 503:
return(Conflict("Error communicating with Riot (Service unavailable)"));
}
throw;
}
}
protected void btnEditUser_Click(object sender, EventArgs e)
{
MemberInfo user = Users.GetUser(this.userId);
if (this.txtRealName.Text.Trim().Length > 20 || (this.txtRealName.Text.Trim().Length > 0 && !Regex.IsMatch(this.txtRealName.Text.Trim(), "^[A-Za-z\\u4e00-\\u9fa5]+$")))
{
this.ShowMsg("真实姓名限制在20个字符以内,只能由中文或英文组成", false);
}
else
{
user.GradeId = this.drpMemberRankList.SelectedValue.Value;
user.RealName = this.txtRealName.Text.Trim();
if (this.rsddlRegion.GetSelectedRegionId().HasValue)
{
user.RegionId = this.rsddlRegion.GetSelectedRegionId().Value;
user.TopRegionId = RegionHelper.GetTopRegionId(user.RegionId, true);
}
user.Address = Globals.HtmlEncode(this.txtAddress.Text);
user.QQ = this.txtQQ.Text.Trim();
user.NickName = this.txtMSN.Text.Trim();
if (this.calBirthday.SelectedDate.HasValue)
{
user.BirthDate = this.calBirthday.SelectedDate.Value;
}
if (!string.IsNullOrEmpty(this.txtprivateEmail.Text.Trim()) && user.Email != this.txtprivateEmail.Text.Trim() && user.UserName != this.txtprivateEmail.Text.Trim())
{
MemberInfo memberInfo = MemberProcessor.FindMemberByUsername(this.txtprivateEmail.Text.Trim());
if (Users.MemberEmailIsExist(this.txtprivateEmail.Text.Trim()) || (memberInfo != null && memberInfo.UserName == this.txtprivateEmail.Text.Trim()))
{
this.ShowMsg("邮箱已存在，请重新输入!", false);
return;
}
user.EmailVerification = false;
}
user.Email = this.txtprivateEmail.Text.Trim();
if (!string.IsNullOrEmpty(this.txtCellPhone.Text.Trim()) && user.CellPhone != this.txtCellPhone.Text.Trim() && user.UserName != this.txtCellPhone.Text.Trim())
{
MemberInfo memberInfo2 = MemberProcessor.FindMemberByUsername(this.txtCellPhone.Text.Trim());
if (MemberProcessor.IsUseCellphone(this.txtCellPhone.Text.Trim()) || (memberInfo2 != null && memberInfo2.UserName == this.txtCellPhone.Text.Trim()))
{
this.ShowMsg("手机号码已存在!", false);
return;
}
user.CellPhoneVerification = false;
}
user.CellPhone = this.txtCellPhone.Text.Trim();
user.Gender = this.gender.SelectedValue;
string text = this.hidTagId.Value;
if (string.IsNullOrWhiteSpace(text))
{
text = ",";
}
if (text != ",")
{
text = "," + text + ",";
}
user.TagIds = text;
if (MemberHelper.Update(user, false))
{
this.ShowMsg("成功修改了当前会员的个人资料", true);
}
else
{
this.ShowMsg("当前会员的个人信息修改失败,请检查您的邮箱是否与其它会员相同了。", false);
}
}
}
public static bool DamageOverride(TakeDamage take, ref DamageEvent damage, ref TakeDamage.Quantity quantity)
{
if (damage.attacker.idMain != damage.victim.idMain)
{
if (!Core.OverrideDamage || float.IsInfinity(damage.amount))
{
return(true);
}
if ((damage.victim.id.GetComponent <Character>() == null) && (damage.attacker.client != null))
{
ulong ownerID = (damage.victim.client != null) ? damage.victim.client.userID : ((ulong)0L);
if (damage.victim.idMain is DeployableObject)
{
ownerID = (damage.victim.idMain as DeployableObject).ownerID;
}
if (damage.victim.idMain is StructureComponent)
{
ownerID = (damage.victim.idMain as StructureComponent)._master.ownerID;
}
ulong num2 = (damage.attacker.client != null) ? damage.attacker.client.userID : ((ulong)0L);
if (damage.attacker.idMain is DeployableObject)
{
num2 = (damage.attacker.idMain as DeployableObject).ownerID;
}
if (damage.attacker.idMain is StructureComponent)
{
num2 = (damage.attacker.idMain as StructureComponent)._master.ownerID;
}
if (((ownerID == num2) || Users.SharedGet(ownerID, num2)) && (Core.OwnershipDestroy || Core.DestoryOwnership.ContainsKey(damage.attacker.client.userID)))
{
Config.Get("OVERRIDE.DAMAGE", damage.attacker.idMain.name.Replace("(Clone)", "") + ".DAMAGE", ref damage.amount, true);
return(true);
}
}
bool result = true;
if ((damage.attacker.client != null) && (damage.attacker.idMain is Character))
{
WeaponImpact extraData = damage.extraData as WeaponImpact;
string str = (extraData != null) ? extraData.dataBlock.name : "Hunting Bow";
string str2 = str.Replace(" ", "") + ".DAMAGE";
string key = str2 + "." + damage.victim.idMain.name.Replace("(Clone)", "");
string str4 = str2 + ".HEADSHOT";
if (Config.Get("OVERRIDE.DAMAGE", key, ref result, true) && !result)
{
return(false);
}
float[] numArray = (extraData != null) ? new float[] { extraData.dataBlock.damageMin, extraData.dataBlock.damageMax } : new float[] { 75f, 75f };
Config.Get("OVERRIDE.DAMAGE", (damage.bodyPart == BodyPart.Head) ? str4 : str2, ref numArray, true);
damage.amount = UnityEngine.Random.Range(Math.Min(numArray[0], numArray[1]), Math.Max(numArray[0], numArray[1]));
if ((extraData != null) && (damage.extraData is BulletWeaponDataBlock))
{
damage.amount *= (damage.extraData as BulletWeaponDataBlock).IsSilenced(extraData.itemRep) ? 0.8f : 1f;
}
if ((extraData != null) && (damage.extraData is BulletWeaponImpact))
{
quantity = new DamageTypeList(0f, damage.amount, 0f, 0f, 0f, 0f);
}
else
{
quantity = new DamageTypeList(0f, 0f, damage.amount, 0f, 0f, 0f);
}
damage.amount = 0f;
if (quantity.Unit == TakeDamage.Unit.List)
{
ApplyDamageTypeList(take, ref damage, quantity.DamageTypeList);
}
Helper.Log(string.Concat(new object[] {
"Damage: ", damage.attacker.idMain, "[", damage.attacker.networkViewID, "] from ", str, " hit ", damage.victim.idMain, "[", damage.victim.networkViewID, "] on ", damage.amount, "(", numArray[0], "-", numArray[1],
") pts."
}), false);
}
else if (!(damage.attacker.idMain is Character))
{
float baseReturnDmg = 0f;
float explosionRadius = 0f;
if (damage.attacker.id is TimedGrenade)
{
baseReturnDmg = (damage.attacker.id as TimedGrenade).damage;
explosionRadius = (damage.attacker.id as TimedGrenade).explosionRadius;
}
if (damage.attacker.id is TimedExplosive)
{
baseReturnDmg = (damage.attacker.id as TimedExplosive).damage;
explosionRadius = (damage.attacker.id as TimedExplosive).explosionRadius;
}
if (damage.attacker.id is SpikeWall)
{
baseReturnDmg = (damage.attacker.id as SpikeWall).baseReturnDmg;
explosionRadius = 0f;
}
if (baseReturnDmg > 0f)
{
string str5 = damage.attacker.idMain.name.Replace("(Clone)", "") + ".DAMAGE";
string str6 = str5 + "." + damage.victim.idMain.name.Replace("(Clone)", "");
if (Config.Get("OVERRIDE.DAMAGE", str6, ref result, true) && !result)
{
return(false);
}
Config.Get("OVERRIDE.DAMAGE", str5, ref baseReturnDmg, true);
if (explosionRadius > 0f)
{
RaycastHit hit;
bool flag2;
MeshBatchInstance instance;
Vector3 center = damage.victim.idMain.collider.bounds.center;
Vector3 a = damage.attacker.idMain.collider.bounds.center;
Vector3 direction = center - a;
float distance = Vector3.Distance(a, center);
if (Facepunch.MeshBatch.MeshBatchPhysics.Raycast(a, direction, out hit, distance, 0x10360401, out flag2, out instance))
{
IDMain main = flag2 ? instance.idMain : IDBase.GetMain(hit.collider);
GameObject obj2 = (main != null) ? main.gameObject : hit.collider.gameObject;
if (obj2 != damage.victim.idMain.gameObject)
{
damage.amount = (1f - Mathf.Clamp01(distance / explosionRadius)) * baseReturnDmg;
if (flag2)
{
damage.amount *= 0.1f;
}
}
}
}
if (damage.attacker.id is SpikeWall)
{
quantity = new DamageTypeList(0f, 0f, damage.amount, 0f, 0f, 0f);
}
else
{
quantity = new DamageTypeList(0f, 0f, 0f, damage.amount, 0f, 0f);
}
damage.amount = 0f;
if (quantity.Unit == TakeDamage.Unit.List)
{
ApplyDamageTypeList(take, ref damage, quantity.DamageTypeList);
}
}
Helper.Log(string.Concat(new object[] { "Damage: ", damage.attacker.idMain, "[", damage.attacker.networkViewID, "] owned ", damage.attacker.client, " hit ", damage.victim.idMain, "[", damage.victim.networkViewID, "] on ", damage.amount, "(", baseReturnDmg, ") pts." }), false);
}
}
return(true);
}
public async Task <IActionResult> PostUserFriendMappingsByEmail([FromRoute] string id, [FromBody] Users user)
{
var x = await _userFriendMappingsRepository.CreateUserFriendMappingByEmail(id, user);
return(Ok(x));
}
public async Task <IActionResult> Register(string Username, string Email, string Password, string Token, string FirstName, string LastName, string FBToken)
{
Users user = null;
if (!string.IsNullOrEmpty(FBToken))
{
user = _context.Users.Where(x => x.FBToken == FBToken).FirstOrDefault();
if (user == null)
{
user = _context.Users.Where(x => x.Email == Email).FirstOrDefault();
}
}
if (user == null)
{
user = new Users {
UserName = Username, Email = Email, CreationDate = DateTime.Now, FirstName = FirstName, LastName = LastName, UserType = UserType.Planner, FBToken = FBToken
};
var result = await _userManager.CreateAsync(user, Password);
if (result.Succeeded)
{
await _userManager.AddToRoleAsync(user, "Planner");
await _signInManager.SignInAsync(user, isPersistent : false);
var token = _context.UserPushToken.Where(x => x.Token == Token).FirstOrDefault();
if (token != null)
{
token.User = user;
}
_context.SaveChanges();
string Address = !string.IsNullOrEmpty(user.Address) ? user.Address : "";
string Age = !string.IsNullOrEmpty(user.Age) ? user.Age : "";
string City = !string.IsNullOrEmpty(user.City) ? user.City : "";
string Country = !string.IsNullOrEmpty(user.Country) ? user.Country : "";
DateTime CreationDate = user.CreationDate;
Gender VGender = user.Gender;
string Id = user.Id;
string Image = user.Image;
string PhoneNumber = !string.IsNullOrEmpty(user.PhoneNumber) ? user.PhoneNumber : "";
UserType UserType = user.UserType;
var events = _context.Events.Where(x => x.UserId == user.Id).FirstOrDefault();
if (events != null)
{
if (!string.IsNullOrEmpty(events.Image))
{
events.Image = "http://" + Request.Host + "/Media/" + events.Image;
}
}
else
{
events = new Events {
}
};
ApiUsersViewModel api = new ApiUsersViewModel {
Address = Address, Age = Age, City = City, Country = Country, CreationDate = CreationDate, Email = Email, FirstName = FirstName, Gender = VGender, Id = Id, Image = Image, LastName = LastName, PhoneNumber = PhoneNumber, UserName = Username, UserType = user.UserType, Events = events
};
return(Ok(api));
}
else
{
return(Ok(result));
}
}
else
{
await _signInManager.SignInAsync(user, isPersistent : false);
var token = _context.UserPushToken.Where(x => x.Token == Token).FirstOrDefault();
if (token != null)
{
token.User = user;
}
_context.SaveChanges();
string Address = !string.IsNullOrEmpty(user.Address) ? user.Address : "";
string Age = !string.IsNullOrEmpty(user.Age) ? user.Age : "";
string City = !string.IsNullOrEmpty(user.City) ? user.City : "";
string Country = !string.IsNullOrEmpty(user.Country) ? user.Country : "";
DateTime CreationDate = user.CreationDate;
Gender VGender = user.Gender;
string Id = user.Id;
string Image = user.Image;
string PhoneNumber = !string.IsNullOrEmpty(user.PhoneNumber) ? user.PhoneNumber : "";
UserType UserType = user.UserType;
var events = _context.Events.Where(x => x.UserId == user.Id).FirstOrDefault();
if (events != null)
{
if (!string.IsNullOrEmpty(events.Image))
{
events.Image = "http://" + Request.Host + "/Media/" + events.Image;
}
}
else
{
events = new Events {
}
};
ApiUsersViewModel api = new ApiUsersViewModel {
Address = Address, Age = Age, City = City, Country = Country, CreationDate = CreationDate, Email = Email, FirstName = FirstName, Gender = VGender, Id = Id, Image = Image, LastName = LastName, PhoneNumber = PhoneNumber, UserName = Username, UserType = user.UserType, Events = events
};
return(Ok(api));
}
}
public AllUserData GetUserByCardId(string id) => Users.GetUser(id);
public string[] GetAllGarages() => Users.GetGarageNumbers();
public IHttpActionResult AddCardToUser(AllUserData allData)
{
Users.AddCardToUser(allData.User, allData.Card.CardId);
return(Ok());
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
//new Log("System").Write("支付宝支付：Receive.aspx:接收到了通知！支付编号为：" + Request.QueryString["out_trade_no"]);
//***************************************************************
string subject_t = Request.QueryString["subject"]; //商品名称，用户存放用户ID
subject_t = Shove._Security.Encrypt.UnEncryptString(PF.GetCallCert(), subject_t);
string partner = "";
string key = "";
if ((subject_t.IndexOf("_alipay") < 0) && (so["OnlinePay_Alipay_UserNumber1"].ToString("") != ""))
{
//纯网关
partner = so["OnlinePay_Alipay_UserNumber1"].ToString(""); //卖家商户号
key = so["OnlinePay_Alipay_MD5Key1"].ToString(""); //MD5-Key
}
else
{
//支付宝
partner = so["OnlinePay_Alipay_UserNumber"].ToString(""); //卖家商户号
key = so["OnlinePay_Alipay_MD5Key"].ToString(""); //MD5-Key
}
string _input_charset = "utf-8";
//string alipayNotifyURL = "https://www.alipay.com/cooperate/gateway.do?"; //支付接口
//alipayNotifyURL = alipayNotifyURL + "service=notify_verify" + "&partner=" + partner + "¬ify_id=" + Request.QueryString["notify_id"];
string alipayNotifyURL = "http://notify.alipay.com/trade/notify_query.do?";
alipayNotifyURL = alipayNotifyURL + "partner=" + partner + "¬ify_id=" + Request.QueryString["notify_id"];
//获取支付宝ATN返回结果，true是正确的订单信息，false 是无效的
string responseTxt = Get_Http(alipayNotifyURL, 120000);
int i;
NameValueCollection coll;
//Load QueryString variables into NameValueCollection variable.
coll = Request.QueryString;
// Get names of all QueryStrings into a string array.
String[] requestarr = coll.AllKeys;
//进行排序；
string[] Sortedstr = Alipay.Gateway.Utility.BubbleSort(requestarr);
//构造待md5摘要字符串 ；
StringBuilder prestr = new StringBuilder();
for (i = 0; i < Sortedstr.Length; i++)
{
if (string.IsNullOrEmpty(Sortedstr[i]))
{
continue;
}
if (Request.QueryString[Sortedstr[i]] != "" && Sortedstr[i] != "sign" && Sortedstr[i] != "sign_type")
{
if (i == Sortedstr.Length - 1)
{
prestr.Append(Sortedstr[i] + "=" + Request.QueryString[Sortedstr[i]]);
}
else
{
prestr.Append(Sortedstr[i] + "=" + Request.QueryString[Sortedstr[i]] + "&");
}
}
}
prestr.Append(key);
string mysign = Alipay.Gateway.Utility.GetMD5(prestr.ToString(), _input_charset);
string sign = Request.QueryString["sign"];
string trade_status = Request.QueryString["trade_status"];
string trade_no = Request.QueryString["trade_no"]; //支付宝交易号
string out_trade_no = Request.QueryString["out_trade_no"]; //自己交易号
string payment_type = Request.QueryString["payment_type"]; //支付类型
string subject = Request.QueryString["subject"]; //商品名称，用户存放用户ID
string subject_UnEncrypt = (Shove._Security.Encrypt.UnEncryptString(PF.GetCallCert(), subject)).Split('_')[0];
bankPay = (Shove._Security.Encrypt.UnEncryptString(PF.GetCallCert(), subject)).Split('_')[2]; //支付方式，刘美慧添加
double total_fee = double.Parse(Request.QueryString["total_fee"].ToString()); //支付金额
string seller_email = Request.QueryString["seller_email"]; //卖家账号
if (seller_email != so["OnlinePay_Alipay_UserName"].ToString("") && seller_email != so["OnlinePay_Alipay_UserName_Email"].ToString(""))
{
new Log("System").Write("在线支付：收款帐号不匹配！");
return;
}
if (mysign == sign && (responseTxt == "true" || responseTxt == "success") && trade_status == "TRADE_FINISHED") //验证支付发过来的消息，签名是否正确
{
Users user;
if (_User == null)
{
user = new Users(_Site.ID)[_Site.ID, Shove._Convert.StrToLong(subject_UnEncrypt, -1)];
}
else
{
user = new Users(_Site.ID)[_Site.ID, _User.ID];
}
if (user == null)
{
new Log("System").Write("在线支付：异常用户数据！" + " 支付号：" + out_trade_no);
this.Response.Write("<script language='javascript'>window.top.location.href='" + Shove._Web.Utility.GetUrl() + "/Home/Room/OnlinePay/Fail.aspx'</script>");
return;
}
if (_User == null)
{
_User = new Users(_Site.ID)[_Site.ID, user.ID];
string ReturnDescription = "";
_User.LoginDirect(ref ReturnDescription);
}
if (WriteUserAccountToShop(_User, out_trade_no.ToString(), total_fee.ToString(), "系统交易号：" + out_trade_no.ToString() + " 支付宝交易号：" + trade_no))
{
long BuyID = 0;
if (this.Request.Url.AbsoluteUri.IndexOf("?BuyID") > 0 && this.Request.Url.AbsoluteUri.IndexOf("&") > 0)
{
BuyID = Shove._Convert.StrToLong(HttpUtility.UrlDecode(this.Request.Url.AbsoluteUri).Split('?')[1].Split('&')[0].Replace("BuyID=", ""), -1);
}
this.Response.Write("<script language='javascript'>window.top.location.href='" + Shove._Web.Utility.GetUrl() + "/tuan/step2.aspx'</script>");
return;
}
else
{
new Log("System").Write("在线支付：写入返回数据出错！" + " 支付号：" + out_trade_no);
this.Response.Write("<script language='javascript'>window.top.location.href='" + Shove._Web.Utility.GetUrl() + "/Home/Room/OnlinePay/Fail.aspx'</script>");
return;
}
}
else
{
new Log("System").Write("在线支付：校验出错！responseTxt系统要求参数为true/false，实际返回：" + responseTxt.ToString() + " trade_status系统要求返回TRADE_FINISHED，实际返回： " + trade_status.ToString() + " 生成校验码：" + mysign.ToString() + "返回校验码：" + sign.ToString() + " 支付号：" + out_trade_no);
this.Response.Write("<script language='javascript'>window.top.location.href='" + Shove._Web.Utility.GetUrl() + "/Home/Room/OnlinePay/Fail.aspx'</script>");
return;
}
}
catch (Exception Ex)
{
new Log("System").Write("在线支付：" + Ex.Message + " -- 接收数据异常！");
this.Response.Write("<script language='javascript'>window.top.location.href='" + Shove._Web.Utility.GetUrl() + "/Home/Room/OnlinePay/Fail.aspx'</script>");
return;
}
}
public User GetUserById(int id) => Users.GetUser(id);
protected override Task Load(bool forceCacheInvalidation)
{
return(Users.SimpleCollectionLoad(() => this.GetApplication().Client.Users[Name].GetFollowing(forceCacheInvalidation).Values.Select(x => new UserModel {
Username = x.Username, Avatar = x.Links.Avatar.Href
}).OrderBy(x => x.Username).ToList()));
}
public IEnumerable <User> GetAllUsers() => Users.GetAllUsers();
private string Register(Update update)
{
// поиск пользователя в бдhttp://botshop.azurewebsites.net/Account/Login
Users user = null;
string answer = "";
using (botEntities3 db = new botEntities3())
{
try
{
Token tok = db.Token.Where(x => x.token1 == update.message.text).FirstOrDefault();
if (tok != null)
{
return("Такой токен уже есть в нашей системе");
}
TelegramUser u = db.TelegramUser.Where(x => x.Username == update.message.from.id.ToString()).FirstOrDefault();
if (u != null)
{
user = db.Users.FirstOrDefault(x => x.Id == u.UserId);
return("У вас уже есть магазин");
}
}
catch
{
user = null;
}
}
if (user != null)
{
using (botEntities3 db = new botEntities3())
{
Token t = new Token();
t.token1 = update.message.text;
t.UserID = user.Id;
db.Token.Add(t);
db.SaveChanges();
}
answer += "Магазин успешно добавлен";
return(answer);
}
else
{
string em = "";
string pas = "";
Random ran = new Random();
for (int i = 0; i < 4; i++)
{
em += (char)ran.Next('a', 'z');
pas += (char)ran.Next('a', 'z');
}
try
{
int count;
using (botEntities3 db = new botEntities3())
{
count = db.Users.Count() + 10;
em += db.Users.Count().ToString() + "@bot.ru";
user = new Users()
{
Email = em,
RoleId = 1,
Passwords = pas,
Id = count
};
db.Users.Add(user);
db.SaveChanges();
}
using (botEntities3 db = new botEntities3())
{
TelegramUser t = new TelegramUser();
// count = db.Users.Where(x => x.Id == count).First().;
t.UserId = count;
t.Username = update.message.from.id.ToString();
t.BotChannel = getBotInfo(update.message.text);
db.TelegramUser.Add(t);
db.SaveChanges();
}
using (botEntities3 db = new botEntities3())
{
Token k = new Token();
k.token1 = update.message.text;
k.UserID = count;
db.Token.Add(k);
db.SaveChanges();
}
return("Регистрация прошла успешно" + Environment.NewLine + " Ваш логин:" + " " + em + " Ваш пароль " + pas + Environment.NewLine
+ " Используйте эти данные для входа в систему " + @"http://botshop.azurewebsites.net/Account/Login");
}
catch
{
return("Неверные входные данные");
}
// answer = "Вы успешно зарегистрировались" + " " + "Ваш логин " + em;
}
}
public JsonResult GetListPupils([System.Web.Http.FromUri] string seedcode, [System.Web.Http.FromUri] string centretype, [System.Web.Http.FromUri] string dataname, [System.Web.Http.FromUri] string sYear)
{
try
{
Users temp = Session["SessionUser"] as Users;
List <PupilsDataHubObj> templistpupils = new List <PupilsDataHubObj>();
List <PupilsDataHubObj> listpupils = new List <PupilsDataHubObj>();
DatahubCentre centreName = new DatahubCentre();
if (centretype.Equals("1"))
{
//get list all pupils data by school
if (seedcode.Equals("1002"))
{
templistpupils = Getlistpupil(rpGeneric2nd, sYear);
centreName = new DatahubCentre("1002", "Aberdeen City", "1");
}
else
{
templistpupils = Getlistpupil(rpGeneric2nd, sYear).Where(x => (x.SEED_Code != null && x.SEED_Code.Equals(seedcode))).ToList();;
centreName = GetListSchoolname().Where(x => x.seedcode.Equals(seedcode)).First();
}
}
else if (centretype.Equals("2"))
{
//get list pupils data by neighbourhood
if (seedcode.Equals("1002"))
{
templistpupils = Getlistpupil(rpGeneric2nd, sYear);
centreName = new DatahubCentre("1002", "Aberdeen City", "2");
}
else
{
templistpupils = GetDatahubdatabyNeighbourhoods(rpGeneric2nd, seedcode, sYear);
centreName = GetListNeighbourhoodsname(rpGeneric2nd).Where(x => x.seedcode.Equals(seedcode)).First();
}
}
switch (dataname.ToLower())
{
case "allclients":
listpupils = (from a in templistpupils where !a.SDS_Client_Ref.Equals("n/a") select a).ToList();
break;
case "male":
listpupils = (from a in templistpupils where a.Gender.ToLower().Equals("male") select a).ToList();
break;
case "female":
listpupils = (from a in templistpupils where a.Gender.ToLower().Equals("female") select a).ToList();
break;
case "pupils16":
listpupils = (from a in templistpupils where a.Age == 16 select a).ToList();
break;
case "pupils17":
listpupils = (from a in templistpupils where a.Age == 17 select a).ToList();
break;
case "pupils18":
listpupils = (from a in templistpupils where a.Age == 18 select a).ToList();
break;
case "pupils19":
listpupils = (from a in templistpupils where a.Age == 19 select a).ToList();
break;
case "movedoutwithscotland":
listpupils = (from a in templistpupils where a.status_code.ToLower().Equals("000") select a).ToList();
break;
default:
listpupils = (from a in templistpupils where a.status_code.ToLower().Equals(dataname.ToLower()) select a).ToList();
break;
}
var listdatasetdate = GetListDataSetDate();
object oResult = null;
oResult = new
{
ListPupils = listpupils.Select(x => new
{
Forename = x.Forename,
Surname = x.Surname,
Age = x.Age,
Gender = x.Gender,
CSS_Address = x.CSS_Address,
CSS_Postcode = x.CSS_Postcode,
Telephone = x.Telephone_Number,
}).OrderBy(x => x.Age).ThenBy(x => x.Forename),
DatasetSelected = listdatasetdate.Where(x => x.code.Equals(sYear)).Select(x => x.GetJson()).First(),
DataTitle = dataname,
CentreName = centreName
};
return(Json(oResult, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(ThrowJsonError(ex));
}
}
/// <summary>
/// 注册
/// </summary>
public ActionResult Register()
{
try
{
//if (WorkContext.ShopConfig.RegTimeSpan > 0)
//{
// DateTime registerTime = Users.GetRegisterTimeByRegisterIP(WorkContext.IP);
// if ((DateTime.Now - registerTime).Minutes <= WorkContext.ShopConfig.RegTimeSpan)
// return APIResult("error", "你注册太频繁，请间隔一定时间后再注册!");
//}
NameValueCollection parmas = WorkContext.postparms;
if (parmas.Keys.Count != 3)
{
return(APIResult("error", "缺少请求参数"));
}
//ajax请求
string phone = string.Empty;
string account = phone = parmas["account"].Trim();
int userid = Users.GetUidByMobile(account);
if (userid > 0)
{
return(APIResult("error", "账号已存在"));
}
int invitecode = -1;
if (parmas.AllKeys.Contains("invitecode"))
{
invitecode = int.Parse(parmas["invitecode"]); //介绍用户标识号
}
string password = parmas["password"];
string imei = parmas["imei"];
UserInfo userInfo = null;
userInfo = new UserInfo();
userInfo.UserName = account;
userInfo.UserId = Randoms.CreateRandomValue(8);
userInfo.Email = string.Empty;
userInfo.Mobile = phone;
userInfo.Salt = Randoms.CreateRandomValue(6);
userInfo.Password = Users.CreateUserPassword(password, userInfo.Salt);
userInfo.UserRid = 7; //普通用户 UserRanks.GetLowestUserRank().UserRid;
userInfo.AdminGid = 1; //非管理员组
userInfo.NickName = Randoms.CreateRandomValue(6);
userInfo.Avatar = "";
userInfo.PayCredits = 0;
userInfo.RankCredits = 0;
userInfo.VerifyEmail = 0;
userInfo.VerifyMobile = 0;
userInfo.LastVisitIP = WorkContext.IP;
userInfo.LastVisitRgId = WorkContext.RegionId;
userInfo.LastVisitTime = DateTime.Now;
userInfo.RegisterIP = WorkContext.IP;
userInfo.RegisterRgId = WorkContext.RegionId;
userInfo.RegisterTime = DateTime.Now;
userInfo.Gender = WebHelper.GetFormInt("gender");
userInfo.RealName = WebHelper.HtmlEncode(WebHelper.GetFormString("realName"));
userInfo.Bday = new DateTime(1900, 1, 1);
userInfo.IdCard = WebHelper.GetFormString("idCard");
userInfo.RegionId = WebHelper.GetFormInt("regionId");
userInfo.Address = WebHelper.HtmlEncode(WebHelper.GetFormString("address"));
userInfo.Bio = WebHelper.HtmlEncode(WebHelper.GetFormString("bio"));
userInfo.InviteCode = invitecode;
userInfo.IMEI = imei;
//创建用户
userInfo.Uid = Users.CreateUser(userInfo);
//添加用户失败
if (userInfo.Uid < 1)
{
return(APIResult("error", "注册失败"));
}
return(APIResult("success", "注册成功"));
}
catch (Exception ex)
{
Logs.Write("注册失败:" + ex.Message);
return(APIResult("error", "注册失败"));
}
}
private static void Command_Bet(string user, Command cmd, string[] args)
{
if (Running)
{
if (args.Length > 0)
{
int Value;
if (args[0] == "help")
{
if (Api.GetUnixTimeNow() - LastUsedHelp < 60 && Users.GetLevel(user) < 1)
{
return;
}
LastUsedHelp = Api.GetUnixTimeNow();
if (!Locked)
{
string temp = "Betting open for: ";
lock (Options) for (int i = 0; i < Options.Count; i++)
{
temp += "(" + (i + 1).ToString() + ") " + Options[i] + " - " + getNumberOfBets(Options[i]) + " bets (" + getTotalBetsOn(Options[i]) + " " + Currency.Name + ")" + (i + 1 < Options.Count ? ", " : "");
}
Chat.SendMessage(temp + ".");
Chat.SendMessage("Bet by typing \"!bet 50 #1\" to bet 50 " + Currency.Name + " on option 1, \"bet 25 #2\" to bet 25 " + Currency.Name + " on option 2, etc.");
}
else
{
string temp = "The pool is now closed, the following options were open for betting: ";
lock (Options) for (int i = 0; i < Options.Count; i++)
{
temp += "(" + (i + 1).ToString() + ") " + Options[i] + " - " + getNumberOfBets(Options[i]) + " bets (" + getTotalBetsOn(Options[i]) + " " + Currency.Name + ")" + (i + 1 < Options.Count ? ", " : "");
}
Chat.SendMessage(temp + ".");
}
}
else if (!Locked && int.TryParse(args[0], out Value) && args.Length > 1)
{
bool inQuote = false;
string option = "";
for (int i = 1; i < args.Length; i++)
{
if (args[i].StartsWith("\""))
{
inQuote = true;
}
if (!inQuote)
{
option = args[i];
}
if (inQuote)
{
option += args[i] + " ";
}
if (args[i].EndsWith("\""))
{
option = option.Substring(1, option.Length - 3);
inQuote = false;
}
}
if (option.ToLower() == args[1].ToLower())
{
if (option.StartsWith("#"))
{
int optionnumber = 0;
if (int.TryParse(option.Substring(1), out optionnumber))
{
option = GetOptionFromNumber(optionnumber);
if (option == "")
{
//Chat.SendMessage(user + " the option number does not exist");
lock (FalseEntries)
{
if (!FalseEntries.ContainsKey(user))
{
FalseEntries.Add(user, 0);
BetQueue.Change(10000, Timeout.Infinite);
}
}
return;
}
}
}
}
placeBet(user, option, Value);
}
}
else
{
//if (isInPool(user)) Chat.SendMessage(user + ": " + bets[user].Key + " (" + bets[user].Value + ")");
}
}
}
public IEnumerable <User> FindAllAdmins()
{
List <UserEntity> entities = Users.Where(x => x.IsAdmin).ToList();
return(FromEntity.ToUserList(entities));
}
/// <summary>
/// 登录
/// </summary>
public ActionResult Login()
{
try
{
NameValueCollection parmas = WorkContext.postparms;
if (parmas.Keys.Count != 3)
{
return(APIResult("error", "缺少请求参数"));
}
PartUserInfo partUserInfo = null;
//string type=parmas["type"];//1:微信 2:QQ 3:账户
//if (type == "1")
//{
// string openid = parmas["openid"];
// string nickname = parmas["nickname"];
// //判断此用户是否已经存在
// int uid = OAuths.GetUidByOpenIdAndServer(openid, "微信");
// if (uid > 0)//存在时
// {
// partUserInfo = Users.GetPartUserById(uid);
// }
// else
// {
// UserInfo userInfo = OAuths.CreateOAuthUser(nickname, "wx", openid, "微信", WorkContext.RegionId, "");
// partUserInfo.Uid = userInfo.Uid;
// }
//}
//else if (type == "2")
//{
// string openid = parmas["openid"];
// string nickname = parmas["nickname"];
// //判断此用户是否已经存在
// int uid = OAuths.GetUidByOpenIdAndServer(openid, "QQ");
// if (uid > 0)//存在时
// {
// partUserInfo = Users.GetPartUserById(uid);
// }
// else
// {
// UserInfo userInfo = OAuths.CreateOAuthUser(nickname, "qq", openid, "QQ", WorkContext.RegionId, "");
// partUserInfo.Uid = userInfo.Uid;
// }
//}
//else if (type == "3")
//{
//ajax请求
string accountName = parmas["account"];//手机号
string password = parmas["password"];
string imei = parmas["imei"];
//当以上验证全部通过时
partUserInfo = Users.GetPartUserByMobile(accountName);
if (partUserInfo != null)
{
if (partUserInfo.Uid <= 0)
{
return(APIResult("error", "账号不存在"));
}
if (Users.CreateUserPassword(password, partUserInfo.Salt) != partUserInfo.Password)//判断密码是否正确
{
return(APIResult("error", "密码不正确"));
}
//更新IMEI号
partUserInfo.IMEI = imei;
bool partres = Users.UpdatePartUser(partUserInfo);
if (!partres)
{
return(APIResult("error", "登录失败"));
}
}
//}
//更新用户最后访问
Users.UpdateUserLastVisit(partUserInfo.Uid, DateTime.Now, WorkContext.IP, WorkContext.RegionId);
return(APIResult("success", "登录成功"));
}
catch (Exception ex)
{
return(APIResult("error", "登录失败"));
}
}
public User GetUserByUsername(string username)
{
UserEntity entity = Users.FirstOrDefault(x => x.Username == username);
return(FromEntity.ToUser(entity));
}
protected void g_ItemCommand(object source, System.Web.UI.WebControls.DataListCommandEventArgs e)
{
long SiteID = Shove._Convert.StrToLong(((HtmlInputHidden)e.Item.FindControl("tbSiteID")).Value, -1);
long id = Shove._Convert.StrToLong(((HtmlInputHidden)e.Item.FindControl("tbID")).Value, -1);
long UserID = Shove._Convert.StrToLong(((HtmlInputHidden)e.Item.FindControl("tbUserID")).Value, -1);
double Money = Math.Round(Shove._Convert.StrToDouble(((HtmlInputHidden)e.Item.FindControl("tbMoney")).Value, 0), 2);
HtmlInputHidden tbBankName = (HtmlInputHidden)(e.Item.FindControl("tbBankName"));
HtmlInputHidden tbBankUserName = (HtmlInputHidden)(e.Item.FindControl("tbBankUserName"));
HtmlInputHidden tbBankCardNumber = (HtmlInputHidden)(e.Item.FindControl("tbBankCardNumber"));
HtmlInputHidden tbProvince = (HtmlInputHidden)(e.Item.FindControl("tbProvince"));
HtmlInputHidden tbCity = (HtmlInputHidden)(e.Item.FindControl("tbCity"));
HtmlInputHidden tbRealityName = (HtmlInputHidden)(e.Item.FindControl("tbRealityName"));
HtmlInputHidden tbAlipayID = (HtmlInputHidden)(e.Item.FindControl("tbAlipayID"));
HtmlInputHidden tbAlipayName = (HtmlInputHidden)(e.Item.FindControl("tbAlipayName"));
HtmlInputHidden tbMemo = (HtmlInputHidden)(e.Item.FindControl("tbMemo"));
HtmlInputHidden tbIsCps = (HtmlInputHidden)(e.Item.FindControl("tbIsCps"));
double DistillFormalitiesFeesScale;
if ((SiteID < 0) || (id < 0) || (UserID < 0))
{
PF.GoError(ErrorNumber.Unknow, "参数错误", this.GetType().BaseType.FullName);
return;
}
Users tu = new Users(SiteID)[SiteID, UserID];
if (tu == null)
{
PF.GoError(ErrorNumber.Unknow, "参数错误", this.GetType().BaseType.FullName);
return;
}
if (e.CommandName == "btnNoAccept")
{
TextBox tb = (TextBox)e.Item.FindControl("tbMemo1");
if (tb.Text.Trim() == "")
{
Shove._Web.JavaScript.Alert(this.Page, "请输入拒绝理由。");
return;
}
string ReturnDescription = "";
if (tu.DistillNoAccept(id, tb.Text.Trim(), _User.ID, ref ReturnDescription) < 0)
{
PF.GoError(ErrorNumber.Unknow, ReturnDescription, this.GetType().BaseType.FullName);
return;
}
BindData();
return;
}
if (e.CommandName == "btnAccept")
{
TextBox tb = (TextBox)e.Item.FindControl("tbMemo2");
if (tu.Freeze < Money)
{
Shove._Web.JavaScript.Alert(this.Page, "用户冻结账户余额不足以提款。");
return;
}
//主要出现的问题是:后台处理提款的时候,若是支付宝用户则会出现 "用户没有输入开户名"，"用户没有输入开户银行"，"用户没有输入银行卡号" 的提示
if (tbBankCardNumber.Value != "")
{
if (tbBankUserName.Value == "")
{
Shove._Web.JavaScript.Alert(this.Page, "用户没有输入开户名。");
return;
}
if (tbBankName.Value == "")
{
Shove._Web.JavaScript.Alert(this.Page, "用户没有输入开户银行。");
return;
}
if (tbBankCardNumber.Value == "")
{
Shove._Web.JavaScript.Alert(this.Page, "用户没有输入银行卡号。");
return;
}
}
//添加了 判断支付宝账号的验证
else
{
if (tbAlipayName.Value == "")
{
Shove._Web.JavaScript.Alert(this.Page, "用户没有输入支付宝账号");
return;
}
}
if (tbAlipayName.Value != "")
{
DistillFormalitiesFeesScale = so["OnlinePay_Alipay_ForUserDistill_MD5Key_ForPayOut"].ToDouble(0);
}
else
{
DistillFormalitiesFeesScale = so["OnlinePayOut_99Bill_DistillFormalitiesFeesScale"].ToDouble(0);
}
if (DistillFormalitiesFeesScale >= 1)
{
Shove._Web.JavaScript.Alert(this.Page, "提款手续费比例设置错误。");
return;
}
string ReturnDescription = "";
if (tu.DistillAccept(id, tbBankUserName.Value, tbBankName.Value, tbBankCardNumber.Value, tbAlipayID.Value, tbAlipayName.Value, tb.Text.Trim(), _User.ID, ref ReturnDescription) < 0)
{
Shove._Web.JavaScript.Alert(this.Page, "出错:" + ReturnDescription);
return;
}
Shove._Web.JavaScript.Alert(this.Page, "已经接受提款! 请到待付款一览表进行付款操作.");
BindData();
return;
}
}
public User GetEditorById(Guid id)
{
UserEntity entity = Users.FirstOrDefault(x => x.Id == id && x.IsEditor);
return(FromEntity.ToUser(entity));
}
public User GetUserByUsernameOrEmail(string username, string email)
{
UserEntity entity = Users.FirstOrDefault(x => x.Username == username || x.Email == email);
return(FromEntity.ToUser(entity));
}
public int AllUsersCount()
{
return(Users.Count());
}
public User GetUserByPasswordResetKey(string key)
{
UserEntity entity = Users.FirstOrDefault(x => x.PasswordResetKey == key);
return(FromEntity.ToUser(entity));
}
public IEnumerable <User> AllUsers()
{
List <UserEntity> entities = Users.ToList();
return(FromEntity.ToUserList(entities));
}
public User GetUserByActivationKey(string key)
{
UserEntity entity = Users.FirstOrDefault(x => x.ActivationKey == key && x.IsActivated == false);
return(FromEntity.ToUser(entity));
}
public string GetUserName(int userId)
{
return(userId > 0 ? Users.Single(x => x.Id == userId).Name : "-");
}
public int AllOrgsCount()
{
return(Users.GroupBy(rs => rs.orgID).Count());
}
