public void ActiveDeactiveProductStock(int ProductID)
{
using (AustraliaDAL.DataSet1TableAdapters.tblProductTableAdapter objProduct = new AustraliaDAL.DataSet1TableAdapters.tblProductTableAdapter())
{
objProduct.ActiveDeactiveProductStock(ProductID);
}
}
public void UpdateProductHits(int ProductID)
{
using (AustraliaDAL.DataSet1TableAdapters.tblProductTableAdapter objProduct = new AustraliaDAL.DataSet1TableAdapters.tblProductTableAdapter())
{
objProduct.UpdateProductHits(ProductID);
}
}
public void DeleteProduct(int ProductID)
{
using (AustraliaDAL.DataSet1TableAdapters.tblProductTableAdapter objProduct = new AustraliaDAL.DataSet1TableAdapters.tblProductTableAdapter())
{
objProduct.DeleteProduct(ProductID);
}
}
public void AddEditProduct(int ProductID, string Title, string ImageUrl, string Description, string Weight, string Price, string Discount, string AfterDiscount, int Stock, bool IsFeartured, int CategoryID, int SubCategoryID, string MetaTitle, string MetaKeyword, string MetaDescription, bool IsOnSale, string OnSaleDiscount, string Image1, string Image2, string Image3, string Image4, string Image5, int brandID, string totalamount, string tax, string DeliveryCharge, int MaxQTY)
{
DataTable dt = new DataTable();
using (AustraliaDAL.DataSet1TableAdapters.tblProductTableAdapter objProduct = new AustraliaDAL.DataSet1TableAdapters.tblProductTableAdapter())
{
dt = objProduct.AddEditProduct(ProductID, Title, ImageUrl, Description, Weight, Price, Discount, AfterDiscount, Stock, IsFeartured, CategoryID, SubCategoryID, MetaTitle, MetaKeyword, MetaDescription, IsOnSale, OnSaleDiscount, Image1, Image2, Image3, Image4, Image5, brandID, totalamount, tax, DeliveryCharge, MaxQTY);
}
}
public DataTable GetProductAutoComplete(int ProductID, string Title)
{
DataTable dt = new DataTable();
using (AustraliaDAL.DataSet1TableAdapters.tblProductTableAdapter objProduct = new AustraliaDAL.DataSet1TableAdapters.tblProductTableAdapter())
{
dt = objProduct.GetProductAutoComplete(ProductID, Title);
}
return(dt);
}
public DataTable GetProductAllBySubCategoryID(int SubCategoryID)
{
DataTable dt = new DataTable();
using (AustraliaDAL.DataSet1TableAdapters.tblProductTableAdapter objProduct = new AustraliaDAL.DataSet1TableAdapters.tblProductTableAdapter())
{
dt = objProduct.GetProductAllBySubcategoryID(SubCategoryID);
}
return(dt);
}
public DataTable GetAllProduct(int ProductID)
{
DataTable dt = new DataTable();
using (AustraliaDAL.DataSet1TableAdapters.tblProductTableAdapter objProduct = new AustraliaDAL.DataSet1TableAdapters.tblProductTableAdapter())
{
dt = objProduct.GetAllProduct(ProductID);
}
return(dt);
}
public DataTable GetProductByBrandIDForNavMenu(int BrandID, bool Active)
{
DataTable dt = new DataTable();
using (AustraliaDAL.DataSet1TableAdapters.tblProductTableAdapter objProduct = new AustraliaDAL.DataSet1TableAdapters.tblProductTableAdapter())
{
dt = objProduct.GetProductByBrandIDForNavMenu(BrandID, Active);
}
return(dt);
}
public DataTable GetProductBySubCategoryIDForNavMenu(int SubCategoryID, bool active)
{
DataTable dt = new DataTable();
using (AustraliaDAL.DataSet1TableAdapters.tblProductTableAdapter objProduct = new AustraliaDAL.DataSet1TableAdapters.tblProductTableAdapter())
{
dt = objProduct.GetProductBySubCategoryIDForNavMenu(SubCategoryID, active);
}
return(dt);
}
public DataTable GetDataTotblProduct(int CategoryID, int SubCategory, string ProductName, string price)
{
DataTable dt = new DataTable();
using (AustraliaDAL.DataSet1TableAdapters.tblProductTableAdapter objProduct = new AustraliaDAL.DataSet1TableAdapters.tblProductTableAdapter())
{
dt = objProduct.GetDataTotblProduct(CategoryID, SubCategory, ProductName, price);
}
return(dt);
}
public DataTable GetProductbySubCategoryID_ProductName(int SubCategoryID, string PrefixText)
{
DataTable dt = new DataTable();
using (AustraliaDAL.DataSet1TableAdapters.tblProductTableAdapter objProduct = new AustraliaDAL.DataSet1TableAdapters.tblProductTableAdapter())
{
dt = objProduct.GetProductbySubCategoryID_ProductName(SubCategoryID, PrefixText);
}
return(dt);
}
public DataTable GetProductByProductName(string ProductName)
{
DataTable dt = new DataTable();
using (AustraliaDAL.DataSet1TableAdapters.tblProductTableAdapter objProduct = new AustraliaDAL.DataSet1TableAdapters.tblProductTableAdapter())
{
dt = objProduct.GetProductByProductName(ProductName);
}
return(dt);
}
public DataTable GetProductOnItemDetails(int ProductID)
{
DataTable dt = new DataTable();
using (AustraliaDAL.DataSet1TableAdapters.tblProductTableAdapter objProduct = new AustraliaDAL.DataSet1TableAdapters.tblProductTableAdapter())
{
dt = objProduct.Getproductbyitem(ProductID);
}
return(dt);
}
