public List <MiniUser> GetAllMini()
{
List <MiniUser> list = null;
Action <SqlParameterCollection> inputMapper = delegate(SqlParameterCollection parameters)
{
};
Action <IDataReader, short> resultMapper = delegate(IDataReader reader, short set)
{
MiniUser newMiniUser = MapReaderToMiniUser(reader, 0);
if (list == null)
{
list = new List <MiniUser>();
}
list.Add(newMiniUser);
};
DataProvider.ExecuteCmd(
GetConnection,
"dbo.Users_SelectAllMini",
inputMapper,
resultMapper
);
return(list);
}
public void create()
{
var newMiniUser = new MiniUser {
email = "*****@*****.**",
password = "******"
};
newMiniUser = MiniUsers.Create(newMiniUser).Result;
string id = newMiniUser.id;
Assert.AreEqual("*****@*****.**", newMiniUser.email);
//trying to create duplicate MiniUser
try
{
newMiniUser = MiniUsers.Create(newMiniUser).Result;
Assert.Fail();
}
catch (AggregateException e)
{
var restException = (RestException)e.InnerException;
Assert.AreEqual(422, restException.StatusCode);
}
performLoginAsAdmin();
MiniUsers.DeleteById(id).Wait();
MiniUsers.logout().Wait();
}
public void createDelete()
{
var newMiniUser = new MiniUser {
email = "*****@*****.**",
password = "******"
};
newMiniUser = MiniUsers.Create(newMiniUser).Result;
string id = newMiniUser.id;
Assert.AreEqual("*****@*****.**", newMiniUser.email);
//trying to create duplicate MiniUser
try
{
MiniUser usr = MiniUsers.Create(newMiniUser).Result;
Assert.Fail();
}
catch (AggregateException e)
{
var restException = (RestException)e.InnerException;
Assert.AreEqual(422, restException.StatusCode);
}
MiniUsers.DeleteById(id).Wait();
try
{
MiniUser delRes = MiniUsers.FindById(id).Result;
Assert.Fail();
}
catch (AggregateException e)
{
var restException = (RestException)e.InnerException;
Assert.AreEqual(404, restException.StatusCode);
}
}
public void createDelete()
{
var newMiniUser = new MiniUser {
email = "*****@*****.**",
password = "******"
};
newMiniUser = MiniUsers.Create (newMiniUser).Result;
string id = newMiniUser.id;
Assert.AreEqual ("*****@*****.**", newMiniUser.email);
//trying to create duplicate MiniUser
try
{
MiniUser usr = MiniUsers.Create(newMiniUser).Result;
Assert.Fail();
}
catch (AggregateException e)
{
var restException = (RestException)e.InnerException;
Assert.AreEqual(422, restException.StatusCode);
}
MiniUsers.DeleteById(id).Wait();
try
{
MiniUser delRes = MiniUsers.FindById(id).Result;
Assert.Fail();
}
catch (AggregateException e)
{
var restException = (RestException)e.InnerException;
Assert.AreEqual(404, restException.StatusCode);
}
}
public MiniUser MapReaderToMiniUser(IDataReader reader, int startingIndex)
{
MiniUser newMiniUser = new MiniUser();
newMiniUser.Id = reader.GetInt32(startingIndex++);
newMiniUser.Username = reader.GetString(startingIndex++);
newMiniUser.ImageUrl = reader.GetSafeString(startingIndex++);
return(newMiniUser);
}
public void login()
{
var credentials = new MiniUser {
email = "*****@*****.**",
password = "******"
};
var accessToken = MiniUsers.login (credentials).Result;
Assert.AreEqual ("1", accessToken.Property ("userId").Value.ToString ());
}
public void Regis(string usernameRegis)
{
MiniUser miniUser = new MiniUser(Config.GetAndroidID(), usernameRegis);
JSONObject js = new JSONObject();
js.AddField("userid", miniUser.MobileId);
js.AddField("username", miniUser.Username);
socket.Emit("regisaccount", js);
}
public void login()
{
var credentials = new MiniUser {
email = "*****@*****.**",
password = "******"
};
var accessToken = MiniUsers.login(credentials).Result;
Assert.AreEqual("1", accessToken.Property("userId").Value.ToString());
}
/* perfomLogin
* preforms login as admin
*/
public void performLogin()
{
var credentials = new MiniUser {
email = "*****@*****.**",
password = "******"
};
var a = MiniUsers.login(credentials).Result;
Gateway.SetAccessToken(a);
}
public void findOne()
{
MiniUser usr = MiniUsers.FindOne().Result;
Assert.AreNotEqual(null, usr);
Assert.AreEqual("1", usr.getID());
usr = MiniUsers.FindOne("{\"where\": {\"email\" : \"[email protected]\"}}").Result;
Assert.AreNotEqual(null, usr);
Assert.AreEqual("2", usr.getID());
}
public void findById()
{
var usr = new MiniUser {
email = "*****@*****.**",
password = "******"
};
usr = MiniUsers.Create(usr).Result;
usr = MiniUsers.FindById(usr.id).Result;
Assert.AreNotEqual(null, usr);
Assert.AreEqual("*****@*****.**", usr.email);
MiniUsers.DeleteById(usr.id).Wait();
}
public void findOne()
{
try
{
MiniUser result = MiniUsers.FindOne().Result;
Assert.Fail();
}
catch (AggregateException e)
{
var restException = (RestException)e.InnerException;
Assert.AreEqual(401, restException.StatusCode);
}
}
public static MiniUser GenFakeUser()
{
string r = Config.GetAndroidID();
string idUser = "";
for (var i = 'A'; i <= 'Z'; i++)
{
if (Random.Range(0, 3) == 0)
{
idUser += i;
}
}
MiniUser user = new MiniUser(r, idUser);
return(user);
}
public async Task <User> SubscribeBuddyForProfileActionAsync(long ProfileID, long UserID, int State, string SubscribtionID)
{
MiniUser resMiniUser = _guardianContext.Database
.SqlQuery <MiniUser>("EXEC [dbo].[SubscribeBuddyForProfileAction] @ProfileID,@UserID,@State,@SubscribtionID",
new SqlParameter("@ProfileID", ProfileID),
new SqlParameter("@UserID", UserID),
new SqlParameter("@State", State),
new SqlParameter("@SubscribtionID", SubscribtionID)).FirstOrDefault();
User resUser = new User
{
Name = resMiniUser.Name,
MobileNumber = Security.Decrypt(resMiniUser.MobileNumber)
};
return(resUser);
}
public void updateAll()
{
var upUsr = new MiniUser {
email = "*****@*****.**"
};
try
{
MiniUsers.UpdateAll(upUsr, "{\"id\" : \"3\"}").Wait();
Assert.Fail();
}
catch (AggregateException e)
{
var restException = (RestException)e.InnerException;
Assert.AreEqual(401, restException.StatusCode);
}
}
public void updateAll_ById()
{
var upUsr = new MiniUser {
email = "*****@*****.**"
};
var newIds = new List <string> ();
string filter = "{\"or\": [";
for (int i = 0; i < 4; i++)
{
var newMiniUser = new MiniUser {
email = "newMiniUserA" + i + "@g.com",
password = "******"
};
newMiniUser = MiniUsers.Create(newMiniUser).Result;
newIds.Add(newMiniUser.id);
filter = filter + "{\"id\": \"" + newMiniUser.id + "\"}";
if (i < 3)
{
filter = filter + " ,";
}
}
filter = filter + "]}";
MiniUsers.UpdateAll(upUsr, filter).Wait();
MiniUser upRes;
foreach (string id in newIds)
{
upRes = MiniUsers.FindById(id).Result;
Assert.AreEqual(upUsr.email, upRes.email);
}
upUsr = new MiniUser {
email = "*****@*****.**"
};
MiniUsers.UpdateById(newIds[0], upUsr).Wait();
upRes = MiniUsers.FindById(newIds[0]).Result;
Assert.AreEqual(upUsr.email, upRes.email);
foreach (string id in newIds)
{
MiniUsers.DeleteById(id);
}
}
public void findById()
{
MiniUser usr = MiniUsers.FindById("2").Result;
Assert.AreNotEqual(null, usr);
Assert.AreEqual("*****@*****.**", usr.email);
try
{
usr = MiniUsers.FindById("1").Result;
Assert.Fail();
}
catch (AggregateException e)
{
var restException = (RestException)e.InnerException;
Assert.AreEqual(401, restException.StatusCode);
}
}
public async Task <User> SubscribeBuddyForProfileActionAsync(long ProfileID, long UserID, int State)
{
User resUser = null;
await _sqlAzureExecutionStrategy.ExecuteAsync(async() =>
{
MiniUser resMiniUser = await _guardianContext.Database
.SqlQuery <MiniUser>("EXEC [dbo].[SubscribeBuddyForProfileAction] @ProfileID,@UserID,@State",
new SqlParameter("@ProfileID", ProfileID),
new SqlParameter("@UserID", UserID),
new SqlParameter("@State", State)).FirstOrDefaultAsync();
resUser = new User
{
Name = resMiniUser.Name,
MobileNumber = resMiniUser.MobileNumber
};
}, CancellationToken.None);
return(resUser);
}
public void create()
{
var newMiniUser = new MiniUser {
email = "*****@*****.**",
password = "******"
};
MiniUser resMiniUser = MiniUsers.Create (newMiniUser).Result;
string id = resMiniUser.id;
Assert.AreEqual (resMiniUser.email, newMiniUser.email);
try
{
newMiniUser = MiniUsers.Create(newMiniUser).Result;
Assert.Fail();
}
catch (AggregateException e)
{
var restException = (RestException)e.InnerException;
Assert.AreEqual(422, restException.StatusCode);
}
performLoginAsAdmin ();
MiniUsers.DeleteById (id).Wait();
performLogin ();
}
public void updateById()
{
var upUsr = new MiniUser {
email = "*****@*****.**"
};
//update self
MiniUsers.UpdateById("2", upUsr).Wait();
//trying to update other
try
{
MiniUsers.UpdateById("3", upUsr).Wait();
Assert.Fail();
}
catch (AggregateException e)
{
var restException = (RestException)e.InnerException;
Assert.AreEqual(401, restException.StatusCode);
}
MiniUser upRes = MiniUsers.FindById("2").Result;
Assert.AreEqual(upUsr.email, upRes.email);
//perform update checks using admin login
performLoginAsAdmin();
upRes = MiniUsers.FindById("3").Result;
Assert.AreNotEqual(upUsr.email, upRes.email);
upUsr = new MiniUser {
email = "*****@*****.**"
};
//update back to original state
MiniUsers.UpdateById("2", upUsr).Wait();
performLogin();
}
public ResLastUserInfo GetLastUserInfo(int UID)
{
ResLastUserInfo Res = new ResLastUserInfo();
try
{
Com.User usr = BLL.User.GetUser(UID);
MiniUser miniUser = new MiniUser()
{
CodeMeli = usr.CodeMeli ?? "",
Credit = usr.Credit,
Email = usr.Email ?? "",
FamilyName = usr.FamilyName ?? "",
JoinDate = usr.JoinDate,
LastLogin = usr.LastLogin,
Name = usr.Name ?? "",
NickName = usr.NickName ?? "",
RewardState = 1,
TellNumber = usr.TellNumber,
UID = usr.UID,
Address = usr.Address ?? "",
CodePosti = usr.CodePosti ?? "",
City = usr.City ?? "",
Ostan = usr.Ostan ?? "",
};
Res.MiniUser = miniUser;
Res.userBought = BLL.User.GetAllUserBought(UID);
Res.userMessage = BLL.User.GetAllUserMessage(UID);
}
catch (Exception e)
{
new System.Threading.Thread(delegate() { BLL.Log.DoLog(Common.Action.GetLastUserInfo, UID.ToString(), -400, e.Message); }).Start();
new System.Threading.Thread(delegate() { BLL.Log.DoLog(Common.Action.GetLastUserInfo, UID.ToString(), -400, e.InnerException.Message); }).Start();
}
return(Res);
}
public void updateAll_ById()
{
var upUsr = new MiniUser {
email = "*****@*****.**"
};
var newIds = new List<string> ();
string filter = "{\"or\": [";
for (int i = 0; i < 4; i++) {
var newMiniUser = new MiniUser {
email = "newMiniUserA" + i + "@g.com",
password = "******"
};
newMiniUser = MiniUsers.Create (newMiniUser).Result;
newIds.Add (newMiniUser.id);
filter = filter + "{\"id\": \"" + newMiniUser.id + "\"}";
if (i < 3) {
filter = filter + " ,";
}
}
filter = filter + "]}";
MiniUsers.UpdateAll(upUsr, filter).Wait();
MiniUser upRes;
foreach (string id in newIds) {
upRes = MiniUsers.FindById (id).Result;
Assert.AreEqual (upUsr.email, upRes.email);
}
upUsr = new MiniUser {
email = "*****@*****.**"
};
MiniUsers.UpdateById (newIds[0], upUsr).Wait();
upRes = MiniUsers.FindById (newIds[0]).Result;
Assert.AreEqual (upUsr.email, upRes.email);
foreach (string id in newIds) {
MiniUsers.DeleteById (id);
}
}
public void findById()
{
var usr = new MiniUser {
email = "*****@*****.**",
password = "******"
};
usr = MiniUsers.Create (usr).Result;
usr = MiniUsers.FindById (usr.id).Result;
Assert.AreNotEqual (null, usr);
Assert.AreEqual ("*****@*****.**", usr.email);
MiniUsers.DeleteById (usr.id).Wait();
}
public void updateAll()
{
var upUsr = new MiniUser {
email = "*****@*****.**"
};
try
{
MiniUsers.UpdateAll(upUsr, "{\"id\" : \"3\"}").Wait();
Assert.Fail();
}
catch (AggregateException e)
{
var restException = (RestException)e.InnerException;
Assert.AreEqual(401, restException.StatusCode);
}
}
public void updateById()
{
var upUsr = new MiniUser {
email = "*****@*****.**"
};
//update self
MiniUsers.UpdateById("2", upUsr).Wait();
//trying to update other
try
{
MiniUsers.UpdateById("3", upUsr).Wait();
Assert.Fail();
}
catch (AggregateException e)
{
var restException = (RestException)e.InnerException;
Assert.AreEqual(401, restException.StatusCode);
}
MiniUser upRes = MiniUsers.FindById ("2").Result;
Assert.AreEqual (upUsr.email, upRes.email);
//perform update checks using admin login
performLoginAsAdmin ();
upRes = MiniUsers.FindById ("3").Result;
Assert.AreNotEqual (upUsr.email, upRes.email);
upUsr = new MiniUser {
email = "*****@*****.**"
};
//update back to original state
MiniUsers.UpdateById ("2", upUsr).Wait();
performLogin ();
}
/* performLoginAsAdmin
* performs login as server admin
*/
public void performLoginAsAdmin()
{
var credentials = new MiniUser {
email = "*****@*****.**",
password = "******"
};
var a = MiniUsers.login (credentials).Result;
Gateway.SetAccessToken (a);
}
