Can an affidavit be submitted by a witness so that they won’t have to appear in Court?

No. A witness who has direct knowledge of the facts to which they testify must present all testimony in person. If the witness is not physically present in court, under oath, and subject to cross examination, their statements may not be presented to the Court.