public static List <ExploreVM> ReadExcelExpore(string filePath)
{
List <ExploreVM> assets = new List <ExploreVM>();
var connectionString = string.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0}; Extended Properties=Excel 8.0;", @filePath);
var adapter = new OleDbDataAdapter("SELECT * FROM [Sayfa1$]", connectionString);
var ds = new DataSet();
adapter.Fill(ds, "hardcatAssets");
DataTable data = ds.Tables["hardcatAssets"];
foreach (DataRow row in data.Rows)
{
ExploreVM asset = new ExploreVM();
int i = 0;
foreach (PropertyInfo pinfo in asset.GetType().GetProperties())
{
pinfo.SetValue(asset, row.ItemArray[i].ToString());
i++;
}
assets.Add(asset);
}
return(assets);
}
public ActionResult Explore(ExploreVM conceptSet)
{
// try
//{
// TODO: Add insert logic here
//if (String.IsNullOrWhiteSpace(conceptSet.search)) return View();
ExploreVM retSet = UpdateConceptSet(conceptSet);
TempData["conceptSet"] = retSet;
return(RedirectToAction("Index"));
// }
//catch (Exception ex)
//{
// if (User.IsInRole("Administrator"))
// {
// System.Diagnostics.Debug.Write(ex);
// throw new HttpException(500, ex.Message);
// //
// }
// ViewBag.error = ex.Message;
// return RedirectToAction("Index");
//}
}
private ExploreVM UpdateConceptSet(ExploreVM conceptSet)
{
conceptSet.originalSearch = conceptSet.search;
searchLogger.Info("search: {0} user: {1}", conceptSet.search, User.Identity.Name);
conceptSet.isAdmin = User.IsInRole("Administrator");
List <FullWord> results = SuomenkieliRepository.GetWordsByExplore(conceptSet);
conceptSet.resultList = results;
return(conceptSet);
}
public ActionResult Explore(string id)
{
ExploreVM ex = new ExploreVM();
//if (!id.Contains('*')) id = id + '*';
ex.search = id;
ExploreVM retSet = UpdateConceptSet(ex);
TempData["conceptSet"] = retSet;
return(RedirectToAction("Index"));
}
public ActionResult Index(string q)
{
ExploreVM evm = null;
if (!String.IsNullOrWhiteSpace(q))
{
evm = UpdateConceptSet(new ExploreVM()
{
search = q
});
}
else
{
evm = (ExploreVM)TempData["conceptSet"];
}
return(View(evm));
}
public ActionResult Index(int?ItemForID, int?ItemTypeID, string SearchText, string SearchType, int?pageNo)
{
PopulateItemForDropDownList();
PopulateItemTypeDropDownList();
ExploreVM model = new ExploreVM();
if (SearchType == "Item" || SearchType == null)
{
var itemsObj = db.UserItemDetails.AsEnumerable().Where(i => i.UserAccount.Status == true).Where(i => i.ItemDetail.Status == true).Select(i => i.ItemDetail);
if (!String.IsNullOrEmpty(SearchText))
{
itemsObj = itemsObj.Where(s => s.Location.ToLower().Contains(SearchText.ToLower()) || s.City.ToLower().Contains(SearchText.ToLower()));
}
if (ItemForID.HasValue && ItemForID.Value > 0)
{
itemsObj = itemsObj.Where(e => e.ItemForID == ItemForID);
}
if (ItemTypeID.HasValue && ItemTypeID.Value > 0)
{
itemsObj = itemsObj.Where(e => e.ItemTypeID == ItemTypeID);
}
int count = itemsObj.Count();
pageNo = pageNo ?? 1;
var skipCount = (pageNo.Value - 1) * pageSize;
itemsObj = itemsObj.OrderByDescending(x => x.ItemID).Skip(skipCount).Take(pageSize);
model.Pager = new Pager(count, pageNo, pageSize);
model.Count = count;
model.ItemDetails = itemsObj.ToList();
model.SearchText = SearchText;
model.ItemForID = ItemForID ?? default(int);
model.ItemTypeID = ItemTypeID ?? default(int);
model.UserItemDetails = db.UserItemDetails;
model.SearchType = "Item";
}
else if (SearchType == "SearchingFor")
{
var srch = db.UserSearchingFors.AsEnumerable().Where(i => i.UserAccount.Status == true).Where(i => i.SearchingFor.Status == true).Select(i => i.SearchingFor);
if (!String.IsNullOrEmpty(SearchText))
{
srch = srch.Where(s => s.Location.ToLower().Contains(SearchText.ToLower()) || s.City.ToLower().Contains(SearchText.ToLower()));
}
int count = srch.Count();
pageNo = pageNo ?? 1;
//pageNo = pageNo.HasValue ? pageNo.Value : 1;
var skipCount = (pageNo.Value - 1) * pageSize;
srch = srch.OrderByDescending(x => x.SearchingForID).Skip(skipCount).Take(pageSize);
model.Pager = new Pager(count, pageNo, pageSize);
model.Count = count;
model.SearchingFors = srch.ToList();
model.SearchText = SearchText;
model.UserSearchingFors = db.UserSearchingFors;
model.SearchType = "SearchingFor";
}
return(View(model));
}
