private void Getamount()
{
SqlInterface sq;
sq = new SqlInterface(connection);
DataTable Dtbalce = sq.Select("select balance from account");
if (Dtbalce.Rows.Count != 0)
{
lblbalance.Text = Dtbalce.Rows[0]["balance"].ToString() + "\t" + "SR";
}
}
private void filldata()
{
SqlInterface sq;
sq = new SqlInterface(connection);
DataTable Dtpost = sq.Select("select * from recommendedplaces");
if (Dtpost.Rows.Count != 0)
{
try
{
Datalistuser.DataSource = Dtpost;
Datalistuser.DataBind();
}
catch { }
}
}
protected void RegisterUser_Click(object sender, EventArgs e)
{
SqlInterface sq;
sq = new SqlInterface(connection);
bool username = false;
bool email = false;
DataTable DTgetusername = sq.Select("select * from Customer where Username='******'");
if (DTgetusername.Rows.Count != 0)
{
username = true;
}
DataTable DTgetemail = sq.Select("select * from Customer where Email='" + txtEmailr.Text + "'");
if (DTgetemail.Rows.Count != 0)
{
email = true;
}
if (username && !email)
{
lblerr.Text = "UserName already exists ";
}
if (!username && email)
{
lblerr.Text = "email already exists";
}
if (!username && !email)
{
try
{
sq.Insert("UserName,FirsName,PassWord,Email,Phone,PassportNumber", txtusernamer.Text.ToString().Trim() + "," + txtnamer.Text.ToString().ToLower().Trim() + "," + txtPassWordr.Text.ToString().ToLower().Trim() + "," + txtEmailr.Text.ToString().ToLower().Trim() + "," + txtphoner.Text.ToString().ToLower() + "," + txtpaport.Text.ToString().ToLower(), "Customer");
lblerr.Text = "Registration Successful";
FormsAuthentication.SetAuthCookie(txtusernamer.Text, true);
Session["value"] = txtusernamer.Text;
Response.Redirect("Home.aspx");
}
catch
{
lblerr.Text = " please try agin ";
}
}
}
protected void ValidateUser(object sender, AuthenticateEventArgs e)
{
SqlInterface sq;
sq = new SqlInterface(connection);
DataTable DTgetusers = sq.Select("select * from Customer where Username='******' and Password='******'");
if (DTgetusers.Rows.Count > 0)
{
FormsAuthentication.RedirectFromLoginPage(Login1.UserName, Login1.RememberMeSet);
Response.Redirect("Home.aspx");
}
else
{
lblerr.Text = "incorrect username or password";
lblerr.ForeColor = System.Drawing.Color.Red;
}
}
