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 + "'")); }