internal void Save()
{
if (user == null)
{
user = new Users();
}
else
{
user.KEY_USER = intKeyUtenze.GetValueOrDefault();
}
user.NOME = txtNome.Text;
user.COGNOME = txtCognome.Text;
user.DTINS = DateTime.Now;
user.DTNAS = dateTimePicker1.Value.Date;
if (cmbSst.SelectedItem != null)
{
if (!string.IsNullOrEmpty(cmbSst.SelectedItem.ToString()))
{
user.SST = cmbSst.SelectedItem.ToString();
}
}
user.STRADA = txtStrada.Text;
user.TYP_UTE = (cmbTYP_UTE.SelectedIndex).ToString();
user.COD_FIS = txtCF.Text;
user.P_IVA = txtPiva.Text;
user.NCN = txtNcn.Text;
user.CELL = txtCell.Text;
user.TEL = txtTel.Text;
user.MAIL = txtMail.Text;
if (cmbNaz.SelectedItem != null)
{
user.KEY_NAZ = Convert.ToInt32(((DataRowView)cmbNaz.SelectedItem).Row.ItemArray[0]);
}
if (cmbReg.SelectedItem != null)
{
user.KEY_REG = Convert.ToInt32(((DataRowView)cmbReg.SelectedItem).Row.ItemArray[0]);
}
if (cmbProv.SelectedItem != null)
{
user.KEY_PRO = Convert.ToInt32(((DataRowView)cmbProv.SelectedItem).Row.ItemArray[0]);
}
if (cmbCom.SelectedItem != null)
{
user.KEY_COM = Convert.ToInt32(((DataRowView)cmbCom.SelectedItem).Row.ItemArray[0]);
}
if (cmbLoc.SelectedItem != null)
{
user.KEY_LOC = Convert.ToInt32(((DataRowView)cmbLoc.SelectedItem).Row.ItemArray[0]);
}
if (cmbNazNas.SelectedItem != null)
{
user.KEY_NAZ_NAS = Convert.ToInt32(((DataRowView)cmbNazNas.SelectedItem).Row.ItemArray[0]);
}
if (cmbRegNas.SelectedItem != null)
{
user.KEY_REG_NAS = Convert.ToInt32(((DataRowView)cmbRegNas.SelectedItem).Row.ItemArray[0]);
}
if (cmbProvNas.SelectedItem != null)
{
user.KEY_PRO_NAS = Convert.ToInt32(((DataRowView)cmbProvNas.SelectedItem).Row.ItemArray[0]);
}
if (cmbComNas.SelectedItem != null)
{
user.KEY_COM_NAS = Convert.ToInt32(((DataRowView)cmbComNas.SelectedItem).Row.ItemArray[0]);
}
if (cmbLocNas.SelectedItem != null)
{
user.KEY_LOC_NAS = Convert.ToInt32(((DataRowView)cmbLocNas.SelectedItem).Row.ItemArray[0]);
}
if (cmbSEX.SelectedItem != null)
{
user.SEX = ((KeyValuePair <string, string>)cmbSEX.SelectedItem).Key;
}
user.KEY_TEMPL = cmbTemplate.SelectedIndex;
if (document == null)
{
document = new Document();
}
else
{
document.KEY_DOC = intKeyDoc.GetValueOrDefault();
}
document.TYP_DOC = cmbTyp_DOC.SelectedIndex;
document.NUM_DOC = txtNumber.Text;
if (DateTime.MinValue < dtmPickDocument.Value.Date && dtmPickDocument.Value.Date < DateTime.MaxValue)
{
document.ISS_DOC = dtmPickDocument.Value.Date;
}
document.CITY_DOC = txtCityDoc.Text;
document.ID_DOC = txtIdDoc.Text;
try
{
if (!GestioneMySql.OpenConnection())
{
throw new Exception("Errore nell'apertura della connessione.");
}
DocumentDB.SaveDocument(document);
user.KEY_DOC = document.KEY_DOC;
UsersDB.SaveUser(user);
if (!GestioneMySql.CloseConnection())
{
throw new Exception("Errore nella chiusura della connessione.");
}
}
catch (Exception ex)
{
GestioneMySql.CloseConnection();
MessageBox.Show("Errore: " + ex.Message);
}
intKeyUtenze = user.KEY_USER;
}
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;
}
