public static bool IsProcessedImageExists(tblProcessedImage image)
{
var dbCtx = new CUATRGEntities4();
return(dbCtx.tblProcessedImages.Any <tblProcessedImage>(i => i.PIM_Name == image.PIM_Name &&
i.FLT_IDFkey == image.tblFilter.FLT_IDPkey &&
i.IMG_IDFkey == image.tblImage.IMG_IDPkey));
}
public static void HandleZipAsync(string startPath, string zipPath, tblFile file)
{
//Task.Run(() => ZipFile.CreateFromDirectory(startPath, zipPath));
ZipFile.CreateFromDirectory(startPath, zipPath);
var dbCtx = new CUATRGEntities4();
file.EndStamp = DateTime.Now;
dbCtx.SaveChanges();
}
public static bool IsExists(tblImage image)
{
var dbCtx = new CUATRGEntities4();
return(dbCtx.tblImages.Any <tblImage>(i => i.IMG_Name == image.IMG_Name &&
i.ALB_IDFkey == image.tblAlbum.ALB_IDPkey &&
i.FTR_IDFkey == image.tblFeature.FTR_IDPkey &&
i.ENC_IDFkey == image.tblEnvironmentalCondition.ENC_IDPkey));
}
public ActionResult CreateZipIndex(string message)
{
var dbCtx = new CUATRGEntities4();
var files = dbCtx.tblFiles.OrderByDescending(f => f.StartStamp).Take(10);
var model = new CreateZipViewModel
{
Message = !string.IsNullOrWhiteSpace(message) ? message :
files.FirstOrDefault() == null ? " " :
files.FirstOrDefault().EndStamp.HasValue ? " " :
(DateTime.Now - files.FirstOrDefault().StartStamp) > new TimeSpan(0, 10, 0) ? " " : "Zipping the images",
Files = files.ToList()
};
return(View(model));
}
public ActionResult CreateZip()
{
//string startPath = Server.MapPath("../") + @"Images\Albums";
string startPath = "D:\\Software";
string zipPath = "D:\\Temp\\" + DateTime.Now.ToString("yyyyMMddHHmmssffff") + ".zip";
var dbCtx = new CUATRGEntities4();
var file = dbCtx.tblFiles.Create();
file.Status = 0;
var paths = zipPath.Split('\\');
file.FileName = paths[paths.Length - 1];
file.StartStamp = DateTime.Now;
dbCtx.Entry(file).State = EntityState.Added;
dbCtx.SaveChanges();
//FileHelper.HandleZipAsync(startPath, zipPath);
Task.Run(() => FileHelper.HandleZipAsync(startPath, zipPath, file));
//ZipFile.ExtractToDirectory(zipPath, extractPath);
return(RedirectToAction("CreateZipIndex", new { message = "Zipping started.." }));
}
public string AddImage(string ddlAlbums, string ddlConditions,
string ddlFeatures)
{
var image = new tblImage();
try
{
var dbCtx = new CUATRGEntities4();
tblAlbum album = dbCtx.tblAlbums.FirstOrDefault(a => a.ALB_Name == ddlAlbums);
if (album == null)
{
album = dbCtx.tblAlbums.Create();
album.ALB_Name = ddlAlbums;
album.ALB_Description = ddlAlbums;
}
tblEnvironmentalCondition condition = dbCtx.tblEnvironmentalConditions.FirstOrDefault(a => a.ENC_Name == ddlConditions);
if (condition == null)
{
condition = dbCtx.tblEnvironmentalConditions.Create();
condition.ENC_Name = ddlConditions;
condition.ENC_Description = ddlConditions;
}
tblFeature feature = dbCtx.tblFeatures.FirstOrDefault(a => a.FTR_Name == ddlFeatures);
if (feature == null)
{
feature = dbCtx.tblFeatures.Create();
feature.FTR_Name = ddlFeatures;
}
image.tblAlbum = album;
image.tblEnvironmentalCondition = condition;
image.tblFeature = feature;
log.Info("Saving files started");
var files = HttpContext.Current.Request.Files.Count > 0 ?
HttpContext.Current.Request.Files : null;
log.InfoFormat("Files {0} , Album {1}, Condition {2}, Feature {3} ",
string.Join(",", files.AllKeys), ddlAlbums, ddlConditions, ddlFeatures);
if (files != null)
{
foreach (var file in files.AllKeys)
{
var path = string.Format("~/Images/Albums/{0}", ddlAlbums);
var relativePath = string.Format("Images/Albums/{0}", ddlAlbums);
var fileName = files[file].FileName;
if (fileName.Contains("Image") || fileName.Contains("IMG"))
{
image.IMG_Name = fileName;
image.IMG_Path = relativePath;
}
else if (fileName.Contains("Sensor"))
{
image.IMG_SensorDataPath = relativePath;
}
else if (fileName.Contains("Meta"))
{
image.IMG_MetaDataPath = relativePath;
}
if (ImageHelper.IsExists(image))
{
throw new InvalidOperationException("Image Exists");
}
var mappedPath = System.Web.Hosting.HostingEnvironment.MapPath(path);
var filePath = Path.Combine(mappedPath, Path.GetFileName(fileName));
if (!Directory.Exists(mappedPath))
{
log.Info("Creating directory");
Directory.CreateDirectory(mappedPath);
}
string user = System.Security.Principal.WindowsIdentity.GetCurrent().User.Value;
var uploadedFile = files[file];
uploadedFile.SaveAs(filePath);
}
}
log.Info("Saving files completed");
log.Info("Retriving Exif data started");
ImageHelper.ExtractMetaData(image);
log.Info("Saving db data started");
//Add newStudent entity into DbEntityEntry and mark EntityState to Added
dbCtx.Entry(image).State = EntityState.Added;
// call SaveChanges method to save new Student into database
dbCtx.SaveChanges();
log.Info("Saving db data completed");
return("OK");
}
catch (DbEntityValidationException ex)
{
var valErrors = ex.EntityValidationErrors.SelectMany(e => e.ValidationErrors);
var error = string.Join(",", valErrors.Select(e => e.ErrorMessage));
log.Error(string.Format("Error uploading image {0} - {1}", image.IMG_Name, error), ex);
return("ERROR:" + ex.Message.ToString());
}
catch (Exception ex)
{
log.Error(string.Format("Error saving image {0}", image.IMG_Name), ex);
return(ex.ToString());
}
}
public string AddProcessedImage(string name, string filterType, string filterName)
{
var processedImage = new tblProcessedImage();
try
{
var para = name.Split('_');
var masterImageName = "image_" + para[para.Length - 1];
var dbCtx = new CUATRGEntities4();
var masterImage = dbCtx.tblImages.FirstOrDefault(i => i.IMG_Name == masterImageName);
processedImage.tblImage = masterImage ?? throw new InvalidOperationException("Image not found");
var filter = dbCtx.tblFilters.FirstOrDefault(i => i.FLT_Name == filterName && i.FLT_Description == filterType);
processedImage.tblFilter = filter ?? throw new InvalidOperationException("Filter not found");
processedImage.CMD_IDFkey = 1;//Fixed color mode to RGP
log.Info("Saving files started");
var files = HttpContext.Current.Request.Files.Count > 0 ?
HttpContext.Current.Request.Files : null;
log.InfoFormat("Files {0} , Name {1}, Filter Type {2}, Filter Name {3} ",
string.Join(",", files.AllKeys), name, filterType, filterName);
if (files != null)
{
foreach (var file in files.AllKeys)
{
var path = string.Format("~/{0}", masterImage.IMG_Path);
var relativePath = masterImage.IMG_Path;
var fileName = files[file].FileName;
log.InfoFormat("File name : {0}", fileName);
if (fileName.Contains("Image") || fileName.Contains("IMG"))
{
processedImage.PIM_Name = fileName;
processedImage.PIM_Path = relativePath;
}
if (ImageHelper.IsProcessedImageExists(processedImage))
{
throw new InvalidOperationException("Processed Image Exists");
}
var mappedPath = System.Web.Hosting.HostingEnvironment.MapPath(path);
var filePath = Path.Combine(mappedPath, Path.GetFileName(fileName));
if (!Directory.Exists(mappedPath))
{
log.Info("Creating directory");
Directory.CreateDirectory(mappedPath);
}
string user = System.Security.Principal.WindowsIdentity.GetCurrent().User.Value;
var uploadedFile = files[file];
uploadedFile.SaveAs(filePath);
}
}
log.Info("Saving files completed");
log.Info("Saving db data started");
//Add newStudent entity into DbEntityEntry and mark EntityState to Added
dbCtx.Entry(processedImage).State = EntityState.Added;
// call SaveChanges method to save new Student into database
dbCtx.SaveChanges();
log.Info("Saving db data completed");
return("OK");
}
catch (DbEntityValidationException ex)
{
var valErrors = ex.EntityValidationErrors.SelectMany(e => e.ValidationErrors);
var error = string.Join(",", valErrors.Select(e => e.ErrorMessage));
log.Error(string.Format("Error uploading image {0} - {1}", processedImage.PIM_Name, error), ex);
return("ERROR:" + ex.Message.ToString());
}
catch (Exception ex)
{
log.Error(string.Format("Error uploading image {0}", processedImage.PIM_Name), ex);
return("ERROR:" + ex.Message.ToString());
}
}
public ActionResult AddImage(string name, string ddlAlbums, string ddlConditions,
string ddlFeatures, HttpPostedFileBase masterimage, HttpPostedFileBase sensordata)
{
var image = new tblImage();
try
{
int albumId = -1;
if (!int.TryParse(ddlAlbums, out albumId))
{
throw new InvalidDataException("Error in album id");
}
int conditionid = -1;
if (!int.TryParse(ddlConditions, out conditionid))
{
throw new InvalidDataException("Error in condition id");
}
int filterId = -1;
if (!int.TryParse(ddlFeatures, out filterId))
{
throw new InvalidDataException("Error in filter id");
}
//set image data
image.IMG_Name = name;
var dbCtx = new CUATRGEntities4();
tblAlbum album = dbCtx.tblAlbums.FirstOrDefault(a => a.ALB_IDPkey == albumId);
tblEnvironmentalCondition condition = dbCtx.tblEnvironmentalConditions.FirstOrDefault(a => a.ENC_IDPkey == conditionid);
tblFeature feature = dbCtx.tblFeatures.FirstOrDefault(a => a.FTR_IDPkey == filterId);
image.tblAlbum = album;
image.tblEnvironmentalCondition = condition;
image.tblFeature = feature;
image.IMG_Path = string.Format("Images/Albums/{0}", album.ALB_Name);
image.IMG_SensorDataPath = string.Format("Images/Albums/{0}", album.ALB_Name);
string[] imagaeData = masterimage.FileName.Split('\\');
image.IMG_Name = imagaeData[imagaeData.Length - 1];
if (ImageHelper.IsExists(image))
{
throw new InvalidOperationException("Image Exists");
}
log.Info("Saving files started");
FileHelper.SaveFile(image, masterimage, image.IMG_Name);
FileHelper.SaveFile(image, sensordata, image.IMG_Name.Replace("IMG", "SensorData").Replace("jpg", "csv"));
log.Info("Saving files completed");
log.Info("Retriving Exif data started");
ImageHelper.ExtractMetaData(image);
log.Info("Saving db data started");
//Add newStudent entity into DbEntityEntry and mark EntityState to Added
dbCtx.Entry(image).State = EntityState.Added;
// call SaveChanges method to save new Student into database
dbCtx.SaveChanges();
log.Info("Saving db data completed");
log.Info("View generation completed");
ViewBag.Message = "Successfully uploaded";
}
catch (Exception ex)
{
log.Error(string.Format("Error uploading image {0}", image.IMG_Name));
ViewBag.Message = "ERROR:" + ex.Message.ToString();
}
var viewModel = new AddImageViewModel()
{
Albums = imageDB.tblAlbums.ToList(),
Conditions = imageDB.tblEnvironmentalConditions.ToList(),
Features = imageDB.tblFeatures.ToList()
};
return(View(viewModel));
}
