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