public async Task <int> UpdateInformFinalDataSupervisor(BE.ReportBE.Report report)
{
int i = 0;
try {
if (report.ActionType == 1)
{
i = _assignmentRepository.UpdateInformFinalDataSupervisor(report);
}
else if (report.ActionType == 2)
{
i = _assignmentRepository.UpdateInformFinalDataSupervisor(report);
List <Attachment> listAttachments = new List <Attachment>();
if (!string.IsNullOrEmpty(report.UrlFile))
{
string[] arrName = report.UrlFile.Split('/');
var stream = new WebClient().OpenRead(new Uri(report.UrlFile));
Attachment attachement = new Attachment(stream, arrName[arrName.Length - 1]);
listAttachments.Add(attachement);
//listUsers.Add("*****@*****.**");
//listUsersCC.Add("*****@*****.**");
listUsersCC.Add("*****@*****.**");
}
else
{
}
listUsersCC.Add("*****@*****.**");
await email.PostSendEmail(listUsers, listUsersCC, "FERREYROS", "<p>Comentario del Supervisor:</p><p>" + report.Comment2 + "</p>", true, listAttachments);
}
} catch (Exception ex) {
Log.Write(ex);
throw;
}
return(i);
}
public int DeleteArchiveInformFinal(BE.ReportBE.Report report)
{
int i = 0;
i = _assignmentRepository.DeleteArchiveInformFinal(report);
return(i);
}
public async Task <int> UpdateArchiveInformFinal(BE.ReportBE.Report report)
{
int i = 0;
if (report.ActionType == 1)
{
i = _assignmentRepository.UpdateArchiveInformFinal(report);
}
else if (report.ActionType == 2)
{
report.Sent1 = true;
i = _assignmentRepository.UpdateArchiveInformFinal(report);
if (i >= 1)
{
if (report.WhoUpdate == 1)
{
return(i);
}
listUsersCC.Add("*****@*****.**");
// listUsersCC.Add("*****@*****.**");
// listUsersCC.Add("*****@*****.**");
await email.PostSendEmail(listUsers, listUsersCC, "FERREYROS", "<p>El tecnico ha generado su informe Final de la OT-XXXX</p>", true, new List <Attachment>());
}
}
return(i);
}
public int UpdateUrlInformFinalSupervisor(BE.ReportBE.Report report)
{
int i = 0;
i = _assignmentRepository.UpdateUrlInformFinalSupervisor(report);
return(i);
}
public async Task <int> UpdateExecutiveReport(BE.ReportBE.Report report)
{
int i = 0;
if (report.ActionType == 1)
{
i = _assignmentRepository.UpdateExecutiveReport(report);
}
else if (report.ActionType == 2)
{
i = _assignmentRepository.UpdateExecutiveReport(report);
if (i >= 1)
{
var dynamicFile = await GenerateAct(report, 2);
report.UrlExe = dynamicFile.FileUrl;
i = _assignmentRepository.UpdateExecutiveReport(report);
listAttachments.Add(new Attachment(dynamicFile.Route));
listUsers.Add("*****@*****.**");
listUsersCC.Add("*****@*****.**");
listUsersCC.Add("*****@*****.**");
await email.PostSendEmail(listUsers, listUsersCC, "FERREYROS", "<p>Este mensaje es para el cliente. Le estamos enviando un informe preliminar del servicio</p>", true, listAttachments);
}
}
;
return(i);
}
public int DeleteArchiveInformFinal(BE.ReportBE.Report report)
{
int i = 0;
DatabaseFactory.CreateDatabase()
.ExecuteNonQuery("TSP_REPORT_DELETE_INFORMFINAL", report.Id, report.AssignmentId, report.UrlFile, report.ModifiedBy);
i = 1;
return(i);
}
public int UpdateSendFiletoReportSupervisor(BE.ReportBE.Report report)
{
int i = 0;
try {
foreach (var item in report.Files)
{
if (item.status == 0)
{
i = _assignmentRepository.AddFileReportSupervisor(item);
}
else if (item.status == 1)
{
i = _assignmentRepository.DeleteFileReportSupervisor(item);
}
}
} catch (Exception ex) {
Log.Write(ex);
throw;
}
return(i);
}
public async Task <dynamic> GenerateAct(BE.ReportBE.Report report, int type)
{
var assignment = _assignmentRepository.GetReportSupervisor(report.AssignmentId);
var users = _assignmentRepository.GetByPersonnelIdAssignment(report.AssignmentId).ToList();
var usersClient = _assignmentRepository.GetContactByAssignemtnId(report.AssignmentId).ToList();
var supervisor = users.Where(x => x.UserType == 1).FirstOrDefault();
var technician = users.Where(x => x.UserType == 2).FirstOrDefault();
var client = usersClient.Where(x => x.Id == report.ContactId).FirstOrDefault();
var sValue = ConvertNumberToString(report.Value) + "\"";
var pdfContent = string.Empty;
if (type == 1)
{
pdfContent = Resources.Template.ActString.ToString();
}
else if (type == 2)
{
pdfContent = Resources.Template.ExeString.ToString();
}
CultureInfo ci = new CultureInfo("es-PE");
var colorStyle = sValue + " " + strFill.Replace("@@strcolor", strColor);
pdfContent = pdfContent
.Replace("@SocialName", assignment.CompanyName)
.Replace("@RUC", assignment.RUC)
.Replace("@Branch", assignment.CorpId)
.Replace("@Description", assignment.Description)
.Replace("@OT", assignment.WorkOrderNumber)
.Replace("@Brand", assignment.Machine.Brand)
.Replace("@Model", assignment.Machine.Model)
.Replace("@Technical", technician?.Name)
.Replace("@Horometro", assignment.Machine.TotalHoursFunction.ToString())
.Replace("@NumberSerie", assignment.Machine.SerialNumber)
.Replace("@DateDelivery", report.Date.ToString("dd-MM-yyyy", ci))
.Replace("@DateService", assignment.RequestDate.ToString("dd-MM-yyyy", ci))
.Replace("@Antecedent", report.Antecedent)
.Replace("@Work", report.Work)
.Replace("@Observations", report.Observation)
.Replace("@Recommendations", report.Replacement)
.Replace("@Client", client?.Name + " " + client?.LastName)
.Replace("@SignAct", report.UrlSign)
.Replace(sValue.ToString(), colorStyle)
//EXE
.Replace("@Supervisor", supervisor?.Name)
.Replace("@SPhone", supervisor?.Phone)
.Replace("@SMail", supervisor?.Email);
var converter = new HtmlToPdfConverter();
var pdfFile = converter.GeneratePdf(pdfContent);
var path = System.IO.Path.GetTempPath();
dynamic dynamicAttachment = new ExpandoObject();
string pdfString = ""; string nameFile = "";
nameFile = report.Id + ".pdf";
if (type == 1)
{
pdfString = nameFile;
}
else if (type == 2)
{
pdfString = $"{path}\\" + nameFile;
dynamicAttachment.Route = pdfString;
System.IO.File.WriteAllBytes(pdfString, pdfFile);
}
string container = "act";
dynamicAttachment.File = pdfFile;
dynamicAttachment.Container = container;
dynamicAttachment.Name = nameFile;
dynamicAttachment.Route = pdfString;
dynamicAttachment.FileUrl = "";
var result = await StorageHelperAzure.UploadFileToAzure(dynamicAttachment
, Constants.AzureStorage.DefaultConnectionString);
dynamicAttachment.FileUrl = result.FileUrl;
return(dynamicAttachment);
}
public int SyncReport(BE.ReportBE.Report item)
{
var i = _assignmentRepository.InsertReport(item);
return(i);
}
public int UpdateUrlInformFinalSupervisor(BE.ReportBE.Report report)
{
return(DatabaseFactory.CreateDatabase()
.ExecuteNonQuery("TSP_REPORT_UPDATE_FINAL_URL", report.Id, report.AssignmentId, report.UrlFile, report.ModifiedBy));
}
public int UpdateInformFinalDataSupervisor(BE.ReportBE.Report report)
{
return(DatabaseFactory.CreateDatabase()
.ExecuteNonQuery("TSP_REPORT_UPDATE_FINAL_SUPERVISOR", report.Id, report.AssignmentId, report.Comment2, report.Check,
report.ModifiedBy));
}
public int UpdateArchiveInformFinal(BE.ReportBE.Report report)
{
return(DatabaseFactory.CreateDatabase()
.ExecuteNonQuery("TSP_REPORT_UPDATE_FINAL", report.Id, report.AssignmentId, report.TotalMinute, report.Comment1,
report.UrlFile, report.Sent1, report.ModifiedBy));
}
public int UpdateExecutiveReport(BE.ReportBE.Report report)
{
return(DatabaseFactory.CreateDatabase()
.ExecuteNonQuery("TSP_REPORT_UPDATE_EXECUTIVE", report.Id, report.AssignmentId, report.Antecedent, report.Work,
report.Observation, report.Replacement, report.UrlExe, report.ModifiedBy));
}
//TÉCNICO
public int InsertReport(BE.ReportBE.Report entity)
{
return(DatabaseFactory.CreateDatabase()
.ExecuteNonQuery("TSP_REPORT_INSERT", entity.Id, entity.AssignmentId, entity.Antecedent, entity.Work,
entity.Observation, entity.Replacement, entity.Date, entity.UrlAct, entity.UrlSign, entity.ContactId, entity.Value, entity.Online, entity.CreatedBy));
}