public void MyDatabaseTest_ShowAllPlayers() { //1. arrange MyModelContainer container = new MyModelContainer(); db = new MyDatabase(container); //2. act IEnumerable<Player> result = db.ShowAllPlayers().ToList(); //2. assert Assert.AreEqual(11, result.Count()); }
public void MyDatabaseTest_ShowAllPlayersInTeam_Success() { //1. arrange MyModelContainer container = new MyModelContainer(); db = new MyDatabase(container); //2. act IEnumerable<Player> result = db.ShowAllPlayersInTeam("FNATIC"); //2. assert Assert.AreEqual(6, result.Count()); }
public void MyDatabaseTest_ShowAllPlayersInTeam_WrongParam() { //1. arrange MyModelContainer container = new MyModelContainer(); db = new MyDatabase(container); int currentCount = container.Teams.Count(); //2. act IEnumerable<Player> result= db.ShowAllPlayersInTeam("joepie"); //2. assert Assert.IsNull(result); }
public void MyDatabaseTest_AddNewCompetition() { //1. arrange MyModelContainer container = new MyModelContainer(); db = new MyDatabase(container); int currentCount = container.Competitions.Count(); Team[] teams = container.Teams.ToArray(); //Short assert Assert.IsTrue(teams.Length >= 2); //2. act Competition comp = db.AddNewCompetition(teams[0], teams[1], DateTime.Now); //2. assert int newCount = container.Competitions.Count(); Assert.AreEqual(currentCount + 1, newCount); Assert.IsNotNull(comp); Assert.IsNotNull(comp.Id); }
public static void CalculateAllSimilarities(MyDatabase mydb) { List<ArtistInfo> artists = GetArtists(mydb, -1); mydb.newQuery("DELETE FROM ArtistSimilarity"); mydb.ExecuteNonQuery(); Dictionary<KeyValuePair<int, int>, double> totalSimilarity = new Dictionary<KeyValuePair<int, int>, double>(); for (int j = 0; j < MAX_STEPS; ++j) { List<ArtistInfo> prevArtists = new List<ArtistInfo>(); for (int i = 0; i < artists.Count; ++i) { System.Diagnostics.Debug.WriteLine(artists[i].ArtistId + " " + artists[i].ArtistName); Dictionary<int, double> currentSimilarity = CalculateSimilarities(mydb, artists[i], true, prevArtists); foreach (KeyValuePair<int, double> entry in currentSimilarity) { KeyValuePair<int, int> pair = new KeyValuePair<int, int>(entry.Key, artists[i].ArtistId); if (!totalSimilarity.ContainsKey(pair)) totalSimilarity.Add(pair, 0); totalSimilarity[pair] += entry.Value; pair = new KeyValuePair<int, int>(artists[i].ArtistId, entry.Key); if (!totalSimilarity.ContainsKey(pair)) totalSimilarity.Add(pair, 0); totalSimilarity[pair] += entry.Value; } prevArtists.Add(artists[i]); } artists = Shuffle(artists); mydb.newQuery("DELETE FROM ArtistSimilarity"); mydb.ExecuteNonQuery(); } foreach (KeyValuePair<KeyValuePair<int, int>, double> entry in totalSimilarity) StoreSimilarity(mydb, entry.Key.Key, entry.Key.Value, entry.Value / MAX_STEPS); for (int i = 0; i < artists.Count; ++i) StoreSimilarity(mydb, artists[i].ArtistId, artists[i].ArtistId, 1); }
public static Dictionary<int, double> CalculateSimilarities(MyDatabase mydb, ArtistInfo Artist, bool batchMode = false, List<ArtistInfo> prevArtists = null) { if (!batchMode) { mydb.newQuery("DELETE FROM ArtistSimilarity WHERE artist1_id=@artist_id OR artist2_id=@artist_id"); mydb.setParameter("artist_id", Artist.ArtistId); mydb.ExecuteNonQuery(); } Dictionary<String, int> similarArtists = new Dictionary<string, int>(); GetEchonestData(similarArtists, Artist.ArtistName); GetLastFMData(similarArtists, Artist.ArtistName); GetYahooData(similarArtists, Artist.ArtistName); if (!batchMode) prevArtists = GetArtists(mydb, Artist.ArtistId); Dictionary<int, double> similarityNumerator = new Dictionary<int, double>(); Dictionary<int, double> similarityDenominator = new Dictionary<int, double>(); Dictionary<int, double> similarity = new Dictionary<int, double>(); for (int i = 0; i < prevArtists.Count; ++i) { similarityNumerator.Add(prevArtists[i].ArtistId, 0); similarityDenominator.Add(prevArtists[i].ArtistId, 0); if (!similarArtists.ContainsKey(prevArtists[i].ArtistName)) similarity.Add(prevArtists[i].ArtistId, 0); else similarity.Add(prevArtists[i].ArtistId, initialSimilarity(similarArtists[prevArtists[i].ArtistName])); } foreach (KeyValuePair<string, int> entry in similarArtists) { double weight = initialSimilarity(entry.Value); weight *= weight; mydb.newQuery("SELECT s.artist2_id, s.similarity FROM Artist a, ArtistSimilarity s" + " WHERE s.artist1_id = a.artist_id AND a.artist_name=@artist_name AND s.artist2_id!=@artist_id"); mydb.setParameter("artist_name", entry.Key); mydb.setParameter("artist_id", Artist.ArtistId); SqlDataReader reader = mydb.ExecuteReader(); while (reader.Read()) { int artistId = Int32.Parse(reader["artist2_id"].ToString()); double sim = Double.Parse(reader["similarity"].ToString()); similarityNumerator[artistId] += sim * weight; similarityDenominator[artistId] += weight; } } for (int i = 0; i < prevArtists.Count; ++i) { int id = prevArtists[i].ArtistId; similarity[id] += transitiveSimilarity(similarity[id], similarityNumerator[id], similarityDenominator[id]); } for (int i = 0; i < prevArtists.Count; ++i) { StoreSimilarity(mydb, Artist.ArtistId, prevArtists[i].ArtistId, similarity[prevArtists[i].ArtistId]); StoreSimilarity(mydb, prevArtists[i].ArtistId, Artist.ArtistId, similarity[prevArtists[i].ArtistId]); } StoreSimilarity(mydb, Artist.ArtistId, Artist.ArtistId, 1); return similarity; }
public static void StoreSimilarity(MyDatabase mydb, int artist1_id, int artist2_id, double similarity) { mydb.newQuery("INSERT INTO ArtistSimilarity VALUES(@artist1_id, @artist2_id, @similarity)"); mydb.setParameter("artist1_id", artist1_id); mydb.setParameter("artist2_id", artist2_id); mydb.setParameter("similarity", similarity); mydb.ExecuteNonQuery(); }
public SupplementRepository(MyDatabase context) : base(context) { }
public void MyDatabaseTest_UpdateLadder() { //1. arrange MyModelContainer container = new MyModelContainer(); db = new MyDatabase(container); int currentCount = container.Ladders.First().Competitions.Count(); Team[] teams = container.Teams.ToArray(); Competition comp = db.AddNewCompetition(teams[0], teams[1], DateTime.Now); //Short assert Assert.IsTrue(teams.Length >= 2); //2. act db.AddCompetitionToLadder(comp); //2. assert Ladder ladder = container.Ladders.First(); int newCount = container.Ladders.First().Competitions.Count(); Assert.AreEqual(currentCount + 1, newCount); }
public Table1Repository(MyDatabase context) : base(context) { _context = context; }
public ReviewRepository(MyDatabase context) : base(context) { }
public AddressRepository(MyDatabase context) : base(context) { }
public ProductRepository(MyDatabase context) : base(context) { }
public UserRepository(MyDatabase context) : base(context) { }
public GoodController(Brain brain, MyDatabase db) : base(brain, db) { this._table = db.GetTable <Good>("Good"); }
/***************************************************** * - Function name : IncomeExpenseService * - Description : 构造函数 * - Variables : void *****************************************************/ public IncomeExpenseService() { MDB = new MyDatabase(); }
public void doctorsOutput(string a, MyDatabase db) { Console.Clear(); if (ts2 == "5") { Console.Write("Select symbol(<,>,=): "); symbol = Console.ReadLine(); } foreach (var item in db.doctors) { switch (ts2) { default: break; case "1": if (item.Id.ToString() == a) { Console.WriteLine($"Selected ID: {a}"); Console.WriteLine($"ID: {item.Id}\nFirstName: {item.FirstΝame}\nLastName: {item.LastΝame}\nAge: {item.Age}\nSalary: {item.Salary} EURO\n{"---------"}"); } break; case "2": if (item.FirstΝame.ToString() == a) { Console.WriteLine($"Selected FirstName: {a}"); Console.WriteLine($"ID: {item.Id}\nFirstName: {item.FirstΝame}\nLastName: {item.LastΝame}\nAge: {item.Age}\nSalary: {item.Salary} EURO\n{"---------"}"); } break; case "3": if (item.LastΝame.ToString() == a) { Console.WriteLine($"Selected LastName: {a}"); Console.WriteLine($"ID: {item.Id}\nFirstName: {item.FirstΝame}\nLastName: {item.LastΝame}\nAge: {item.Age}\nSalary: {item.Salary} EURO\n{"---------"}"); } break; case "4": if (item.Age.ToString() == a) { Console.WriteLine($"Selected Age: {a}"); Console.WriteLine($"ID: {item.Id}\nFirstName: {item.FirstΝame}\nLastName: {item.LastΝame}\nAge: {item.Age}\nSalary: {item.Salary} EURO\n{"---------"}"); } break; case "5": if (symbol == "=") { if (item.Salary == int.Parse(a)) { Console.WriteLine($"Selected Salary: {a}"); Console.WriteLine($"ID: {item.Id}\nFirstName: {item.FirstΝame}\nLastName: {item.LastΝame}\nAge: {item.Age}\nSalary: {item.Salary} EURO\n{"---------"}"); } } else if (symbol == ">") { if (item.Salary > int.Parse(a)) { Console.WriteLine($"Selected Salary: {a}"); Console.WriteLine($"ID: {item.Id}\nFirstName: {item.FirstΝame}\nLastName: {item.LastΝame}\nAge: {item.Age}\nSalary: {item.Salary} EURO\n{"---------"}"); } } else if (symbol == "<") { if (item.Salary < int.Parse(a)) { Console.WriteLine($"Selected Salary: {a}"); Console.WriteLine($"ID: {item.Id}\nFirstName: {item.FirstΝame}\nLastName: {item.LastΝame}\nAge: {item.Age}\nSalary: {item.Salary} EURO\n{"---------"}"); } } break; } } back(); }
public List <Movie.Entities.Movie> GetMovies() { MyDatabase db = new MyDatabase(); return(db.Movies); //m1 , m2 ,m3 }
public void MyDatabaseTest_ShowAllTeams() { //1. arrange MyModelContainer container = new MyModelContainer(); db = new MyDatabase(container); //2. act IEnumerable<Team> result = db.ShowAllTeams(); //2. assert Assert.AreEqual(2, result.Count()); }
public static List<ArtistInfo> GetArtists(MyDatabase mydb, int ArtistId) { List<ArtistInfo> artists = new List<ArtistInfo>(); mydb.newQuery("SELECT artist_id, artist_name from Artist WHERE artist_id != @artist_id"); mydb.setParameter("artist_id", ArtistId); SqlDataReader reader = mydb.ExecuteReader(); while (reader.Read()) { int artistId = Int32.Parse(reader["artist_id"].ToString()); string artistName = reader["artist_name"].ToString(); artists.Add(new ArtistInfo(artistId, artistName)); } return artists; }
protected void Page_Load(object sender, EventArgs e) { try { string connStr = ConfigurationManager.ConnectionStrings["conStrProd"].ConnectionString; XDocument xdoc = XDocument.Load("C:/BCBS_Horizon_Data/MultiFlight_SABKLCNT_Test.XML"); List<ClientData> clientdata = (from cntry in xdoc.Element("BatchRequests").Elements("BatchRequest") select new ClientData { //RowID = Convert.ToInt32( cntry.Element("ClientTransactionID").Value), ClientTransactionID = cntry.Element("ClientTransactionID").Value, DocumentDate = cntry.Element("DocumentDate").Value, BatchID = cntry.Element("BatchID").Value, TransactionNo = cntry.Element("TransactionNo").Value, ProductName = cntry.Element("ProductName").Value, BusinessName = cntry.Element("BusinessName").Value, CompanyName = cntry.Element("CompanyName").Value, flights = (from ste in cntry.Element("MailPiece").Elements("Flight") select new Flight { FlightNumber = (string)ste.Element("FlightNumber"), Bind = (string)ste.Element("Bind"), InsertCode1 = (string)ste.Element("InsertCode1"), FileName = (string)ste.Element("Files").Element("Filename"), SequenceOrder = (string)ste.Element("Files").Element("SequenceOrder") }).ToList(), receipts = (from ste in cntry.Element("MailPiece").Elements("MailingInfo").Elements("RecipientInfo") select new Receipt { NumberOfCopy = (string)ste.Element("NumberOfCopy").Value, NameLine1 = (string)ste.Element("NameLine1").Value, NameLine2 = (string)ste.Element("NameLine2").Value, AddressLine1 = (string)ste.Element("AddressLine1").Value, AddressLine2 = (string)ste.Element("AddressLine2").Value, city = (string)ste.Element("city").Value, state = (string)ste.Element("State").Value, zip = (string)ste.Element("Zip").Value, GroupNo = (string)ste.Element("GroupNo").Value, FullName = (string)ste.Element("FullName").Value, SubscriberID = (string)ste.Element("SubscriberID").Value, EffectiveDate = (string)ste.Element("EffectiveDate").Value, ContractType = (string)ste.Element("ContractType").Value }).ToList() }).ToList(); MyDatabase db = new MyDatabase(); foreach (var co in clientdata) { Console.WriteLine(co.ClientTransactionID); db.BatchDataXML.InsertOnSubmit(co); db.SubmitChanges(); foreach (var st in co.flights) { st.ClientTransactionID = co.ClientTransactionID; db.BatchDetail_Flight.InsertOnSubmit(st); db.SubmitChanges(); Console.WriteLine(st.FileName); } foreach (var st in co.receipts) { st.ClientTransactionID = co.ClientTransactionID; db.BatchDetail_Receipt.InsertOnSubmit(st); db.SubmitChanges(); //Console.WriteLine(st.FileName); } } } catch (Exception ex) { } }
public CommentHandlers(MyDatabase db) { _db = db; }