public virtual ActionResult FileUpload(HttpPostedFileBase file)
{
try
{
IImagesRepository imagesRepository = DependencyResolver.Current.GetService <IImagesRepository>();
var memStream = new MemoryStream();
file.InputStream.CopyTo(memStream);
byte[] fileData = memStream.ToArray();
//get existing
Data.Models.Image newImage = imagesRepository.GetList().FirstOrDefault(x => x.Name == file.FileName && x.Binary.Length == fileData.Length);
//get from database
if (newImage == null)
{
newImage = imagesRepository.Insert(new Data.Models.Image {
Binary = fileData, Name = file.FileName, CreatedDateTime = DateTime.Now
});
}
return(Json(new
{
success = true,
response = "File uploaded.",
id = newImage.Id.ToString(),
fileName = file.FileName
}));
}
catch (Exception exception)
{
return(Json(new
{
success = false,
response = exception.Message
}));
}
}
public IEnumerable <Images> getAllImages()
{
var images = _imagesRepository.GetList();
return(images);
}
public virtual JsonResult GetEntityList(string table, string field)
{
Table t = (Table)Enum.Parse(typeof(Table), table);
Field f = (Field)Enum.Parse(typeof(Field), field);
if (t == Table.Articles)
{
IArticleRepository repository = DependencyResolver.Current.GetService <IArticleRepository>();
if (f == Field.Name)
{
return(Json(repository.GetList().Select(x => new { x.Id, x.Name }), JsonRequestBehavior.AllowGet));
}
if (f == Field.Description)
{
return(Json(repository.GetList().Select(x => new { x.Id, Name = x.Description }), JsonRequestBehavior.AllowGet));
}
}
if (t == Table.Certificates)
{
ICertificatesRepository repository = DependencyResolver.Current.GetService <ICertificatesRepository>();
if (f == Field.Name)
{
return(Json(repository.GetList().Select(x => new { x.Id, x.Name }), JsonRequestBehavior.AllowGet));
}
}
if (t == Table.Contacts)
{
IContactsRepository repository = DependencyResolver.Current.GetService <IContactsRepository>();
if (f == Field.Name)
{
return(Json(repository.GetList().Select(x => new { x.Id, x.Name }), JsonRequestBehavior.AllowGet));
}
if (f == Field.Description)
{
return(Json(repository.GetList().Select(x => new { x.Id, Name = x.Description }), JsonRequestBehavior.AllowGet));
}
}
if (t == Table.Images)
{
IImagesRepository repository = DependencyResolver.Current.GetService <IImagesRepository>();
if (f == Field.Name)
{
return(Json(repository.GetList().Select(x => new { x.Id, x.Name }), JsonRequestBehavior.AllowGet));
}
}
if (t == Table.Languages)
{
ILanguagesRepository repository = DependencyResolver.Current.GetService <ILanguagesRepository>();
if (f == Field.Name)
{
return(Json(repository.GetList().Select(x => new { x.Id, x.Name }), JsonRequestBehavior.AllowGet));
}
}
if (t == Table.PortfolioDetails)
{
IPortfolioDetailsRepository repository = DependencyResolver.Current.GetService <IPortfolioDetailsRepository>();
if (f == Field.Name)
{
return(Json(repository.GetList().Select(x => new { x.Id, x.Name }), JsonRequestBehavior.AllowGet));
}
}
if (t == Table.Portfolios)
{
IPortfoliosRepository repository = DependencyResolver.Current.GetService <IPortfoliosRepository>();
if (f == Field.Name)
{
return(Json(repository.GetList().Select(x => new { x.Id, x.Name }), JsonRequestBehavior.AllowGet));
}
if (f == Field.Description)
{
return(Json(repository.GetList().Select(x => new { x.Id, Name = x.Description }), JsonRequestBehavior.AllowGet));
}
}
if (t == Table.ProductCategories)
{
IProductCategoriesRepository repository = DependencyResolver.Current.GetService <IProductCategoriesRepository>();
if (f == Field.Name)
{
return(Json(repository.GetList().Select(x => new { x.Id, x.Name }), JsonRequestBehavior.AllowGet));
}
if (f == Field.Description)
{
return(Json(repository.GetList().Select(x => new { x.Id, Name = x.Description }), JsonRequestBehavior.AllowGet));
}
}
if (t == Table.Products)
{
IProductsRepository repository = DependencyResolver.Current.GetService <IProductsRepository>();
if (f == Field.Name)
{
return(Json(repository.GetList().Select(x => new { x.Id, x.Name }), JsonRequestBehavior.AllowGet));
}
if (f == Field.Description)
{
return(Json(repository.GetList().Select(x => new { x.Id, Name = x.Description }), JsonRequestBehavior.AllowGet));
}
}
if (t == Table.Quotes)
{
IQuotesRepository repository = DependencyResolver.Current.GetService <IQuotesRepository>();
if (f == Field.Description)
{
return(Json(repository.GetList().Select(x => new { x.Id, Name = x.Description }), JsonRequestBehavior.AllowGet));
}
}
if (t == Table.Sliders)
{
ISlidersRepository repository = DependencyResolver.Current.GetService <ISlidersRepository>();
if (f == Field.Name)
{
return(Json(repository.GetList().Select(x => new { x.Id, x.Name }), JsonRequestBehavior.AllowGet));
}
}
return(Json("", JsonRequestBehavior.AllowGet));
}
public object GetAll()
{
var queryValues = Request.RequestUri.ParseQueryString();
int page = Convert.ToInt32(queryValues["page"]);
int start = Convert.ToInt32(queryValues["start"]);
int limit = Convert.ToInt32(queryValues["limit"]);
int id = Convert.ToInt32(queryValues["id"]);
int orden = Convert.ToInt32(queryValues["orden"]);
int itemId = Convert.ToInt32(queryValues["ItemId"]);
#region Configuramos el orden de la consulta si se obtuvo como parametro
string strOrder = !string.IsNullOrWhiteSpace(queryValues["sort"]) ? queryValues["sort"] : "";
strOrder = strOrder.Replace('[', ' ');
strOrder = strOrder.Replace(']', ' ');
Sort sort;
if (!string.IsNullOrWhiteSpace(strOrder))
{
sort = JsonConvert.DeserializeObject <Sort>(strOrder);
}
else
{
sort = new Sort();
}
#endregion
string query = !string.IsNullOrWhiteSpace(queryValues["query"]) ? queryValues["query"] : "";
int totalRecords = 0;
try
{
if (id == 0)
{
object json;
string msgError = "";
IList <Img> lista;
lista = repository.GetList(itemId, query, sort, page, start, limit, ref totalRecords, ref msgError);
json = new
{
total = totalRecords,
data = lista,
success = true
};
return(json);
}
else
{
string msgError = "";
Img estatus = repository.Get(id, ref msgError);
object json = new
{
data = estatus,
success = true,
message = msgError
};
return(json);
}
}
catch (Exception ex)
{
LogManager.Write("ERROR:" + Environment.NewLine + "\tMETHOD = " + this.GetType().FullName + "." + MethodBase.GetCurrentMethod().Name + Environment.NewLine + "\tMESSAGE = " + ex.Message);
object error = new { message = ex.Message };
object json = new
{
message = ex.Message,
success = false
};
return(json);
}
}
