public IHttpActionResult GetTrendsProducts(string version)
{
try
{
System.Net.Http.Headers.HttpRequestHeaders headers = this.Request.Headers;
string x_StateName = string.Empty;
string x_DistrictName = string.Empty;
if (headers.Contains("state"))
{
x_StateName = headers.GetValues("state").First().ToLower();
}
if (headers.Contains("district"))
{
x_DistrictName = headers.GetValues("district").First().ToLower();
}
DataSet ds = new DataSet();
ds = LiveStocks.BZTrendsProducts(version, x_StateName, x_DistrictName);
//ds.Tables[0].TableName = "TrendsProducts";Product,ProductsApiReponse
ds.Tables[0].TableName = "Product";
//return Ok(new { TrendsProductsApiReponse = ds, Status = true });
return(Ok(new { ProductsApiReponse = ds, Status = true }));
}
catch (Exception ex)
{
LogDal.ErrorLog(this.GetType().Name, MethodBase.GetCurrentMethod().Name, ex.Message, 0);
return(Ok(new { ProductsApiReponse = "", Status = false }));
}
}
public IHttpActionResult LiveStockMethod(int LiveStockID, int BreedId, int MilkAmount, string Mode, string version)
{
try
{
DataSet ds = new DataSet();
ds = LiveStocks.GetLiveStock(LiveStockID, BreedId, MilkAmount, Mode, version);
ds.Tables[0].TableName = "LiveStockDetails";
ds.Tables[1].TableName = "AnimalDetails";
DataSet ds1 = new DataSet();
ds1 = LiveStocks.BZTrendsProducts("1", "", "");
// ds1 = LiveStocks.BZLiveStockProducts("1");
ds1.Tables[0].TableName = "Products";
ds.Tables.Add(ds1.Tables[0].Copy());
BALLiveStock objLiveStock = new BALLiveStock();
List <BALLiveStock> ListLiveStock = new List <BALLiveStock>();
var liveStockData = ds.Tables[0].AsEnumerable();
var liveStockProduct = ds1.Tables[0].AsEnumerable();
AnimalDetails objAnimal = new AnimalDetails();
objAnimal.LiveStockId = Convert.ToInt32(ds.Tables["AnimalDetails"].Rows[0]["LiveStockId"]);
objAnimal.LiveStockName = ds.Tables["AnimalDetails"].Rows[0]["LiveStockName"].ToString();
objAnimal.LiveStockNameHindi = ds.Tables["AnimalDetails"].Rows[0]["LiveStockNameHindi"].ToString();
objAnimal.LiveStockType = Convert.ToInt32(ds.Tables["AnimalDetails"].Rows[0]["LiveStockType"]);
objAnimal.BreedId = Convert.ToInt32(ds.Tables["AnimalDetails"].Rows[0]["BreedId"]);
objAnimal.BreedName = Convert.ToString(ds.Tables["AnimalDetails"].Rows[0]["BreedName"]);
objAnimal.IsMilk = Convert.ToBoolean(ds.Tables["AnimalDetails"].Rows[0]["IsMilk"]);
objAnimal.MilkQuantity = Convert.ToInt32(ds.Tables["AnimalDetails"].Rows[0]["MilkQuantity"]);
objAnimal.IsActive = Convert.ToBoolean(ds.Tables["AnimalDetails"].Rows[0]["IsActive"]);
objAnimal.ImageUrl = ds.Tables["AnimalDetails"].Rows[0]["ImageUrl"].ToString();
objAnimal.BALLiveStock = new List <BALLiveStock>();
foreach (var item in liveStockData)
{
objAnimal.BALLiveStock.Add(new BALLiveStock
{
ID = item.Field <int>("ID"),
Name = item.Field <string>("Name"),
Description = item.Field <string>("Description"),
Extra = item.Field <int>("Extra"),
IsShow = item.Field <bool>("IsShow"),
VideoUrl = item.Field <string>("VideoUrl"),
ImageUrl = item.Field <string>("ImageUrl"),
Products = new List <Products>()
});
}
foreach (var ItemList in objAnimal.BALLiveStock)
{
foreach (var item1 in liveStockProduct)
{
if (item1.Field <long>("RowNumber") > 1)
{
ItemList.Products.Add(new Products
{
RowNumber = item1.Field <long>("RowNumber"),
ProductID = item1.Field <int>("ProductID"),
ProductName = item1.Field <string>("ProductName"),
OrganisationName = item1.Field <string>("OrganisationName"),
BrandName = item1.Field <string>("BrandName"),
TechnicalName = item1.Field <string>("TechnicalName"),
SubCategoryName = item1.Field <string>("SubCategoryName"),
CategoryName = item1.Field <string>("CategoryName"),
CategoryHindi = item1.Field <string>("CategoryHindi"),
CategoryID = item1.Field <byte>("CategoryID"),
PackageID = item1.Field <int>("PackageID"),
RN = item1.Field <Int64>("RN"),
OfferPrice_Qty = item1.Field <int?>("OfferPrice_Qty"),
Amount = item1.Field <decimal>("Amount"),
UnitName = item1.Field <string>("UnitName"),
OurPrice = item1.Field <decimal>("OurPrice"),
offerprice = item1.Field <decimal>("offerprice"),
RecordID = item1.Field <int>("RecordID"),
CreatedDate = item1.Field <DateTime>("CreatedDate"),
IsActive = item1.Field <bool>("IsActive"),
status = item1.Field <string>("status"),
CretedBy = item1.Field <string>("CretedBy"),
ProductHindiName = item1.Field <string>("ProductHindiName"),
IsDetails = item1.Field <bool>("IsDetails"),
ImagePath = item1.Field <string>("ImagePath"),
DistrictID = item1.Field <int>("DistrictID"),
DistrictName = item1.Field <string>("DistrictName"),
COD = item1.Field <decimal>("COD"),
OnlinePrice = item1.Field <decimal>("OnlinePrice"),
MRP = item1.Field <decimal>("MRP"),
OfferDiscount = item1.Field <string>("OfferDiscount") + " छूट"
});
}
}
}
return(Ok(new { LiveStockResults = objAnimal, Status = true }));
}
catch (Exception ex)
{
LogDal.ErrorLog(this.GetType().Name, MethodBase.GetCurrentMethod().Name, ex.Message, 0);
return(Ok(new { LiveStockResults = "", Status = false }));
}
}