protected void loginBtn_Click(object sender, EventArgs e)
{
requiredLbl.Visible = false;
usernamerequiredLbl.Visible = false;
passwordrequiredLbl.Visible = false;
invalidloginLbl.Visible = false;
int count = 0;
PointofInterestDataContext Context = new PointofInterestDataContext();
var result = Context.sp_select_AllUsers();
if (usernameTxtbx.Text == "")
{
requiredLbl.Text = "Username Field Required *";
requiredLbl.Visible = true;
usernamerequiredLbl.Visible = true;
}
else
{
if (passwordTxtbx.Text == "")
{
requiredLbl.Text = "Password Field Required *";
requiredLbl.Visible = true;
passwordrequiredLbl.Visible = true;
}
}
if (usernameTxtbx.Text == "" && passwordTxtbx.Text == "")
{
requiredLbl.Text = "Username and Password Field Required *";
requiredLbl.Visible = true;
usernamerequiredLbl.Visible = true;
passwordrequiredLbl.Visible = true;
}
if (usernameTxtbx.Text != "" && passwordTxtbx.Text != "")
{
foreach (var r in result)
{
if (usernameTxtbx.Text != r.username || passwordTxtbx.Text != r.password1 && count == Count_Number_of_Users() - 1)
{
invalidloginLbl.Visible = true;
}
else
{
if (usernameTxtbx.Text == r.username && passwordTxtbx.Text == r.password1)
{
Users user = new Users(r.username, r.password1, r.fname, r.lname, r.gender, r.address1, r.telephone, r.roles);
Session["ReadUser"] = user;
Response.Redirect("Home.aspx");
}
}
count++;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
String name = Request.QueryString["name"];
SpotDropDownList.SelectedValue = name;
DataTable dt = this.GetData("Select Spots.name, Spots.typeofspot, Location.latitude, Location.longitude From Spots INNER JOIN Location ON Spots.location_id=Location.locationid");// Where Spots.name="+SpotDropDownList.SelectedValue.ToString());
rptMarkers.DataSource = dt;
rptMarkers.DataBind();
PointofInterestDataContext context = new PointofInterestDataContext();
var result1 = context.sp_select_SpotsOpeningHoursLocationbyName(name);
foreach (var r in result1)
{
spotnameLbl.Text = r.name;
typespotLbl.Text = r.typeofspot;
// websiteLbl.Text = r.websitelink;
streetLbl.Text = r.Street;
parishlbl.Text = r.Parish;
monhrLbl.Text = r.mondayhr;
tuehrLbl.Text = r.tuesdayhr;
wedhrLbl.Text = r.wednesdayhr;
thuhrLbl.Text = r.thursdayhr;
frihrLbl.Text = r.fridayhr;
sathrLbl.Text = r.saturdayhr;
sunhrLbl.Text = r.sundayhr;
decriptheadLbl.Text = r.name;
decriptionLbl.Text = r.descriptions;
Image1.ImageUrl = r.picturesdir + "01.jpg";
Imagethumb1.ImageUrl = r.picturesdir + "01.jpg";
Image2.ImageUrl = r.picturesdir + "02.jpg";
Imagethumb2.ImageUrl = r.picturesdir + "02.jpg";
Image3.ImageUrl = r.picturesdir + "03.jpg";
Imagethumb3.ImageUrl = r.picturesdir + "03.jpg";
logoImg.ImageUrl = r.picturesdir + "logo.jpg";
}
}
Users user = (Users)Session["ReadUser"];
if (user == null)
{
booknowBtn.Visible = false;
}
else
{
booknowBtn.Visible = true;
}
}
protected int Count_Users()
{
PointofInterestDataContext Context = new PointofInterestDataContext();
var result = Context.sp_select_AllUsers();
int count = 0;
foreach (var r in result)
{
count++;
}
return(count);
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack == false)
{
PointofInterestDataContext context = new PointofInterestDataContext();
var result = context.sp_select_AllLocationSpots();
typeofspotDropDownList.Items.Add("Any");
typeofspotDropDownList.Items.Add("Restaurant");
typeofspotDropDownList.Items.Add("Attraction");
typeofspotDropDownList.Items.Add("Venue");
parishDropDownList.Items.Add("Any");
parishDropDownList.Items.Add("Kingston");
}
}
protected int Count_Number_of_Users()
{
PointofInterestDataContext Context = new PointofInterestDataContext();
var result = Context.sp_select_AllUsers();
int count = 0;
foreach (var r in result)
{
if (r.username != "")
{
count++;
}
}
return(count);
}
protected void SpotDropDownList_SelectedIndexChanged(object sender, EventArgs e)
{
PointofInterestDataContext context = new PointofInterestDataContext();
var result = context.sp_select_SpotsOpeningHoursLocationbyName(SpotDropDownList.SelectedValue.ToString());
foreach (var r in result)
{
spotnameLbl.Text = r.name;
typespotLbl.Text = r.typeofspot;
//websiteLbl.Text = r.websitelink;
streetLbl.Text = r.Street;
parishlbl.Text = r.Parish;
monhrLbl.Text = r.mondayhr;
tuehrLbl.Text = r.tuesdayhr;
wedhrLbl.Text = r.wednesdayhr;
thuhrLbl.Text = r.thursdayhr;
frihrLbl.Text = r.fridayhr;
sathrLbl.Text = r.saturdayhr;
sunhrLbl.Text = r.sundayhr;
decriptheadLbl.Text = r.name;
decriptionLbl.Text = r.descriptions;
Image1.ImageUrl = r.picturesdir + "01.jpg";
Imagethumb1.ImageUrl = r.picturesdir + "01.jpg";
Image2.ImageUrl = r.picturesdir + "02.jpg";
Imagethumb2.ImageUrl = r.picturesdir + "02.jpg";
Image3.ImageUrl = r.picturesdir + "03.jpg";
Imagethumb3.ImageUrl = r.picturesdir + "03.jpg";
logoImg.ImageUrl = r.picturesdir + "logo.jpg";
}
}
protected void registerBtn_Click(object sender, EventArgs e)
{
int i = 0;
bool cmp = true, exist = false;
ResetValidators();
if (fnameTxtbx.Text == "")
{
i++;
fnameValidatorLbl.Visible = true;
}
if (lnameTxtbx.Text == "")
{
i++;
lnameValidatorLbl.Visible = true;
}
if (addressTxtbx.Text == "")
{
i++;
addressValidatorLbl.Visible = true;
}
if (genderRadioButtonList.SelectedItem == null)
{
i++;
genderValidatorLbl.Visible = true;
}
if (telephTxtbx.Text == "" || telephTxtbx.Text.Length != 10)
{
i++;
telephValidatorLbl.Visible = true;
}
if (usernameTxtbx.Text == "")
{
i++;
usernameValidatorLbl.Visible = true;
}
else
{
try { var eMailValidator = new System.Net.Mail.MailAddress(usernameTxtbx.Text); }
catch (FormatException ex)
{
cmp = false;
emailformatValidatorLbl.Visible = true;
}
}
if (passwordTxtbx.Text == "")
{
i++;
passwordValidatorLbl.Visible = true;
}
if (confpasswordTxtbx.Text == "")
{
i++;
confpasswordValidatorLbl.Visible = true;
}
if (passwordTxtbx.Text != confpasswordTxtbx.Text)
{
passwordCompValidatorLbl.Visible = true;
passwordValidatorLbl.Visible = true;
cmp = false;
}
PointofInterestDataContext Context = new PointofInterestDataContext();
var result1 = Context.sp_select_AllUsers();
foreach (var r in result1)
{
if (usernameTxtbx.Text == r.username)
{
exist = true;
emailexistvalidatorLbl.Visible = true;
usernameValidatorLbl.Visible = true;
}
}
if (i > 0)
{
requiredLbl.Visible = true;
}
else
{
if (i == 0 && cmp == true && exist == false)
{
PointofInterestDataContext context = new PointofInterestDataContext();
context.sp_insert_User(usernameTxtbx.Text, passwordTxtbx.Text, fnameTxtbx.Text, lnameTxtbx.Text, genderRadioButtonList.SelectedValue.ToString(), addressTxtbx.Text, telephTxtbx.Text, "Users");
Users user = new Users(usernameTxtbx.Text, passwordTxtbx.Text, fnameTxtbx.Text, lnameTxtbx.Text, genderRadioButtonList.SelectedValue.ToString(), addressTxtbx.Text, telephTxtbx.Text, "Users");
Session["RegisterUser"] = user;
Response.Redirect("RegistrationSucess.aspx");
}
}
}
