public ActionResult FoundSave(AuditoryCuestionarioFound found, int applicationUserId)
{
if (found.Id > 0)
{
return(found.Update(applicationUserId));
}
return(found.Insert(applicationUserId));
}
public ActionResult ReportData(long id, int companyId)
{
var res = "{\"Cuestionarios\":[";
res += Auditory.RenderCuestionarios(id, companyId);
res += "],\"Founds\":";
res += AuditoryCuestionarioFound.JsonList(AuditoryCuestionarioFound.ByAuditory(id, companyId));
res += ",\"Improvements\":";
res += AuditoryCuestionarioImprovement.JsonList(AuditoryCuestionarioImprovement.ByAuditory(id, companyId));
res += "}";
return(new ActionResult
{
Success = true,
ReturnValue = res,
MessageError = string.Empty
});
}
protected void Page_Load(object sender, EventArgs e)
{
long auditoryId = Convert.ToInt64(Request.QueryString["id"]);
int companyId = Convert.ToInt32(Request.QueryString["companyId"]);
var company = new Company(companyId);
var res = ActionResult.NoAction;
var user = HttpContext.Current.Session["User"] as ApplicationUser;
var dictionary = HttpContext.Current.Session["Dictionary"] as Dictionary <string, string>;
var auditory = Auditory.ById(auditoryId, user.CompanyId);
string path = HttpContext.Current.Request.PhysicalApplicationPath;
if (!path.EndsWith(@"\", StringComparison.OrdinalIgnoreCase))
{
path = string.Format(CultureInfo.InvariantCulture, @"{0}\", path);
}
string formatedDescription = auditory.Description.Replace("?", string.Empty);
formatedDescription = formatedDescription.Replace("#", string.Empty);
formatedDescription = formatedDescription.Replace("/", string.Empty);
formatedDescription = formatedDescription.Replace("\\", string.Empty);
formatedDescription = formatedDescription.Replace(":", string.Empty);
formatedDescription = formatedDescription.Replace(";", string.Empty);
formatedDescription = formatedDescription.Replace(".", string.Empty);
string fileName = string.Format(
CultureInfo.InvariantCulture,
@"{0}_{1}_Data_{2:yyyyMMddhhmmss}.pdf",
dictionary["Item_Auditory"],
formatedDescription,
DateTime.Now);
// FONTS
var pathFonts = HttpContext.Current.Request.PhysicalApplicationPath;
if (!path.EndsWith(@"\", StringComparison.OrdinalIgnoreCase))
{
pathFonts = string.Format(CultureInfo.InstalledUICulture, @"{0}\", pathFonts);
}
this.headerFont = BaseFont.CreateFont(string.Format(CultureInfo.InvariantCulture, @"{0}fonts\ARIAL.TTF", pathFonts), BaseFont.IDENTITY_H, BaseFont.EMBEDDED);
this.arial = BaseFont.CreateFont(string.Format(CultureInfo.InvariantCulture, @"{0}fonts\ARIAL.TTF", pathFonts), BaseFont.IDENTITY_H, BaseFont.EMBEDDED);
var descriptionFont = new Font(this.headerFont, 12, Font.BOLD, BaseColor.BLACK);
var document = new iTextSharp.text.Document(PageSize.A4, 40, 40, 65, 55);
var writer = PdfWriter.GetInstance(document, new FileStream(Request.PhysicalApplicationPath + "\\Temp\\" + fileName, FileMode.Create));
var pageEventHandler = new TwoColumnHeaderFooter()
{
CompanyLogo = string.Format(CultureInfo.InvariantCulture, @"{0}\images\logos\{1}.jpg", path, companyId),
IssusLogo = string.Format(CultureInfo.InvariantCulture, "{0}issus.png", path),
Date = string.Format(CultureInfo.InvariantCulture, "{0:dd/MM/yyyy}", DateTime.Now),
CreatedBy = string.Format(CultureInfo.InvariantCulture, "{0}", user.UserName),
CompanyId = auditory.CompanyId,
CompanyName = company.Name,
Title = dictionary["Item_Auditory"]
};
writer.PageEvent = pageEventHandler;
document.Open();
#region Dades bàsiques
// Ficha pincipal
var planning = AuditoryPlanning.ByAuditory(auditory.Id, auditory.CompanyId);
var table = new PdfPTable(4)
{
WidthPercentage = 100,
HorizontalAlignment = 0
};
table.SetWidths(new float[] { 30f, 50f, 30f, 50f });
table.AddCell(new PdfPCell(new Phrase(auditory.Description, descriptionFont))
{
Colspan = 4,
Border = Rectangle.NO_BORDER,
PaddingTop = 20f,
PaddingBottom = 20f,
HorizontalAlignment = Element.ALIGN_CENTER
});
table.AddCell(TitleLabel(dictionary["Item_Auditory_Label_Type"]));
table.AddCell(TitleData(dictionary["Item_Adutory_Type_Label_" + auditory.Type.ToString()]));
if (auditory.Provider.Id > 0)
{
table.AddCell(TitleLabel(dictionary["Item_Auditory_Label_Provider"]));
table.AddCell(TitleData(auditory.Provider.Description));
}
else if (auditory.Customer.Id > 0)
{
table.AddCell(TitleLabel(dictionary["Item_Auditory_Label_Customer"]));
table.AddCell(TitleData(auditory.Customer.Description));
}
else
{
table.AddCell(TitleData(string.Empty, 2));
}
table.AddCell(TitleLabel(dictionary["Item_Auditory_Label_Rules"]));
var rulesText = string.Empty;
bool firstRule = true;
foreach (var rule in auditory.Rules)
{
if (firstRule)
{
firstRule = false;
}
else
{
rulesText += ", ";
}
rulesText += rule.Description;
}
table.AddCell(TitleData(rulesText, 3));
var previewDateText = string.Empty;
if (planning != null && planning.Count > 0)
{
previewDateText = string.Format(CultureInfo.InvariantCulture, "{0:dd/MM/yyyy}", planning.OrderBy(p => p.Date).First().Date);
}
table.AddCell(TitleLabel(dictionary["Item_Auditory_Label_InternalResponsible"]));
table.AddCell(TitleData(auditory.InternalResponsible.FullName, 3));
//table.AddCell(TitleLabel(dictionary["Item_Auditory_Label_PannedDate"]));
//table.AddCell(TitleData(previewDateText));
table.AddCell(TitleLabel(dictionary["Item_Audiotry_PDF_Planned"]));
if (auditory.PlannedBy.Id > 0)
{
var planningText = string.Format(
CultureInfo.InvariantCulture,
"{0} {1} {2}",
auditory.PlannedBy.FullName,
dictionary["Item_Auditory_PDF_Label_date"],
string.Format(CultureInfo.InvariantCulture, "{0:dd/MM/yyyy}", auditory.PlannedOn) ?? "-");
table.AddCell(TitleData(planningText, 3));
}
else
{
table.AddCell(TitleData(string.Empty, 3));
}
//table.AddCell(TitleLabel(dictionary["Item_Auditory_Label_PlanningDate"]));
//table.AddCell(TitleData(string.Format(CultureInfo.InvariantCulture, "{0:dd/MM/yyyy}", auditory.PlannedOn) ?? "-"));
table.AddCell(TitleLabel(dictionary["Item_Auditory_PDF_Closing"]));
if (auditory.ClosedBy.Employee.Id > 0)
{
var closedText = string.Format(
CultureInfo.InvariantCulture,
"{0} {1} {2}",
auditory.ClosedBy.Employee.FullName,
dictionary["Item_Auditory_PDF_Label_date"],
string.Format(CultureInfo.InvariantCulture, "{0:dd/MM/yyyy}", auditory.ClosedOn) ?? "-");
table.AddCell(TitleData(closedText, 3));
}
else
{
table.AddCell(TitleData(string.Empty, 3));
}
//table.AddCell(TitleLabel(dictionary["Item_Auditory_Label_ClosedOn"]));
//table.AddCell(TitleData(string.Format(CultureInfo.InvariantCulture, "{0:dd/MM/yyyy}", auditory.ClosedOn) ?? "-"));
table.AddCell(TitleLabel(dictionary["Item_Auditory_PDF_Validation"]));
if (auditory.ValidatedBy.Id > 0)
{
var validatedText = string.Format(
CultureInfo.InvariantCulture,
"{0} {1} {2}",
auditory.ValidatedBy.FullName,
dictionary["Item_Auditory_PDF_Label_date"],
string.Format(CultureInfo.InvariantCulture, "{0:dd/MM/yyyy}", auditory.ValidatedOn) ?? "-");
table.AddCell(TitleData(validatedText, 3));
}
else
{
table.AddCell(TitleData(string.Empty, 3));
}
//table.AddCell(TitleLabel(dictionary["Item_Auditory_Label_ValidatedOn"]));
//table.AddCell(TitleData(string.Format(CultureInfo.InvariantCulture, "{0:dd/MM/yyyy}", auditory.ValidatedOn) ?? "-"));
table.AddCell(TitleLabel(dictionary["Item_Auditory_Label_Scope"]));
table.AddCell(TitleData(auditory.Scope, 3));
table.AddCell(TitleLabel(dictionary["Item_Auditory_Label_Address"]));
table.AddCell(TitleData(auditory.EnterpriseAddress, 3));
table.AddCell(TitleLabel(dictionary["Item_Auditory_Label_Notes"]));
table.AddCell(TitleData(string.IsNullOrEmpty(auditory.Notes.Trim()) ? "-" : auditory.Notes, 3));
document.Add(table);
#endregion
if (auditory.Status > 2)
{
var widthsPlanning = new float[] { 30f, 20f, 25f, 60f, 60f, 60f };
var tablePlanning = new PdfPTable(widthsPlanning.Length)
{
WidthPercentage = 100,
HorizontalAlignment = 0
};
tablePlanning.SetWidths(widthsPlanning);
tablePlanning.AddCell(new PdfPCell(new Phrase(dictionary["Item_Auditory_PlanningTable_Title"], descriptionFont))
{
Colspan = 6,
Border = Rectangle.NO_BORDER,
PaddingTop = 20f,
PaddingBottom = 20f,
HorizontalAlignment = Element.ALIGN_CENTER
});
tablePlanning.AddCell(ToolsPdf.HeaderCell(dictionary["Item_AuditoryPlanning_Header_Date"]));
tablePlanning.AddCell(ToolsPdf.HeaderCell(dictionary["Item_AuditoryPlanning_Header_Hour"]));
tablePlanning.AddCell(ToolsPdf.HeaderCell(dictionary["Item_AuditoryPlanning_Header_Duration"]));
tablePlanning.AddCell(ToolsPdf.HeaderCell(dictionary["Item_AuditoryPlanning_Header_Process"]));
tablePlanning.AddCell(ToolsPdf.HeaderCell(dictionary["Item_AuditoryPlanning_Header_Auditor"]));
tablePlanning.AddCell(ToolsPdf.HeaderCell(dictionary["Item_AuditoryPlanning_Header_Audited"]));
foreach (var pla in planning)
{
var hourText = string.Empty;
var hours = 0;
var minutes = pla.Hour;
while (minutes > 59)
{
hours++;
minutes -= 60;
}
hourText = string.Format(CultureInfo.InvariantCulture, "{0:0}:{1:00}", hours, minutes);
var auditedText = pla.ProviderName;
if (string.IsNullOrEmpty(auditedText))
{
auditedText = pla.Audited.FullName;
}
tablePlanning.AddCell(ToolsPdf.DataCellCenter(pla.Date));
tablePlanning.AddCell(ToolsPdf.DataCellCenter(hourText));
tablePlanning.AddCell(ToolsPdf.DataCellCenter(pla.Duration));
tablePlanning.AddCell(ToolsPdf.DataCell(pla.Process.Description));
tablePlanning.AddCell(ToolsPdf.DataCell(pla.Auditor.Description));
tablePlanning.AddCell(ToolsPdf.DataCell(auditedText));
}
document.Add(tablePlanning);
document.SetPageSize(PageSize.A4.Rotate());
document.NewPage();
var widthsTroballes = new float[] { 30f, 30f, 20f, 8f };
var tableTroballes = new PdfPTable(widthsTroballes.Length)
{
WidthPercentage = 100,
HorizontalAlignment = 0
};
tableTroballes.SetWidths(widthsTroballes);
tableTroballes.AddCell(new PdfPCell(new Phrase(dictionary["Item_Auditory_Title_Found"], descriptionFont))
{
Colspan = 4,
Border = Rectangle.NO_BORDER,
PaddingTop = 20f,
PaddingBottom = 20f,
HorizontalAlignment = Element.ALIGN_CENTER
});
tableTroballes.AddCell(ToolsPdf.HeaderCell(dictionary["Item_Auditory_Header_Found"]));
tableTroballes.AddCell(ToolsPdf.HeaderCell(dictionary["Item_Auditory_Header_Requirement"]));
tableTroballes.AddCell(ToolsPdf.HeaderCell(dictionary["Item_Auditory_Header_Result"]));
tableTroballes.AddCell(ToolsPdf.HeaderCell(dictionary["Item_Auditory_Header_Action"]));
var troballes = AuditoryCuestionarioFound.ByAuditory(auditory.Id, auditory.CompanyId);
foreach (var troballa in troballes)
{
tableTroballes.AddCell(ToolsPdf.DataCell(troballa.Text));
tableTroballes.AddCell(ToolsPdf.DataCell(troballa.Requeriment));
tableTroballes.AddCell(ToolsPdf.DataCell(troballa.Unconformity));
tableTroballes.AddCell(ToolsPdf.DataCell(troballa.Action ? dictionary["Common_Yes"] : dictionary["Common_No"]));
}
document.Add(tableTroballes);
var widthsMillores = new float[] { 80f, 8f };
var tableMillores = new PdfPTable(widthsMillores.Length)
{
WidthPercentage = 100,
HorizontalAlignment = 0
};
tableMillores.SetWidths(widthsMillores);
tableMillores.AddCell(new PdfPCell(new Phrase(dictionary["Item_Auditory_Title_Improvements"], descriptionFont))
{
Colspan = 4,
Border = Rectangle.NO_BORDER,
PaddingTop = 20f,
PaddingBottom = 20f,
HorizontalAlignment = Element.ALIGN_CENTER
});
tableMillores.AddCell(ToolsPdf.HeaderCell(dictionary["Item_Auditory_Header_Improvement"]));
tableMillores.AddCell(ToolsPdf.HeaderCell(dictionary["Item_Auditory_Header_Action"]));
var millores = AuditoryCuestionarioImprovement.ByAuditory(auditory.Id, auditory.CompanyId);
foreach (var millora in millores)
{
tableMillores.AddCell(ToolsPdf.DataCell(millora.Text));
tableMillores.AddCell(ToolsPdf.DataCell(millora.Action ? dictionary["Common_Yes"] : dictionary["Common_No"]));
}
document.Add(tableMillores);
if (!string.IsNullOrEmpty(auditory.PuntosFuertes.Trim()))
{
document.Add(new Phrase(Environment.NewLine));
document.Add(new Phrase(dictionary["Item_Auditory_Label_PuntosFuertes"], new Font(this.arial, 10, Font.BOLD, BaseColor.BLACK)));
document.Add(new Phrase(Environment.NewLine));
document.Add(new Phrase(auditory.PuntosFuertes));
}
var actions = IncidentAction.ByAuditoryId(auditory.Id, auditory.CompanyId);
if (actions != null && actions.Count > 0)
{
document.SetPageSize(PageSize.A4.Rotate());
document.NewPage();
var widthsActions = new float[] { 8f, 80f };
var tableActions = new PdfPTable(widthsActions.Length)
{
WidthPercentage = 100,
HorizontalAlignment = 0
};
tableActions.SetWidths(widthsActions);
tableActions.AddCell(new PdfPCell(new Phrase(dictionary["Item_IncidentActions"], descriptionFont))
{
Colspan = 4,
Border = Rectangle.NO_BORDER,
PaddingTop = 20f,
PaddingBottom = 20f,
HorizontalAlignment = Element.ALIGN_CENTER
});
tableActions.AddCell(ToolsPdf.HeaderCell(dictionary["Item_IncidentAction_Header_Type"]));
tableActions.AddCell(ToolsPdf.HeaderCell(dictionary["Item_IncidentAction_Header_Description"]));
foreach (var action in actions)
{
string actionTypeText = string.Empty;
switch (action.ActionType)
{
default:
case 1: actionTypeText = dictionary["Item_IncidentAction_Type1"]; break;
case 2: actionTypeText = dictionary["Item_IncidentAction_Type2"]; break;
case 3: actionTypeText = dictionary["Item_IncidentAction_Type3"]; break;
}
tableActions.AddCell(ToolsPdf.DataCell(actionTypeText));
tableActions.AddCell(ToolsPdf.DataCell(action.Description));
}
document.Add(tableActions);
}
}
document.Close();
Response.ClearContent();
Response.ClearHeaders();
Response.AddHeader("Content-Disposition", "inline;filename=outfile.pdf");
Response.ContentType = "application/pdf";
Response.WriteFile(Request.PhysicalApplicationPath + "\\Temp\\" + fileName);
Response.Flush();
Response.Clear();
}
public ActionResult FoundDelete(long id, int companyId, int applicationUserId)
{
return(AuditoryCuestionarioFound.Inactivate(id, companyId, applicationUserId));
}
