private void CargarDatos() { DatosFiltro filtros = new DatosFiltro(); Periodos periodo = (Periodos)Convert.ToInt32(comboPeriodo.SelectedValue); if (periodo == Periodos.Folios) { filtros.Filtro = TipoFiltro.Folios; filtros.Folios = textBoxFolios.Text; } else { filtros.Filtro = TipoFiltro.Fecha; filtros.FechaInicio = dateTimePickerFechaInicio.Value; filtros.FechaFinal = dateTimePickerFechaFinal.Value; } Registrador.IRegistroEjecucion registrador = new Registrador.RegistroEjecucionArchivo("GeneradorASNWinLogCarga" + DateTime.Now.ToString("yyyyMMddHHmmss")); Cursor.Current = Cursors.WaitCursor; Remisiones = RemisionesManager.ObtenerRemisiones(filtros, registrador); remisionesDataTableBindingSource.DataSource = Remisiones; foreach (DataGridViewRow row in dataGridViewRANs.Rows) { if (((DateTime)row.Cells["fechaDocumentoDataGridViewTextBoxColumn"].Value) >= DateTime.Today) { row.Cells["Selected"].Value = true; } } Cursor.Current = Cursors.Default; }
private void buttonCargar_Click(object sender, EventArgs e) { this.buttonCargar.Enabled = false; List <string> foliosElegidos = new List <string>(); if (dataGridViewRANs.Rows.Count > 0) { foreach (DataGridViewRow row in dataGridViewRANs.Rows) { if (row.Cells["Selected"].Value != null) { if (Convert.ToBoolean(row.Cells["Selected"].Value) == true) { foliosElegidos.Add(Convert.ToString(row.Cells["folioRemisionDataGridViewTextBoxColumn"].Value)); } } } if (foliosElegidos.Count > 0) { Registrador.IRegistroEjecucion registrador = new Registrador.RegistroEjecucionArchivo("GeneradorASNWinLogGeneracion" + DateTime.Now.ToString("yyyyMMddHHmmss")); ExportadorASN.ExportarRemisiones(this.textBoxRutaDestino.Text, foliosElegidos, Remisiones, registrador); } else { MessageBox.Show("No hay remisiones seleccionadas. Favor de seleccionar remisiones a cargar ASN", "Seleccionar Remisiones"); } } else { MessageBox.Show("No hay remisiones disponibles para cargar", "No hay Remisiones"); } //http://www.codeproject.com/Articles/42437/Toggling-the-States-of-all-CheckBoxes-Inside-a-Dat }
/* * Steps to complete: * 1: Create a NEW database from a BAK file * 2: Delete unneeded artifacts: SPs, Fns, triggers, views, synonyms, indexes, foreign keys, constraints * 3: Run customized SP (to delete unneeded rows and tables) * 4: Backup NEW database to a BAK file * 5: Drop NEW database * 6: Delete exiting physical files for NEW database */ static void Main(string[] args) { string SAConnectionString = ""; //This it to use the System Administrator credentials string DBOwnerConnectionString = ""; //This it to use the owner of the new DB credentials. QUESTION: Can they be the same? Should they? string ProductionBackupFile = ""; string ResultingBackupFile = ""; string NewDBName = ""; string Script = ""; Registrador.IRegistroEjecucion Logger = new Registrador.RegistroEjecucionArchivo("Log_" + NewDBName + "_" + DateTime.Now.ToString("yyyyMMdd HHmmss")); int result = DBManager.RestoreDB(SAConnectionString, ProductionBackupFile, NewDBName, Logger); if (result == 0) { result = DBManager.ClearDB(DBOwnerConnectionString, NewDBName, Logger); if (result == 0) { result = DBManager.ExecuteScript(DBOwnerConnectionString, NewDBName, Script, Logger); if (result == 0) { result = DBManager.ShrinkDB(DBOwnerConnectionString, NewDBName, Logger); if (result == 0) { result = DBManager.BackupDB(SAConnectionString, NewDBName, ResultingBackupFile, Logger); if (result == 0) { result = DBManager.DropDB(SAConnectionString, NewDBName, Logger); if (result == 0) { //SUCCESS!!! } else { //Log error } } else { //Log error } } else { } } else { //Log error } } else { //Log error } } else { //Log error } }