public ActionResult DeleteJournal(string JournalId, string FilePath)
{
try
{
var curUrl = ConfigurationManager.AppSettings["url"].TrimEnd('/');
var pathDelete = FilePath.Replace(curUrl, "").Replace("/", "\\");
var serverDir = Server.MapPath("/").TrimEnd('\\');
var fileDel = serverDir + pathDelete;
int idx = fileDel.IndexOf(JournalId);
if (idx != -1)
{
fileDel = fileDel.Substring(0, idx + 36);
System.IO.Directory.Delete(fileDel, true);
}
Guid journalId = Guid.Parse(JournalId);
PlantDAL.EDMX.Journal journal = JournalCRUD.GetByID(journalId);
List <Images> images = ImageCRUD.GetByJournalID(journalId);
foreach (var img in images)
{
ImageCRUD.Delete(img);
}
JournalCRUD.Delete(journal);
}
catch (Exception ex)
{
ex.ToString();
}
return(Json(new { IsError = false, message = "success", data = true }, JsonRequestBehavior.AllowGet));
}
public ActionResult JournalDisplay(string journalId)
{
var curUrl = ConfigurationManager.AppSettings["url"];
curUrl = curUrl.TrimEnd('/');
PlantDAL.EDMX.Journal journal = JournalCRUD.GetByID(Guid.Parse(journalId));
JournalDto dto = Mappers.JournalMapper.MapDALToDto(journal);
List <Images> imgs = ImageCRUD.GetByJournalID(Guid.Parse(journalId));
foreach (var img in imgs)
{
var idx = img.ImageFilePath.ToLower().IndexOf(@"\images\");
if (dto.imageFilePath == null)
{
dto.imageFilePath = new List <string>();
}
if (idx != -1)
{
var imgpath = curUrl + img.ImageFilePath.Substring(idx).Replace("\\", "/");
dto.imageFilePath.Add(imgpath);
}
}
PlantDAL.EDMX.Plant plant = PlantCRUD.GetByID(dto.PlantId);
dto.Plants.Add(new SelectListItem
{
Text = plant.Name,
Value = plant.ID.ToString()
});
return(View(dto));
}
public ActionResult GetData()
{
// Initialization.
JsonResult result = this.Json(new { draw = Convert.ToInt32(0), recordsTotal = 0, recordsFiltered = 0, data = Array.Empty <JournalTableDto>() }, JsonRequestBehavior.AllowGet);
try
{
var strCurrentUserId = User.Identity.GetUserId();
// Initialization.
string search = Request.Form.GetValues("search[value]")[0];
string draw = Request.Form.GetValues("draw")[0];
string order = Request.Form.GetValues("order[0][column]")[0];
string orderDir = Request.Form.GetValues("order[0][dir]")[0];
int startRec = Convert.ToInt32(Request.Form.GetValues("start")[0]);
int pageSize = Convert.ToInt32(Request.Form.GetValues("length")[0]);
var listOfJournals = JournalCRUD.Search(strCurrentUserId, search, orderDir, order, startRec, pageSize);
var tableJournals = new List <JournalTableDto>();
foreach (var journal in listOfJournals)
{
List <Images> images = ImageCRUD.GetByJournalID(journal.ID);
JournalTableDto tableDto = new JournalTableDto();
tableDto.JournalId = journal.ID.ToString();
tableDto.Name = journal.Name;
tableDto.Date = journal.DateModified.ToString();
string firstImage = "";
if (images.Count() > 0)
{
firstImage = images.First().ImageFilePath;
int idx = firstImage.ToLower().IndexOf(@"\images\");
firstImage = firstImage.Substring(idx);
}
tableDto.Image = firstImage;
tableJournals.Add(tableDto);
}
int totalRecords = PlantCRUD.GetByUserID(strCurrentUserId).Count();
int recFilter = listOfJournals.Count();
// Loading drop down lists.
result = this.Json(new { draw = Convert.ToInt32(draw), recordsTotal = listOfJournals.Count(), recordsFiltered = recFilter, data = tableJournals }, JsonRequestBehavior.AllowGet);
}
catch (Exception ex)
{
//Loger.Log.Error(ex);
}
// Return info.
return(result);
}
public ActionResult NewJournal(JournalDto journalDto)
{
Guid id = Guid.NewGuid();
journalDto.ID = id;
journalDto.UserID = User.Identity.GetUserId();
var plantDir = Server.MapPath("~/Images/Journal/" + id.ToString());
List <Images> imgList = Mappers.ImageMapper.MapHTTPToImage(journalDto.Images, journalDto, plantDir);
PlantDAL.EDMX.Journal journal = Mappers.JournalMapper.MapDtoToDAL(journalDto, imgList);
journal.DateModified = DateTime.Now;
JournalCRUD.Insert(journal);
return(RedirectToAction("JournalTable"));
}
public ActionResult JournalDetails(JournalDto journalDto)
{
var plantDir = Server.MapPath("~/Images/Journal/" + journalDto.ID.ToString());
List <Images> imgList = Mappers.ImageMapper.MapHTTPToImage(journalDto.Images, journalDto, plantDir);
foreach (var img in imgList)
{
ImageCRUD.Insert(img);
}
PlantDAL.EDMX.Journal journal = Mappers.JournalMapper.MapDtoToDAL(journalDto, imgList);
journal.UserID = User.Identity.GetUserId();
JournalCRUD.Update(journal);
return(RedirectToAction("JournalTable"));
}
public ActionResult DeletePlant(string PlantId, string FilePath)
{
try
{
var curUrl = ConfigurationManager.AppSettings["url"].TrimEnd('/');
var pathDelete = FilePath.Replace(curUrl, "").Replace("/", "\\");
var serverDir = Server.MapPath("/").TrimEnd('\\');
var fileDel = serverDir + pathDelete;
int idx = fileDel.IndexOf(PlantId);
if (idx != -1)
{
fileDel = fileDel.Substring(0, idx + 36);
System.IO.Directory.Delete(fileDel, true);
}
Guid plantId = Guid.Parse(PlantId);
PlantDAL.EDMX.Plant plant = PlantCRUD.GetByID(plantId);
List <Images> images = ImageCRUD.GetByPlantID(plantId);
foreach (var img in images)
{
ImageCRUD.Delete(img);
}
if (plant.CustomValueOneID != null)
{
CustomValues cv = CustomValueCRUD.GetByID(plant.CustomValueOneID);
CustomValueCRUD.Delete(cv);
}
if (plant.CustomValueTwoD != null)
{
CustomValues cv = CustomValueCRUD.GetByID(plant.CustomValueTwoD);
CustomValueCRUD.Delete(cv);
}
if (plant.CustomValueThreeID != null)
{
CustomValues cv = CustomValueCRUD.GetByID(plant.CustomValueThreeID);
CustomValueCRUD.Delete(cv);
}
if (plant.CustomValueFourID != null)
{
CustomValues cv = CustomValueCRUD.GetByID(plant.CustomValueFourID);
CustomValueCRUD.Delete(cv);
}
if (plant.CustomValueFiveID != null)
{
CustomValues cv = CustomValueCRUD.GetByID(plant.CustomValueFiveID);
CustomValueCRUD.Delete(cv);
}
List <PlantDAL.EDMX.Journal> journals = JournalCRUD.GetByPlantID(plant.ID);
foreach (var jour in journals)
{
List <Images> jourImages = ImageCRUD.GetByJournalID(jour.ID);
foreach (var img in jourImages)
{
ImageCRUD.Delete(img);
}
JournalCRUD.Delete(jour);
}
List <PlantDAL.EDMX.Plant> childrenPlants = PlantCRUD.GetByParentId(plant.ID);
foreach (var plt in childrenPlants)
{
if (plt.ParentOneID == plant.ID)
{
plt.ParentOneID = null;
}
if (plt.ParentTwoID == plant.ID)
{
plt.ParentTwoID = null;
}
PlantCRUD.Update(plt);
}
PlantCRUD.Delete(plant);
}
catch (Exception ex)
{
ex.ToString();
}
return(Json(new { IsError = false, message = "success", data = true }, JsonRequestBehavior.AllowGet));
}
public ActionResult PlantDetails(string plantId)
{
PlantDAL.EDMX.Plant plant = PlantCRUD.GetByID(Guid.Parse(plantId));
PlantDto dto = Mappers.PlantMapper.MapDALToDto(plant);
List <PlantDAL.EDMX.Plant> plantList = new List <PlantDAL.EDMX.Plant>();
plantList = PlantCRUD.GetByUserID(User.Identity.GetUserId());
foreach (var plt in plantList)
{
dto.Plants.Add(new SelectListItem
{
Text = plt.Name,
Value = plt.ID.ToString()
});
}
List <PlantDAL.EDMX.Journal> journalList = JournalCRUD.GetByPlantID(dto.ID);
foreach (var jour in journalList)
{
dto.Journals.Add(new SelectListItem
{
Text = jour.Name,
Value = jour.ID.ToString()
});
}
List <Images> imgs = ImageCRUD.GetByPlantID(Guid.Parse(plantId));
var curUrl = ConfigurationManager.AppSettings["url"];
curUrl = curUrl.TrimEnd('/');
foreach (var img in imgs)
{
var idx = img.ImageFilePath.ToLower().IndexOf(@"\images\");
if (idx != -1)
{
if (dto.imageFilePath == null)
{
dto.imageFilePath = new List <string>();
}
var imgpath = curUrl + img.ImageFilePath.Substring(idx).Replace("\\", "/");
dto.imageFilePath.Add(imgpath);
}
}
if (plant.CustomValueOneID != null || plant.CustomValueOneID == Guid.Empty)
{
plant.CustomValues = CustomValueCRUD.GetByID(plant.CustomValueOneID);
dto.CustomValues1 = Mappers.CustomValueMapper.MapDALToDto(plant.CustomValues, 1) as CustomValueDto;
}
if (plant.CustomValueTwoD != null || plant.CustomValueOneID == Guid.Empty)
{
plant.CustomValues1 = CustomValueCRUD.GetByID(plant.CustomValueTwoD);
dto.CustomValues2 = Mappers.CustomValueMapper.MapDALToDto(plant.CustomValues1, 2) as CustomValueDto;
}
if (plant.CustomValueThreeID != null || plant.CustomValueThreeID == Guid.Empty)
{
plant.CustomValues2 = CustomValueCRUD.GetByID(plant.CustomValueThreeID);
dto.CustomValues3 = Mappers.CustomValueMapper.MapDALToDto(plant.CustomValues2, 3) as CustomValueDto;
}
if (plant.CustomValueFourID != null || plant.CustomValueFourID == Guid.Empty)
{
plant.CustomValues3 = CustomValueCRUD.GetByID(plant.CustomValueFourID);
dto.CustomValues4 = Mappers.CustomValueMapper.MapDALToDto(plant.CustomValues3, 4) as CustomValueDto;
}
if (plant.CustomValueFiveID != null || plant.CustomValueFiveID == Guid.Empty)
{
plant.CustomValues4 = CustomValueCRUD.GetByID(plant.CustomValueFiveID);
dto.CustomValues5 = Mappers.CustomValueMapper.MapDALToDto(plant.CustomValues4, 5) as CustomValueDto;
}
return(View(dto));
}
