public void TestDelMatch()
{
DalManager m_data = DalManager.Instance;
Jedi jedi1 = new Jedi(18, "Jedi 1", false, null, "");
Jedi jedi2 = new Jedi(68, "Jedi 2", true, null, "");
Stade stade = new Stade(42, "Test 4", 42000, "Tata Ouine", null, null);
m_data.addJedi(jedi1);
m_data.addJedi(jedi2);
m_data.addStade(stade);
List <Stade> list1 = m_data.getAllStades().Where(s => s.Nom == stade.Nom && s.NbPlaces == stade.NbPlaces && s.Planete == stade.Planete).ToList();
List <Jedi> list2 = m_data.getAllJedis().Where(j => (j.Nom == jedi1.Nom || j.Nom == jedi2.Nom)).ToList();
Match toto = new Match(42, list2.ElementAt(0), list2.ElementAt(1), EPhaseTournoi.Finale, list1.ElementAt(0));
m_data.addMatch(toto);
List <Match> list = m_data.getAllMatchs().Where(m => m.Jedi1.ID == list2.ElementAt(0).ID&& m.Jedi2.ID == list2.ElementAt(1).ID&& m.Stade.ID == list1.ElementAt(0).ID).ToList();
m_data.delMatch(list.ElementAt(0));
m_data.delStade(list1.ElementAt(0));
m_data.delJedi(list2.ElementAt(0));
m_data.delJedi(list2.ElementAt(1));
List <Match> list4 = m_data.getAllMatchs().Where(m => m.Jedi1.ID == list2.ElementAt(0).ID&& m.Jedi2.ID == list2.ElementAt(1).ID&& m.Stade.ID == list1.ElementAt(0).ID).ToList();
Assert.IsTrue(!list4.Any(m => string.IsNullOrEmpty(m.Jedi1.Nom)));
}
/// <summary>
/// Configures container. Initializes Services
/// </summary>
protected override void Configure()
{
//NEW UP CONTAINER
_Container = new CompositionContainer();
//CREATE ASSEMBLY CATALOGS FOR COMPOSITION OF APPLICATION (WPF)
AssemblyCatalog catThis = new AssemblyCatalog(typeof(MefBootstrapper).Assembly);
AssemblyCatalog catBusiness = new AssemblyCatalog(typeof(Customer).Assembly);
AssemblyCatalog catDal = new AssemblyCatalog(typeof(DalManager).Assembly);
AssemblyCatalog catWcfClient = new AssemblyCatalog(typeof(CustomerDalProxy).Assembly);
AggregateCatalog catAll = new AggregateCatalog(catThis, catBusiness, catDal, catWcfClient);
_Container = new CompositionContainer(catAll);
//ADD BATCH FOR SERVICES TO CONTAINER, INCLUDING CONTAINER ITSELF
var batch = new CompositionBatch();
batch.AddExportedValue <IWindowManager>(new WindowManager());
batch.AddExportedValue <IEventAggregator>(new EventAggregator());
batch.AddExportedValue(_Container);
_Container.Compose(batch);
//INITIALIZE SERVICES
Services.Initialize(_Container);
//INITIALIZE DALMANAGER
DalManager.Initialize(_Container);
}
public void TestCreateDeleteStades()
{
DalManager manager = new DalManager();
List <Stade> list1 = manager.getStades();
Stade newStade = new Stade(12, 1000, "PlaneteTest", null);
manager.InsertStade(newStade);
List <Stade> listTemp = list1;
listTemp.Add(newStade);
List <Stade> list2 = manager.getStades();
Assert.AreEqual(listTemp.Count, list2.Count);
Assert.AreEqual(list1[listTemp.Count - 1].ID, list2[list2.Count - 1].ID);
Assert.AreEqual(list1[listTemp.Count - 1].NbPlaces, list2[list2.Count - 1].NbPlaces);
Assert.AreEqual(list1[listTemp.Count - 1].Planete, list2[list2.Count - 1].Planete);
manager.DeleteStades(newStade);
list2 = manager.getStades();
Assert.AreEqual(list1.Count, list2.Count);
Assert.AreEqual(list1[list1.Count - 1].ID, list2[list2.Count - 1].ID);
Assert.AreEqual(list1[list1.Count - 1].NbPlaces, list2[list2.Count - 1].NbPlaces);
Assert.AreEqual(list1[list1.Count - 1].Planete, list2[list2.Count - 1].Planete);
}
public void TestUpdateStades()
{
DalManager manager = new DalManager();
List <Stade> list1 = manager.getStades();
Stade updatedStade = list1[0];
updatedStade.NbPlaces = 1000;
updatedStade.Planete = "PlanetTest";
manager.UpdateStade(updatedStade); //Modification du premier Stade
List <Stade> list2 = manager.getStades();
//Assert.AreEqual(updatedStade, list2[0]); //Test si le premier Stade à bien été modifié
Assert.AreEqual(updatedStade.ID, list2[0].ID);
Assert.AreEqual(updatedStade.NbPlaces, list2[0].NbPlaces);
Assert.AreEqual(updatedStade.Planete, list2[0].Planete);
updatedStade.NbPlaces = list1[0].NbPlaces;
updatedStade.Planete = list1[0].Planete;
manager.UpdateStade(updatedStade); //Reinitialisation du premier Stade
list2 = manager.getStades();
//Assert.AreEqual(list1, list2); //Test si le stade est bien réinitialisé
Assert.AreEqual(list1[list1.Count - 1].ID, list2[0].ID);
Assert.AreEqual(list1[list1.Count - 1].NbPlaces, list2[0].NbPlaces);
Assert.AreEqual(list1[list1.Count - 1].Planete, list2[0].Planete);
}
public void TestCreateDeleteJedis()
{
DalManager manager = new DalManager();
List <Jedi> list1 = manager.getJedis();
Jedi newJedi = new Jedi(12, "JediTest", true, null);
manager.InsertJedi(newJedi);
List <Jedi> listTemp = list1;
listTemp.Add(newJedi);
List <Jedi> list2 = manager.getJedis();
Assert.AreEqual(listTemp.Count, list2.Count);
Assert.AreEqual(list1[listTemp.Count - 1].ID, list2[list2.Count - 1].ID);
Assert.AreEqual(list1[listTemp.Count - 1].IsSith, list2[list2.Count - 1].IsSith);
Assert.AreEqual(list1[listTemp.Count - 1].Nom, list2[list2.Count - 1].Nom);
manager.DeleteJedis(newJedi);
list2 = manager.getJedis();
Assert.AreEqual(list1.Count, list2.Count);
Assert.AreEqual(list1[list1.Count - 1].ID, list2[list2.Count - 1].ID);
Assert.AreEqual(list1[list1.Count - 1].IsSith, list2[list2.Count - 1].IsSith);
Assert.AreEqual(list1[list1.Count - 1].Nom, list2[list2.Count - 1].Nom);
}
public void TestUpdateJedis()
{
DalManager manager = new DalManager();
List <Jedi> list1 = manager.getJedis();
Jedi updatedJedi = list1[0];
updatedJedi.IsSith = true;
updatedJedi.Nom = "JediTest";
manager.UpdateJedi(updatedJedi); //Modification du premier Jedi
List <Jedi> list2 = manager.getJedis();
//Assert.AreEqual(updatedJedi, list2[0]); //Test si le premier Jedi à bien été modifié
Assert.AreEqual(list1.Count, list2.Count);
Assert.AreEqual(updatedJedi.ID, list2[0].ID);
Assert.AreEqual(updatedJedi.IsSith, list2[0].IsSith);
Assert.AreEqual(updatedJedi.Nom, list2[0].Nom);
updatedJedi.IsSith = list1[0].IsSith;
updatedJedi.Nom = list1[0].Nom;
manager.UpdateJedi(updatedJedi); //Reinitialisation du premier Jedi
list2 = manager.getJedis();
//Assert.AreEqual(list1, list2); //Test si le jedi est bien réinitialisé
Assert.AreEqual(list1.Count, list2.Count);
Assert.AreEqual(list1[list1.Count - 1].ID, list2[0].ID);
Assert.AreEqual(list1[list1.Count - 1].IsSith, list2[0].IsSith);
Assert.AreEqual(list1[list1.Count - 1].Nom, list2[0].Nom);
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (this.ruleTestControl.IsEmpty || !this.ruleTestControl.IsValid)
{
return;
}
// string file = Server.MapPath("/Rules/Rule.config");
string ruleXml = this.ruleTestControl.GetRuleXml();
// File.WriteAllText(file, rule);
// string ruleText = ruleTestControl.GetClientRuleData();
string ruleText = ruleTestControl.ToString();
TMRule rule = new TMRule();
rule.RuleName = txtRuleName.Text.Trim();
rule.RuleType = ddlEntity.Text;
rule.RuleText = ruleText;
rule.RuleXml = ruleXml;
rule.RuleDescription = txtDescription.Text.Trim();
rule.ExecutionOrder = int.Parse(txtExecOrder.Text);
bool result = DalManager.InsertRule(rule);
ruleTestControl.Clear();
txtDescription.Text = "";
txtExecOrder.Text = "";
txtRuleName.Text = "";
BindData();
}
public void getStadeTest()
{
DalManager manager = new DalManager();
List <Stade> list = manager.getStades();
Console.WriteLine(list.Count);
}
public void getJediTest()
{
DalManager manager = new DalManager();
List <Jedi> list = manager.getJedis();
Console.WriteLine(list.Count);
}
public bool CheckConnexionUser(string login, string password)
{
DalManager dal = new DalManager();
Utilisateur user;
user = dal.GetUtilisateurByLogin(login);
return(user.Password == password);
}
static public void displayAllStades()
{
DalManager dm = new DalManager();
List<Stade> l = dm.GetAllStades();
foreach(Stade s in l)
{
Console.Out.WriteLine(s);
}
}
public IEnumerable <string> AfficheStade()
{
IEnumerable <string> stringStade;
List <Stade> listStade;
DalManager dal = new DalManager();
listStade = dal.GetStade();
stringStade = from stade in listStade select stade.Planete;
return(stringStade);
}
public IEnumerable <string> AfficheSith()
{
IEnumerable <string> stringSith;
List <Jedi> listJedi;
DalManager dal = new DalManager();
listJedi = dal.GetJedi();
stringSith = from sith in listJedi where sith.IsSith == true select sith.Nom;
return(stringSith);
}
public bool CheckConnexionUser(string username, string password)
{
Utilisateur user = DalManager.GetUtilisateurByLogin(username);
if (user != null && user.Password == password)
{
return(true);
}
return(false);
}
public IEnumerable <string> ListMatch()
{
List <Match> listMatch;
DalManager dal = new DalManager();
listMatch = dal.GetMatch();
IEnumerable <string> stringMatch;
stringMatch = from match in listMatch select match.Jedi1.Nom;
return(stringMatch);
}
public IEnumerable <string> ListJedi()
{
List <Jedi> listJedi;
DalManager dal = new DalManager();
listJedi = dal.GetJedi();
IEnumerable <string> stringJedi;
stringJedi = from jedi in listJedi select jedi.Nom;
return(stringJedi);
}
public IEnumerable <string> ListCaracteristiques()
{
List <Caracteristiques> listCaracteristique;
DalManager dal = new DalManager();
listCaracteristique = dal.GetCaracteristiques();
IEnumerable <string> stringCaracteristique;
stringCaracteristique = from carac in listCaracteristique select carac.Nom;
return(stringCaracteristique);
}
public void TestAddJedi()
{
Jedi toto = new Jedi(42, "Jedi Toto", false, null, "");
DalManager m_data = DalManager.Instance;
m_data.addJedi(toto);
List <Jedi> list = m_data.getAllJedis().Where(j => j.Nom == toto.Nom).ToList();
Assert.AreEqual(toto.Nom, list.ElementAt(0).Nom);
Assert.AreEqual(toto.IsSith, list.ElementAt(0).IsSith);
m_data.delJedi(list.ElementAt(0));
}
private void BindData()
{
List <TMRuleResult> ruleResults = new List <TMRuleResult>();
ruleResults = DalManager.GetRuleResults(DateTime.Now, 0);
GridView1.DataSource = ruleResults;
GridView1.DataBind();
GridView2.DataSource = ruleResults;
GridView2.DataBind();
}
public IEnumerable <string> AfficheMatchDuSiecle()
{
IEnumerable <string> stringMatchDuSiecle;
List <Match> listMatch;
DalManager dal = new DalManager();
listMatch = dal.GetMatch();
stringMatchDuSiecle = from match in listMatch
where match.Stade.NbPlaces > 3 && match.Jedi1.IsSith == true && match.Jedi2.IsSith == true
select match.Stade.Planete;
return(stringMatchDuSiecle);
}
public IEnumerable <string> AfficheJediFort()
{
IEnumerable <string> stringJediFort;
List <Jedi> listJedi;
DalManager dal = new DalManager();
listJedi = dal.GetJedi();
stringJediFort = from jedifort in listJedi
where jedifort.Carac[0].Valeur > 3 && jedifort.Carac[2].Valeur > 50
select jedifort.Nom;
return(stringJediFort);
}
public List <ViewModelMatch> getAllMatchModel()
{
List <ViewModelMatch> list = new List <ViewModelMatch>();
var manager = new DalManager();
var matches = manager.GetMatch();
foreach (Match matchs in matches)
{
list.Add(new ViewModelMatch(matchs));
}
return(list);
}
public List <ViewModelStade> getAllStadeModel()
{
List <ViewModelStade> list = new List <ViewModelStade>();
var manager = new DalManager();
var stades = manager.GetStade();
foreach (Stade stads in stades)
{
list.Add(new ViewModelStade(stads));
}
return(list);
}
public List <ViewModelJedi> getAllJediModel()
{
List <ViewModelJedi> list = new List <ViewModelJedi>();
var manager = new DalManager();
var jedis = manager.GetJedi();
foreach (Jedi jeds in jedis)
{
list.Add(new ViewModelJedi(jeds));
}
return(list);
}
public void TestAddStade()
{
Stade toto = new Stade(42, "Test", 42000, "Tata Ouine", null, null);
DalManager m_data = DalManager.Instance;
m_data.addStade(toto);
List <Stade> list = m_data.getAllStades().Where(s => s.Nom == toto.Nom && s.NbPlaces == toto.NbPlaces && s.Planete == toto.Planete).ToList();
Assert.AreEqual(toto.Nom, list.ElementAt(0).Nom);
Assert.AreEqual(toto.NbPlaces, list.ElementAt(0).NbPlaces);
Assert.AreEqual(toto.Planete, list.ElementAt(0).Planete);
m_data.delStade(list.ElementAt(0));
}
public void TestDelCaracs()
{
Caracteristique carac = new Caracteristique(1, "Test", EDefCaracteristique.Force, ETypeCaracteristique.Jedi, 42);
DalManager m_data = DalManager.Instance;
m_data.addCarac(carac);
List <Caracteristique> list = m_data.getAllCaracs().Where(c => c.Nom == carac.Nom && c.Definition == carac.Definition && c.Type == carac.Type && c.Valeur == carac.Valeur).ToList();
m_data.delCarac(list.ElementAt(0));
List <Caracteristique> list2 = m_data.getAllCaracs().Where(c => c.Nom == carac.Nom && c.Definition == carac.Definition && c.Type == carac.Type && c.Valeur == carac.Valeur).ToList();
Assert.IsTrue(!list2.Any(c => string.IsNullOrEmpty(c.Nom)));
}
public void TestDelJedi()
{
Jedi toto = new Jedi(42, "Jedi Toto", false, null, "");
DalManager m_data = DalManager.Instance;
m_data.addJedi(toto);
List <Jedi> list = m_data.getAllJedis().Where(j => j.Nom == toto.Nom).ToList();
m_data.delJedi(list.ElementAt(0));
List <Jedi> list2 = m_data.getAllJedis().Where(j => j.Nom == toto.Nom).ToList();
Assert.IsTrue(!list2.Any(j => string.IsNullOrEmpty(j.Nom)));
}
public void TestAddCarac()
{
Caracteristique carac = new Caracteristique(1, "Test", EDefCaracteristique.Force, ETypeCaracteristique.Jedi, 42);
DalManager m_data = DalManager.Instance;
m_data.addCarac(carac);
List <Caracteristique> list = m_data.getAllCaracs().Where(c => c.Nom == carac.Nom && c.Definition == carac.Definition && c.Type == carac.Type && c.Valeur == carac.Valeur).ToList();
Assert.AreEqual(carac.Nom, list.ElementAt(0).Nom);
Assert.AreEqual(carac.Definition, list.ElementAt(0).Definition);
Assert.AreEqual(carac.Type, list.ElementAt(0).Type);
Assert.AreEqual(carac.Valeur, list.ElementAt(0).Valeur);
m_data.delCarac(list.ElementAt(0));
}
private void BindData()
{
List <TMRule> rules = new List <TMRule>();
rules = DalManager.GetRules("OPTION");
grdRules.DataSource = rules;
grdRules.Update();
List <string> logs = new List <string>();
logs = DalManager.GetLogs("EXEC");
grdLog.DataSource = logs;
grdLog.Update();
}
public void TestDelStade()
{
Stade toto = new Stade(42, "Test", 42000, "Tata Ouine", null, null);
DalManager m_data = DalManager.Instance;
m_data.addStade(toto);
List <Stade> list = m_data.getAllStades().Where(s => s.Nom == toto.Nom && s.NbPlaces == toto.NbPlaces && s.Planete == toto.Planete).ToList();
m_data.delStade(list.ElementAt(0));
List <Stade> list2 = m_data.getAllStades().Where(s => s.Nom == toto.Nom && s.NbPlaces == toto.NbPlaces && s.Planete == toto.Planete).ToList();
Assert.IsTrue(!list2.Any(s => string.IsNullOrEmpty(s.Nom)));
}
/// <summary>
/// Executes the SP.
/// </summary>
/// <returns>spResult object</returns>
public spResult ExecuteSP(int accountID)
{
var myData = new DalManager();
var myResult = new spR_Get_Account_Info_by_AccountID_Result();
if (myData.GetConnection(out _mySQLConn)) return null;
try
{
using (var myAccessCommand = new SqlCommand(_storedProcedureName, _mySQLConn))
{
myAccessCommand.CommandType = System.Data.CommandType.StoredProcedure;
myAccessCommand.Parameters.AddWithValue("@AccountID", accountID);
_mySQLConn.Open();
using (var dr = new SafeDataReader(myAccessCommand.ExecuteReader()))
{
var rdrResult = Mapper.Map<List<RenterAccountDTO>>(dr);
_myDTO = rdrResult.FirstOrDefault();
myResult.RowsReturned = rdrResult.Count;
// Get the next resultset (Cards) from the DataReader
dr.NextResult();
LoadRenterData(dr);
dr.NextResult();
LoadAddresses(dr);
dr.NextResult();
LoadContactInfoItems(dr);
myResult.ResultSet = _myDTO;
}
}
return myResult;
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Error: Failed to act on the data in the DataBase.\n{0}", ex.Message);
myResult.ErrorMessage = CreateUIMessage(ex.Message);
return myResult;
}
finally
{
_mySQLConn.Close();
}
}
/// <summary>
/// Executes the SP.
/// </summary>
/// <returns>spResult object</returns>
public spResult ExecuteSP()
{
var myData = new DalManager();
var myResult = new spR_Get_AddressTypes_List_Result();
if (myData.GetConnection(out _mySQLConn)) return null;
try
{
using (var myAccessCommand = new SqlCommand(_storedProcedureName, _mySQLConn))
{
myAccessCommand.CommandType = System.Data.CommandType.StoredProcedure;
var myCount = myAccessCommand.Parameters.Count;
_mySQLConn.Open();
using (var dr = new SafeDataReader(myAccessCommand.ExecuteReader()))
{
var rdrResult = Mapper.Map<List<AddressTypeDTO>>(dr);
myResult.RowsReturned = rdrResult.Count;
// Get the next resultset (Cards) from the DataReader
// dr.NextResult();
// LoadCardData(dr);
myResult.ResultSet = rdrResult;
}
}
return myResult;
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Error: Failed to act on the data in the DataBase.\n{0}", ex.Message);
myResult.ErrorMessage = CreateUIMessage(ex.Message);
return myResult;
}
finally
{
_mySQLConn.Close();
}
}
/// <summary>
/// Executes the SP.
/// </summary>
/// <returns>spResult object</returns>
public spResult ExecuteSP(mmDTObase myDTO)
{
var myData = new DalManager();
var myResult = new spR_Insert_Renter_Result();
if (myData.GetConnection(out _mySQLConn)) return null;
try
{
using (var myAccessCommand = new SqlCommand(_storedProcedureName, _mySQLConn))
{
myAccessCommand.CommandType = System.Data.CommandType.StoredProcedure;
//Get the Address parms for sure
var concDTO = (RenterAccountDTO)myDTO;
var address = concDTO.Renter.Addresses[0];
var myAddresStuff = DataMapper.CreateCriteriaParameters(address);
foreach (SqlParameter parm in myAddresStuff)
{
if (parm.ParameterName.Length > 0)
{
myAccessCommand.Parameters.Add(parm);
System.Diagnostics.Debug.WriteLine("Parameter: " + parm.ParameterName + " - Value: " + parm.Value);
}
}
var phone = concDTO.Renter.ContactInfoItems[0];
myAccessCommand.Parameters.AddWithValue("@Phone", phone.ContactInfoItem);
myAccessCommand.Parameters.AddWithValue("@ContactType", phone.ContactInfoTypeID);
var myStuff = DataMapper.CreateCriteriaParameters(concDTO.Renter);
foreach (SqlParameter parm in myStuff)
{
if (parm.ParameterName.Length > 0)
{
myAccessCommand.Parameters.Add(parm);
System.Diagnostics.Debug.WriteLine("Parameter: " + parm.ParameterName + " - Value: " + parm.Value);
}
}
var query = from SqlParameter myparm in myAccessCommand.Parameters
where myparm.ParameterName == "@RenterID"
select myparm;
var outParm = query.FirstOrDefault();
outParm.DbType = System.Data.DbType.Int32;
outParm.Direction = System.Data.ParameterDirection.Output;
outParm.ParameterName = "@AccountID";
myAccessCommand.Parameters.AddWithValue("@UserID", concDTO.Renter.CreateUserID);
var myCount = myAccessCommand.Parameters.Count;
_mySQLConn.Open();
myResult.RowsReturned = myAccessCommand.ExecuteNonQuery();
concDTO.Renter.RenterID = (int)myAccessCommand.Parameters["@AccountID"].Value;
}
return myResult;
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Error: Failed to act on the data in the DataBase.\n{0}", ex.Message);
myResult.ErrorMessage = CreateUIMessage(ex.Message);
return myResult;
}
finally
{
_mySQLConn.Close();
}
}
