public async Task <IActionResult> AddDevDtrFgtResult(AddDevDtrFgtResultDto addDevDtrFgtResultDto) { _logger.LogInformation(String.Format(@"****** DTRController AddDevDtrFgtResult fired!! ******")); var devDtrFgtResult = _mapper.Map <DevDtrFgtResult>(addDevDtrFgtResultDto); if (devDtrFgtResult != null) { if (String.IsNullOrEmpty(devDtrFgtResult.FILENAME)) { devDtrFgtResult.FILENAME = ""; } if (String.IsNullOrEmpty(devDtrFgtResult.PARTNO)) { devDtrFgtResult.PARTNO = ""; } if (String.IsNullOrEmpty(devDtrFgtResult.PARTNAME)) { devDtrFgtResult.PARTNAME = ""; } devDtrFgtResult.UPUSR = devDtrFgtResult.UPUSR; devDtrFgtResult.UPDAY = DateTime.Now; _devDtrFgtResultDAO.Add(devDtrFgtResult); await _devDtrFgtResultDAO.SaveAll(); return(Ok(true)); } return(Ok(false)); }
public async Task <IActionResult> DeleteDevDtrFgtResult(AddDevDtrFgtResultDto addDevDtrFgtResultDto) { _logger.LogInformation(String.Format(@"****** DTRController DeleteDevDtrFgtResult fired!! ******")); var devDtrFgtResult = _mapper.Map <DevDtrFgtResult>(addDevDtrFgtResultDto); if (devDtrFgtResult != null) { //Step1: kill fgt result _devDtrFgtResultDAO.Remove(devDtrFgtResult); await _devDtrFgtResultDAO.SaveAll(); //Step2: kill the pdf // save or delete file to server List <string> nastFileName = new List <string>(); nastFileName.Add("QCTestResult"); nastFileName.Add(devDtrFgtResult.ARTICLE); nastFileName.Add(devDtrFgtResult.FILENAME); //Step3:( if it have pdf) recount the pass or fault and previous labNo if (await _fileService.SaveFiletoServer(null, "F340PpdPic", nastFileName)) { _logger.LogInformation(String.Format(@"******DTRController DeleteDevDtrFgtResult Delete a PDF: {0}!! ******", devDtrFgtResult.FILENAME)); /* Cancel FgtStats 2021/09/14 Aven * //3.1 :find the status by article stage kind * var dtrFgtStats = _devDtrFgtStatsDAO.FindSingle( * x => x.ARTICLE.Trim() == devDtrFgtResult.ARTICLE && * x.STAGE.Trim() == devDtrFgtResult.STAGE && * x.KIND.Trim() == devDtrFgtResult.KIND); * if (devDtrFgtResult.RESULT == "PASS") dtrFgtStats.PASS -= 1; * if (devDtrFgtResult.RESULT == "FAIL") dtrFgtStats.FAIL -= 1; * //3.2 find previous (the) * var thePrevious = _devDtrFgtResultDAO * .FindAll(x => x.ARTICLE.Trim() == devDtrFgtResult.ARTICLE && * x.STAGE.Trim() == devDtrFgtResult.STAGE && * x.KIND.Trim() == devDtrFgtResult.KIND && * x.FILENAME.Trim() != "") * .OrderByDescending(x => x.LABNO).Take(1).ToList().FirstOrDefault(); * _logger.LogInformation(String.Format(@"******DTRController DeleteDevDtrFgtResult the Previous Lab No is : {0}!! ******", devDtrFgtResult.FILENAME)); * if (thePrevious != null) * { * dtrFgtStats.LABNO = thePrevious.LABNO; * } * else * { * dtrFgtStats.LABNO = ""; * } * _devDtrFgtStatsDAO.Update(dtrFgtStats); * await _devDtrFgtStatsDAO.SaveAll(); */ } return(Ok(true)); } return(Ok(false)); }
public async Task <IActionResult> UpdateDevDtrFgtResult(AddDevDtrFgtResultDto updateDevDtrFgtResultDto) { _logger.LogInformation(String.Format(@"****** DTRController UpdateDevDtrFgtResult fired!! ******")); DevDtrFgtResult model = _devDtrFgtResultDAO.FindSingle( x => x.ARTICLE.Trim() == updateDevDtrFgtResultDto.Article && x.MODELNO.Trim() == updateDevDtrFgtResultDto.ModelNo && x.MODELNAME.Trim() == updateDevDtrFgtResultDto.ModelName && x.LABNO.Trim() == updateDevDtrFgtResultDto.LabNo && x.STAGE.Trim() == updateDevDtrFgtResultDto.Stage && x.KIND.Trim() == updateDevDtrFgtResultDto.Kind); if (model != null) { model.RESULT = updateDevDtrFgtResultDto.Result; model.REMARK = updateDevDtrFgtResultDto.Remark; model.UPUSR = updateDevDtrFgtResultDto.Upusr; model.UPDAY = DateTime.Now; _devDtrFgtResultDAO.Update(model); await _devDtrFgtResultDAO.SaveAll(); return(Ok(true)); } return(Ok(false)); }