Ejemplo n.º 1
0
 public static async Task<int> CreateRequestDevice(RequestDevice newApp)
 {
     int num = 0;
     string str = (string)null;
     var device = await DeviceDal.GetDevice(newApp.ClientId, newApp.DeviceKey);
     if (device == null)
     {
         var exit = await RequestDeviceDal.IsExistRequestDevice(newApp.ClientId, newApp.DeviceKey);
         if (!exit)
             await RequestDeviceDal.CreateRequestDevice(newApp);
         else
              await RequestDeviceDal.UpdateRequestDevice(newApp);
         RequestDevice requestDevice = await RequestDeviceDal.GetRequestDevice(newApp.ClientId, newApp.DeviceKey);
         if (requestDevice != null)
         {
             if (!requestDevice.IsApproved)
                 //str = string.Format("R{0}", (object)requestDevice.Id.ToString("D4"));
                 num = (int)requestDevice.Id;
             else
                 num = 3;
         }
         else
             num = 2;
     }
     else
         num = 1;
     return num;
 }
Ejemplo n.º 2
0
        public static async  Task<long> UpdateRequestDevice(RequestDevice newApp, bool isApproved)
        {
            if (isApproved)
            {
                const string commandText = @"Update RequestDevices Set ClientId=@clientId, SerialNumber=@serialNumber, IMEI=@iMEI, Manufacturer=@manufacturer, Model=@model, Platform=@platform, PlatformVersion=@platformVersion, IsApproved = @isApproved, Updated = @updated Where DeviceKey = @deviceKey";
                var parameters = new DynamicParameters();
                parameters.Add("clientId", newApp.ClientId);
                parameters.Add("deviceKey", newApp.DeviceKey);
                parameters.Add("serialNumber", newApp.SerialNumber);
                parameters.Add("iMEI", newApp.IMEI);
                parameters.Add("manufacturer", newApp.Manufacturer);
                parameters.Add("model", newApp.Model);
                parameters.Add("platform", newApp.Platform);
                parameters.Add("platformVersion", newApp.PlatformVersion);
                parameters.Add("isApproved", isApproved);
                parameters.Add("updated", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));

                //            if (isApproved)
                long results;
                using (var conn = await DataAccessBase.GetOpenAsync(DataAccessBase.QuangAuthConn))
                {

                    var data = await conn.QueryAsync<long>(commandText, parameters);
                    results = data.FirstOrDefault();
                }
                return results;
            }
            else
            {
                const string commandText = @"Update RequestDevices Set ClientId=@clientId, SerialNumber=@serialNumber, IMEI=@iMEI, Manufacturer=@manufacturer, Model=@model, Platform=@platform, PlatformVersion=@platformVersion, Created = @created Where DeviceKey = @deviceKey and IsApproved = @isApproved";
                var parameters = new DynamicParameters();
                parameters.Add("clientId", newApp.ClientId);
                parameters.Add("deviceKey", newApp.DeviceKey);
                parameters.Add("serialNumber", (object)newApp.SerialNumber);
                parameters.Add("iMEI", (object)newApp.IMEI);
                parameters.Add("manufacturer", (object)newApp.Manufacturer);
                parameters.Add("model", (object)newApp.Model);
                parameters.Add("platform", (object)newApp.Platform);
                parameters.Add("platformVersion", (object)newApp.PlatformVersion);
                parameters.Add("isApproved", isApproved);
                parameters.Add("created", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));

                long results;
                using (var conn = await DataAccessBase.GetOpenAsync(DataAccessBase.QuangAuthConn))
                {

                    var data = await conn.QueryAsync<long>(commandText, parameters);
                    results = data.FirstOrDefault();
                }
                return results;
            }
           
        }
Ejemplo n.º 3
0
 public static async Task<long> UpdateRequestDevice(RequestDevice newApp)
 {
     return await UpdateRequestDevice(newApp, false);
 }
