import os
import csv
def newBook():
    print("Add a New Book Record")
    print("========================")
    f=open('Library.csv','a',newline='\r\n')
    s=csv.writer(f)
    BookId=int(input('Enter Book Id='))
    BookName=input('Enter Book Name=')
    Author=input('Enter Author=')
    Cost=float(input('Enter Cost='))
    rec=[BookId,BookName,Author,Cost]
    s.writerow(rec)
    f.close()
    print("Record Saved...")
    input("Press any key to continue..")

def updateBook():
    print("Modify a Book Record")
    print("=======================")
    f=open('Library.csv','r',newline='\r\n') 
    f1=open('temporary.csv','w',newline='\r\n')
    f1=open('temporary.csv','a',newline='\r\n')
    r=input('Enter Book Id of Book you want to modify=')
    s=csv.reader(f)
    s1=csv.writer(f1)
    
    for rec in s:
        if rec[0]==r:
            print("BookId=",rec[0])
            print("BookName=",rec[1])
            print("Author=",rec[2])
            print("Cost=",rec[3])
            choice=input("Do you want to modify..?(y/n)=")
            if choice=='y' or choice=='Y':
                BookId=int(input('Enter New BookId='))
                BookName=input('Enter new Book Name=')
                Author=input('Enter Author=')
                Cost=float(input('Enter Cost='))
                rec=[BookId,BookName,Author,Cost]
                s1.writerow(rec)
                print("Record Modified...")
            else:
                s1.writerow(rec)
        else:
            s1.writerow(rec)
            
    
        
    f.close()   
    f1.close()
    os.remove("Library.csv")
    os.rename("temporary.csv","Library.csv")
    
    input("Press any key to continue...")

def deleteBook():
    f=open('Library.csv','r',newline='\r\n') 
    f1=open('temporary.csv','w',newline='\r\n')
    f1=open('temporary.csv','a',newline='\r\n')
    r=input('Enter BookId of Book you want to delete=')
    s=csv.reader(f)
    s1=csv.writer(f1)
    
    for rec in s:
        if rec[0]==r:
            print("BookId=",rec[0])
            print("Book Name=",rec[1])
            print("Author=",rec[2])
            print("Cost=",rec[3])
            choice=input("Do you want to delete this record(y/n)=")
            if choice=='y' or choice=='Y':
                pass
                print("Record Deleted...")
            else:
                s1.writerow(rec)
        else:
            s1.writerow(rec)
            print("No such record found...")
    f.close()
    f1.close()
    os.remove("Library.csv")
    os.rename("temporary.csv","Library.csv")
    
    input("Press any key to continue...")

def searchBook():
    print("Search a Record")
    print("===================")
    f=open('Library.csv','r',newline='\r\n')  #Remove new line character from output
    r=input('Enter BookId you want to search=')
    s=csv.reader(f)
   
    for rec in s:
        if rec[0]==r:
            print("BookId=",rec[0])
            print("Book Name=",rec[1])
            print("Author=",rec[2])
            print("Cost=",rec[3])
        else:
            print("No such record found...")
    f.close()
    input("Press any key to continue..")
def listBooks():
    print("List of All Books")
    print("===================")
    f=open('Library.csv','r',newline='\r\n')  #Remove new line character from output
    s=csv.reader(f)
    for rec in s:
        print(rec[0],end="\t\t")
        print(rec[1],end="\t\t")
        print(rec[2],end="\t\t")
        print(rec[3])
        
    
    f.close()
    input("Press any key to continue...")

def menu():
    choice=0
    while choice!=6:
        print("\n")
        print("====================================")
        print("Softare for Library Data Management")
        print("====================================")
        print("\n==========")
        print("Main Menu")
        print("==========")
        print("1. Add a new Book Record")
        print("2. Modify Existing Book Record")
        print("3. Delete Existing Book Record")
        print("4. Search a Book Record")
        print("5. List of all Books")
        print("6. Quit")
        choice=int(input('Enter your choice'))
        if choice==1:
            newBook()
        elif choice==2:
            updateBook()
        elif choice==3:
            deleteBook()
        elif choice==4:
            searchBook()
        elif choice==5:
            listBooks()
        elif choice==6:
            print("Good Bye")
            break
menu()