#include<fstream>
#include<string>
#include<iostream>
#include<iomanip>
#include <conio.h>
#include<string.h>

using namespace std;
class course
{
public:
string CRN;
string title;
string department;
string room;
};//course
class student
{
public:
string fname, lname, major;
double gpa;
course courses[10];
}; //student
student e[100];
course c[100];
int n=0;
int z=0;
void load()
{
ifstream studentFile("student.txt",ios::in);
ifstream courseFile("courses.txt",ios::in);
while(studentFile>>e[n].fname>>e[n].lname>>e[n].major>>e[n].gpa)
{
n++;
}//WHILE
while(courseFile>>c[z].CRN>>c[z].title>>c[z].department>>c[z].room)
{
z++;
}//while
}//LOAD
void store()
{
ofstream studentFile("student.txt",ios::out);
for(int i=0; i<n; i++)
{
if(e[i].fname!=" ")
studentFile<<e[i].fname<<" "<<e[i].lname<<" "<<e[i].major<<" "<<e[i].gpa<<endl;
}//FOR
ofstream courseFile("course.txt",ios::out);
for(int j=0; j<n; j++)
{
if(c[j].CRN!="")
courseFile<<c[j].CRN<<" "<<c[j].title<<" "<<c[j].department<<" "<<c[j].room;
}//FOR
}//STORE

void insert()
{
cout<<"Enter student's first name: ";
cin>>e[n].fname;
cout<<"Enter student's last name: ";
cin>>e[n].lname;
cout<<"Enter student's major: ";
cin>>e[n].major;
if(cin.fail())
{
cout<<"Error\n"; exit(1);
}
cout<<"Enter student's gpa: ";
cin>>e[n].gpa;
n++;
}//INSERTS THE RECORD TO ARRAY
void addCourse()
{
cout<<"Enter course CRN:";
cin>>c[z].CRN;
cout<<"Enter course title:";
cin>>c[z].title;
cout<<"Enter course department:";
cin>>c[z].department;
cout<<"Enter course room:";
cin>>c[z].room;
z++;
}//AddCourse
void display()
{
cout<<setiosflags(ios::left)<<setw(15)<<"First Name"<<setw(15)<<"Last Name";
cout<<setw(10)<<"Major"<<setw(10)<<"Gpa";
cout<<endl<<endl;
cout<<setiosflags(ios::fixed|ios::showpoint|ios::left);
for(int i=0;i<n;i++)
{
if(e[i].fname!=" ")
{
cout<<setiosflags(ios::left)<<setw(15)<<e[i].fname<<setw(15)<<e[i].lname;
cout<<setprecision(2)<<setiosflags(ios::left)<<setw(10)<<e[i].major;
cout<<setw(10)<<e[i].gpa;
cout<<resetiosflags(ios::left)<<endl;
}//IF
}//FOR
}//THIS FUNCTION DISPLAYS ALL RECORDS IN ARRAY
int search(string s)
{
for(int i=0;i<n;i++)
{
if(s==e[i].lname)
return i;
}//FOR
return -1;
}//SEARCH BY NAME,-1 NOT FOUND
int searchCourse(string crn)
{
for(int i=0;i<z;i++)
{
if(crn ==c[i].CRN)
return i;
}//FOR
return -1;
}//SEARCH BY NAME,-1 NOT FOUND
void update()
{
string searchn;
cout<<"Enter the Last Name of the student to be modified: "; cin>>searchn;
int i=search(searchn);
if(i==-1) cout<<"STUDENT NOT LISTED"<<endl;
else
{
cout<<endl<<"Please enter the updated information."<<endl;
cout<<"Enter student's first name: ";
cin>>e[i].fname;
cout<<"Enter student's last name: ";
cin>>e[i].lname;
cout<<"Enter student's major: ";
cin>>e[i].major;
cout<<"Enter student's gpa: ";
cin>>e[i].gpa;
}
}//UPDATE
void deleterec()
{
string searchn;
cout<<"Enter the Last Name of the student to delete: "; cin>>searchn;
int k=-1;
for(int j=0; j<n;j++)
{
if(searchn==e[j].lname)
k=j;
}
if(k!=-1)
{
cout<<" Name: "<<e[k].fname<<" "<<e[k].lname<<endl;
cout<<" Major: "<<e[k].major<<endl;
cout<<" GPA: "<<e[k].gpa<<endl;
}
char ans;
cout<<endl<<"Do you want to delete this record? (Y/N): ";
cin>>ans;
if(ans=='Y'||ans=='y')
{
e[k].fname=" ";
}//IF
else cout<<"STUDENT NOT FOUND";
}//DELETE
void report()
{
int i=0;
double totalgpa=0.00, avg;
for(i=0;i<n;i++)
{
totalgpa = totalgpa + e[i].gpa;
}//FOR
avg = totalgpa / n;
cout<<"Total number of student: " <<n<<endl<<endl;
cout<<"AVERGE GPA: "<<avg<<endl<<endl;
//cout<<"HIGHEST GPA"<<highest<<endl;
}//REPORT
void deletefile()
{
int pword;
cout<<"Enter your administrative password: "; cin>>pword;
if(pword==5438)
{
ofstream record("student.txt", ios::out);
record<<endl;
load();
record.close();
}
else cout<<"Wrong password entered."<<endl;
}//DELETE FILE
void backupfile()
{
system("copy student.txt backup.txt");
cout<<endl<<"Back-up file has been made."<<endl;
}//BACKUPFILE use cp command for UNIX
void studentmenu()
{
char choice='z';
system("cls");
cout<<"Student Menu"<<endl<<endl;
cout<<"1. Insert Student Record"<<endl;
cout<<"2. Display All Records"<<endl;
cout<<"3. Search by Last Name"<<endl;
cout<<"4. Search by Student ID"<<endl;
cout<<"5. Update Record"<<endl;
cout<<"8. Delete Database File"<<endl;
cout<<"9. Back-up Database File"<<endl;
cin>>choice;
switch (choice)
{
case '1': insert(); break;
case '2': display(); break;
case '3':
char s[100];
int index;
cout<<"Enter the last name of the student you want: ";
cin>>s;
index=search(s);
if(index!=-1)
{
cout<<"Name: "<<e[index].fname<<" "<<e[index].lname<<endl;
cout<<"Major: "<<e[index].major<<endl;
cout<<"GPA: "<<e[index].gpa<<endl;
}//IF
else cout<<"EMPLOYEE NOT FOUND"<<endl;
break;
case '4':
int id;
cout<<"Enter Student ID: " ;
cin>>id;
if(id < n)
{
cout<<"Name: "<<e[id].fname<<" "<<e[id].lname<<endl;
cout<<"Major: "<<e[id].major<<endl;
cout<<"GPA: "<<e[id].gpa;
}
else cout<<"Student not found"<<endl;
break;
case '5': update(); break;
case 'e': store(); break; //EXIT
default: cout<<"Invalid Choice"<<endl; break;
}//SWITCH
}//studentmenu