Ejemplo n.º 4
0
        public static async Task< long> CreateRequestDevice(RequestDevice newApp)
        {
            const string commandText = @"Insert into RequestDevices (Id, ClientId, DeviceKey, SerialNumber, IMEI, Manufacturer, Model, Platform, PlatformVersion, IsApproved, Created, Updated) " + "values (@id, @clientId, @deviceKey, @serialNumber, @iMEI, @manufacturer, @model, @platform, @platformVersion, @isApproved, @created, @updated)";
            var parameters = new DynamicParameters();
            parameters.Add("clientId", newApp.ClientId);
            parameters.Add("deviceKey", newApp.DeviceKey);
            parameters.Add("serialNumber", newApp.SerialNumber);
            parameters.Add("iMEI", newApp.IMEI);
            parameters.Add("manufacturer", newApp.Manufacturer);
            parameters.Add("model", newApp.Model);
            parameters.Add("platform", newApp.Platform);
            parameters.Add("platformVersion", newApp.PlatformVersion);
            parameters.Add("isApproved", false);
            parameters.Add("updated", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
            parameters.Add("created", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
            
            long results;
            using (var conn = await DataAccessBase.GetOpenAsync(DataAccessBase.QuangAuthConn))
            {

                var data = await conn.QueryAsync<long>(commandText, parameters);
                results = data.FirstOrDefault();
            }
            return results;
          
        }
Ejemplo n.º 5
0
 public IEnumerable<RequestDevice> GetPaging(int pageSize, int pageNumber, string clientId, string keyword, DateTime? dateFrom, DateTime? dateTo)
 {
     var parameters = new Dictionary<string, object>();
     string str = "select *, EXISTS(SELECT * FROM TrustDevices WHERE TrustDevices.DeviceSerial = RequestDevices.SerialNumber) as IsTrust\n                        from RequestDevices \n                        where IsApproved = false and (Id = @id or DeviceKey LIKE @param)";
     int num1 = 0;
     if (!string.IsNullOrEmpty(keyword))
     {
         Match match = Regex.Match(keyword, "^R([\\d]{4,})$");
         if (match.Success)
             num1 = int.Parse(match.Groups[1].Value);
     }
     parameters.Add("@id", num1);
     parameters.Add("@param", "%" + Utils.EncodeForLike(keyword) + "%");
     if (!string.IsNullOrEmpty(clientId))
     {
         str += " and ClientId = @clientId";
         parameters.Add("@clientId", clientId);
     }
     if (dateFrom.HasValue)
     {
         str += " and Created >= @dateFrom";
         parameters.Add("@dateFrom", dateFrom.Value.ToString("yyyy-MM-dd 00:00:00"));
     }
     if (dateTo.HasValue)
     {
         str += " and Created <= @dateTo";
         parameters.Add("@dateTo", dateTo.Value.ToString("yyyy-MM-dd 23:59:59"));
     }
     string commandText = str + " order by Created limit @rowNumber, @pageSize";
     parameters.Add("@rowNumber", pageSize * pageNumber);
     parameters.Add("@pageSize", pageSize);
     var list = new List<RequestDevice>();
     foreach (Dictionary<string, string> dictionary in _database.Query(commandText, parameters))
     {
         var requestDevice = new RequestDevice
                             {
                                 Id = int.Parse(dictionary["Id"]),
                                 ClientId = dictionary["ClientId"],
                                 IsApproved = bool.Parse(dictionary["IsApproved"]),
                                 DeviceKey = dictionary["DeviceKey"],
                                 SerialNumber = dictionary["SerialNumber"],
                                 IMEI = dictionary["IMEI"],
                                 Manufacturer = dictionary["Manufacturer"],
                                 Model = dictionary["Model"],
                                 Platform = dictionary["Platform"],
                                 PlatformVersion = dictionary["PlatformVersion"],
                                 Created = DateTime.Parse(dictionary["Created"])
                             };
         if (!string.IsNullOrEmpty(dictionary["Updated"]))
             requestDevice.Updated = DateTime.Parse(dictionary["Updated"]);
         if (!string.IsNullOrEmpty(dictionary["IsTrust"]))
         {
             int num2 = int.Parse(dictionary["IsTrust"]);
             requestDevice.IsTrust = num2 > 0;
         }
         list.Add(requestDevice);
     }
     return list;
 }
Ejemplo n.º 6
0
   public RequestDevice GetRequestDevice(string clientId, string deviceKey)
   {
       List<Dictionary<string, string>> list = _database.Query("select * from RequestDevices where ClientId=@clientId and DeviceKey = @deviceKey and IsApproved = @isApproved", new Dictionary<string, object>
                                                                                                                                                                                {
   {
     "@clientId",
     clientId
   },
   {
     "@deviceKey",
     deviceKey
   },
   {
     "@isApproved",
     false
   }
 });
       var requestDevice = (RequestDevice)null;
       if (list != null && list.Count == 1)
       {
           Dictionary<string, string> dictionary = list[0];
           requestDevice = new RequestDevice
                           {
                               Id = int.Parse(dictionary["Id"]),
                               ClientId = dictionary["ClientId"],
                               IsApproved = bool.Parse(dictionary["IsApproved"]),
                               DeviceKey = dictionary["DeviceKey"],
                               SerialNumber = dictionary["SerialNumber"],
                               IMEI = dictionary["IMEI"],
                               Manufacturer = dictionary["Manufacturer"],
                               Model = dictionary["Model"],
                               Platform = dictionary["Platform"],
                               PlatformVersion = dictionary["PlatformVersion"],
                               Created = DateTime.Parse(dictionary["Created"]),
                               Updated = DateTime.Parse(dictionary["Updated"])
                           };
       }
       return requestDevice;
   }