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;
}
