//删除企业信息
public int deleteCpById(string id)
{
int cid = int.Parse(id);
int result = QueryDB.Context().Delete(Config.pretable + "search").Where("id", cid).Execute();
return(result);
}
public void TestErrorSavePoints()
{
QueryDB queryDB = new QueryDB();
bool saveError = queryDB.SavePoints("MiroStarts", 1000);
Assert.IsFalse(saveError);
}
public void TestSearchBestScorePlayers()
{
QueryDB queryDB = new QueryDB();
List <Player> bestScorePlayers = queryDB.SearchBestScoresPlayer();
Assert.IsNotNull(bestScorePlayers);
}
public static void ClassInitializeReport(TestContext testContext)
{
Account accountOne = new Account();
accountOne.passwordAccount = Encrypt("Mmol180515#");
accountOne.email = "*****@*****.**";
accountOne.confirmationCode = 154863;
accountOne.nickName = "MariaFer13";
Player playerOne = new Player();
playerOne.lastName = "Gomez";
playerOne.nickName = "MariaFer13";
playerOne.namePlayer = "Maria Fernanda";
playerOne.statusPlayer = "Active";
Account accountTwo = new Account();
accountTwo.passwordAccount = Encrypt("Mmol180515#");
accountTwo.email = "*****@*****.**";
accountTwo.confirmationCode = 154863;
accountTwo.nickName = "MiroStart";
Player playerTwo = new Player();
playerTwo.lastName = "Ortiz";
playerTwo.nickName = "MiroStart";
playerTwo.namePlayer = "Martha";
playerTwo.statusPlayer = "Active";
QueryDB queryDB = new QueryDB();
queryDB.RegisterPlayer(accountOne, playerOne);
queryDB.RegisterPlayer(accountTwo, playerTwo);
}
public void TestErrorIsLog()
{
QueryDB queryDB = new QueryDB();
bool isLog = queryDB.IsLog("*****@*****.**", "VwBpAGcAZQB0AHQAYQBfADQA");
Assert.IsTrue(isLog);
}
public void TestSearchSentence()
{
QueryDB queryDB = new QueryDB();
Sentence sentence = queryDB.SearchSentence();
Assert.IsNotNull(sentence.hintSpanish);
}
public void TestSavePoints()
{
QueryDB queryDB = new QueryDB();
bool saveOk = queryDB.SavePoints("MiroStart", 1000);
Assert.IsTrue(saveOk);
}
public void TestSearchInformationPlayer()
{
QueryDB queryDB = new QueryDB();
Player player = queryDB.SearchInformationPlayer("*****@*****.**");
Assert.IsNotNull(player.nickName);
}
public override bool Delete(long key)
{
QueryDB query = new QueryDB("DELETE FROM Rating WHERE Id_Rating = @Id");
query.AddParametre("@Id", key);
return(Connector.ExecuteNonQuery(query) == 1);
}
public override ProductionCompany Get(long key)
{
QueryDB query = new QueryDB("SELECT * FROM ProductionCompany WHERE Id_ProductionCompany = @Id");
query.AddParametre("@Id", key);
return(Connector.ExecuteReader(query, ConvertReaderToEntity).SingleOrDefault());
}
public override ProductionCompany Insert(ProductionCompany entity)
{
QueryDB query = new QueryDB("INSERT INTO ProductionCompany (Name) OUTPUT inserted.* VALUES (@name)");
query.AddParametre("@name", entity.Name);
return(Connector.ExecuteReader(query, ConvertReaderToEntity).SingleOrDefault());
}
public bool Delete(Guid id)
{
QueryDB query = new QueryDB("DELETE FROM [ImageData] WHERE [Id] = @Id");
query.AddParametre("Id", id);
return(DB.ExecuteNonQuery(query) == 1);
}
public override bool Delete(long key)
{
QueryDB query = new QueryDB("DELETE FROM ProductionCompany WHERE Id_ProductionCompany = @Id");
query.AddParametre("@Id", key);
return(Connector.ExecuteNonQuery(query) == 1);
}
public void TestErrorSearchAccount()
{
QueryDB queryDB = new QueryDB();
Account account = new Account();
account = queryDB.SearchAccount("*****@*****.**");
Assert.AreEqual("*****@*****.**", account.email);
}
public ImageData Get(Guid id)
{
QueryDB query = new QueryDB("SELECT * FROM [ImageData] WHERE [Id] = @id");
query.AddParametre("id", id);
return(DB.ExecuteReader(query, ConvertReaderToEntity).SingleOrDefault());
}
public override Rating Get(long key)
{
QueryDB query = new QueryDB("SELECT * FROM Rating WHERE Id_Rating = @Id");
query.AddParametre("@Id", key);
return(Connector.ExecuteReader(query, ConvertReaderToEntity).SingleOrDefault());
}
public void TestReportAccountPlayer()
{
QueryDB queryDB = new QueryDB();
bool isReportAccountPlayer;
isReportAccountPlayer = queryDB.ReportAccountPlayer("MariaFer13");
Assert.IsTrue(isReportAccountPlayer);
}
public void TestDeleteAccountPlayer()
{
QueryDB queryDB = new QueryDB();
bool isDeleteAccountPlayer;
isDeleteAccountPlayer = queryDB.DeleteAccountPlayer("MiroStart");
Assert.IsTrue(isDeleteAccountPlayer);
}
public void TestSearchReport()
{
List <ReportMisConduct> reportMisConducts = new List <ReportMisConduct>();
QueryDB queryDB = new QueryDB();
reportMisConducts = queryDB.SearchReport("MariaFer13");
Assert.AreEqual(1, reportMisConducts.Count);
}
public void TestErrorSearchRepeatNicknamePlayer()
{
QueryDB queryDB = new QueryDB();
bool isRepeatNicknamePlayer;
isRepeatNicknamePlayer = queryDB.SearchRepeatNicknamePlayer(null, "MiroStart");
Assert.IsTrue(isRepeatNicknamePlayer);
}
public void TestSearchRepeatNicknamePlayer()
{
QueryDB queryDB = new QueryDB();
bool isRepeatNicknamePlayer;
isRepeatNicknamePlayer = queryDB.SearchRepeatNicknamePlayer("Maria123", "MiroStart");
Assert.IsTrue(isRepeatNicknamePlayer);
}
public void TestErrorSearchRepeatEmailAccount()
{
QueryDB queryDB = new QueryDB();
bool isRepeatEmailAccount;
isRepeatEmailAccount = queryDB.SearchRepeatEmailAccount("*****@*****.**", 0);
Assert.IsTrue(isRepeatEmailAccount);
}
public void TestErrorSearchPlayer()
{
QueryDB queryDB = new QueryDB();
Player player = new Player();
player = queryDB.SearchPlayer("MarthaStart2563");
Assert.AreEqual("MarthaStart2563", player.nickName);
}
public void TestSearchPlayer()
{
QueryDB queryDB = new QueryDB();
Player player = new Player();
player = queryDB.SearchPlayer("MariaFer13");
Assert.AreEqual("MariaFer13", player.nickName);
}
public IEnumerable <Rating> GetByMovie(long idMovie)
{
QueryDB query = new QueryDB("SELECT * FROM Rating WHERE Id_Movie = @IdMovie");
query.AddParametre("@IdMovie", idMovie);
return(Connector.ExecuteReader(query, ConvertReaderToEntity));
}
public void TestSearchEmailPlayer()
{
QueryDB queryDB = new QueryDB();
bool isEmailPlayer;
isEmailPlayer = queryDB.SearchEmailPlayer("*****@*****.**");
Assert.IsTrue(isEmailPlayer);
}
public void TestSearchNicknamePlayer()
{
QueryDB queryDB = new QueryDB();
bool isNicknamePlayer;
isNicknamePlayer = queryDB.SearchNicknamePlayer("MiroStart");
Assert.IsTrue(isNicknamePlayer);
}
public void TestErrorSearchEmailPlayer()
{
QueryDB queryDB = new QueryDB();
bool isEmailPlayer;
isEmailPlayer = queryDB.SearchEmailPlayer(null);
Assert.IsTrue(isEmailPlayer);
}
public override int Insert(CategoryEntity entity)
{
QueryDB query = new QueryDB("InsertCategory", true);
query.AddParametre("@Name", entity.Name);
return((int)ConnectDB.ExecuteScalar(query));
}
public void TestIsLog()
{
QueryDB queryDB = new QueryDB();
string passwordAccount = Encrypt("Mmol15052000#");
bool isLog = queryDB.IsLog("*****@*****.**", passwordAccount);
Assert.IsTrue(isLog);
}