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 Update(Auditory auditory, bool toPlanned, string rules, Auditory oldAuditory, int applicationUserId)
{
foreach (var ruleId in rules.Split('|'))
{
if (!string.IsNullOrEmpty(ruleId))
{
auditory.AddRule(Convert.ToInt64(ruleId));
}
}
string differences = auditory.Differences(oldAuditory);
var res = auditory.Update(applicationUserId, auditory.CompanyId, differences);
// Cuando pasa a planificada hay que generar los cuestionarios y enviar los mails
if (res.Success && toPlanned && auditory.Type != 1)
{
// Generar custionarios
var resPlanned = Auditory.SetQuestionaries(auditory.Id, applicationUserId);
if (!resPlanned.Success)
{
res.SetFail(resPlanned.MessageError);
}
// enviar mails
var planning = AuditoryPlanning.ByAuditory(auditory.Id, auditory.CompanyId);
if (auditory.Type == 2)
{
foreach (var pl in planning.Where(p => p.SendMail == true))
{
res = SendPanningMail(pl, auditory.Description);
}
}
}
if (!res.Success)
{
return(res);
}
var setReportStart = false;
/*if (auditory.Type == 1 && auditory.ReportStart != null)
* {
* setReportStart = true;
* }
*
* if(auditory.Status == 1 && auditory.ReportStart != null)
* {
* setReportStart = true;
* }*/
if (setReportStart)
{
/* CREATE PROCEDURE [dbo].[Auditory_SetReportStart]
* @AuditoryId bigint,
* @CompanyId int,
* @ReportStart datetime */
using (var cmd = new SqlCommand("Auditory_SetReportStart"))
{
using (var cnn = new SqlConnection(ConfigurationManager.ConnectionStrings["cns"].ConnectionString))
{
cmd.Connection = cnn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(DataParameter.Input("@AuditoryId", auditory.Id));
cmd.Parameters.Add(DataParameter.Input("@CompanyId", auditory.CompanyId));
cmd.Parameters.Add(DataParameter.Input("@ReportStart", auditory.ReportStart));
try
{
cmd.Connection.Open();
cmd.ExecuteNonQuery();
}
finally
{
if (cmd.Connection.State != ConnectionState.Closed)
{
cmd.Connection.Close();
}
}
}
}
}
return(res);
}
private ActionResult SendPanningMail(AuditoryPlanning planning, string auditoryName)
{
var res = ActionResult.NoAction;
var dictionary = ApplicationDictionary.Load("ca");
string path = HttpContext.Current.Request.PhysicalApplicationPath;
string destino = path;
if (!path.EndsWith("\\", StringComparison.Ordinal))
{
path = string.Format(CultureInfo.InvariantCulture, @"{0}\images\noimage.jpg", path);
}
else
{
path = string.Format(CultureInfo.InvariantCulture, @"{0}\images\noimage.jpg", path);
}
if (!destino.EndsWith("\\", StringComparison.Ordinal))
{
destino = string.Format(CultureInfo.InvariantCulture, @"{0}\images\Logos\{1}.jpg", destino, res.MessageError.Split('|')[0]);
}
else
{
destino = string.Format(CultureInfo.InvariantCulture, @"{0}\images\Logos\{1}.jpg", destino, res.MessageError.Split('|')[0]);
}
//System.IO.File.Copy(path, destino);
path = HttpContext.Current.Request.PhysicalApplicationPath;
if (!path.EndsWith(@"\", StringComparison.OrdinalIgnoreCase))
{
path = string.Format(CultureInfo.InvariantCulture, @"{0}\", path);
}
var templateName = "InvitationAuditProv.tpl";
var user = Session["User"] as ApplicationUser;
if (!string.IsNullOrEmpty(user.Language))
{
templateName = "InvitationAuditProv_" + user.Language + ".tpl";
}
path = string.Format(CultureInfo.InvariantCulture, @"{0}Templates\{1}", path, templateName);
string bodyPattern = string.Empty;
using (var rdr = new StreamReader(path))
{
bodyPattern = rdr.ReadToEnd();
bodyPattern = bodyPattern.Replace("#AUDITAT#", "{0}");
bodyPattern = bodyPattern.Replace("#EMPRESA#", "{1}");
bodyPattern = bodyPattern.Replace("#AUDIT#", "{2}");
bodyPattern = bodyPattern.Replace("#PLANIFICADA#", "{3:dd/MM/yyyy}");
bodyPattern = bodyPattern.Replace("#HORA#", "{4}");
bodyPattern = bodyPattern.Replace("#DURADA#", "{5}");
}
var company = HttpContext.Current.Session["company"] as Company;
var hora = planning.Hour;
var horarioText = string.Empty;
var horas = 0;
while (hora > 59)
{
hora -= 60;
horas++;
}
horarioText = string.Format(CultureInfo.InvariantCulture, "{0:#0}:{1:00}", horas, hora);
string subject = string.Format(dictionary["Mail_Message_InivitationAuditProv"], res.MessageError.Split('|')[0]);
string body = string.Format(
CultureInfo.InvariantCulture,
bodyPattern,
planning.ProviderName,
company.Name,
auditoryName,
planning.Date,
horarioText,
planning.Duration);
var mail = new MailMessage
{
From = new MailAddress("*****@*****.**", "ISSUS"),
IsBodyHtml = true,
Subject = subject,
Body = body
};
mail.To.Add(planning.ProviderEmail);
//mail.To.Add("*****@*****.**");
mail.Bcc.Add("*****@*****.**");
try
{
var key = Tools.DecryptString(ConfigurationManager.AppSettings["mailpass"] as string);
if (key.StartsWith("Error::", StringComparison.OrdinalIgnoreCase))
{
res.SetFail(key);
}
else
{
var smtpServer = new SmtpClient("smtp.scrambotika.com")
{
Port = 587,
Credentials = new System.Net.NetworkCredential("*****@*****.**", key)
};
smtpServer.Send(mail);
}
}
catch (Exception ex)
{
res.SetFail(HttpContext.Current.Request.Url.Host + " ::> " + ex.Message);
}
return(res);
}
public ActionResult PlanningDelete(long planningId, int companyId, int applicationUserId)
{
return(AuditoryPlanning.Inactivate(planningId, companyId, applicationUserId));
}
public ActionResult PlanningUpdate(AuditoryPlanning planning, int applicationUserId)
{
return(planning.Update(applicationUserId));
}
public ActionResult PlanningInsert(AuditoryPlanning planning, int applicationUserId)
{
return(planning.Insert(applicationUserId));
}
