protected void Button2_Click(object sender, EventArgs e)
{
ccc = new SqlCommand();
ccc.CommandText = "delete from Stage where Itemcode=@Itemcode";
ccc.Parameters.Add("@Itemcode", DropDownList2.SelectedItem.ToString());
db.insert(ccc);
int a = 0;
cmd = new SqlCommand();
cmd.CommandText = "INSERT INTO Stage(Itemcode,SqFeet,Price,Description,Image)VALUES (@ItemCode,@SqFeet,@Price,@Description,@Image)";
cmd.Parameters.Add("@ItemCode", DropDownList2.SelectedItem.ToString());
cmd.Parameters.Add("@Sqfeet", TextBox6.Text);
cmd.Parameters.Add("@Price", TextBox7.Text);
cmd.Parameters.Add("@Description", TextBox8.Text);
if (FileUpload1.HasFile)
{
fileName = FileUpload1.FileName.ToString();
string uploadFolderPath = "~/img/";
string filePath = HttpContext.Current.Server.MapPath(uploadFolderPath);
FileUpload1.SaveAs(filePath + "\\" + fileName);
cmd.Parameters.Add("@image", "~/img/" + fileName);
}
else
{
string file = "" + Image1.ImageUrl;
cmd.Parameters.Add("@image", file);
}
a = db.insert(cmd);
if (a == 1)
{
Response.Redirect("~/updatesuccess.aspx");
}
}
protected void Button1_Click(object sender, EventArgs e)
{
if (FileUpload1.HasFile)
{
string fileName = FileUpload1.FileName.ToString();
string uploadFolderPath = "~/img/";
string filePath = HttpContext.Current.Server.MapPath(uploadFolderPath);
FileUpload1.SaveAs(filePath + "\\" + fileName);
int a = 0;
mydb db = new mydb();
cmd = new SqlCommand();
cmd.CommandText = "INSERT INTO Food(ItemCode,Name,Price,Receipe,Description,Image)VALUES (@ItemCode,@Name,@Price,@Receipe,@Description,@Image)";
cmd.Parameters.Add("@ItemCode", TextBox6.Text);
cmd.Parameters.Add("@Name", TextBox7.Text);
cmd.Parameters.Add("@Price", TextBox8.Text);
cmd.Parameters.Add("@Receipe", TextBox9.Text);
cmd.Parameters.Add("@Description", TextBox10.Text);
cmd.Parameters.Add("@Image", "~/img/" + fileName);
a = db.insert(cmd);
if (a == 1)
{
Response.Redirect("./addsuccess.aspx");
}
}
}
protected void Button2_Click(object sender, EventArgs e)
{
if (FileUpload1.HasFile)
{
string fileName = FileUpload1.FileName.ToString();
string uploadFolderPath = "~/img/";
string filePath = HttpContext.Current.Server.MapPath(uploadFolderPath);
FileUpload1.SaveAs(filePath + "\\" + fileName);
int a = 0;
mydb db = new mydb();
cmd = new SqlCommand();
cmd.CommandText = "INSERT INTO Decoration(Itemcode,Pandaltype,Sqfeet,Noofchair,Price,Description,Nooffans,Nooflights,Image)VALUES (@Itemcode,@Pandaltype,@Sqfeet,@Noofchair,@Price,@Description,@Nooffans,@Nooflights,@Image)";
cmd.Parameters.Add("@Itemcode", TextBox9.Text);
cmd.Parameters.Add("@Pandaltype", TextBox10.Text);
cmd.Parameters.Add("@Sqfeet", TextBox11.Text);
cmd.Parameters.Add("@Noofchair", TextBox12.Text);
cmd.Parameters.Add("@Price", TextBox13.Text);
cmd.Parameters.Add("@Description", TextBox14.Text);
cmd.Parameters.Add("@Nooffans", TextBox15.Text);
cmd.Parameters.Add("@Nooflights", TextBox16.Text);
cmd.Parameters.Add("@Image", "~/img/" + fileName);
a = db.insert(cmd);
if (a == 1)
{
Response.Redirect("./addsuccess.aspx");
}
}
}
protected void Button2_Click(object sender, EventArgs e)
{
if (FileUpload1.HasFile)
{
string fileName = FileUpload1.FileName.ToString();
string uploadFolderPath = "~/img/";
string filePath = HttpContext.Current.Server.MapPath(uploadFolderPath);
FileUpload1.SaveAs(filePath + "\\" + fileName);
int a = 0;
mydb db = new mydb();
cmd = new SqlCommand();
cmd.CommandText = "INSERT INTO Travel(ItemCode,Vehicle,Name,Bustype,Noofseats,Duration,Price,Description,Image)VALUES (@ItemCode,@Vehicle,@Name,@Bustype,@Noofseats,@Duration,@Price,@Description,@Image)";
cmd.Parameters.Add("@ItemCode", TextBox3.Text);
cmd.Parameters.Add("@Vehicle", DropDownList4.Text);
cmd.Parameters.Add("@Name", TextBox5.Text);
cmd.Parameters.Add("@Bustype", DropDownList5.Text);
cmd.Parameters.Add("@Noofseats", DropDownList1.Text);
cmd.Parameters.Add("@Duration", TextBox2.Text);
cmd.Parameters.Add("@Price", TextBox1.Text);
cmd.Parameters.Add("@Description", TextBox4.Text);
cmd.Parameters.Add("@Image", "~/img/" + fileName);
a = db.insert(cmd);
if (a == 1)
{
Response.Redirect("./addsuccess.aspx");
}
}
}
protected void Button2_Click(object sender, EventArgs e)
{
ccc = new SqlCommand();
ccc.CommandText = "delete from Travel where ItemCode=@ItemCode";
ccc.Parameters.Add("@ItemCode", DropDownList1.SelectedItem.ToString());
db.insert(ccc);
int a = 0;
cmd = new SqlCommand();
cmd.CommandText = "INSERT INTO Travel(ItemCode,Vehicle,Name,Bustype,Noofseats,Duration,Price,Description,Image)VALUES (@ItemCode,@Vehicle,@Name,@Bustype,@Noofseats,@Duration,@Price,@Description,@Image)";
cmd.Parameters.Add("@ItemCode", DropDownList1.SelectedItem.ToString());
cmd.Parameters.Add("@Vehicle", DropDownList4.Text);
cmd.Parameters.Add("@Name", TextBox5.Text);
cmd.Parameters.Add("@Bustype", DropDownList5.Text);
cmd.Parameters.Add("@Noofseats", DropDownList2.Text);
cmd.Parameters.Add("@Duration", TextBox2.Text);
cmd.Parameters.Add("@Price", TextBox1.Text);
cmd.Parameters.Add("@Description", TextBox4.Text);
if (FileUpload1.HasFile)
{
fileName = FileUpload1.FileName.ToString();
string uploadFolderPath = "~/img/";
string filePath = HttpContext.Current.Server.MapPath(uploadFolderPath);
FileUpload1.SaveAs(filePath + "\\" + fileName);
cmd.Parameters.Add("@image", "~/img/" + fileName);
}
else
{
string file = "" + Image1.ImageUrl;
cmd.Parameters.Add("@image", file);
}
a = db.insert(cmd);
if (a == 1)
{
Response.Redirect("~/updatesuccess.aspx");
}
}
protected void Button1_Click(object sender, EventArgs e)
{
int a = 0;
mydb db = new mydb();
cmd = new SqlCommand();
cmd.CommandText = "INSERT INTO payment(name,address,mobile,email,date,card,cardnum,nameonthecard,expirydate,cvv,video,code1,price1,stills,code2,price2,decoration,code3,price3,Costumes,code4,price4,travels,code5,price5,food,code6,price6,stage,code7,price7,total,purpose,deliverydate,deliverytime)VALUES (@name,@address,@mobile,@email,@date,@card,@cardnum,@nameonthecard,@expirydate,@cvv,@video,@code1,@price1,@stills,@code2,@price2,@decoration,@code3,@price3,@Costumes,@code4,@price4,@travels,@code5,@price5,@food,@code6,@price6,@stage,@code7,@price7,@total,@purpose,@deliverydate,@deliverytime)";
cmd.Parameters.Add("@name", gen.name);
cmd.Parameters.Add("@address", gen.add);
cmd.Parameters.Add("@mobile", gen.ph);
cmd.Parameters.Add("@email", gen.email);
cmd.Parameters.Add("@date", TextBox1.Text);
cmd.Parameters.Add("@card", DropDownList1.SelectedItem.Value);
cmd.Parameters.Add("@cardnum", TextBox7.Text);
cmd.Parameters.Add("@nameonthecard", TextBox8.Text);
cmd.Parameters.Add("@expirydate", DropDownList3.SelectedItem.Value + "-" + DropDownList4.SelectedItem.Value);
cmd.Parameters.Add("@cvv", TextBox9.Text);
cmd.Parameters.Add("@video", "video");
cmd.Parameters.Add("@code1", gen.vcode);
cmd.Parameters.Add("@price1", gen.vprice);
cmd.Parameters.Add("@stills", "stills");
cmd.Parameters.Add("@code2", gen.scode);
cmd.Parameters.Add("@price2", gen.sprice);
cmd.Parameters.Add("@decoration", "decoration");
cmd.Parameters.Add("@code3", gen.pcode);
cmd.Parameters.Add("@price3", gen.pprice);
cmd.Parameters.Add("@Costumes", "Costumes");
cmd.Parameters.Add("@code4", gen.ccode);
cmd.Parameters.Add("@price4", gen.cprice);
cmd.Parameters.Add("@travels", "travels");
cmd.Parameters.Add("@code5", gen.tcode);
cmd.Parameters.Add("@price5", gen.tprice);
cmd.Parameters.Add("@food", "food");
cmd.Parameters.Add("@code6", gen.fcode);
cmd.Parameters.Add("@price6", gen.fprice);
cmd.Parameters.Add("@stage", "stage");
cmd.Parameters.Add("@code7", gen.sgcode);
cmd.Parameters.Add("@price7", gen.sgprice);
cmd.Parameters.Add("@total", gen.total);
cmd.Parameters.Add("@purpose", DropDownList11.SelectedItem.Value);
cmd.Parameters.Add("@deliverydate", DropDownList5.SelectedItem.Value + "-" + DropDownList9.SelectedItem.Value + "-" + DropDownList6.SelectedItem.Value);
cmd.Parameters.Add("@deliverytime", DropDownList7.SelectedItem.Value + "-" + DropDownList8.SelectedItem.Value + "-" + DropDownList10.SelectedItem.Value);
a = db.insert(cmd);
if (a == 1)
{
Response.Redirect("./booked.aspx");
}
}
protected void Button1_Click(object sender, EventArgs e)
{
int a = 0;
mydb db = new mydb();
cmd = new SqlCommand();
cmd.CommandText = "INSERT INTO Feedback(Name,Email,Message)VALUES(@Name,@Email,@Message)";
cmd.Parameters.Add("@Name", TextBox1.Text);
cmd.Parameters.Add("@Email", TextBox2.Text);
cmd.Parameters.Add("@Message", TextBox3.Text);
a = db.insert(cmd);
if (a == 1)
{
Response.Redirect("feedbksubmit.aspx");
}
}
protected void Button1_Click(object sender, EventArgs e)
{
{
int a = 0;
mydb db = new mydb();
cmd = new SqlCommand();
cmd.CommandText = "INSERT INTO adminlogin(Name,Password,Email,Mobile)VALUES (@Name,@Password,@Email,@Mobile)";
cmd.Parameters.Add("@Name", TextBox1.Text + TextBox2.Text);
cmd.Parameters.Add("@Password", TextBox3.Text);
cmd.Parameters.Add("@Email", TextBox5.Text);
cmd.Parameters.Add("@Mobile", TextBox6.Text + TextBox7.Text);
a = db.insert(cmd);
if (a == 1)
{
Response.Redirect("./registeredsuccess1.aspx");
}
}
}
protected void Button2_Click(object sender, EventArgs e)
{
if (DropDownList1.SelectedItem == null)
{
Label1.Text = "Null not allowed";
}
else
{
int a = 0;
mydb db = new mydb();
cmd = new SqlCommand();
cmd.CommandText = "delete from stills where itemcode=@itemcode";
cmd.Parameters.Add("@itemcode", DropDownList1.SelectedItem.ToString());
a = db.insert(cmd);
if (a == 1)
{
Response.Redirect("~/deletesuccess.aspx");
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
{
int a = 0;
mydb db = new mydb();
cmd = new SqlCommand();
cmd.CommandText = "INSERT INTO Register(FirstName,LastName,Address,State,District,DateOfBirth,Gender,Email,Mobile,Password)VALUES (@FirstName,@LastName,@Address,@State,@District,@DateOfBirth,@Gender,@Email,@Mobile,@Password)";
cmd.Parameters.Add("@FirstName", TextBox1.Text);
cmd.Parameters.Add("@LastName", TextBox2.Text);
cmd.Parameters.Add("@Address", TextBox3.Text);
cmd.Parameters.Add("@State", DropDownList1.SelectedItem.Value);
cmd.Parameters.Add("@District", DropDownList2.SelectedItem.Value);
cmd.Parameters.Add("@DateOfBirth", TextBox9.Text);
cmd.Parameters.Add("@Gender", RadioButtonList1.SelectedItem.Value);
cmd.Parameters.Add("@Email", TextBox4.Text);
cmd.Parameters.Add("@Mobile", TextBox5.Text + TextBox6.Text);
cmd.Parameters.Add("@Password", TextBox7.Text);
a = db.insert(cmd);
if (a == 1)
{
Response.Redirect("./registeredsucces.aspx");
}
}
}
