public async Task <bool> AddRecD(AuditRecDDto model)
{
MES_Audit_Rec_D auditRecDConvert = _mapper.Map <MES_Audit_Rec_D>(model);
_repoD.Add(auditRecDConvert);
return(await _repoD.SaveAll());
}
public async Task <bool> UpdateRecD(AuditRecDDto model)
{
var auditRecD = _mapper.Map <MES_Audit_Rec_D>(model);
auditRecD.Updated_Time = DateTime.Now;
_repoD.Update(auditRecD);
return(await _repoD.SaveAll());
}
public async Task <IActionResult> CreateAuditRecD([FromBody] AuditRecDDto auditRecDDto)
{
var auditRecM = await _auditRecMService.GetRecMById(auditRecDDto.Record_ID);
var auditRecD = await _service.GetById(auditRecDDto.Record_ID);
if (auditRecD != null)
{
auditRecDDto.Item_no = auditRecD.Item_no + 1;
}
else
{
auditRecDDto.Item_no = 1;
}
var username = User.FindFirst(ClaimTypes.NameIdentifier).Value;
auditRecDDto.Updated_By = username;
auditRecDDto.Implement_User = username;
string folder = _webHostEnvironmentl.WebRootPath + "\\uploaded\\images";
if (auditRecDDto.Before_Picture != "")
{
var source = auditRecDDto.Before_Picture;
string base64 = source.Substring(source.IndexOf(',') + 1);
base64 = base64.Trim('\0');
byte[] charData = Convert.FromBase64String(base64);
if (!Directory.Exists(folder))
{
Directory.CreateDirectory(folder);
}
var fileName = auditRecM.Record_ID + "_" + auditRecM.Line + "_" + auditRecM.Model_No + "_B4_" + auditRecDDto.Item_no + ".jpg";
string filePathB4 = Path.Combine(folder, fileName);
System.IO.File.WriteAllBytes(filePathB4, charData);
auditRecDDto.Before_Picture = fileName;
}
if (auditRecDDto.After_Picture != "")
{
var source = auditRecDDto.After_Picture;
string base64 = source.Substring(source.IndexOf(',') + 1);
byte[] charData = Convert.FromBase64String(base64);
if (!Directory.Exists(folder))
{
Directory.CreateDirectory(folder);
}
var fileName = auditRecM.Record_ID + "_" + auditRecM.Line + "_" + auditRecM.Model_No + "_After_" + auditRecDDto.Item_no + ".jpg";
string filePathAfter = Path.Combine(folder, fileName);
System.IO.File.WriteAllBytes(filePathAfter, charData);
auditRecDDto.After_Picture = fileName;
}
if (await _service.AddRecD(auditRecDDto))
{
return(NoContent());
}
throw new Exception("Creating the Audit Rec D failed on save");
}
public async Task <bool> ImportExcel(string filePath, string userName)
{
string record_Id = await GetRecordIdRate();
using (var package = new ExcelPackage(new FileInfo(filePath)))
{
ExcelWorksheet workSheet = package.Workbook.Worksheets[0];
ExcelWorksheet workSheet2 = package.Workbook.Worksheets[1];
AuditRecMDto auditRecMDto = new AuditRecMDto();
for (int i = workSheet.Dimension.Start.Row + 1; i <= workSheet.Dimension.End.Row; i++)
{
auditRecMDto.Record_ID = record_Id;
auditRecMDto.Record_Time = Convert.ToDateTime(workSheet.Cells[i, 1].Value.ToString());
auditRecMDto.Updated_By = userName;
auditRecMDto.PDC = workSheet.Cells[i, 2].Value.ToString();
auditRecMDto.Building = workSheet.Cells[i, 3].Value.ToString();
auditRecMDto.Line = workSheet.Cells[i, 4].Value.ToString();
auditRecMDto.Model_No = workSheet.Cells[i, 5].Value.ToString();
auditRecMDto.Model_Name = _mesMo.FindAll().Where(x => x.Style_No.Trim()
== (workSheet.Cells[i, 5].Value.ToString()).Trim()).Count() == 0 ? "" :
_mesMo.FindAll().Where(x => x.Style_No.Trim()
== (workSheet.Cells[i, 5].Value.ToString()).Trim()).FirstOrDefault().Style_Name;
var auditRecM = _mapper.Map <MES_Audit_Rec_M>(auditRecMDto);
_repoAuditRecM.Add(auditRecM);
}
AuditRecDDto auditRecDDto = new AuditRecDDto();
for (int i = workSheet2.Dimension.Start.Row + 1; i <= workSheet2.Dimension.End.Row; i++)
{
auditRecDDto.Record_ID = record_Id;
auditRecDDto.Updated_By = userName;
auditRecDDto.Status = "Ongoing";
auditRecDDto.Item_no = workSheet2.Cells[i, 1].Value.ToInt();
auditRecDDto.Issue_LL = workSheet2.Cells[i, 2].Value.ToString();
var auditRecD = _mapper.Map <MES_Audit_Rec_D>(auditRecDDto);
_repoAuditRecD.Add(auditRecD);
}
try
{
await _repoAuditRecD.SaveAll();
return(true);
}
catch (System.Exception)
{
return(false);
throw;
}
}
}
public Task <bool> Add(AuditRecDDto model)
{
throw new System.NotImplementedException();
}
