private Device Registration(List<string> data) { //@email NVARCHAR(50), //@pwd NVARCHAR(50), //@TypeDeviceID INT, //@Token NVARCHAR(300), //@AndroidIDMacaddress NVARCHAR(100), //@Name NVARCHAR(50) Device dev = new Device(); int typeDevice = Convert.ToInt32(data[TypeDeviceIDX]); if (typeDevice < 1) { dev.Name = "type device not define"; return dev; } try { MyCom = new MLDBUtils.SQLCom(connectionString, ""); Dictionary<string, object> dic = new Dictionary<string, object>(); MyCom.setCommand("aRegistration"); MyCom.AddParam(Utils.TruncateLongString(data[EMAILIDX], 50)); MyCom.AddParam(Utils.TruncateLongString(data[PWDIDX], 50)); MyCom.AddParam(typeDevice); MyCom.AddParam(Utils.TruncateLongString(data[TokenIDX], 500)); MyCom.AddParam(Utils.TruncateLongString(data[AndroidIDMacAddressIDX], 100)); MyCom.AddParam(Utils.TruncateLongString(data[NameIDX], 50)); MyCom.AddParam(Utils.TruncateLongString(data[VersionIDX], 10)); dic = MyCom.GetResultD(); if (dic == null || dic.Count == 0) { dev.Name = "dic is null or empty"; return dev; } dev.UserID = Convert.ToInt64(dic["userID"].ToString()); if (dev.UserID == EXISTUSER) { dev.Name = "User Exist"; return dev; } if (dev.UserID == ERRORSQL) { dev.Name = "Error SQL"; return dev; } dev.DeviceID = Convert.ToInt64(dic["deviceID"]); //dev.TypeDeviceID = Convert.ToInt32(dic["TypeDeviceID"]); //dev.Token = dic["Token"].ToString(); //dev.AndroidIDMacaddress = dic["AndroidIDMacaddress"].ToString(); dev.Name = dic["Name"].ToString(); //dev.DateCreate = Convert.ToDateTime(dic["dateCreate"]); } catch (Exception ex) { dev.UserID = ERRORDB; dev.Name = "Sql Exept. - "; if (ex.Message != null) { dev.Name += ex.Message; } return dev; } return dev; }
private Device Authentication(List<string> data) { Device dev = new Device(); int typeDevice = Convert.ToInt32(data[TypeDeviceIDX]); if (typeDevice < 1) { dev.Name = "type device not define"; return dev; } try { MyCom = new MLDBUtils.SQLCom(connectionString, ""); Dictionary<string, object> dic = new Dictionary<string, object>(); MyCom.setCommand("aAuthentication"); MyCom.AddParam(Utils.TruncateLongString(data[EMAILIDX], 50)); MyCom.AddParam(Utils.TruncateLongString(data[PWDIDX], 50)); MyCom.AddParam(typeDevice); MyCom.AddParam(Utils.TruncateLongString(data[TokenIDX], 500)); MyCom.AddParam(Utils.TruncateLongString(data[AndroidIDMacAddressIDX], 100)); MyCom.AddParam(Utils.TruncateLongString(data[IpIDX], 50)); MyCom.AddParam(Utils.TruncateLongString(data[VersionIDX], 10)); dic = MyCom.GetResultD(); if (dic == null || dic.Count == 0) { dev.Name = "dic is null or empty"; return dev; } //SELECT @OK AS 'returncode', @deviceID AS 'deviceID', @DeviceName AS 'DeviceName', '0' AS 'PGP' dev.Code = Convert.ToInt32(dic["returncode"]); dev.DeviceID = Convert.ToInt64(dic["deviceID"]); dev.Name = dic["DeviceName"].ToString(); } catch (Exception ex) { dev.Code = ERRORDB; dev.Name = "Sql Exept. - "; if (ex.Message != null) { dev.Name += ex.Message; } return dev; } return dev; }