protected void Button1_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
selectdata sd = new selectdata();
string s = sd.returnscalar("select count(ad_id) from tbl_admin where ad_email='" + txtemail.Text + "'");
if (s == "0")
{
admin a = new admin();
a.email = txtemail.Text;
a.password = txtpassword.Text;
a.phone = txtphone.Text;
insert i = new insert();
Session["admin_id"] = i.signup_admin(a);
if (Session["admin_id"] == "-1")
{
Label1.Text = "Some Error Occurred Please Try Again.";
}
else
{
Response.Redirect("~/View/Admin/adminpannel.aspx");
}
}
else if (s == "1")
{
Label1.Text = "Email ID Already Exists.";
}
else
{
Label1.Text = "Some Error Occurred Please Try Again.";
}
}
}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
if (DropDownList1.SelectedIndex == 0)
{
drop2Changed();
DropDownList2.Enabled = false;
DropDownList2.SelectedIndex = 0;
HyperLink1.Visible = false;
Label2.Text = "";
}
else
{
DropDownList2.Enabled = true;
SqlParameter para = new SqlParameter("@cat_id", DropDownList1.SelectedValue);
selectdata sd = new selectdata();
DataSet DS = sd.GetData("sp_sub_categories", para);
DropDownList2.DataSource = DS;
DropDownList2.DataBind();
drop2Changed();
HyperLink1.Visible = false;
Label2.Text = "";
}
}
protected void Csignin_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
selectdata sd = new selectdata();
string s = sd.returnscalar("select count(cu_id) from tbl_custom where cu_email='" + email.Text + "'");
if (s == "0")
{
customer c = new customer();
c.email = email.Text;
c.password = password.Text;
c.phone = phone.Text;
insert i = new insert();
Session["customer_id"] = i.signup_customer(c);
if (Session["customer_id"] == null)
{
Label1.Text = "some exception ";
}
else
{
Session["customer_mail"] = sd.returnscalar("select cu_email from tbl_custom where cu_id=" + Session["customer_id"]);
Response.Redirect("~/Home_Main.aspx");
}
}
else
{
Label1.Text = "Email already exist";
}
}
}
//protected void Page_Init(object sender, EventArgs e)
//{
// ((Site1)Master).searchButton.Click += new EventHandler(searchButton_Click);
//}
protected void Page_Load(object sender, EventArgs e)
{
selectdata sd = new selectdata();
DataSet ds = sd.SearchData(((Site1)Master).Session["TextSearch"].ToString());
Repeater1.DataSource = ds;
Repeater1.DataBind();
}
protected void Csignin_Click(object sender, EventArgs e)
{
selectdata sd = new selectdata();
string user = sd.returnscalar("select count(cu_id) from tbl_custom where cu_email='" + email.Text + "'");
if (user == "1")
{
string pass = sd.returnscalar("select cu_password from tbl_custom where cu_email= '" + email.Text + "'");
if (pass != password.Text)
{
Label7.Text = "Password is wrong";
}
else
{
Session["customer_mail"] = email.Text;
Session["customer_id"] = sd.cust_id("select cu_id from tbl_custom where cu_email = '" + Session["customer_mail"] + "'");
if (CheckBox1.Checked)
{
//HttpCookie cookie = new HttpCookie("customerInfo");
//cookie["email.Text"] = email.Text;
//cookie["password.Text"] = email.Text;
//Response.Cookies.Add(cookie);
//cookie.Expires = DateTime.Now.AddDays(20);
Response.Cookies["email.Text"].Value = email.Text;
Response.Cookies["password.Text"].Value = password.Text;
Response.Cookies["email.Text"].Expires = DateTime.Now.AddDays(20);
Response.Cookies["password.Text"].Expires = DateTime.Now.AddDays(20);
}
else
{
Response.Cookies["email.Text"].Expires = DateTime.Now.AddMinutes(-1);
Response.Cookies["password.Text"].Expires = DateTime.Now.AddMinutes(-1);
}
Response.Redirect("~/Home_Main.aspx");
}
}
else
{
Label1.Text = "Email is wrong";
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
LinkButton3.Visible = false;
}
if (Session["admin_id"] != null)
{
selectdata sd = new selectdata();
Label1.Text = sd.returnscalar("select ad_email from tbl_admin where ad_id=" + Session["admin_id"]);
TextBox2.Text = System.DateTime.Now.ToShortDateString();
MultiView1.ActiveViewIndex = 0;
}
else
{
Response.Redirect("~/View/Admin/login.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["admin_id"] != null)
{
selectdata sd = new selectdata();
HyperLink1.Text = sd.returnscalar("select ad_email from tbl_admin where ad_id=" + Session["admin_id"]);
HyperLink1.NavigateUrl = "";
HyperLink2.Text = "Admin Pannel";
HyperLink2.NavigateUrl = "~/View/Admin/adminpannel.aspx";
}
else
{
HyperLink2.Text = "SignUp";
HyperLink1.NavigateUrl = "~/View/Admin/WebForm1.aspx";
HyperLink2.Text = "LogIn";
HyperLink2.NavigateUrl = "~/View/Admin/login.aspx";
}
}
protected void Page_Load(object sender, EventArgs e)
{
TextBox2.Text = DateTime.Now.ToString();
if (!IsPostBack)
{
HyperLink1.Visible = false;
MultiView1.ActiveViewIndex = 0;
Session["admin_mail"] = 1;
if (Session["admin_mail"] != null)
{
// Label1.Text = Session["admin_mail"].ToString();
//Testing purpose session variable got hard coded value
}
else
{
Response.Redirect("~/AdminAccount/AdLogin.aspx");
}
selectdata sd1 = new selectdata();
DropDownList1.DataSource = sd1.GetData("sp_main_categories", null);
DropDownList1.DataBind();
ListItem li_main = new ListItem("Select Categories", "-1");
DropDownList1.Items.Insert(0, li_main);
ListItem li_sub_main = new ListItem("Select Sub Categories", "-1");
DropDownList2.Items.Insert(0, li_sub_main);
DropDownList2.Enabled = false;
}
TextBox2.Text = DateTime.Now.ToString();
selectdata sd = new selectdata();
DataSet ds = sd.SortOrder();
GridView1.DataSource = ds;
GridView1.DataBind();
}
protected void Asignin_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
selectdata sd = new selectdata();
string user = sd.returnscalar("select count(ad_id) from tbl_admin where ad_email='" + email.Text + "'");
if (user == "1")
{
string pass = sd.returnscalar("select ad_password from tbl_admin where ad_email= '" + email.Text + "'");
if (pass != password.Text)
{
Label7.Text = "Password is wrong";
}
else
{
string id = sd.returnscalar("select ad_id from tbl_admin where ad_email= '" + email.Text + "'");
Session["admin_id"] = "1";
Session["admin_mail"] = email.Text;
if (CheckBox1.Checked)
{
Response.Cookies["Aemail.Text"].Value = email.Text;
Response.Cookies["Apassword.Text"].Value = password.Text;
Response.Cookies["Aemail.Text"].Expires = DateTime.Now.AddDays(20);
Response.Cookies["Apassword.Text"].Expires = DateTime.Now.AddDays(20);
}
else
{
Response.Cookies["Aemail.Text"].Expires = DateTime.Now.AddMinutes(-1);
Response.Cookies["Apassword.Text"].Expires = DateTime.Now.AddMinutes(-1);
}
Response.Redirect("~/AdminAccount/AdminPannel.aspx");
}
}
else
{
Label1.Text = "Email is wrong";
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string pwdfromdb;
selectdata sd = new selectdata();
string c = sd.returnscalar("select COUNT(ad_id) from tbl_admin where ad_email='" + txtEmail.Text + "'");
if (c != "0")
{
pwdfromdb = sd.returnscalar("select ad_password from tbl_admin where ad_email='" + txtEmail.Text + "'");
if (txtpassword.Text.Equals(pwdfromdb))
{
Session["admin_id"] = sd.returnscalar("select ad_id from tbl_admin where ad_email='" + txtEmail.Text + "'");
Response.Redirect("~/home.aspx?");
}
else
{
Label1.Text = "Invalid Password!";
}
}
else
{
Label1.Text = "This Email is not registered!";
}
}
//private DataSet GetData()
//{
// string CS = ConfigurationManager.ConnectionStrings["comfy_string"].ConnectionString;
// using (SqlConnection con = new SqlConnection(CS))
// {
// SqlDataAdapter da = new SqlDataAdapter("select * from tbl_product_items where pro_fk_subcat = 5 ", con);
// DataSet ds = new DataSet();
// da.Fill(ds);
// return ds;
// }
//}
protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)
{
ImageButton btn = (ImageButton)(e.Item.FindControl("ImageButton1"));
string productId = btn.CommandArgument;
DropDownList dl = (DropDownList)(e.Item.FindControl("DropDownList1"));
int Quantity = Convert.ToInt32(dl.SelectedValue);
//Session["addproduct"] = "true";
// Response.Redirect("AddtoCart.aspx?id=" + e.CommandArgument.ToString());
//if (Session["addproduct"].ToString() == "true")
//{
// Session["addproduct"] = "false";
DataTable dt = new DataTable();
DataRow dr;
dt.Columns.Add("sno");
dt.Columns.Add("pro_id");
dt.Columns.Add("pro_name");
dt.Columns.Add("pro_price");
dt.Columns.Add("Quantity");
dt.Columns.Add("pro_image");
dt.Columns.Add("TotalPrice");
if (productId != null)
{
if (Session["Buyitems"] == null)
{
dr = dt.NewRow();
String myquery = "select * from tbl_product_items where pro_id=" + productId;
selectdata sd = new selectdata();
DataSet ds = sd.GetCart(myquery);
dr["sno"] = 1;
dr["pro_id"] = ds.Tables[0].Rows[0]["pro_id"].ToString();
dr["pro_name"] = ds.Tables[0].Rows[0]["pro_name"].ToString();
dr["pro_price"] = ds.Tables[0].Rows[0]["pro_price"].ToString();
dr["Quantity"] = Quantity;
dr["pro_image"] = ds.Tables[0].Rows[0]["pro_image"].ToString();
int price = Convert.ToInt32(ds.Tables[0].Rows[0]["pro_price"].ToString());
dr["TotalPrice"] = price * Quantity;
((Site1)Master).cart_Quantity.Text = Quantity.ToString();
Session["F_Qua"] = ((Site1)Master).cart_Quantity.Text;
dt.Rows.Add(dr);
Session["buyitems"] = dt;
((Site1)Master).cart_Price.Text = grandtotal().ToString();
//ImageButton img = (ImageButton)(e.Item.FindControl("ImageButton1"));
//img.ImageUrl = "images/addedtocart.png";
}
else
{
dt = (DataTable)Session["buyitems"];
int sr;
sr = dt.Rows.Count;
dr = dt.NewRow();
String myquery = "select * from tbl_product_items where pro_id=" + productId;
selectdata sd = new selectdata();
DataSet ds = sd.GetCart(myquery);
dr["sno"] = sr + 1;
dr["pro_id"] = ds.Tables[0].Rows[0]["pro_id"].ToString();
dr["pro_name"] = ds.Tables[0].Rows[0]["pro_name"].ToString();
dr["pro_price"] = ds.Tables[0].Rows[0]["pro_price"].ToString();
dr["Quantity"] = Quantity;
dr["pro_image"] = ds.Tables[0].Rows[0]["pro_image"].ToString();
int price = Convert.ToInt32(ds.Tables[0].Rows[0]["pro_price"].ToString());
dr["TotalPrice"] = price * Quantity;
int Q = Convert.ToInt32(((Site1)Master).cart_Quantity.Text);
Quantity = Quantity + Q;
((Site1)Master).cart_Quantity.Text = Quantity.ToString();
Session["F_Qua"] = ((Site1)Master).cart_Quantity.Text;
dt.Rows.Add(dr);
((Site1)Master).cart_Price.Text = grandtotal().ToString();
Session["F_total"] = ((Site1)Master).cart_Price.Text;
Session["buyitems"] = dt;
//ImageButton img = (ImageButton)(e.Item.FindControl("ImageButton1"));
//img.ImageUrl = "images/addedtocart.png";
//Response.Redirect("~/ShoopingCart.aspx?id=" + name);
}
}
else
{
dt = (DataTable)Session["buyitems"];
}
// insert i = new insert();
// //i.insert_tbl_cart();
// shoopingcart cart = new shoopingcart();
// selectdata sd = new selectdata();
// SqlParameter para = new SqlParameter("pro_id", productId);
//DataSet cartdata = sd.Get_product("sp_retrieve_cart", para);
// cart.cart_id = Convert.ToInt32(cartdata.Tables[0].Rows[0][0]);
// cart.cart_name = cartdata.Tables[0].Rows[0][1].ToString();
// cart.cart_price = cartdata.Tables[0].Rows[0][2].ToString();
// cart.cart_img = cartdata.Tables[0].Rows[0][3].ToString();
// cart.cart_subcat = Convert.ToInt32(cartdata.Tables[0].Rows[0][4]);
// i.insert_tblcart(cart);
// ((Site1)Master).cart_Quantity.Text = "1";
//Response.Redirect("~/CartStatus.FullCart.aspx?id=" + name);
}
