protected void Page_Load(object sender, EventArgs e) { // Deny normal user access if (Session["userType"].ToString() == Reference.USR_MEM) { /* string script = "alert('You do not have access to the page.');"; * ClientScript.RegisterClientScriptBlock(this.GetType(), "Alert", script, true); */ ScriptManager.RegisterStartupScript(this, this.GetType(), "redirect", "alert('You do not have access to this page'); window.location='" + Request.ApplicationPath + "ProfileInfo.aspx';", true); } if (!IsPostBack) { if (Session["userType"].ToString() == Reference.USR_ADM) { Billboard BillboardObj = new Billboard(); Billboard_Management bDao = new Billboard_Management(); //Company CompanyObj = new Company(); // Company_Management CDao = new Company_Management(); BillboardObj = bDao.getBillboardByID(Session["BillboardID"].ToString()); latitude = BillboardObj.latitude; longtitude = BillboardObj.Longtitude; //CompanyObj = CDao.getCompanyByID(Session["CompanyID"].ToString()); Database db = new Database(); //SqlCommand cmd = new SqlCommand("select CodeValue,CodeDesc from CodeReferece where CodeType=Industry "); //DataTable dt = db.getDataTable(cmd); //CoIndustry.DataSource = dt; //CoIndustry.DataValueField = "CodeValue"; //CoIndustry.DataTextField = "CodeDesc"; //CoIndustry.DataBind(); //CoIndustry.Items.Insert(0, new ListItem("---Select An Industry---", "0")); SqlCommand cmd = new SqlCommand("select CodeValue,CodeDesc from CodeReferece where CodeType='Country' "); DataTable dt = db.getDataTable(cmd); BBCountry.DataSource = dt; BBCountry.DataValueField = "CodeValue"; BBCountry.DataTextField = "CodeDesc"; BBCountry.DataBind(); BBCountry.Items.Insert(0, new ListItem("---Select A Country---", "0")); BBAddLn1.Text = BillboardObj.AddressLn1; BBAddLn2.Text = BillboardObj.AddressLn2; BBCity.Text = BillboardObj.City; BBCountry.SelectedValue = BillboardObj.Country; BBLatitude.Text = BillboardObj.latitude; BBLongtitude.Text = BillboardObj.Longtitude; BBPostalCode.Text = BillboardObj.postalCode; } } }
protected void updateBtn_Click(object sender, EventArgs e) { if (BBCountry.SelectedValue == "" || BBAddLn1.Text == "" || BBCity.Text == "" || BBPostalCode.Text == "" || BBLatitude.Text == "" || BBLongtitude.Text == "") { alertWarning.Visible = true; alertSuccess.Visible = false; } else { Billboard_Management bDAO = new Billboard_Management(); //Company_Management cDAO = new Company_Management(); // string companyName = CoName.Text; // string Industry = CoIndustry.SelectedValue; string Addr1 = BBAddLn1.Text.ToString(); string Addr2 = BBAddLn2.Text.ToString(); string City = BBCity.Text.ToString(); string Country = BBCountry.SelectedItem.Value.ToString(); string latitude = BBLatitude.Text.ToString(); string Longtitude = BBLongtitude.Text.ToString(); string postalCode = BBPostalCode.Text.ToString(); string lastUpdBy = Session["userID"].ToString(); string lastUpdOn = DateTime.Now.ToString("MM/dd/yyyy h:mm tt"); //(string BillboardID, string AddressLn1, string AddressLn2, string City, string Country, string latitude, string Longtitude, string postalCode, string lastUpdBy, string lastUpdOn) Boolean insCnt = bDAO.BBInfoUpdate(Session["BillboardID"].ToString(), Addr1, Addr2, City, Country, latitude, Longtitude, postalCode, lastUpdBy, lastUpdOn); alertWarning.Visible = false; alertSuccess.Visible = true; BBAddLn1.Text = String.Empty; BBAddLn2.Text = String.Empty; BBCountry.SelectedItem.Value = ""; BBCity.Text = String.Empty; BBPostalCode.Text = String.Empty; BBLatitude.Text = String.Empty; BBLongtitude.Text = String.Empty; Session["BBUpdate"] = 2; Response.Redirect("BillboardList.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { Billboard BillboardObj = new Billboard(); Billboard_Management bDao = new Billboard_Management(); //Company CompanyObj = new Company(); // Company_Management CDao = new Company_Management(); BillboardObj = bDao.getBillboardByID(Session["BillboardID"].ToString()); latitude = BillboardObj.latitude; longtitude = BillboardObj.Longtitude; //CompanyObj = CDao.getCompanyByID(Session["CompanyID"].ToString()); Database db = new Database(); //SqlCommand cmd = new SqlCommand("select CodeValue,CodeDesc from CodeReferece where CodeType=Industry "); //DataTable dt = db.getDataTable(cmd); //CoIndustry.DataSource = dt; //CoIndustry.DataValueField = "CodeValue"; //CoIndustry.DataTextField = "CodeDesc"; //CoIndustry.DataBind(); //CoIndustry.Items.Insert(0, new ListItem("---Select An Industry---", "0")); SqlCommand cmd = new SqlCommand("select CodeValue,CodeDesc from CodeReferece where CodeType='Country' "); DataTable dt = db.getDataTable(cmd); BBCountry.DataSource = dt; BBCountry.DataValueField = "CodeValue"; BBCountry.DataTextField = "CodeDesc"; BBCountry.DataBind(); BBCountry.Items.Insert(0, new ListItem("---Select A Country---", "0")); BBAddLn1.Text = BillboardObj.AddressLn1; BBAddLn2.Text = BillboardObj.AddressLn2; BBCity.Text = BillboardObj.City; BBCountry.SelectedValue = BillboardObj.Country; BBLatitude.Text = BillboardObj.latitude; BBLongtitude.Text = BillboardObj.Longtitude; BBPostalCode.Text = BillboardObj.postalCode; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { Billboard BillboardObj = new Billboard(); Billboard_Management bDao = new Billboard_Management(); BillboardObj = bDao.getBillboardByID(Session["BillboardID"].ToString()); latitude = BillboardObj.latitude; longtitude = BillboardObj.Longtitude; this.BindGrid(); } try { var rowIndex = 0; var hiddenvalue = (string)GridView1.DataKeys[rowIndex]["BillboardCode"]; BillboardCodelabel.Text = " for " + hiddenvalue.ToString(); } catch (System.ArgumentOutOfRangeException ArgumentOutOfRangeException) { } }
protected void Page_Load(object sender, EventArgs e) { // Deny normal user access if (Session["userType"].ToString() == Reference.USR_MEM) { /* string script = "alert('You do not have access to the page.');"; * ClientScript.RegisterClientScriptBlock(this.GetType(), "Alert", script, true); */ ScriptManager.RegisterStartupScript(this, this.GetType(), "redirect", "alert('You do not have access to this page'); window.location='" + Request.ApplicationPath + "ProfileInfo.aspx';", true); } if (!IsPostBack) { if (Session["userType"].ToString() == Reference.USR_ADM) { Billboard BillboardObj = new Billboard(); Billboard_Management bDao = new Billboard_Management(); BillboardObj = bDao.getBillboardByID(Session["BillboardID"].ToString()); latitude = BillboardObj.latitude; longtitude = BillboardObj.Longtitude; this.BindGrid(); } } try { var rowIndex = 0; var hiddenvalue = (string)GridView1.DataKeys[rowIndex]["BillboardCode"]; BillboardCodelabel.Text = " for " + hiddenvalue.ToString(); } catch (System.ArgumentOutOfRangeException ArgumentOutOfRangeException) { } }
protected void btnDelete_Command(object sender, CommandEventArgs e) { if (e.CommandName == "DeleteBBMessage") { SqlConnection conn = null; SqlDataReader reader = null; // instantiate and open connection conn = new SqlConnection(Reference.Constr); conn.Open(); int index = Convert.ToInt32(e.CommandArgument); // Retrieve the row that contains the button // from the Rows collection. GridViewRow row = GridView1.Rows[index]; LinkButton btnButton1 = sender as LinkButton; GridViewRow gvRow1 = (GridViewRow)btnButton1.NamingContainer; Billboard bObj = new Billboard(); Billboard_Management bDao = new Billboard_Management(); Label lb_msgId = (Label)gvRow1.FindControl("lb_BillboardID"); bObj = bDao.getBillboardByID(lb_msgId.Text); string BBCode = bObj.BillboardCode; SqlCommand cmdcount = new SqlCommand("Select count(*) as total from BillboardLocation as b inner join AdvertisementLocation al on b.BillboardID=al.BillboardID inner join Advertisement a2 on" + " al.AdvID=a2.AdvID where al.BillboardID=@ID and a2.status=1", conn); SqlParameter paramCount = new SqlParameter(); paramCount.ParameterName = "@ID"; paramCount.Value = bObj.BillboardID.ToString(); cmdcount.Parameters.Add(paramCount); SqlDataAdapter sdacount = new SqlDataAdapter(); DataTable dt = new DataTable(); cmdcount.Connection = conn; sdacount.SelectCommand = cmdcount; sdacount.Fill(dt); for (int i = 0; i < dt.Rows.Count; i++) { int count = Convert.ToInt32(dt.Rows[i]["total"]); if (count == 0) { Boolean insCnt = bDao.deleteBillboard(lb_msgId.Text); //VIC: never inform if the delete is successful or not? alertSuccess.Visible = true; DeleteFailure.Visible = false; createSuccess.Visible = false; updateSuccess.Visible = false; msgSuccess.Text = " Billboard #" + BBCode + " has been deleted successfully!"; } else { DeleteFailure.Visible = true; alertSuccess.Visible = false; createSuccess.Visible = false; updateSuccess.Visible = false; LabelError.Text = "There are " + count + " Advertisement(s) in Billboard " + BBCode + ".Please delete existing advertisement(s) first before proceeding to delete the Billboard."; } } Database db = new Database(); SqlCommand cmd = new SqlCommand("Select * from [BillboardLocation] WHERE Status = 1"); DataSet ds = db.getDataSet(cmd); //gvUser.DataSource = ds; GridView1.DataBind(); } }
protected void SubmitBtn_Click(object sender, EventArgs e) { SqlConnection conn = null; SqlDataReader reader = null; // instantiate and open connection conn = new SqlConnection(Reference.Constr); conn.Open(); String BillboardCode = BBLocationCode.Text.ToString(); String AddressLn1 = BBAddLn1.Text.ToString(); String AddressLn2 = BBAddLn2.Text.ToString(); String City = BBCity.Text.ToString(); String Country = (BBCountry.SelectedItem.Value.ToString()); String PostalCode = BBPostalCode.Text.ToString(); DateTime CreatedOn = DateTime.Now; int Status = 1; string latitude = BBLatitude.Text.ToString(); int CreatedBy = 1; string Longtitude = BBLongtitude.Text.ToString(); Billboard_Management bbMgmt = new Billboard_Management(); //che ee was here // Boolean record = bbMgmt.BBcheck(BillboardCode); SqlCommand sCmd = new SqlCommand("SELECT Count(*) FROM BillboardLocation WHERE BillboardCode=@BCode and status=1", conn); SqlParameter param = new SqlParameter(); param.ParameterName = "@BCode"; param.Value = BillboardCode; sCmd.Parameters.Add(param); Int32 totalcount = Convert.ToInt32(sCmd.ExecuteScalar()); //if (BBLocationCode.Text == "" || BBAddLn1.Text == "" || BBCity.Text == "" || BBCountry.SelectedValue == "" || // BBPostalCode.Text == "" || BBLatitude.Text == "" || BBLongtitude.Text == "") //{ // alertWarning.Visible = true; // alertSuccess.Visible = false; // alertDanger.Visible = false; // warningLocation.Text = "Please enter All Required Fields"; //} //else //{ if (totalcount == 0) { Boolean result = bbMgmt.BBinsert(BillboardCode, AddressLn1, AddressLn2, City, Country, PostalCode, CreatedOn, Status, latitude, Longtitude, CreatedBy); if (result == true) { //alertWarning.Visible = false; //alertSuccess.Visible = true; //BBLocationCode.Text = String.Empty; //BBAddLn1.Text = String.Empty; //BBAddLn2.Text = String.Empty; //BBCountry.SelectedValue = ""; //BBCity.Text = String.Empty; //BBPostalCode.Text = String.Empty; Session["BBCreate"] = 2; Response.Redirect("BillboardList.aspx"); } } else { alertWarning.Visible = false; alertSuccess.Visible = false; alertDanger.Visible = true; dangerLocation.Text = "Billboard Code already exist"; } //} }