コード例 #1
0
        public async Task <IEnumerable <dynamic> > SaveOrUpdate([FromBody] TechUpgradeViewModel svm)
        {
            string sql = "dbo.EAppSaveTechUpgrade";

            using (var conn = util.MasterCon())
            {
                try
                {
                    return(await(conn.QueryAsync <dynamic>(sql, new
                    {
                        svm.TechUpgradeId,
                        svm.ClientSiteId,
                        svm.EquipmentId,
                        svm.ReportDate,
                        svm.RecommendationDate,
                        svm.Saving,
                        svm.Recommendation,
                        svm.Remarks,
                        svm.OriginalFileName,
                        svm.LogicalFileName,
                        svm.PhysicalFilePath,
                        svm.Active,
                        svm.UserId
                    }, commandType: CommandType.StoredProcedure)));
                }
                catch (Exception ex)
                {
                    throw new CustomException("Unable to Save Or Update, Please Contact Support!!!", "Error", true, ex);
                }
            }
        }
コード例 #2
0
        public async Task <IActionResult> UploadFiles()
        {
            try
            {
                CurrentUser cUser = new CurrentUser(HttpContext, _configuration);

                var          customHeaders      = Request.Headers;
                StringValues aId                = "";
                StringValues Type               = "";
                StringValues EquipmentId        = "";
                StringValues PlantAreaId        = "";
                StringValues Saving             = "";
                StringValues ReportDate         = "";
                StringValues RecommendationDate = "";
                StringValues Recommendation     = "";
                StringValues Remarks            = "";
                if (customHeaders.ContainsKey("aId") && customHeaders.ContainsKey("Type"))
                {
                    customHeaders.TryGetValue("aId", out aId);
                    customHeaders.TryGetValue("Type", out Type);
                    customHeaders.TryGetValue("equipmentId", out EquipmentId);
                    customHeaders.TryGetValue("plantAreaId", out PlantAreaId);
                    customHeaders.TryGetValue("saving", out Saving);
                    customHeaders.TryGetValue("reportDate", out ReportDate);
                    customHeaders.TryGetValue("recommendationDate", out RecommendationDate);
                    customHeaders.TryGetValue("recommendation", out Recommendation);
                    customHeaders.TryGetValue("remarks", out Remarks);
                    List <FileUploadViewModel> fuvms = await fileUploadService.UploadFiles(Request, HttpContext);

                    foreach (FileUploadViewModel fuvm in fuvms)
                    {
                        TechUpgradeViewModel svm = new TechUpgradeViewModel();
                        svm.ClientSiteId       = Int32.Parse(aId);
                        svm.EquipmentId        = Int32.Parse(EquipmentId);
                        svm.ReportDate         = DateTime.Parse(ReportDate);
                        svm.Saving             = Decimal.Parse(Saving);
                        svm.RecommendationDate = DateTime.Parse(RecommendationDate);
                        svm.Recommendation     = Recommendation;
                        svm.OriginalFileName   = fuvm.OriginalFileName;
                        svm.LogicalFileName    = fuvm.LogicalFileName;
                        svm.PhysicalFilePath   = fuvm.PhysicalFilePath.Replace(@"\", @"/");
                        svm.Active             = "Y";
                        svm.UserId             = cUser.UserId;
                        await iRepo.SaveOrUpdate(svm);
                    }
                }

                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)));
            }
        }