public DataTable isStyleCode(string productskucode)
{
return
(GenericDAO.getDataTable("select * from PRODUCTS where StyleCode='" + productskucode + "' order by Size asc"));
}
public DataTable getbrandselecteddata(string SKUCategory, string SKUCategoryType, string SKUBrand)
{
SKUBrand = SKUBrand.Replace("'", "\''");
return
(GenericDAO.getDataTable("select * from PRODUCTS where CategoryID = '" + SKUCategory + "' and SKUCategoryType = '" + SKUCategoryType + "' and SKUBrand like '" + SKUBrand + "%' and SKUClassification='Normal' union select * from PRODUCTS where CategoryID = '" + SKUCategory + "' and SKUCategoryType = '" + SKUCategoryType + "' and SKUBrand like '" + SKUBrand + "%' and VariantType='Size' and (StyleCode='' or StyleCode is null) union select * from PRODUCTS where CategoryID = '" + SKUCategory + "' and SKUCategoryType = '" + SKUCategoryType + "' and SKUBrand like '" + SKUBrand + "%' and VariantType='Color' and (StyleCode='' or StyleCode is null)"));
}
public DataTable getsitemapbrandselecteddata(string SKUBrand)
{
return
(GenericDAO.getDataTable("select * from PRODUCTS where SKUBrand like '" + SKUBrand + "%' and SKUClassification='Normal' union select * from PRODUCTS where SKUBrand like '" + SKUBrand + "%' and VariantType='Size' and (StyleCode='' or StyleCode is null) union select * from PRODUCTS where SKUBrand like '" + SKUBrand + "%' and VariantType='Color' and (StyleCode='' or StyleCode is null)"));
}
public DataTable getsizeproductdetails()
{
return
(GenericDAO.getDataTable("select * from View_Product_Size_InsertTable"));
}
public DataTable getskucatcattypebrandproducttype1(string SKUCategoryType)
{
return
(GenericDAO.getDataTable("select * from PRODUCTS where SKUCategoryType='" + SKUCategoryType + "'"));
}
public DataTable getsearchbyproducttypebydata(string SKUProductType)
{
return
(GenericDAO.getDataTable("select * from PRODUCTS where SKUProductType = '" + SKUProductType + "' and SKUClassification='Normal' union select * from PRODUCTS where SKUProductType = '" + SKUProductType + "' and VariantType='Size' and (StyleCode='' or StyleCode is null) union select * from PRODUCTS where SKUProductType = '" + SKUProductType + "' and VariantType='Color' and (StyleCode='' or StyleCode is null) ORDER BY (PRODUCTS) DESC"));
}
public DataTable getallwomenpagebanner()
{
return(GenericDAO.getDataTable("select * from BannerMaster_New where PageTypeName='Woman Page' order by (PageTypeName) desc"));
}
public DataTable getaddtowishlistdetails(string SKUCode)
{
return
(GenericDAO.getDataTable("select * from PRODUCTS where SKUCode='" + SKUCode + "'"));
}
public DataTable getindexinternalproductdetails()
{
return
(GenericDAO.getDataTable("select * from PRODUCTS where SKUProductType='Coaster & Lamps'"));
}
public DataTable getProdByStyleSize(String styleCode, string size)
{
return
(GenericDAO.getDataTable("select * from PRODUCTS where StyleCode='" + styleCode + "' and Size='" + size + "'"));
}
public DataTable getSkuCodeBySize1(String styleCode, string size)
{
return
(GenericDAO.getDataTable("select * from PRODUCTS where SKUCode='" + styleCode + "' and Size='" + size + "'"));
}
public DataTable getSkuCodeByColor1(String styleCode, string color)
{
return
(GenericDAO.getDataTable("select * from PRODUCTS where SKUCode='" + styleCode + "' and Color='" + color + "'"));
}
public DataTable getVarientProduct(String style, string color, String size)
{
return
(GenericDAO.getDataTable("select * from PRODUCTS where StyleCode='" + style + "' and Color='" + color + "' and Size='" + size + "'"));
}
public DataTable getProdBySkuColorSize(String sku, string color, String size)
{
return
(GenericDAO.getDataTable("select * from PRODUCTS where SKUCode='" + sku + "' and Color='" + color + "' and Size='" + size + "'"));
}
public DataTable getProductType_1(string SKUCategoryType, string SKUBrand)
{
return
(GenericDAO.getDataTable("select distinct(SKUProductType),SKUCategory,SKUCategoryType,CategoryTypeID,ProductTypeID from PRODUCTS where SKUBrand = '" + SKUBrand + "' and CategoryTypeID = '" + SKUCategoryType + "' and SKUClassification='Normal' union select distinct(SKUProductType),SKUCategory,SKUCategoryType,CategoryTypeID,ProductTypeID from PRODUCTS where SKUBrand = '" + SKUBrand + "' and CategoryTypeID = '" + SKUCategoryType + "' and VariantType='Size' and (StyleCode='' or StyleCode is null) union select distinct(SKUProductType),SKUCategory,SKUCategoryType,CategoryTypeID,ProductTypeID from PRODUCTS where SKUBrand = '" + SKUBrand + "' and CategoryTypeID = '" + SKUCategoryType + "' and VariantType='Color' and (StyleCode!='' and StyleCode is not null) ORDER BY (SKUProductType)"));
}
public DataTable gethomebodybannerindexinternalproductdetails()
{
return
(GenericDAO.getDataTable("select * from PRODUCTS where SKUProductType='Saree'"));
}
public DataTable getProductByProductTypeId(string productTypeID, string SKUBrand)
{
return
(GenericDAO.getDataTable("select * from PRODUCTS where ProductTypeID = '" + productTypeID + "' and SKUBrand ='" + SKUBrand + "' and SKUClassification='Normal' union select * from PRODUCTS where ProductTypeID = '" + productTypeID + "' and VariantType='Size' and (StyleCode='' or StyleCode is null) union select * from PRODUCTS where ProductTypeID = '" + productTypeID + "'and SKUBrand ='" + SKUBrand + "' and VariantType='Color' and (StyleCode!='' and StyleCode is not null) ORDER BY (SKUProductType)"));
}
public DataTable getmenuwomenallsalesindexinternalproductdetails()
{
return
(GenericDAO.getDataTable("select * from PRODUCTS where SKUCategory='Women'"));
}
public DataTable getsearchsingleproductdata(string SKUName)
{
return
(GenericDAO.getDataTable("select * from PRODUCTS where SKUName = '" + SKUName + "'"));
}
public DataTable getallhomepagetopbanner()
{
return
(GenericDAO.getDataTable("select CategoryName,CategoryTypeName,BrandName,ProductTypeAlias,CategoryTypeAlias,CategoryAlias,ProductTypeName,'http://admin.megafactoryoutlet.com/' + FilePath as FilePath from View_Banner_Master where PageTypeName='Home page' and BannerTypeName = 'Body Banner' order by (PageTypeName) desc"));
}
public DataTable getmenuwomenbrandindexinternalproductdetails(string womenbrand)
{
return
(GenericDAO.getDataTable("select * from PRODUCTS where SKUBrand='" + womenbrand + "'"));
}
public DataTable getshopbybrandsbasedalldata(string SKUCategoryType, string SKUBrand)
{
SKUBrand = SKUBrand.Replace("'", "\''");
return
(GenericDAO.getDataTable("select * from PRODUCTS where SKUCategoryType = '" + SKUCategoryType + "' and SKUBrand like '%" + SKUBrand + "' and SKUClassification='Normal' and SKUStatus='Active' union select * from PRODUCTS where SKUCategoryType = '" + SKUCategoryType + "' and SKUBrand like '%" + SKUBrand + "'and VariantType='Size' and SKUStatus='Active' and (StyleCode='' or StyleCode is null) union select * from PRODUCTS where SKUCategoryType = '" + SKUCategoryType + "' and SKUBrand like '%" + SKUBrand + "'and VariantType='Color' and SKUStatus='Active' and (StyleCode='' or StyleCode is null) order by PRODUCTS desc"));
}
public DataTable gettestimage()
{
return
(GenericDAO.getDataTable("select * from View_Product_Master where Product_ID=33"));
}
public DataTable getwomenhomebagsdatatest(string SKUCategory, string SKUCategoryType, string SKUBrand)
{
return
(GenericDAO.getDataTable("select * from PRODUCTS where CategoryID = '" + SKUCategory + "' and CategoryTypeID = '" + SKUCategoryType + "' and SKUBrand like '" + SKUBrand + "%' and SKUClassification='Normal' union select * from PRODUCTS where CategoryID = '" + SKUCategory + "' and CategoryTypeID = '" + SKUCategoryType + "' and SKUBrand like '" + SKUBrand + "%' and VariantType='Size' and (StyleCode='' or StyleCode is null) union select * from PRODUCTS where CategoryID = '" + SKUCategory + "' and CategoryTypeID = '" + SKUCategoryType + "' and SKUBrand like '" + SKUBrand + "%' and VariantType='Color' and (StyleCode='' or StyleCode is null)"));
}
public DataTable getskucatcattypebrandproducttype(string SKUID)
{
return
(GenericDAO.getDataTable("select * from PRODUCTS where SKUBrand='" + SKUID + "'"));
}
public DataTable getProductType(string SKUCategory, string SKUCategoryType)
{
return
(GenericDAO.getDataTable("select distinct(SKUProductType),SKUCategory,SKUCategoryType,CategoryTypeID,ProductTypeID,SKUStatus,RecordStatus from PRODUCTS where CategoryID = '" + SKUCategory + "' and CategoryTypeID = '" + SKUCategoryType + "' and SKUStatus='Active' and RecordStatus='1' and SKUClassification='Normal' union select distinct(SKUProductType),SKUCategory,SKUCategoryType,CategoryTypeID,ProductTypeID,SKUStatus,RecordStatus from PRODUCTS where CategoryID = '" + SKUCategory + "' and CategoryTypeID = '" + SKUCategoryType + "' and SKUStatus='Active' and RecordStatus='1' and VariantType='Size' and (StyleCode='' or StyleCode is null) union select distinct(SKUProductType),SKUCategory,SKUCategoryType,CategoryTypeID,ProductTypeID,SKUStatus,RecordStatus from PRODUCTS where CategoryID = '" + SKUCategory + "' and CategoryTypeID = '" + SKUCategoryType + "' and SKUStatus='Active' and RecordStatus='1' and VariantType='Color' and (StyleCode!='' and StyleCode is not null) ORDER BY (SKUProductType)"));
}
public DataTable getallmenpagebanner()
{
return(GenericDAO.getDataTable("select * from BannerMaster_New where PageTypeName='Men Page' order by PageTypeName"));
}
public DataTable getProductTypeID(string productTypeID)
{
return
(GenericDAO.getDataTable("select * from PRODUCTS where ProductTypeID = '" + productTypeID + "' and SKUStatus='Active' and RecordStatus='1' and SKUClassification='Normal' union select * from PRODUCTS where ProductTypeID = '" + productTypeID + "' and SKUStatus='Active' and RecordStatus='1' and VariantType='Size' and (StyleCode='' or StyleCode is null) union select * from PRODUCTS where ProductTypeID = '" + productTypeID + "' and SKUStatus='Active' and RecordStatus='1' and VariantType='Color' and (StyleCode!='' and StyleCode is not null) Order by SKUBrand asc"));
}
public DataTable getbrandselectedcategorydata(string SKUCategory, string SKUCategoryType)
{
return
(GenericDAO.getDataTable("select * from PRODUCTS where SKUCategory = '" + SKUCategory + "' and SKUCategoryType = '" + SKUCategoryType + "' and SKUClassification='Normal' union select * from PRODUCTS where SKUCategory = '" + SKUCategory + "' and SKUCategoryType = '" + SKUCategoryType + "' and VariantType='Size' and (StyleCode='' or StyleCode is null) union select * from PRODUCTS where SKUCategory = '" + SKUCategory + "' and SKUCategoryType = '" + SKUCategoryType + "' and VariantType='Color' and (StyleCode='' or StyleCode is null)"));
}
public DataTable getcategorydetails(string productskucode, string styleCode)
{
return
(GenericDAO.getDataTable("select * from PRODUCTS where SKUCode='" + productskucode + "' or StyleCode='" + styleCode + "'"));
}