public ActionResult GetServices()
{
var allAnunciosList = new List<AN_Anuncios>();
List<AnunciosViewModel> viewModelAnuncios = new List<AnunciosViewModel>();
using (Entities model = new Entities())
{
allAnunciosList = model.AN_Anuncios.AsParallel().OrderByDescending(c => c.AN_Fecha).Where(sts => sts.ST_Id == 1).ToList();
foreach (var item in allAnunciosList)
{
string username = item.UserProfile.Name;
string statusDesc = item.ST_Estatus.ST_Descripcion;
var categoria = item.SBS_SubCategoriaServicio.CD_CategoriaServicio.CD_Descripcion;
var firstImage = string.Empty;
if (item.AE_AnunciosExtras.FirstOrDefault() != null)
{
firstImage = item.AE_AnunciosExtras.FirstOrDefault().AN_ImagenUrl;
}
else
{
firstImage = item.UserProfile.Image == null ? "~/Images/No_Profile.jpg" : item.UserProfile.Image;
}
//item.AN_Fecha = Convert.ToDateTime(item.AN_Fecha.ToShortDateString());
var getRating = model.SEL_ValoracionAnuncios(item.AN_Id).FirstOrDefault();
string urlimg = Request.Url.GetLeftPart(UriPartial.Authority) + VirtualPathUtility.ToAbsolute("~/");
var formatted = firstImage.Replace("~", "");
if (formatted.StartsWith("/"))
formatted = formatted.Remove(0, 1);
firstImage = urlimg + formatted;
var number = 0;
item.SS_SolicitudServicio.AsParallel().ToList().ForEach((counter) =>
{
number += counter.RW_Reviews.Count;
});
viewModelAnuncios.Add(new AnunciosViewModel
{
Usuario = username,
EstatusDescription = statusDesc,
AnunciosInfo = item,
CategoriaDescripcion = categoria,
FirstImage = firstImage,
Rating = getRating,
Comments = number,
});
}
}
if (viewModelAnuncios == null || viewModelAnuncios.Count == 0)
{
return HttpNotFound();
}
var anuncios = viewModelAnuncios.SerializeToJson();
return Json(anuncios);
}
public ActionResult GetInformationAnuncios(FormCollection form)
{
var allAnunciosList = new List<AN_Anuncios>();
var category = string.IsNullOrEmpty(form["Categoria"]) ? default(int) : int.Parse(form["Categoria"].ToString());
var subcategoria = string.IsNullOrEmpty(form["SubCategoria"]) ? default(int) : int.Parse(form["SubCategoria"].ToString());
var lugar = string.IsNullOrEmpty(form["Lugar"]) ? default(string) : form["Lugar"].ToString();
var descripcion = string.IsNullOrEmpty(form["Descripcion"]) ? default(string) : form["Descripcion"].ToString();
List<AnunciosViewModel> viewModelAnuncios = new List<AnunciosViewModel>();
using (Entities model = new Entities())
{
allAnunciosList = db.Get_AdvanceSearch(category, subcategoria, descripcion, lugar).ToList();
foreach (var item in allAnunciosList)
{
string username = item.UserProfile.Name;
string statusDesc = item.ST_Estatus.ST_Descripcion;
var categoria = item.SBS_SubCategoriaServicio.CD_CategoriaServicio.CD_Descripcion;
var firstImage = string.Empty;
if (item.AE_AnunciosExtras.FirstOrDefault() != null)
{
firstImage = item.AE_AnunciosExtras.FirstOrDefault().AN_ImagenUrl;
}
else
{
firstImage = item.UserProfile.Image == null ? "~/Images/No_Profile.jpg" : item.UserProfile.Image;
}
var getRating = model.SEL_ValoracionAnuncios(item.AN_Id).FirstOrDefault();
string urlimg = Request.Url.GetLeftPart(UriPartial.Authority) + VirtualPathUtility.ToAbsolute("~/");
var formatted = firstImage.Replace("~", "");
if (formatted.StartsWith("/"))
formatted = formatted.Remove(0, 1);
firstImage = urlimg + formatted;
List<RW_Reviews> rvList = new List<RW_Reviews>();
model.SS_SolicitudServicio.Where(c => c.AN_Id == item.AN_Id).AsParallel().ToList().ForEach(
c =>
{
c.RW_Reviews.AsParallel().ToList().ForEach(i => rvList.Add(i));
});
viewModelAnuncios.Add(new AnunciosViewModel
{
Usuario = username,
EstatusDescription = statusDesc,
AnunciosInfo = item,
CategoriaDescripcion = categoria,
FirstImage = firstImage,
Rating = getRating,
ReviewList = rvList
});
}
}
if (viewModelAnuncios == null || viewModelAnuncios.Count == 0)
{
return Json(new { Error = "No se encontraron registros" });
}
var anuncios = viewModelAnuncios.SerializeToJson();
return Json(anuncios);
}
public ActionResult GetAnunciosByUser()
{
int UserId = UserId = WebSecurity.CurrentUserId;
var allAnunciosList = new List<AN_Anuncios>();
List<AnunciosViewModel> viewModelAnuncios = new List<AnunciosViewModel>();
using (Entities model = new Entities())
{
allAnunciosList = model.AN_Anuncios.OrderBy(c => c.AN_Fecha).Where(acc => acc.ST_Id == 1 && acc.UserId == UserId).ToList();
var categoriasList = new List<Categoria>();
db.CD_CategoriaServicio.ToList().ForEach(c =>
{
var subCatList = new List<SubCategorias>();
c.SBS_SubCategoriaServicio.ToList().ForEach(sb =>
{
subCatList.Add(new SubCategorias { SubCatId = sb.SBS_Id, SubCatDesc = sb.SBS_Descripcion });
});
categoriasList.Add(new Categoria
{
CatId = c.CD_Id,
CatDesc = c.CD_Descripcion,
SubCatCollection = subCatList
});
});
ViewBag.Categories = categoriasList;
foreach (var item in allAnunciosList)
{
string username = item.UserProfile.Name;
string statusDesc = item.ST_Estatus.ST_Descripcion;
var categoria = item.SBS_SubCategoriaServicio.CD_CategoriaServicio.CD_Descripcion;
var firstImage = string.Empty;
if (item.AE_AnunciosExtras.FirstOrDefault() != null)
{
firstImage = item.AE_AnunciosExtras.FirstOrDefault().AN_ImagenUrl;
}
var getRating = model.SEL_ValoracionAnuncios(item.AN_Id).FirstOrDefault();
string urlimg = Request.Url.GetLeftPart(UriPartial.Authority) + VirtualPathUtility.ToAbsolute("~/");
var formatted = firstImage.Replace("~", "");
if (formatted.StartsWith("/"))
formatted = formatted.Remove(0, 1);
firstImage = urlimg + formatted;
viewModelAnuncios.Add(new AnunciosViewModel
{
Usuario = username,
EstatusDescription = statusDesc,
AnunciosInfo = item,
CategoriaDescripcion = categoria,
FirstImage = firstImage, Rating = getRating
});
}
}
if (viewModelAnuncios == null || viewModelAnuncios.Count == 0)
{
return HttpNotFound();
}
return View(viewModelAnuncios);
}