protected void DataListFullPG_ItemCommand(object source, DataListCommandEventArgs e) { if (e.CommandName == "readMore") { int index = e.Item.ItemIndex; Table allDetails = (Table)DataListFullPG.Items[index].FindControl("infoTable"); Button view = (Button)DataListFullPG.Items[index].FindControl("btnExpand"); if (view.Text == "Read More...") { view.Text = "See Less..."; allDetails.Visible = true; } else { view.Text = "Read More..."; allDetails.Visible = false; } } else if (e.CommandName == "addInterest") { int index = e.Item.ItemIndex; Label pid = (Label)DataListFullPG.Items[index].FindControl("lblID"); Button int1 = (Button)DataListFullPG.Items[index].FindControl("btnInterest1"); Button int2 = (Button)DataListFullPG.Items[index].FindControl("btnInterest2"); Label init = (Label)DataListFullPG.Items[index].FindControl("lblInterests"); int interests = Int32.Parse(init.Text); String myConn = ConfigurationManager.ConnectionStrings["StayHubDBConnection"].ConnectionString; SqlConnection con = new SqlConnection(myConn); if (Session["userid"] != null) { String addIntr = "insert into Interests(UID, PID) values (@uid, @pid);"; SqlCommand cmd = new SqlCommand(addIntr, con); cmd.Parameters.AddWithValue("uid", Session["userid"].ToString()); cmd.Parameters.AddWithValue("pid", pid.Text); String incnum = "update PG set Interests = @interests where ID = @pid;"; SqlCommand cmd2 = new SqlCommand(incnum, con); cmd2.Parameters.AddWithValue("interests", interests + 1); cmd2.Parameters.AddWithValue("pid", pid.Text); con.Open(); int i = cmd.ExecuteNonQuery(); cmd2.ExecuteNonQuery(); con.Close(); if (i > 0) { int1.Visible = false; int2.Visible = true; } else { int1.Visible = true; int2.Visible = false; } DataListFullPG.DataBind(); } else { ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "alertMessage();", true); int1.ToolTip = "You need to login first!"; } } else if (e.CommandName == "remInterest") { int index = e.Item.ItemIndex; Label pid = (Label)DataListFullPG.Items[index].FindControl("lblID"); Button int1 = (Button)DataListFullPG.Items[index].FindControl("btnInterest1"); Button int2 = (Button)DataListFullPG.Items[index].FindControl("btnInterest2"); Label init = (Label)DataListFullPG.Items[index].FindControl("lblInterests"); int interests = Int32.Parse(init.Text); String myConn = ConfigurationManager.ConnectionStrings["StayHubDBConnection"].ConnectionString; SqlConnection con = new SqlConnection(myConn); String addIntr = "delete from Interests where UID = @uid and PID = @pid;"; SqlCommand cmd = new SqlCommand(addIntr, con); cmd.Parameters.AddWithValue("uid", Session["userid"].ToString()); cmd.Parameters.AddWithValue("pid", pid.Text); String decnum = "update PG set Interests = @interests where ID = @pid;"; SqlCommand cmd2 = new SqlCommand(decnum, con); cmd2.Parameters.AddWithValue("interests", interests - 1); cmd2.Parameters.AddWithValue("pid", pid.Text); con.Open(); int i = cmd.ExecuteNonQuery(); cmd2.ExecuteNonQuery(); con.Close(); if (i > 0) { int1.Visible = true; int2.Visible = false; } else { int1.Visible = false; int2.Visible = true; } DataListFullPG.DataBind(); } else if (e.CommandName == "reqVisit") { int index = e.Item.ItemIndex; String pid = e.CommandArgument.ToString(); //Label pid = (Label)DataListFullPG.Items[index].FindControl("lblID"); Button req = (Button)DataListFullPG.Items[index].FindControl("btnVisit"); Label oid = (Label)DataListFullPG.Items[index].FindControl("lblOID"); Label pgname = (Label)DataListFullPG.Items[index].FindControl("lblName"); Label pgaddr = (Label)DataListFullPG.Items[index].FindControl("lblAddr"); Label pgowner = (Label)DataListFullPG.Items[index].FindControl("lblOwner"); Label pgcontact = (Label)DataListFullPG.Items[index].FindControl("lblContact"); if (req.Text == "Request A Visit") { String myConn = ConfigurationManager.ConnectionStrings["StayHubDBConnection"].ConnectionString; SqlConnection con = new SqlConnection(myConn); if (Session["userid"] != null) { String query = "insert into SiteVisits(PID, SID, OID) values (@pid, @sid, @oid);"; SqlCommand cmd = new SqlCommand(query, con); cmd.Parameters.AddWithValue("pid", pid); cmd.Parameters.AddWithValue("sid", Session["userid"].ToString()); cmd.Parameters.AddWithValue("oid", oid.Text); con.Open(); int i = cmd.ExecuteNonQuery(); con.Close(); if (i > 0) { req.Text = "Visit Requested!"; req.Enabled = false; DataListFullPG.DataBind(); SendEmail(pgname.Text, pgaddr.Text, pgowner.Text, pgcontact.Text); } else { req.Text = "Request A Visit"; req.Enabled = true; } } else { ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "alertMessage();", true); req.ToolTip = "You need to login first!"; } } else { req.Enabled = false; } } else if (e.CommandName == "pgImg") { String arg = e.CommandArgument.ToString(); String a = arg.Substring(2); String script = "window.open('" + a + "')"; ScriptManager.RegisterStartupScript(this, GetType(), "openImage", script, true); } }
/* * private void DeleteDirectory(string path) * { * // Delete all files from the Directory * foreach (string filename in Directory.GetFiles(path)) * { * File.Delete(filename); * } * Directory.Delete(path); * } */ protected void btnUpdate_Click(object sender, EventArgs e) { try { lblEmpty.Visible = false; btnCancel.Visible = true; deletePG.Visible = false; DataListItem dli = this.DataListFullPG.Controls[this.DataListFullPG.Controls.Count - 1] as DataListItem; /*Editable amenities list*/ Label l1 = dli.FindControl("lblName") as Label; TextBox t1 = dli.FindControl("txtName") as TextBox; Label l2 = dli.FindControl("lblAddr") as Label; TextBox t2 = dli.FindControl("txtAddr") as TextBox; Label l3 = dli.FindControl("lblOcc") as Label; TextBox t3 = dli.FindControl("txtOcc") as TextBox; Label l4 = dli.FindControl("lblRent") as Label; TextBox t4 = dli.FindControl("txtRent") as TextBox; Label l5 = dli.FindControl("lblElec") as Label; DropDownList d5 = dli.FindControl("ddlElec") as DropDownList; Label l6 = dli.FindControl("lblLndry") as Label; DropDownList d6 = dli.FindControl("ddlLndry") as DropDownList; Label l7 = dli.FindControl("lblGeyser") as Label; DropDownList d7 = dli.FindControl("ddlGeyser") as DropDownList; Label l8 = dli.FindControl("lblTV") as Label; DropDownList d8 = dli.FindControl("ddlTV") as DropDownList; Label l9 = dli.FindControl("lblFri") as Label; DropDownList d9 = dli.FindControl("ddlFri") as DropDownList; Label l10 = dli.FindControl("lblAC") as Label; DropDownList d10 = dli.FindControl("ddlAC") as DropDownList; Label l11 = dli.FindControl("lblWi") as Label; DropDownList d11 = dli.FindControl("ddlWi") as DropDownList; Label l12 = dli.FindControl("lblCook") as Label; DropDownList d12 = dli.FindControl("ddlCook") as DropDownList; Label l13 = dli.FindControl("lblMeals") as Label; DropDownList d13 = dli.FindControl("ddlMeals") as DropDownList; Label l14 = dli.FindControl("lblNonV") as Label; DropDownList d14 = dli.FindControl("ddlNonV") as DropDownList; Label l15 = dli.FindControl("lblTable") as Label; DropDownList d15 = dli.FindControl("ddlTable") as DropDownList; Label l16 = dli.FindControl("lblBalc") as Label; DropDownList d16 = dli.FindControl("ddlBalc") as DropDownList; Label l17 = dli.FindControl("lblPark") as Label; DropDownList d17 = dli.FindControl("ddlPark") as DropDownList; Label l18 = dli.FindControl("lblSec") as Label; DropDownList d18 = dli.FindControl("ddlSec") as DropDownList; FileUpload f1 = dli.FindControl("FilePic1") as FileUpload; FileUpload f2 = dli.FindControl("FilePic2") as FileUpload; FileUpload f3 = dli.FindControl("FilePic3") as FileUpload; FileUpload f4 = dli.FindControl("FilePic4") as FileUpload; FileUpload f5 = dli.FindControl("FilePic5") as FileUpload; Label pic1Validation = dli.FindControl("pic1Validation") as Label; Label pic2Validation = dli.FindControl("pic2Validation") as Label; Label pic3Validation = dli.FindControl("pic3Validation") as Label; Label pic4Validation = dli.FindControl("pic4Validation") as Label; Label pic5Validation = dli.FindControl("pic5Validation") as Label; if (btnUpdate.Text == "Edit PG") //Owner wants to edit { btnUpdate.Text = "Save Changes"; editAmenitiesList.Visible = true; editPhotos.Visible = true; viewAmenitiesList.Visible = false; //viewPhotos.Visible = false; l1.Visible = false; t1.Visible = true; l2.Visible = false; t2.Visible = true; l3.Visible = false; t3.Visible = true; l4.Visible = false; t4.Visible = true; d5.SelectedValue = l5.Text; d6.SelectedValue = l6.Text; d7.SelectedValue = l7.Text; d8.SelectedValue = l8.Text; d9.SelectedValue = l9.Text; d10.SelectedValue = l10.Text; d11.SelectedValue = l11.Text; d12.SelectedValue = l12.Text; d13.SelectedValue = l13.Text; d14.SelectedValue = l14.Text; d15.SelectedValue = l15.Text; d16.SelectedValue = l16.Text; d17.SelectedValue = l17.Text; d18.SelectedValue = l18.Text; /*Retrieving pictures to display filecontrol only for additional pics instead of overwriting all*/ String id = Request.QueryString["id"]; String myConn = ConfigurationManager.ConnectionStrings["StayHubDBConnection"].ConnectionString; SqlConnection con = new SqlConnection(myConn); String query = "select Pic1, Pic2, Pic3, Pic4, Pic5 from PG where ID = @ID"; SqlCommand cmd = new SqlCommand(query, con); cmd.Parameters.AddWithValue("ID", id); con.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { String p1 = reader[0].ToString(); String p2 = reader[1].ToString(); String p3 = reader[2].ToString(); String p4 = reader[3].ToString(); String p5 = reader[4].ToString(); if (p1 == "") { f1.Visible = true; } if (p2 == "") { f2.Visible = true; } if (p3 == "") { f3.Visible = true; } if (p4 == "") { f4.Visible = true; } if (p5 == "") { f5.Visible = true; } } con.Close(); //pic1Validation.Visible = pic2Validation.Visible = pic3Validation.Visible = pic4Validation.Visible = pic5Validation.Visible = true; } else if (btnUpdate.Text == "Save Changes") //Owner wants to update the details (save changes) { String id = Request.QueryString["id"]; String myConn = ConfigurationManager.ConnectionStrings["StayHubDBConnection"].ConnectionString; SqlConnection con = new SqlConnection(myConn); /*Update textual fields*/ String query = "update PG set " + "Name = @Name, " + "Address = @Addr, " + "Rent = @Rent, " + "Occupancy = @Occ, " + "Meals = @Meals, " + "NonVeg = @NonV, " + "Electricity = @Elec, " + "AC = @AC, " + "TV = @TV, " + "WiFi = @Wi, " + "Laundry = @Lndry, " + "Geyser = @Geyser, " + "Refrigerator = @Fri, " + "CookingStove = @Cook, " + "StudyTable = @Table, " + "Balcony = @Balc, " + "Parking = @Park, " + "Security = @Sec " + " where ID = @ID"; SqlCommand cmd = new SqlCommand(query, con); cmd.Parameters.AddWithValue("ID", id); cmd.Parameters.AddWithValue("Name", t1.Text); cmd.Parameters.AddWithValue("Addr", t2.Text); cmd.Parameters.AddWithValue("Occ", t3.Text); cmd.Parameters.AddWithValue("Rent", t4.Text); cmd.Parameters.AddWithValue("Elec", d5.SelectedValue); cmd.Parameters.AddWithValue("Lndry", d6.SelectedValue); cmd.Parameters.AddWithValue("Geyser", d7.SelectedValue); cmd.Parameters.AddWithValue("TV", d8.SelectedValue); cmd.Parameters.AddWithValue("Fri", d9.SelectedValue); cmd.Parameters.AddWithValue("AC", d10.SelectedValue); cmd.Parameters.AddWithValue("Wi", d11.SelectedValue); cmd.Parameters.AddWithValue("Cook", d12.SelectedValue); cmd.Parameters.AddWithValue("Meals", d13.SelectedValue); cmd.Parameters.AddWithValue("NonV", d14.SelectedValue); cmd.Parameters.AddWithValue("Table", d15.SelectedValue); cmd.Parameters.AddWithValue("Balc", d16.SelectedValue); cmd.Parameters.AddWithValue("Park", d17.SelectedValue); cmd.Parameters.AddWithValue("Sec", d18.SelectedValue); con.Open(); cmd.ExecuteNonQuery(); con.Close(); /*Update picture fields*/ if (f1.Visible) { String pic1 = validateImages(f1, pic1Validation, id); String picQuery = "update PG set Pic1 = @p where ID = @ID"; SqlCommand cmd1 = new SqlCommand(picQuery, con); cmd1.Parameters.AddWithValue("ID", id); cmd1.Parameters.AddWithValue("p", pic1); con.Open(); cmd1.ExecuteNonQuery(); con.Close(); } if (f2.Visible) { String pic2 = validateImages(f2, pic2Validation, id); String picQuery = "update PG set Pic2 = @p where ID = @ID"; SqlCommand cmd1 = new SqlCommand(picQuery, con); cmd1.Parameters.AddWithValue("ID", id); cmd1.Parameters.AddWithValue("p", pic2); con.Open(); cmd1.ExecuteNonQuery(); con.Close(); } if (f3.Visible) { String pic3 = validateImages(f3, pic3Validation, id); String picQuery = "update PG set Pic3 = @p where ID = @ID"; SqlCommand cmd1 = new SqlCommand(picQuery, con); cmd1.Parameters.AddWithValue("ID", id); cmd1.Parameters.AddWithValue("p", pic3); con.Open(); cmd1.ExecuteNonQuery(); con.Close(); } if (f4.Visible) { String pic4 = validateImages(f4, pic4Validation, id); String picQuery = "update PG set Pic4 = @p where ID = @ID"; SqlCommand cmd1 = new SqlCommand(picQuery, con); cmd1.Parameters.AddWithValue("ID", id); cmd1.Parameters.AddWithValue("p", pic4); con.Open(); cmd1.ExecuteNonQuery(); con.Close(); } if (f5.Visible) { String pic5 = validateImages(f5, pic5Validation, id); String picQuery = "update PG set Pic5 = @p where ID = @ID"; SqlCommand cmd1 = new SqlCommand(picQuery, con); cmd1.Parameters.AddWithValue("ID", id); cmd1.Parameters.AddWithValue("p", pic5); con.Open(); cmd1.ExecuteNonQuery(); con.Close(); } lblEmpty.Text = "PG Updated Successfully"; lblEmpty.ForeColor = System.Drawing.Color.Green; lblEmpty.Visible = true; DataListFullPG.DataBind(); btnCancel.Visible = false; btnUpdate.Text = "Edit PG"; deletePG.Visible = true; editAmenitiesList.Visible = false; editPhotos.Visible = false; viewAmenitiesList.Visible = true; viewPhotos.Visible = true; SwapLabels(); } } catch (Exception exc) { Response.Redirect("ErrorPage.aspx"); } }