public static async Task<long> Insert(Device device) { const string commandText = @" Insert into Devices (Id, ClientId, RequestDeviceId, IsActived, DeviceKey, DeviceSecret, SerialNumber, IMEI, Manufacturer, Model, Platform, PlatformVersion, DeviceName, DeviceDescription) values (@id, @clientId, @requestDeviceId, @isActived, @deviceKey, @deviceSecret, @serialNumber, @iMEI, @manufacturer, @model, @platform, @platformVersion, @deviceName, @deviceDescription)"; var parameters = new DynamicParameters(); if (device.Id > 0) parameters.Add("id", device.Id); else parameters.Add("id",0); parameters.Add("clientId", device.ClientId); parameters.Add("requestDeviceId", device.RequestDeviceId); parameters.Add("isActived", device.IsActived ? 1 : 0); parameters.Add("deviceKey", device.DeviceKey); parameters.Add("deviceSecret", device.DeviceSecret); parameters.Add("serialNumber", device.SerialNumber); parameters.Add("iMEI", device.IMEI); parameters.Add("manufacturer", device.Manufacturer); parameters.Add("model", device.Model); parameters.Add("platform", device.Platform); parameters.Add("platformVersion", device.PlatformVersion); parameters.Add("deviceName", device.DeviceName); parameters.Add("deviceDescription", device.DeviceDescription); long results; using (var conn = await DataAccessBase.GetOpenAsync(DataAccessBase.QuangAuthConn)) { var data = await conn.QueryAsync<long>(commandText, parameters); results = data.FirstOrDefault(); } return results; }
public static async Task<long> Update(Device device) { var parameters = new DynamicParameters(); const string commandText = "Update Devices Set " + "ClientId = @clientId, " + "IsActived = @isActived, " + "DeviceKey = @deviceKey, " + "DeviceSecret = @deviceSecret, " + "SerialNumber = @serialNumber, " + "IMEI = @iMEI, " + "Manufacturer = @manufacturer, " + "Model = @model, " + "Platform = @platform, " + "PlatformVersion = @platformVersion, " + "DeviceName = @deviceName, " + "DeviceDescription = @deviceDescription " + "where Id = @id"; parameters.Add("id", device.Id); parameters.Add("clientId", device.ClientId); parameters.Add("@isActived", (device.IsActived ? 1 : 0)); parameters.Add("deviceKey", device.DeviceKey); parameters.Add("deviceSecret", device.DeviceSecret); parameters.Add("serialNumber", device.SerialNumber); parameters.Add("iMEI", device.IMEI); parameters.Add("manufacturer", device.Manufacturer); parameters.Add("model", device.Model); parameters.Add("platform", device.Platform); parameters.Add("platformVersion", device.PlatformVersion); parameters.Add("@deviceName", device.DeviceName); parameters.Add("deviceDescription", device.DeviceDescription); long results; using (var conn = await DataAccessBase.GetOpenAsync(DataAccessBase.QuangAuthConn)) { var data = await conn.QueryAsync<long>(commandText, parameters); results = data.FirstOrDefault(); } return results; }
public static async Task<long> UpdateDevice(Device input) { long result = await DeviceDal.Update(input); if (result > 0) await RequestDeviceDal.UpdateRequestDeviceStatus(input.ClientId, input.DeviceKey, true); return (result); }
public int Update(Device device) { return _database.Execute("Update Devices Set " + "ClientId = @clientId, " + "IsActived = @isActived, " + "DeviceKey = @deviceKey, " + "DeviceSecret = @deviceSecret, " + "SerialNumber = @serialNumber, " + "IMEI = @iMEI, " + "Manufacturer = @manufacturer, " + "Model = @model, " + "Platform = @platform, " + "PlatformVersion = @platformVersion, " + "DeviceName = @deviceName, " + "DeviceDescription = @deviceDescription " + "where Id = @id", new Dictionary<string, object>() { {"@id", device.Id}, {"@clientId", device.ClientId}, { "@isActived", device.IsActived ? 1 : 0 }, {"@deviceKey", device.DeviceKey}, { "@deviceSecret", device.DeviceSecret }, { "@serialNumber", device.SerialNumber }, {"@iMEI", device.IMEI}, { "@manufacturer", device.Manufacturer }, {"@model", device.Model}, {"@platform", device.Platform}, { "@platformVersion", device.PlatformVersion }, {"@deviceName", device.DeviceName}, { "@deviceDescription", device.DeviceDescription } }); }
public int Insert(Device device) { const string commandText = "Insert into Devices (Id, ClientId, RequestDeviceId, IsActived, DeviceKey, DeviceSecret, SerialNumber, IMEI, Manufacturer, Model, Platform, PlatformVersion, DeviceName, DeviceDescription) " + "values (@id, @clientId, @requestDeviceId, @isActived, @deviceKey, @deviceSecret, @serialNumber, @iMEI, @manufacturer, @model, @platform, @platformVersion, @deviceName, @deviceDescription)"; var parameters = new Dictionary<string, object>(); if (device.Id > 0) parameters.Add("@id", device.Id); else parameters.Add("@id", null); parameters.Add("@clientId", device.ClientId); parameters.Add("@requestDeviceId", device.RequestDeviceId); parameters.Add("@isActived", (device.IsActived ? 1 : 0)); parameters.Add("@deviceKey", device.DeviceKey); parameters.Add("@deviceSecret", device.DeviceSecret); parameters.Add("@serialNumber", device.SerialNumber); parameters.Add("@iMEI", device.IMEI); parameters.Add("@manufacturer", device.Manufacturer); parameters.Add("@model", device.Model); parameters.Add("@platform", device.Platform); parameters.Add("@platformVersion", device.PlatformVersion); parameters.Add("@deviceName", device.DeviceName); parameters.Add("@deviceDescription", device.DeviceDescription); return _database.Execute(commandText, parameters); }
public Device GetDevice(string clientId, string deviceKey) { List<Dictionary<string, string>> list = this._database.Query("select * from Devices where ClientId=@clientId and DeviceKey = @deviceKey", new Dictionary<string, object>() {{"@clientId",clientId},{"@deviceKey",deviceKey}}); Device device = null; if (list != null && list.Count == 1) { Dictionary<string, string> dictionary = list[0]; device = new Device { Id = int.Parse(dictionary["Id"]), ClientId = dictionary["ClientId"], IsActived = bool.Parse(dictionary["IsActived"]), DeviceKey = dictionary["DeviceKey"], DeviceSecret = dictionary["DeviceSecret"], DeviceName = dictionary["DeviceName"], DeviceDescription = dictionary["DeviceDescription"], SerialNumber = dictionary["SerialNumber"], IMEI = dictionary["IMEI"], Manufacturer = dictionary["Manufacturer"], Model = dictionary["Model"], Platform = dictionary["Platform"], PlatformVersion = dictionary["PlatformVersion"], RequestDeviceId = new int?() }; if (!string.IsNullOrEmpty(dictionary["RequestDeviceId"])) device.RequestDeviceId = new int?(int.Parse(dictionary["RequestDeviceId"])); } return device; }
public IEnumerable<Device> GetPaging(int pageSize, int pageNumber, string clientId, string keyword) { var parameters = new Dictionary<string, object>(); string str = "select * from Devices where (DeviceName LIKE @param OR DeviceKey LIKE @param OR RequestDeviceId=@rid)"; parameters.Add("@param", "%" + Utils.EncodeForLike(keyword) + "%"); if (!string.IsNullOrEmpty(clientId)) { str += " AND ClientId=@clientId"; parameters.Add("@clientId", clientId); } int num = 0; if (!string.IsNullOrEmpty(keyword)) { Match match = Regex.Match(keyword, "^R([\\d]{4,})$"); if (match.Success) num = int.Parse(match.Groups[1].Value); } parameters.Add("@rid", num); string commandText = str + " order by Id limit @rowNumber, @pageSize"; parameters.Add("@rowNumber", pageSize * pageNumber); parameters.Add("@pageSize", pageSize); var list = new List<Device>(); foreach (Dictionary<string, string> dictionary in _database.Query(commandText, parameters)) { var device = new Device { Id = int.Parse(dictionary["Id"]), ClientId = dictionary["ClientId"], IsActived = bool.Parse(dictionary["IsActived"]), DeviceKey = dictionary["DeviceKey"], DeviceSecret = dictionary["DeviceSecret"], DeviceName = dictionary["DeviceName"], DeviceDescription = dictionary["DeviceDescription"], SerialNumber = dictionary["SerialNumber"], IMEI = dictionary["IMEI"], Manufacturer = dictionary["Manufacturer"], Model = dictionary["Model"], Platform = dictionary["Platform"], PlatformVersion = dictionary["PlatformVersion"], RequestDeviceId = new int?() }; if (!string.IsNullOrEmpty(dictionary["RequestDeviceId"])) device.RequestDeviceId = int.Parse(dictionary["RequestDeviceId"]); list.Add(device); } return list; }
public Device GetOneDevice(int deviceId) { var device = (Device)null; List<Dictionary<string, string>> list = _database.Query("Select * from Devices where Id = @id", new Dictionary<string, object> { {"@id",deviceId}}); if (list != null && list.Count == 1) { var dictionary = list[0]; device = new Device { Id = int.Parse(dictionary["Id"]), ClientId = dictionary["ClientId"], IsActived = bool.Parse(dictionary["IsActived"]), DeviceKey = dictionary["DeviceKey"], DeviceSecret = dictionary["DeviceSecret"], DeviceName = dictionary["DeviceName"], DeviceDescription = dictionary["DeviceDescription"], SerialNumber = dictionary["SerialNumber"], IMEI = dictionary["IMEI"], Manufacturer = dictionary["Manufacturer"], Model = dictionary["Model"], Platform = dictionary["Platform"], PlatformVersion = dictionary["PlatformVersion"], RequestDeviceId = new int?() }; if (!string.IsNullOrEmpty(dictionary["RequestDeviceId"])) device.RequestDeviceId = int.Parse(dictionary["RequestDeviceId"]); } return device; }
public IEnumerable<Device> GetAllDevices() { var list = new List<Device>(); foreach (Dictionary<string, string> dictionary in this._database.Query("Select * from Devices order by Id")) { var device = new Device { Id = int.Parse(dictionary["Id"]), ClientId = dictionary["ClientId"], IsActived = bool.Parse(dictionary["IsActived"]), DeviceKey = dictionary["DeviceKey"], DeviceSecret = dictionary["DeviceSecret"], DeviceName = dictionary["DeviceName"], DeviceDescription = dictionary["DeviceDescription"], SerialNumber = dictionary["SerialNumber"], IMEI = dictionary["IMEI"], Manufacturer = dictionary["Manufacturer"], Model = dictionary["Model"], Platform = dictionary["Platform"], PlatformVersion = dictionary["PlatformVersion"], RequestDeviceId = new int?() }; if (!string.IsNullOrEmpty(dictionary["RequestDeviceId"])) device.RequestDeviceId = int.Parse(dictionary["RequestDeviceId"]); list.Add(device); } return list; }