private DataTable ExecuteTransaction(string procedureName, List <SqlParameter> ps)
{
DBTransaction db = new DBTransaction();
DataTable dt = db.GetStoreProcedure(procedureName, ps);
return(dt);
}
public int InsDenunciante()
{
List <SqlParameter> ps = new List <SqlParameter>();
DBTransaction db = new DBTransaction();
ps.Add(new SqlParameter("@ComplaintId", this.ComplaintId));
ps.Add(new SqlParameter("@Name", this.Denunciante.Name));
ps.Add(new SqlParameter("@SecondName", this.Denunciante.SecondName));
ps.Add(new SqlParameter("@LastName", this.Denunciante.LastName));
ps.Add(new SqlParameter("@SecondLastName", this.Denunciante.SecondLastName));
ps.Add(new SqlParameter("@NroDocument", this.Denunciante.NroDocument));
ps.Add(new SqlParameter("@ParameterExtent", this.Denunciante.ParameterExtent));
ps.Add(new SqlParameter("@ParameterGender", this.Denunciante.ParameterGender));
ps.Add(new SqlParameter("@BirthDate", this.Denunciante.BirthDate));
ps.Add(new SqlParameter("@ParameterCivilStatus", this.Denunciante.ParameterCivilStatus));
ps.Add(new SqlParameter("@ParameterNationality", this.Denunciante.ParameterNationality));
ps.Add(new SqlParameter("@Address", this.Denunciante.Address));
ps.Add(new SqlParameter("@Phone", this.Denunciante.Phone));
ps.Add(new SqlParameter("@Occupation", this.Denunciante.Occupation));
ps.Add(new SqlParameter("@Workplace", this.Denunciante.Workplace));
ps.Add(new SqlParameter("@WPhone", this.Denunciante.wPhone));
ps.Add(new SqlParameter("@WAddress", this.Denunciante.wAddress));
DataTable dt = db.GetStoreProcedure("den.InsDenunciante", ps);
return(Convert.ToInt32(dt.Rows[0]["ComplainantId"]));
}
public static List <Cronograma> GetCronogramaConjunto(int deporteId, Nullable <DateTime> fecha, int eventoId)
{
List <Cronograma> lcr = new List <Cronograma>();
DBTransaction db = new DBTransaction();
List <SqlParameter> ps = new List <SqlParameter>();
ps.Add(new SqlParameter("DeporteId", deporteId));
if (fecha != null)
{
ps.Add(new SqlParameter("Fecha", fecha.Value.ToShortDateString()));
}
ps.Add(new SqlParameter("EventoId", eventoId));
DataTable dt = db.GetStoreProcedure("conj.pGetCronogramaConjunto", ps);
foreach (DataRow dr in dt.Rows)
{
Cronograma cr = ConvertToCronogramas(dr);
cr.CronogramaCompetidor = new List <CronogramaCompetidor>();
CronogramaCompetidor cc = new CronogramaCompetidor();
cc = HamGeneric.CronogramaCompetidor.GetCronogramaCompetidor(Convert.ToInt32(dr["CompetidorA"]), cr.EventoId);
cr.CronogramaCompetidor.Add(cc);
cc = HamGeneric.CronogramaCompetidor.GetCronogramaCompetidor(Convert.ToInt32(dr["CompetidorB"]), cr.EventoId);
cr.CronogramaCompetidor.Add(cc);
cr.Instalacion = cr.InstalacionId != 0 ? Instalacion.GetInstalacion(cr.InstalacionId) : new Instalacion();
lcr.Add(cr);
}
return(lcr);
}
public static DataTable GetSecUsuarios()
{
DBTransaction db = new DBTransaction();
List <SqlParameter> ps = new List <SqlParameter>();
return(db.GetStoreProcedure("[pSMGetUsuarios]", ps));
}
public static DataTable GetTotales(int grupoId)
{
DBTransaction db = new DBTransaction();
List <SqlParameter> ps = new List <SqlParameter>();
ps.Add(new SqlParameter("grupoId", grupoId));
return(db.GetStoreProcedure("golf.pCalcularNeto", ps));
}
public static DataTable GetHCPporciento(int competidorId)
{
DBTransaction db = new DBTransaction();
List <SqlParameter> ps = new List <SqlParameter>();
ps.Add(new SqlParameter("CompetidorId", competidorId));
return(db.GetStoreProcedure("pGolfGetHCPporciento", ps));
}
public static DataTable GetListaSHCP(int jornadaId, int categoriaId)
{
DBTransaction db = new DBTransaction();
List <SqlParameter> ps = new List <SqlParameter>();
ps.Add(new SqlParameter("JornadaId", jornadaId));
ps.Add(new SqlParameter("CategoriaId", categoriaId));
return(db.GetStoreProcedure("pgolfTablaClasificatoriasSHCP", ps));
}
public static DataTable GetCredencialDatosPrivilegios(int personaId, int eventoId)
{
DBTransaction db = new DBTransaction();
List <SqlParameter> ps = new List <SqlParameter>();
ps.Add(new SqlParameter("PersonaId", personaId));
ps.Add(new SqlParameter("EventoId", eventoId));
return(db.GetStoreProcedure("acre.pCredencialDatosPrivilegios", ps));
}
public static DataTable GetResultadoCompetidor(int jornaId, int personaId)
{
DBTransaction db = new DBTransaction();
List <SqlParameter> ps = new List <SqlParameter>();
ps.Add(new SqlParameter("JornadaId", jornaId));
ps.Add(new SqlParameter("PersonaId", personaId));
return(db.GetStoreProcedure("[golf].[pResultadosCompetidor]", ps));
}
public DataTable EliminarPunto()
{
DBTransaction db = new DBTransaction();
List <SqlParameter> ps = new List <SqlParameter>();
ps.Add(new SqlParameter("PuntoId", PuntoId));
return(db.GetStoreProcedure("[tarc].[pDelPuntos]", ps));
}
public static DataTable GetCompetidoresGrupos(int jornadaId, int categoriaId)
{
DBTransaction db = new DBTransaction();
List <SqlParameter> ps = new List <SqlParameter>();
ps.Add(new SqlParameter("JornadaId", jornadaId));
ps.Add(new SqlParameter("CategoriaId", categoriaId));
return(db.GetStoreProcedure("[golf].[pListadoGruposPersonas]", ps));
}
public static DataTable GetTypeCrimen()
{
DataTable dt = new DataTable();
DBTransaction db = new DBTransaction();
List <SqlParameter> ls = new List <SqlParameter>();
ls.Add(new SqlParameter("@TypeCrimenId", 1));
dt = db.GetStoreProcedure("den.GetTypeCrimen", ls);
return(dt);
}
public static DataTable GetParametroFinalPeriodo(int deporteId)
{
DataTable dt = new DataTable();
DBTransaction db = new DBTransaction();
List <SqlParameter> ls = new List <SqlParameter>();
ls.Add(new SqlParameter("DeporteId", deporteId));
dt = db.GetStoreProcedure("[conj].[pGetFinalPeriodosId]", ls);
return(dt);
}
public int savePlanilla()
{
DBTransaction db = new DBTransaction();
List <SqlParameter> ps = new List <SqlParameter>();
ps.Add(new SqlParameter("CronogramaId", CronogramaId));
var resultado = db.GetStoreProcedure("[tarc].[pInsPlanilla]", ps).Rows[0]["Resultado"];
return(Convert.ToInt32(resultado));
}
public static int deleteCompetidor(int LeccionCompetidorId)
{
DBTransaction db = new DBTransaction();
List <SqlParameter> ps = new List <SqlParameter>();
ps.Add(new SqlParameter("LeccionCompetidorId", LeccionCompetidorId));
var resultado = db.GetStoreProcedure("[ecue].[pDelLeccionCompetidor]", ps).Rows[0]["Resultado"];
return(Convert.ToInt32(resultado));
}
public static DataTable GetMedalleroGeneral(int eventoId)
{
DataTable dt = new DataTable();
DBTransaction db = new DBTransaction();
List <SqlParameter> lp = new List <SqlParameter>();
lp.Add(new SqlParameter("EventoId", eventoId));
dt = db.GetStoreProcedure("prog.pGetMedalleroGeneral", lp);
return(dt);
}
public static DataTable GetPlanillaAtletismo(int pruebaEventoId)
{
DBTransaction db = new DBTransaction();
List <SqlParameter> lp = new List <SqlParameter>();
lp.Add(new SqlParameter("PruebaEventoId", pruebaEventoId));
DataTable td = db.GetStoreProcedure("indv.pGetPlanillaMiniAtletismo", lp);
return(td);
}
public static DataTable GetNroJornadas(int eventoId)
{
DBTransaction db = new DBTransaction();
List <SqlParameter> ps = new List <SqlParameter>();
ps.Add(new SqlParameter("EventoId", eventoId));
var respuesta = db.GetStoreProcedure("[golf].[pGetNroJonadasByEvento]", ps);
return(respuesta);
}
public DataTable cerrarPeriodo()
{
DBTransaction db = new DBTransaction();
List <SqlParameter> ps = new List <SqlParameter>();
ps.Add(new SqlParameter("PlanillaId", PlanillaId));
ps.Add(new SqlParameter("PeriodoId", PeriodoId));
return(db.GetStoreProcedure("[tarc].[pUpdPeriodos ]", ps));
}
public static DataTable GetResultadoConjuntoVs(int cronogramaId)
{
DataTable dt = new DataTable();
DBTransaction db = new DBTransaction();
List <SqlParameter> ls = new List <SqlParameter>();
ls.Add(new SqlParameter("CronogramaId", cronogramaId));
dt = db.GetStoreProcedure("[conj].[pGetResultadoConjuntoVs]", ls);
return(dt);
}
public static DataTable GetCalendarioEvento(int eventoId)
{
DataTable dt = new DataTable();
DBTransaction db = new DBTransaction();
List <SqlParameter> ls = new List <SqlParameter>();
ls.Add(new SqlParameter("EventoId", eventoId));
dt = db.GetStoreProcedure("[prog].[pGetCalendarioEvento]", ls);
return(dt);
}
public static DataTable GetResultadosWeb(int cronogramaId, int deporteId)
{
DataTable dt = new DataTable();
DBTransaction db = new DBTransaction();
List <SqlParameter> ls = new List <SqlParameter>();
ls.Add(new SqlParameter("_CronogramaId", cronogramaId));
ls.Add(new SqlParameter("_DeporteId", deporteId));
dt = db.GetStoreProcedure("[conj].[pGetResultadoWeb]", ls);
return(dt);
}
public static DataTable BusquedaCompetidores(string search, int cronogramaId)
{
DataTable dt = new DataTable();
DBTransaction db = new DBTransaction();
List <SqlParameter> ls = new List <SqlParameter>();
ls.Add(new SqlParameter("Search", search));
ls.Add(new SqlParameter("CronogramaId", cronogramaId));
dt = db.GetStoreProcedure("[indv].[pSearchCompetidor]", ls);
return(dt);
}
public static DataTable GetPersonaPrueba(int eventoId, int personaId)
{
DataTable dt = new DataTable();
DBTransaction db = new DBTransaction();
List <SqlParameter> ls = new List <SqlParameter>();
ls.Add(new SqlParameter("EventoId", eventoId));
ls.Add(new SqlParameter("PersonaId", personaId));
dt = db.GetStoreProcedure("[acre].[pGetPersonaPruebas]", ls);
return(dt);
}
public static DataTable GetTarijeta(int competidorJornadaId1, int competidorJornadaId2, int competidorJornadaId3, int competidorJornadaId4)
{
DBTransaction db = new DBTransaction();
List <SqlParameter> ps = new List <SqlParameter>();
ps.Add(new SqlParameter("CompetidorJornadaId1", competidorJornadaId1));
ps.Add(new SqlParameter("CompetidorJornadaId2", competidorJornadaId2));
ps.Add(new SqlParameter("CompetidorJornadaId3", competidorJornadaId3));
ps.Add(new SqlParameter("CompetidorJornadaId4", competidorJornadaId4));
return(db.GetStoreProcedure("[golf].[pGetTarjetaCompetidores]", ps));
}
public static DataTable GetProgramacionInstalaciones(int eventoId, int instalacionId)
{
DataTable dt = new DataTable();
DBTransaction db = new DBTransaction();
List <SqlParameter> ls = new List <SqlParameter>();
ls.Add(new SqlParameter("EventoId", eventoId));
ls.Add(new SqlParameter("InstalacionId", instalacionId));
dt = db.GetStoreProcedure("[prog].[pGetProgramacionInstalaciones]", ls);
return(dt);
}
private bool ExecuteTransaction(string procedureName, List <SqlParameter> ps)
{
DBTransaction db = new DBTransaction();
DataTable dt = db.GetStoreProcedure(procedureName, ps);
if (dt.Rows.Count > 0)
{
this.CompetidorId = Convert.ToInt32(dt.Rows[0]["Resultado"]);
}
return(this.CompetidorId > 0);
}
private bool ExecuteTransaction(string procedureName, List <SqlParameter> ps)
{
DBTransaction db = new DBTransaction();
DataTable dt = db.GetStoreProcedure(procedureName, ps);
if (dt.Rows.Count > 0)
{
PersonaId = Convert.ToInt32(dt.Rows[0][0]);
}
return(PersonaId > 0);
}
public static DataTable GetUltimoCronogramaId(int eventoId, int deporteId)
{
DataTable dt = new DataTable();
DBTransaction db = new DBTransaction();
List <SqlParameter> ls = new List <SqlParameter>();
ls.Add(new SqlParameter("EventoId", eventoId));
ls.Add(new SqlParameter("DeporteId", deporteId));
dt = db.GetStoreProcedure("conj.pGetUltimoCronogramaId", ls);
return(dt);
}
public static DataTable GetInscripcionEnventoDelegacion(int EventoId, int DelegacionId)
{
DBTransaction db = new DBTransaction();
//DataTable dt = db.GetDataView(string.Format("[acre].[vAcreditacionDetallePersona] where [EventoId]= {0} and DelegacionId = {1}", EventoId, DelegacionId));
List <SqlParameter> ps = new List <SqlParameter>();
ps.Add(new SqlParameter("EventoId", EventoId));
ps.Add(new SqlParameter("DelegacionId", DelegacionId));
DataTable dt = db.GetStoreProcedure("[acre].[pInscritosDelegacion]", ps);
return(dt);
}