Quantum Chemistry In Solid-State Simulations: Gaussian Basis Sets Development And Ab-Initio Green'S Function Based Realistic System Applications