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