private void BindAllProductsRptr()
{
DataTable categoryData = new DataTable();
if (Request.QueryString["type"].Trim().Equals("All"))
{
//h1noOfItems.InnerText = "My Products if";
SqlCommand cmd = new SqlCommand("SELECT ProductPrice,ImageData,ProductName,ProductCode From PDetails");
categoryData = access.SelectFromDatabase(cmd);
}
else
{
string gender = Request.QueryString["type"].Trim('#');
h1noOfItems.InnerText = "My Products";
SqlCommand cmd = new SqlCommand("SELECT ProductPrice,ImageData,ProductName,ProductCode From PDetails where Gender=@gender");
cmd.Parameters.AddWithValue("@gender", gender);
categoryData = access.SelectFromDatabase(cmd);
}
if (categoryData.Rows.Count > 0)
{
h1noOfItems.InnerText = "My Products";
MyProductsRptr.DataSource = categoryData;
MyProductsRptr.DataBind();
}
else
{
h1noOfItems.InnerText = "No products";
MyProductsRptr.DataSource = null;
MyProductsRptr.DataSourceID = null;
MyProductsRptr.DataBind();
}
}
public DataTable checkCategory(string cat)
{
DataTable dt = new DataTable();
SqlCommand cmd = new SqlCommand("SELECT * FROM ProductCategory WHERE ProductCatName='" + cat + "'");
dt = access.SelectFromDatabase(cmd);
return(dt);
}
private void BrandRepeater()
{
SqlCommand cmd = new SqlCommand("Select TOP 3 ImageData from Vendor ORDER BY VendorId DESC");
brandData = access.SelectFromDatabase(cmd);
BrandRptr.DataSource = brandData;
BrandRptr.DataBind();
}
public void BindCartNumber()
{
if (Session["Customer"] != null)
{
DataTable idTab = new DataTable();
SqlCommand cmd2 = new SqlCommand("SELECT CustomerID FROM CustomerDetails WHERE CustomerEmailAddress = @email");
cmd2.Parameters.AddWithValue("@email", Session["Customer"].ToString());
idTab = access.SelectFromDatabase(cmd2);
foreach (DataRow rows in idTab.Rows)
{
cId = Convert.ToInt64(rows["CustomerID"]);
}
if (Request.Cookies["OrderID" + cId.ToString()] != null)
{
string CookiePID = Request.Cookies["OrderID" + cId.ToString()]["ProductID"].Split('=')[0];
string[] ProductArray = CookiePID.Split(',');
int ProductCount = ProductArray.Length;
pCount.InnerText = ProductCount.ToString();
}
else
{
pCount.InnerText = 0.ToString();
}
}
else
{
pCount.InnerText = 0.ToString();
}
}
private string getUserName()
{
String userName = string.Empty;
DataTable user = new DataTable();
SqlCommand cmd2 = new SqlCommand("SELECT CustomerName FROM CustomerDetails WHERE CustomerEmailAddress = @email");
cmd2.Parameters.AddWithValue("@email", Session["Customer"].ToString());
user = access.SelectFromDatabase(cmd2);
foreach (DataRow rows in user.Rows)
{
userName = rows["CustomerName"].ToString();
}
return(userName);
}
public void BindCartProducts()
{
Int64 OrderID = Convert.ToInt64(Request.QueryString["OrderID"]);
DataTable cartitems = new DataTable();
SqlCommand cmd = new SqlCommand("select p.ProductName,p.ImageData, o.OrderQnty, o.OrderTotalPrice from OrderDetails o JOIN PDetails p ON p.ProductCode=o.ProductCode where OrderID=" + OrderID + "");
cartitems = access.SelectFromDatabase(cmd);
if (cartitems.Rows.Count > 0)
{
h2NoItems.InnerText = "Items you buyed (" + cartitems.Rows.Count + ")";
rptrCartProducts.DataSource = cartitems;
rptrCartProducts.DataBind();
}
else
{
//TODO Show Empty Cart
h2NoItems.InnerText = "Your Shopping Cart is Empty";
}
}
protected bool checkingForPUpdate(int n)
{
if (Session["vendor"] != null)
{
SqlCommand cmd2 = new SqlCommand(" SELECT * FROM Product where ProductCode=@ProductCode and ProductSize=@Size");
cmd2.Parameters.AddWithValue("@ProductCode", Request.QueryString["ProductCode"].ToString());
cmd2.Parameters.AddWithValue("@Size", size[n]);
DataTable productDetailData = access.SelectFromDatabase(cmd2);
if (productDetailData.Rows.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
return(false);
}
public bool CheckCode(string code, string email, char t)
{
DataTable dt = new DataTable();
SqlCommand cmd;
if (t == 'v')
{
cmd = new SqlCommand("SELECT VerificationCode FROM Vendor WHERE VendorEmail=@Email");
cmd.Parameters.AddWithValue("@Email", email);
dt = access.SelectFromDatabase(cmd);
}
else if (t == 'c')
{
cmd = new SqlCommand("SELECT VerificationCode FROM CustomerDetails WHERE CustomerEmailAddress=@Email");
cmd.Parameters.AddWithValue("@Email", email);
dt = access.SelectFromDatabase(cmd);
}
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
if (code.Equals(dr["VerificationCode"]))
{
return(true);
}
else
{
return(false);
}
}
}
else
{
return(false);
}
return(false);
}
private void BindCityRptr()
{
DataTable cityData = new DataTable();
SqlCommand cmd = new SqlCommand(" SELECT * from CityTable");
cityData = access.SelectFromDatabase(cmd);
if (cityData.Rows.Count != 0)
{
custCity.DataSource = cityData;
custCity.DataTextField = "CityName";
custCity.DataValueField = "Id";
custCity.DataBind();
custCity.Items.Insert(0, new ListItem("-Select-", "0"));
}
}
private void BindMyProductsRptr()
{
DataTable categoryData = new DataTable();
SqlCommand cmd = new SqlCommand("SELECT ProductPrice,ImageData,ProductName,ProductCode From PDetails Where VendorId = @VId");
cmd.Parameters.AddWithValue("@VId", currentVendorId);
categoryData = access.SelectFromDatabase(cmd);
if (categoryData.Rows.Count > 0)
{
h1noOfItems.InnerText = "My Products";
MyProductsRptr.DataSource = categoryData;
MyProductsRptr.DataBind();
}
else
{
h1noOfItems.InnerText = "You have not added any product till now";
}
}
protected void Signin_Click(object sender, EventArgs e)
{
// int Cid;
SqlCommand cmd = new SqlCommand("select * from CustomerDetails where CustomerEmailAddress='" + email.Text + "' and CustomerPassword='******'");
DataTable dt = new DataTable();
dt = access.SelectFromDatabase(cmd);
if (dt.Rows.Count != 0)
{
if (access.checkifAlreadyVerified(email.Text, 'c'))
{
Session["Customer"] = email.Text;
if (Request.QueryString["rurl"] != null)
{
if (Request.QueryString["rurl"] == "view")
{
Response.Redirect("~/ViewProduct.aspx");
}
}
else
{
Response.Redirect("~/AllProducts.aspx");
}
Session.RemoveAll();
}
else
{
Response.Redirect("/Activation.aspx?rurl=notVerifiedCust");
}
}
else
{
lblError.Text = "Invalid Username or password";
lblError.ForeColor = Color.Red;
}
}
private void AddToCart(string quantity, string size)
{
Int64 ProductID = Convert.ToInt64(Request.QueryString["ProductCode"]);
Int64 cId = 0;
if (Session["Customer"] != null)
{
DataTable idTab = new DataTable();
SqlCommand cmd2 = new SqlCommand("SELECT CustomerID FROM CustomerDetails WHERE CustomerEmailAddress = @email");
cmd2.Parameters.AddWithValue("@email", Session["Customer"].ToString());
idTab = access.SelectFromDatabase(cmd2);
foreach (DataRow rows in idTab.Rows)
{
cId = Convert.ToInt64(rows["CustomerID"]);
}
if (Request.Cookies["OrderID" + cId.ToString()] != null)
{
string CookiePID = Request.Cookies["OrderID" + cId.ToString()]["ProductID"].Split('=')[0];
CookiePID = CookiePID + "," + ProductID;
HttpCookie Order = new HttpCookie("OrderID" + cId.ToString());
Order.Values["ProductID"] = CookiePID;
string CookieQnty = Request.Cookies["OrderID" + cId.ToString()]["Quantity"].Split('=')[0];
CookieQnty = CookieQnty + "," + quantity;
Order.Values["Quantity"] = CookieQnty;
string CookieSize = Request.Cookies["OrderID" + cId.ToString()]["Size"].Split('=')[0];
CookieSize = CookieSize + "," + size;
Order.Values["Size"] = CookieSize;
Order.Expires = DateTime.Now.AddDays(30);
Response.Cookies.Add(Order);
}
else
{
HttpCookie Order = new HttpCookie("OrderID" + cId.ToString());
//Order.Values["Customer"] = Session["Customer"].ToString();
Order.Values["ProductID"] = ProductID.ToString();
Order.Values["Quantity"] = quantity;
Order.Values["Size"] = size;
Order.Expires = DateTime.Now.AddDays(30);
Response.Cookies.Add(Order);
}
Response.Redirect("~/Cart.aspx");
}
else
{
if (Session["vendor"] != null)
{
Response.Redirect("~/MyProducts.aspx");
}
else
{
Response.Redirect("/CustLogin.aspx?rurl=view");
}
}
}