private bool ExecuteTransaction(string procedureName) { DBTransaction db = new DBTransaction(); List <SqlParameter> ps = new List <SqlParameter>(); ps.Add(new SqlParameter("Usuario", Usuario)); ps.Add(new SqlParameter("Password", Password)); ps.Add(new SqlParameter("OficinaId", OficinaId)); ps.Add(new SqlParameter("IsActivo", IsActivo)); ps.Add(new SqlParameter("PersonaId", PersonaId)); if (procedureName == "pSMInsertUsuario") { db.ExecStoreProcedure(procedureName, ps); } if ((procedureName == "pSMUpdateUsuario") || (procedureName == "pSMDeleteUsuario")) { ps.Add(new SqlParameter("UsuarioId", UsuarioId)); db.ExecStoreProcedure(procedureName, ps); } return(db.RowAffected > 0); }
public bool SaveCronograma() { DataTable dt = new DataTable(); DBTransaction db = new DBTransaction(); List <SqlParameter> ls = new List <SqlParameter>(); ls.Add(new SqlParameter("EventoId", this.EventoId)); ls.Add(new SqlParameter("DeporteId", this.DeporteId)); ls.Add(new SqlParameter("PruebaId", this.PruebaId)); ls.Add(new SqlParameter("ParametroRamaId", this.ParametroRamaId)); ls.Add(new SqlParameter("ParametroFaseId", this.ParametroFaseId)); ls.Add(new SqlParameter("InstalacionId", this.InstalacionId)); ls.Add(new SqlParameter("Fecha", this.Fecha)); ls.Add(new SqlParameter("HoraProgramada", this.HoraProgramada)); // ls.Add(new SqlParameter("FaseId", this.FaseId)); ls.Add(new SqlParameter("ParametroTipoId", this.ParametroTipoId)); ls.Add(new SqlParameter("AreaInstalacionId", this.AreaInstalacionId)); ls.Add(new SqlParameter("Descripcion", this.Descripcion)); if (this.CronogramaId == 0) { db.ExecStoreProcedure("prog.pInsCronograma", ls); } else { ls.Add(new SqlParameter("CronogramaId", this.CronogramaId)); db.ExecStoreProcedure("[prog].[pUpCronograma]", ls); } return(db.RowAffected > 1 ? true: false); }
public bool SaveEquipo() { DataTable dt = new DataTable(); DBTransaction db = new DBTransaction(); List <SqlParameter> lp = new List <SqlParameter>(); lp.Add(new SqlParameter("Equipo", Equipo.ToUpper())); lp.Add(new SqlParameter("DelegacionId", DelegacionId)); lp.Add(new SqlParameter("PruebaId", PruebaId)); lp.Add(new SqlParameter("ParametroRamaId", ParametroRamaId)); lp.Add(new SqlParameter("EventoId", EventoId)); if (this.EquipoId == 0) { db.ExecStoreProcedure("[acre].[pInsEquipo]", lp); } else { lp.Clear(); lp.Add(new SqlParameter("EquipoId", this.EquipoId)); lp.Add(new SqlParameter("Equipo", Equipo.ToUpper())); lp.Add(new SqlParameter("DelegacionId", DelegacionId)); lp.Add(new SqlParameter("PruebaEventoId", PruebaEventoId)); db.ExecStoreProcedure("[acre].[pUpdEquipos]", lp); } return(db.RowAffected > 1 ? true : false); }
private bool ExecuteTransaction(string procedureName, List <SqlParameter> ps) { DBTransaction db = new DBTransaction(); db.ExecStoreProcedure(procedureName, ps); return(db.RowAffected > 0); }
public bool DeleteInscrito(int CompetidorId) { DBTransaction db = new DBTransaction(); List <SqlParameter> ps = new List <SqlParameter>(); ps.Add(new SqlParameter("CompetidorId", CompetidorId)); db.ExecStoreProcedure("[golf].[pDeleteCompetidor]", ps); return(db.RowAffected > 0); }
//eliminar usuario public bool DeleteU(int usuarioId) { DBTransaction db = new DBTransaction(); List <SqlParameter> ps = new List <SqlParameter>(); ps.Add(new SqlParameter("usuarioId", usuarioId)); db.ExecStoreProcedure("[erp].[pDelUsuario]", ps); return(db.RowAffected > 0); }
public bool Delete(int competidorId) { DBTransaction db = new DBTransaction(); List <SqlParameter> ps = new List <SqlParameter>(); ps.Add(new SqlParameter("CompetidorId", competidorId)); db.ExecStoreProcedure("pDelCompetidor", ps); return(db.RowAffected > 0); }
public bool Delete(int jornadaId) { DBTransaction db = new DBTransaction(); List <SqlParameter> ps = new List <SqlParameter>(); ps.Add(new SqlParameter("JornadaId", jornadaId)); db.ExecStoreProcedure("[golf].[pDeleteJornada]", ps); return(db.RowAffected > 0); }
public static bool DeletePuntaje(int competidorJornadaId) { DBTransaction db = new DBTransaction(); List <SqlParameter> ps = new List <SqlParameter>(); ps.Add(new SqlParameter("CompetidorJornadaId", competidorJornadaId)); db.ExecStoreProcedure("[golf].[pDeleteJugadas]", ps); return(db.RowAffected > 0); }
public bool Insert() { DBTransaction db = new DBTransaction(); List <SqlParameter> ps = new List <SqlParameter>(); ps = SetParameters(ps); db.ExecStoreProcedure("[golf].[pInsCompetidor]", ps); return(db.RowAffected > 0); }
public static bool DeleteEquipo(int equipoId) { DBTransaction db = new DBTransaction(); List <SqlParameter> ls = new List <SqlParameter>(); ls.Add(new SqlParameter("EquipoId", equipoId)); db.ExecStoreProcedure("[acre].[pDelEquipos]", ls); return(db.RowAffected > 0); }
public bool UpdateEstado() { DBTransaction db = new DBTransaction(); List <SqlParameter> ps = new List <SqlParameter>(); ps = SetParameters(ps); db.ExecStoreProcedure("[golf].[pUpdEstadoTarjeta]", ps); return(db.RowAffected > 0); }
public static bool Delete(int grupoId) { DBTransaction db = new DBTransaction(); List <SqlParameter> ps = new List <SqlParameter>(); ps.Add(new SqlParameter("GrupoId", grupoId)); db.ExecStoreProcedure("[golf].[pDeleteGrupo]", ps); return(db.RowAffected > 0); }
public static bool CambiarEstado(int competidorJornadaId) { DBTransaction db = new DBTransaction(); List <SqlParameter> ps = new List <SqlParameter>(); ps.Add(new SqlParameter("CompetidorJornadaId", competidorJornadaId)); db.ExecStoreProcedure("[golf].[pEstadoCompetidorJornada]", ps); return(db.RowAffected > 0); }
public static bool DeleteCronograma(int cronogramaId) { DBTransaction db = new DBTransaction(); List <SqlParameter> ls = new List <SqlParameter>(); ls.Add(new SqlParameter("CronogramaId", cronogramaId)); db.ExecStoreProcedure("[prog].[pDelCronograma]", ls); return(db.RowAffected > 0); }
public static bool DeleteCronogramaCompetidor(int cronogramaId, int competidorId) { DBTransaction db = new DBTransaction(); List <SqlParameter> ps = new List <SqlParameter>(); ps.Add(new SqlParameter("CronogramaId", cronogramaId)); ps.Add(new SqlParameter("CompetidorId", competidorId)); db.ExecStoreProcedure("[indv].[pDelCronogramaCompetidor]", ps); return(db.RowAffected > 0); }
public static bool DeleteGrupo(int GrupoId) { DBTransaction db = new DBTransaction(); List <SqlParameter> ls = new List <SqlParameter> { new SqlParameter("GrupoId", GrupoId) }; db.ExecStoreProcedure("[prog].[pDelGrupos]", ls); return(db.RowAffected > 0); }
public bool Update() { DBTransaction db = new DBTransaction(); List <SqlParameter> ps = new List <SqlParameter>(); ps = SetParameters(ps); ps.Add(new SqlParameter("Estado", Estado)); db.ExecStoreProcedure("pgolfUpCompetidorJornada", ps); return(db.RowAffected > 0); }
public static bool UpdateCronogramaEstado(int cronogramaId, int estadoId) { DBTransaction db = new DBTransaction(); List <SqlParameter> ls = new List <SqlParameter>(); ls.Add(new SqlParameter("CronogramaId", cronogramaId)); ls.Add(new SqlParameter("Estado", estadoId)); db.ExecStoreProcedure("[prog].[pUpEstadoCronograma]", ls); return(db.RowAffected > 0); }
public bool ActualizarPassword() { DBTransaction db = new DBTransaction(); List <SqlParameter> ps = new List <SqlParameter>(); ps.Add(new SqlParameter("Password", Password)); ps.Add(new SqlParameter("UsuarioId", UsuarioId)); db.ExecStoreProcedure("erp.pUpPassword", ps); return(db.RowAffected > 0); }
public int UpdateEstado() { List <SqlParameter> ps = new List <SqlParameter>(); ps.Add(new SqlParameter("CompetidorId", CompetidorId)); ps.Add(new SqlParameter("Activo", Activo)); DBTransaction db = new DBTransaction(); db.ExecStoreProcedure("indv.pUpEstadoCompetidor", ps); return(db.RowAffected); }
public int SaveEquipoGrupo() { List <SqlParameter> lp = new List <SqlParameter>(); lp.Add(new SqlParameter("GrupoId", GrupoId)); lp.Add(new SqlParameter("EquipoId", EquipoId)); lp.Add(new SqlParameter("Orden", Orden)); DBTransaction db = new DBTransaction(); db.ExecStoreProcedure("prog.pUpEquipoGrupo", lp); return(db.RowAffected); }
public static bool CreateFixture(int eventoId, int deporteId, int parametroRamaId) { List <SqlParameter> ls = new List <SqlParameter>(); ls.Add(new SqlParameter("EventoId", eventoId)); ls.Add(new SqlParameter("DeporteId", deporteId)); ls.Add(new SqlParameter("ParametroRamaId", parametroRamaId)); DBTransaction db = new DBTransaction(); db.ExecStoreProcedure("[prog].[pCreacionFixture]", ls); return(db.RowAffected > 0); }
// actualizar Usuarios public bool Guardar() { DBTransaction db = new DBTransaction(); List <SqlParameter> ps = new List <SqlParameter>(); ps.Add(new SqlParameter("UsuarioId", UsuarioId)); ps.Add(new SqlParameter("Usuario", Username)); ps.Add(new SqlParameter("contraseña", DBSecurity.Encriptar(Password))); ps.Add(new SqlParameter("IsActivo", IsActivo)); db.ExecStoreProcedure("[erp].[pUpUsuarios]", ps); return(db.RowAffected > 0); }
public static int Llamado(int IDticket) { string procedimiento; List <SqlParameter> ps = new List <SqlParameter>(); ps.Add(new SqlParameter("TicketId", IDticket)); procedimiento = "erp.pUpTicket"; DBTransaction db = new DBTransaction(); db.ExecStoreProcedure(procedimiento, ps); return(db.RowAffected); }
public bool AddUsuario() { DBTransaction db = new DBTransaction(); List <SqlParameter> ps = new List <SqlParameter>(); ps.Add(new SqlParameter("Username", Username)); ps.Add(new SqlParameter("Password", Password)); ps.Add(new SqlParameter("OficinaId", OficinaId)); ps.Add(new SqlParameter("IsActivo", IsActivo)); ps.Add(new SqlParameter("PersonaId", PersonaId)); db.ExecStoreProcedure("dbo.pInsUsuarios", ps); return(db.RowAffected > 0); }
public bool SaveEquipoPersona() { DataTable dt = new DataTable(); DBTransaction db = new DBTransaction(); List <SqlParameter> lp = new List <SqlParameter>(); lp.Add(new SqlParameter("EquipoId", EquipoId)); lp.Add(new SqlParameter("PersonaId", PersonaId)); lp.Add(new SqlParameter("Posicion", Posicion)); lp.Add(new SqlParameter("NroCamiseta", NroCamiseta)); db.ExecStoreProcedure("[acre].[pInsEquipoPersona]", lp); return(db.RowAffected > 0); }
public static int Cerrar(Ticket tt) { string procedimiento; List <SqlParameter> ps = new List <SqlParameter>(); ps.Add(new SqlParameter("tickeId", tt.Id)); ps.Add(new SqlParameter("tiempo", tt.tiempo)); ps.Add(new SqlParameter("servi", tt.servicio)); procedimiento = "erp.pUpCerrar"; DBTransaction db = new DBTransaction(); db.ExecStoreProcedure(procedimiento, ps); return(db.RowAffected); }
public static int SetTicket(string f, string h, int n) { string procedimiento; List <SqlParameter> ps = new List <SqlParameter>(); ps.Add(new SqlParameter("Fecha", DateTime.Now)); ps.Add(new SqlParameter("Hora", DateTime.Now)); ps.Add(new SqlParameter("Numero", n)); ps.Add(new SqlParameter("Estado", "0")); procedimiento = "erp.pInsTicket"; DBTransaction db = new DBTransaction(); db.ExecStoreProcedure(procedimiento, ps); return(db.RowAffected); }
public static bool UpdateCronograma(int cronogramaId, int competidorId, string posicion, int parametromedallaId, int Sembrado, decimal marca, int esGanador, bool esRecord, string tiempo) { DBTransaction db = new DBTransaction(); List <SqlParameter> ls = new List <SqlParameter>(); ls.Add(new SqlParameter("CronogramaId", cronogramaId)); ls.Add(new SqlParameter("CompetidorId", competidorId)); ls.Add(new SqlParameter("Posicion", posicion)); ls.Add(new SqlParameter("ParametroMedallaId", parametromedallaId)); ls.Add(new SqlParameter("Sembrado", Sembrado)); ls.Add(new SqlParameter("Tiempo", tiempo)); ls.Add(new SqlParameter("Marca", marca)); ls.Add(new SqlParameter("EsGanador", esGanador)); ls.Add(new SqlParameter("EsRecord", esRecord)); db.ExecStoreProcedure("[indv].[pUpCronogramaCompetidor]", ls); return(db.RowAffected > 0); }