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--;
}
}
