protected void btnSubmit_Click(object sender, EventArgs e)
{
ShoppingCart k=new ShoppingCart
{
CategoryName=txtCategoryName.Text
};
k.AddCategroy();
txtCategoryName.Text = string.Empty;
Response.Redirect("~/Admin/AddNewProducts.aspx");
}
private void GetOrderList()
{
ShoppingCart k = new ShoppingCart()
{
Flag=0
};
DataTable dt=k.GetOrderList();
gvAvailableProducts.DataSource = dt;
gvAvailableProducts.DataBind();
}
private void GetCategories()
{
ShoppingCart k = new ShoppingCart();
DataTable dt = k.GetCategories();
k.GetCategories();
if(dt.Rows.Count>0)
{
gbAvailableCategories.DataSource = dt;
gbAvailableCategories.DataBind();
}
}
protected void btnPlaceOrder_Click(object sender, EventArgs e)
{
string productids = string.Empty;
DataTable dt;
if (Session["MyCart"] != null)
{
dt = (DataTable)Session["MyCart"];
ShoppingCart k = new ShoppingCart()
{
CustomerName = txtCustomerName.Text,
CustomerEmailID = txtCustomerEmailID.Text,
CustomerAddres = txtCustomerAddress.Text,
CustomerPhoneNo = txtCustomerPhoneNo.Text,
TotalProducts = Convert.ToInt32(txtTotalProducts.Text),
TotalPrice = Convert.ToInt32(txtTotalPrice.Text),
PaymenMethod = rdlPaymentMethod.SelectedItem.Text
};
DataTable dtReult = k.SaveCustomerDetails();
for(int i=0; i<dt.Rows.Count;i++)
{
ShoppingCart SaveProducts = new ShoppingCart()
{
CustomerID = Convert.ToInt32(dtReult.Rows[0][0]),
ProductID = Convert.ToInt32(dt.Rows[i]["ProductID"]),
TotalProducts = Convert.ToInt32(dt.Rows[i]["ProductQuantity"])
};
SaveProducts.SaveCustomerProducts();
}
Session.Clear();
GetMyCart();
lblTransactionNo.Text = "Your Transaction No: " + dtReult.Rows[0][0];
pnlOrderPlacedSuccesfully.Visible = true;
pnlCheckOut.Visible = false;
pnlCategories.Visible = false;
pnlMyCart.Visible = false;
pnlEmptyCart.Visible = false;
pnlProducts.Visible = false;
SendOrderPlaceAlert(txtCustomerName.Text, txtCustomerEmailID.Text, Convert.ToString(dtReult.Rows[0][0]));
txtCustomerAddress.Text = string.Empty;
txtCustomerEmailID.Text = string.Empty;
txtCustomerName.Text = string.Empty;
txtCustomerPhoneNo.Text = string.Empty;
txtTotalPrice.Text = "0";
txtTotalProducts.Text = "0";
}
}
private void GetProducts(int CategoryID)
{
ShoppingCart k = new ShoppingCart()
{
CategoryID = CategoryID
};
DataTable dt = k.GetAllProducts();
gvAvailableProducts.DataSource = null;
gvAvailableProducts.DataSource = k.GetAllProducts();
gvAvailableProducts.DataBind();
}
private void GetCategories()
{
ShoppingCart k = new ShoppingCart();
DataTable dt = k.GetCategories();
if(dt.Rows.Count>0)
{
ddlCategory.DataValueField = "CategoryID";
ddlCategory.DataTextField = "CategoryName";
ddlCategory.DataSource = dt;
ddlCategory.DataBind();
}
}
private void GetCategories()
{
ShoppingCart k=new ShoppingCart();
DataTable dt=k.GetCategories();
if(dt.Rows.Count>0)
{
ddlCategory.DataValueField = "CategoryID";
ddlCategory.DataTextField = "CategoryName";
ddlCategory.DataSource = dt;
ddlCategory.DataBind();
ddlCategory.Items.Add(new ListItem("All Products", "0", true));
ddlCategory.SelectedValue = "0";
}
}
private void GetAvailableStock()
{
ShoppingCart k = new ShoppingCart()
{
CategoryID = Convert.ToInt32(ddlCategory.SelectedValue),
StockTypes = Convert.ToInt32(rblProductStock.SelectedValue)
};
DataTable dt = k.GetAvailableStock();
if(dt.Rows.Count>0)
{
gvAvailableStock.DataSource = dt;
gvAvailableStock.DataBind();
gvAvailableStock.Visible = true;
NoRecordsDisplay.Visible = false;
}else
{
NoRecordsDisplay.Visible = true;
gvAvailableStock.Visible = false;
}
}
protected void btnSubmit_Click1(object sender, EventArgs e)
{
if(uploadProductPhoto.PostedFile!=null)
{
SaveProductPhoto();
ShoppingCart k = new ShoppingCart()
{
ProductName = txtProductName.Text,
ProductImage = "~/ProductImages/" + uploadProductPhoto.FileName,
ProductPrice = txtProductPrice.Text,
ProductDescription = txtProductDescription.Text,
CategoryID = Convert.ToInt32(ddlCategory.SelectedValue),
TotalProducts = Convert.ToInt32(txtProductQuantity.Text)
};
if(k!=null)
k.AddNewProduct();
k = null;
ClearText();
}
}
private void GetIncomeReport()
{
ShoppingCart k = new ShoppingCart()
{
Flag=Convert.ToInt32(rblIncomeFilter.SelectedValue)
};
DataTable dt=k.GetIncomeReport();
if(dt.Rows.Count>0)
{
gvIncomeReport.Visible=true;
gvIncomeReport.DataSource=dt;
gvIncomeReport.DataBind();
object ProductSold;
ProductSold=dt.Compute("Sum(TotalProducts)" , "" );
object TotalIncome;
TotalIncome=dt.Compute("Sum(TotalPrice)" , "" );
}else {
gvIncomeReport.Visible = false;
lblIncome.Text = "No Products Income";
}
}
private void GetProducts(int CategoryID)
{
ShoppingCart k = new ShoppingCart()
{
CategoryID = CategoryID
};
dlProducts.DataSource = null;
dlProducts.DataSource = k.GetAllProducts();
dlProducts.DataBind();
}
private void GetCategory()
{
ShoppingCart k = new ShoppingCart();
dlCategories.DataSource = null;
dlCategories.DataSource = k.GetCategories();
dlCategories.DataBind();
}
