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; }