public void InsertUser(UsersItem user) { using (var cn = new SqlConnection(Settings.GetConnectionString())) { SqlCommand cmd = new SqlCommand("InsertUser"); cmd.Connection = cn; cmd.CommandType = CommandType.StoredProcedure; List <UsersItem> users = new List <UsersItem>(); cn.Open(); using (SqlDataReader dr = cmd.ExecuteReader()) { var param = new DynamicParameters(); param.Add("@UserId", dbType: DbType.Int32, direction: ParameterDirection.Output); param.Add("@Email", user.Email); param.Add("@EmailConfirmed", user.EmailConfirmed); param.Add("@AccessFailedCount", user.AccessFailedCount); param.Add("@FirstName", user.FirstName); param.Add("@LastName", user.LastName); param.Add("@LockOutEnable", user.LockoutEnabled); param.Add("@PasswordHash", user.PasswordHash); param.Add("@PhoneNumberConfirmed", user.PhoneNumberConfirmed); param.Add("@RoleId", user.Role); param.Add("@TwoFactorEnabled", user.TwoFactorEnabled); param.Add("@UserName", user.UserName); cn.Execute("InsertUser", param, commandType: CommandType.StoredProcedure); } } }
public static void Do(Db db) { try { int n = NextFixedNumber(); var d = new UsersItem() { UserId = n }; d.CodeSearch = "0 1 2"; d.Date = DateTime.Now; d.GuidSearch = "asdasd"; d.ID = "code_123"; d.IsLive = 1; d.LangSearch = "1"; d.TextSearch = "sdsdf ksajdks"; d.TitleSearch = "0 1 2"; db.Table <UsersItem>().Save(d); } catch (Exception ex) { Console.WriteLine("Parallel2: " + ex.Message); lock (_lock) { errors++; } } }
/// <summary> /// vmess协议服务器配置 /// </summary> /// <param name="config"></param> /// <param name="v2rayConfig"></param> /// <returns></returns> private static int ServerInbound(Config config, ref V2rayConfig v2rayConfig) { try { UsersItem usersItem; if (v2rayConfig.inbound.settings.clients.Count <= 0) { usersItem = new UsersItem(); v2rayConfig.inbound.settings.clients.Add(usersItem); } else { usersItem = v2rayConfig.inbound.settings.clients[0]; } //远程服务器端口 v2rayConfig.inbound.port = config.port(); //远程服务器用户ID usersItem.id = config.id(); usersItem.alterId = config.alterId(); usersItem.email = Global.userEMail; //远程服务器底层传输配置 StreamSettings streamSettings = v2rayConfig.inbound.streamSettings; boundStreamSettings(config, "in", ref streamSettings); } catch { } return(0); }
public IActionResult Create([FromBody] UsersItem item) { if (item == null) { return(BadRequest()); } UserItems.Add(item); return(CreatedAtRoute("GetUser", new { id = item.User }, item)); }
public void Add(UsersItem usersItems) { string query = "Insert into UsersItems values(@Id, @CreationDate, @DeletedDate, @UserId, @ItemId, @Comment, @Rating)"; using (var connection = new SqlConnection(configurationService.connectionString)) { var rowsAffected = connection.Execute(query, usersItems); if (rowsAffected != 1) { throw new Exception("Error"); } } }
public static void PutUserItem(UsersItem item) { //JavaScriptSerializer ser = new JavaScriptSerializer(); //ser.MaxJsonLength = Int32.MaxValue; //string data = ser.Serialize(item); //using (var client = new WebClient()) //{ // client.Encoding = Encoding.UTF8; // client.UploadString(TopSecret.ElasticUrl + item.UserId + "/" + item.ID, "PUT", data); //} db.Table <UsersItem>().Save(item); i++; if (i % 1000 == 0) { Console.WriteLine(i); } }
public static void PutUserItem(UsersItem item) { //JavaScriptSerializer ser = new JavaScriptSerializer(); //ser.MaxJsonLength = Int32.MaxValue; //string data = ser.Serialize(item); //using (var client = new WebClient()) //{ // client.Encoding = Encoding.UTF8; // client.UploadString(TopSecret.ElasticUrl + item.UserId + "/" + item.ID, "PUT", data); //} db.Table<UsersItem>().Save(item); i++; if (i % 1000 == 0) { Console.WriteLine(i); } }
/// <summary> /// vmess协议服务器配置 /// </summary> /// <param name="config"></param> /// <param name="v2rayConfig"></param> /// <returns></returns> private static int outbound(Config config, ref V2rayConfig v2rayConfig) { try { VnextItem vnextItem; if (v2rayConfig.outbound.settings.vnext.Count <= 0) { vnextItem = new VnextItem(); v2rayConfig.outbound.settings.vnext.Add(vnextItem); } else { vnextItem = v2rayConfig.outbound.settings.vnext[0]; } //远程服务器地址和端口 vnextItem.address = config.address(); vnextItem.port = config.port(); UsersItem usersItem; if (vnextItem.users.Count <= 0) { usersItem = new UsersItem(); vnextItem.users.Add(usersItem); } else { usersItem = vnextItem.users[0]; } //远程服务器用户ID usersItem.id = config.id(); usersItem.alterId = config.alterId(); usersItem.security = config.security(); //Mux v2rayConfig.outbound.mux.enabled = config.muxEnabled; //远程服务器底层传输配置 StreamSettings streamSettings = v2rayConfig.outbound.streamSettings; boundStreamSettings(config, "out", ref streamSettings); } catch { } return(0); }
public void UpdatePassword(UsersItem user) { using (var cn = new SqlConnection(Settings.GetConnectionString())) { SqlCommand cmd = new SqlCommand("GetAllUsers"); cmd.Connection = cn; cmd.CommandType = CommandType.StoredProcedure; List <UsersItem> users = new List <UsersItem>(); cn.Open(); var param = new DynamicParameters(); param.Add("@UserId", user.UserId); param.Add("@PasswordHash", user.PasswordHash); cn.Execute("UpdateUser", param, commandType: CommandType.StoredProcedure); } }
private static void CreateUsersItemsData() { firstUsersItems = new UsersItem { UserId = firstUser.Id, ItemId = firstItem.Id, Comment = "1st comment", Rating = 3 }; secondUsersItems = new UsersItem { UserId = secondUser.Id, ItemId = firstItem.Id, Comment = "2nd comment", Rating = 4 }; thirdUsersItems = new UsersItem { UserId = secondUser.Id, ItemId = secondItem.Id, Comment = "3rd comment", Rating = 5 }; fourthUsersItems = new UsersItem { UserId = firstUser.Id, ItemId = fourthItem.Id, Comment = "4th comment", Rating = 2 }; fifthUsersItems = new UsersItem { UserId = secondUser.Id, ItemId = fourthItem.Id, Comment = "5th comment", Rating = 3 }; }
public IEnumerable <UsersItem> GetAllUsers() { using (var cn = new SqlConnection(Settings.GetConnectionString())) { SqlCommand cmd = new SqlCommand("GetAllUsers"); cmd.Connection = cn; cmd.CommandType = CommandType.StoredProcedure; List <UsersItem> users = new List <UsersItem>(); cn.Open(); using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { UsersItem user = new UsersItem(); user.Email = dr["Email"].ToString(); user.EmailConfirmed = dr["EmailConfirmed"].ToString(); user.AccessFailedCount = (int)dr["AccessFailedCount"]; user.FirstName = dr["FirstName"].ToString(); user.LastName = dr["LastName"].ToString(); user.LockoutEnabled = Convert.ToBoolean(dr["LockoutEnabled"]); user.PasswordHash = dr["PasswordHash"].ToString(); user.PhoneNumberConfirmed = Convert.ToBoolean(dr["PhoneNumberConfirmed"]); user.Role = dr["RoleId"].ToString(); user.TwoFactorEnabled = Convert.ToBoolean(dr["TwoFactorEnabled"]); user.UserId = dr["UserId"].ToString(); user.UserName = dr["UserName"].ToString(); users.Add(user); } } return(users); } }
void CreateUserItemUI() { if (UserContent.childCount > 0) { foreach (Transform item in UserContent) { Destroy(item.gameObject); } } if (userList != null) { foreach (UsersItem item in userList) { GameObject userItem = Instantiate(UserItemPrefab); UserInfomation gameinfo = userItem.GetComponent <UserInfomation>(); string state = item.isOnline == 1 ? "在线" : "不在线"; bool ison = item.isOnline == 1 ? true : false; gameinfo.SetData(item.username, state, ison, (gameID, canplay) => { UsersItem NeedChange = null; foreach (UsersItem data in userList) { if (data.username == gameID) { NeedChange = data; } } if (NeedChange != null && !canplay) { NeedChange.isOnline = 0; ShutdownMeachine(NeedChange.username); } }); userItem.transform.SetParent(UserContent); } } }
/// <summary> /// vmess协议服务器配置 /// </summary> /// <param name="config"></param> /// <param name="v2rayConfig"></param> /// <returns></returns> private static int outbound(Config config, ref V2rayConfig v2rayConfig) { try { if (config.configType() == (int)EConfigType.Vmess) { VnextItem vnextItem; if (v2rayConfig.outbound.settings.vnext.Count <= 0) { vnextItem = new VnextItem(); v2rayConfig.outbound.settings.vnext.Add(vnextItem); } else { vnextItem = v2rayConfig.outbound.settings.vnext[0]; } //远程服务器地址和端口 vnextItem.address = config.address(); vnextItem.port = config.port(); UsersItem usersItem; if (vnextItem.users.Count <= 0) { usersItem = new UsersItem(); vnextItem.users.Add(usersItem); } else { usersItem = vnextItem.users[0]; } //远程服务器用户ID usersItem.id = config.id(); usersItem.alterId = config.alterId(); usersItem.email = Global.userEMail; usersItem.security = config.security(); //Mux v2rayConfig.outbound.mux.enabled = config.muxEnabled; //远程服务器底层传输配置 StreamSettings streamSettings = v2rayConfig.outbound.streamSettings; boundStreamSettings(config, "out", ref streamSettings); v2rayConfig.outbound.protocol = "vmess"; v2rayConfig.outbound.settings.servers = null; } else if (config.configType() == (int)EConfigType.Shadowsocks) { ServersItem serversItem; if (v2rayConfig.outbound.settings.servers.Count <= 0) { serversItem = new ServersItem(); v2rayConfig.outbound.settings.servers.Add(serversItem); } else { serversItem = v2rayConfig.outbound.settings.servers[0]; } //远程服务器地址和端口 serversItem.address = config.address(); serversItem.port = config.port(); serversItem.password = config.id(); serversItem.method = config.security(); serversItem.ota = false; serversItem.level = 1; v2rayConfig.outbound.mux.enabled = false; v2rayConfig.outbound.protocol = "shadowsocks"; v2rayConfig.outbound.settings.vnext = null; } } catch { } return(0); }
private static void outbound(Server server, Mode mode, ref V2rayConfig v2rayConfig) { try { var outbound = new Outbounds { settings = new Outboundsettings(), mux = new Mux(), streamSettings = new StreamSettings { network = "tcp" } }; switch (server) { case Socks5.Socks5 socks5: { var serversItem = new ServersItem { users = new List <SocksUsersItem>() }; outbound.settings.servers = new List <ServersItem> { serversItem }; serversItem.address = server.AutoResolveHostname(); serversItem.port = server.Port; serversItem.method = null; serversItem.password = null; if (socks5.Auth()) { var socksUsersItem = new SocksUsersItem { user = socks5.Username, pass = socks5.Password, level = 1 }; serversItem.users.Add(socksUsersItem); } outbound.mux.enabled = false; outbound.mux.concurrency = -1; outbound.protocol = "socks"; break; } case VLESS.VLESS vless: { var vnextItem = new VnextItem { users = new List <UsersItem>() }; outbound.settings.vnext = new List <VnextItem> { vnextItem }; vnextItem.address = server.AutoResolveHostname(); vnextItem.port = server.Port; var usersItem = new UsersItem(); vnextItem.users.Add(usersItem); usersItem.id = vless.UserID; usersItem.alterId = 0; usersItem.flow = string.Empty; usersItem.encryption = vless.EncryptMethod; outbound.mux.enabled = vless.UseMux ?? Global.Settings.V2RayConfig.UseMux; outbound.mux.concurrency = vless.UseMux ?? Global.Settings.V2RayConfig.UseMux ? 8 : -1; var streamSettings = outbound.streamSettings; boundStreamSettings(vless, ref streamSettings); if (vless.TransferProtocol == "xtls") { usersItem.flow = string.IsNullOrEmpty(vless.Flow) ? "xtls-rprx-origin" : vless.Flow; outbound.mux.enabled = false; outbound.mux.concurrency = -1; } outbound.protocol = "vless"; outbound.settings.servers = null; break; } case VMess vmess: { var vnextItem = new VnextItem { users = new List <UsersItem>() }; outbound.settings.vnext = new List <VnextItem> { vnextItem }; vnextItem.address = server.AutoResolveHostname(); vnextItem.port = server.Port; var usersItem = new UsersItem(); vnextItem.users.Add(usersItem); usersItem.id = vmess.UserID; usersItem.alterId = vmess.AlterID; usersItem.security = vmess.EncryptMethod; outbound.mux.enabled = vmess.UseMux ?? Global.Settings.V2RayConfig.UseMux; outbound.mux.concurrency = vmess.UseMux ?? Global.Settings.V2RayConfig.UseMux ? 8 : -1; var streamSettings = outbound.streamSettings; boundStreamSettings(vmess, ref streamSettings); outbound.protocol = "vmess"; break; } } v2rayConfig.outbounds = new List <Outbounds> { outbound, new Outbounds { tag = "direct", protocol = "freedom" } }; } catch { // ignored } }
public void Do(Db db) { bool dispose = false; if (db == null) { db = new Db("DATA"); dispose = true; } #if (SERVER) db._db_internal.CallServer = (byte[] f) => { return(SocketTesting.CallServer(f)); }; #endif #if (SOCKETS) db._db_internal.CallServer = (byte[] f) => { return(SocketTesting.CallServer(f, db)); }; #endif #if (SOCKETS || SAMEDB || INDEXES || SERVER) db.Table <SomeData>().Delete(new HashSet <int>(db.Table <UsersItem>().Select(f => new { f.Id }).Select(f => f.Id).ToList())); #endif var d = new UsersItem() { Id = 1, TitleSearch = "read web", CodeSearch = "read web", RegexSearch = "read web", ReplaceSearch = "read web", UserId = 20 }; db.Table <UsersItem>().Save(d); d = new UsersItem() { Id = 2, TitleSearch = "read web", CodeSearch = "read web", RegexSearch = "read web", ReplaceSearch = "read web", UserId = 4975 }; db.Table <UsersItem>().Save(d); var res = db.Table <UsersItem>().Where(f => f.UserId == 20) .Search(f => f.TitleSearch, "read").Or().Search(f => f.CodeSearch, "read").Or().Search(f => f.RegexSearch, "read").Or().Search(f => f.ReplaceSearch, "read") .Search(f => f.TitleSearch, "web").Or().Search(f => f.CodeSearch, "web").Or().Search(f => f.RegexSearch, "web").Or().Search(f => f.ReplaceSearch, "web") .SelectEntity(); if (res.Count() != 1 || res[0].Id != 1) { throw new Exception("Assert failure"); } #if (SERVER || SOCKETS) if (dispose) { Logic.Dispose(); } #else if (dispose) { db.Dispose(); } #endif #if (!SOCKETS && !SAMEDB && !INDEXES && !SERVER) if (dispose) { ServerSharedData.SharedUtils.DeleteFilesAndFoldersRecursively("DATA"); } #endif }
public SalesReportsViewModel() { SalesReportRequest salesReport = new SalesReportRequest(); UsersItem user = new UsersItem(); }
public void InsertUser(UsersItem user) { _users.Add(user); }
public void UpdateUser(UsersItem user) { _users.Where(u => u.UserId == user.UserId); }
/// <summary> /// vmess协议服务器配置 /// </summary> /// <param name="config"></param> /// <param name="v2rayConfig"></param> /// <returns></returns> private static int outbound(Config config, ref V2rayConfig v2rayConfig) { try { var outbound = v2rayConfig.outbounds[0]; if (config.configType() == (int)EConfigType.Vmess) { VnextItem vnextItem; if (outbound.settings.vnext.Count <= 0) { vnextItem = new VnextItem(); outbound.settings.vnext.Add(vnextItem); } else { vnextItem = outbound.settings.vnext[0]; } //远程服务器地址和端口 vnextItem.address = config.address(); vnextItem.port = config.port(); UsersItem usersItem; if (vnextItem.users.Count <= 0) { usersItem = new UsersItem(); vnextItem.users.Add(usersItem); } else { usersItem = vnextItem.users[0]; } //远程服务器用户ID usersItem.id = config.id(); usersItem.alterId = config.alterId(); usersItem.email = Global.userEMail; usersItem.security = config.security(); //Mux outbound.mux.enabled = config.muxEnabled; //远程服务器底层传输配置 StreamSettings streamSettings = outbound.streamSettings; boundStreamSettings(config, "out", ref streamSettings); outbound.protocol = "vmess"; outbound.settings.servers = null; } else if (config.configType() == (int)EConfigType.Shadowsocks) { ServersItem serversItem; if (outbound.settings.servers.Count <= 0) { serversItem = new ServersItem(); outbound.settings.servers.Add(serversItem); } else { serversItem = outbound.settings.servers[0]; } //远程服务器地址和端口 serversItem.address = config.address(); serversItem.port = config.port(); serversItem.password = config.id(); serversItem.method = config.security(); serversItem.ota = false; serversItem.level = 1; outbound.mux.enabled = false; outbound.protocol = "shadowsocks"; outbound.settings.vnext = null; } int isBlacklist = 0; int.TryParse(config.blackOrWhite, out isBlacklist); if (isBlacklist == 0) { //freedom优先 var vmess = v2rayConfig.outbounds[0]; var freedom = v2rayConfig.outbounds[1]; v2rayConfig.outbounds[0] = freedom; v2rayConfig.outbounds[1] = vmess; } } catch { } return(0); }