public IHttpActionResult GetHumTumOffer(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.GetHumTumOffer(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 GetBrandWiseProduct(string version, int?CategoryId, int BrandId, int DistrictId, int PageIndex, int PageSize) { try { DataSet ds = new DataSet(); DataSet ds1 = new DataSet(); ds = LiveStocks.GetCategoryWiseProduct(version, CategoryId, null, DistrictId, BrandId, PageIndex, PageSize); ds.Tables[0].TableName = "Product"; ds.Tables[1].TableName = "BrandCategory"; ds1.Tables.Add(ds.Tables["Product"].Copy()); var productData = ds.Tables[0].AsEnumerable(); var distinctData = productData.Select(x => x.Field <string>("ProductHindiName")).Distinct(); if (ds.Tables[0].Rows.Count > 0) { return(Ok(new { ProductsApiReponse = ds1, Status = true })); } else { return(Ok(new { ProductsApiReponse = "", Status = false })); } } catch (Exception ex) { LogDal.ErrorLog(this.GetType().Name, MethodBase.GetCurrentMethod().Name, ex.Message, 0); return(Ok(new { ProductsApiReponse = "", Status = false })); } }
public IHttpActionResult BZFarmerAppServices(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.AppServices(version, x_StateName, x_DistrictName); if (ds.Tables.Count > 0) { List <dynamic> objlist = new List <dynamic>(); if (ds.Tables.Count > 2) { ds.Tables[0].TableName = "BZFarmerAppServices"; ds.Tables[1].TableName = "District"; ds.Tables[2].TableName = "State"; var Location = new { DistrictId = ds.Tables[1].Rows[0]["DistrictId"], StateId = ds.Tables[2].Rows[0]["State"] }; objlist.Add(Location); } else { var Location = new { DistrictId = "", StateId = "" }; objlist.Add(Location); } DataSet ds1 = new DataSet(); ds.Tables[0].TableName = "BZFarmerAppServices"; ds1.Tables.Add(ds.Tables[0].Copy()); return(Ok(new { BZApiReponse = ds1, Location = objlist, Status = true })); } else { return(Ok(new { BZApiReponse = "", Msg = "Jankari", Status = false })); } } catch (Exception ex) { LogDal.ErrorLog(this.GetType().Name, MethodBase.GetCurrentMethod().Name, ex.Message, 0); return(Ok(new { BZApiReponse = "", Msg = "Jankari", Status = false })); } }
public IHttpActionResult GetBZLiveStockBreed(int LiveStockId, string version) { try { DataSet ds = new DataSet(); ds = LiveStocks.BZLiveStockBreed(LiveStockId, version); ds.Tables[0].TableName = "BZLiveStockBreed"; return(Ok(new { BZApiReponse = ds, Status = true })); } catch (Exception ex) { LogDal.ErrorLog(this.GetType().Name, MethodBase.GetCurrentMethod().Name, ex.Message, 0); return(Ok(new { BZApiReponse = "", Status = false })); } }
public IHttpActionResult GetSubCategory(string version, int?CategoryId) { try { #region Authentication Token //System.Net.Http.Headers.HttpRequestHeaders headers = this.Request.Headers; //string token = string.Empty; //string pwd = string.Empty; //if (headers.Contains("username")) //{ // token = headers.GetValues("username").First(); //} //if (headers.Contains("password")) //{ // pwd = headers.GetValues("password").First(); //} #endregion System.Net.Http.Headers.HttpRequestHeaders headers = this.Request.Headers; string x_StateName = string.Empty; string x_DistrictName = string.Empty; if (headers.Contains("x_StateName")) { x_StateName = headers.GetValues("x_StateName").First(); } if (headers.Contains("x_DistrictName")) { x_DistrictName = headers.GetValues("x_DistrictName").First(); } DataSet ds1 = new DataSet(); //if (CategoryId == 2) //{ // ds1 = LiveStocks.GetCropDetails(version, CategoryId); //} //else //{ ds1 = LiveStocks.GetSubCategories(version, CategoryId, true, x_StateName, x_DistrictName); //} ds1.Tables[0].TableName = "SubCategory"; return(Ok(new { ProductsApiReponse = ds1, Status = true })); } catch (Exception ex) { LogDal.ErrorLog(this.GetType().Name, MethodBase.GetCurrentMethod().Name, ex.Message, 0); return(Ok(new { ProductsApiReponse = "", Status = false })); } }
public IHttpActionResult GetProductsBySearch(string version, string SearchText) { 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(); DataSet ds1 = new DataSet(); ds = LiveStocks.GetProductsBySearch(version, x_StateName, x_DistrictName, SearchText); ds.Tables[0].TableName = "Product"; var productData = ds.Tables[0].AsEnumerable(); var distinctData = productData.Select(x => x.Field <string>("ProductHindiName")).Distinct(); DataSet ds2 = new DataSet(); ds2.Tables.Add(ds.Tables[0].Copy()); //ds2.Tables.Add(ds1.Tables[0].Copy()); if (ds2.Tables[0].Rows.Count > 0) { return(Ok(new { ProductsApiReponse = ds2, Status = true })); } else { return(Ok(new { ProductsApiReponse = "", Status = false })); } } 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 })); } }
public IHttpActionResult GetSathiAppProductDetails(string version, int CategoryId, int BzProductId, int PackageId) { try { DataSet ds = new DataSet(); ds = LiveStocks.GetSathiAppProductDetails(version, CategoryId, BzProductId, PackageId); if (ds.Tables.Count > 0) { if (ds.Tables[0].Rows.Count > 0) { ds.Tables[0].TableName = "ImageAndVideo"; ds.Tables[1].TableName = "ProductDetails"; ds.Tables[2].TableName = "ProductDetailsHindi"; DataTable dTImageUrl = new DataTable("ImageUrlPath"); DataTable dTVideoUrl = new DataTable("VideoUrlPath"); DataTable dTProductDetails = new DataTable("ProductDetails"); dTImageUrl.Columns.Add("ImagePath"); dTVideoUrl.Columns.Add("VideoUrl"); dTVideoUrl.Columns.Add("ImagePath"); string[] imageUrl = null; string[] videoUrl = null; string[] ThumbnailPath = null; if (ds.Tables[0].Rows[0]["ImageUrl"].ToString() != null) { ds.Tables[0].Rows[0]["ImageUrl"] = ds.Tables[0].Rows[0]["ImageUrl"].ToString(); imageUrl = ds.Tables[0].Rows[0]["ImageUrl"].ToString().Split('#'); foreach (var item in imageUrl) { var values = new object[1]; values[0] = item; dTImageUrl.Rows.Add(values); } } if (ds.Tables[0].Rows[0]["VideoUrl"].ToString() != null) { videoUrl = ds.Tables[0].Rows[0]["VideoUrl"].ToString().Split('#'); ThumbnailPath = ds.Tables[0].Rows[0]["VideoThumbnailPath"].ToString().Split('#'); for (int i = 0; i < videoUrl.Length; i++) { DataRow dr = dTVideoUrl.NewRow(); dr["VideoUrl"] = videoUrl[i]; if (i < ThumbnailPath.Length) { dr["ImagePath"] = ThumbnailPath[i]; } else { dr["ImagePath"] = null; } dTVideoUrl.Rows.Add(dr); } } DataSet dsNew = new DataSet(); dsNew.Tables.Add(dTImageUrl); dsNew.Tables.Add(dTVideoUrl); dsNew.Tables.Add(ds.Tables[1].Copy()); dsNew.Tables.Add(ds.Tables[2].Copy()); return(Ok(new { BZApiReponse = dsNew, Status = true })); } else { return(Ok(new { BZApiReponse = "", Status = false })); } } else { return(Ok(new { BZApiReponse = "", Status = false })); } } catch (Exception ex) { LogDal.ErrorLog(this.GetType().Name, MethodBase.GetCurrentMethod().Name, ex.Message, 0); return(Ok(new { BZApiReponse = "", Status = false })); } }