protected void Button2_Click(object sender, EventArgs e) { int r; mydb db = new mydb(); com = new SqlCommand(); com.CommandText = "SELECT FirstName,LastName,Address,Mobile,Email FROM Register where Email = @Email AND Password = @Password "; com.Parameters.Add("@Email", TextBox3.Text); com.Parameters.Add("@Password", TextBox4.Text); dt = db.gettable(com); if (dt.Rows.Count == 1) { //gen.apwd = "" + TextBox4.Text; gen.name = dt.Rows[0][0].ToString().Trim() + " " + dt.Rows[0][1].ToString().Trim(); gen.add = dt.Rows[0][2].ToString().Trim(); gen.ph = dt.Rows[0][3].ToString().Trim(); gen.email = dt.Rows[0][4].ToString().Trim(); gen.vcode = ""; gen.vtype = ""; gen.vprice = "" + 0; gen.scode = ""; gen.stype = ""; gen.sprice = "" + 0; gen.pcode = ""; gen.ptype = ""; gen.pprice = "" + 0; gen.ccode = ""; gen.ctype = ""; gen.cprice = "" + 0; gen.tcode = ""; gen.ttype = ""; gen.tprice = "" + 0; gen.fcode = ""; gen.ftype = ""; gen.fprice = "" + 0; gen.sgcode = ""; gen.sgtype = ""; gen.sgprice = "" + 0; Response.Redirect("pgm.aspx"); } else { Label1.Text = "Login Failed...."; } }
protected void Button1_Click(object sender, EventArgs e) { int a = 0; com = new SqlCommand(); com.CommandText = "SELECT Sqfeet,Price,Description,Image from Stage where Itemcode=@Itemcode"; com.Parameters.Add("@Itemcode", "" + DropDownList2.SelectedItem.ToString()); dt = db.gettable(com); TextBox6.Text = "" + dt.Rows[0][0].ToString().Trim(); TextBox7.Text = "" + dt.Rows[0][1].ToString().Trim(); TextBox8.Text = "" + dt.Rows[0][2].ToString().Trim(); Image1.ImageUrl = "" + dt.Rows[0][3].ToString().Trim(); Panel1.Visible = true; }
protected void Button1_Click(object sender, EventArgs e) { int a = 0; com = new SqlCommand(); com.CommandText = "SELECT CamType,Duration,Price,Image from Video where ItemCode=@ItemCode"; com.Parameters.Add("@ItemCode", "" + DropDownList2.SelectedItem.ToString()); dt = db.gettable(com); TextBox1.Text = "" + dt.Rows[0][0].ToString().Trim(); TextBox2.Text = "" + dt.Rows[0][1].ToString().Trim(); TextBox3.Text = "" + dt.Rows[0][2].ToString().Trim(); Image1.ImageUrl = "" + dt.Rows[0][3].ToString().Trim(); Panel1.Visible = true; }
protected void Button1_Click(object sender, EventArgs e) { int a = 0; com = new SqlCommand(); com.CommandText = "SELECT Pandaltype,Sqfeet,Noofchair,Price,Description,Nooffans,Nooflights,Image from Decoration where Itemcode=@Itemcode"; com.Parameters.Add("@Itemcode", "" + DropDownList1.SelectedItem.ToString()); dt = db.gettable(com); TextBox10.Text = "" + dt.Rows[0][0].ToString().Trim(); TextBox11.Text = "" + dt.Rows[0][1].ToString().Trim(); TextBox12.Text = "" + dt.Rows[0][2].ToString().Trim(); TextBox13.Text = "" + dt.Rows[0][3].ToString().Trim(); TextBox14.Text = "" + dt.Rows[0][4].ToString().Trim(); TextBox15.Text = "" + dt.Rows[0][5].ToString().Trim(); TextBox16.Text = "" + dt.Rows[0][6].ToString().Trim(); Image1.ImageUrl = "" + dt.Rows[0][7].ToString().Trim(); Panel1.Visible = true; }
protected void Button1_Click(object sender, EventArgs e) { int a = 0; com = new SqlCommand(); com.CommandText = "SELECT Vehicle,Name,Bustype,Noofseats,Duration,Price,Description,Image from Travel where ItemCode=@ItemCode"; com.Parameters.Add("@Itemcode", "" + DropDownList1.SelectedItem.ToString()); dt = db.gettable(com); DropDownList4.Text = "" + dt.Rows[0][0].ToString().Trim(); TextBox5.Text = "" + dt.Rows[0][1].ToString().Trim(); DropDownList5.Text = "" + dt.Rows[0][2].ToString().Trim(); DropDownList2.Text = "" + dt.Rows[0][3].ToString().Trim(); TextBox2.Text = "" + dt.Rows[0][4].ToString().Trim(); TextBox1.Text = "" + dt.Rows[0][5].ToString().Trim(); TextBox4.Text = "" + dt.Rows[0][6].ToString().Trim(); Image1.ImageUrl = "" + dt.Rows[0][7].ToString().Trim(); Panel1.Visible = true; }
protected void Button1_Click(object sender, EventArgs e) { int a = 0; cmd = new SqlCommand(); com.CommandText = "SELECT * from adminlogin where Password=@Password "; com.Parameters.AddWithValue("@Password", Session["pass"] + ""); DataRow dr = db.gettable(com).Rows[0]; if (dr["Password"] + "" == TextBox1.Text) { com.CommandText = "update adminlogin set Password=@Password where Password=@Password"; com.Parameters.AddWithValue("@Password", TextBox2.Text); } a = db.update(cmd); if (a == 1) { Response.Redirect("./change_passwrd1.aspx"); } }
protected void Button1_Click(object sender, EventArgs e) { int r; mydb db = new mydb(); com = new SqlCommand(); com.CommandText = "SELECT Name FROM adminlogin where Name = @Name AND Password = @Password "; com.Parameters.AddWithValue("@Name", TextBox1.Text); com.Parameters.AddWithValue("@Password", TextBox2.Text); dt = db.gettable(com); if (dt.Rows.Count == 1) { //gen.apwd = "" + TextBox2.Text; Session["user"] = TextBox1.Text; Session["pass"] = TextBox2.Text; Response.Redirect("./adminhome.aspx"); } else { Label1.Text = "Login Failed...."; } }
protected void Page_Load(object sender, EventArgs e) { db = new mydb(); com1 = new SqlCommand(); com1.CommandText = "SELECT Itemcode,Pandaltype,Sqfeet,Price,Image,Noofchair,Description,Nooffans,Nooflights FROM Decoration"; //com1.Parameters.Add("@type", "" + gen.ftype); dt = db.gettable(com1); int c = dt.Rows.Count; if (c > 0) { TextBox9.Text = "" + dt.Rows[0][1].ToString().Trim(); TextBox1.Text = "" + dt.Rows[0][3].ToString().Trim(); Image1.ImageUrl = "" + dt.Rows[0][4].ToString().Trim(); Panel1.Visible = true; c1 = "" + dt.Rows[0][0].ToString().Trim(); t1 = "" + dt.Rows[0][1].ToString().Trim(); d1 = "" + dt.Rows[0][2].ToString().Trim(); p1 = "" + dt.Rows[0][3].ToString().Trim(); i1 = "" + dt.Rows[0][4].ToString().Trim(); c--; } if (c > 0) { TextBox2.Text = "" + dt.Rows[1][1].ToString().Trim(); TextBox3.Text = "" + dt.Rows[1][3].ToString().Trim(); Image2.ImageUrl = "" + dt.Rows[1][4].ToString().Trim(); Panel2.Visible = true; c2 = "" + dt.Rows[1][0].ToString().Trim(); t2 = "" + dt.Rows[1][1].ToString().Trim(); d2 = "" + dt.Rows[1][2].ToString().Trim(); p2 = "" + dt.Rows[1][3].ToString().Trim(); i2 = "" + dt.Rows[1][4].ToString().Trim(); c--; } if (c > 0) { TextBox4.Text = "" + dt.Rows[2][1].ToString().Trim(); TextBox5.Text = "" + dt.Rows[2][3].ToString().Trim(); Image3.ImageUrl = "" + dt.Rows[2][4].ToString().Trim(); Panel3.Visible = true; c3 = "" + dt.Rows[2][0].ToString().Trim(); t3 = "" + dt.Rows[2][1].ToString().Trim(); d3 = "" + dt.Rows[2][2].ToString().Trim(); p3 = "" + dt.Rows[2][3].ToString().Trim(); i3 = "" + dt.Rows[2][4].ToString().Trim(); c--; } if (c > 0) { TextBox6.Text = "" + dt.Rows[3][1].ToString().Trim(); TextBox7.Text = "" + dt.Rows[3][3].ToString().Trim(); Image4.ImageUrl = "" + dt.Rows[3][4].ToString().Trim(); Panel4.Visible = true; c4 = "" + dt.Rows[3][0].ToString().Trim(); t4 = "" + dt.Rows[3][1].ToString().Trim(); d4 = "" + dt.Rows[3][2].ToString().Trim(); p4 = "" + dt.Rows[3][3].ToString().Trim(); i4 = "" + dt.Rows[3][4].ToString().Trim(); c--; } if (c > 0) { TextBox8.Text = "" + dt.Rows[4][1].ToString().Trim(); TextBox10.Text = "" + dt.Rows[4][3].ToString().Trim(); Image5.ImageUrl = "" + dt.Rows[4][4].ToString().Trim(); Panel5.Visible = true; c5 = "" + dt.Rows[4][0].ToString().Trim(); t5 = "" + dt.Rows[4][1].ToString().Trim(); d5 = "" + dt.Rows[4][2].ToString().Trim(); p5 = "" + dt.Rows[4][3].ToString().Trim(); i5 = "" + dt.Rows[4][4].ToString().Trim(); c--; } if (c > 0) { TextBox11.Text = "" + dt.Rows[4][1].ToString().Trim(); TextBox12.Text = "" + dt.Rows[4][3].ToString().Trim(); Image6.ImageUrl = "" + dt.Rows[4][4].ToString().Trim(); Panel6.Visible = true; c6 = "" + dt.Rows[4][0].ToString().Trim(); t6 = "" + dt.Rows[4][1].ToString().Trim(); d6 = "" + dt.Rows[4][2].ToString().Trim(); p6 = "" + dt.Rows[4][3].ToString().Trim(); i6 = "" + dt.Rows[4][4].ToString().Trim(); c--; } }