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);
}
