public bool InsertaEncargado(Encargado encargado)
{
SqlConnection connection = new SqlConnection(connectionString);
bool insertCompleted = false;
encargado.IdTitular = DataBaseUtilities.GetNextIdForUse("C_Encargado", "IdEncargado", connection);
if (encargado.IdTitular == 0)
{
encargado.IdTitular = 1;
}
try
{
connection.Open();
string sqlQuery = "INSERT INTO C_Encargado(IdEncargado, Nombre,Apellidos,IdTitulo,NombMay,IdOrganismo,IdUsr,Fecha,Obs,Genero,IdTpoOrg,IdFuncion)" +
"VALUES (@IdEncargado,@Nombre,@Apellidos,@IdTitulo,@NombMay,@IdOrganismo,@IdUsr,@Fecha,@Obs,@Genero,@IdTpoOrg,@IdFuncion)";
SqlCommand cmd = new SqlCommand(sqlQuery, connection);
cmd.Parameters.AddWithValue("@IdEncargado", encargado.IdTitular);
cmd.Parameters.AddWithValue("@Nombre", encargado.Nombre);
cmd.Parameters.AddWithValue("@Apellidos", encargado.Apellidos);
cmd.Parameters.AddWithValue("@IdTitulo", encargado.IdTitulo);
cmd.Parameters.AddWithValue("@NombMay", encargado.NombreStr);
cmd.Parameters.AddWithValue("@IdOrganismo", encargado.IdOrganismo);
cmd.Parameters.AddWithValue("@IdUsr", AccesoUsuario.Llave);
cmd.Parameters.AddWithValue("@Fecha", DateTimeUtilities.DateToInt(DateTime.Now));
cmd.Parameters.AddWithValue("@Obs", encargado.Observaciones);
cmd.Parameters.AddWithValue("@Genero", encargado.Genero);
cmd.Parameters.AddWithValue("@IdTpoOrg", encargado.IdTpoOrg);
cmd.Parameters.AddWithValue("@IdFuncion", encargado.IdFuncion);
cmd.ExecuteNonQuery();
cmd.Dispose();
insertCompleted = true;
}
catch (SqlException ex)
{
string methodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
ErrorUtilities.SetNewErrorMessage(ex, methodName + " Exception,EncargadosModel", "DirectorioSjf2017");
}
catch (Exception ex)
{
string methodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
ErrorUtilities.SetNewErrorMessage(ex, methodName + " Exception,EncargadosModel", "DirectorioSjf2017");
}
finally
{
connection.Close();
}
return(insertCompleted);
}
public bool InsertaTermino(Terminos termino)
{
OleDbConnection connection = new OleDbConnection(connectionString);
bool insertCompleted = false;
termino.IdTermino = DataBaseUtilities.GetNextIdForUse("Terminos", "IdTermino", connection);
try
{
connection.Open();
string sqlQuery = "INSERT INTO Terminos(IdTermino,Termino,TerminoStr,Definicion,Bibliografia)" +
"VALUES (@IdTermino,@Termino,@TerminoStr,@Definicion,@Bibliografia)";
OleDbCommand cmd = new OleDbCommand(sqlQuery, connection);
cmd.Parameters.AddWithValue("@IdTermino", termino.IdTermino);
cmd.Parameters.AddWithValue("@Termino", termino.Termino);
cmd.Parameters.AddWithValue("@TerminoStr", termino.TerminoStr);
cmd.Parameters.AddWithValue("@Definicion", termino.Definicion);
cmd.Parameters.AddWithValue("@Bibliografia", termino.Bibliografia);
cmd.ExecuteNonQuery();
cmd.Dispose();
insertCompleted = true;
}
catch (OleDbException ex)
{
string methodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
ErrorUtilities.SetNewErrorMessage(ex, methodName + " Exception,TerminosModel", "BusquedaLatinos");
}
catch (Exception ex)
{
string methodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
ErrorUtilities.SetNewErrorMessage(ex, methodName + " Exception,TerminosModel", "BusquedaLatinos");
}
finally
{
connection.Close();
}
return(insertCompleted);
}
public bool SetCheckIn(Usuarios usuario)
{
bool checkInComplete = false;
OleDbConnection connection = new OleDbConnection(connectionString);
OleDbDataAdapter dataAdapter;
DataSet dataSet = new DataSet();
DataRow dr;
try
{
int id = DataBaseUtilities.GetNextIdForUse("Asistencia", "IdAsistencia", connection);
if (id != 0)
{
dataAdapter = new OleDbDataAdapter();
dataAdapter.SelectCommand = new OleDbCommand("SELECT * FROM Asistencia WHERE IdAsistencia = 0", connection);
dataAdapter.Fill(dataSet, "Asistencia");
dr = dataSet.Tables["Asistencia"].NewRow();
dr["IdAsistencia"] = id;
dr["IdPersonal"] = usuario.IdUsuario;
dr["IdLibreria"] = usuario.IdLibreria;
dr["Fecha"] = DateTime.Now;
dr["FechaInt"] = DateTimeUtilities.DateToInt(DateTime.Now);
dataSet.Tables["Asistencia"].Rows.Add(dr);
dataAdapter.InsertCommand = connection.CreateCommand();
dataAdapter.InsertCommand.CommandText = "INSERT INTO Asistencia(IdAsistencia,IdPersonal,IdLibreria,Fecha,HoraEntrada,FechaInt) " +
"VALUES (@IdAsistencia,@IdPersonal,@IdLibreria,@Fecha,TIME(),@FechaInt)";
dataAdapter.InsertCommand.Parameters.Add("@IdAsistencia", OleDbType.Numeric, 0, "IdAsistencia");
dataAdapter.InsertCommand.Parameters.Add("@IdPersonal", OleDbType.Numeric, 0, "IdPersonal");
dataAdapter.InsertCommand.Parameters.Add("@IdLibreria", OleDbType.Numeric, 0, "IdLibreria");
dataAdapter.InsertCommand.Parameters.Add("@Fecha", OleDbType.Date, 0, "Fecha");
dataAdapter.InsertCommand.Parameters.Add("@FechaInt", OleDbType.Numeric, 0, "FechaInt");
dataAdapter.Update(dataSet, "Asistencia");
dataSet.Dispose();
dataAdapter.Dispose();
connection.Close();
checkInComplete = true;
}
}
catch (OleDbException ex)
{
string methodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
ErrorUtilities.SetNewErrorMessage(ex, methodName + " Exception,AsistenciaModel", "AsistenciaLibreria");
}
catch (Exception ex)
{
string methodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
ErrorUtilities.SetNewErrorMessage(ex, methodName + " Exception,AsistenciaModel", "AsistenciaLibreria");
}
finally
{
connection.Close();
}
return(checkInComplete);
}
public void InsertaTemaNuevo(Temas nuevoTema)
{
SqlConnection connection = Conexion.GetConecctionManttoCE();
SqlDataAdapter dataAdapter;
DataSet dataSet = new DataSet();
DataRow dr;
try
{
nuevoTema.IdTema = DataBaseUtilities.GetNextIdForUse("Temas", "Id", connection);
string sqlCadena = "SELECT * FROM Temas WHERE Id = 0";
dataAdapter = new SqlDataAdapter();
dataAdapter.SelectCommand = new SqlCommand(sqlCadena, connection);
dataAdapter.Fill(dataSet, "Temas");
dr = dataSet.Tables["Temas"].NewRow();
dr["Id"] = nuevoTema.IdTema;
dr["Nivel"] = nuevoTema.Nivel;
dr["Padre"] = nuevoTema.Padre;
dr["Tema"] = nuevoTema.Tema;
dr["Orden"] = nuevoTema.Orden;
dr["TemaStr"] = nuevoTema.TemaStr;
dr["LetraInicial"] = nuevoTema.LInicial;
dr["IdProd"] = nuevoTema.IdProducto;
dataSet.Tables["Temas"].Rows.Add(dr);
dataAdapter.InsertCommand = connection.CreateCommand();
dataAdapter.InsertCommand.CommandText = "INSERT INTO Temas (Id,Nivel,Padre,Tema,Orden,TemaStr,LetraInicial,IdProd) VALUES (@Id,@Nivel,@Padre,@Tema,@Orden,@TemaStr,@LetraInicial,@IdProd)";
dataAdapter.InsertCommand.Parameters.Add("@Id", SqlDbType.Int, 0, "Id");
dataAdapter.InsertCommand.Parameters.Add("@Nivel", SqlDbType.Int, 0, "Nivel");
dataAdapter.InsertCommand.Parameters.Add("@Padre", SqlDbType.Int, 0, "Padre");
dataAdapter.InsertCommand.Parameters.Add("@Tema", SqlDbType.VarChar, 0, "Tema");
dataAdapter.InsertCommand.Parameters.Add("@Orden", SqlDbType.Int, 0, "Orden");
dataAdapter.InsertCommand.Parameters.Add("@TemaStr", SqlDbType.VarChar, 0, "TemaStr");
dataAdapter.InsertCommand.Parameters.Add("@LetraInicial", SqlDbType.VarChar, 0, "LetraInicial");
dataAdapter.InsertCommand.Parameters.Add("@IdProd", SqlDbType.Int, 0, "IdProd");
dataAdapter.Update(dataSet, "Temas");
dataSet.Dispose();
dataAdapter.Dispose();
new BitacoraModel().SetBitacoraEntry(nuevoTema, 1, " ");
}
catch (SqlException ex)
{
string methodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
ErrorUtilities.SetNewErrorMessage(ex, methodName + " Exception,TemasModel", "ManttoProductosAlternos");
}
catch (Exception ex)
{
string methodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
ErrorUtilities.SetNewErrorMessage(ex, methodName + " Exception,TemasModel", "ManttoProductosAlternos");
}
finally
{
connection.Close();
}
}
public void SetNewTerminoGenericos(Genericos generico)
{
OleDbConnection connection = new OleDbConnection(ConfigurationManager.ConnectionStrings["Diccionario"].ToString());
OleDbDataAdapter dataAdapter;
DataSet dataSet = new DataSet();
DataRow dr;
try
{
generico.IdGenerico = DataBaseUtilities.GetNextIdForUse("Genericos", "IdConcepto", connection);
string sqlCadena = "SELECT * FROM Genericos WHERE IdConcepto = 0";
dataAdapter = new OleDbDataAdapter();
dataAdapter.SelectCommand = new OleDbCommand(sqlCadena, connection);
dataAdapter.Fill(dataSet, "Genericos");
dr = dataSet.Tables["Genericos"].NewRow();
dr["IdConcepto"] = generico.IdGenerico;
dr["Concepto"] = StringUtilities.UppercaseFirst(generico.Termino);
dr["ConceptoStr"] = ScjnUtilities.StringUtilities.PrepareToAlphabeticalOrder(generico.Termino);
dr["FechaAlta"] = DateTime.Now;
dr["FechaAltaInt"] = DateTimeUtilities.DateToInt(DateTime.Now);
dataSet.Tables["Genericos"].Rows.Add(dr);
dataAdapter.InsertCommand = connection.CreateCommand();
dataAdapter.InsertCommand.CommandText = "INSERT INTO Genericos VALUES (@IdConcepto,@Concepto,@ConceptoStr,@FechaAlta,@FechaAltaInt)";
dataAdapter.InsertCommand.Parameters.Add("@IdConcepto", OleDbType.Numeric, 0, "IdConcepto");
dataAdapter.InsertCommand.Parameters.Add("@Concepto", OleDbType.VarChar, 0, "Concepto");
dataAdapter.InsertCommand.Parameters.Add("@ConceptoStr", OleDbType.VarChar, 0, "ConceptoStr");
dataAdapter.InsertCommand.Parameters.Add("@FechaAlta", OleDbType.Date, 0, "FechaAlta");
dataAdapter.InsertCommand.Parameters.Add("@FechaAltaInt", OleDbType.Numeric, 0, "FechaAltaInt");
dataAdapter.Update(dataSet, "Genericos");
dataSet.Dispose();
dataAdapter.Dispose();
if (generico.Definiciones != null)
{
foreach (Definiciones definicion in generico.Definiciones)
{
definicion.IdGenerico = generico.IdGenerico;
new DefinicionModel().SetDefiniciones(definicion);
}
}
}
catch (OleDbException ex)
{
string methodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
ErrorUtilities.SetNewErrorMessage(ex, methodName + " Exception,SetNewTerminoGenericos", "Diccionario");
}
catch (Exception ex)
{
string methodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
ErrorUtilities.SetNewErrorMessage(ex, methodName + " Exception,SetNewTerminoGenericos", "Diccionario");
}
finally
{
connection.Close();
}
}
public void SetNewConcept(Conceptos concepto)
{
OleDbConnection connection = new OleDbConnection(ConfigurationManager.ConnectionStrings["Diccionario"].ToString());
OleDbDataAdapter dataAdapter;
DataSet dataSet = new DataSet();
DataRow dr;
try
{
concepto.IdConcepto = DataBaseUtilities.GetNextIdForUse("Conceptos", "IdConcepto", connection);
string sqlCadena = "SELECT * FROM Conceptos WHERE IdConcepto = 0";
dataAdapter = new OleDbDataAdapter();
dataAdapter.SelectCommand = new OleDbCommand(sqlCadena, connection);
dataAdapter.Fill(dataSet, "Conceptos");
dr = dataSet.Tables["Conceptos"].NewRow();
dr["IdConcepto"] = concepto.IdConcepto;
dr["Concepto"] = concepto.Concepto;
dr["ConceptoStr"] = concepto.ConceptoStr;
dr["FechaAlta"] = DateTime.Now;
dr["FechaAltaInt"] = DateTimeUtilities.DateToInt(DateTime.Now);
dataSet.Tables["Conceptos"].Rows.Add(dr);
dataAdapter.InsertCommand = connection.CreateCommand();
dataAdapter.InsertCommand.CommandText = "INSERT INTO Conceptos VALUES (@IdConcepto,@Concepto,@ConceptoStr,@FechaAlta,@FechaAltaInt)";
dataAdapter.InsertCommand.Parameters.Add("@IdConcepto", OleDbType.Numeric, 0, "IdConcepto");
dataAdapter.InsertCommand.Parameters.Add("@Concepto", OleDbType.VarChar, 0, "Concepto");
dataAdapter.InsertCommand.Parameters.Add("@ConceptoStr", OleDbType.VarChar, 0, "ConceptoStr");
dataAdapter.InsertCommand.Parameters.Add("@FechaAlta", OleDbType.Date, 0, "FechaAlta");
dataAdapter.InsertCommand.Parameters.Add("@FechaAltaInt", OleDbType.Numeric, 0, "FechaAltaInt");
dataAdapter.Update(dataSet, "Conceptos");
dataSet.Dispose();
dataAdapter.Dispose();
}
catch (OleDbException ex)
{
string methodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
MessageBox.Show("Error ({0}) : {1}" + ex.Source + ex.Message, methodName, MessageBoxButtons.OK, MessageBoxIcon.Warning);
ErrorUtilities.SetNewErrorMessage(ex, methodName, 0);
}
catch (Exception ex)
{
string methodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
MessageBox.Show("Error ({0}) : {1}" + ex.Source + ex.Message, methodName, MessageBoxButtons.OK, MessageBoxIcon.Warning);
ErrorUtilities.SetNewErrorMessage(ex, methodName, 0);
}
finally
{
connection.Close();
}
}
public void SetNewTesis(Tesis tesis)
{
OleDbConnection connection = new OleDbConnection(connectionString);
string sSql;
OleDbDataAdapter dataAdapter;
DataSet dataSet = new DataSet();
DataRow dr;
try
{
tesis.IdTesis = DataBaseUtilities.GetNextIdForUse("Tesis", "IdTesis", connection);
dataAdapter = new OleDbDataAdapter();
dataAdapter.SelectCommand = new OleDbCommand("SELECT * FROM Tesis WHERE IdTesis = 0", connection);
dataAdapter.Fill(dataSet, "Tesis");
dr = dataSet.Tables["Tesis"].NewRow();
dr["IdTesis"] = tesis.IdTesis;
dr["Tesis"] = tesis.ClaveTesis;
dr["Rubro"] = tesis.Rubro;
dr["RubroStr"] = StringUtilities.PrepareToAlphabeticalOrder(tesis.Rubro);
dr["Tatj"] = tesis.Tatj;
dr["IdInstancia"] = tesis.IdInstancia;
dr["IdSubInstancia"] = tesis.IdSubInstancia;
dr["OrdenInstancia"] = tesis.OrdenInstancia;
dr["IdColor"] = tesis.IdColor;
dr["MateriaAsignada"] = tesis.MateriaAsignada;
dr["Oficio"] = tesis.Oficio;
dr["FechaAlta"] = DateTime.Now;
dr["FechaAltaInt"] = DateTimeUtilities.DateToInt(DateTime.Now);
dr["FechaEnvio"] = tesis.FechaEnvio;
dr["FechaEnvioInt"] = DateTimeUtilities.DateToInt(tesis.FechaEnvio);
dr["IdUsuario"] = AccesoUsuarioModel.Llave;
dataSet.Tables["Tesis"].Rows.Add(dr);
dataAdapter.InsertCommand = connection.CreateCommand();
sSql = "INSERT INTO Tesis (IdTesis,Tesis,Rubro,RubroStr,Tatj,IdInstancia,IdSubInstancia,OrdenInstancia,IdColor,MateriaAsignada,Oficio,FechaAlta,FechaAltaInt,FechaEnvio,FechaEnvioInt,IdUsuario) " +
" VALUES (@IdTesis,@Tesis,@Rubro,@RubroStr,@Tatj,@IdInstancia,@IdSubInstancia,@OrdenInstancia,@IdColor,@MateriaAsignada,@Oficio,@FechaAlta,@FechaAltaInt,@FechaEnvio,@FechaEnvioInt,@IdUsuario)";
dataAdapter.InsertCommand.CommandText = sSql;
dataAdapter.InsertCommand.Parameters.Add("@IdTesis", OleDbType.Numeric, 0, "IdTesis");
dataAdapter.InsertCommand.Parameters.Add("@Tesis", OleDbType.VarChar, 0, "Tesis");
dataAdapter.InsertCommand.Parameters.Add("@Rubro", OleDbType.VarChar, 0, "Rubro");
dataAdapter.InsertCommand.Parameters.Add("@RubroStr", OleDbType.VarChar, 0, "RubroStr");
dataAdapter.InsertCommand.Parameters.Add("@Tatj", OleDbType.Numeric, 0, "Tatj");
dataAdapter.InsertCommand.Parameters.Add("@IdInstancia", OleDbType.Numeric, 0, "IdInstancia");
dataAdapter.InsertCommand.Parameters.Add("@IdSubInstancia", OleDbType.Numeric, 0, "IdSubInstancia");
dataAdapter.InsertCommand.Parameters.Add("@OrdenInstancia", OleDbType.Numeric, 0, "OrdenInstancia");
dataAdapter.InsertCommand.Parameters.Add("@IdColor", OleDbType.Numeric, 0, "IdColor");
dataAdapter.InsertCommand.Parameters.Add("@MateriaAsignada", OleDbType.VarChar, 0, "MateriaAsignada");
dataAdapter.InsertCommand.Parameters.Add("@Oficio", OleDbType.VarChar, 0, "Oficio");
dataAdapter.InsertCommand.Parameters.Add("@FechaAlta", OleDbType.Date, 0, "FechaAlta");
dataAdapter.InsertCommand.Parameters.Add("@FechaAltaInt", OleDbType.Numeric, 0, "FechaAltaInt");
dataAdapter.InsertCommand.Parameters.Add("@FechaEnvio", OleDbType.Date, 0, "FechaEnvio");
dataAdapter.InsertCommand.Parameters.Add("@FechaEnvioInt", OleDbType.Numeric, 0, "FechaEnvioInt");
dataAdapter.InsertCommand.Parameters.Add("@IdUsuario", OleDbType.Numeric, 0, "IdUsuario");
dataAdapter.Update(dataSet, "Tesis");
dataSet.Dispose();
dataAdapter.Dispose();
}
catch (OleDbException ex)
{
string methodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
ErrorUtilities.SetNewErrorMessage(ex, methodName + " Exception,TesisModel", "ListadoDeTesis");
}
catch (Exception ex)
{
string methodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
ErrorUtilities.SetNewErrorMessage(ex, methodName + " Exception,TesisModel", "ListadoDeTesis");
}
finally
{
connection.Close();
}
}
