private void btnLogin_Click(object sender, EventArgs e)
{
using (var db = new RSIJudgingSystemEntities())
{
var judge = db.JudgeProfile.FirstOrDefault(r => r.Username == txtBoxUsername.Text);
if (judge != null)
{
MainWindow form = new MainWindow(judge);
form.Show();
}
else
{
MessageBox.Show("Invalid Username", "Login Error");
}
}
}
public static void SaveTop10(string _beauty, string _intelligence, string _delivery, string judgeNo,
string _contestantNo, out string message)
{
message = "";
try
{
using (var db = new RSIJudgingSystemEntities())
{
if (judgeNo == "1")
{
Top10Judge1 newJ = new Top10Judge1
{
ContestantNo = _contestantNo,
Beauty = decimal.Parse(_beauty),
Delivery = decimal.Parse(_delivery),
Intelligence = decimal.Parse(_intelligence)
};
db.Entry(newJ).State = EntityState.Added;
}
else if (judgeNo == "2")
{
Top10Judge2 newJ = new Top10Judge2
{
ContestantNo = _contestantNo,
Beauty = decimal.Parse(_beauty),
Delivery = decimal.Parse(_delivery),
Intelligence = decimal.Parse(_intelligence)
};
db.Entry(newJ).State = EntityState.Added;
}
else if (judgeNo == "3")
{
Top10Judge3 newJ = new Top10Judge3
{
ContestantNo = _contestantNo,
Beauty = decimal.Parse(_beauty),
Delivery = decimal.Parse(_delivery),
Intelligence = decimal.Parse(_intelligence)
};
db.Entry(newJ).State = EntityState.Added;
}
else if (judgeNo == "4")
{
Top10Judge4 newJ = new Top10Judge4
{
ContestantNo = _contestantNo,
Beauty = decimal.Parse(_beauty),
Delivery = decimal.Parse(_delivery),
Intelligence = decimal.Parse(_intelligence)
};
db.Entry(newJ).State = EntityState.Added;
}
else if (judgeNo == "5")
{
Top10Judge5 newJ = new Top10Judge5
{
ContestantNo = _contestantNo,
Beauty = decimal.Parse(_beauty),
Delivery = decimal.Parse(_delivery),
Intelligence = decimal.Parse(_intelligence)
};
db.Entry(newJ).State = EntityState.Added;
}
else if (judgeNo == "6")
{
Top10Judge6 newJ = new Top10Judge6
{
ContestantNo = _contestantNo,
Beauty = decimal.Parse(_beauty),
Delivery = decimal.Parse(_delivery),
Intelligence = decimal.Parse(_intelligence)
};
db.Entry(newJ).State = EntityState.Added;
}
else if (judgeNo == "7")
{
Top10Judge7 newJ = new Top10Judge7
{
ContestanceNo = _contestantNo,
Beauty = decimal.Parse(_beauty),
Delivery = decimal.Parse(_delivery),
Intelligence = decimal.Parse(_intelligence)
};
db.Entry(newJ).State = EntityState.Added;
}
db.SaveChanges();
}
}
catch (Exception error)
{
message = error.Message;
}
}
public static void SaveRanking(string _personality, string _wit, string _judgeNo, string _contestantNo, out string message)
{
message = "";
try
{
using (var db = new RSIJudgingSystemEntities())
{
if (_judgeNo == "1")
{
RankingJudge1 newTop5 = new RankingJudge1
{
ContestantNo = _contestantNo,
Personality = decimal.Parse(_personality),
Wit = decimal.Parse(_wit)
};
db.Entry(newTop5).State = EntityState.Added;
}
else if (_judgeNo == "2")
{
RankingJudge2 newTop5 = new RankingJudge2
{
ContestantNo = _contestantNo,
Personality = decimal.Parse(_personality),
Wit = decimal.Parse(_wit)
};
db.Entry(newTop5).State = EntityState.Added;
}
else if (_judgeNo == "3")
{
RankingJudge3 newTop5 = new RankingJudge3
{
ContestantNo = _contestantNo,
Personality = decimal.Parse(_personality),
Wit = decimal.Parse(_wit)
};
db.Entry(newTop5).State = EntityState.Added;
}
else if (_judgeNo == "4")
{
RankingJudge4 newTop5 = new RankingJudge4
{
ContestantNo = _contestantNo,
Personality = decimal.Parse(_personality),
Wit = decimal.Parse(_wit)
};
db.Entry(newTop5).State = EntityState.Added;
}
else if (_judgeNo == "5")
{
RankingJudge5 newTop5 = new RankingJudge5
{
ContestantNo = _contestantNo,
Personality = decimal.Parse(_personality),
Wit = decimal.Parse(_wit)
};
db.Entry(newTop5).State = EntityState.Added;
}
else if (_judgeNo == "6")
{
RankingJudge6 newTop5 = new RankingJudge6
{
ContestantNo = _contestantNo,
Personality = decimal.Parse(_personality),
Wit = decimal.Parse(_wit)
};
db.Entry(newTop5).State = EntityState.Added;
}
else if (_judgeNo == "7")
{
RankingJudge7 newTop5 = new RankingJudge7
{
ContestantNo = _contestantNo,
Personality = decimal.Parse(_personality),
Wit = decimal.Parse(_wit)
};
db.Entry(newTop5).State = EntityState.Added;
}
db.SaveChanges();
}
}
catch (Exception error)
{
message = error.Message;
}
}
public static void SaveTop5(string _beauty, string _intelligence, string _poise, string _judgeNo, string _contestantNo, out string message)
{
message = "";
try
{
using (var db = new RSIJudgingSystemEntities())
{
if (_judgeNo == "1")
{
Top5Judge1 j = new Top5Judge1
{
CandidateNo = _contestantNo,
Beauty = decimal.Parse(_beauty),
Intelligence = decimal.Parse(_intelligence),
Poise = decimal.Parse(_poise)
};
db.Entry(j).State = EntityState.Added;
}
else if (_judgeNo == "2")
{
Top5Judge2 j = new Top5Judge2
{
CandidateNo = _contestantNo,
Beauty = decimal.Parse(_beauty),
Intelligence = decimal.Parse(_intelligence),
Poise = decimal.Parse(_poise)
};
db.Entry(j).State = EntityState.Added;
}
else if (_judgeNo == "3")
{
Top5Judge3 j = new Top5Judge3
{
CandidateNo = _contestantNo,
Beauty = decimal.Parse(_beauty),
Intelligence = decimal.Parse(_intelligence),
Poise = decimal.Parse(_poise)
};
db.Entry(j).State = EntityState.Added;
}
else if (_judgeNo == "4")
{
Top5Judge4 j = new Top5Judge4
{
CandidateNo = _contestantNo,
Beauty = decimal.Parse(_beauty),
Intelligence = decimal.Parse(_intelligence),
Poise = decimal.Parse(_poise)
};
db.Entry(j).State = EntityState.Added;
}
else if (_judgeNo == "5")
{
Top5Judge5 j = new Top5Judge5
{
CandidateNo = _contestantNo,
Beauty = decimal.Parse(_beauty),
Intelligence = decimal.Parse(_intelligence),
Poise = decimal.Parse(_poise)
};
db.Entry(j).State = EntityState.Added;
}
else if (_judgeNo == "6")
{
Top5Judge6 j = new Top5Judge6
{
CandidateNo = _contestantNo,
Beauty = decimal.Parse(_beauty),
Intelligence = decimal.Parse(_intelligence),
Poise = decimal.Parse(_poise)
};
db.Entry(j).State = EntityState.Added;
}
else if (_judgeNo == "7")
{
Top5Judge7 j = new Top5Judge7
{
CandidateNo = _contestantNo,
Beauty = decimal.Parse(_beauty),
Intelligence = decimal.Parse(_intelligence),
Poise = decimal.Parse(_poise)
};
db.Entry(j).State = EntityState.Added;
}
db.SaveChanges();
}
}
catch (Exception error)
{
message = error.Message;
}
}
private void GetTop5()
{
using (var db = new RSIJudgingSystemEntities())
{
//var query1 = from c in db.ContestantProfile
// join j in db.Top10Winners on c.ContestantNo equals j.ContestantNo
// //join fj1 in db.Top10Judge1 on c.ContestantNo equals fj1.ContestantNo
// //join fj2 in db.Top10Judge2 on c.ContestantNo equals fj2.ContestantNo
// //join fj3 in db.Top10Judge3 on c.ContestantNo equals fj3.ContestantNo
// //join fj4 in db.Top10Judge4 on c.ContestantNo equals fj4.ContestantNo
// //join fj5 in db.Top10Judge5 on c.ContestantNo equals fj5.ContestantNo
// //join fj6 in db.Top10Judge6 on c.ContestantNo equals fj6.ContestantNo
// //join fj7 in db.Top10Judge7 on c.ContestantNo equals fj7.ContestanceNo
// select new Top5Model
// {
// contestantNo = c.ContestantNo,
// TotalScoreLinq = j.FinalScore
// };
//var top10List1 = query1.OrderByDescending(r => r.TotalScoreLinq).ToList();
//for (int x = 0; x < top10List1.Count; x++)
//{
// if (x >= 10)
// RemoveTab(top10List1[x].contestantNo);
//}
var query = from c in db.ContestantProfile
join j in db.Top5Winners on c.ContestantNo equals j.ContestantNo
//join fj1 in db.Top10Judge1 on c.ContestantNo equals fj1.ContestantNo
//join fj2 in db.Top10Judge2 on c.ContestantNo equals fj2.ContestantNo
//join fj3 in db.Top10Judge3 on c.ContestantNo equals fj3.ContestantNo
//join fj4 in db.Top10Judge4 on c.ContestantNo equals fj4.ContestantNo
//join fj5 in db.Top10Judge5 on c.ContestantNo equals fj5.ContestantNo
//join fj6 in db.Top10Judge6 on c.ContestantNo equals fj6.ContestantNo
//join fj7 in db.Top10Judge7 on c.ContestantNo equals fj7.ContestanceNo
select new Top5Model
{
contestantNo = c.ContestantNo,
panelInterview = c.PanelInterview,
TotalScoreLinq = j.FinalScore
//TotalScoreLinq = j.TotalScore1 + j.TotalScore2 +
//j.TotalScore3 + j.TotalScore4 + j.TotalScore5 +
//j.TotalScore6 + j.TotalScore7
};
var temp = query.OrderByDescending(r => r.TotalScoreLinq).Take(5).ToList();
List <int> tempInt = new List <int>();
temp.ForEach(x =>
{
tempInt.Add(int.Parse(x.contestantNo));
});
for (int x = 1; x <= 20; x++)
{
if (!tempInt.Contains(x))
{
RemoveTab(x.ToString());
}
}
//for(int x = 0; x < temp.Count; x++)
//{
// if (x >= 5)
// {
// RemoveTab(temp[x].contestantNo);
// }
//}
}
}