//select Phase table
public List<Phase> GetPhase()
{
List<Phase> PhaseList = new List<Phase>();
string query = "SELECT [Contest_ID],[Phase_ID],[Phase_Name],[Phase_Score],[Phase_Minus],[Phase_Time],[Sequence]"
+" FROM [Phase]";
DataTable dt = DA.SelectDatabase(query);
//int i = 1;
if (dt!= null)
{
foreach (DataRow item in dt.Rows)
{
Phase Phase = new Phase();
Phase.IDContest = Convert.ToInt32(item["Contest_ID"].ToString());
Phase.IDPhase = Convert.ToInt32(item["Phase_ID"].ToString());
Phase.NamePhase = item["Phase_Name"].ToString();
Phase.ScorePhase = Convert.ToInt32(item["Phase_Score"].ToString());
Phase.MinusPhase = Convert.ToInt32(item["Phase_Minus"].ToString());
Phase.TimePhase = Convert.ToInt32(item["Phase_Time"].ToString());
Phase.Sequence = Convert.ToInt32(item["Sequence"].ToString());
PhaseList.Add(Phase);
//i++;
}
}
return PhaseList;
}
//Edit Phase
public bool EditPhasebyID(Phase Phase)
{
string query = "UPDATE [Phase]"
+ " SET [Contest_ID] ='" + Phase.IDContest + "',[Phase_Name] ='" + Phase.NamePhase + "', [Phase_Score] ='" + Phase.ScorePhase + "'"
+ ",[Phase_Minus] ='" + Phase.MinusPhase + "', [Phase_Time]='" + Phase.TimePhase + "', [Sequence]='" + Phase.Sequence + "'"
+ " WHERE [Phase_ID] = '" + Phase.IDPhase + "'";
return DA.UpdateDatabase(query);
}
public Contest()
{
round = new Round();
competition = new Competition();
phase = new Phase();
player = new Player();
playerList = new List<Player>();
}
//Insert Phase
public bool AddPhase(Phase Phase)
{
string query = "INSERT INTO [Phase]"
+ "([Contest_ID],[Phase_Name],[Phase_Score],[Phase_Minus],[Phase_Time],[Sequence])"
+" VALUES ('" + Phase.IDContest + "','" + Phase.NamePhase + "',"
+ "'" + Phase.ScorePhase + "','" + Phase.MinusPhase + "','" + Phase.TimePhase + "','" + Phase.Sequence + "')";
if (DA.InsertDatabase(query))
{
return true;
}
else
{
return false;
}
}
public bool checkDuplicate()
{
Phase phase = new Phase();
phase.IDContest = idContest;
PhaseQuestionBL PhaseQuestionBL = new PhaseQuestionBL();
List<Phase> ListPhase;
ListPhase = PhaseQuestionBL.getquestionByIDContest(phase);
int count = 0;
foreach (DataGridViewRow row in dgv_Question.Rows)
{
if (row.Cells["Check"].Value != null && (bool)row.Cells["Check"].Value == true)
{
if (ListPhase != null)
{
for (int i = 0; i < ListPhase.Count; i++)
{
if (ListPhase.ElementAt(i).IDQuestion == Convert.ToInt32(row.Cells["IDQuestion"].Value))
{
row.DefaultCellStyle.BackColor = Color.LightCoral;
count++;
}
}
}
}
}
if (count == 0)
{
return false;
}
else
{
return true;
}
}
//Delete Phase
public bool DeletePhasebyIDPhase(Phase Phase)
{
string query = "DELETE FROM [Phase]"
+ " WHERE [Phase_ID] = '" + Phase.IDPhase + "'";
return DA.DeleteDatabase(query);
}
//Get phase normal in flow by id contest
public List<Phase> GetPhaseNormal(Phase phase)
{
List<Phase> PhaseList = new List<Phase>();
string query = "SELECT [Phase_ID],[Contest_ID],[Phase_Name],[Phase_Score],[Phase_Minus],[Phase_Time],[Sequence]"
+ " FROM [Phase]"
+ " WHERE [Contest_ID] = '" + phase.IDContest + "' AND [Sequence] >= 0 ORDER BY [Sequence] ASC";
DataTable dt = DA.SelectDatabase(query);
if (dt != null)
{
foreach (DataRow item in dt.Rows)
{
Phase Phase = new Phase();
Phase.IDContest = Convert.ToInt32(item["Contest_ID"].ToString());
Phase.IDPhase = Convert.ToInt32(item["Phase_ID"].ToString());
Phase.NamePhase = item["Phase_Name"].ToString();
Phase.ScorePhase = Convert.ToInt32(item["Phase_Score"].ToString());
Phase.MinusPhase = Convert.ToInt32(item["Phase_Minus"].ToString());
Phase.TimePhase = Convert.ToInt32(item["Phase_Time"].ToString());
Phase.Sequence = Convert.ToInt32(item["Sequence"].ToString());
PhaseList.Add(Phase);
}
}
return PhaseList;
}
private void deleteSetupToolStripMenuItem_Click(object sender, EventArgs e)
{
DialogResult dialogResult = MessageBox.Show("Bạn muốn xóa cuộc thi này không?", "Xóa Thiết Đặt", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
Contest Contest = new Contest();
Phase Phase = new Phase();
Player Player = new Player();
Record Record = new Record();
ContestBL ContestBL = new ContestBL();
PhaseBL PhaseBl = new PhaseBL();
PlayerBL PlayerBL = new PlayerBL();
PhaseQuestionBL PhaseQuestionBL = new PhaseQuestionBL();
RecordBL RecordBL = new RecordBL();
Contest.IDContest = Convert.ToInt32(lbl_IDContest.Text);
Phase.IDContest = Convert.ToInt32(lbl_IDContest.Text);
Player.IDContest = Convert.ToInt32(lbl_IDContest.Text);
Record.IDContest = Convert.ToInt32(lbl_IDContest.Text);
RecordBL.DeleteRecordByIDContest(Record);
PhaseQuestionBL.DeletePhaseQuestionbyIDContest(Phase);
PlayerBL.DeletePlayerbyIDContest(Player);
PhaseBl.DeletePhasebyIDContest(Phase);
ContestBL.DeleteContestbyID(Contest);
LoadAll();
EventHandler delete = onDelete;
if (delete != null)
{
MyEventArgs args = new MyEventArgs();
args.IDNewGame = iD_NewGame;
delete(this, args);
}
}
}
//Copy Question
public void CopyQuestion()
{
Phase Phase = new Phase();
PhaseQuestionBL PhaseQuestionBL = new PhaseQuestionBL();
foreach (DataGridViewRow row in dgv_Question.Rows)
{
if (row.Cells["Check"].Value != null && (bool)row.Cells["Check"].Value == true)
{
Phase.IDPhase = idPhase;
Phase.IDContest = idContest;
//Phase.Question.IDQuestion = Convert.ToInt32(row.Cells["IDQuestion"].Value);
Phase.IDQuestion = Convert.ToInt32(row.Cells["IDQuestion"].Value);
Phase.Status = 1;
PhaseQuestionBL.AddPhaseQuestion(Phase);
}
}
}
