public async Task <IEnumerable <dynamic> > SaveOrUpdateAttachment(ImagePlottingAttachmentViewModel ipavm) { string sql = "dbo.EAppSavePlottingAttachment"; using (var conn = util.MasterCon()) { try { return(await(conn.QueryAsync <dynamic>(sql, new { ipavm.PlottingAttachId, ipavm.PlantAreaId, ipavm.EquipmentId, ipavm.UnitType, ipavm.UnitId, ipavm.PlotType, ipavm.FileName, ipavm.LogicalName, ipavm.PhysicalPath, ipavm.Active, ipavm.UserId }, commandType: CommandType.StoredProcedure))); } catch (Exception ex) { throw new CustomException("Unable to Save Or Update, Please Contact Support!!!", "Error", true, ex); } } }
public async Task <IActionResult> UploadFiles() { try { CurrentUser cUser = new CurrentUser(HttpContext, _configuration); var customHeaders = Request.Headers; StringValues aId = ""; StringValues PlantAreaId = ""; StringValues EquipmentId = ""; StringValues UnitType = ""; StringValues UnitId = ""; StringValues PlotType = ""; StringValues ImageHeight = ""; StringValues ImageWidth = ""; if (customHeaders.ContainsKey("aId") && customHeaders.ContainsKey("Type")) { customHeaders.TryGetValue("plantAreaId", out PlantAreaId); customHeaders.TryGetValue("equipmentId", out EquipmentId); customHeaders.TryGetValue("unitType", out UnitType); customHeaders.TryGetValue("unitId", out UnitId); customHeaders.TryGetValue("plotType", out PlotType); List <FileUploadViewModel> fuvms = await fileUploadService.UploadFiles(Request, HttpContext); foreach (FileUploadViewModel fuvm in fuvms) { ImagePlottingAttachmentViewModel ipavm = new ImagePlottingAttachmentViewModel(); ipavm.PlottingAttachId = 0; if (PlotType == "PL") { ipavm.PlantAreaId = Int32.Parse(PlantAreaId); } if (PlotType == "EQ") { ipavm.EquipmentId = Int32.Parse(EquipmentId); } if (PlotType == "AS") { ipavm.UnitType = UnitType; ipavm.UnitId = Int32.Parse(UnitId); } ipavm.PlotType = PlotType; ipavm.FileName = fuvm.OriginalFileName; ipavm.LogicalName = fuvm.LogicalFileName; ipavm.PhysicalPath = fuvm.PhysicalFilePath; ipavm.Active = "Y"; ipavm.UserId = cUser.UserId; await imagePlottingRepo.SaveOrUpdateAttachment(ipavm); } } return(Json("Success")); } catch (CustomException cex) { var responseObj = new EmaintenanceMessage(cex.Message, cex.Type, cex.IsException, cex.Exception?.ToString()); return(StatusCode(StatusCodes.Status500InternalServerError, responseObj)); } catch (Exception ex) { return(Ok(new EmaintenanceMessage(ex.Message))); } }