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