Here are the examples of the csharp api int.ToString() taken from open source projects. By voting up you can indicate which examples are most useful and appropriate.
18927 Examples
19
Source : MudProvider.cs
with GNU Lesser General Public License v3.0
from 8720826
with GNU Lesser General Public License v3.0
from 8720826
public async Task ShowHistoryQuests(int playerId, object obj)
{
await _context.Clients.User(playerId.ToString()).SendAsync("ShowHistoryQuests", obj);
}
19
Source : MudProvider.cs
with GNU Lesser General Public License v3.0
from 8720826
with GNU Lesser General Public License v3.0
from 8720826
public async Task ShowFriend(int playerId, object obj)
{
await _context.Clients.User(playerId.ToString()).SendAsync("ShowFriend", obj);
}
19
Source : MudProvider.cs
with GNU Lesser General Public License v3.0
from 8720826
with GNU Lesser General Public License v3.0
from 8720826
public async Task ShowMaster(int playerId, object obj)
{
await _context.Clients.User(playerId.ToString()).SendAsync("ShowMaster", obj);
}
19
Source : MudProvider.cs
with GNU Lesser General Public License v3.0
from 8720826
with GNU Lesser General Public License v3.0
from 8720826
public async Task ShowBox(int playerId, object obj)
{
await _context.Clients.User(playerId.ToString()).SendAsync("ShowBox", obj);
}
19
Source : MudProvider.cs
with GNU Lesser General Public License v3.0
from 8720826
with GNU Lesser General Public License v3.0
from 8720826
public async Task AddFightingTarget(int playerId, object obj)
{
await _context.Clients.User(playerId.ToString()).SendAsync("AddFightingTarget", obj);
}
19
Source : UserCenterController.cs
with Apache License 2.0
from 91270
with Apache License 2.0
from 91270
[HttpPost]
[Authorization]
public IActionResult AvatarUpload([FromForm(Name = "file")] IFormFile file)
{
try
{
if (Convert.ToBoolean(AppSettings.Configuration["AppSettings:Demo"]))
{
return toResponse(StatusCodeType.Error, "当前为演示模式 , 您无权修改任何数据");
}
var fileExtName = Path.GetExtension(file.FileName).ToLower();
var fileName = DateTime.Now.Ticks.ToString() + fileExtName;
string[] AllowedFileExtensions = new string[] { ".jpg", ".gif", ".png", ".jpeg" };
int MaxContentLength = 1024 * 1024 * 4;
if (!AllowedFileExtensions.Contains(fileExtName))
{
return toResponse(StatusCodeType.Error, "上传失败,未经允许上传类型");
}
if (file.Length > MaxContentLength)
{
return toResponse(StatusCodeType.Error, "上传图片过大,不能超过 " + (MaxContentLength / 1024).ToString() + " MB");
}
var filePath = $"/{DateTime.Now:yyyyMMdd}/";
var avatarDirectory = $"{AppSettings.Configuration["AvatarUpload:AvatarDirectory"]}{filePath}";
if (!Directory.Exists(avatarDirectory))
{
Directory.CreateDirectory(avatarDirectory);
}
using (var stream = new FileStream($"{avatarDirectory}{fileName}", FileMode.Create))
{
file.CopyTo(stream);
}
var avatarUrl = $"{AppSettings.Configuration["AvatarUpload:AvatarUrl"]}{filePath}{fileName}";
var userSession = _tokenManager.GetSessionInfo();
#region 更新用户信息
var response = _usersService.Update(m => m.UserID == userSession.UserID, m => new Sys_Users
{
AvatarUrl = avatarUrl,
UpdateID = userSession.UserID,
UpdateName = userSession.UserName,
UpdateTime = DateTime.Now
});
#endregion
#region 更新登录会话记录
_tokenManager.RefreshSession(userSession.UserID);
#endregion
return toResponse(avatarUrl);
}
catch (Exception)
{
throw;
}
}
19
Source : AssetsFile.cs
with MIT License
from 91Act
with MIT License
from 91Act
private void readBase5()
{
int clreplacedID = a_Stream.ReadInt32();
if (fileGen > 15)//5.5.0 and up
{
a_Stream.ReadByte();
int type1;
if ((type1 = a_Stream.ReadInt16()) >= 0)
{
type1 = -1 - type1;
}
else
{
type1 = clreplacedID;
}
clreplacedIDs.Add(new[] { type1, clreplacedID });
clreplacedID = type1;
/*TODO 用来替换下方的代码
if(clreplacedID == 114)
{
a_Stream.Position += 16;
}*/
var temp = a_Stream.ReadInt32();
if (temp == 0)
{
a_Stream.Position += 16;
}
a_Stream.Position -= 4;
if (type1 < 0)
{
a_Stream.Position += 16;
}
}
else if (clreplacedID < 0)
{
a_Stream.Position += 16;
}
a_Stream.Position += 16;
if (baseDefinitions)
{
int varCount = a_Stream.ReadInt32();
int stringSize = a_Stream.ReadInt32();
a_Stream.Position += varCount * 24;
string varStrings = Encoding.UTF8.GetString(a_Stream.ReadBytes(stringSize));
string clreplacedName = "";
var clreplacedVar = new List<ClreplacedMember>();
//build Clreplaced Structures
a_Stream.Position -= varCount * 24 + stringSize;
for (int i = 0; i < varCount; i++)
{
ushort num0 = a_Stream.ReadUInt16();
byte level = a_Stream.ReadByte();
bool isArray = a_Stream.ReadBoolean();
ushort varTypeIndex = a_Stream.ReadUInt16();
ushort test = a_Stream.ReadUInt16();
string varTypeStr;
if (test == 0) //varType is an offset in the string block
{ varTypeStr = varStrings.Substring(varTypeIndex, varStrings.IndexOf('\0', varTypeIndex) - varTypeIndex); }//substringToNull
else //varType is an index in an internal strig array
{ varTypeStr = baseStrings.ContainsKey(varTypeIndex) ? baseStrings[varTypeIndex] : varTypeIndex.ToString(); }
ushort varNameIndex = a_Stream.ReadUInt16();
test = a_Stream.ReadUInt16();
string varNameStr;
if (test == 0) { varNameStr = varStrings.Substring(varNameIndex, varStrings.IndexOf('\0', varNameIndex) - varNameIndex); }
else { varNameStr = baseStrings.ContainsKey(varNameIndex) ? baseStrings[varNameIndex] : varNameIndex.ToString(); }
int size = a_Stream.ReadInt32();
int index = a_Stream.ReadInt32();
int flag = a_Stream.ReadInt32();
if (index == 0) { clreplacedName = varTypeStr + " " + varNameStr; }
else
{
clreplacedVar.Add(new ClreplacedMember()
{
Level = level - 1,
Type = varTypeStr,
Name = varNameStr,
Size = size,
Flag = flag
});
}
}
a_Stream.Position += stringSize;
var aClreplaced = new ClreplacedStruct() { ID = clreplacedID, Text = clreplacedName, members = clreplacedVar };
aClreplaced.SubItems.Add(clreplacedID.ToString());
ClreplacedStructures[clreplacedID] = aClreplaced;
}
}
19
Source : CloudToGuid.cs
with GNU Lesser General Public License v3.0
from 9and3
with GNU Lesser General Public License v3.0
from 9and3
protected override void SolveInstance(IGH_DataAccess DA) {
// Input
GH_Guid g = null;
DA.GetData(0, ref g);
GeometryBase rhino_obj = Rhino.RhinoDoc.ActiveDoc.Objects.Find(g.Value).Geometry;
PointCloud c = rhino_obj as PointCloud;
DA.SetData(0, new PointCloudGH(c) );
base.Message = c.Count.ToString();
}
19
Source : DelayedQueue.cs
with GNU Lesser General Public License v3.0
from 8720826
with GNU Lesser General Public License v3.0
from 8720826
public async Task<bool> Publish<T>(int playerId, T t, int delayMin, int delayMax = 0)
{
var channel = t.GetType().Name.ToLower();
Random rnd = new Random();
var delay = delayMax > delayMin ? rnd.Next(delayMin, delayMax) : delayMin;
var timestamp = DateTimeOffset.Now.AddSeconds(delay).ToUnixTimeSeconds();
var hasAdd = await _redisDb.SortedSetAdd($"{queueName}_{channel}", playerId.ToString(), timestamp);
if (hasAdd)
{
return await _redisDb.StringSet($"{queueName}_{channel}_{playerId}", t, DateTime.Now.AddSeconds(delay).AddDays(1));
}
return await Task.FromResult(false);
}
19
Source : MudProvider.cs
with GNU Lesser General Public License v3.0
from 8720826
with GNU Lesser General Public License v3.0
from 8720826
public async Task ShowRevive(int playerId)
{
await _context.Clients.User(playerId.ToString()).SendAsync("showRevive");
}
19
Source : MudProvider.cs
with GNU Lesser General Public License v3.0
from 8720826
with GNU Lesser General Public License v3.0
from 8720826
public async Task ShowMainQuest(int playerId, object obj)
{
await _context.Clients.User(playerId.ToString()).SendAsync("ShowMainQuest", obj);
}
19
Source : MudProvider.cs
with GNU Lesser General Public License v3.0
from 8720826
with GNU Lesser General Public License v3.0
from 8720826
public async Task ShowMe(int playerId, object obj)
{
await _context.Clients.User(playerId.ToString()).SendAsync("ShowMe", obj);
}
19
Source : MudProvider.cs
with GNU Lesser General Public License v3.0
from 8720826
with GNU Lesser General Public License v3.0
from 8720826
public async Task ShowWare(int playerId, object obj)
{
await _context.Clients.User(playerId.ToString()).SendAsync("ShowWare", obj);
}
19
Source : MudProvider.cs
with GNU Lesser General Public License v3.0
from 8720826
with GNU Lesser General Public License v3.0
from 8720826
public async Task RemoveEmail(int playerId, int playerEmailId)
{
await _context.Clients.User(playerId.ToString()).SendAsync("RemoveEmail", playerEmailId);
}
19
Source : MudProvider.cs
with GNU Lesser General Public License v3.0
from 8720826
with GNU Lesser General Public License v3.0
from 8720826
public async Task ShowActionPoint(int playerId, object obj)
{
await _context.Clients.User(playerId.ToString()).SendAsync("ShowActionPoint", obj);
}
19
Source : PointCloudToMeshComponentFull.cs
with GNU Lesser General Public License v3.0
from 9and3
with GNU Lesser General Public License v3.0
from 9and3
protected override void SolveInstance(IGH_DataAccess DA) {
int Downsample = 5000;
int NormalsNeighbours = 100;
bool debug = false;
int maximumDeptOfReconstructionSurfaceTree = 8;
int targetWidthOfTheFinestLevelOctree = 0;
double ratioBetweenReconCubeAndBBCubeStd = 1.1;
bool ReconstructorUsingLinearInterpolation = false;
DA.GetData(1, ref Downsample);
DA.GetData(2, ref NormalsNeighbours);
DA.GetData(3, ref debug);
DA.GetData(4, ref maximumDeptOfReconstructionSurfaceTree);
DA.GetData(5, ref targetWidthOfTheFinestLevelOctree);
DA.GetData(6, ref ratioBetweenReconCubeAndBBCubeStd);
DA.GetData(7, ref ReconstructorUsingLinearInterpolation);
//Guid to PointCloud
//PointCloud c = new PointCloud();
PointCloudGH c = new PointCloudGH();
string debugInfo = debug ? "1" : "0";
if (DA.GetData(0, ref c)) {
if (!c.IsValid) return;
if (c.Value.Count==0) return;
Downsample = Math.Min(Downsample, c.Value.Count);
// var watch = System.Diagnostics.Stopwatch.StartNew();
// the code that you want to measure comes here
/////////////////////////////////////////////////////////////////
//Get Directory
/////////////////////////////////////////////////////////////////
string replacedemblyLocation = System.Reflection.replacedembly.GetExecutingreplacedembly().Location;
string replacedemblyPath = System.IO.Path.GetDirectoryName(replacedemblyLocation);
/////////////////////////////////////////////////////////////////
//write PointCloud to PLY
/////////////////////////////////////////////////////////////////
PlyReaderWriter.PlyWriter.SavePLY(c.Value, replacedemblyPath + @"\in.ply");
//Rhino.RhinoApp.WriteLine("PointCloudToMesh. Saved Input: " + replacedemblyPath + @"\in.ply");
//watch.Stop();
//Rhino.RhinoApp.WriteLine((watch.ElapsedMilliseconds / 1000.0).ToString());
/////////////////////////////////////////////////////////////////
//Ply to Mesh to Obj
/////////////////////////////////////////////////////////////////
//watch = System.Diagnostics.Stopwatch.StartNew();
//tring argument = replacedemblyPath + "TestVisualizer.exe " + "-1 " + "100";//--asci
string argument = " "+Downsample.ToString()+ " " + NormalsNeighbours.ToString() + " " + debugInfo + " " + maximumDeptOfReconstructionSurfaceTree.ToString() + " " + targetWidthOfTheFinestLevelOctree.ToString() + " " + ratioBetweenReconCubeAndBBCubeStd.ToString() + " " + Convert.ToInt32(ReconstructorUsingLinearInterpolation).ToString();
//--asci
// Rhino.RhinoApp.WriteLine("PointCloudToMesh. Arguments: " + argument );
// Rhino.RhinoApp.WriteLine("PointCloudToMesh. Directory: " + replacedemblyPath + @"\TestVisualizer.exe");
if (debug) {
var proc = new System.Diagnostics.Process {
StartInfo = new System.Diagnostics.ProcessStartInfo {
FileName = replacedemblyPath + @"\TestVisualizer.exe",//filePath+"PoissonRecon.exe",
Arguments = argument,
//UseShellExecute = false,
//RedirectStandardOutput = true,
CreateNoWindow = false,
// WindowStyle = System.Diagnostics.ProcessWindowStyle.Hidden,
WorkingDirectory = replacedemblyPath + @"\TestVisualizer.exe"
}
};
proc.Start();
proc.WaitForExit();
} else {
var proc = new System.Diagnostics.Process {
StartInfo = new System.Diagnostics.ProcessStartInfo {
FileName = replacedemblyPath + @"\TestVisualizer.exe",//filePath+"PoissonRecon.exe",
Arguments = argument,
//UseShellExecute = false,
//RedirectStandardOutput = true,
CreateNoWindow = true,
WindowStyle = System.Diagnostics.ProcessWindowStyle.Hidden,
WorkingDirectory = replacedemblyPath + @"\TestVisualizer.exe"
}
};
proc.Start();
proc.WaitForExit();
}
// watch.Stop();
//Rhino.RhinoApp.WriteLine((watch.ElapsedMilliseconds / 1000.0).ToString());
/////////////////////////////////////////////////////////////////
//Read Obj
/////////////////////////////////////////////////////////////////
///
//Outputs
// watch = System.Diagnostics.Stopwatch.StartNew();
// Initialize
var obj = new ObjParser.Obj();
// Read Wavefront OBJ file
//obj.LoadObj(@"C:\libs\windows\out.obj");
//PlyReaderWriter.PlyLoader plyLoader = new PlyReaderWriter.PlyLoader();
//Mesh mesh3D = plyLoader.load(replacedemblyPath + @"\out.ply")[0];
//Rhino.RhinoApp.WriteLine(replacedemblyPath + @"\windows\out.obj");
obj.LoadObj(replacedemblyPath + @"\out.obj");
Mesh mesh3D = new Mesh();
foreach (ObjParser.Types.Vertex v in obj.VertexList) {
mesh3D.Vertices.Add(new Point3d(v.X, v.Y, v.Z));
mesh3D.VertexColors.Add(System.Drawing.Color.FromArgb((int)(v.r * 255), (int)(v.g * 255), (int)(v.b * 255) ));
}
int num = checked(mesh3D.Vertices.Count - 1);
foreach (ObjParser.Types.Face f in obj.FaceList) {
string[] lineData = f.ToString().Split(' ');
string[] v0 = lineData[1].Split('/');
string[] v1 = lineData[2].Split('/');
string[] v2 = lineData[3].Split('/');
MeshFace mf3D = new MeshFace(Convert.ToInt32(v0[0]) - 1, Convert.ToInt32(v1[0]) - 1, Convert.ToInt32(v2[0]) - 1);
if (mf3D.IsValid())
if (!(mf3D.A > num || mf3D.B > num || mf3D.C > num || mf3D.D > num))
mesh3D.Faces.AddFace(mf3D);
}
DA.SetData(0, mesh3D);
/////////////////////////////////////////////////////////////////
//Output Iso Values
/////////////////////////////////////////////////////////////////
string[] lines = System.IO.File.ReadAllLines(replacedemblyPath + @"\out.txt");
double[] iso = new double[lines.Length];
for (int i = 0; i < lines.Length; i++) {
iso[i] = Convert.ToDouble(lines[i]);
}
//watch.Stop();
//Rhino.RhinoApp.WriteLine((watch.ElapsedMilliseconds/1000.0).ToString());
DA.SetDataList(1, iso);
}
}
19
Source : HashEncode.cs
with Apache License 2.0
from 91270
with Apache License 2.0
from 91270
public static string GetRandomValue()
{
Random Seed = new Random();
string RandomVaule = Seed.Next(1, int.MaxValue).ToString();
return RandomVaule;
}
19
Source : PointCloudToMeshComponent.cs
with GNU Lesser General Public License v3.0
from 9and3
with GNU Lesser General Public License v3.0
from 9and3
protected override void SolveInstance(IGH_DataAccess DA) {
int Downsample = 5000;
int NormalsNeighbours = 100;
bool debug = false;
DA.GetData(1, ref Downsample);
DA.GetData(2, ref NormalsNeighbours);
DA.GetData(3, ref debug);
//Guid to PointCloud
//PointCloud c = new PointCloud();
PointCloudGH c = new PointCloudGH();
string debugInfo = debug ? "1" : "0";
if (DA.GetData(0, ref c)) {
if (!c.IsValid) return;
if (c.Value.Count == 0) return;
Downsample = Math.Min(Downsample, c.Value.Count);
// var watch = System.Diagnostics.Stopwatch.StartNew();
// the code that you want to measure comes here
/////////////////////////////////////////////////////////////////
//Get Directory
/////////////////////////////////////////////////////////////////
string replacedemblyLocation = System.Reflection.replacedembly.GetExecutingreplacedembly().Location;
string replacedemblyPath = System.IO.Path.GetDirectoryName(replacedemblyLocation);
/////////////////////////////////////////////////////////////////
//write PointCloud to PLY
/////////////////////////////////////////////////////////////////
PlyReaderWriter.PlyWriter.SavePLY(c.Value, replacedemblyPath + @"\in.ply");
//Rhino.RhinoApp.WriteLine("PointCloudToMesh. Saved Input: " + replacedemblyPath + @"\in.ply");
//watch.Stop();
//Rhino.RhinoApp.WriteLine((watch.ElapsedMilliseconds / 1000.0).ToString());
/////////////////////////////////////////////////////////////////
//Ply to Mesh to Obj
/////////////////////////////////////////////////////////////////
//watch = System.Diagnostics.Stopwatch.StartNew();
//tring argument = replacedemblyPath + "TestVisualizer.exe " + "-1 " + "100";//--asci
string argument = " "+Downsample.ToString()+ " " + NormalsNeighbours.ToString() + " " + debugInfo + " 8 0 1.1 0";//--asci
// Rhino.RhinoApp.WriteLine("PointCloudToMesh. Arguments: " + argument );
//int maximumDeptOfReconstructionSurfaceTree = atoi(argv[4]);//8
//int targetWidthOfTheFinestLevelOctree = atoi(argv[5]);//0
//float ratioBetweenReconCubeAndBBCubeStd = atof(argv[6]); // 1.1
//bool ReconstructorUsingLinearInterpolation = atoi(argv[7]) == 1;//0
// Rhino.RhinoApp.WriteLine("PointCloudToMesh. Directory: " + replacedemblyPath + @"\TestVisualizer.exe");
if (debug) {
var proc = new System.Diagnostics.Process {
StartInfo = new System.Diagnostics.ProcessStartInfo {
FileName = replacedemblyPath + @"\TestVisualizer.exe",//filePath+"PoissonRecon.exe",
Arguments = argument,
//UseShellExecute = false,
//RedirectStandardOutput = true,
CreateNoWindow = false,
// WindowStyle = System.Diagnostics.ProcessWindowStyle.Hidden,
WorkingDirectory = replacedemblyPath + @"\TestVisualizer.exe"
}
};
proc.Start();
proc.WaitForExit();
} else {
var proc = new System.Diagnostics.Process {
StartInfo = new System.Diagnostics.ProcessStartInfo {
FileName = replacedemblyPath + @"\TestVisualizer.exe",//filePath+"PoissonRecon.exe",
Arguments = argument,
//UseShellExecute = false,
//RedirectStandardOutput = true,
CreateNoWindow = true,
WindowStyle = System.Diagnostics.ProcessWindowStyle.Hidden,
WorkingDirectory = replacedemblyPath + @"\TestVisualizer.exe"
}
};
proc.Start();
proc.WaitForExit();
}
// watch.Stop();
//Rhino.RhinoApp.WriteLine((watch.ElapsedMilliseconds / 1000.0).ToString());
/////////////////////////////////////////////////////////////////
//Read Obj
/////////////////////////////////////////////////////////////////
///
//Outputs
// watch = System.Diagnostics.Stopwatch.StartNew();
// Initialize
var obj = new ObjParser.Obj();
// Read Wavefront OBJ file
//obj.LoadObj(@"C:\libs\windows\out.obj");
//PlyReaderWriter.PlyLoader plyLoader = new PlyReaderWriter.PlyLoader();
//Mesh mesh3D = plyLoader.load(replacedemblyPath + @"\out.ply")[0];
//Rhino.RhinoApp.WriteLine(replacedemblyPath + @"\windows\out.obj");
obj.LoadObj(replacedemblyPath + @"\out.obj");
Mesh mesh3D = new Mesh();
foreach (ObjParser.Types.Vertex v in obj.VertexList) {
mesh3D.Vertices.Add(new Point3d(v.X, v.Y, v.Z));
mesh3D.VertexColors.Add(System.Drawing.Color.FromArgb((int)(v.r * 255), (int)(v.g * 255), (int)(v.b * 255) ));
}
int num = checked(mesh3D.Vertices.Count - 1);
foreach (ObjParser.Types.Face f in obj.FaceList) {
string[] lineData = f.ToString().Split(' ');
string[] v0 = lineData[1].Split('/');
string[] v1 = lineData[2].Split('/');
string[] v2 = lineData[3].Split('/');
MeshFace mf3D = new MeshFace(Convert.ToInt32(v0[0]) - 1, Convert.ToInt32(v1[0]) - 1, Convert.ToInt32(v2[0]) - 1);
if (mf3D.IsValid())
if (!(mf3D.A > num || mf3D.B > num || mf3D.C > num || mf3D.D > num))
mesh3D.Faces.AddFace(mf3D);
}
DA.SetData(0, mesh3D);
/////////////////////////////////////////////////////////////////
//Output Iso Values
/////////////////////////////////////////////////////////////////
string[] lines = System.IO.File.ReadAllLines(replacedemblyPath + @"\out.txt");
double[] iso = new double[lines.Length];
for (int i = 0; i < lines.Length; i++) {
iso[i] = Convert.ToDouble(lines[i]);
}
//watch.Stop();
//Rhino.RhinoApp.WriteLine((watch.ElapsedMilliseconds/1000.0).ToString());
DA.SetDataList(1, iso);
}
}
19
Source : MudProvider.cs
with GNU Lesser General Public License v3.0
from 8720826
with GNU Lesser General Public License v3.0
from 8720826
public async Task UpdatePlayerRoomNpcList(int playerId, object obj)
{
await _context.Clients.User(playerId.ToString()).SendAsync(ClientMethod.UpdateNpcList, obj);
}
19
Source : MudProvider.cs
with GNU Lesser General Public License v3.0
from 8720826
with GNU Lesser General Public License v3.0
from 8720826
public async Task UpdatePlayerRoomPlayerList(int playerId, object obj)
{
await _context.Clients.User(playerId.ToString()).SendAsync(ClientMethod.UpdatePlayerList, obj);
}
19
Source : MudProvider.cs
with GNU Lesser General Public License v3.0
from 8720826
with GNU Lesser General Public License v3.0
from 8720826
public async Task RefreshKillInfo(int playerId, object obj)
{
await _context.Clients.User(playerId.ToString()).SendAsync("refreshKillInfo", obj);
}
19
Source : MudProvider.cs
with GNU Lesser General Public License v3.0
from 8720826
with GNU Lesser General Public License v3.0
from 8720826
public async Task ShowQuest(int playerId, object obj)
{
await _context.Clients.User(playerId.ToString()).SendAsync("ShowQuest", obj);
}
19
Source : MudProvider.cs
with GNU Lesser General Public License v3.0
from 8720826
with GNU Lesser General Public License v3.0
from 8720826
public async Task LoadWare(int playerId, object obj)
{
await _context.Clients.User(playerId.ToString()).SendAsync("LoadWare", obj);
}
19
Source : MudProvider.cs
with GNU Lesser General Public License v3.0
from 8720826
with GNU Lesser General Public License v3.0
from 8720826
public async Task DropWare(int playerId, object obj)
{
await _context.Clients.User(playerId.ToString()).SendAsync("DropWare", obj);
}
19
Source : MudProvider.cs
with GNU Lesser General Public License v3.0
from 8720826
with GNU Lesser General Public License v3.0
from 8720826
public async Task ShowEmailDetail(int playerId, object obj)
{
await _context.Clients.User(playerId.ToString()).SendAsync("ShowEmailDetail", obj);
}
19
Source : MudProvider.cs
with GNU Lesser General Public License v3.0
from 8720826
with GNU Lesser General Public License v3.0
from 8720826
public async Task ShowRemainingTime(int playerId, object obj)
{
await _context.Clients.User(playerId.ToString()).SendAsync("ShowRemainingTime", obj);
}
19
Source : MudProvider.cs
with GNU Lesser General Public License v3.0
from 8720826
with GNU Lesser General Public License v3.0
from 8720826
public async Task ShowStoreWare(int playerId, object obj)
{
await _context.Clients.User(playerId.ToString()).SendAsync("ShowStoreWare", obj);
}
19
Source : MudProvider.cs
with GNU Lesser General Public License v3.0
from 8720826
with GNU Lesser General Public License v3.0
from 8720826
public async Task SetDefaultSkill(int playerId, object obj)
{
await _context.Clients.User(playerId.ToString()).SendAsync("SetDefaultSkill", obj);
}
19
Source : SecondToStringConverter.cs
with MIT License
from 944095635
with MIT License
from 944095635
public object Convert(object value, Type targetType, object parameter, CultureInfo culture)
{
if (value is int offset)
{
var absOffset = Math.Abs(offset);
var hour = ((absOffset / 3600)).ToString();
var minute = ((absOffset - ((absOffset / 3600) * 3600)) / 60).ToString();
var second = ((absOffset - ((absOffset / 3600) * 3600)) % 60).ToString();
return $"{(offset >= 0 ? "" : "-")}{hour.PadLeft(2, '0')}:{minute.PadLeft(2, '0')}:{second.PadLeft(2, '0')}";
}
return value;
}
19
Source : ZUART.cs
with MIT License
from a2633063
with MIT License
from a2633063
private void init()
{
#region 控件初始化
btnSend.Enabled = false;
cbbComList.Items.AddRange(SerialPort.GetPortNames());
ListSendButton[0] = ListSend_Send0;
ListSendTextBox[0] = ListSend_Text0;
ListSendCheckBox[0] = ListSend_Hex0;
for (int i = 1; i < ListSend_Count; i++)
{
#region 增加Button
ListSendButton[i] = new Button();
ListSendButton[i].Left = ListSendButton[0].Left;
ListSendButton[i].Size = ListSendButton[0].Size;
ListSendButton[i].Text = (i + 1).ToString();
ListSendButton[i].Top = ListSendButton[i - 1].Top + ListSendButton[0].Height + 1;
ListSendButton[i].Click += ListSendButton_Click;
ListSendButton[i].TabStop = ListSendButton[0].TabStop;
ListSendButton[i].TabIndex = i;
ListSendButton[i].Anchor = ListSendButton[0].Anchor;
panel_ListSend.Controls.Add(ListSendButton[i]);
#endregion
#region 增加TextBox
ListSendTextBox[i] = new TextBox();
ListSendTextBox[i].Left = ListSendTextBox[0].Left;
ListSendTextBox[i].Size = ListSendTextBox[0].Size;
ListSendTextBox[i].Top = ListSendButton[i - 1].Top + ListSendButton[0].Height + 1;
ListSendTextBox[i].TabStop = ListSendTextBox[0].TabStop;
ListSendTextBox[i].Anchor = ListSendTextBox[0].Anchor;
panel_ListSend.Controls.Add(ListSendTextBox[i]);
#endregion
#region 增加CheckBox
ListSendCheckBox[i] = new CheckBox();
ListSendCheckBox[i].Left = ListSendCheckBox[0].Left;
ListSendCheckBox[i].Size = ListSendCheckBox[0].Size;
ListSendCheckBox[i].Text = ListSendCheckBox[0].Text;
ListSendCheckBox[i].Top = ListSendButton[i - 1].Top + ListSendButton[0].Height + 5;
ListSendCheckBox[i].TabStop = ListSendCheckBox[0].TabStop;
ListSendCheckBox[i].Anchor = ListSendCheckBox[0].Anchor;
panel_ListSend.Controls.Add(ListSendCheckBox[i]);
#endregion
toolTip1.SetToolTip(ListSendCheckBox[i], toolTip1.GetToolTip(ListSendCheckBox[0]));
}
#endregion
#region 设置保存初始化
cbbComList.DataBindings.Add(new System.Windows.Forms.Binding("Text", global::ZUART.Properties.Settings.Default, "cbbComList", true, System.Windows.Forms.DataSourceUpdateMode.OnPropertyChanged));
cbbBaudRate.DataBindings.Add(new System.Windows.Forms.Binding("Text", global::ZUART.Properties.Settings.Default, "cbbBaudRate", true, System.Windows.Forms.DataSourceUpdateMode.OnPropertyChanged));
cbbDataBits.DataBindings.Add(new System.Windows.Forms.Binding("Text", global::ZUART.Properties.Settings.Default, "cbbDataBits", true, System.Windows.Forms.DataSourceUpdateMode.OnPropertyChanged));
cbbStopBits.DataBindings.Add(new System.Windows.Forms.Binding("Text", global::ZUART.Properties.Settings.Default, "cbbStopBits", true, System.Windows.Forms.DataSourceUpdateMode.OnPropertyChanged));
cbbParity.DataBindings.Add(new System.Windows.Forms.Binding("Text", global::ZUART.Properties.Settings.Default, "cbbParity", true, System.Windows.Forms.DataSourceUpdateMode.OnPropertyChanged));
txtSendData.DataBindings.Add(new System.Windows.Forms.Binding("Text", global::ZUART.Properties.Settings.Default, "txtSendData", true, System.Windows.Forms.DataSourceUpdateMode.OnPropertyChanged));
txtAutoSendms.DataBindings.Add(new System.Windows.Forms.Binding("Text", global::ZUART.Properties.Settings.Default, "txtAutoSendms", true, System.Windows.Forms.DataSourceUpdateMode.OnPropertyChanged));
chkAutoLine.DataBindings.Add(new System.Windows.Forms.Binding("Checked", global::ZUART.Properties.Settings.Default, "chkAutoLine", true, System.Windows.Forms.DataSourceUpdateMode.OnPropertyChanged));
chkShowTime.DataBindings.Add(new System.Windows.Forms.Binding("Checked", global::ZUART.Properties.Settings.Default, "chkShowTime", true, System.Windows.Forms.DataSourceUpdateMode.OnPropertyChanged));
chkRecSend.DataBindings.Add(new System.Windows.Forms.Binding("Checked", global::ZUART.Properties.Settings.Default, "chkRecSend", true, System.Windows.Forms.DataSourceUpdateMode.OnPropertyChanged));
chkfromFileSend.DataBindings.Add(new System.Windows.Forms.Binding("Checked", global::ZUART.Properties.Settings.Default, "chkfromFileSend", true, System.Windows.Forms.DataSourceUpdateMode.OnPropertyChanged));
chkAutoAddSend.DataBindings.Add(new System.Windows.Forms.Binding("Checked", global::ZUART.Properties.Settings.Default, "chkAutoAddSend", true, System.Windows.Forms.DataSourceUpdateMode.OnPropertyChanged));
chkAutoCleanSend.DataBindings.Add(new System.Windows.Forms.Binding("Checked", global::ZUART.Properties.Settings.Default, "chkAutoCleanSend", true, System.Windows.Forms.DataSourceUpdateMode.OnPropertyChanged));
chkAutoSend.DataBindings.Add(new System.Windows.Forms.Binding("Checked", global::ZUART.Properties.Settings.Default, "chkAutoSend", true, System.Windows.Forms.DataSourceUpdateMode.OnPropertyChanged));
rbtnHex.DataBindings.Add(new System.Windows.Forms.Binding("Checked", global::ZUART.Properties.Settings.Default, "rbtnHex", true, System.Windows.Forms.DataSourceUpdateMode.OnPropertyChanged));
rbtnASCII.DataBindings.Add(new System.Windows.Forms.Binding("Checked", global::ZUART.Properties.Settings.Default, "rbtnASCII", true, System.Windows.Forms.DataSourceUpdateMode.OnPropertyChanged));
rbtnUTF8.DataBindings.Add(new System.Windows.Forms.Binding("Checked", global::ZUART.Properties.Settings.Default, "rbtnUTF8", true, System.Windows.Forms.DataSourceUpdateMode.OnPropertyChanged));
rbtnUnicode.DataBindings.Add(new System.Windows.Forms.Binding("Checked", global::ZUART.Properties.Settings.Default, "rbtnUnicode", true, System.Windows.Forms.DataSourceUpdateMode.OnPropertyChanged));
rbtnSendHex.DataBindings.Add(new System.Windows.Forms.Binding("Checked", global::ZUART.Properties.Settings.Default, "rbtnSendHex", true, System.Windows.Forms.DataSourceUpdateMode.OnPropertyChanged));
rbtnSendASCII.DataBindings.Add(new System.Windows.Forms.Binding("Checked", global::ZUART.Properties.Settings.Default, "rbtnSendASCII", true, System.Windows.Forms.DataSourceUpdateMode.OnPropertyChanged));
rbtnSendUTF8.DataBindings.Add(new System.Windows.Forms.Binding("Checked", global::ZUART.Properties.Settings.Default, "rbtnSendUTF8", true, System.Windows.Forms.DataSourceUpdateMode.OnPropertyChanged));
rbtnSendUnicode.DataBindings.Add(new System.Windows.Forms.Binding("Checked", global::ZUART.Properties.Settings.Default, "rbtnSendUnicode", true, System.Windows.Forms.DataSourceUpdateMode.OnPropertyChanged));
for (int i = 0; i < ListSend_Count; i++)
{
ListSendTextBox[i].DataBindings.Add(new System.Windows.Forms.Binding("Text", global::ZUART.Properties.Settings.Default, "ListSend_Text" + i, true, System.Windows.Forms.DataSourceUpdateMode.OnPropertyChanged));
ListSendCheckBox[i].DataBindings.Add(new System.Windows.Forms.Binding("Checked", global::ZUART.Properties.Settings.Default, "ListSend_Hex" + i, true, System.Windows.Forms.DataSourceUpdateMode.OnPropertyChanged));
}
#endregion
}
19
Source : OtherBehaviour.cs
with GNU General Public License v3.0
from a2659802
with GNU General Public License v3.0
from a2659802
[Handle(Operation.SetGate)]
public void HandleGateNumber(int num)
{
if (numDisp != null)
{
numDisp.GetComponent<TextMeshPro>().text = num.ToString();
}
int gateNum = ((ItemDef.LeverGateItem)item).Number;
var gateName = $"{ItemDef.LeverGateItem.GateNamePrefix}{gateNum}";
gameObject.name = gateName;
}
19
Source : OtherBehaviour.cs
with GNU General Public License v3.0
from a2659802
with GNU General Public License v3.0
from a2659802
[Handle(Operation.SetGate)]
public void HandleGateNumber(int num)
{
if (numDisp != null)
{
numDisp.GetComponent<TextMeshPro>().text = num.ToString();
}
int gateNum = ((ItemDef.LeverGateItem)item).Number;
var gateName = $"{ItemDef.LeverGateItem.GateNamePrefix}{gateNum}";
playMakerFSM = gameObject.LocateMyFSM("toll switch");
playMakerFSM.GetAction<FindGameObject>("Initiate", 2).objectName = gateName;
}
19
Source : RPGCharacterControllerFREE.cs
with Apache License 2.0
from A7ocin
with Apache License 2.0
from A7ocin
public void Attack(int attackSide){
if(canAction){
if(weapon == Weapon.UNARMED){
int maxAttacks = 3;
int attackNumber = 0;
if(attackSide == 1 || attackSide == 3){
attackNumber = Random.Range(3, maxAttacks);
}
else if(attackSide == 2){
attackNumber = Random.Range(6, maxAttacks + 3);
}
if(isGrounded){
if(attackSide != 3){
animator.SetTrigger("Attack" + (attackNumber).ToString() + "Trigger");
if(leftWeapon == 12 || leftWeapon == 14 || rightWeapon == 13 || rightWeapon == 15){
StartCoroutine(_LockMovementAndAttack(0, .75f));
}
else{
StartCoroutine(_LockMovementAndAttack(0, .6f));
}
}
else{
animator.SetTrigger("AttackDual" + (attackNumber).ToString() + "Trigger");
StartCoroutine(_LockMovementAndAttack(0, .75f));
}
}
}
//2 handed weapons
else{
if(isGrounded){
animator.SetTrigger("Attack" + (6).ToString() + "Trigger");
StartCoroutine(_LockMovementAndAttack(0, .85f));
}
}
}
}
19
Source : RPGCharacterControllerFREE.cs
with Apache License 2.0
from A7ocin
with Apache License 2.0
from A7ocin
public void CastAttack(int attackSide){
if(weapon == Weapon.UNARMED){
int maxAttacks = 3;
if(attackSide == 1){
int attackNumber = Random.Range(0, maxAttacks);
if(isGrounded){
animator.SetTrigger("CastAttack" + (attackNumber + 1).ToString() + "Trigger");
StartCoroutine(_LockMovementAndAttack(0, .8f));
}
}
if(attackSide == 2){
int attackNumber = Random.Range(3, maxAttacks + 3);
if(isGrounded){
animator.SetTrigger("CastAttack" + (attackNumber + 1).ToString() + "Trigger");
StartCoroutine(_LockMovementAndAttack(0, .8f));
}
}
if(attackSide == 3){
int attackNumber = Random.Range(0, maxAttacks);
if(isGrounded){
animator.SetTrigger("CastDualAttack" + (attackNumber + 1).ToString() + "Trigger");
StartCoroutine(_LockMovementAndAttack(0, 1f));
}
}
}
}
19
Source : RPGCharacterControllerFREE.cs
with Apache License 2.0
from A7ocin
with Apache License 2.0
from A7ocin
public void GetHit(){
int hits = 5;
int hitNumber = Random.Range(0, hits);
animator.SetTrigger("GetHit" + (hitNumber + 1).ToString() + "Trigger");
StartCoroutine(_LockMovementAndAttack(.1f, .4f));
//apply directional knockback force
if(hitNumber <= 1){
StartCoroutine(_Knockback(-transform.forward, 8, 4));
}
else if(hitNumber == 2){
StartCoroutine(_Knockback(transform.forward, 8, 4));
}
else if(hitNumber == 3){
StartCoroutine(_Knockback(transform.right, 8, 4));
}
else if(hitNumber == 4){
StartCoroutine(_Knockback(-transform.right, 8, 4));
}
}
19
Source : UMAAvatarLoadSaveMenuItems.cs
with Apache License 2.0
from A7ocin
with Apache License 2.0
from A7ocin
[MenuItem("UMA/Runtime/Save Selected Avatars generated textures to PNG")]
public static void SaveSelectedAvatarsPNG()
{
if (!Application.isPlaying)
{
EditorUtility.DisplayDialog("Notice", "This function is only available at runtime", "Got it");
return;
}
if (Selection.gameObjects.Length != 1)
{
EditorUtility.DisplayDialog("Notice", "Only one Avatar can be selected.", "OK");
return;
}
var selectedTransform = Selection.gameObjects[0].transform;
var avatar = selectedTransform.GetComponent<UMAAvatarBase>();
if (avatar == null)
{
EditorUtility.DisplayDialog("Notice", "An Avatar must be selected to use this function", "OK");
return;
}
SkinnedMeshRenderer smr = avatar.gameObject.GetComponentInChildren<SkinnedMeshRenderer>();
if (smr == null)
{
EditorUtility.DisplayDialog("Warning", "Could not find SkinnedMeshRenderer in Avatar hierarchy", "OK");
return;
}
string path = EditorUtility.SaveFilePanelInProject("Save Texture(s)", "Texture.png", "png", "Base Filename to save PNG files to.");
if (!string.IsNullOrEmpty(path))
{
string basename = System.IO.Path.GetFileNameWithoutExtension(path);
string pathname = System.IO.Path.GetDirectoryName(path);
// save the diffuse texture
for (int i = 0; i < smr.materials.Length; i++)
{
string PathBase = System.IO.Path.Combine(pathname, basename + "_material_" + i.ToString());
string DiffuseName = PathBase + "_Diffuse.PNG";
SaveTexture(smr.materials[i].GetTexture("_MainTex"), DiffuseName);
}
}
}
19
Source : TennisAgent.cs
with Apache License 2.0
from A7ocin
with Apache License 2.0
from A7ocin
public override void AgentStep(float[] act)
{
int action = Mathf.FloorToInt(act[0]);
float moveX = 0.0f;
float moveY = 0.0f;
if (action == 0)
{
moveX = invertMult * -0.25f;
}
if (action == 1)
{
moveX = invertMult * 0.25f;
}
if (action == 2 && gameObject.transform.position.y + transform.parent.transform.position.y < -1.5f)
{
moveY = 0.5f;
gameObject.GetComponent<Rigidbody>().velocity = new Vector3(GetComponent<Rigidbody>().velocity.x, moveY * 12f, 0f);
}
if (action == 3)
{
GetComponent<Rigidbody>().velocity = new Vector3(GetComponent<Rigidbody>().velocity.x * 0.5f, GetComponent<Rigidbody>().velocity.y, 0f);
moveY = 0f;
moveX = 0f;
}
gameObject.GetComponent<Rigidbody>().velocity = new Vector3(moveX * 50f, GetComponent<Rigidbody>().velocity.y, 0f);
if (invertX)
{
if (gameObject.transform.position.x + transform.parent.transform.position.x < -(invertMult) * 1f)
{
gameObject.transform.position = new Vector3(-(invertMult) * 1f + transform.parent.transform.position.x, gameObject.transform.position.y, gameObject.transform.position.z);
}
}
else
{
if (gameObject.transform.position.x + transform.parent.transform.position.x > -(invertMult) * 1f)
{
gameObject.transform.position = new Vector3(-(invertMult) * 1f + transform.parent.transform.position.x, gameObject.transform.position.y, gameObject.transform.position.z);
}
}
scoreText.GetComponent<Text>().text = score.ToString();
}
19
Source : ReadPagedTests.cs
with Apache License 2.0
from aadreja
with Apache License 2.0
from aadreja
[Fact]
public void NoQueryNoOffsetMultipleOrderByWithCriteriaTest()
{
Repository<City> cityRepo = new Repository<City>(Fixture.Connection);
cityRepo.DropTable();
cityRepo.CreateTable();
int counter = 1000;
for (int i = 1; i <= counter; i++)
{
City city = new City()
{
Name = "PagedNoCriteriaTest." + i.ToString().PadLeft(5, '0'),
State = i % 5 == 0 ? "RC" : "DC",
CountryId = i % 2 == 0 ? 1 : 2,
Longitude = 1m,
Lareplacedude = 1m,
CreatedBy =Fixture.CurrentUserId
};
city.Id = (long)cityRepo.Add(city);
}
var parameters = new { state = "DC" };
//order by country ASC, name ASC
//First Page
List<City> cityList = cityRepo.ReadAllPaged("countryid,name", 50, PageNavigationEnum.First, null, null, null, parameters).ToList();
replacedert.Equal(50, cityList.Count);
replacedert.Equal(1, cityList[0].CountryId);
replacedert.Equal("PagedNoCriteriaTest.00002", cityList[0].Name);
replacedert.Equal("PagedNoCriteriaTest.00124", cityList[49].Name);
//Next Page
cityList = cityRepo.ReadAllPaged("countryid,name", 50, PageNavigationEnum.Next, null, new object[] { cityList[49].CountryId, cityList[49].Name }, cityList[49].Id, parameters).ToList();
replacedert.Equal(50, cityList.Count);
replacedert.Equal(1, cityList[0].CountryId);
replacedert.Equal("PagedNoCriteriaTest.00126", cityList[0].Name);
replacedert.Equal("PagedNoCriteriaTest.00248", cityList[49].Name);
//Last Page
cityList = cityRepo.ReadAllPaged("countryid,name", 50, PageNavigationEnum.Last, null, null, null, parameters).ToList();
replacedert.Equal(50, cityList.Count);
replacedert.Equal(2, cityList[0].CountryId);
replacedert.Equal("PagedNoCriteriaTest.00877", cityList[0].Name);
replacedert.Equal("PagedNoCriteriaTest.00999", cityList[49].Name);
//Previous Page
cityList = cityRepo.ReadAllPaged("countryid,name", 50, PageNavigationEnum.Previous, null, new object[] { cityList[0].CountryId, cityList[0].Name }, cityList[0].Id, parameters).ToList();
replacedert.Equal(50, cityList.Count);
replacedert.Equal(2, cityList[0].CountryId);
replacedert.Equal("PagedNoCriteriaTest.00751", cityList[0].Name);
replacedert.Equal("PagedNoCriteriaTest.00873", cityList[49].Name);
//order by countryid desc, name asc
//First Page
cityList = cityRepo.ReadAllPaged("countryid desc, name", 50, PageNavigationEnum.First, null, null, null, parameters).ToList();
replacedert.Equal(50, cityList.Count);
replacedert.Equal(2, cityList[0].CountryId);
replacedert.Equal("PagedNoCriteriaTest.00001", cityList[0].Name);
replacedert.Equal("PagedNoCriteriaTest.00123", cityList[49].Name);
//Next Page
cityList = cityRepo.ReadAllPaged("countryid desc,name", 50, PageNavigationEnum.Next, null, new object[] { cityList[49].CountryId, cityList[49].Name }, cityList[49].Id, parameters).ToList();
replacedert.Equal(50, cityList.Count);
replacedert.Equal(2, cityList[0].CountryId);
replacedert.Equal("PagedNoCriteriaTest.00127", cityList[0].Name);
replacedert.Equal("PagedNoCriteriaTest.00249", cityList[49].Name);
//Last Page
cityList = cityRepo.ReadAllPaged("countryid desc,name", 50, PageNavigationEnum.Last, null, null, null, parameters).ToList();
replacedert.Equal(50, cityList.Count);
replacedert.Equal(1, cityList[0].CountryId);
replacedert.Equal("PagedNoCriteriaTest.00876", cityList[0].Name);
replacedert.Equal("PagedNoCriteriaTest.00998", cityList[49].Name);
//Previous Page
cityList = cityRepo.ReadAllPaged("countryid desc,name", 50, PageNavigationEnum.Previous, null, new object[] { cityList[0].CountryId, cityList[0].Name }, cityList[0].Id, parameters).ToList();
replacedert.Equal(50, cityList.Count);
replacedert.Equal(1, cityList[0].CountryId);
replacedert.Equal("PagedNoCriteriaTest.00752", cityList[0].Name);
replacedert.Equal("PagedNoCriteriaTest.00874", cityList[49].Name);
}
19
Source : ReadPagedTests.cs
with Apache License 2.0
from aadreja
with Apache License 2.0
from aadreja
[Fact]
public void NoQueryNoOffsetWithCriteriaTest()
{
Repository<City> cityRepo = new Repository<City>(Fixture.Connection);
cityRepo.DropTable();
cityRepo.CreateTable();
int counter = 1000;
for (int i = 1; i <= counter; i++)
{
City city = new City()
{
Name = "PagedNoCriteriaTest." + i.ToString().PadLeft(5, '0'),
State = i % 2 == 0 ? "RC" : "DC",
CountryId = 1,
Longitude = 1m,
Lareplacedude = 1m,
CreatedBy =Fixture.CurrentUserId
};
city.Id = (long)cityRepo.Add(city);
}
var parameters = new { state = "RC" };
//order by ASC
//First Page
List<City> cityList = cityRepo.ReadAllPaged("name", 50, PageNavigationEnum.First, null, null, null, parameters).ToList();
replacedert.Equal(50, cityList.Count);
replacedert.Equal("PagedNoCriteriaTest.00002", cityList[0].Name);
replacedert.Equal("PagedNoCriteriaTest.00100", cityList[49].Name);
//Next Page
cityList = cityRepo.ReadAllPaged("name", 50, PageNavigationEnum.Next, null, new[] { cityList[49].Name }, cityList[49].Id, parameters).ToList();
replacedert.Equal(50, cityList.Count);
replacedert.Equal("PagedNoCriteriaTest.00102", cityList[0].Name);
replacedert.Equal("PagedNoCriteriaTest.00200", cityList[49].Name);
//Last Page
cityList = cityRepo.ReadAllPaged("name", 50, PageNavigationEnum.Last, null, null, null, parameters).ToList();
replacedert.Equal(50, cityList.Count);
replacedert.Equal("PagedNoCriteriaTest.00902", cityList[0].Name);
replacedert.Equal("PagedNoCriteriaTest.01000", cityList[49].Name);
//Previous Page
cityList = cityRepo.ReadAllPaged("name", 50, PageNavigationEnum.Previous, null, new[] { cityList[0].Name }, cityList[0].Id, parameters).ToList();
replacedert.Equal(50, cityList.Count);
replacedert.Equal("PagedNoCriteriaTest.00802", cityList[0].Name);
replacedert.Equal("PagedNoCriteriaTest.00900", cityList[49].Name);
//order by desc
//First Page
cityList = cityRepo.ReadAllPaged("name desc", 50, PageNavigationEnum.First, null, null, null, parameters).ToList();
replacedert.Equal(50, cityList.Count);
replacedert.Equal("PagedNoCriteriaTest.01000", cityList[0].Name);
replacedert.Equal("PagedNoCriteriaTest.00902", cityList[49].Name);
//Next Page
cityList = cityRepo.ReadAllPaged("name desc", 50, PageNavigationEnum.Next, null, new[] { cityList[49].Name }, cityList[49].Id, parameters).ToList();
replacedert.Equal(50, cityList.Count);
replacedert.Equal("PagedNoCriteriaTest.00900", cityList[0].Name);
replacedert.Equal("PagedNoCriteriaTest.00802", cityList[49].Name);
//Last Page
cityList = cityRepo.ReadAllPaged("name desc", 50, PageNavigationEnum.Last, null, null, null, parameters).ToList();
replacedert.Equal(50, cityList.Count);
replacedert.Equal("PagedNoCriteriaTest.00100", cityList[0].Name);
replacedert.Equal("PagedNoCriteriaTest.00002", cityList[49].Name);
//Previous Page
cityList = cityRepo.ReadAllPaged("name desc", 50, PageNavigationEnum.Previous, null, new[] { cityList[0].Name }, cityList[0].Id, parameters).ToList();
replacedert.Equal(50, cityList.Count);
replacedert.Equal("PagedNoCriteriaTest.00200", cityList[0].Name);
replacedert.Equal("PagedNoCriteriaTest.00102", cityList[49].Name);
}
19
Source : ReadPagedTests.cs
with Apache License 2.0
from aadreja
with Apache License 2.0
from aadreja
[Fact]
public void NoQueryNoOffsetMultipleOrderByNoCriteriaTest()
{
Repository<City> cityRepo = new Repository<City>(Fixture.Connection);
cityRepo.DropTable();
cityRepo.CreateTable();
int counter = 1000;
for (int i = 1; i <= counter; i++)
{
City city = new City()
{
Name = "PagedNoCriteriaTest." + i.ToString().PadLeft(5, '0'),
State = i % 2 == 0 ? "RC" : "DC",
CountryId = i % 2 == 0 ? 1 : 2,
Longitude = 1m,
Lareplacedude = 1m,
CreatedBy =Fixture.CurrentUserId
};
city.Id = (long)cityRepo.Add(city);
}
//order by country ASC, name ASC
//First Page
List<City> cityList = cityRepo.ReadAllPaged("countryid,name", 50, PageNavigationEnum.First).ToList();
replacedert.Equal(50, cityList.Count);
replacedert.Equal(1, cityList[0].CountryId);
replacedert.Equal("PagedNoCriteriaTest.00002", cityList[0].Name);
replacedert.Equal("PagedNoCriteriaTest.00100", cityList[49].Name);
//Next Page
cityList = cityRepo.ReadAllPaged("countryid,name", 50, PageNavigationEnum.Next, "*", new object[] { cityList[49].CountryId, cityList[49].Name }, cityList[49].Id).ToList();
replacedert.Equal(50, cityList.Count);
replacedert.Equal(1, cityList[0].CountryId);
replacedert.Equal("PagedNoCriteriaTest.00102", cityList[0].Name);
replacedert.Equal("PagedNoCriteriaTest.00200", cityList[49].Name);
//Last Page
cityList = cityRepo.ReadAllPaged("countryid,name", 50, PageNavigationEnum.Last).ToList();
replacedert.Equal(50, cityList.Count);
replacedert.Equal(2, cityList[0].CountryId);
replacedert.Equal("PagedNoCriteriaTest.00901", cityList[0].Name);
replacedert.Equal("PagedNoCriteriaTest.00999", cityList[49].Name);
//Previous Page
cityList = cityRepo.ReadAllPaged("countryid,name", 50, PageNavigationEnum.Previous, "*", new object[] { cityList[0].CountryId, cityList[0].Name }, cityList[0].Id).ToList();
replacedert.Equal(50, cityList.Count);
replacedert.Equal(2, cityList[0].CountryId);
replacedert.Equal("PagedNoCriteriaTest.00801", cityList[0].Name);
replacedert.Equal("PagedNoCriteriaTest.00899", cityList[49].Name);
//order by countryid desc, name asc
//First Page
cityList = cityRepo.ReadAllPaged("countryid desc, name", 50, PageNavigationEnum.First).ToList();
replacedert.Equal(50, cityList.Count);
replacedert.Equal(2, cityList[0].CountryId);
replacedert.Equal("PagedNoCriteriaTest.00001", cityList[0].Name);
replacedert.Equal("PagedNoCriteriaTest.00099", cityList[49].Name);
//Next Page
cityList = cityRepo.ReadAllPaged("countryid desc,name", 50, PageNavigationEnum.Next, "*", new object[] { cityList[49].CountryId, cityList[49].Name }, cityList[49].Id).ToList();
replacedert.Equal(50, cityList.Count);
replacedert.Equal(2, cityList[0].CountryId);
replacedert.Equal("PagedNoCriteriaTest.00101", cityList[0].Name);
replacedert.Equal("PagedNoCriteriaTest.00199", cityList[49].Name);
//Last Page
cityList = cityRepo.ReadAllPaged("countryid desc,name", 50, PageNavigationEnum.Last).ToList();
replacedert.Equal(50, cityList.Count);
replacedert.Equal(1, cityList[0].CountryId);
replacedert.Equal("PagedNoCriteriaTest.00902", cityList[0].Name);
replacedert.Equal("PagedNoCriteriaTest.01000", cityList[49].Name);
//Previous Page
cityList = cityRepo.ReadAllPaged("countryid desc,name", 50, PageNavigationEnum.Previous, "*", new object[] { cityList[0].CountryId, cityList[0].Name }, cityList[0].Id).ToList();
replacedert.Equal(50, cityList.Count);
replacedert.Equal(1, cityList[0].CountryId);
replacedert.Equal("PagedNoCriteriaTest.00802", cityList[0].Name);
replacedert.Equal("PagedNoCriteriaTest.00900", cityList[49].Name);
}
19
Source : ReadPagedTests.cs
with Apache License 2.0
from aadreja
with Apache License 2.0
from aadreja
[Fact]
public void NoQueryNoOffsetNoCriteriaTest()
{
Repository<City> cityRepo = new Repository<City>(Fixture.Connection);
cityRepo.DropTable();
cityRepo.CreateTable();
int counter = 1000;
for (int i = 1; i <= counter; i++)
{
City city = new City()
{
Name = "PagedNoCriteriaTest." + i.ToString().PadLeft(5, '0'),
State = "RC",
CountryId = 1,
Longitude = 1m,
Lareplacedude = 1m,
CreatedBy =Fixture.CurrentUserId
};
city.Id = (long)cityRepo.Add(city);
}
//order by ASC
//First Page
List<City> cityList = cityRepo.ReadAllPaged("name", 50, PageNavigationEnum.First).ToList();
replacedert.Equal(50, cityList.Count);
replacedert.Equal("PagedNoCriteriaTest.00001", cityList[0].Name);
replacedert.Equal("PagedNoCriteriaTest.00050", cityList[49].Name);
//Next Page
cityList = cityRepo.ReadAllPaged("name", 50, PageNavigationEnum.Next, "*", new[] { cityList[49].Name }, cityList[49].Id).ToList();
replacedert.Equal(50, cityList.Count);
replacedert.Equal("PagedNoCriteriaTest.00051", cityList[0].Name);
replacedert.Equal("PagedNoCriteriaTest.00100", cityList[49].Name);
//Last Page
cityList = cityRepo.ReadAllPaged("name", 50, PageNavigationEnum.Last).ToList();
replacedert.Equal(50, cityList.Count);
replacedert.Equal("PagedNoCriteriaTest.00951", cityList[0].Name);
replacedert.Equal("PagedNoCriteriaTest.01000", cityList[49].Name);
//Previous Page
cityList = cityRepo.ReadAllPaged("name", 50, PageNavigationEnum.Previous, "*", new[] { cityList[0].Name }, cityList[0].Id).ToList();
replacedert.Equal(50, cityList.Count);
replacedert.Equal("PagedNoCriteriaTest.00901", cityList[0].Name);
replacedert.Equal("PagedNoCriteriaTest.00950", cityList[49].Name);
//order by desc
//First Page
cityList = cityRepo.ReadAllPaged("name desc", 50, PageNavigationEnum.First).ToList();
replacedert.Equal(50, cityList.Count);
replacedert.Equal("PagedNoCriteriaTest.01000", cityList[0].Name);
replacedert.Equal("PagedNoCriteriaTest.00951", cityList[49].Name);
//Next Page
cityList = cityRepo.ReadAllPaged("name desc", 50, PageNavigationEnum.Next, "*", new[] { cityList[49].Name }, cityList[49].Id).ToList();
replacedert.Equal(50, cityList.Count);
replacedert.Equal("PagedNoCriteriaTest.00950", cityList[0].Name);
replacedert.Equal("PagedNoCriteriaTest.00901", cityList[49].Name);
//Last Page
cityList = cityRepo.ReadAllPaged("name desc", 50, PageNavigationEnum.Last).ToList();
replacedert.Equal(50, cityList.Count);
replacedert.Equal("PagedNoCriteriaTest.00050", cityList[0].Name);
replacedert.Equal("PagedNoCriteriaTest.00001", cityList[49].Name);
//Previous Page
cityList = cityRepo.ReadAllPaged("name desc", 50, PageNavigationEnum.Previous, "*", new[] { cityList[0].Name }, cityList[0].Id).ToList();
replacedert.Equal(50, cityList.Count);
replacedert.Equal("PagedNoCriteriaTest.00100", cityList[0].Name);
replacedert.Equal("PagedNoCriteriaTest.00051", cityList[49].Name);
}
19
Source : ReadPagedTests.cs
with Apache License 2.0
from aadreja
with Apache License 2.0
from aadreja
[Fact]
public void WithQueryNoOffsetMultipleOrderByWithCriteriaTest()
{
Repository<City> cityRepo = new Repository<City>(Fixture.Connection);
cityRepo.DropTable();
cityRepo.CreateTable();
int counter = 1000;
for (int i = 1; i <= counter; i++)
{
City city = new City()
{
Name = "PagedNoCriteriaTest." + i.ToString().PadLeft(5, '0'),
State = i % 5 == 0 ? "RC" : "DC",
CountryId = i % 2 == 0 ? 1 : 2,
Longitude = 1m,
Lareplacedude = 1m,
CreatedBy =Fixture.CurrentUserId
};
city.Id = (long)cityRepo.Add(city);
}
var parameters = new { state = "DC" };
//order by country ASC, name ASC
//First Page
List<City> cityList = cityRepo.ReadAllPaged("SELECT * FROM city WHERE state=@state", "countryid,name", 50, PageNavigationEnum.First,null, null, parameters).ToList();
replacedert.Equal(50, cityList.Count);
replacedert.Equal(1, cityList[0].CountryId);
replacedert.Equal("PagedNoCriteriaTest.00002", cityList[0].Name);
replacedert.Equal("PagedNoCriteriaTest.00124", cityList[49].Name);
//Next Page
cityList = cityRepo.ReadAllPaged("SELECT * FROM city WHERE state=@state", "countryid,name", 50, PageNavigationEnum.Next, new object[] { cityList[49].CountryId, cityList[49].Name }, cityList[49].Id, parameters).ToList();
replacedert.Equal(50, cityList.Count);
replacedert.Equal(1, cityList[0].CountryId);
replacedert.Equal("PagedNoCriteriaTest.00126", cityList[0].Name);
replacedert.Equal("PagedNoCriteriaTest.00248", cityList[49].Name);
//Last Page
cityList = cityRepo.ReadAllPaged("SELECT * FROM city WHERE state=@state", "countryid,name", 50, PageNavigationEnum.Last, null, null, parameters).ToList();
replacedert.Equal(50, cityList.Count);
replacedert.Equal(2, cityList[0].CountryId);
replacedert.Equal("PagedNoCriteriaTest.00877", cityList[0].Name);
replacedert.Equal("PagedNoCriteriaTest.00999", cityList[49].Name);
//Previous Page
cityList = cityRepo.ReadAllPaged("SELECT * FROM city WHERE state=@state", "countryid,name", 50, PageNavigationEnum.Previous, new object[] { cityList[0].CountryId, cityList[0].Name }, cityList[0].Id, parameters).ToList();
replacedert.Equal(50, cityList.Count);
replacedert.Equal(2, cityList[0].CountryId);
replacedert.Equal("PagedNoCriteriaTest.00751", cityList[0].Name);
replacedert.Equal("PagedNoCriteriaTest.00873", cityList[49].Name);
//order by countryid desc, name asc
//First Page
cityList = cityRepo.ReadAllPaged("SELECT * FROM city WHERE state=@state", "countryid desc, name", 50, PageNavigationEnum.First, null, null, parameters).ToList();
replacedert.Equal(50, cityList.Count);
replacedert.Equal(2, cityList[0].CountryId);
replacedert.Equal("PagedNoCriteriaTest.00001", cityList[0].Name);
replacedert.Equal("PagedNoCriteriaTest.00123", cityList[49].Name);
//Next Page
cityList = cityRepo.ReadAllPaged("SELECT * FROM city WHERE state=@state", "countryid desc,name", 50, PageNavigationEnum.Next, new object[] { cityList[49].CountryId, cityList[49].Name }, cityList[49].Id, parameters).ToList();
replacedert.Equal(50, cityList.Count);
replacedert.Equal(2, cityList[0].CountryId);
replacedert.Equal("PagedNoCriteriaTest.00127", cityList[0].Name);
replacedert.Equal("PagedNoCriteriaTest.00249", cityList[49].Name);
//Last Page
cityList = cityRepo.ReadAllPaged("SELECT * FROM city WHERE state=@state", "countryid desc,name", 50, PageNavigationEnum.Last, null, null, parameters).ToList();
replacedert.Equal(50, cityList.Count);
replacedert.Equal(1, cityList[0].CountryId);
replacedert.Equal("PagedNoCriteriaTest.00876", cityList[0].Name);
replacedert.Equal("PagedNoCriteriaTest.00998", cityList[49].Name);
//Previous Page
cityList = cityRepo.ReadAllPaged("SELECT * FROM city WHERE state=@state", "countryid desc,name", 50, PageNavigationEnum.Previous, new object[] { cityList[0].CountryId, cityList[0].Name }, cityList[0].Id, parameters).ToList();
replacedert.Equal(50, cityList.Count);
replacedert.Equal(1, cityList[0].CountryId);
replacedert.Equal("PagedNoCriteriaTest.00752", cityList[0].Name);
replacedert.Equal("PagedNoCriteriaTest.00874", cityList[49].Name);
}
19
Source : ReadPagedTests.cs
with Apache License 2.0
from aadreja
with Apache License 2.0
from aadreja
[Fact]
public void WithQueryNoOffsetWithCriteriaTest()
{
Repository<City> cityRepo = new Repository<City>(Fixture.Connection);
cityRepo.DropTable();
cityRepo.CreateTable();
int counter = 1000;
for (int i = 1; i <= counter; i++)
{
City city = new City()
{
Name = "PagedNoCriteriaTest." + i.ToString().PadLeft(5, '0'),
State = i % 2 == 0 ? "RC" : "DC",
CountryId = 1,
Longitude = 1m,
Lareplacedude = 1m,
CreatedBy =Fixture.CurrentUserId
};
city.Id = (long)cityRepo.Add(city);
}
var parameters = new { state = "RC" };
//order by ASC
//First Page
List<City> cityList = cityRepo.ReadAllPaged("SELECT * FROM city WHERE state=@state", "name", 50, PageNavigationEnum.First, null, null, parameters).ToList();
replacedert.Equal(50, cityList.Count);
replacedert.Equal("PagedNoCriteriaTest.00002", cityList[0].Name);
replacedert.Equal("PagedNoCriteriaTest.00100", cityList[49].Name);
//Next Page
cityList = cityRepo.ReadAllPaged("SELECT * FROM city WHERE state=@state", "name", 50, PageNavigationEnum.Next, new[] { cityList[49].Name }, cityList[49].Id, parameters).ToList();
replacedert.Equal(50, cityList.Count);
replacedert.Equal("PagedNoCriteriaTest.00102", cityList[0].Name);
replacedert.Equal("PagedNoCriteriaTest.00200", cityList[49].Name);
//Last Page
cityList = cityRepo.ReadAllPaged("SELECT * FROM city WHERE state=@state", "name", 50, PageNavigationEnum.Last, null, null, parameters).ToList();
replacedert.Equal(50, cityList.Count);
replacedert.Equal("PagedNoCriteriaTest.00902", cityList[0].Name);
replacedert.Equal("PagedNoCriteriaTest.01000", cityList[49].Name);
//Previous Page
cityList = cityRepo.ReadAllPaged("SELECT * FROM city WHERE state=@state", "name", 50, PageNavigationEnum.Previous, new[] { cityList[0].Name }, cityList[0].Id, parameters).ToList();
replacedert.Equal(50, cityList.Count);
replacedert.Equal("PagedNoCriteriaTest.00802", cityList[0].Name);
replacedert.Equal("PagedNoCriteriaTest.00900", cityList[49].Name);
//order by desc
//First Page
cityList = cityRepo.ReadAllPaged("SELECT * FROM city WHERE state=@state", "name desc", 50, PageNavigationEnum.First, null, null, parameters).ToList();
replacedert.Equal(50, cityList.Count);
replacedert.Equal("PagedNoCriteriaTest.01000", cityList[0].Name);
replacedert.Equal("PagedNoCriteriaTest.00902", cityList[49].Name);
//Next Page
cityList = cityRepo.ReadAllPaged("SELECT * FROM city WHERE state=@state", "name desc", 50, PageNavigationEnum.Next, new[] { cityList[49].Name }, cityList[49].Id, parameters).ToList();
replacedert.Equal(50, cityList.Count);
replacedert.Equal("PagedNoCriteriaTest.00900", cityList[0].Name);
replacedert.Equal("PagedNoCriteriaTest.00802", cityList[49].Name);
//Last Page
cityList = cityRepo.ReadAllPaged("SELECT * FROM city WHERE state=@state", "name desc", 50, PageNavigationEnum.Last, null, null, parameters).ToList();
replacedert.Equal(50, cityList.Count);
replacedert.Equal("PagedNoCriteriaTest.00100", cityList[0].Name);
replacedert.Equal("PagedNoCriteriaTest.00002", cityList[49].Name);
//Previous Page
cityList = cityRepo.ReadAllPaged("SELECT * FROM city WHERE state=@state", "name desc", 50, PageNavigationEnum.Previous, new[] { cityList[0].Name }, cityList[0].Id, parameters).ToList();
replacedert.Equal(50, cityList.Count);
replacedert.Equal("PagedNoCriteriaTest.00200", cityList[0].Name);
replacedert.Equal("PagedNoCriteriaTest.00102", cityList[49].Name);
}
19
Source : ReadPagedTests.cs
with Apache License 2.0
from aadreja
with Apache License 2.0
from aadreja
[Fact]
public void WithQueryNoOffsetMultipleOrderByNoCriteriaTest()
{
Repository<City> cityRepo = new Repository<City>(Fixture.Connection);
cityRepo.DropTable();
cityRepo.CreateTable();
int counter = 1000;
for (int i = 1; i <= counter; i++)
{
City city = new City()
{
Name = "PagedNoCriteriaTest." + i.ToString().PadLeft(5, '0'),
State = i % 2 == 0 ? "RC" : "DC",
CountryId = i % 2 == 0 ? 1 : 2,
Longitude = 1m,
Lareplacedude = 1m,
CreatedBy =Fixture.CurrentUserId
};
city.Id = (long)cityRepo.Add(city);
}
//order by country ASC, name ASC
//First Page
List<City> cityList = cityRepo.ReadAllPaged("SELECT * FROM city", "countryid,name", 50, PageNavigationEnum.First).ToList();
replacedert.Equal(50, cityList.Count);
replacedert.Equal(1, cityList[0].CountryId);
replacedert.Equal("PagedNoCriteriaTest.00002", cityList[0].Name);
replacedert.Equal("PagedNoCriteriaTest.00100", cityList[49].Name);
//Next Page
cityList = cityRepo.ReadAllPaged("SELECT * FROM city", "countryid,name", 50, PageNavigationEnum.Next, new object[] { cityList[49].CountryId, cityList[49].Name }, cityList[49].Id).ToList();
replacedert.Equal(50, cityList.Count);
replacedert.Equal(1, cityList[0].CountryId);
replacedert.Equal("PagedNoCriteriaTest.00102", cityList[0].Name);
replacedert.Equal("PagedNoCriteriaTest.00200", cityList[49].Name);
//Last Page
cityList = cityRepo.ReadAllPaged("SELECT * FROM city", "countryid,name", 50, PageNavigationEnum.Last).ToList();
replacedert.Equal(50, cityList.Count);
replacedert.Equal(2, cityList[0].CountryId);
replacedert.Equal("PagedNoCriteriaTest.00901", cityList[0].Name);
replacedert.Equal("PagedNoCriteriaTest.00999", cityList[49].Name);
//Previous Page
cityList = cityRepo.ReadAllPaged("SELECT * FROM city", "countryid,name", 50, PageNavigationEnum.Previous, new object[] { cityList[0].CountryId, cityList[0].Name }, cityList[0].Id).ToList();
replacedert.Equal(50, cityList.Count);
replacedert.Equal(2, cityList[0].CountryId);
replacedert.Equal("PagedNoCriteriaTest.00801", cityList[0].Name);
replacedert.Equal("PagedNoCriteriaTest.00899", cityList[49].Name);
//order by countryid desc, name asc
//First Page
cityList = cityRepo.ReadAllPaged("SELECT * FROM city", "countryid desc, name", 50, PageNavigationEnum.First).ToList();
replacedert.Equal(50, cityList.Count);
replacedert.Equal(2, cityList[0].CountryId);
replacedert.Equal("PagedNoCriteriaTest.00001", cityList[0].Name);
replacedert.Equal("PagedNoCriteriaTest.00099", cityList[49].Name);
//Next Page
cityList = cityRepo.ReadAllPaged("SELECT * FROM city", "countryid desc,name", 50, PageNavigationEnum.Next, new object[] { cityList[49].CountryId, cityList[49].Name }, cityList[49].Id).ToList();
replacedert.Equal(50, cityList.Count);
replacedert.Equal(2, cityList[0].CountryId);
replacedert.Equal("PagedNoCriteriaTest.00101", cityList[0].Name);
replacedert.Equal("PagedNoCriteriaTest.00199", cityList[49].Name);
//Last Page
cityList = cityRepo.ReadAllPaged("SELECT * FROM city", "countryid desc,name", 50, PageNavigationEnum.Last).ToList();
replacedert.Equal(50, cityList.Count);
replacedert.Equal(1, cityList[0].CountryId);
replacedert.Equal("PagedNoCriteriaTest.00902", cityList[0].Name);
replacedert.Equal("PagedNoCriteriaTest.01000", cityList[49].Name);
//Previous Page
cityList = cityRepo.ReadAllPaged("SELECT * FROM city", "countryid desc,name", 50, PageNavigationEnum.Previous, new object[] { cityList[0].CountryId, cityList[0].Name }, cityList[0].Id).ToList();
replacedert.Equal(50, cityList.Count);
replacedert.Equal(1, cityList[0].CountryId);
replacedert.Equal("PagedNoCriteriaTest.00802", cityList[0].Name);
replacedert.Equal("PagedNoCriteriaTest.00900", cityList[49].Name);
}
19
Source : ReadPagedTests.cs
with Apache License 2.0
from aadreja
with Apache License 2.0
from aadreja
[Fact]
public void WithQueryNoOffsetNoCriteriaTest()
{
Repository<City> cityRepo = new Repository<City>(Fixture.Connection);
cityRepo.DropTable();
cityRepo.CreateTable();
int counter = 1000;
for (int i = 1; i <= counter; i++)
{
City city = new City()
{
Name = "PagedNoCriteriaTest." + i.ToString().PadLeft(5, '0'),
State = "RC",
CountryId = 1,
Longitude = 1m,
Lareplacedude = 1m,
CreatedBy =Fixture.CurrentUserId
};
city.Id = (long)cityRepo.Add(city);
}
//order by ASC
//First Page
List<City> cityList = cityRepo.ReadAllPaged("SELECT * FROM city", "name", 50, PageNavigationEnum.First).ToList();
replacedert.Equal(50, cityList.Count);
replacedert.Equal("PagedNoCriteriaTest.00001", cityList[0].Name);
replacedert.Equal("PagedNoCriteriaTest.00050", cityList[49].Name);
//Next Page
cityList = cityRepo.ReadAllPaged("SELECT * FROM city", "name", 50, PageNavigationEnum.Next, new[] { cityList[49].Name }, cityList[49].Id).ToList();
replacedert.Equal(50, cityList.Count);
replacedert.Equal("PagedNoCriteriaTest.00051", cityList[0].Name);
replacedert.Equal("PagedNoCriteriaTest.00100", cityList[49].Name);
//Last Page
cityList = cityRepo.ReadAllPaged("SELECT * FROM city", "name", 50, PageNavigationEnum.Last).ToList();
replacedert.Equal(50, cityList.Count);
replacedert.Equal("PagedNoCriteriaTest.00951", cityList[0].Name);
replacedert.Equal("PagedNoCriteriaTest.01000", cityList[49].Name);
//Previous Page
cityList = cityRepo.ReadAllPaged("SELECT * FROM city", "name", 50, PageNavigationEnum.Previous, new[] { cityList[0].Name }, cityList[0].Id).ToList();
replacedert.Equal(50, cityList.Count);
replacedert.Equal("PagedNoCriteriaTest.00901", cityList[0].Name);
replacedert.Equal("PagedNoCriteriaTest.00950", cityList[49].Name);
//order by desc
//First Page
cityList = cityRepo.ReadAllPaged("SELECT * FROM city", "name desc", 50, PageNavigationEnum.First).ToList();
replacedert.Equal(50, cityList.Count);
replacedert.Equal("PagedNoCriteriaTest.01000", cityList[0].Name);
replacedert.Equal("PagedNoCriteriaTest.00951", cityList[49].Name);
//Next Page
cityList = cityRepo.ReadAllPaged("SELECT * FROM city", "name desc", 50, PageNavigationEnum.Next, new[] { cityList[49].Name }, cityList[49].Id).ToList();
replacedert.Equal(50, cityList.Count);
replacedert.Equal("PagedNoCriteriaTest.00950", cityList[0].Name);
replacedert.Equal("PagedNoCriteriaTest.00901", cityList[49].Name);
//Last Page
cityList = cityRepo.ReadAllPaged("SELECT * FROM city", "name desc", 50, PageNavigationEnum.Last).ToList();
replacedert.Equal(50, cityList.Count);
replacedert.Equal("PagedNoCriteriaTest.00050", cityList[0].Name);
replacedert.Equal("PagedNoCriteriaTest.00001", cityList[49].Name);
//Previous Page
cityList = cityRepo.ReadAllPaged("SELECT * FROM city", "name desc", 50, PageNavigationEnum.Previous, new[] { cityList[0].Name }, cityList[0].Id).ToList();
replacedert.Equal(50, cityList.Count);
replacedert.Equal("PagedNoCriteriaTest.00100", cityList[0].Name);
replacedert.Equal("PagedNoCriteriaTest.00051", cityList[49].Name);
}
19
Source : ReadPagedTests.cs
with Apache License 2.0
from aadreja
with Apache License 2.0
from aadreja
[Fact]
public void NoQueryNoCriteriaTest()
{
Repository<City> cityRepo = new Repository<City>(Fixture.Connection);
cityRepo.DropTable();
cityRepo.CreateTable();
int counter = 100;
for (int i = 1; i <= counter; i++)
{
City city = new City()
{
Name = "PagedNoCriteriaTest." + i.ToString().PadLeft(4, '0'),
State = "RC",
CountryId = 1,
Longitude = 1m,
Lareplacedude = 1m,
CreatedBy =Fixture.CurrentUserId
};
city.Id = (long)cityRepo.Add(city);
}
List<City> cityList = cityRepo.ReadAllPaged("name", 1, 10).ToList();
replacedert.Equal(10, cityList.Count);
replacedert.Equal("PagedNoCriteriaTest.0001", cityList[0].Name);
replacedert.Equal("PagedNoCriteriaTest.0010", cityList[9].Name);
cityList = cityRepo.ReadAllPaged("name", 5, 10).ToList();
replacedert.Equal(10, cityList.Count);
replacedert.Equal("PagedNoCriteriaTest.0041", cityList[0].Name);
replacedert.Equal("PagedNoCriteriaTest.0050", cityList[9].Name);
}
19
Source : ReadPagedTests.cs
with Apache License 2.0
from aadreja
with Apache License 2.0
from aadreja
[Fact]
public void NoQueryWithCriteriaTest()
{
Repository<City> cityRepo = new Repository<City>(Fixture.Connection);
cityRepo.DropTable();
cityRepo.CreateTable();
int counter = 100;
for (int i = 1; i <= counter; i++)
{
City city = new City()
{
Name = "PagedNoCriteriaTest." + i.ToString().PadLeft(4, '0'),
State = (i % 2 == 0 ? "RC" : "DC"),
CountryId = 1,
Longitude = 1m,
Lareplacedude = 1m,
CreatedBy =Fixture.CurrentUserId
};
city.Id = (long)cityRepo.Add(city);
}
List<City> cityList = cityRepo.ReadAllPaged("name", 1, 10, null, new { state = "DC" }).ToList();
replacedert.Equal(10, cityList.Count);
replacedert.Equal("PagedNoCriteriaTest.0001", cityList[0].Name);
replacedert.Equal("PagedNoCriteriaTest.0019", cityList[9].Name);
cityList = cityRepo.ReadAllPaged("name", 5, 10, null, new { state = "RC" }).ToList();
replacedert.Equal(10, cityList.Count);
replacedert.Equal("PagedNoCriteriaTest.0082", cityList[0].Name);
replacedert.Equal("PagedNoCriteriaTest.0100", cityList[9].Name);
}
19
Source : ReadPagedTests.cs
with Apache License 2.0
from aadreja
with Apache License 2.0
from aadreja
[Fact]
public void WithQueryNoCriteriaTest()
{
Repository<City> cityRepo = new Repository<City>(Fixture.Connection);
cityRepo.DropTable();
cityRepo.CreateTable();
int counter = 100;
for (int i = 1; i <= counter; i++)
{
City city = new City()
{
Name = "PagedNoCriteriaTest." + i.ToString().PadLeft(4,'0'),
State = "RC",
CountryId = 1,
Longitude = 1m,
Lareplacedude = 1m,
CreatedBy =Fixture.CurrentUserId
};
city.Id = (long)cityRepo.Add(city);
}
List<City> cityList = cityRepo.ReadAllPaged("SELECT * FROM city", "name", 1, 10).ToList();
replacedert.Equal(10, cityList.Count);
replacedert.Equal("PagedNoCriteriaTest.0001", cityList[0].Name);
replacedert.Equal("PagedNoCriteriaTest.0010", cityList[9].Name);
cityList = cityRepo.ReadAllPaged("SELECT * FROM city", "name", 5, 10).ToList();
replacedert.Equal(10, cityList.Count);
replacedert.Equal("PagedNoCriteriaTest.0041", cityList[0].Name);
replacedert.Equal("PagedNoCriteriaTest.0050", cityList[9].Name);
}
19
Source : ReadPagedTests.cs
with Apache License 2.0
from aadreja
with Apache License 2.0
from aadreja
[Fact]
public void WithQueryWithCriteriaTest()
{
Repository<City> cityRepo = new Repository<City>(Fixture.Connection);
cityRepo.DropTable();
cityRepo.CreateTable();
int counter = 100;
for (int i = 1; i <= counter; i++)
{
City city = new City()
{
Name = "PagedNoCriteriaTest." + i.ToString().PadLeft(4, '0'),
State = (i % 2 == 0 ? "RC" : "DC"),
CountryId = 1,
Longitude = 1m,
Lareplacedude = 1m,
CreatedBy =Fixture.CurrentUserId
};
city.Id = (long)cityRepo.Add(city);
}
List<City> cityList = cityRepo.ReadAllPaged("SELECT * FROM city WHERE state=@state", "name", 1, 10, new { state = "DC" }).ToList();
replacedert.Equal(10, cityList.Count);
replacedert.Equal("PagedNoCriteriaTest.0001", cityList[0].Name);
replacedert.Equal("PagedNoCriteriaTest.0019", cityList[9].Name);
cityList = cityRepo.ReadAllPaged("SELECT * FROM city WHERE state=@state", "name", 5, 10, new { state = "RC" }).ToList();
replacedert.Equal(10, cityList.Count);
replacedert.Equal("PagedNoCriteriaTest.0082", cityList[0].Name);
replacedert.Equal("PagedNoCriteriaTest.0100", cityList[9].Name);
}
19
Source : ReadPagedTests.cs
with Apache License 2.0
from aadreja
with Apache License 2.0
from aadreja
[Fact]
public void NoQueryNoOffsetMultipleOrderByWithCriteriaTestCompositePrimaryKey()
{
Repository<Address> addRepo = new Repository<Address>(Fixture.Connection);
addRepo.DropTable();
addRepo.CreateTable();
int counter = 1000;
for (int i = 1; i <= counter; i++)
{
Address city = new Address()
{
AddressLine1 = "Line1PagedNoCriteriaTest." + i.ToString().PadLeft(5, '0'),
AddressLine2 = "Line2PagedNoCriteriaTest." + i.ToString().PadLeft(5, '0'),
AddressType = i % 5 == 0 ? "HOME" : "OFFICE",
CustomerCode = i % 2 == 0 ? "P0001" : "P0002",
Town = "Ahmedabad",
};
city.Id = (long)addRepo.Add(city);
}
var parameters = new { AddressType = "OFFICE" };
//order by country ASC, name ASC
//First Page
List<Address> addList = addRepo.ReadAllPaged("customercode,addressline1", 50, PageNavigationEnum.First, "*", null, null, parameters).ToList();
replacedert.Equal(50, addList.Count);
replacedert.Equal("P0001", addList[0].CustomerCode);
replacedert.Equal("Line1PagedNoCriteriaTest.00002", addList[0].AddressLine1);
replacedert.Equal("Line1PagedNoCriteriaTest.00124", addList[49].AddressLine1);
//Next Page
addList = addRepo.ReadAllPaged("customercode,addressline1", 50, PageNavigationEnum.Next, "*", new object[] { addList[49].CustomerCode, addList[49].AddressLine1 }, new Address() { Id= addList[49].Id, AddressType="HOME" }, parameters).ToList();
replacedert.Equal(50, addList.Count);
replacedert.Equal("P0001", addList[0].CustomerCode);
replacedert.Equal("Line1PagedNoCriteriaTest.00126", addList[0].AddressLine1);
replacedert.Equal("Line1PagedNoCriteriaTest.00248", addList[49].AddressLine1);
//Last Page
addList = addRepo.ReadAllPaged("customercode,addressline1", 50, PageNavigationEnum.Last, "*", null, null, parameters).ToList();
replacedert.Equal(50, addList.Count);
replacedert.Equal("P0002", addList[0].CustomerCode);
replacedert.Equal("Line1PagedNoCriteriaTest.00877", addList[0].AddressLine1);
replacedert.Equal("Line1PagedNoCriteriaTest.00999", addList[49].AddressLine1);
//Previous Page
addList = addRepo.ReadAllPaged("customercode,addressline1", 50, PageNavigationEnum.Previous, "*", new object[] { addList[0].CustomerCode, addList[0].AddressLine1 }, new Address() { Id = addList[0].Id, AddressType = "HOME" }, parameters).ToList();
replacedert.Equal(50, addList.Count);
replacedert.Equal("P0002", addList[0].CustomerCode);
replacedert.Equal("Line1PagedNoCriteriaTest.00751", addList[0].AddressLine1);
replacedert.Equal("Line1PagedNoCriteriaTest.00873", addList[49].AddressLine1);
//order by countryid desc, name asc
//First Page
addList = addRepo.ReadAllPaged("customercode desc,addressline1", 50, PageNavigationEnum.First, "*", null, null, parameters).ToList();
replacedert.Equal(50, addList.Count);
replacedert.Equal("P0002", addList[0].CustomerCode);
replacedert.Equal("Line1PagedNoCriteriaTest.00001", addList[0].AddressLine1);
replacedert.Equal("Line1PagedNoCriteriaTest.00123", addList[49].AddressLine1);
//Next Page
addList = addRepo.ReadAllPaged("customercode desc,addressline1", 50, PageNavigationEnum.Next, "*", new object[] { addList[49].CustomerCode, addList[49].AddressLine1 }, new Address() { Id = addList[49].Id, AddressType="HOME" }, parameters).ToList();
replacedert.Equal(50, addList.Count);
replacedert.Equal("P0002", addList[0].CustomerCode);
replacedert.Equal("Line1PagedNoCriteriaTest.00127", addList[0].AddressLine1);
replacedert.Equal("Line1PagedNoCriteriaTest.00249", addList[49].AddressLine1);
//Last Page
addList = addRepo.ReadAllPaged("customercode desc,addressline1", 50, PageNavigationEnum.Last, "*", null, null, parameters).ToList();
replacedert.Equal(50, addList.Count);
replacedert.Equal("P0001", addList[0].CustomerCode);
replacedert.Equal("Line1PagedNoCriteriaTest.00876", addList[0].AddressLine1);
replacedert.Equal("Line1PagedNoCriteriaTest.00998", addList[49].AddressLine1);
//Previous Page
addList = addRepo.ReadAllPaged("customercode desc,addressline1", 50, PageNavigationEnum.Previous, "*", new object[] { addList[0].CustomerCode, addList[0].AddressLine1 }, new Address() { Id = addList[0].Id, AddressType = "HOME" }, parameters).ToList();
replacedert.Equal(50, addList.Count);
replacedert.Equal("P0001", addList[0].CustomerCode);
replacedert.Equal("Line1PagedNoCriteriaTest.00752", addList[0].AddressLine1);
replacedert.Equal("Line1PagedNoCriteriaTest.00874", addList[49].AddressLine1);
}
See More Examples