public string EliminarTipo(string IdTipo) { string r = ""; using (SqlConnection conn = DataContext.GetConnection()) { var listaParams = new List <SqlParameter>(); listaParams.Add(new SqlParameter("@IdTipo", SqlDbType.VarChar) { Direction = ParameterDirection.Input, Value = IdTipo }); r = SQLHelper.ExecuteScalar(conn, System.Data.CommandType.StoredProcedure, @"Sp_TipoEliminar", listaParams.ToArray()).ToString(); } return(r); }
public string EliminarSalon(int IdSalon, int Accion) { string r = ""; using (SqlConnection conn = DataContext.GetConnection()) { var listaParams = new List <SqlParameter>(); listaParams.Add(new SqlParameter("@IdSalon", SqlDbType.Int) { Direction = ParameterDirection.Input, Value = IdSalon }); listaParams.Add(new SqlParameter("@Accion", SqlDbType.Int) { Direction = ParameterDirection.Input, Value = Accion }); r = SQLHelper.ExecuteScalar(conn, System.Data.CommandType.StoredProcedure, @"Sp_SalonEliminar", listaParams.ToArray()).ToString(); } return(r); }
public string MantenimientoDigitalizacion(Digitalizacion objDigitalizacion) { string r = ""; using (SqlConnection conn = DataContext.GetConnection()) { var listaParams = new List <SqlParameter>(); listaParams.Add(new SqlParameter("@IdPersona", SqlDbType.VarChar) { Direction = ParameterDirection.Input, Value = objDigitalizacion.IdPersona }); listaParams.Add(new SqlParameter("@FechaVencimiento", SqlDbType.DateTime) { Direction = ParameterDirection.Input, Value = objDigitalizacion.FechaVencimiento }); listaParams.Add(new SqlParameter("@IdDigitalizacion", SqlDbType.VarChar) { Direction = ParameterDirection.Input, Value = objDigitalizacion.IdDigitalizacion }); listaParams.Add(new SqlParameter("@IdDocumento", SqlDbType.VarChar) { Direction = ParameterDirection.Input, Value = objDigitalizacion.IdDocumento }); listaParams.Add(new SqlParameter("@Observacion", SqlDbType.VarChar) { Direction = ParameterDirection.Input, Value = objDigitalizacion.Observacion }); listaParams.Add(new SqlParameter("@IdEstado", SqlDbType.VarChar) { Direction = ParameterDirection.Input, Value = objDigitalizacion.IdEstado }); listaParams.Add(new SqlParameter("@Opcion", SqlDbType.VarChar) { Direction = ParameterDirection.Input, Value = objDigitalizacion.Opcion }); listaParams.Add(new SqlParameter("@IdUsuario", SqlDbType.VarChar) { Direction = ParameterDirection.Input, Value = objDigitalizacion.IdUsuario }); r = SQLHelper.ExecuteScalar(conn, System.Data.CommandType.StoredProcedure, @"Sp_DigitalizacionMantenimiento", listaParams.ToArray()).ToString(); } return(r); }
public string MantenimientoUsuario(Usuario objUsuariop) { string r = ""; using (SqlConnection conn = DataContext.GetConnection()) { var listaParams = new List <SqlParameter>(); listaParams.Add(new SqlParameter("@IdUsuario", SqlDbType.VarChar) { Direction = ParameterDirection.Input, Value = objUsuariop.IdUsuario }); listaParams.Add(new SqlParameter("@IdPerfil", SqlDbType.VarChar) { Direction = ParameterDirection.Input, Value = objUsuariop.IdPerfil }); listaParams.Add(new SqlParameter("@IdPersona", SqlDbType.VarChar) { Direction = ParameterDirection.Input, Value = objUsuariop.IdPersona }); listaParams.Add(new SqlParameter("@Password", SqlDbType.VarChar) { Direction = ParameterDirection.Input, Value = objUsuariop.Password }); listaParams.Add(new SqlParameter("@Usuario", SqlDbType.VarChar) { Direction = ParameterDirection.Input, Value = objUsuariop.Usuarios }); listaParams.Add(new SqlParameter("@Correo", SqlDbType.VarChar) { Direction = ParameterDirection.Input, Value = objUsuariop.Correo }); listaParams.Add(new SqlParameter("@IdEmpresa", SqlDbType.VarChar) { Direction = ParameterDirection.Input, Value = objUsuariop.IdEmpresa }); listaParams.Add(new SqlParameter("@IdEstado", SqlDbType.VarChar) { Direction = ParameterDirection.Input, Value = objUsuariop.IdEstado }); r = SQLHelper.ExecuteScalar(conn, System.Data.CommandType.StoredProcedure, @"Sp_UsuarioMantenimiento", listaParams.ToArray()).ToString(); } return(r); }
public string EliminarTarjetaColaborador(ColaboradorTiposDto objColaboradorTiposDto) { string r = ""; using (SqlConnection conn = DataContext.GetConnection()) { var listaParams = new List <SqlParameter>(); listaParams.Add(new SqlParameter("@IdTipo", SqlDbType.VarChar) { Direction = ParameterDirection.Input, Value = objColaboradorTiposDto.IdTipo }); listaParams.Add(new SqlParameter("@IdPersona", SqlDbType.VarChar) { Direction = ParameterDirection.Input, Value = objColaboradorTiposDto.IdPersona }); listaParams.Add(new SqlParameter("@Nombre", SqlDbType.VarChar) { Direction = ParameterDirection.Input, Value = objColaboradorTiposDto.Nombre }); r = SQLHelper.ExecuteScalar(conn, System.Data.CommandType.StoredProcedure, @"Sp_ColaboradorTarjetaEliminar", listaParams.ToArray()).ToString(); } return(r); }
public string MantenimientoColaborador(Colaborador objColaboradorp) { string r = ""; using (SqlConnection conn = DataContext.GetConnection()) { var listaParams = new List <SqlParameter>(); listaParams.Add(new SqlParameter("@IdColaborador", SqlDbType.VarChar) { Direction = ParameterDirection.Input, Value = objColaboradorp.IdColaborador }); listaParams.Add(new SqlParameter("@IdPersona", SqlDbType.VarChar) { Direction = ParameterDirection.Input, Value = objColaboradorp.IdPersona }); listaParams.Add(new SqlParameter("@Nombres", SqlDbType.VarChar) { Direction = ParameterDirection.Input, Value = objColaboradorp.Nombre }); listaParams.Add(new SqlParameter("@ApellidoMaterno", SqlDbType.VarChar) { Direction = ParameterDirection.Input, Value = objColaboradorp.ApellidoMaterno }); listaParams.Add(new SqlParameter("@ApellidoPaterno", SqlDbType.VarChar) { Direction = ParameterDirection.Input, Value = objColaboradorp.ApellidoPaterno }); listaParams.Add(new SqlParameter("@IdDepartamento", SqlDbType.VarChar) { Direction = ParameterDirection.Input, Value = objColaboradorp.IdDepartamento }); listaParams.Add(new SqlParameter("@IdUbicacion", SqlDbType.VarChar) { Direction = ParameterDirection.Input, Value = objColaboradorp.IdUbicacion }); listaParams.Add(new SqlParameter("@FechaNacimiento", SqlDbType.VarChar) { Direction = ParameterDirection.Input, Value = objColaboradorp.FechaNacimiento }); listaParams.Add(new SqlParameter("@Genero", SqlDbType.VarChar) { Direction = ParameterDirection.Input, Value = objColaboradorp.Sexo }); listaParams.Add(new SqlParameter("@IdEmpresa", SqlDbType.VarChar) { Direction = ParameterDirection.Input, Value = objColaboradorp.IdEmpresa }); listaParams.Add(new SqlParameter("@Foto", SqlDbType.VarChar) { Direction = ParameterDirection.Input, Value = objColaboradorp.Foto }); //listaParams.Add(new SqlParameter("@Tarjeta", SqlDbType.VarChar) { Direction = ParameterDirection.Input, Value = objColaboradorp.Tarjeta }); listaParams.Add(new SqlParameter("@IdUDepartamento", SqlDbType.VarChar) { Direction = ParameterDirection.Input, Value = objColaboradorp.IdUDepartamento }); listaParams.Add(new SqlParameter("@IdProvincia", SqlDbType.VarChar) { Direction = ParameterDirection.Input, Value = objColaboradorp.IdProvincia }); listaParams.Add(new SqlParameter("@IdDistrito", SqlDbType.VarChar) { Direction = ParameterDirection.Input, Value = objColaboradorp.IdDistrito }); listaParams.Add(new SqlParameter("@IdCondicion", SqlDbType.VarChar) { Direction = ParameterDirection.Input, Value = objColaboradorp.IdCondicion }); listaParams.Add(new SqlParameter("@Direccion", SqlDbType.VarChar) { Direction = ParameterDirection.Input, Value = objColaboradorp.Direccion }); listaParams.Add(new SqlParameter("@NumeroDocumento", SqlDbType.VarChar) { Direction = ParameterDirection.Input, Value = objColaboradorp.NumeroDocumento }); listaParams.Add(new SqlParameter("@IdCategoria", SqlDbType.VarChar) { Direction = ParameterDirection.Input, Value = objColaboradorp.IdCategoria }); listaParams.Add(new SqlParameter("@Alias", SqlDbType.VarChar) { Direction = ParameterDirection.Input, Value = objColaboradorp.Alias }); listaParams.Add(new SqlParameter("@IdEstado", SqlDbType.VarChar) { Direction = ParameterDirection.Input, Value = objColaboradorp.IdEstado }); listaParams.Add(new SqlParameter("@IdArea", SqlDbType.VarChar) { Direction = ParameterDirection.Input, Value = objColaboradorp.IdArea }); listaParams.Add(new SqlParameter("@IdTipoLugar", SqlDbType.VarChar) { Direction = ParameterDirection.Input, Value = objColaboradorp.IdTipoLugar }); listaParams.Add(new SqlParameter("@Descripcion", SqlDbType.VarChar) { Direction = ParameterDirection.Input, Value = objColaboradorp.Descripcion }); r = SQLHelper.ExecuteScalar(conn, System.Data.CommandType.StoredProcedure, @"Sp_ColaboradorMantenimiento", listaParams.ToArray()).ToString(); } return(r); }
public string MantenimientoVehiculo(Vehiculo objVehiculop) { string r = ""; using (SqlConnection conn = DataContext.GetConnection()) { var listaParams = new List <SqlParameter>(); listaParams.Add(new SqlParameter("@IdVehiculo", SqlDbType.VarChar) { Direction = ParameterDirection.Input, Value = objVehiculop.IdVehiculo }); listaParams.Add(new SqlParameter("@IdPersona", SqlDbType.VarChar) { Direction = ParameterDirection.Input, Value = objVehiculop.IdPersona }); listaParams.Add(new SqlParameter("@Nombre", SqlDbType.VarChar) { Direction = ParameterDirection.Input, Value = objVehiculop.Nombre }); listaParams.Add(new SqlParameter("@IdCategoria", SqlDbType.VarChar) { Direction = ParameterDirection.Input, Value = objVehiculop.IdCategoria }); listaParams.Add(new SqlParameter("@Codigo", SqlDbType.VarChar) { Direction = ParameterDirection.Input, Value = objVehiculop.Codigo }); listaParams.Add(new SqlParameter("@IdEmpresa", SqlDbType.VarChar) { Direction = ParameterDirection.Input, Value = objVehiculop.IdEmpresa }); listaParams.Add(new SqlParameter("@Descripcion", SqlDbType.VarChar) { Direction = ParameterDirection.Input, Value = objVehiculop.Descripcion }); listaParams.Add(new SqlParameter("@Documento", SqlDbType.VarChar) { Direction = ParameterDirection.Input, Value = objVehiculop.Documento }); listaParams.Add(new SqlParameter("@FinContrato", SqlDbType.VarChar) { Direction = ParameterDirection.Input, Value = objVehiculop.FinContrato }); listaParams.Add(new SqlParameter("@InicioContrato", SqlDbType.VarChar) { Direction = ParameterDirection.Input, Value = objVehiculop.InicioContrato }); listaParams.Add(new SqlParameter("@IdMarca", SqlDbType.VarChar) { Direction = ParameterDirection.Input, Value = objVehiculop.IdMarca }); listaParams.Add(new SqlParameter("@IdModelo", SqlDbType.VarChar) { Direction = ParameterDirection.Input, Value = objVehiculop.IdModelo }); listaParams.Add(new SqlParameter("@IdEstado", SqlDbType.VarChar) { Direction = ParameterDirection.Input, Value = objVehiculop.IdEstado }); listaParams.Add(new SqlParameter("@Observacion", SqlDbType.VarChar) { Direction = ParameterDirection.Input, Value = objVehiculop.Observacion }); listaParams.Add(new SqlParameter("@IdProveedor", SqlDbType.VarChar) { Direction = ParameterDirection.Input, Value = objVehiculop.IdProveedor }); listaParams.Add(new SqlParameter("@IdTipo", SqlDbType.VarChar) { Direction = ParameterDirection.Input, Value = objVehiculop.IdTipo }); r = SQLHelper.ExecuteScalar(conn, System.Data.CommandType.StoredProcedure, @"Sp_VehiculoMantenimiento", listaParams.ToArray()).ToString(); } return(r); }