static void Main(string[] args)
{
try
{
//Initialization
DocumentDB documentDB = new DocumentDB
{
AuthorizationKey = "h6H3BgbraykUTr2yP3UEzgqXRqkaiixaliJI9UFgGEOU5JazdciFehayZgrJERwXQHwHOknVaH6FGygXBNVCeA==",
EndpointUrl = "https://abasu1.documents.azure.com:443/"
};
DocumentClient client = new DocumentClient(new Uri(documentDB.EndpointUrl), documentDB.AuthorizationKey);
DocumentDBOperations dbOperations = new DocumentDBOperations(documentDB.EndpointUrl, documentDB.AuthorizationKey, client);
Program p = new Program();
//p.CreateDB(dbOperations).Wait();
p.CreateCollections(dbOperations).Wait();
p.CreateDocuments(dbOperations).Wait();
}
catch (DocumentClientException de)
{
Exception baseException = de.GetBaseException();
Console.WriteLine("{0} error occurred: {1}, Message: {2}", de.StatusCode, de.Message, baseException.Message);
}
catch (Exception e)
{
Exception baseException = e.GetBaseException();
Console.WriteLine("Error: {0}, Message: {1}", e.Message, baseException.Message);
}
finally
{
Console.WriteLine("End of demo, press any key to exit.");
Console.ReadKey();
}
}
public RevitFamily Find(int id)
{
if (!this.Items.ContainsKey(id))
{
this.Items[id] = DocumentDB.GetElementById(id);
}
return(this.Items[id]);
}
private void initVariables()
{
clearData();
docID = Main.currentDocument;
pnlUI.Controls.Add(pnlList);
DocumentDB.fillDocumentIDCumbo(cmbSelectDocument);
btnNew.Visible = false;
disableButtons();
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
document doc = new document();
DocumentDB docDB = new DocumentDB();
doc.DocumentID = txtDocumentID.Text;
doc.DocumentName = txtDocumentName.Text;
doc.TableName = txtTableName.Text;
doc.IsReversible = docDB.getYesNoCode(cmbIsReversible.SelectedItem.ToString());
doc.DocumentStatus = docDB.getDocumentStatusCode(cmbDocumentStatus.SelectedItem.ToString());
System.Windows.Forms.Button btn = sender as System.Windows.Forms.Button;
string btnText = btn.Text;
{
if (btnText.Equals("Update"))
{
if (docDB.updateDocument(doc))
{
MessageBox.Show("Document Status updated");
closeAllPanels();
ListDocument();
}
else
{
MessageBox.Show("Failed to update Document Status");
}
}
else if (btnText.Equals("Save"))
{
if (docDB.validateDocument(doc))
{
if (docDB.insertDocument(doc))
{
MessageBox.Show("Document data Added");
closeAllPanels();
ListDocument();
}
else
{
MessageBox.Show("Failed to Insert Document");
}
}
else
{
MessageBox.Show("Document Data Validation failed");
}
}
}
}
catch (Exception)
{
MessageBox.Show("Failed Adding / Editing User Data");
}
}
private static async Task EnsureClientIsConnected()
{
if (client == null)
{
var connectionString = WebConfigurationManager.AppSettings["connectionString"];
var databaseName = WebConfigurationManager.AppSettings["databaseName"];
var collectionName = WebConfigurationManager.AppSettings["collectionName"];
collectionLink = string.Format("dbs/{0}/colls/{1}", databaseName, collectionName);
documentLinkFormat = collectionLink + "/docs/{0}";
client = await DocumentDB.GetDocumentClient(connectionString, databaseName, collectionName);
}
}
/// <summary>
/// The DeleteBtn_Click event handler on this Page is used to delete an
/// a document. It uses the Rainbow.DocumentsDB()
/// data component to encapsulate all data functionality.
/// </summary>
/// <param name="e">The <see cref="T:System.EventArgs"/> instance containing the event data.</param>
protected override void OnDelete(EventArgs e)
{
base.OnDelete(e);
// Only attempt to delete the item if it is an existing item
// (new items will have "ItemID" of 0)
//TODO: Ask confim before delete
if (ItemID != 0)
{
DocumentDB documents = new DocumentDB();
documents.DeleteDocument(ItemID, Server.MapPath(PathField.Text));
}
RedirectBackToReferringPage();
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
document doc = new document();
DocumentDB docDB = new DocumentDB();
System.Windows.Forms.Button btn = sender as System.Windows.Forms.Button;
string btnText = btn.Text;
{
if (btnText.Equals("Update"))
{
if (docDB.updateDocument(doc))
{
MessageBox.Show("Document Status updated");
closeAllPanels();
//ListDocument();
}
else
{
MessageBox.Show("Failed to update Document Status");
}
}
else if (btnText.Equals("Save"))
{
if (docDB.validateDocument(doc))
{
if (docDB.insertDocument(doc))
{
MessageBox.Show("Document data Added");
closeAllPanels();
//ListDocument();
}
else
{
MessageBox.Show("Failed to Insert Document");
}
}
else
{
MessageBox.Show("Document Data Validation failed");
}
}
}
}
catch (Exception)
{
MessageBox.Show("Failed Adding / Editing User Data");
}
}
/// <summary>
/// The Page_Load event handler on this Page is used to
/// obtain obtain the contents of a document from the
/// Documents table, construct an HTTP Response of the
/// correct type for the document, and then stream the
/// document contents to the response. It uses the
/// Rainbow.DocumentDB() data component to encapsulate
/// the data access functionality.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="T:System.EventArgs"/> instance containing the event data.</param>
private void Page_Load(object sender, EventArgs e)
{
if (ItemID != -1)
{
// Obtain Document Data from Documents table
DocumentDB documents = new DocumentDB();
// Change by [email protected]
// Date: 7/2/2003
WorkFlowVersion version = Request.QueryString["wversion"] == "Staging"
? WorkFlowVersion.Staging
: WorkFlowVersion.Production;
// End Change [email protected]
// Change by [email protected]
// Date: 7/2/2003
// Original:
// SqlDataReader dBContent = documents.GetDocumentContent(ItemID);
SqlDataReader dBContent = documents.GetDocumentContent(ItemID, version);
// End Change [email protected]
try
{
dBContent.Read();
// Serve up the file by name
// [email protected]. FIX: FileName does not exist
// Response.AppendHeader("content-disposition", "filename=" + (string)dBContent["FileName"]);
Response.AppendHeader("content-disposition", "filename=" + (string)dBContent["FileNameUrl"]);
// set the content type for the Response to that of the
// document to display. For example. "application/msword"
// Change for translate extension-files to exact contentType
// Response.ContentType = (string) dBContent["ContentType"];
Response.ContentType = giveMeContentType((string)dBContent["ContentType"]);
// output the actual document contents to the response output stream
Response.OutputStream.Write((byte[])dBContent["Content"], 0, (int)dBContent["ContentSize"]);
}
finally
{
dBContent.Close(); //by Manu, fixed bug 807858
}
// end the response
Response.End();
}
}
public void CanRetrieveNullCollectionProperty()
{
/* todo: The service can return a null collection, but apparently the client needs that feature added as well
* I suppose it's not that big a deal though, since you have control over the object at this point
* var create = House.CreateHouse(Guid.NewGuid().ToString("D"));
* create.TestWindows = null;
* client.AddToHouses(create);
* client.SaveChanges();
* client.Detach(create);*/
// because of the above bug, we must create the document directly, but this is the more important path anyway
var connectionString = ConfigurationManager.AppSettings["connectionString"];
var databaseName = ConfigurationManager.AppSettings["databaseName"];
var collectionName = ConfigurationManager.AppSettings["collectionName"];
var collectionLink = string.Format("dbs/{0}/colls/{1}", databaseName, collectionName);
var documentLinkFormat = collectionLink + "/docs/{0}";
var task = DocumentDB.GetDocumentClient(connectionString, databaseName, collectionName);
task.Wait();
var docClient = task.Result;
// make test document
HouseDocument houseDocument = new HouseDocument();
houseDocument.Id = Guid.NewGuid().ToString("D");
houseDocument.TestWindows = null;
// insert it directly to DocumentDB
DocumentDbExtensions.ExecuteResultWithRetry(() =>
docClient.UpsertDocumentAsync(collectionLink, houseDocument));
// retrieve it directly from DocumentDB
var retrievedDocument = DocumentDbExtensions.ExecuteQueryWithContinuationAndRetry(
docClient.CreateDocumentQuery <HouseDocument>(collectionLink)
.Where(x => x.Id == houseDocument.Id))
.Single();
// is the test set up properly?
Assert.IsNull(retrievedDocument.TestWindows);
// finally, test retrieval through OData
var house = odataClient.Houses.ByKey(houseDocument.Id).GetValue();
Assert.IsNotNull(house);
// note: house.TestWindows will actually be deserialized as an empty collection here, but the test is
// that the OData service didn't throw an error when encountering that in the source document
}
/// <summary>
/// The Page_Load event on this Page is used to obtain the ModuleID
/// and ItemID of the document to edit.
/// It then uses the DocumentDB() data component
/// to populate the page's edit controls with the document details.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="T:System.EventArgs"/> instance containing the event data.</param>
private void Page_Load(object sender, EventArgs e)
{
// If the page is being requested the first time, determine if an
// document itemID value is specified, and if so populate page
// contents with the document details
if (!Page.IsPostBack)
{
if (ModuleID > 0)
{
PathToSave = ((SettingItem)moduleSettings["DocumentPath"]).FullPath;
}
if (ItemID > 0)
{
// Obtain a single row of document information
DocumentDB documents = new DocumentDB();
SqlDataReader dr = documents.GetSingleDocument(ItemID, WorkFlowVersion.Staging);
try
{
// Load first row into Datareader
if (dr.Read())
{
NameField.Text = (string)dr["FileFriendlyName"];
PathField.Text = (string)dr["FileNameUrl"];
CategoryField.Text = (string)dr["Category"];
CreatedBy.Text = (string)dr["CreatedByUser"];
CreatedDate.Text = ((DateTime)dr["CreatedDate"]).ToShortDateString();
// 15/7/2004 added localization by Mario Endara [email protected]
if (CreatedBy.Text == "unknown")
{
CreatedBy.Text = General.GetString("UNKNOWN", "unknown");
}
}
}
finally
{
dr.Close();
}
}
}
}
private void ListDocument()
{
try
{
grdList.Rows.Clear();
DocumentDB dbrecord = new DocumentDB();
List <document> Documents = dbrecord.getDocuments();
foreach (document doc in Documents)
{
grdList.Rows.Add(doc.DocumentID, doc.DocumentName, doc.TableName,
dbrecord.getYesNo(doc.IsReversible),
dbrecord.getDocumentStatusString(doc.DocumentStatus));
//dbrecord.getEmpStatusString(emp.empStatus), emp.empPhoto);
}
}
catch (Exception ex)
{
MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error");
}
enableBottomButtons();
pnlDocumentList.Visible = true;
}
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;
}
/// <summary>
/// Called during startup by each shared project
/// </summary>
public static void Initialize(string environment)
{
//Initialize all static settings classes based on current environment
//See "instructions.txt" for details on the configurations to use per environment.
//Host application must pass in the current environment name to initialize settings
Environment.Current = environment;
//---------------------------------------------------------------------
//URLs & Email Addresses are initialized first as they are used in copy within other settings
// Endpoint Settings ---------------
URLs.Initialize();
Emails.Initialize();
//---------------------------------------------------------------------
// Remaining settings are then initialized...
// AZURE Services -----------------
Databases.Initialize();
DocumentDB.Initialize();
Redis.Initialize();
Storage.Initialize();
Search.Initialize();
// EXTERNAL Services ---------------
Stripe.Initialize();
SendGrid.Initialize();
MailChimp.Initialize();
GoogleMaps.Initialize();
CloudFlare.Initialize();
Registration.Initialize();
GarbageCollection.Initialize();
Custodian.Initialize();
Worker.Initialize();
Partitioning.Initialize();
Payments.Initialize();
// Platform Settings ---------------
Application.Initialize();
Platform.Users.Initialize();
Accounts.Users.Initialize();
Commerce.Credits.Initialize();
//Copy Settings ---------------
EmailMessages.Initialize();
NotificationMessages.Initialize();
PlatformMessages.Initialize();
//Image Settings ------------
Imaging.Images.Initialize();
// Flush ALL Redis caches when we initialize CoreServices
// This allows new updates to be forced into cached objects
var redisEndpoints = Sahara.Core.Settings.Azure.Redis.RedisMultiplexers.RedisMultiplexer.GetEndPoints(true);
var redisserver = Sahara.Core.Settings.Azure.Redis.RedisMultiplexers.RedisMultiplexer.GetServer(redisEndpoints[0]);
try
{
redisserver.FlushAllDatabases();
}
catch (Exception e)
{
string exception = e.Message;
}
/*
* // Flush ALL Redis caches when we initialize CoreServices
* // This allows new updates to be forced into cached objects
* var accountsRedisEndpoints = Sahara.Core.Settings.Azure.Redis.RedisMultiplexers.AccountManager_Multiplexer.GetEndPoints(true);
* var accountRedisserver = Sahara.Core.Settings.Azure.Redis.RedisMultiplexers.AccountManager_Multiplexer.GetServer(accountsRedisEndpoints[0]);
* accountRedisserver.FlushAllDatabases();
*
* var platformRedisEndpoints = Sahara.Core.Settings.Azure.Redis.RedisMultiplexers.PlatformManager_Multiplexer.GetEndPoints(true);
* var platformRedisserver = Sahara.Core.Settings.Azure.Redis.RedisMultiplexers.PlatformManager_Multiplexer.GetServer(platformRedisEndpoints[0]);
* platformRedisserver.FlushAllDatabases();
*/
}
protected override void OnUpdate(EventArgs e)
{
base.OnUpdate(e);
byte[] buffer = new byte[0];
int size = 0;
// Only Update if Input Data is Valid
if (Page.IsValid)
{
// Create an instance of the Document DB component
DocumentDB documents = new DocumentDB();
// Determine whether a file was uploaded
if (FileUpload.PostedFile.FileName != string.Empty)
{
FileInfo fInfo = new FileInfo(FileUpload.PostedFile.FileName);
if (bool.Parse(moduleSettings["DOCUMENTS_DBSAVE"].ToString()))
{
Stream stream = FileUpload.PostedFile.InputStream;
buffer = new byte[FileUpload.PostedFile.ContentLength];
size = FileUpload.PostedFile.ContentLength;
try
{
stream.Read(buffer, 0, size);
PathField.Text = fInfo.Name;
}
finally
{
stream.Close(); //by manu
}
}
else
{
PathToSave = ((SettingItem)moduleSettings["DocumentPath"]).FullPath;
// [email protected] (02/07/2004). Create the Directory if not exists.
if (!Directory.Exists(Server.MapPath(PathToSave)))
{
Directory.CreateDirectory(Server.MapPath(PathToSave));
}
string virtualPath = Path.WebPathCombine(PathToSave, fInfo.Name);
string physicalPath = Server.MapPath(virtualPath);
// while(System.IO.File.Exists(physicalPath))
// {
// // Calculate virtualPath of the newly uploaded file
// virtualPath = Rainbow.Framework.Settings.Path.WebPathCombine(PathToSave, Guid.NewGuid().ToString() + fInfo.Extension);
//
// // Calculate physical path of the newly uploaded file
// phyiscalPath = Server.MapPath(virtualPath);
// }
while (File.Exists(physicalPath))
{
try
{
// Delete file before upload
File.Delete(physicalPath);
}
catch (Exception ex)
{
Message.Text =
General.GetString("ERROR_FILE_DELETE", "Error while deleting file!<br>") +
ex.Message;
return;
}
}
try
{
// Save file to uploads directory
FileUpload.PostedFile.SaveAs(physicalPath);
// Update PathFile with uploaded virtual file location
PathField.Text = virtualPath;
}
catch (Exception ex)
{
Message.Text = General.GetString("ERROR_FILE_NAME", "Invalid file name!<br>") + ex.Message;
return;
}
}
}
// Change for save contenType and document buffer
// documents.UpdateDocument(ModuleID, ItemID, PortalSettings.CurrentUser.Identity.Email, NameField.Text, PathField.Text, CategoryField.Text, new byte[0], 0, string.Empty );
string contentType = PathField.Text.Substring(PathField.Text.LastIndexOf(".") + 1).ToLower();
documents.UpdateDocument(ModuleID, ItemID, PortalSettings.CurrentUser.Identity.Email, NameField.Text,
PathField.Text, CategoryField.Text, buffer, size, contentType);
RedirectBackToReferringPage();
}
}
public data()
{
InitializeComponent();
documentDB = new DocumentDB(dbName: Config.CurrentConfig.DocumentsDBName, ip: Config.CurrentConfig.DocumentsDBIp);
}
/// <summary>
/// The Page_Load event handler on this User Control is used to
/// obtain a SqlDataReader of document information from the
/// Documents table, and then databind the results to a DataGrid
/// server control. It uses the Rainbow.DocumentDB()
/// data component to encapsulate all data functionality.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="T:System.EventArgs"/> instance containing the event data.</param>
private void Page_Load(object sender, EventArgs e)
{
LoadAvailableImageList();
if (!Page.IsPostBack)
{
string sortFieldOption = Settings["DOCUMENTS_SORTBY_FIELD"].ToString();
string sortDirectionOption = Settings["DOCUMENTS_SORTBY_DIRECTION"].ToString();
if (sortFieldOption.Length > 0)
{
if (General.GetString("DOCUMENTS_SORTBY_FIELD_LIST", "File Name;Created Date").IndexOf(sortFieldOption) > 0)
{
sortField = "CreatedDate";
}
else
{
sortField = "FileFriendlyName";
}
if (General.GetString("DOCUMENTS_SORTBY_DIRECTION_LIST", "Ascending;Descending").IndexOf(sortDirectionOption) > 0)
{
sortDirection = "DESC";
}
else
{
sortDirection = "ASC";
}
}
else
{
sortField = "FileFriendlyName";
sortDirection = "ASC";
if (sortField == "DueDate")
{
sortDirection = "DESC";
}
}
ViewState["SortField"] = sortField;
ViewState["SortDirection"] = sortDirection;
}
else
{
sortField = (string)ViewState["SortField"];
sortDirection = (string)ViewState["sortDirection"];
}
myDataView = new DataView();
// Obtain Document Data from Documents table
// and bind to the datalist control
DocumentDB documents = new DocumentDB();
// DataSet documentsData = documents.GetDocuments(ModuleID, Version);
// myDataView = documentsData.Tables[0].DefaultView;
setDataView(documents.GetDocuments(ModuleID, Version));
if (!Page.IsPostBack)
{
myDataView.Sort = sortField + " " + sortDirection;
}
BindGrid();
}
public async Task <List <Document> > Get(string CustomerID)
{
var db = new DocumentDB(_storageConnectionString);
return(await db.GetDocumentAsync(CustomerID));
}
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;
}