void coursemenu()
{
char choice='z';
system("cls");
cout<<"Course Menu"<<endl;
cout<<"Add Course (a)"<<endl;
cout<<"Search for Course (s)"<<endl;
cin>>choice;
switch(choice)
{
case 'a':
addCourse();
break;
case 's':
char crn[100];
int index;
cout<<"Enter the CRN of the course: ";
cin>>crn;
index=searchCourse(crn);
if(index!=-1)
{
cout<<"CRN: "<<c[index].CRN<<endl;
cout<<"Title: "<<c[index].title<<endl;
cout<<"Room: "<<c[index].room<<endl;
cout<<"Department: "<<c[index].department<<endl;
}//IF
else cout<<"COURSE NOT FOUND"<<endl;
break;

default: cout<<"Invalid Choice"<<endl;
break;
}//SWITCH
}//coursemenu
int login()
{
char username[15], password[7];
int limit=0;
ifstream fin("login.txt");
int correct=0;//use as a flag
while(limit<3)
{
cout<<"\nPlease Enter your name: "<<endl;
cin>>username;
cout<<"\nPlease Enter your password (6 char) :"<<endl;
for(int i=0;i<6;i++)
{
password[i] = getch(); cout<<'*';cout.flush();
}//FOR
password[i]='\0';//last character to 0
char u[15], p[7]; //read from the login.txt
while(fin >> u >> p)
{
if(strcmp(username,u)==0 && strcmp(password,p)==0)
{
cout<<"\nYour Password is ACCEPTED"<<endl;
correct=1;
return 1;
}//IF
} //while
if(correct==0){cout<<"\nYour Password is incorrect. Please try again."<<endl;
limit++;
}//IF
}//WHILE
cout<<"\nSorry, you've used all your chances."<<endl;
return 0;
}//login
void main()
{
if(login()){cout<<"\nWelcome to the SUNY OW Database!"<<endl;
load();
char choice='z';
while (choice!='e'&&choice!='E')
{
cout<<endl<<"SUNY OW Database"<<endl;
cout<<"Student Menu(s)"<<endl;
cout<<"Course Menu(c)"<<endl;
cout<<"Save Database(x)"<<endl;
cout<<endl<<"Type e To Exit"<<endl<<endl;
cin>>choice;
switch (choice)
{
case 's': studentmenu();
break;
case 'c':
coursemenu();
break;
case 'x':store();
break;
case 'e':store();
break;//Exit
default: cout<<"Invalid Choice"<<endl;
break;
}//SWITCH
cout<<"1. Insert Student Record and Compute Gpa"<<endl;
cout<<"2. Display All Records"<<endl;
cout<<"3. Search by Last Name"<<endl;
cout<<"4. Serch by Student ID"<<endl;
cout<<"5. Update Record"<<endl;
cout<<"6. Delete Record"<<endl;
cout<<"7. Generate Report"<<endl;
cout<<"8. Delete Database File"<<endl;
cout<<"9. Back-up Database File"<<endl;
cout<<endl<<"Type e to exit"<<endl<<endl;
cout<<"Enter the number of your choice:";
cin>>choice;
cout<<endl;
switch (choice)
{
case '1': insert();
break;
case '2': display();
break;
case '3': char s[100];
int index;
cout<<"Enter the last name of the student you want: ";
cin>>s;
index=search(s);
if(index!=-1)
{
cout<<"Name: "<<e[index].fname<<" "<<e[index].lname<<endl;
cout<<"Major: "<<e[index].major<<endl;
cout<<"Gpa: "<<e[index].gpa<<endl;
}//IF
else cout<<"STUDENT NOT FOUND"<<endl;
break;
case '4':
int id;
cout<<"Enter Student ID:";
cin>>id;
if(id<n)
{
cout<<"Name:"<<e[id].fname<<""<<e[id].lname<<endl;
cout<<"Major:"<<e[id].major<<endl;
cout<<"GPA:"<<e[id].gpa<<endl;
}
else
cout<<"Student not found"<<endl;
break;
case '5': update(); break;
case '6': deleterec(); break;
case '7': report(); break;
case '8': deletefile(); break;
case '9': backupfile(); break;
case 'e': store(); break; //EXIT
default: cout<<"Invalid Choice"<<endl; break;
}//SWITCH
}//WHILE
}//if
else {cout<<"Sorry!You don't have the chance!"<<endl;
}//else
}//MAIN


กก

1