public void registrarEvaluacionSolicitud(Solicitud solicitud)
{
SqlConnection cn = null;
SqlTransaction transaccion = null;
try
{
cn = HelperDB.GetSqlConnection();
//Inicio de la transaccion
transaccion = cn.BeginTransaction();
//Estado 5= Aprobado , 4 Desaprobado
SolicitudEstado nuevoEstado = estadoSolicitudRepository.obtenerPorId(solicitud.aprobado ? 5 : 4, cn, transaccion);
if (nuevoEstado == null)
{
throw new ArgumentNullException("No se encontro el estado APROBADO/DESAPROBADO para la solicitud");
}
solicitudRepository.registrarEvaluacionSolicitud(solicitud, nuevoEstado, cn, transaccion);
transaccion.Commit();
}
catch (Exception e)
{
Console.WriteLine(e.Message);
transaccion.Rollback();
throw new Exception(e.Message);
}
finally
{
if (cn != null)
{
cn.Close();
cn.Dispose();
}
}
}
public List <Solicitud> obtenerSolicitudesPendientesPago()
{
SqlConnection cn = null;
List <Solicitud> data = new List <Solicitud>();
try
{
cn = HelperDB.GetSqlConnection();
//1-GENERADO
data = solicitudRepository.obtenerPorEstado(1, cn);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
finally
{
if (cn != null)
{
cn.Close();
cn.Dispose();
}
}
return(data);
}
public List <Solicitud> obtenerSolicitudPorEstado(int idEstado)
{
SqlConnection cn = null;
List <Solicitud> data = new List <Solicitud>();
try
{
cn = HelperDB.GetSqlConnection();
data = solicitudRepository.obtenerPorEstado(idEstado, cn);
foreach (Solicitud solicitud in data)
{
solicitud.temas = solicitudTemaRepository.obtenerTemasPorSolicitud(solicitud, cn);
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
finally
{
if (cn != null)
{
cn.Close();
cn.Dispose();
}
}
return(data);
}
internal virtual void ClientDatabasesEnsureDeleted()
{
foreach (var tr in this.ClientRuns)
{
HelperDB.DropDatabase(tr.ClientProviderType, tr.DatabaseName);
}
this.ClientRuns.Clear();
}
public OsmPointsSearcher(HelperDB _hdb)
{
if (_hdb == null)
{
hdb = new HelperDB();
}
else
{
hdb = _hdb;
}
}
public SyncAllColumnsFixture()
{
// create databases
HelperDB.CreateDatabase(ProviderType.Sql, serverDbName);
HelperDB.CreateDatabase(ProviderType.Sql, client1DbName);
// create table
HelperDB.ExecuteSqlScript(serverDbName, createTableScript);
// insert table
HelperDB.ExecuteSqlScript(serverDbName, datas);
}
public GooglePointsSearcher(HelperDB _hdb)
{
if (_hdb == null)
{
hdb = new HelperDB();
}
else
{
hdb = _hdb;
}
hgoogle = new HelperGoogle();
}
public List <Pessoa> Select()
{
var lsPessoas = new List <Pessoa>();
try
{
var SQL = "select ID, NOME, CPF_CNPJ, TIPOPESSOA, DATANASCIMENTO from PESSOA";
IDbCommand comandoSQL = conexao.CreateCommand();
comandoSQL.CommandText = SQL;
comandoSQL.CommandType = CommandType.Text;
conexao.Open();
IDataReader reader = comandoSQL.ExecuteReader();
while (reader.Read())
{
var OPessoa = new Pessoa();
OPessoa.Id = Int32.Parse(reader[0].ToString());
OPessoa.Nome = reader[1].ToString();
OPessoa.Cpf_Cnpj = reader[2].ToString();
if (reader.IsDBNull(3))
{
OPessoa.TipoPessoa = 'F';
}
else
{
OPessoa.TipoPessoa = char.Parse(reader[3].ToString());
}
if (reader.IsDBNull(4))
{
OPessoa.DataNascimento = HelperDB.MinValue();
}
else
{
OPessoa.DataNascimento = DateTime.Parse(reader[4].ToString());
}
lsPessoas.Add(OPessoa);
}
reader.Close();
}
finally
{
conexao.Close();
}
return(lsPessoas);
}
private void btnSaoLuu_Click(object sender, EventArgs e)
{
FolderBrowserDialog dlg = new FolderBrowserDialog();
if (dlg.ShowDialog() == DialogResult.OK)
{
bool isSuccess = HelperDB.BackupDatabase(dlg.SelectedPath);
if (isSuccess)
{
MessageBox.Show("Backup thanh cong");
}
else
{
MessageBox.Show("Backup that bai");
}
}
}
public void Save(HelperDB helper)
{
switch (this.Type)
{
case PointType.CustomerEpicentrK: helper.SetEpicentrKPoint(this);
break;
case PointType.CustomerNewLine: helper.SetNewLinePoint(this);
break;
case PointType.BoardPoint:
break;
case PointType.MarketPoint:
break;
}
}
public void Delete(Pessoa pessoa)
{
try
{
var SQL = "delete from PESSOA where ID = @ID";
IDbCommand comandoSQL = conexao.CreateCommand();
comandoSQL.CommandText = SQL;
HelperDB.AddParameter(comandoSQL, "@ID", pessoa.Id);
comandoSQL.CommandType = CommandType.Text;
conexao.Open();
comandoSQL.ExecuteNonQuery();
}
finally
{
conexao.Close();
}
}
public void Delete(Usuario usuario)
{
try
{
var SQL = "delete from USUARIO where ID = @ID";
IDbCommand comandoSQL = conexao.CreateCommand();
comandoSQL.CommandText = SQL;
HelperDB.AddParameter(comandoSQL, "@ID", usuario.Id);
comandoSQL.CommandType = CommandType.Text;
conexao.Open();
comandoSQL.ExecuteNonQuery();
}
finally
{
conexao.Close();
}
}
/// <summary>
/// Will configure the fixture on first test launch
/// </summary>
internal void Configure()
{
// Pattern double check to be sur one instance is not trying to create the databse during an other trying to delete the same one.
lock (locker)
{
if (isConfigured)
{
return;
}
lock (locker)
{
if (isConfigured)
{
return;
}
// gets the server provider
this.ServerProvider = this.NewServerProvider(HelperDB.GetConnectionString(this.ProviderType, this.DatabaseName));
// create the server database
this.ServerDatabaseEnsureCreated();
// Get all provider fixture
var listOfBs = (from assemblyType in typeof(ProviderFixture).Assembly.DefinedTypes
where typeof(ProviderFixture).IsAssignableFrom(assemblyType) &&
assemblyType.BaseType == typeof(ProviderFixture)
select assemblyType).ToArray();
foreach (var t in listOfBs)
{
var c = GetDefaultConstructor(t);
var instance = c.Invoke(null) as ProviderFixture;
RegisterProvider(instance.ProviderType, instance);
}
// create the clients database
this.ClientDatabasesEnsureCreated();
isConfigured = true;
}
}
}
private void btnPhucHoi_Click(object sender, EventArgs e)
{
OpenFileDialog dlg = new OpenFileDialog();
dlg.Filter = "SQL SERVER database backup files|*.bak";
dlg.Title = "Database restore";
if (dlg.ShowDialog() == DialogResult.OK)
{
bool isSuccess = HelperDB.RostoreDatabase(dlg.FileName);
if (isSuccess)
{
MessageBox.Show("Restore thanh cong");
}
else
{
MessageBox.Show("Restore that bai");
}
}
}
public void Insert(Usuario usuario)
{
try
{
var SQL = "insert into USUARIO (LOGIN, SENHA, IDPESSOA) values (@LOGIN, @SENHA, @IDPESSOA)";
IDbCommand comandoSQL = conexao.CreateCommand();
comandoSQL.CommandText = SQL;
HelperDB.AddParameter(comandoSQL, "@LOGIN", usuario.Login);
HelperDB.AddParameter(comandoSQL, "@SENHA", usuario.Senha);
HelperDB.AddParameter(comandoSQL, "@IDPESSOA", usuario.IdPessoa);
comandoSQL.CommandType = CommandType.Text;
conexao.Open();
comandoSQL.ExecuteNonQuery();
}
finally
{
conexao.Close();
}
}
public void registrarMiembrosTesis(List <HorarioSustentacion> miembrosConHorario)
{
SqlConnection cn = null;
SqlTransaction transaccion = null;
try
{
cn = HelperDB.GetSqlConnection();
//Inicio de la transaccion
transaccion = cn.BeginTransaction();
Solicitud solicitud = miembrosConHorario[0].solicitud;
//Registrar el horario y los miembros
foreach (HorarioSustentacion miembroHorario in miembrosConHorario)
{
horarioRepository.registrarHorario(miembroHorario, cn, transaccion);
}
//Actualizar en estado FINALIZADO la solicitud
//Estado 6= Finalizada
SolicitudEstado nuevoEstado = estadoSolicitudRepository.obtenerPorId(6, cn, transaccion);
if (nuevoEstado == null)
{
throw new ArgumentNullException("No se encontro el estado FINALIZADO para la solicitud");
}
solicitudRepository.registrarEstadoFinalizado(solicitud, nuevoEstado, cn, transaccion);
transaccion.Commit();
}
catch (Exception e)
{
Console.WriteLine(e.Message);
transaccion.Rollback();
throw new Exception(e.Message);
}
finally
{
if (cn != null)
{
cn.Close();
cn.Dispose();
}
}
}
public void Update(Usuario usuario)
{
try
{
var SQL = "update USUARIO set LOGIN = @LOGIN, SENHA = @SENHA, IDPESSOA = @IDPESSOA where ID = @ID";
IDbCommand comandoSQL = conexao.CreateCommand();
comandoSQL.CommandText = SQL;
HelperDB.AddParameter(comandoSQL, "@LOGIN", usuario.Login);
HelperDB.AddParameter(comandoSQL, "@SENHA", usuario.Senha);
HelperDB.AddParameter(comandoSQL, "@IDPESSOA", usuario.IdPessoa);
comandoSQL.CommandType = CommandType.Text;
conexao.Open();
comandoSQL.ExecuteNonQuery();
}
finally
{
conexao.Close();
}
}
internal virtual void ClientDatabasesEnsureCreated()
{
// foreach server provider to test, there is a list of client / network
foreach (var serverKey in this.lstClientsType)
{
// get the the network we want to use
var networkType = serverKey.Key;
// create all the client databases based in the flags we set
foreach (var cpt in serverKey.Value.GetFlags())
{
// cast (wait for C# 7.3 to be able to set an extension method where a generic T can be marked as Enum compliant :)
var clientProviderType = (ProviderType)cpt;
// check if we have the fixture provider to be able to create a client provider
if (!registeredProviders.ContainsKey(clientProviderType))
{
continue;
}
// generate a new database name
var dbName = GetRandomDatabaseName();
Console.WriteLine("Create client database called " + dbName + " for provider " + clientProviderType);
// get the connection string
var connectionString = HelperDB.GetConnectionString(clientProviderType, dbName);
// create the database on the client provider
HelperDB.CreateDatabase(clientProviderType, dbName);
// generate the client provider
var clientProvider = registeredProviders[clientProviderType].NewServerProvider(connectionString);
// then add the run
this.ClientRuns.Add(new ProviderRun(dbName, clientProvider, clientProviderType, networkType));
}
}
}
public void Insert(Pessoa pessoa)
{
try
{
var SQL = "insert into PESSOA (NOME, CPF_CNPJ, TIPOPESSOA, DATANASCIMENTO)" +
" values (@NOME, @CPF_CNPJ, @TIPOPESSOA, @DATANASCIMENTO)";
IDbCommand comandoSQL = conexao.CreateCommand();
comandoSQL.CommandText = SQL;
HelperDB.AddParameter(comandoSQL, "@NOME", pessoa.Nome);
HelperDB.AddParameter(comandoSQL, "@CPF_CNPJ", pessoa.Cpf_Cnpj);
HelperDB.AddParameter(comandoSQL, "@TIPOPESSOA", pessoa.TipoPessoa);
HelperDB.AddParameter(comandoSQL, "@DATANASCIMENTO", pessoa.DataNascimento);
comandoSQL.CommandType = CommandType.Text;
conexao.Open();
comandoSQL.ExecuteNonQuery();
}
finally
{
conexao.Close();
}
}
public void Update(Pessoa pessoa)
{
try
{
var SQL = "update PESSOA set NOME = @NOME, CPF_CNPJ = @CPF_CNPJ" +
" ,TIPOPESSOA = @TIPOPESSOA, DATANASCIMENTO = @DATANASCIMENTO where ID = @ID";
IDbCommand comandoSQL = conexao.CreateCommand();
comandoSQL.CommandText = SQL;
HelperDB.AddParameter(comandoSQL, "@NOME", pessoa.Nome);
HelperDB.AddParameter(comandoSQL, "@CPF_CNPJ", pessoa.Cpf_Cnpj);
HelperDB.AddParameter(comandoSQL, "@TIPOPESSOA", pessoa.TipoPessoa);
HelperDB.AddParameter(comandoSQL, "@ID", pessoa.Id);
HelperDB.AddParameter(comandoSQL, "@DATANASCIMENTO", pessoa.DataNascimento);
comandoSQL.CommandType = CommandType.Text;
conexao.Open();
comandoSQL.ExecuteNonQuery();
}
finally
{
conexao.Close();
}
}
public List <Alumno> obtenerAlumnosHabilitados()
{
SqlConnection cn = null;
List <Alumno> data = new List <Alumno>();
try
{
cn = HelperDB.GetSqlConnection();
data = alumnoRepository.obtenerHabilitados(cn).ToList <Alumno>();;
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
finally
{
if (cn != null)
{
cn.Close();
cn.Dispose();
}
}
return(data);
}
public Alumno buscarPorCodigo(string codigo)
{
SqlConnection cn = null;
Alumno alumno = null;
try
{
cn = HelperDB.GetSqlConnection();
alumno = alumnoRepository.buscarPorCodigo(codigo, cn);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
finally
{
if (cn != null)
{
cn.Close();
cn.Dispose();
}
}
return(alumno);
}
public void registrarPagoSolicitud(PagoSolicitud pagoSolicitud)
{
SqlConnection cn = null;
SqlTransaction transaccion = null;
try
{
cn = HelperDB.GetSqlConnection();
//Inicio de la transaccion
transaccion = cn.BeginTransaction();
//Estado 3= Cancelado
SolicitudEstado estadoPagado = estadoSolicitudRepository.obtenerPorId(3, cn, transaccion);
if (estadoPagado == null)
{
throw new ArgumentNullException("No se encontro el estado PAGADO para la solicitud");
}
pagoSolicitudRepository.registrarPago(pagoSolicitud, cn, transaccion);
//Modificar el estado de la solicitud
solicitudRepository.cambiarEstadoPagadoSolicitud(pagoSolicitud.solicitud, estadoPagado, cn, transaccion);
transaccion.Commit();
}
catch (Exception e)
{
Console.WriteLine(e.Message);
transaccion.Rollback();
throw new Exception(e.Message);
}
finally
{
if (cn != null)
{
cn.Close();
cn.Dispose();
}
}
}
public List <FormaDePago> obtenerFormasPagoHabilitadas()
{
SqlConnection cn = null;
List <FormaDePago> data = new List <FormaDePago>();
try
{
cn = HelperDB.GetSqlConnection();
data = formaPagoRepository.obtenerHabilitados(cn);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
finally
{
if (cn != null)
{
cn.Close();
cn.Dispose();
}
}
return(data);
}
public System.Data.DataSet obtenerTodos()
{
SqlConnection cn = null;
System.Data.DataSet dataSet = new System.Data.DataSet();
try
{
cn = HelperDB.GetSqlConnection();
dataSet = alumnoRepository.obtenerTodos(cn);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
finally
{
if (cn != null)
{
cn.Close();
cn.Dispose();
}
}
return(dataSet);
}
public List <Profesor> obtenerProfesoresHabilitados()
{
SqlConnection cn = null;
List <Profesor> data = new List <Profesor>();
try
{
cn = HelperDB.GetSqlConnection();
data = profesorRepository.obtenerHabilitados(cn);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
finally
{
if (cn != null)
{
cn.Close();
cn.Dispose();
}
}
return(data);
}
public Tst()
{
hdb = new HelperDB();
}
public void Dispose()
{
HelperDB.DropSqlDatabase(serverDbName);
HelperDB.DropSqlDatabase(client1DbName);
}
public CoreYandexPoints()
{
hdb = new HelperDB();
hyandex = new HelperYandex();
}
public ServiceFinder()
{
hdb = new HelperDB();
InitializeComponent();
}
