I have four asp buttons, all handling code behing procedures, for example Button1 load data on click but on second click acts as submit button. Button 2 supose tp load data on specific textboxes grouped in same update panel, even outside panel it behaves the same. Webpage and code behind, a little long but for you to see the whole picture.
What I need is that each button to execute only the procedure is specify to
Code behind
- using System;
- using System.Data;
- using System.Data.SqlClient;
- using System.Web.UI.WebControls;
- using System.Configuration;
- using System.Web.Services;
- using System.Collections.Generic;
- using System.Web.UI;
- using System.Drawing;
- namespace WAPReview
- {
- public partial class ReviewWAP : System.Web.UI.Page
- {
- string connString = Properties.Settings.Default.ConnectionString.ToString();
- protected void Page_Load(object sender, EventArgs e)
- {
- if (Users.UserRole != "Admin" & Users.UserRole != "Reviewer")
- {
- Response.Redirect("/HomePage.aspx", false);
- }
- if (!IsPostBack)
- {
- GetWAPData();
- GetDivisionName();
- GetLocation1();
- GetLocation2();
- GetWAPType();
- GetServiceCompany();
- GetJobType();
- GetChkCategory1();
- GetChkCategory2();
- }
- Button2.Enabled = false;
- Button3.Enabled = false;
- Button4.Enabled = false;
- Checklist1.Visible = false;
- string UserName = Environment.UserName;
- FillUserDetails FS = new FillUserDetails();
- FS.fillUser(UserName);
- txtReviewer1.Text = Users.FullName;
- txtReviewer2.Text = Users.FullName;
- txtDate1.Text = DateTime.Now.ToString();
- txtDate2.Text = DateTime.Now.ToString();
- }
- protected void ReviewNewWAP(object sender, EventArgs e)
- {
- AddWAPReviewDataNew();
- }
- protected void ReviewExistingWAP(object sender, EventArgs e)
- {
- AddWAPReviewDataExisting();
- }
- protected void LoadTaskData(object sender, EventArgs e)
- {
- if (ddlJobTask1.DataValueField == "0")
- {
- ddlJobTask1.Attributes.Add("class", "border-warning");
- return;
- }
- else
- {
- GetTaskData();
- Button3.Enabled = true;
- Button4.Enabled = true;
- Checklist1.Visible = true;
- }
- }
- protected void AddWAPReviewDataNew()
- {
- using (SqlConnection conn = new SqlConnection(connString))
- {
- using (SqlCommand cmd = new SqlCommand("WAPReviewInsert"))
- {
- cmd.CommandType = CommandType.StoredProcedure;
- {
- cmd.Parameters.AddWithValue("@WAPNo", tmpWAPNo.Text);
- cmd.Parameters.AddWithValue("@ReviewDate", txtDate2.Text);
- cmd.Parameters.AddWithValue("@WorkArea", ddlLocation2.SelectedItem.Value);
- cmd.Parameters.AddWithValue("@Reviewer", txtReviewer2.Text);
- cmd.Parameters.AddWithValue("@Division", ddlDivision.SelectedItem.Value);
- cmd.Parameters.AddWithValue("@Unit", ddlUnit.SelectedItem.Value);
- cmd.Parameters.AddWithValue("@Contractor", ddlContractor.SelectedItem.Value);
- cmd.Parameters.AddWithValue("@WAPType", ddlWAPType.SelectedItem.Value);
- cmd.Parameters.AddWithValue("@JobType", ddlJobType.SelectedItem.Value);
- cmd.Parameters.AddWithValue("@JobTask", ddlJobTask2.SelectedItem.Value);
- cmd.Parameters.AddWithValue("@IssuerBN", IssuerBN.Text);
- cmd.Parameters.AddWithValue("@IssuerName", IssuerName.Text);
- cmd.Parameters.AddWithValue("@ReceiverCN", ReceiverCN.Text);
- cmd.Parameters.AddWithValue("@ReceiverName", ReceiverName.Text);
- cmd.Parameters.AddWithValue("@ChkCategory", ddlChkCategory2.SelectedItem.Value);
- cmd.Parameters.AddWithValue("@ChkDetails", ddlChkDetails2.SelectedItem.Value);
- cmd.Parameters.AddWithValue("@Remarks", txtRemarks2.Text);
- cmd.Connection = conn;
- conn.Open();
- int result = cmd.ExecuteNonQuery();
- if (result > 0)
- {
- ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Record Inserted Successfully')", true);
- }
- }
- }
- }
- }
- protected void AddWAPReviewDataExisting()
- {
- using (SqlConnection conn = new SqlConnection(connString))
- {
- using (SqlCommand cmd = new SqlCommand("WAPReviewInsert"))
- {
- cmd.CommandType = CommandType.StoredProcedure;
- {
- cmd.Parameters.AddWithValue("@WAPNo", tmpWAPNo.Text);
- cmd.Parameters.AddWithValue("@ReviewDate", txtDate1.Text);
- cmd.Parameters.AddWithValue("@WorkArea", ddlLocation1.SelectedItem.Value);
- cmd.Parameters.AddWithValue("@Reviewer", txtReviewer1.Text);
- cmd.Parameters.AddWithValue("@Division", txtDivision.Text);
- cmd.Parameters.AddWithValue("@Unit", txtUnit.Text);
- cmd.Parameters.AddWithValue("@Contractor", txtContractor.Text);
- cmd.Parameters.AddWithValue("@WAPType", txtWAPType.Text);
- cmd.Parameters.AddWithValue("@JobType", txtJobType.Text);
- cmd.Parameters.AddWithValue("@JobTask", ddlJobTask1.SelectedItem.Value);
- cmd.Parameters.AddWithValue("@IssuerBN", txtIssuerBN1.Text);
- cmd.Parameters.AddWithValue("@IssuerName", txtIssuerName1.Text);
- cmd.Parameters.AddWithValue("@ReceiverCN", txtReceiverCN1.Text);
- cmd.Parameters.AddWithValue("@ReceiverName", txtReceiverName1.Text);
- cmd.Parameters.AddWithValue("@ChkCategory", ddlChkCategory1.SelectedItem.Value);
- cmd.Parameters.AddWithValue("@ChkDetails", ddlChkDetails1.SelectedItem.Value);
- cmd.Parameters.AddWithValue("@Remarks", txtRemarks1.Text);
- cmd.Connection = conn;
- conn.Open();
- int result = cmd.ExecuteNonQuery();
- if (result > 0)
- {
- ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Record Inserted Successfully')", true);
- }
- }
- }
- }
- }
- protected void GetIssuerName(object sender, EventArgs e)
- {
- using (SqlConnection conn = new SqlConnection(connString))
- {
- try
- {
- SqlCommand cmd = new SqlCommand("selectIssuerName", conn);
- cmd.CommandType = CommandType.StoredProcedure;
- cmd.Parameters.AddWithValue("@IssuerBN", IssuerBN.Text);
- cmd.Connection = conn;
- conn.Open();
- using (SqlDataReader rdr = cmd.ExecuteReader())
- {
- while (rdr.Read())
- {
- IssuerName.Text = rdr.GetValue(0).ToString();
- }
- }
- }
- catch
- {
- }
- finally
- {
- conn.Close();
- }
- }
- }
- protected void GetReceiverName(object sender, EventArgs e)
- {
- using (SqlConnection conn = new SqlConnection(connString))
- {
- try
- {
- SqlCommand cmd = new SqlCommand("selectReceiverName", conn);
- cmd.CommandType = CommandType.StoredProcedure;
- cmd.Parameters.AddWithValue("@ReceiverCN", ReceiverCN.Text);
- cmd.Connection = conn;
- conn.Open();
- using (SqlDataReader rdr = cmd.ExecuteReader())
- {
- while (rdr.Read())
- {
- ReceiverName.Text = rdr.GetValue(0).ToString();
- }
- }
- }
- catch
- {
- }
- finally
- {
- conn.Close();
- }
- }
- }
- protected void GetLocation1()
- {
- SqlConnection conn = new SqlConnection(connString);
- {
- try
- {
- conn.Open();
- SqlCommand cmd = new SqlCommand("spLocation", conn);
- cmd.CommandType = CommandType.StoredProcedure;
- ddlLocation1.DataSource = cmd.ExecuteReader();
- ddlLocation1.DataTextField = "WorkArea";
- ddlLocation1.DataBind();
- conn.Close();
- }
- catch (Exception)
- {
-
- }
- }
- ddlLocation2.Items.Insert(0, new ListItem("", "0"));
- if (ddlLocation1.SelectedValue == "OTHER")
- {
-
- }
- }
- protected void GetLocation2()
- {
- using (SqlConnection conn = new SqlConnection(connString))
- {
- using (SqlCommand cmd = new SqlCommand("spLocation", conn))
- {
- cmd.CommandType = CommandType.StoredProcedure;
- conn.Open();
- ddlLocation2.DataSource = cmd.ExecuteReader();
- ddlLocation2.DataTextField = "WorkArea";
- ddlLocation2.DataBind();
- }
- }
- ddlLocation2.Items.Insert(0, new ListItem("", "0"));
- }
- protected void GetWAPType()
- {
- using (SqlConnection conn = new SqlConnection(connString))
- {
- using (SqlCommand cmd = new SqlCommand("spWAPType", conn))
- {
- cmd.CommandType = CommandType.StoredProcedure;
- conn.Open();
- ddlWAPType.DataSource = cmd.ExecuteReader();
- ddlWAPType.DataTextField = "WAPType";
- ddlWAPType.DataBind();
- }
- }
- ddlWAPType.Items.Insert(0, new ListItem("Select WAP Type", "0"));
- }
- protected void GetServiceCompany()
- {
- using (SqlConnection conn = new SqlConnection(connString))
- {
- string sqlQuery = "select * from tblContractor";
- using (SqlCommand cmd = new SqlCommand(sqlQuery, conn))
- {
- cmd.CommandType = CommandType.Text;
- conn.Open();
- ddlContractor.DataSource = cmd.ExecuteReader();
- ddlContractor.DataTextField = "Contractor";
- ddlContractor.DataBind();
- conn.Close();
- }
- }
- ddlContractor.Items.Insert(0, new ListItem("Select Service Company", "0"));
- }
- protected void GetJobType()
- {
- SqlConnection conn = new SqlConnection(connString);
- {
- try
- {
- conn.Open();
- SqlCommand cmd = new SqlCommand("spJobType", conn);
- cmd.CommandType = CommandType.StoredProcedure;
- ddlJobType.DataSource = cmd.ExecuteReader();
- ddlJobType.DataTextField = "JobType";
- ddlJobType.DataBind();
- conn.Close();
- }
- catch (Exception)
- {
-
- }
- }
- ddlJobType.Items.Insert(0, new ListItem("Select Job Type", "0"));
- ddlJobTask2.Enabled = false;
- }
- protected void GetJobDetails(object sender, EventArgs e)
- {
- if (ddlJobType.SelectedValue == "0")
- {
- ddlJobTask2.Enabled = false;
- }
- else
- {
- ddlJobTask2.Enabled = true;
- GetJobTask();
- }
- }
- protected void GetJobTask()
- {
- using (SqlConnection conn = new SqlConnection(connString))
- {
- string sqlQuery = "SELECT JobTask FROM tblActivity WHERE JobType=@JobType";
- using (SqlCommand cmd = new SqlCommand(sqlQuery, conn))
- {
- conn.Open();
- cmd.CommandType = CommandType.Text;
- cmd.Parameters.AddWithValue("@JobType", ddlJobType.SelectedValue);
- ddlJobTask2.DataSource = cmd.ExecuteReader();
- ddlJobTask2.DataTextField = "JobTask";
- ddlJobTask2.DataBind();
- }
- }
- ddlJobTask2.Items.Insert(0, new ListItem("Select Job Task", "0"));
- }
- protected void GetJobTaskNew()
- {
- using (SqlConnection conn = new SqlConnection(connString))
- {
- string sqlQuery = "SELECT JobTask FROM WAPTask WHERE WAPNo=@WAPNo And JobType=@JobType And Status=1";
- using (SqlCommand cmd = new SqlCommand(sqlQuery, conn))
- {
- conn.Open();
- cmd.CommandType = CommandType.Text;
- cmd.Parameters.AddWithValue("@WAPNo", tmpWAPNo.Text);
- cmd.Parameters.AddWithValue("@JobType", txtJobType.Text);
- ddlJobTask1.DataSource = cmd.ExecuteReader();
- ddlJobTask1.DataTextField = "JobTask";
- ddlJobTask1.DataBind();
- }
- }
- ddlJobTask1.Items.Insert(0, new ListItem("Select Job Task", "0"));
- }
- protected void GetChkCategory1()
- {
- SqlConnection conn = new SqlConnection(connString);
- {
- try
- {
- conn.Open();
- SqlCommand cmd = new SqlCommand("spChkCategory", conn);
- cmd.CommandType = CommandType.StoredProcedure;
- ddlChkCategory1.DataSource = cmd.ExecuteReader();
- ddlChkCategory1.DataTextField = "ChkCategory";
- ddlChkCategory1.DataBind();
- conn.Close();
- }
- catch (Exception)
- {
-
- }
- }
- ddlChkCategory1.Items.Insert(0, new ListItem("Select Checklist Category", "0"));
- ddlChkDetails1.Enabled = false;
- }
- protected void GetChkCategory2()
- {
- SqlConnection conn = new SqlConnection(connString);
- {
- try
- {
- conn.Open();
- SqlCommand cmd = new SqlCommand("spChkCategory", conn);
- cmd.CommandType = CommandType.StoredProcedure;
- ddlChkCategory2.DataSource = cmd.ExecuteReader();
- ddlChkCategory2.DataTextField = "ChkCategory";
- ddlChkCategory2.DataBind();
- conn.Close();
- }
- catch (Exception)
- {
-
- }
- }
- ddlChkCategory2.Items.Insert(0, new ListItem("Select Checklist Category", "0"));
- ddlChkDetails2.Enabled = false;
- }
- protected void GetChecklistDetails1(object sender, EventArgs e)
- {
- if (ddlChkCategory1.SelectedValue == "0")
- {
- ddlChkDetails1.Enabled = false;
- }
- else
- {
- ddlChkDetails1.Enabled = true;
- GetChkDetails1();
- }
- }
- protected void GetChecklistDetails2(object sender, EventArgs e)
- {
- if (ddlChkCategory2.SelectedValue == "0")
- {
- ddlChkDetails2.Enabled = false;
- }
- else
- {
- ddlChkDetails2.Enabled = true;
- GetChkDetails2();
- }
- }
- protected void GetChkDetails1()
- {
- SqlConnection conn = new SqlConnection(connString);
- {
- try
- {
- conn.Open();
- SqlCommand cmd = new SqlCommand("spChkDetails", conn);
- cmd.CommandType = CommandType.StoredProcedure;
- cmd.Parameters.AddWithValue("@ChkCategory", ddlChkCategory1.SelectedValue);
- ddlChkDetails1.DataSource = cmd.ExecuteReader();
- ddlChkDetails1.DataTextField = "ChkDetails";
- ddlChkDetails1.DataBind();
- conn.Close();
- }
- catch (Exception)
- {
-
- }
- }
- ddlChkDetails1.Items.Insert(0, new ListItem("Select Checklist Details", "0"));
- }
- protected void GetChkDetails2()
- {
- SqlConnection conn = new SqlConnection(connString);
- {
- try
- {
- conn.Open();
- SqlCommand cmd = new SqlCommand("spChkDetails", conn);
- cmd.CommandType = CommandType.StoredProcedure;
- cmd.Parameters.AddWithValue("@ChkCategory", ddlChkCategory2.SelectedValue);
- ddlChkDetails2.DataSource = cmd.ExecuteReader();
- ddlChkDetails2.DataTextField = "ChkDetails";
- ddlChkDetails2.DataBind();
- conn.Close();
- }
- catch (Exception)
- {
-
- }
- }
- ddlChkDetails2.Items.Insert(0, new ListItem("Select Checklist Details", "0"));
- }
- protected void GetDivisionName()
- {
- SqlConnection conn = new SqlConnection(connString);
- {
- try
- {
- conn.Open();
- SqlCommand cmd = new SqlCommand("spDivision", conn);
- cmd.CommandType = CommandType.StoredProcedure;
- ddlDivision.DataSource = cmd.ExecuteReader();
- ddlDivision.DataTextField = "Division";
- ddlDivision.DataBind();
- conn.Close();
- }
- catch (Exception)
- {
-
- }
- }
- ddlDivision.Items.Insert(0, new ListItem("Select Division", "0"));
- ddlUnit.Enabled = false;
- }
- protected void GetDivisionDetails(object sender, EventArgs e)
- {
- if (ddlDivision.SelectedValue == "0")
- {
- ddlUnit.Enabled = false;
- }
- else
- {
- ddlUnit.Enabled = true;
- GetUnitName();
- }
- }
- protected void GetUnitName()
- {
- SqlConnection conn = new SqlConnection(connString);
- {
- try
- {
- conn.Open();
- SqlCommand cmd = new SqlCommand("spUnit", conn);
- cmd.CommandType = CommandType.StoredProcedure;
- cmd.Parameters.Add("@Division", SqlDbType.VarChar).Value = ddlDivision.SelectedValue;
- ddlUnit.DataSource = cmd.ExecuteReader();
- ddlUnit.DataTextField = "Unit";
- ddlUnit.DataBind();
- conn.Close();
- }
- catch (Exception)
- {
-
- }
- ddlUnit.Items.Insert(0, new ListItem("Select Unit", "0"));
- }
- }
- protected void GetData(object sender, EventArgs e)
- {
- if (String.IsNullOrEmpty(tmpWAPNo.Text))
- {
- ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Enter WAP No')", true);
- }
- else
- {
- CheckWAP();
- GetWAPData();
- }
- }
- protected void CheckWAP()
- {
- string sqlQuery = "SELECT Count(*) as result FROM WAPData WHERE WAPNo=@WAPNo";
- using (SqlConnection conn = new SqlConnection(connString))
- {
- using (SqlCommand cmd = new SqlCommand(sqlQuery, conn))
- {
- cmd.CommandType = CommandType.Text;
- cmd.Parameters.AddWithValue("@WAPNo", tmpWAPNo.Text);
- conn.Open();
- int result = (int)cmd.ExecuteScalar();
- if (result > 0)
- {
- GetWAPData();
- GetJobTaskNew();
- ReviewExisting.Visible = true;
- Button2.Enabled = true;
- }
- else
- {
- ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Data not exisiting for this WAP No')", true);
- ReviewNew.Visible = true;
- }
- }
- }
- }
- protected void GetWAPData()
- {
- string sqlQuery = "SELECT * FROM WAPData WHERE WAPNo=@WAPNo";
- using (SqlConnection conn = new SqlConnection(connString))
- {
- using (SqlCommand cmd = new SqlCommand(sqlQuery, conn))
- {
- cmd.CommandType = CommandType.Text;
- cmd.Parameters.AddWithValue("@WAPNo", tmpWAPNo.Text);
- conn.Open();
- using (SqlDataReader rdr = cmd.ExecuteReader())
- {
- while (rdr.Read())
- {
- txtIssueDT1.Text = rdr["IssueDT"].ToString();
- txtJobType.Text = rdr["JobType"].ToString();
- txtWAPType.Text = rdr["WAPType"].ToString();
- txtWellNo1.Text = rdr["WellNo"].ToString();
- txtDivision.Text = rdr["Division"].ToString();
- txtUnit.Text = rdr["Unit"].ToString();
- txtContractor.Text = rdr["Contractor"].ToString();
- }
- }
- }
- }
- }
- public void GetTaskData()
- {
- string sqlQuery = "SELECT * FROM WAPTask WHERE WAPNo=@WAPNo And JobType=@JobType And JobTask=@JobTask And Status=1";
- using (SqlConnection conn = new SqlConnection(connString))
- {
- using (SqlCommand cmd = new SqlCommand(sqlQuery, conn))
- {
- cmd.CommandType = CommandType.Text;
- cmd.Parameters.AddWithValue("@WAPNo", tmpWAPNo.Text);
- cmd.Parameters.AddWithValue("@JobType", txtJobType.Text);
- cmd.Parameters.AddWithValue("@JobTask", ddlJobTask1.SelectedValue);
- conn.Open();
- using (SqlDataReader rdr = cmd.ExecuteReader())
- {
- while (rdr.Read())
- {
- txtIssuerBN1.Text = rdr["IssuerBN"].ToString();
- txtIssuerName1.Text = rdr["IssuerName"].ToString();
- txtReceiverCN1.Text = rdr["ReceiverCN"].ToString();
- txtReceiverName1.Text = rdr["ReceiverName"].ToString();
- }
- }
- }
- }
- }
- }
- }