protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
if (Request.QueryString["menu"] == "5")
{
DetailsView5.Focus();
this.DetailsView5.ChangeMode(DetailsViewMode.ReadOnly);
}
if (Request.QueryString["menu"] == "4")
{
DetailsView2.Focus();
this.DetailsView2.ChangeMode(DetailsViewMode.ReadOnly);
}
if (Request.QueryString["menu"] == "3")
{
DetailsView1.Focus();
this.DetailsView1.ChangeMode(DetailsViewMode.ReadOnly);
}
if (Request.QueryString["menu"] == "2")
{
DetailsView3.Focus();
this.DetailsView3.ChangeMode(DetailsViewMode.ReadOnly);
}
if (Request.QueryString["menu"] == "1")
{
DetailsView4.Focus();
this.DetailsView4.ChangeMode(DetailsViewMode.ReadOnly);
}
}
protected void newResponseButton_Click(object sender, EventArgs e)
{
if (DetailsView3.CurrentMode == DetailsViewMode.Insert)
{
DetailsView3.ChangeMode(DetailsViewMode.ReadOnly);
}
else
{
DetailsView3.ChangeMode(DetailsViewMode.Insert);
}
}
protected void DeluxePager1_CommonPageIndexChanged(object sender, EventArgs e)
{
DataSet ds = ObjData.GetPagerList(DeluxePager1.PageSize, DeluxePager1.PageIndex);
int recordCount = ObjData.GetOrdersCount();
DeluxePager1.RecordCount = recordCount;
DetailsView3.DataSource = ds;
DetailsView3.DataBind();
}
protected void Button9_Click(object sender, EventArgs e)
{
int rid = 0;
string cantpic = "";
string cstpic = "";
string cstname = "";
string stcn = "Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|Database1.mdf;Integrated Security=True;User Instance=True";
SqlConnection con = new SqlConnection(stcn);
con.Open();
SqlCommand cmd = new SqlCommand("select * from review", con);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
rid++;
}
}
rid++;
con.Close();
con.Open();
if (DropDownList1.SelectedItem.Text.Equals("Spicy Bite"))
{
SqlCommand cmd1 = new SqlCommand("select * from canteen where cid = '" + DropDownList1.SelectedValue + "'", con);
SqlDataReader dr1 = cmd1.ExecuteReader();
dr1.Read();
cantpic = dr1["cphoto"].ToString();
}
con.Close();
con.Open();
SqlCommand cmd2 = new SqlCommand("select * from customer where custid = '" + cuid + "'", con);
SqlDataReader dr2 = cmd2.ExecuteReader();
dr2.Read();
cstpic = dr2["custphoto"].ToString();
cstname = dr2["custname"].ToString();
con.Close();
string stcn1 = "Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|Database1.mdf;Integrated Security=True;User Instance=True";
SqlConnection con1 = new SqlConnection(stcn1);
con1.Open();
SqlCommand cmd3 = new SqlCommand("insert into review values('" + rid + "','" + cuid + "','" + DropDownList1.SelectedValue + "','" + TextBox1.Text + "','" + DropDownList1.SelectedItem.Text + "','" + cantpic + "','" + cstname + "','" + cstpic + "' ) ", con1);
cmd3.ExecuteNonQuery();
con1.Close();
DetailsView3.DataBind();
Panel2.Visible = false;
//Label1.Text = "Successfull.";
}
private void InitializePagers()
{
DeluxePager1.PageIndex = 0;
DataSet ds = ObjData.GetPagerList(DeluxePager1.PageSize, DeluxePager1.PageIndex);
int recordCount = ObjData.GetOrdersCount();
DeluxePager1.RecordCount = recordCount;
DetailsView3.DataSource = ds;
DetailsView3.DataBind();
}
protected void Button1_Click(object sender, EventArgs e)
{
//string selectedItem= ComboBox1.SelectedValue;
//SqlDataSource4.DataBind();
//SqlDataSource5.DataBind();
//SqlDataSource1.DataBind();
GridView1.DataBind();
GridView2.DataBind();
DetailsView1.DataBind();
//DetailsView2.DataBind();
DetailsView3.DataBind();
//System.Threading.Thread.Sleep(2000);
//Response.Redirect("Admin.aspx?companyListBox.SelectedValue=" + companyListBox.SelectedValue);
}
protected void Page_Load(object sender, EventArgs e)
{
DataTable table = new DataTable();
table.Columns.AddRange(new DataColumn[] { new DataColumn("key1"), new DataColumn("value1") });
table.Rows.Add("1", "2");
DetailsView1.DataSource = table;
DetailsView1.DataBind();
DetailsView3.DataSource = table;
DetailsView3.DataBind();
table = new DataTable();
DetailsView2.DataSource = table;
DetailsView1.Height = 0;
DetailsView2.DataBind();
}
private void displayDetails(int productid)
{
using (SqlConnection con = new SqlConnection(ConnectionString))
{
using (SqlCommand cmd = new SqlCommand("SELECT * from tblSpecifications,tblMeasurement,tblLook,tblInstallation where tblSpecifications.ProductId=tblLook.ProductId and tblLook.ProductId=tblInstallation.ProductId and tblInstallation.ProductId=tblMeasurement.ProductId and tblMeasurement.ProductId=@id;"))
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@id", SqlDbType.Int).Value = productid;
cmd.Connection = con;
try
{
con.Open();
using (SqlDataAdapter sda = new SqlDataAdapter(cmd))
{
using (DataTable dt = new DataTable())
{
sda.Fill(dt);
if (dt.Rows.Count > 0)
{
DetailsView1.DataSource = dt;
DetailsView1.DataBind();
DetailsView2.DataSource = dt;
DetailsView2.DataBind();
DetailsView3.DataSource = dt;
DetailsView3.DataBind();
DetailsView4.DataSource = dt;
DetailsView4.DataBind();
divDetails.Style.Add("display", "block");
}
}
}
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
finally
{
con.Close();
con.Dispose();
}
}
}
}
protected void DetailsView_ItemCommand(object sender, DetailsViewCommandEventArgs e)
{
#region ItemCommand Action
if (e.CommandName == "Clear")
{
GridView1.SelectedIndex = -1;
DetailsView1.DataBind();
DetailsView2.DataBind();
DetailsView3.DataBind();
DetailsView4.DataBind();
DetailsView5.DataBind();
}
if (e.CommandName == "Update")
{
DetailsView dv = (DetailsView)sender;
WriteToLabel("new", "Blue", dv.ID + " Update Processed [" + DateTime.Now.ToString("HH:mm:ss") + "]<br />", dtlLabel);
}
//dtlLabel.Text = e.CommandName;
#endregion ItemCommand Action
}
protected void Page_Load(object sender, EventArgs e)
{
string ID = Session["ActivityIDTest"].ToString();
string selectAct = "SELECT * FROM Activities WHERE Activity_ID = " + ID + ";";
DataTable dt = dbconn.QueryExecuteScalar(selectAct);
string CheckType = dt.Rows[0]["Activity_Type"].ToString();
if (CheckType == "Campaign")
{
string ID1 = Session["ActivityIDTest"].ToString();
DetailsView1.Visible = true;
string CampaignDetail = "SELECT Activity_ID, Activities.AT_ID, Activity_Type, Activity_Name, Activity_StartDate, Activity_EndDate, Activity_Place, Activity_Type Activity_Province, Activity_Status, Activities.CAMP_ID, AT_Name, CAMP_Name FROM Activities ,ActionTypes , CampaignTypes WHERE Activities.AT_ID = ActionTypes.AT_ID AND Activities.CAMP_ID = CampaignTypes.CAMP_ID AND Activities.Activity_Type = 'Campaign' AND Activities.Activity_ID = " + ID1 + ";";
DataTable dt2 = dbconn.QueryExecuteScalar(CampaignDetail);
DetailsView1.DataSource = dt2;
DetailsView1.DataBind();
}
else if (CheckType == "Training")
{
string ID1 = Session["ActivityIDTest"].ToString();
DetailsView2.Visible = true;
string TrainDetail = "SELECT Activity_ID, Activities.AT_ID, Activity_Name, Activity_StartDate,Activity_Type, Activity_EndDate, Activity_Place, Activity_Province, Activity_Status, Activities.TTY_ID, Activities.TT_ID, Activities.TC_ID,TTY_Name, TT_Name, TC_Name FROM Activities , TrainingCatagories , TrainingTeams , TrainingTypes WHERE Activities.Activity_Type = 'Training' AND Activities.Activity_ID = " + ID1 + " AND Activities.TTY_ID = TrainingTypes.TTY_ID AND Activities.TT_ID = TrainingTeams.TT_ID AND Activities.TC_ID = TrainingCatagories.TC_ID ;";
DataTable dt3 = dbconn.QueryExecuteScalar(TrainDetail);
DetailsView2.DataSource = dt3;
DetailsView2.DataBind();
}
else
{
string ID1 = Session["ActivityIDTest"].ToString();
DetailsView3.Visible = true;
string GADetail = "SELECT Activity_ID,Activity_Name, Activity_StartDate, Activity_EndDate, Activity_Place,Activity_Province, Activity_Status, Activity_Type FROM Activities WHERE Activity_Type = 'General Activity' AND Activity_ID = " + ID1 + ";";
DataTable dt4 = dbconn.QueryExecuteScalar(GADetail);
DetailsView3.DataSource = dt4;
DetailsView3.DataBind();
}
dbconn.Close();
}
protected void DetailsView1_ModeChanged(object sender, EventArgs e)
{
if (Request.QueryString["menu"] == "5")
{
DetailsView5.Focus();
}
if (Request.QueryString["menu"] == "4")
{
DetailsView2.Focus();
}
if (Request.QueryString["menu"] == "3")
{
DetailsView1.Focus();
}
if (Request.QueryString["menu"] == "2")
{
DetailsView3.Focus();
}
if (Request.QueryString["menu"] == "1")
{
DetailsView4.Focus();
}
}
