public JsonResult Get()
{
DatabaseCURD dbCurd = new DatabaseCURD();
List <ProductSegmentClass> lst = dbCurd.GetSegmentProduct(Configuration["ConnectionStrings:Default"]);
return(new JsonResult(lst));
}
public JsonResult Get()
{
DatabaseCURD dbCurd = new DatabaseCURD();
List <ProductSizeClass> lst = dbCurd.GetAllSize(Configuration["ConnectionStrings:Default"]);
return(new JsonResult(lst)); //dbCurd.GetAllProduct(Configuration["ConnectionStrings:Default"]);
//return "value";
}
public JsonResult Get(int id)
{
DatabaseCURD dbCurd = new DatabaseCURD();
List <ProductFamilyClass> lst = dbCurd.GetFamilyByID(Configuration["ConnectionStrings:Default"], id);
return(new JsonResult(lst)); //dbCurd.GetAllProduct(Configuration["ConnectionStrings:Default"]);
//return "value";
}
public JsonResult Get()
{
DatabaseCURD dbCurd = new DatabaseCURD();
List <decimal> lst = dbCurd.GetDistinctDiscount(Configuration["ConnectionStrings:Default"]);
// string query = dbCurd.GetDistinctDiscount(Configuration["ConnectionStrings:Default"]);
return(new JsonResult(lst)); //dbCurd.GetAllProduct(Configuration["ConnectionStrings:Default"]);
//return "value";
}
public JsonResult Get(decimal Discount)
{
DatabaseCURD dbCurd = new DatabaseCURD();
List <ProductDetailsClass> lst = dbCurd.GetDiscountDetailsAll(Configuration["ConnectionStrings:Default"], Discount);
// string query = dbCurd.GetProductDetails(Configuration["ConnectionStrings:Default"],Family,Class,Commodity,Color,Brand);
return(new JsonResult(lst)); //dbCurd.GetAllProduct(Configuration["ConnectionStrings:Default"]);
//return "value";
}
public JsonResult Get(string SearchValue, string Color, string Brand, string Size)
{
DatabaseCURD dbCurd = new DatabaseCURD();
List <ProductDetailsClass> lst = dbCurd.GetSearchProductDetailsWFilter(Configuration["ConnectionStrings:Default"], Color, Brand, Size, SearchValue);
// string query = dbCurd.GetProductDetails(Configuration["ConnectionStrings:Default"],Family,Class,Commodity,Color,Brand);
return(new JsonResult(lst)); //dbCurd.GetAllProduct(Configuration["ConnectionStrings:Default"]);
//return "value";
}
public JsonResult Get(string SearchValue)
{
DatabaseCURD dbCurd = new DatabaseCURD();
//string result = dbCurd.GetSearchProductDetails(Configuration["ConnectionStrings:Default"],SearchValue);
//return result;
List <ProductDetailsClass> lst = dbCurd.GetSearchProductDetails(Configuration["ConnectionStrings:Default"], SearchValue);
return(new JsonResult(lst));
}
public JsonResult Get(int id)
{
List <ProductMenuDetails> lst = new List <ProductMenuDetails>();
DatabaseCURD dbCurd = new DatabaseCURD();
lst = dbCurd.GetMenuDetails(Configuration["ConnectionStrings:Default"], id);
return(new JsonResult(lst));
}
public JsonResult Get(Int32 Family, Int32 Class)
{
DatabaseCURD dbCurd = new DatabaseCURD();
List <ProductDetailsClass> lst = dbCurd.GetProductDetailsExCommodity(Configuration["ConnectionStrings:Default"], Family, Class);
// string query = dbCurd.GetProductDetailsExCommodity(Configuration["ConnectionStrings:Default"],Family,Class);
return(new JsonResult(lst)); //dbCurd.GetAllProduct(Configuration["ConnectionStrings:Default"]);
//return "value";
}
public JsonResult Get()
{
string errorSt = string.Empty;
DatabaseCURD dbCurd = new DatabaseCURD();
List <ProductDetailsClass> lst = dbCurd.GetProductDetailsAllData(Configuration["ConnectionStrings:Default"]);
//errorSt = dbCurd.GetProductDetailsAllData(Configuration["ConnectionStrings:Default"]);;
// string query = dbCurd.GetProductDetails(Configuration["ConnectionStrings:Default"],Family,Class,Commodity,Color,Brand);
return(new JsonResult(lst)); //dbCurd.GetAllProduct(Configuration["ConnectionStrings:Default"]);
//return "value";
}
