private void LoadTemplate_Linq(TemplateLinq template)
{
try
{
dataGridView2.Rows.Clear();
dataGridView2.ReadOnly = true;
if (template == null)
{
return;
}
dataTableLoadTemplateFirma = FirmaInCloudDB.LoadTemplateFirmati(template);
//dataGridView2.Columns[2].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
int n = 0;
foreach (DataRow item in dataTableLoadTemplateFirma.Rows)
{
n = dataGridView2.Rows.Add();
dataGridView2.Rows[n].Cells[0].Value = item[0].ToString();
dataGridView2.Rows[n].Cells[1].Value = item[1].ToString();
dataGridView2.Rows[n].Cells[2].Value = DateTime.ParseExact(item[2].ToString(), "yyyyMMddHHmm", CultureInfo.InvariantCulture).ToString("dd/MM/yyyy HH:mm", CultureInfo.InvariantCulture);;
dataGridView2.Rows[n].Cells[2].Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
dataGridView2.Rows[n].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
}
}
catch (Exception ex)
{
throw;
}
}
private void btnFirma_Click(object sender, EventArgs e)
{
if (this.isModified)
{
if (DialogResult.No == MessageBox.Show("Per proseguire รจ necessario salvare i dati inseriti. Vuoi proseguire ?", "Firma documento", MessageBoxButtons.YesNo, MessageBoxIcon.Question))
{
return;
}
if (!ValidateControls())
{
return;
}
Save();
}
//if (DialogResult.No == MessageBox.Show("Selezionare una directory in cui salvare il documento." + Environment.NewLine + "Vuoi proseguire ?", "Firma documento", MessageBoxButtons.YesNo, MessageBoxIcon.Question))
// return;
//SaveFileDialog dlg = new SaveFileDialog
//{
// Title = "Salvataggio Pdf",
// AddExtension = true,
// Filter = "PDF|*.pdf"
//};
//if (dlg.ShowDialog() != DialogResult.OK)
// return;
//if (string.IsNullOrEmpty(dlg.FileName))
// return;
if (cmbTemplate.SelectedIndex == 0)
{
MessageBox.Show("E' necessario selezionare un template valido !", "Firma documento", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
this.isModified = false;
return;
}
string strFileNameOutput = $"{FileHelper.GetPath("pdfElab")}{user.COGNOME}" + " " + $"{user.NOME}" + " " + $"{DateTime.Today:yyyyMMdd}" + ".pdf";
string strFileName = PDFManager.RunSignPro(strFileNameOutput, cmbTemplate.SelectedIndex, user);
if (string.IsNullOrEmpty(strFileName))
{
return;
}
var pathString = FirmaInCloudDB.LoadTemplate(cmbTemplate.SelectedIndex, "").AsEnumerable().First();
FileNameParser fileNameParser = new FileNameParser(strFileName);
TemplateLinq templateLinq = new TemplateLinq
{
KEY_USER = user.KEY_USER,
DTSIGN = DateTime.Now,
PATH = strFileName,
DESCR = fileNameParser.DESCR,
KEY_TEMPL = Convert.ToInt32(pathString.ItemArray[0])
};
FirmaInCloudDB.SaveTemplate_Linq(templateLinq, user);
ConfigDB.SaveConfig(Config.ParamValues.COUNT, (int.Parse(ConfigDB.LoadConfig(Config.ParamValues.COUNT).CONF_VALUE) + 1).ToString());
LoadTemplate_Linq(templateLinq);
if (DialogResult.No == MessageBox.Show("E' possibile inviare il documento appena firmato all'indirizzo mail: " + user.MAIL + Environment.NewLine + "Vuoi proseguire ?", "Firma documento", MessageBoxButtons.YesNo, MessageBoxIcon.Question))
{
return;
}
Mail.SendMail(strFileName, txtMail.Text, user.NOME + " " + user.COGNOME, "");
}
private void LoadData(int?intKeyUte)
{
user = UsersDB.LoadUser(intKeyUte).First();
if (user == null)
{
return;
}
txtNome.Text = user.NOME;
txtCognome.Text = user.COGNOME;
cmbSst.SelectedItem = user.SST;
txtStrada.Text = user.STRADA;
dateTimePicker1.Value = user.DTNAS;
if (user.KEY_NAZ != null)
{
cmbNaz.SelectedValue = user.KEY_NAZ;
}
if (user.KEY_REG != null)
{
cmbReg.SelectedValue = user.KEY_REG;
}
if (user.KEY_PRO != null)
{
cmbProv.SelectedValue = user.KEY_PRO;
}
if (user.KEY_COM != null)
{
cmbCom.SelectedValue = user.KEY_COM;
}
if (user.KEY_LOC != null)
{
cmbLoc.SelectedValue = user.KEY_LOC;
}
if (user.TYP_UTE != null)
{
cmbTYP_UTE.SelectedIndex = int.Parse(user.TYP_UTE);
}
if (user.SEX != null)
{
cmbSEX.SelectedValue = user.SEX;
}
txtCF.Text = user.COD_FIS;
txtPiva.Text = user.P_IVA;
txtNcn.Text = user.NCN;
txtCell.Text = user.CELL;
txtTel.Text = user.TEL;
txtMail.Text = user.MAIL;
if ((cmbTemplate.SelectedIndex != -1) && (cmbTemplate.SelectedItem != null) && (cmbTemplate.Items.Count > 1))
{
cmbTemplate.SelectedIndex = user.KEY_TEMPL;
}
if (user.KEY_NAZ_NAS != null)
{
cmbNazNas.SelectedValue = user.KEY_NAZ_NAS;
}
if (user.KEY_REG_NAS != null)
{
cmbRegNas.SelectedValue = user.KEY_REG_NAS;
}
if (user.KEY_PRO_NAS != null)
{
cmbProvNas.SelectedValue = user.KEY_PRO_NAS;
}
if (user.KEY_COM_NAS != null)
{
cmbComNas.SelectedValue = user.KEY_COM_NAS;
}
if (user.KEY_LOC_NAS != null)
{
cmbLocNas.SelectedValue = user.KEY_LOC_NAS;
}
if (user.KEY_DOC.HasValue)
{
intKeyDoc = user.KEY_DOC;
}
document = DocumentDB.LoadDocument(user.KEY_DOC);
if (document != null)
{
if (document.TYP_DOC.HasValue)
{
cmbTyp_DOC.SelectedIndex = document.TYP_DOC.GetValueOrDefault();
}
txtIdDoc.Text = document.ID_DOC;
if (DateTime.MinValue < document.ISS_DOC && document.ISS_DOC < DateTime.MaxValue)
{
dtmPickDocument.Value = document.ISS_DOC;
}
txtCityDoc.Text = document.CITY_DOC;
txtNumber.Text = document.NUM_DOC;
}
TemplateLinq template = new TemplateLinq();
template.KEY_USER = user.KEY_USER;
template.KEY_TEMPL_L = user.KEY_TEMPL;
LoadTemplate_Linq(template);
bFreeze = false;
}
