/* * */ public List <CompartToolImageViewModel> GetCompartMeasuringImages() { List <CompartToolImageViewModel> retList = new List <CompartToolImageViewModel>(); if (Id == 0) { return(retList); } var res = _context.COMPART_TOOL_IMAGE.Where(m => m.CompartId == Id).OrderBy(m => m.ToolId).ToList(); foreach (var ctImg in res) { CompartToolImageViewModel ctImgVm = new CompartToolImageViewModel { Id = ctImg.Id, CompartId = ctImg.CompartId, CreatedDate = ctImg.CreatedDate.ToString("dd-MMM-yyyy"), ImageDataBase64 = Convert.ToBase64String(ctImg.ImageData), ImageType = ctImg.ImageType, Title = ctImg.Title, ToolId = ctImg.ToolId, ToolName = ctImg.Tool.tool_name }; retList.Add(ctImgVm); } return(retList); }
public ServerReturnMessage saveCompartToolImage(CompartToolImageViewModel ImageRecord) { ServerReturnMessage result = new ServerReturnMessage { Id = 0, Message = "Compartment is not found!", Succeed = false }; if (Id == 0) { return(result); } result.Message = "Selected tool is invalid!"; var tool = _context.TRACK_TOOL.Find(ImageRecord.ToolId); if (tool == null) { return(result); } COMPART_TOOL_IMAGE ctImage = new COMPART_TOOL_IMAGE(); ctImage.CompartId = Id; ctImage.ToolId = ImageRecord.ToolId; ctImage.Title = ImageRecord.Title; ctImage.ImageData = Convert.FromBase64String(ImageRecord.ImageDataBase64); ctImage.ImageType = ImageRecord.ImageType; ctImage.CreatedDate = DateTime.Now; var k = _context.COMPART_TOOL_IMAGE.Where(m => m.CompartId == ImageRecord.CompartId && m.ToolId == ImageRecord.ToolId); if (k.Count() > 0) { _context.COMPART_TOOL_IMAGE.RemoveRange(k); } _context.COMPART_TOOL_IMAGE.Add(ctImage); try { _context.SaveChanges(); result.Succeed = true; result.Message = "Operation succeeded"; return(result); } catch (Exception e1) { result.Message = "Operation failed! please try again!"; result.ExceptionMessage = e1.Message; if (e1.InnerException != null) { result.InnerExceptionMessage = e1.InnerException.Message; } result.Succeed = false; return(result); } }