/*###########################################Fin leer######################################################*/
/*#############################################Actualizar##################################################*/
public static void ActualizarEstadoUsuarioRepresentate(int refRepresentante, string estado)
{
try
{
var command = new MySqlCommand()
{
CommandText = "Modificar_crearProceso_usuario_representante", CommandType = System.Data.CommandType.StoredProcedure
};
command.Parameters.Add(new MySqlParameter()
{
ParameterName = "in_refResponsable", Direction = System.Data.ParameterDirection.Input, Value = refRepresentante
});
command.Parameters.Add(new MySqlParameter()
{
ParameterName = "in_estado", Direction = System.Data.ParameterDirection.Input, Value = estado
});
//command.Parameters.Add(new MySqlParameter() { ParameterName = "out_nombre", Direction = System.Data.ParameterDirection.Output, Value = -1 });
var datos = ContexDb.ExecuteProcedure(command);
//return datos.Parameters["out_nombre"].Value.ToString();
//saber.Id = Convert.ToInt32(datos.Parameters["out_id"].Value);
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
//return null;
}
public static Organizacion LeerOrganizacion(int refSolicitud)
{
try
{
var command = new MySqlCommand()
{
CommandText = "Leer_Organizacion", CommandType = System.Data.CommandType.StoredProcedure
};
command.Parameters.Add(new MySqlParameter()
{
ParameterName = "in_refSolicitud", Direction = System.Data.ParameterDirection.Input, Value = refSolicitud
});
var datos = ContexDb.GetDataSet(command);
if (datos.Tables[0].Rows.Count == 1)
{
var prodData = datos.Tables[0].Rows[0];
Organizacion organizacion = new Organizacion()
{
Nombre = prodData["nombre"].ToString(),
TipoOE = new TipoOE {
Nombre = prodData["tipo"].ToString()
},
};
return(organizacion);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
return(null);
}
public static Boolean EliminarParticipante(int IdSolicitud, String IdParticipante, DateTime FechaModificacion)
{
try
{
var command = new MySqlCommand()
{
CommandText = "Eliminar_Participante", CommandType = System.Data.CommandType.StoredProcedure
};
command.Parameters.Add(new MySqlParameter()
{
ParameterName = "in_refSolicitud", Direction = System.Data.ParameterDirection.Input, Value = IdSolicitud
});
command.Parameters.Add(new MySqlParameter()
{
ParameterName = "in_refParticipante", Direction = System.Data.ParameterDirection.Input, Value = IdParticipante
});
command.Parameters.Add(new MySqlParameter()
{
ParameterName = "in_fechaModificacion", Direction = System.Data.ParameterDirection.Input, Value = FechaModificacion
});
//command.Parameters.Add(new MySqlParameter() { ParameterName = "out_id", Direction = System.Data.ParameterDirection.Output, Value = -1 });
var datos = ContexDb.ExecuteProcedure(command);
return(true);
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
return(false);
}
public static void AgregarCategoria(int idSolicitud, int idCategoria, DateTime FechaModificacion)
{
try
{
var command = new MySqlCommand()
{
CommandText = "Agregar_categoria", CommandType = System.Data.CommandType.StoredProcedure
};
command.Parameters.Add(new MySqlParameter()
{
ParameterName = "in_refSolicitud", Direction = System.Data.ParameterDirection.Input, Value = idSolicitud
});
command.Parameters.Add(new MySqlParameter()
{
ParameterName = "in_refCategoria", Direction = System.Data.ParameterDirection.Input, Value = idCategoria
});
command.Parameters.Add(new MySqlParameter()
{
ParameterName = "in_fechaModificacion", Direction = System.Data.ParameterDirection.Input, Value = FechaModificacion
});
var datos = ContexDb.ExecuteProcedure(command);
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
}
public static void AgregarParSol(String refParticipante, int refSolicitud, DateTime FechaModificacion)
{
try
{
var command = new MySqlCommand()
{
CommandText = "Agregar_parsol", CommandType = System.Data.CommandType.StoredProcedure
};
command.Parameters.Add(new MySqlParameter()
{
ParameterName = "in_refParticipante", Direction = System.Data.ParameterDirection.Input, Value = refParticipante
});
command.Parameters.Add(new MySqlParameter()
{
ParameterName = "in_refSolicitud", Direction = System.Data.ParameterDirection.Input, Value = refSolicitud
});
command.Parameters.Add(new MySqlParameter()
{
ParameterName = "in_fechaModificacion", Direction = System.Data.ParameterDirection.Input, Value = FechaModificacion
});
//command.Parameters.Add(new MySqlParameter() { ParameterName = "out_id", Direction = System.Data.ParameterDirection.Output, Value = -1 });
var datos = ContexDb.ExecuteProcedure(command);
//saber.Id = Convert.ToInt32(datos.Parameters["out_id"].Value);
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
}
/*#############################################Leer######################################################*/
/// <summary>
/// Muestra los datos de la declaracion de gastos en base al id de esta
/// </summary>
/// <param name="RefDeclaracionGastos"></param>
/// <returns>Devuelve los datos principales de la declaracion de gastos que son la fecha limite del evento, el monto total de la documentacion guardada y el monto total de los documentos seleccionados a rendir. En caso de que exista algun problema, devuelve un null.</returns>
public static DeclaracionGastos LeerDeclaracionGastos(int RefDeclaracionGastos)
{
try
{
var command = new MySqlCommand()
{
CommandText = "Leer_Declaracion_Gastos", CommandType = System.Data.CommandType.StoredProcedure
};
command.Parameters.Add(new MySqlParameter()
{
ParameterName = "in_refDeclaracionGastos", Direction = System.Data.ParameterDirection.Input, Value = RefDeclaracionGastos
});
var datos = ContexDb.GetDataSet(command);
if (datos.Tables[0].Rows.Count == 1)
{
DeclaracionGastos declaracionGastos;
var prodData = datos.Tables[0].Rows[0];
declaracionGastos = new DeclaracionGastos()
{
Id = Convert.ToInt32(prodData["id"]),
FechaLimite = Convert.ToDateTime(prodData["fechaLimite"]),
TotalDocumentacion = Convert.ToInt32(prodData["totalDocumentacion"]),
TotalRendido = Convert.ToInt32(prodData["totalRendido"])
};
return(declaracionGastos);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
return(null);
}
public static int EliminarDocumentosDG(int IdDeclaracionGastos)
{
try
{
var command = new MySqlCommand()
{
CommandText = "Eliminar_documentos_declaracion_gastos", CommandType = System.Data.CommandType.StoredProcedure
};
command.Parameters.Add(new MySqlParameter()
{
ParameterName = "in_idDeclaracionGastos", Direction = System.Data.ParameterDirection.Input, Value = IdDeclaracionGastos
});
command.Parameters.Add(new MySqlParameter()
{
ParameterName = "out_validacion", Direction = System.Data.ParameterDirection.Output, Value = -1
});
var datos = ContexDb.ExecuteProcedure(command);
return(Convert.ToInt32(datos.Parameters["out_validacion"].Value));
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
return(-1);
}
public static String Leer_Correo(string Email)
{
try
{
var command = new MySqlCommand()
{
CommandText = "leer_Correo", CommandType = System.Data.CommandType.StoredProcedure
};
command.Parameters.Add(new MySqlParameter()
{
ParameterName = "in_email", Direction = System.Data.ParameterDirection.Input, Value = Email
});
var datos = ContexDb.GetDataSet(command);
if (datos.Tables[0].Rows.Count == 1)
{
System.Data.DataRow row = datos.Tables[0].Rows[0];
var prodData = row;
return(prodData["email"].ToString());
}
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
finally
{
}
return(null);
}
public static List <Campus> Leer_Campus()
{
List <Campus> campus = new List <Campus>();
var command = new MySqlCommand()
{
CommandText = "Leer_Campus", CommandType = System.Data.CommandType.StoredProcedure
};
try
{
var datos = ContexDb.GetDataSet(command);
if (datos.Tables[0].Rows.Count > 0)
{
foreach (System.Data.DataRow row in datos.Tables[0].Rows)
{
var prodData = row;
Campus camp = new Campus()
{
Id = Convert.ToInt32(prodData["id"]),
Nombre = prodData["nombre"].ToString()
};
campus.Add(camp);
}
return(campus);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
return(null);
}
public static int ActualizarInstitucion(int IdInstitucion, string Abreviatura, string Nombre)
{
int result;
try
{
var command = new MySqlCommand()
{
CommandText = "Actualizar_Institucion", CommandType = System.Data.CommandType.StoredProcedure
};
command.Parameters.Add(new MySqlParameter()
{
ParameterName = "in_id", Direction = System.Data.ParameterDirection.Input, Value = IdInstitucion
});
command.Parameters.Add(new MySqlParameter()
{
ParameterName = "in_abreviacion", Direction = System.Data.ParameterDirection.Input, Value = Abreviatura
});
command.Parameters.Add(new MySqlParameter()
{
ParameterName = "in_nombre", Direction = System.Data.ParameterDirection.Input, Value = Nombre
});
var datos = ContexDb.ExecuteProcedure(command);
result = 1;
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
result = -1;
}
return(result);
}
/*Se debe cambiar a consultas de usuario*/
public static int IniciarSesion(Login login)
{
try
{
var command = new MySqlCommand()
{
CommandText = "iniciar_sesion", CommandType = System.Data.CommandType.StoredProcedure
};
command.Parameters.Add(new MySqlParameter()
{
ParameterName = "in_usuario", Direction = System.Data.ParameterDirection.Input, Value = login.Usuario
});
command.Parameters.Add(new MySqlParameter()
{
ParameterName = "in_clave", Direction = System.Data.ParameterDirection.Input, Value = login.Clave
});
var datos = ContexDb.GetDataSet(command);
if (datos.Tables[0].Rows.Count == 1)
{
System.Data.DataRow row = datos.Tables[0].Rows[0];
var prodData = row;
return(Convert.ToInt32(prodData["id"].ToString()));
}
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
return(-1);
}
public static List <Institucion> LeerInstituciones()
{
try
{
var command = new MySqlCommand()
{
CommandText = "Leer_Institucion", CommandType = System.Data.CommandType.StoredProcedure
};
var datos = ContexDb.GetDataSet(command);
List <Institucion> instituciones = new List <Institucion>();
if (datos.Tables[0].Rows.Count > 0)
{
foreach (System.Data.DataRow row in datos.Tables[0].Rows)
{
var prodData = row;
var institucion = new Institucion()
{
Id = Convert.ToInt32(prodData["id"]),
Abreviacion = prodData["abreviacion"].ToString(),
Nombre = prodData["nombre"].ToString(),
Estado = prodData["estado"].ToString(),
EstadoEliminacion = prodData["estadoEliminacion"].ToString()
};
instituciones.Add(institucion);
}
}
return(instituciones);
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
return(null);
}
public static Modulo Leer_Modulo(int idModulo)
{
try
{
var command = new MySqlCommand()
{
CommandText = "Leer_Modulo", CommandType = System.Data.CommandType.StoredProcedure
};
command.Parameters.Add(new MySqlParameter()
{
ParameterName = "in_idModulo", Direction = System.Data.ParameterDirection.Input, Value = idModulo
});
var datos = ContexDb.GetDataSet(command);
if (datos.Tables[0].Rows.Count > 0)
{
Modulo modulo = new Modulo()
{
Id = Convert.ToInt32(datos.Tables[0].Rows[0]["id"]),
Nombre = datos.Tables[0].Rows[0]["nombre"].ToString()
};
return(modulo);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
return(null);
}
public static Boolean ActualizarEstadoProceso(int estado, int refProceso, String nombreProceso)
{
try
{
var command = new MySqlCommand()
{
CommandText = "Actualizar_Estado_Proceso", CommandType = System.Data.CommandType.StoredProcedure
};
command.Parameters.Add(new MySqlParameter()
{
ParameterName = "in_estado", Direction = System.Data.ParameterDirection.Input, Value = estado
});
command.Parameters.Add(new MySqlParameter()
{
ParameterName = "in_refProceso", Direction = System.Data.ParameterDirection.Input, Value = refProceso
});
command.Parameters.Add(new MySqlParameter()
{
ParameterName = "in_nombreProceso", Direction = System.Data.ParameterDirection.Input, Value = nombreProceso
});
var datos = ContexDb.ExecuteProcedure(command);
return(true);
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
return(false);
}
public static void Actualizar_Proceso_Resolucion_DecGatos(int proceso, int id_proceso, int id_procesoActual)
{
try
{
var command = new MySqlCommand()
{
CommandText = "actualizar_estado_proceso", CommandType = System.Data.CommandType.StoredProcedure
};
command.Parameters.Add(new MySqlParameter()
{
ParameterName = "in_proceso", Direction = System.Data.ParameterDirection.Input, Value = id_proceso
});
command.Parameters.Add(new MySqlParameter()
{
ParameterName = "in_id_procesoFondo", Direction = System.Data.ParameterDirection.Input, Value = id_proceso
});
command.Parameters.Add(new MySqlParameter()
{
ParameterName = "in_id_proceso_actual", Direction = System.Data.ParameterDirection.Input, Value = id_procesoActual
});
var datos = ContexDb.ExecuteProcedure(command);
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
}
public static void AgregarCategoria(SolicitudCategoria categoria)
{
try
{
var command = new MySqlCommand()
{
CommandText = "agregar_categoria", CommandType = System.Data.CommandType.StoredProcedure
};
command.Parameters.Add(new MySqlParameter()
{
ParameterName = "in_refSolicitud", Direction = System.Data.ParameterDirection.Input, Value = categoria.RefSolicitud
});
command.Parameters.Add(new MySqlParameter()
{
ParameterName = "in_refCategoria", Direction = System.Data.ParameterDirection.Input, Value = categoria.RefCategoria
});
//command.Parameters.Add(new MySqlParameter() { ParameterName = "out_id", Direction = System.Data.ParameterDirection.Output, Value = -1 });
var datos = ContexDb.ExecuteProcedure(command);
//saber.Id = Convert.ToInt32(datos.Parameters["out_id"].Value);
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
}
public static String ModificarEstadoResponsable(string refResponsable, string estado)
{
try
{
var command = new MySqlCommand()
{
CommandText = "cambiar_estado_responsable", CommandType = System.Data.CommandType.StoredProcedure
};
command.Parameters.Add(new MySqlParameter()
{
ParameterName = "in_refResponsable", Direction = System.Data.ParameterDirection.Input, Value = refResponsable
});
command.Parameters.Add(new MySqlParameter()
{
ParameterName = "in_estado", Direction = System.Data.ParameterDirection.Input, Value = estado
});
command.Parameters.Add(new MySqlParameter()
{
ParameterName = "out_nombre", Direction = System.Data.ParameterDirection.Output, Value = -1
});
var datos = ContexDb.ExecuteProcedure(command);
return(datos.Parameters["out_nombre"].Value.ToString());
//saber.Id = Convert.ToInt32(datos.Parameters["out_id"].Value);
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
return(null);
}
public static void AgregarProcesoFondo(int refOrganizacion, int refSolicitud, int estado)
{
try
{
var command = new MySqlCommand()
{
CommandText = "crear_proceso_fondo", CommandType = System.Data.CommandType.StoredProcedure
};
command.Parameters.Add(new MySqlParameter()
{
ParameterName = "in_refOrganizacion", Direction = System.Data.ParameterDirection.Input, Value = refOrganizacion
});
command.Parameters.Add(new MySqlParameter()
{
ParameterName = "in_refSolicitud", Direction = System.Data.ParameterDirection.Input, Value = refSolicitud
});
command.Parameters.Add(new MySqlParameter()
{
ParameterName = "in_estado", Direction = System.Data.ParameterDirection.Input, Value = estado
});
//command.Parameters.Add(new MySqlParameter() { ParameterName = "out_id", Direction = System.Data.ParameterDirection.Output, Value = -1 });
var datos = ContexDb.ExecuteProcedure(command);
//saber.Id = Convert.ToInt32(datos.Parameters["out_id"].Value);
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
}
public static int DocumentoSeleccionado(int Estado, int IdDocumento)
{
try
{
var command = new MySqlCommand()
{
CommandText = "Modificar_seleccion_documento", CommandType = System.Data.CommandType.StoredProcedure
};
command.Parameters.Add(new MySqlParameter()
{
ParameterName = "in_idDocumento", Direction = System.Data.ParameterDirection.Input, Value = IdDocumento
});
command.Parameters.Add(new MySqlParameter()
{
ParameterName = "in_estado", Direction = System.Data.ParameterDirection.Input, Value = Estado
});
command.Parameters.Add(new MySqlParameter()
{
ParameterName = "out_validacion", Direction = System.Data.ParameterDirection.Output, Value = -1
});
var datos = ContexDb.ExecuteProcedure(command);
return(Convert.ToInt32(datos.Parameters["out_validacion"].Value));
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
return(-1);
}
public static void EliminarPersona(SolicitudPersona solper)
{
try
{
var command = new MySqlCommand()
{
CommandText = "eliminar_persona_seleccionada", CommandType = System.Data.CommandType.StoredProcedure
};
command.Parameters.Add(new MySqlParameter()
{
ParameterName = "in_refSolicitud", Direction = System.Data.ParameterDirection.Input, Value = solper.RefSolicitud
});
command.Parameters.Add(new MySqlParameter()
{
ParameterName = "in_refPersona", Direction = System.Data.ParameterDirection.Input, Value = solper.RefPersona
});
//command.Parameters.Add(new MySqlParameter() { ParameterName = "out_id", Direction = System.Data.ParameterDirection.Output, Value = -1 });
var datos = ContexDb.ExecuteProcedure(command);
//saber.Id = Convert.ToInt32(datos.Parameters["out_id"].Value);
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
}
/*#############################################Crear Resolucion|######################################################*/
public static int CrearResolucion(Resolucion resolucion)
{
try
{
var command = new MySqlCommand()
{
CommandText = "crear_resolucion", CommandType = System.Data.CommandType.StoredProcedure
};
command.Parameters.Add(new MySqlParameter()
{
ParameterName = "in_idResolucion", Direction = System.Data.ParameterDirection.Input, Value = resolucion.NumeroResolucion
});
command.Parameters.Add(new MySqlParameter()
{
ParameterName = "in_anio", Direction = System.Data.ParameterDirection.Input, Value = resolucion.AnioResolucion
});
command.Parameters.Add(new MySqlParameter()
{
ParameterName = "in_copiaDocumento", Direction = System.Data.ParameterDirection.Input, Value = resolucion.CopiaDocumento
});
command.Parameters.Add(new MySqlParameter()
{
ParameterName = "out_id", Direction = System.Data.ParameterDirection.Output, Value = -1
});
var datos = ContexDb.ExecuteProcedure(command);
return(Convert.ToInt32(datos.Parameters["out_id"].Value));
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
return(-1);
}
public static List <TipoOE> LeerTipoOE()
{
try
{
var command = new MySqlCommand()
{
CommandText = "Leer_TipoOE", CommandType = System.Data.CommandType.StoredProcedure
};
var datos = ContexDb.GetDataSet(command);
List <TipoOE> tipoOEs = new List <TipoOE>();
if (datos.Tables[0].Rows.Count > 0)
{
foreach (System.Data.DataRow row in datos.Tables[0].Rows)
{
var prodData = row;
var tipoOE = new TipoOE()
{
Id = Convert.ToInt32(prodData["id"]),
Nombre = prodData["nombre"].ToString(),
NombreExtendido = prodData["nombreExtendido"].ToString(),
Estado = prodData["estado"].ToString(),
EstadoEliminacion = prodData["estadoEliminacion"].ToString()
};
tipoOEs.Add(tipoOE);
}
return(tipoOEs);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
return(null);
}
public static void AgregarParticipante(Persona persona)
{
try
{
var command = new MySqlCommand()
{
CommandText = "Agregar_Participante", CommandType = System.Data.CommandType.StoredProcedure
};
command.Parameters.Add(new MySqlParameter()
{
ParameterName = "in_nombre", Direction = System.Data.ParameterDirection.Input, Value = persona.Nombre
});
command.Parameters.Add(new MySqlParameter()
{
ParameterName = "in_run", Direction = System.Data.ParameterDirection.Input, Value = persona.RUN
});
//command.Parameters.Add(new MySqlParameter() { ParameterName = "out_id", Direction = System.Data.ParameterDirection.Output, Value = -1 });
var datos = ContexDb.ExecuteProcedure(command);
//saber.Id = Convert.ToInt32(datos.Parameters["out_id"].Value);
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
}
public static int ActualizarTipoOE(int IdTipoOE, string Nombre, string NombreExtendido)
{
int result;
try
{
var command = new MySqlCommand()
{
CommandText = "Actualizar_TipoOE", CommandType = System.Data.CommandType.StoredProcedure
};
command.Parameters.Add(new MySqlParameter()
{
ParameterName = "in_id", Direction = System.Data.ParameterDirection.Input, Value = IdTipoOE
});
command.Parameters.Add(new MySqlParameter()
{
ParameterName = "in_nombre", Direction = System.Data.ParameterDirection.Input, Value = Nombre
});
command.Parameters.Add(new MySqlParameter()
{
ParameterName = "in_nombreExtendido", Direction = System.Data.ParameterDirection.Input, Value = NombreExtendido
});
var datos = ContexDb.ExecuteProcedure(command);
result = 1;
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
result = -1;
}
return(result);
}
public static List <Categoria> LeerCategorias()
{
try
{
var command = new MySqlCommand()
{
CommandText = "Leer_Categorias", CommandType = System.Data.CommandType.StoredProcedure
};
//ejemplo command.Parameters.Add(new MySqlParameter() { ParameterName = "in_id", Direction = System.Data.ParameterDirection.Input, Value = id });
var datos = ContexDb.GetDataSet(command);
List <Categoria> categorias = new List <Categoria>();
if (datos.Tables[0].Rows.Count > 0)
{
foreach (System.Data.DataRow row in datos.Tables[0].Rows)
{
var prodData = row;
var categoria = new Categoria()
{
Id = Convert.ToInt32(prodData["id"]),
Nombre = prodData["nombre"].ToString()
};
categorias.Add(categoria);
}
return(categorias);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
return(null);
}
internal static int Leer_Estado_Proceso(int idSolicitud, int proceso)
{
try
{
var command = new MySqlCommand()
{
CommandText = "leer_Estado_Proceso", CommandType = System.Data.CommandType.StoredProcedure
};
command.Parameters.Add(new MySqlParameter()
{
ParameterName = "in_proceso", Direction = System.Data.ParameterDirection.Input, Value = proceso
});
command.Parameters.Add(new MySqlParameter()
{
ParameterName = "in_id_proceso", Direction = System.Data.ParameterDirection.Input, Value = idSolicitud
});
var datos = ContexDb.GetDataSet(command);
if (datos.Tables[0].Rows.Count == 1)
{
System.Data.DataRow row = datos.Tables[0].Rows[0];
var prodData = row;
return(Convert.ToInt32(prodData["estado"].ToString()));
}
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
finally
{
}
return(-1);
}
public static Persona LeerParticipante(String refParticipante)
{
try
{
var command = new MySqlCommand()
{
CommandText = "Leer_Participante", CommandType = System.Data.CommandType.StoredProcedure
};
command.Parameters.Add(new MySqlParameter()
{
ParameterName = "in_refParticipante", Direction = System.Data.ParameterDirection.Input, Value = refParticipante
});
var datos = ContexDb.GetDataSet(command);
if (datos.Tables[0].Rows.Count == 1)
{
Persona participante;
var prodData = datos.Tables[0].Rows[0];
participante = new Persona()
{
Nombre = prodData["nombre"].ToString(),
RUN = prodData["run"].ToString(),
EstadoEdicion = Convert.ToInt32(prodData["estadoEdicion"])
};
return(participante);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
return(null);
}
public static Organizacion Leer_Organizacion(int refSolicitud)
{
try
{
var command = new MySqlCommand()
{
CommandText = "leer_organizacion", CommandType = System.Data.CommandType.StoredProcedure
};
command.Parameters.Add(new MySqlParameter()
{
ParameterName = "in_refSolicitud", Direction = System.Data.ParameterDirection.Input, Value = refSolicitud
});
var datos = ContexDb.GetDataSet(command);
if (datos.Tables[0].Rows.Count == 1)
{
System.Data.DataRow row = datos.Tables[0].Rows[0];
var prodData = row;
var organizacion = new Organizacion()
{
Id = Convert.ToInt32(prodData["id"]),
Tipo = prodData["tipo"].ToString()
};
return(organizacion);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
finally
{
}
return(null);
}
/// <summary>
/// Se encarga de eliminar una solicitud en particular y por ende elimina el proceso (Para realizar esta eliminacion, el proceso
/// no debe tener asignado una resolucion y una declaracion de gasto)
/// (1) Indica que se ha eliminado la solicitud correctamente
/// (-1) Existen problemas de conexion con la base de datos o el parametro ingresado en la variable id no es correcto
/// (-2) Aun existe la solicitud en la BD
/// </summary>
/// <param name="id"></param>
/// <returns>1, -1 o -2</returns>
public static int EliminarSolicitud(int id)
{
try
{
var command = new MySqlCommand()
{
CommandText = "Eliminar_solicitud", CommandType = System.Data.CommandType.StoredProcedure
};
command.Parameters.Add(new MySqlParameter()
{
ParameterName = "in_id", Direction = System.Data.ParameterDirection.Input, Value = id
});
command.Parameters.Add(new MySqlParameter()
{
ParameterName = "out_validacion", Direction = System.Data.ParameterDirection.Output, Value = -1
});
var datos = ContexDb.ExecuteProcedure(command);
return(Convert.ToInt32(datos.Parameters["out_validacion"].Value));
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
return(-1);
}
public static Proceso LeerEstadoProceso(Proceso Proceso)
{
try
{
var command = new MySqlCommand()
{
CommandText = "Leer_estado_proceso", CommandType = System.Data.CommandType.StoredProcedure
};
command.Parameters.Add(new MySqlParameter()
{
ParameterName = "in_idSolicitud", Direction = System.Data.ParameterDirection.Input, Value = Proceso.Solicitud.Id
});
var datos = ContexDb.GetDataSet(command);
if (datos.Tables[0].Rows.Count == 1)
{
var prodData = datos.Tables[0].Rows[0];
Proceso.Estado = Convert.ToInt32(prodData["estado"]);
Proceso.EstadoFinal = prodData["estadoFinal"].ToString();
}
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
return(Proceso);
}
