public string validate_login()
{
int flag;
DataTable dt = new DataTable();
dt = lib.SelectQuery("select * from Tbl_Users where UserName='******' and Password='******'");
if (dt.Rows.Count > 0)
{
if (dt.Rows[0]["status"].ToString() == "0" || dt.Rows[0]["status"].ToString() == string.Empty)
{
flag = lib.InsertQuery("update Tbl_Users set status=1 where UserName='******'");
if (flag == 1)
{
error_flag = string.Empty;
}
else
{
error_flag += "Some problem in database";
}
}
else
{
error_flag += "12:User already loged in.\n";
}
}
else
{
error_flag += "13:No user exist.\n";
}
return(error_flag);
}
public int NextRound(int roundNo, string playername)
{
DataTable dt = new DataTable();
if (CurRound < 4)
{
Flag = lib.InsertQuery("update Tbl_Users set RoundNo='" + roundNo.ToString() + "' where UserName='******'");
if (Flag == 1)
{
dt = lib.SelectQuery("select * from Tbl_Users where RoundNo='" + roundNo.ToString() + "'");
if (dt.Rows.Count == 2)
{
Status = 0;
}
else
{
Status = 1;
}
}
else
{
Status = 1;
}
}
else if (CurRound == 4)
{
CurRound = 4;
Status = 1;
}
return(Status);
}
public string UserStaus()
{
DataTable dt = new DataTable();
dt = lib.SelectQuery("select * from Tbl_Users where status='1' and IsPlaying='active'");
if (dt.Rows.Count > 0)
{
flag += dt.Rows[0]["UserName"].ToString();
}
else
{
//check deactivared users
dt = lib.SelectQuery("select * from Tbl_Users where status='1' and IsPlaying='deactive'");
if (dt.Rows.Count == 2)
{
flag = "Finish";
}
else
{
flag = string.Empty;
}
}
return(flag);
}
public bool Generate_Qestion(int row)
{
if (row >= 4)
{
return(false);
}
else
{
dt = lib.SelectQuery("SELECT TOP 4 * FROM [question-answer]ORDER BY CHECKSUM(NEWID())");
Question = dt.Rows[row]["question"].ToString();
ChoiceA = dt.Rows[row]["A"].ToString();
ChoiceB = dt.Rows[row]["B"].ToString();
ChoiceC = dt.Rows[row]["C"].ToString();
ChoiceD = dt.Rows[row]["D"].ToString();
Category = dt.Rows[row]["cat_id"].ToString();
CorrectAnswer = dt.Rows[row]["answer"].ToString();
return(true);
}
}
public void Onload()
{
DataTable dt = new DataTable();
dt = lib.SelectQuery("select * from Tbl_Users where status='1'");
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
cmb_user.Items.Add(dt.Rows[i]["UserName"].ToString());
}
cmb_user.SelectedIndex = 0;
}
else
{
cmb_user.Items.Add("No acitve users");
txt_Pswd.IsEnabled = false;
btn_logout.IsEnabled = false;
}
}
private void btn_Click(object sender, RoutedEventArgs e)
{
DataTable dt = new DataTable();
DBLib lib = new DBLib();
dt = lib.SelectQuery("select * from Tbl_Users where status='1' and UserName='******'");
if (dt.Rows.Count > 0)
{
GamePlay.GameRounds round = new GamePlay.GameRounds();
round.NextRound(_roundno, txt_username.Text.ToString());
Screens.Game game = new Screens.Game(txt_username.Text);
this.Close();
game.Show();
}
else
{
MessageBox.Show("Invalid User", "Error", MessageBoxButton.OK, MessageBoxImage.Error);
txt_username.Text = string.Empty;
}
}
