Students fee management system c++ project with report ~ Programming Exercises

Project Name: Student Fee Management system

Language Name: C++

Database Connectivity :SQL Server 2008

Application Type: Console application

Introduction

The student fee management system project is one of best mini c++ console application project .it can be very beneficial for a school ,college and university for management of fee .The student fee management system is linked with Microsoft SQL SERVER 2008.The function hold by this mini software are following .

Create student profile
Update Fee student record
Delete Fee student record
Search Fee student record
See full Fee Report

Entity Relation Diagram

Use Case Diagram

Source Code
#include "stdafx.h"
#include<iostream>
#include <stdio.h>
#include<conio.h>
#include<Windows.h>//for sleep();
#include<dos.h>//for textbackgroundcolor();
using namespace System;
using namespace System::Data::SqlClient;
using namespace System::Data;
using namespace std;

//int main(array<System::String ^> ^args)
//{
//
//    return 0;
//}
class fee
{
     
private:
    int roll_no;
    long int deposit;
    static    const long int total=2000;
    long int r;
    char pay[10];
public:
    fee()  //constuctor to initaillize value
        {
    deposit=0;
   
    }

void stdrecord()
{
    String^ address = "Data Source=6930P\\SQLEXPRESS;Initial Catalog=feemanag;Integrated Security=True";
    SqlConnection^ connection = gcnew SqlConnection(address);
    connection->Open();
    cout<<"Enter Student Name:"<<endl;
    String^ name=Console::ReadLine();
    cout<<"Enter Father Name:"<<endl;
    String^ f_name=Console::ReadLine();
    cout<<"Enter Address:"<<endl;
    address=Console::ReadLine();
    cout<<"Gender:"<<endl;
    String^ gender=Console::ReadLine();
    cout<<"Enter Contact Number:";
    String^ contact=Console::ReadLine();
    cout<<"Enter SUBMIT for pay fee \nEnter NOTSUBMITTED for non pay fee:";
    String^ pay_fee=Console::ReadLine();
    cout<<"Your record has been saved";
    Console::ReadLine();
    String^ query = "insert into student (Student_name,Father_name,Student_address,Gender,Student_cell,Fee_Pay) Values('"+name->ToString()+"','"+f_name->ToString()+"','"
+address->ToString()+"','"+gender->ToString()
+"','"+contact->ToString()+"','"+pay_fee->ToString()+"')";
    SqlCommand^ command = gcnew SqlCommand(query,connection);

    command->ExecuteNonQuery();
    connection->Close();
}
void display()
{
    //query
    String^ address = "Data Source=6930P\\SQLEXPRESS;Initial Catalog=feemanag ;Integrated Security=True";
    SqlConnection^ connection = gcnew SqlConnection(address);
connection -> Open();
        Console::WriteLine("\t\t\t\t\tALL STUDENTS RECORDS");
        String^query = "select * from student";
       
    SqlCommand^ command = gcnew SqlCommand(query,connection);
    SqlDataReader^ datareader = command -> ExecuteReader ();

    while (datareader -> Read())
    {
        Console::WriteLine();
String^ fee;
if(!datareader->IsDBNull(6))
fee=datareader->GetString(6);




String^ line=String::Format("Id: {0} ==Name: {1} ==Father Name: {2} ==Address: {3} ==Gender: {4} ==Contact: {5} ==Fees: {6}",datareader->GetInt32(0),datareader->GetString(1),datareader->GetString(2),datareader->
GetString(3),datareader->GetString(4),datareader->GetString(5),fee);
        Console::WriteLine("******************************************************
**********************************************************************");

        Console::Write(line);
        /*Console::WriteLine();*/
    }
    Console::ReadLine();
       
    datareader -> Close();
    connection -> Close();

}
void del()
{
    String^ address = "Data Source=6930P\\SQLEXPRESS;Initial Catalog=feemanag;Integrated Security=True";
    SqlConnection^ connection = gcnew SqlConnection(address);
        connection->Open();
        Console::WriteLine("Please enter the stuudent id of student you want to delete");
        roll_no=Convert::ToInt32(Console::ReadLine());
        String^ query = "Delete from student where Student_id='"+Convert::ToString(roll_no)+"'";
        Console::WriteLine("Data has been deleted");
    SqlCommand^ command = gcnew SqlCommand(query,connection);
    command->ExecuteNonQuery();
    connection->Close();
}
void update()

{
   
    String^ address = "Data Source=6930P\\SQLEXPRESS;Initial Catalog=feemanag ;Integrated Security=True";
    SqlConnection^ connection = gcnew SqlConnection(address);
    connection-> Open();
        Console::WriteLine("Enter Student Id whose Record You want to Update");
        roll_no=Convert::ToInt32(Console::ReadLine());
            Console::WriteLine("Enter Name:");
        String^ name=Console::ReadLine();
        cout<<"Enter Father Name:"<<endl;
    String^ f_name=Console::ReadLine();
        Console::WriteLine("Enter Address:");
        /*String^*/ address=Console::ReadLine();
        Console:: WriteLine("Enter Gender");
        String^ gender=Console::ReadLine();
        Console::WriteLine("Contact No:");
        String^ contact=Console::ReadLine();
        Console::WriteLine("Enter Amount:");
        cin>>deposit;
       
        {

if(deposit==total)
{
        String^ address = "Data Source=6930P\\SQLEXPRESS;Initial Catalog=feemanag ;Integrated Security=True";
    SqlConnection^ connection = gcnew SqlConnection(address);
    connection-> Open();
cout<<"Your Fee Has Been Submitted"<<endl;

String^ query="Update student set Fee_Pay='Submitted' where Student_id='"+Convert::ToString(roll_no)+"'";

SqlCommand^ command = gcnew SqlCommand(query,connection);
    command->ExecuteNonQuery();
    connection->Close();
   
}
else if(deposit<total)
{    String^ address = "Data Source=6930P\\SQLEXPRESS;Initial Catalog=feemanag ;Integrated Security=True";
    SqlConnection^ connection = gcnew SqlConnection(address);
    connection-> Open();
    r=total-deposit;
cout<<"ALERT!you should pay "<<r<<"Rupee More To Submit Your Fee\n";
cout<<"Fee Not Submitted"<<endl;
String^ query="Update student set Fee_Pay='Not Submit' where Student_id='"+Convert::ToString(roll_no)+"'";
SqlCommand^ command = gcnew SqlCommand(query,connection);
    command->ExecuteNonQuery();
    connection->Close();
}
else
{    String^ address = "Data Source=6930P\\SQLEXPRESS;Initial Catalog=feemanag ;Integrated Security=True";
    SqlConnection^ connection = gcnew SqlConnection(address);
    connection-> Open();
    String^ query="Update student set Fee_Pay='Not Submitted' where Student_id='"+Convert::ToString(roll_no)+"'";
    SqlCommand^ command = gcnew SqlCommand(query,connection);
    command->ExecuteNonQuery();
    connection->Close();
}}
        String^ query = "Update student set Student_name='"+name->ToString()+"',Father_name='"+f_name->ToString()+"',Student_address='"
+address->ToString() +"',Gender='"+gender->ToString()
+"',Student_cell='"+contact->ToString()+"'where Student_id='"+Convert::ToString(roll_no)+"'";
    SqlCommand^ command = gcnew SqlCommand(query,connection);
    command->ExecuteNonQuery();
connection->Close();
}
void search_std()

{
    String^ address = "Data Source=6930P\\SQLEXPRESS;Initial Catalog=feemanag ;Integrated Security=True";
    SqlConnection^ connection = gcnew SqlConnection(address);
    connection-> Open();
    cout<<"Enter Student Id";
    cin>>roll_no;
    String^ query="Select * from student where Student_id='"+Convert::ToString(roll_no)+"' ";
        SqlCommand^ command = gcnew SqlCommand(query,connection);
   

    SqlDataReader^ datareader = command -> ExecuteReader ();
    while (datareader -> Read())
    {
        Console::WriteLine();
        String^ line=String::Format("Id :{0} Name :{1}  Father Name:{2}  Address :{3} Gender :{4} Contact :{5} Fee :{6}",datareader->GetInt32(0),datareader->GetString(1),datareader->
GetString(2),datareader->GetString(3),
datareader->GetString(4),datareader->GetString(5),datareader->GetString(6));        Console::Write(line);
    }
    Console::ReadLine();
       
    datareader -> Close();
    connection -> Close();
}

void updatefee()
{String^ address = "Data Source=6930P\\SQLEXPRESS;Initial Catalog=feemanag ;Integrated Security=True";
    SqlConnection^ connection = gcnew SqlConnection(address);
    connection->Open();
cout<<"Enter Student Id whoes Fee you want to update:";
cin>>roll_no;
cout<<"Enter amount:";
cin>>deposit;
if(deposit==total)
{
    String^ address = "Data Source=6930P\\SQLEXPRESS;Initial Catalog=feemanag ;Integrated Security=True";
    SqlConnection^ connection = gcnew SqlConnection(address);
    connection-> Open();
    cout<<"paid";//query
    String^ query="Update student set Fee_Pay='Submitted' where Student_id='"+Convert::ToString(roll_no)+"'";
    SqlCommand^ command = gcnew SqlCommand(query,connection);
    command->ExecuteNonQuery();
    connection->Close();
}
else if(deposit<total)
{String^ address = "Data Source=6930P\\SQLEXPRESS;Initial Catalog=feemanag ;Integrated Security=True";
    SqlConnection^ connection = gcnew SqlConnection(address);
    connection-> Open();
    cout<<"Unpaid\n";//upadate in unpaid col
    r=total-deposit;
    cout<<"ALERT!you should pay "<<r<<" Rupee More";
   
   
    String^ query="Update student set Fee_Pay='Not Submitted' where Student_id='"+Convert::ToString(roll_no)+"'";
    SqlCommand^ command = gcnew SqlCommand(query,connection);
    command->ExecuteNonQuery();
    connection->Close();
}
connection->Close();

}
void menu()
{
    Console::SetCursorPosition(30,10);
    cout<<"1.Insert New Student Record"<<endl;
    Console::SetCursorPosition(30,12);
    cout<<"2.Display Record"<<endl;
    Console::SetCursorPosition(30,13);
    cout<<"3.Delete Student Record"<<endl;
    Console::SetCursorPosition(30,14);
    cout<<"4.Update Student Record"<<endl;
    Console::SetCursorPosition(30,15);
    cout<<"5.Search Student Record"<<endl;
    Console::SetCursorPosition(30,16);
    cout<<"6.Update Fee Record"<<endl;

}
};
void main()
{
    String^address="Data Source=6930P\\SQLEXPRESS;Initial Catalog=feemanag;Integrated Security=True";
    SqlConnection^ connection=gcnew SqlConnection(address);// yaha ban gaya connection
    fee f;
    int a,p;
    char ch;
   
    {
         Sleep(800);
        Console::SetCursorPosition(55,10);
        Console::ForegroundColor = ConsoleColor::DarkRed;
     cout<<"FEE MANAGMENT SYSTEM\n";
     Sleep(600);
     Console::SetCursorPosition(55,12);
     Console::ForegroundColor = ConsoleColor::DarkGreen;
     cout<<"\xDB\xDB\xDB\xDB";
     Sleep(2000);
      cout<<"\xDB\xDB\xDB\xDB";
      Sleep(1000);
      cout<<"\xDB\xDB\xDB\xDB\xDB\xDB";
     Sleep(2000);
    cout<<"\xDB\xDB\xDB\xDB\xDB\xDB";
     Sleep(500);
   
    }
    system("cls");
    Console::ResetColor();
    Console::SetCursorPosition(50,15);
    Console::ForegroundColor = ConsoleColor::DarkBlue;
    cout<<"W"; Sleep(200);
    cout<<"E"; Sleep(200);
    cout<<"L"; Sleep(200);
    cout<<"C"; Sleep(200);
    cout<<"O"; Sleep(200);
    cout<<"M"; Sleep(200);
    cout<<"E"; Sleep(200);
    cout<<" T"; Sleep(200);
    cout<<"O"; Sleep(200);
    cout<<" F"; Sleep(200);
    cout<<"E"; Sleep(200);
    cout<<"E"; Sleep(200);
    cout<<" M"; Sleep(200);
    cout<<"A"; Sleep(200);
    cout<<"N"; Sleep(200);
    cout<<"A"; Sleep(200);
    cout<<"G"; Sleep(200);
    cout<<"M"; Sleep(200);
    cout<<"E"; Sleep(200);
    cout<<"N"; Sleep(200);
    cout<<"T"; Sleep(200);
    cout<<" S"; Sleep(200);
    cout<<"Y"; Sleep(200);
    cout<<"S"; Sleep(200);
    cout<<"T"; Sleep(200);
    cout<<"E"; Sleep(200);
    cout<<"M"; Sleep(600);
   
    Sleep(600);
    system("cls");
    Console::ResetColor();
menu:
    Console::SetCursorPosition(40,7);
    Console::ForegroundColor = ConsoleColor::Blue;
    cout<<"       MAIN MENU";
    Console::SetCursorPosition(40,8);
   
     Console::ResetColor();
    Console::SetCursorPosition(40,9);

    cout<<"1.Insert New Student Record"<<endl;
    Console::SetCursorPosition(40,10);
    cout<<"2.Display Record"<<endl;
    Console::SetCursorPosition(40,11);
    cout<<"3.Delete Student Record"<<endl;
    Console::SetCursorPosition(40,12);
    cout<<"4.Update Student Record"<<endl;
    Console::SetCursorPosition(40,13);
    cout<<"5.Search Student Record"<<endl;
    Console::SetCursorPosition(40,14);
    cout<<"6.Update Fee Record"<<endl;
    Console::SetCursorPosition(40,15);
    cout<<"7.Exit";
    Console::SetCursorPosition(40,16);
    cout<<"Choose Any One:";
    cin>>a;

    system("cls");
    if(a==1)
    {
       
    f.stdrecord();
    cout<<"Press BACKSPACE to back in Main Menu OR Escape To Exit";
    ch=getch();
    p=ch;
    if(p==8){
    system("cls");
    goto menu;}
    else if(p==27){
        exit(0);
    }
    }
    else if(a==2)
    {
        f.display();
       
        cout<<"Press BACKSPACE to back in Main Menu OR Escape To Exit"<<endl;
        ch=getch();
    p=ch;
   
    {
        if(p==8)
    {
    system("cls");
    goto menu;
    }
   
    else if(p==27)
    {
        exit(0);
    }
    }
    /*else{
        cout<<"Invalid Key";
    }*/
    }
   
   

    else if(a==3)
    {
        f.del();
    cout<<"Press BACKSPACE to back in Main Menu OR Escape To Exit";
    ch=getch();
    p=ch;
    if(p==8)
    {
    system("cls");
    goto menu;
    }
    else if(p==27)
    {
        exit(0);
    }
   

    }
    else if (a==4)
    {
    f.update();
cout<<"Press BACKSPACE to back in Main Menu OR Escape To Exit";
ch=getch();
    p=ch;
    if(p==8)
    {
    system("cls");
    goto menu;
    }
    else if(p==27)
    {
        exit(0);
    }
   
    }
    else if (a==5)
    {
        f.search_std();
    cout<<"Press BACKSPACE to back in Main Menu OR Escape To Exit";
    ch=getch();
    p=ch;
    if(p==8){
    system("cls");
    goto menu;}
    else if(p==27){
        exit(0);
    }
   
    }
    else if (a==6)
    {
        f.updatefee();
    cout<<"Press BACKSPACE to back in Main Menu OR Escape To Exit";
    ch=getch();
    p=ch;
    if(p==8){
    system("cls");
    goto menu;}
    else if(p==27){
        exit(0);
    }
    }
    else if(a==7)
       
    {
        Sleep(900);
        cout<<"Wait Your Program Will Be Terminate in 10 sec\n";
    Sleep(3000);
    system("cls");
    cout<<"1  ";
    Sleep(800);
    cout<<"2  ";Sleep(900);
    cout<<"3  ";Sleep(900);
    cout<<"4  ";Sleep(900);
    cout<<"5  ";Sleep(900);
    cout<<"6  ";Sleep(900);
    cout<<"7  ";Sleep(900);
    cout<<"8  ";Sleep(900);
    cout<<"9  ";Sleep(900);
    cout<<"10  ";Sleep(600);
    system("cls");
    Console::SetCursorPosition(50,10);
    Sleep(600);
    Console::ForegroundColor = ConsoleColor::DarkRed;
    cout<<"Shutting Down";
    Console::ResetColor();
    Sleep(600);
    cout<<". ";Sleep(800);
    cout<<". ";Sleep(800);
    cout<<". ";Sleep(800);
    cout<<". ";Sleep(800);
    cout<<". ";    Sleep(800);
    cout<<". ";Sleep(800);
    cout<<". ";Sleep(800);
    cout<<". ";Sleep(500);
    exit(0);
   
    }
    else
    {
cout<<"Invalid Number\n";
cout<<"Press BACKSPACE to back in Main Menu OR Escape To Exit";
    ch=getch();
    p=ch;
    if(p==8)
    {
    system("cls");
    goto menu;
    }
    else if(p==27)
    {
    exit(0);
    }

    }

    Console::ReadLine();
    }
Anonymous25 March 2022 at 01:27
Students Fee Management System C++ Project With Report ~ Programming Exercises >>>>> Download Now

>>>>> Download Full

Students Fee Management System C++ Project With Report ~ Programming Exercises >>>>> Download LINK

>>>>> Download Now

Students Fee Management System C++ Project With Report ~ Programming Exercises >>>>> Download Full

>>>>> Download LINK el
Programming Exercises

Monday, 10 June 2013

Students fee management system c++ project with report

05:37

Share it Please

Project Name: Student Fee Management system

Language Name: C++

Database Connectivity :SQL Server 2008

Application Type: Console application

Introduction

16 comments:

Popular Posts

Links

About Me

Labels

Contact Form

Blog Archive
