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