protected void Button1_Click(object sender, EventArgs e)
{
if (flag == 1)
{
con.ExecuteCommand("insert into executive_bio values('" + Session["Username"].ToString() + "','" + NameBox.Text + "','" + Session["Photo"].ToString() + "','" + QBox.SelectedValue.ToString() + "','" + ExpBox.Text + "' )");
Response.Redirect("executivebio.aspx");
}
if (flag == 0)
{
con.ExecuteCommand("update executive_bio set bio='" + NameBox.Text + "', photo='" + Session["Photo"].ToString() + "',qualification='" + QBox.SelectedValue.ToString() + "',exp='" + ExpBox.Text + "' where designerid='" + Session["Username"].ToString() + "' ");
Response.Redirect("executivebio.aspx");
}
}
protected void DataList1_ItemCommand(object source, DataListCommandEventArgs e)
{
if (e.CommandName.ToString() == "Approve")
{
con.ExecuteCommand("update Registration set Status=1 where Email='" + e.CommandArgument.ToString() + "' ");
Response.Redirect("ViewCustomers.aspx");
}
if (e.CommandName.ToString() == "Reject")
{
con.ExecuteCommand("update Registration set Status=2 where Email='" + e.CommandArgument.ToString() + "' ");
Response.Redirect("ViewCustomers.aspx");
}
}
protected void Button1_Click(object sender, EventArgs e)
{
if ((Convert.ToInt32(MaxQtyBox.Text) >= 1) && (Convert.ToInt32(MinQtyBox.Text) >= 1) && (Convert.ToInt32(MaxQtyBox.Text) >= Convert.ToInt32(MinQtyBox.Text)))
{
if ((Convert.ToInt32(DiscountBox.Text) < 0) || (Convert.ToInt32(DiscountBox.Text) >= 100))
{
Response.Write("<script>alert('The discount percentage should be a valid amount')</script>");
}
else
{
if ((Convert.ToInt32(PriceBox.Text) < 0))
{
Response.Write("<script>alert('The price should be a valid amount')</script>");
}
else
{
if ((Convert.ToInt32(Delivery.Text) < 0))
{
Response.Write("<script>alert('The delivery period should be a valid number')</script>");
}
else
{
con.ExecuteCommand("insert into tbl_productdetails values('" + Session["Username"].ToString() + "','" + ProductBox.Text + "','" + Session["Photo"].ToString() + "','" + DescriptionBox.Text + "','" + CategoryBox.SelectedValue + "','" + SizeBox.SelectedValue + "','" + MaxQtyBox.Text + "','" + MinQtyBox.Text + "','" + PriceBox.Text + "','" + DiscountBox.Text + "','" + System.DateTime.Today.Date + "','" + Delivery.Text + "')");
Response.Redirect("ProductDetails.aspx");
}
}
}
}
else
{
Response.Write("<script>alert('Max. quantity shouldnot be less than minimum quantity')</script>");
}
}
protected void Button1_Click(object sender, EventArgs e)
{
if ((Convert.ToInt32(MaxQtyBox.Text) >= 1) && (Convert.ToInt32(MinQtyBox.Text) >= 1) && (Convert.ToInt32(MaxQtyBox.Text) >= Convert.ToInt32(MinQtyBox.Text)))
{
if ((Convert.ToInt32(DiscountBox.Text) < 0) || (Convert.ToInt32(DiscountBox.Text) >= 100))
{
Response.Write("<script>alert('The discount percentage should be a valid amount')</script>");
}
else
{
if ((Convert.ToInt32(PriceBox.Text) < 0))
{
Response.Write("<script>alert('The price should be a valid amount')</script>");
}
else
{
con.ExecuteCommand("update tbl_productdetails set productname='" + ProductBox.Text + "', description='" + DescriptionBox.Text + "',category='" + CategoryBox.SelectedValue + "',size='" + SizeBox.SelectedValue + "',maxqty='" + MaxQtyBox.Text + "',minqty='" + MinQtyBox.Text + "',price='" + PriceBox.Text + "',discount='" + DiscountBox.Text + "' where emailid='" + Session["Username"].ToString() + "'");
Response.Redirect("ViewOwnProducts.aspx");
}
}
}
else
{
Response.Write("<script>alert('Max. quantity shouldnot be less than minimum quantity')</script>");
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string status = "Ordered";
con.ExecuteCommand("insert into order_table(product_code,customer_id,quantity,discount,unit_price,total_price,house_name,place,landmark,district,state,pincode,phone,status,book_date,delivery_date) values('" + Session["ProductID"].ToString() + "', '" + Session["Username"].ToString() + "','" + Convert.ToInt32(QtyBox.Text) + "','" + Convert.ToInt32(DiscountBox.Text) + "','" + Convert.ToInt32(UpriceBox.Text) + "','" + Convert.ToInt32(TotalBox.Text) + "','" + Hname.Text + "','" + Place.SelectedValue.ToString() + "','" + Landmark.Text + "','" + Dist.SelectedValue.ToString() + "','" + State.SelectedValue.ToString() + "','" + Pincode.Text + "','" + Phone.Text + "','" + status + "','" + System.DateTime.Today.Date.ToShortDateString() + "','" + Ddate.Text + "')");
Session["amount"] = TotalBox.Text;
Response.Redirect("~/Payment/First.aspx");
}
protected void DataList1_ItemCommand(object source, DataListCommandEventArgs e)
{
if (e.CommandName.ToString() == "Remove")
{
con.ExecuteCommand("delete from Gallery where Id='" + Convert.ToInt32(e.CommandArgument.ToString()) + "'");
Response.Redirect("ViewMyWorks.aspx");
}
}
protected void DataList1_ItemCommand(object source, DataListCommandEventArgs e)
{
if (e.CommandName.ToString() == "Edit")
{
Session["Pid"] = e.CommandArgument.ToString();
Response.Redirect("EditProduct.aspx");
}
if (e.CommandName.ToString() == "Delete")
{
con.ExecuteCommand("delete from tbl_productdetails where productid='" + e.CommandArgument.ToString() + "' ");
Response.Redirect("ViewOwnProducts.aspx");
}
}
protected void DataList1_ItemCommand(object source, DataListCommandEventArgs e)
{
if (e.CommandName.ToString() == "Deliver")
{
con.ExecuteCommand("update order_table set status='Delivered', delivery_date='" + System.DateTime.Today.ToShortDateString() + "' where order_id='" + e.CommandArgument.ToString() + "' ");
Response.Redirect("ViewOrders.aspx");
}
if (e.CommandName.ToString() == "Customer")
{
Session["CID"] = e.CommandArgument.ToString();
Response.Redirect("ViewCustomer.aspx");
}
}
protected void Button1_Click(object sender, EventArgs e)
{
con.reader("select * from Registration where Email='" + TextBox2.Text + "' ");
if (con.dr.Read())
{
Response.Write("<script>alert('The Email ID is already registered')</script>");
con.dr.Close();
}
else
{
con.dr.Close();
string Usertype = "Customer";
con.ExecuteCommand("insert into Registration values('" + TextBox2.Text + "','" + TextBox1.Text + "','" + RadioButtonList1.SelectedValue + "','" + TextBox3.Text + "','" + DropDownList5.SelectedValue + "','" + TextBox4.Text + "','" + DropDownList2.SelectedValue + "','" + DropDownList1.SelectedValue + "','" + DropDownList3.SelectedValue + "','" + TextBox6.Text + "','" + TextBox7.Text + "','" + Usertype + "','" + TextBox8.Text + "','" + DropDownList4.Text + "','" + TextBox11.Text + "','" + 0 + "')");
Response.Redirect("Login.aspx");
Response.Write("<script>alert('Successfully registered to T-Trends.You can login after admin approval')</script>");
}
}
protected void Button1_Click(object sender, EventArgs e)
{
con.ExecuteCommand("update order_table set status='Cancelled', cancel_date='" + System.DateTime.Today.ToShortDateString() + "',cancel_reason='" + NameBox.Text + "' where order_id='" + EmailBox.Text + "' ");
Response.Redirect("MyOrders.aspx");
}
protected void Button1_Click(object sender, EventArgs e)
{
con.ExecuteCommand("insert into Chat values('" + Session["Username"].ToString() + "','" + DropDownList1.SelectedValue.ToString() + "','" + NameBox.Text + "','" + System.DateTime.Today.ToShortDateString() + "' ,'" + System.DateTime.Now.ToShortTimeString() + "','Executive' )");
Response.Redirect("Chat.aspx");
}
protected void Button1_Click(object sender, EventArgs e)
{
con.ExecuteCommand("update Registration set Name='" + NameBox.Text + "', Gender='" + RadioButtonList1.SelectedValue.ToString() + "',Housename='" + HouseBox.Text + "',Place='" + PlaceBox.SelectedValue.ToString() + "', Landmark='" + LandMarkBox.Text + "', District='" + DistrictBox.SelectedValue.ToString() + "',State='" + StateBox.SelectedValue.ToString() + "', Nationality='" + NationalityBox.SelectedValue.ToString() + "', Pincode='" + PincodeBox.Text + "',Phone='" + PhoneBox.Text + "' where Email='" + Session["Username"].ToString() + "' ");
Response.Redirect("Profile.aspx");
// Response.Write("<script>alert('"+Session["Username"].ToString()+"')</script>");
}
protected void Button1_Click(object sender, EventArgs e)
{
con.ExecuteCommand("insert into Gallery values('" + Session["Username"].ToString() + "','" + Session["Photo"].ToString() + "','" + NameBox.Text + "')");
Response.Write("<script>alert('Design inserted successfully')</script>");
}