int.ToString()

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 7

19 Source : MudProvider.cs
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

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

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

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

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

[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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

[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

[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

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

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

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

[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

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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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