public JsonResult GetBanner()
{
try
{
using (var context = new ChossonKallahAdmin.EF6.ChossonKallah())
{
var result = context.Database.SqlQuery <EF6.WebsiteBanner>("sp_WebSitebanner_select_Front").ToList();
return(Json(SessionUtilities.ConvertDataTableTojSonString(SessionUtilities.LINQResultToDataTable(result)), JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
return(Json(string.Format("Exception {0}", ex.Message), JsonRequestBehavior.AllowGet));
}
}
public JsonResult GetCategories()
{
try
{
using (var context = new ChossonKallahAdmin.EF6.ChossonKallah())
{
var result = context.Database.SqlQuery <EF6.Category>("sp_Category_select_Front").ToList();
List <EF6.CategoryClass> LstCat = new List <EF6.CategoryClass>();
for (int i = 0; i < result.Count; i++)
{
EF6.CategoryClass childcat = new EF6.CategoryClass();
childcat.CategoryId = result[i].CategoryId;
childcat.CategoryName = result[i].CategoryName;
LstCat.Add(childcat);
}
for (int i = 0; i < LstCat.Count; i++)
{
var CategoryIdPara = new SqlParameter("@CategoryId", LstCat[i].CategoryId);
var SubCat = context.Database.SqlQuery <EF6.CategoryClass>("sp_Category_Sub_select_Front @CategoryId", CategoryIdPara).ToList();
LstCat[i].childCat = new List <EF6.CategoryClass>();
for (int j = 0; j < SubCat.Count; j++)
{
EF6.CategoryClass childcat = new EF6.CategoryClass();
childcat.CategoryId = SubCat[j].CategoryId;
childcat.CategoryName = SubCat[j].CategoryName;
LstCat[i].childCat.Add(childcat);
}
}
return(Json(SessionUtilities.ConvertDataTableTojSonString(SessionUtilities.LINQResultToDataTable(LstCat)), JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
return(Json(string.Format("Exception {0}", ex.Message), JsonRequestBehavior.AllowGet));
}
}
public JsonResult GetListingDataByCategory(Int32 CategoryId)
{
try
{
using (var context = new ChossonKallahAdmin.EF6.ChossonKallah())
{
var CategoryIdPara = new SqlParameter("@CategoryId", CategoryId);
var result = context.Database.SqlQuery <EF6.BusinessDirectoryClass>("sp_BusinessDirectory_select_Front @CategoryId", CategoryIdPara).ToList();
List <EF6.BusinessDirectoryClass> LstCat = new List <EF6.BusinessDirectoryClass>();
for (int i = 0; i < result.Count; i++)
{
EF6.BusinessDirectoryClass childcat = new EF6.BusinessDirectoryClass();
childcat.BusinessName = result[i].BusinessName;
childcat.BusinessID = result[i].BusinessID;
childcat.Website = result[i].Website;
childcat.BusinessURL = result[i].BusinessURL;
childcat.PhoneNumber = result[i].PhoneNumber;
childcat.BusinessImage = result[i].BusinessImage;
childcat.LocationId = result[i].LocationId;
childcat.Address = result[i].Address;
childcat.AddressLine2 = result[i].AddressLine2;
childcat.City = result[i].City;
childcat.State = result[i].State;
childcat.Zipcode = result[i].Zipcode;
childcat.IsActive = result[i].IsActive;
childcat.IsDeleted = result[i].IsDeleted;
childcat.CreatedOn = result[i].CreatedOn;
childcat.DeletedOn = result[i].DeletedOn;
childcat.PhoneNumber2 = result[i].PhoneNumber2;
childcat.Email = result[i].Email;
childcat.HasBrochure = result[i].HasBrochure;
childcat.IsFeatured = result[i].IsFeatured;
childcat.BusinessVideoURL = result[i].BusinessVideoURL;
childcat.BusinessLogo = result[i].BusinessLogo;
LstCat.Add(childcat);
}
for (int i = 0; i < LstCat.Count; i++)
{
var BusinessIdPara = new SqlParameter("@BusinessID", LstCat[i].BusinessID);
var SubCat = context.Database.SqlQuery <EF6.BusinessGalleryClass>("sp_Business_Gallery_select_Front @BusinessID", BusinessIdPara).ToList();
LstCat[i].Gallery = new List <EF6.BusinessGalleryClass>();
for (int j = 0; j < SubCat.Count; j++)
{
EF6.BusinessGalleryClass childcat = new EF6.BusinessGalleryClass();
childcat.BusinessGalleryID = SubCat[j].BusinessGalleryID;
childcat.BusinessID = SubCat[j].BusinessID;
childcat.ImageName = SubCat[j].ImageName;
childcat.IsActive = SubCat[j].IsActive;
childcat.Sequence = SubCat[j].Sequence;
LstCat[i].Gallery.Add(childcat);
}
}
return(Json(SessionUtilities.ConvertDataTableTojSonString(SessionUtilities.LINQResultToDataTable(LstCat)), JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
return(Json(string.Format("Exception {0}", ex.Message), JsonRequestBehavior.AllowGet));
}
}
