Projects Inventory – Page 244 – Projects Inventory Management Systems and Source Codes PHP, C#, C, Android and many others

[Source Code Download] Students Course Enrollment Management System Project in C#

Leave a Comment / C# Projects / By Projects Inventory

The Students Course Enrollment Management System has the advantage of decreasing the time and effort in the student enrollment process. This system aids you to eliminate unnecessary paperwork and bringing a new level of enrollment transaction. The Students Course Enrollment Management System is an easy way of retrieving and storing student information made easy and …

[Source Code Download] Students Course Enrollment Management System Project in C# Read More »

[Free Code Download] Laboratory Monitoring Project in C#

Leave a Comment / C# Projects / By Projects Inventory

Laboratory Monitoring Project in C# The Laboratory Monitoring Project in C# is an automated system developed in C# and MySQL is used for the database. The Laboratory Monitoring Project is a user-friendly system that users can easily operate and understood how the system will operate. In The Laboratory Monitoring Project, we can view with ease the list of items that contain the …

[Free Code Download] Laboratory Monitoring Project in C# Read More »

[Free Download] Grocery Store Management System in PHP SQLite

Leave a Comment / PHP Projects / By Projects Inventory

[Free Download] Grocery Store Management System in PHP SQLite I developed this project using the following: PHP Language SQLite Database HTML JavaScrip XAMPP v3.3.0 jQuery Ajax CSS Bootstrap This Final year project has two modules; Administrator Usermodul Client module The Administrator User Module is the system side where the Grocery’s store Add, delete, view, update, and …

[Free Download] Grocery Store Management System in PHP SQLite Read More »

Research Project Ideas on Algebraic k-theory Math

Leave a Comment / Research Projects Math / By Projects Inventory

Research Project Ideas on Algebraic k-theory Math 1. HOMOLOGICAL STABILITY MINICOURSE LECTURE 1: THE HOMOLOGY OF SYMMETRIC GROUPS 2. On a deformation theory of finite dimensional modules over repetitive algebras 3. Connectedness in Tropical Combinatorics 4. Galois module structure of the units modulo of cyclic extensions of degree 5. Graph Schemes, Graph Series, and Modularity …

Research Project Ideas on Algebraic k-theory Math Read More »

Research Topics of Applied And Computational Geometry Project Ideas

Leave a Comment / Research Projects Math / By Projects Inventory

Research Topics of Applied And Computational Geometry Project Ideas 1. Arbitrary positive powers of semicirculant and r-circulant matrices 2. Machine learning moment closures for accurate and efficient simulation of polydisperse evaporating sprays 3. New illustrative applications of integral transforms to financial models with different fractional derivatives 4. Assessment of pollutant dispersion in urban street canyons …

Research Topics of Applied And Computational Geometry Project Ideas Read More »

GPA calculator in PHP

Leave a Comment / PHP Projects / By Projects Inventory

This tutorial covers the code of the calculator in PHP. index.php

<?php
$sgpa=0;
	if(!empty($_POST["save"])) 
	{
		
		$total_subjects = count($_POST["subject_name"]);
		$counter=0;

		
		$total_cr=$_POST['total_cr'];
		$sub_cr=$_POST["sub_cr"];
		for($i=0;$i<$total_subjects;$i++)
		{
			$counter++;
			$sub_gpa=($_POST["subject_gpa"][$i]*$sub_cr[$i])/$total_cr;	
			$sgpa+=$sub_gpa;
			
		}
		
		
	}
?>
<!DOCTYPE html>
<html>
<head>
	<title>gpa</title>
</head>
	
	<link rel="stylesheet" type="text/css" href="css/bootstrap.css">
	<link rel="stylesheet" type="text/css" href="bootstrap.min.css">
	<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" integrity="sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTsz/K68vbdEjh4u" crossorigin="anonymous">
	<script src="https://code.jquery.com/jquery-2.1.1.js"></script>
<script>

function addMore() {
	$("<div>").load("getdata.php", function() {
			$("#subjects").append($(this).html());
	});	
}
function deleteRow() {
	$('div.grab_values').each(function(index, item){
		jQuery(':checkbox', this).each(function () {
            if ($(this).is(':checked')) {
				$(item).remove();
            }
        });
	});
}
</script>
</head>
<body>
<nav class="navbar navbar-default">
  <div class="container-fluid">
    <div class="navbar-header">
      <a class="navbar-brand" href="index.php">GPA CALCULATOR</a>
    </div>
    <ul class="nav navbar-nav">
      <li class="active"><a href="index.php"><span class="glyphicon glyphicon-home"></span>Calculate SGPA</a></li>
      <li><a href="cgpa.php"><span class="glyphicon glyphicon-flag"></span>Calculate CGPA</a></li>
    </ul>
  </div>
</nav>
<div class="container">
	<div class="row">
		<div class="col-lg-7 col-lg-offset-2">
			<form method="post">
				<b>Your SGPA : </b>
				<input type="text"  class="form-control" placeholder="Your SGPA is" value="<?php print round($sgpa, 2) ;?>" readonly></input><br>
				<input type="text" name="total_cr"  class="form-control" placeholder="Total Credit Hours" required></input>
	
				<table class="table" >
					<th>&nbsp&nbsp&nbsp&nbsp&nbsp</th>
					<th>Subject Name</th>
					<th>Subject GPA</th>
					<th>Subject Credit Hour</th>	
				</table>
				<div id="subjects">
					<?php include("getdata.php") ?>
				</div>

				<div>
					<br><br>
					<input type="button" class="btn btn-success" name="add_item" value="Add More" onClick="addMore();" />
					<input type="button" class="btn btn-danger" name="del_item" value="Delete" onClick="deleteRow();" />
					<input type="submit" name="save" value="Calculate" class="btn btn-primary"/>
					<br><br>
				</div>
				<div>
					
				</div>
			</form>
		</div>
	</div>
</div>
</body>
</html>

<?php

$sgpa=0;

if(!empty($_POST["save"]))

{

$total_subjects = count($_POST["subject_name"]);

$counter=0;

$total_cr=$_POST['total_cr'];

$sub_cr=$_POST["sub_cr"];

for($i=0;$i<$total_subjects;$i++)

{

$counter++;

$sub_gpa=($_POST["subject_gpa"][$i]*$sub_cr[$i])/$total_cr;

$sgpa+=$sub_gpa;

}

<!DOCTYPE html>

<html>

<head>

</head>

function addMore() {

$("<div>").load("getdata.php", function() {

$("#subjects").append($(this).html());

});

}

function deleteRow() {

$('div.grab_values').each(function(index, item){

jQuery(':checkbox', this).each(function () {

if ($(this).is(':checked')) {

$(item).remove();

}

});

}

</script>

</head>

<body>

<a class="navbar-brand" href="index.php">GPA CALCULATOR</a>

</div>

<li class="active"><a href="index.php"><span class="glyphicon glyphicon-home"></span>Calculate SGPA</a></li>

<li><a href="cgpa.php"><span class="glyphicon glyphicon-flag"></span>Calculate CGPA</a></li>

</ul>

</div>

</nav>

<input type="text" class="form-control" placeholder="Your SGPA is" value="<?php print round($sgpa, 2) ;?>" readonly></input><br>

<th>Subject Name</th>

<th>Subject GPA</th>

<th>Subject Credit Hour</th>

</table>

<?php include("getdata.php") ?>

</div>

<div>

</div>

<div>

</div>

</form>

</div>

</body>

</html>

getdata.php

<!DOCTYPE html>
<html>
<head>
	<title></title>
	<link rel="stylesheet" type="text/css" href="css/bootstrap.css">
	<link rel="stylesheet" type="text/css" href="bootstrap.min.css">
</head>
<body>
<div class="grab_values form-group" style="clear:both;">
	<div style="float: left;">
		<input type="checkbox"  name="item_index[]"/>
	</div>
	<div style="float: left;">
		<input type="text" class="form-control" placeholder="Subject name" name="subject_name[]" required/>
	</div>
	<div style="float: left;">
		<input type="text" class="form-control" placeholder="Subject gpa" name="subject_gpa[]" required/>
	</div>
	<div style="float: left;">
		<input type="text" class="form-control" placeholder="Subject credit hour"name="sub_cr[]" required/>
	</div><br><br>
</div>
</body>
</html>

<!DOCTYPE html>

<html>

<head>

</head>

<body>

</div>

</div>

</div>

</div><br><br>

</div>

</body>

</html>

cgpa.php

<?php 
$answer=0; 
if (isset($_POST['submit'])) 
{
	$current_gpa=$_POST['current_gpa'];
	$previous_semester=$_POST['previous_semester'];
	$expected=$_POST['expected'];
	$this_semester=$_POST['this_semester'];

	$sum=$current_gpa*$previous_semester;
	$sum1=$sum+$expected;
	$answer=$sum1/$this_semester;
} 
?>
<!DOCTYPE html>
<html>
<head>
	<title></title>
	<link rel="stylesheet" type="text/css" href="css/bootstrap.css">
	<link rel="stylesheet" type="text/css" href="bootstrap.min.css">
	<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" integrity="sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTsz/K68vbdEjh4u" crossorigin="anonymous">

</head>
<body>
<nav class="navbar navbar-default">
  <div class="container-fluid">
    <div class="navbar-header">
      <a class="navbar-brand" href="index.php">GPA CALCULATOR</a>
    </div>
    <ul class="nav navbar-nav">
      <li><a href="index.php"><span class="glyphicon glyphicon-home"></span>Calculate SGPA</a></li>
      <li class="active"><a href="cgpa.php"><span class="glyphicon glyphicon-flag"></span>Calculate CGPA</a></li>
    </ul>
  </div>
</nav>
<div class="container">
	<div class="row">
		<div class="col-lg-5 col-lg-offset-3">
			<form method="post" class="form-group">
				<input type="text" name="current_gpa" placeholder="Current CGPA" class="form-control"></input><br><br>
				<input type="text" name="expected" placeholder="Expected CGPA" class="form-control"></input><br><br>
				<input type="text" name="previous_semester" placeholder="Your Previous Semester" class="form-control"></input><br><br>
				<input type="text" name="this_semester" placeholder="Your Current Semester" class="form-control"></input><br><br>
				<b>Your CGPA</b><br>
				<input type="text"  class="form-control" placeholder="CGPA" value="<?php print round($answer, 2) ;?>" readonly></input><br><br>

				<input type="submit" name="submit" value="Calculate" class="btn btn-primary"></input><br><br>
			</form>
		</div>
	</div>
</div>
<center>
<div class="alert alert-info">
	<p>Your Previous Semester* (means the semester in which you appeared last time)</p>
	<p>Your current Semester* (means the semester in which you appeared recently)</p>
</div>
</center>


</body>
</html>

<?php

$answer=0;

if (isset($_POST['submit']))

{

$current_gpa=$_POST['current_gpa'];

$previous_semester=$_POST['previous_semester'];

$expected=$_POST['expected'];

$this_semester=$_POST['this_semester'];

$sum=$current_gpa*$previous_semester;

$sum1=$sum+$expected;

$answer=$sum1/$this_semester;

}

<!DOCTYPE html>

<html>

<head>

</head>

<body>

<a class="navbar-brand" href="index.php">GPA CALCULATOR</a>

</div>

<li><a href="index.php"><span class="glyphicon glyphicon-home"></span>Calculate SGPA</a></li>

<li class="active"><a href="cgpa.php"><span class="glyphicon glyphicon-flag"></span>Calculate CGPA</a></li>

</ul>

</div>

</nav>

<input type="text" class="form-control" placeholder="CGPA" value="<?php print round($answer, 2) ;?>" readonly></input><br><br>

</form>

</div>

<p>Your Previous Semester* (means the semester in which you appeared last time)</p>

<p>Your current Semester* (means the semester in which you appeared recently)</p>

</div>

</center>

</body>

</html>

Similarly, you can practice different examples of calculator in PHP. Download Source Code of GPA calculator in PHP

Quantitative Biology Research Project Examples

Leave a Comment / Research Projects Math / By Projects Inventory

Quantitative Biology Research Project Examples 1. Pre-Service Biology Teachers’ Attitudes Towards Math: Using the Covid-19 Case in Calculus Course 2. Biology educators, professional societies, and practitioner networks within community colleges 3. Integration of biology, mathematics and computing in the classroom through the creation and repeated use of transdisciplinary modules 4. Assessing quantitative modelling practices, metamodelling, …

Quantitative Biology Research Project Examples Read More »

Random graphs Research Project Examples

Leave a Comment / Research Projects Math / By Projects Inventory

Random graphs Research Project Examples. Predictor‐based H∞ leader‐following consensus of stochastic multi‐agent systems with random input delay Adaptive Rewiring in Weighted Networks Shows Specificity, Robustness, and Flexibility Impact of the mesoscale structure of a bipartite ecological interaction network on its robustness through a probabilistic modeling Vulnerability studies in the fields of transportation and complex networks: …

Random graphs Research Project Examples Read More »

Source code OF LIBRARY MANAGEMENT SYSTEM Project in C++ – Free Download

Leave a Comment / C++ Projects / By Projects Inventory

Source code OF LIBRARY MANAGEMENT SYSTEM Project in C++ – Free Download.

#include<iostream.h>
#include<constream.h>
#include<stdlib.h>
#include<graphics.h>
#include<dos.h>
int n,n1;
int i;
int inc=0;
int inc1=0;
class book
{
   public:
   int bookcode;
   char bookname[20];
   char authorname[20];
   char bookpub[20];
   int bookprice;
   int status;
   public:
  void addbook()
{

    clrscr();
    status=1;
    cout<<"\t\t\t   YOU HAVE CHOSEN TO ADD BOOK DETAILS"<<endl;
    cout<<"\t\t\t^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^"<<endl;
    cout<<endl;
    inc++;
    bookcode=100+inc;
    cout<<"\n\tBook code                :"<<bookcode;
    cout<<endl;
    cout<<"\n\tEnter book name          :";
    cin>>bookname;
    cout<<"\n\tEnter author name        :";
    cin>>authorname;
    cout<<"\n\tEnter publishing company :";
    cin>>bookpub;
    cout<<"\n\tEnter book price         :";
    cin>>bookprice;

}
void dispbook()
{
  cout<<bookcode<<"\t\t"<<bookname<<"\t\t"<<authorname<<"\t\t"<<bookpub<<"\t\t"<<bookprice<<endl;
}
void liststat()
{
  if(status==1)
  {
     cout<<"\t\tBookcode:"<<bookcode<<"\t\tStatus:Available"<<endl;
     cout<<endl;
  }
  else
  {
     cout<<"\t\tBookcode:"<<bookcode<<"\t\tStatus:Issued"<<endl;
     cout<<endl;
   }

}
};book b[10];
class student
{
public:
int studid;
char studname[20];
char deptname[20];
int bookcount;
public:
void addstud()
{
    clrscr();
    cout<<"\t\tYOU HAVE CHOSEN TO ADD STUDENT DETAILS"<<endl;
    cout<<"\t\t^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^"<<endl;
    cout<<endl;
    cout<<endl;
    inc1++;
    studid=100+inc1;
    cout<<"\t\tStudent Id            :"<<studid;
    cout<<endl;
    cout<<endl;
    cout<<"\t\tEnter Student Name    :";
    cin>>studname;
    cout<<endl;
    cout<<"\t\tEnter Department Name :";
    cin>>deptname;
    cout<<endl;
    bookcount=2;
    cout<<endl;
    cout<<"\t\tMaximum books allowed for a student:"<<bookcount<<endl;
    cout<<endl;

 }
 void dispstud()
 {
     cout<<"\t"<<studid<<"\t\t"<<studname<<"\t\t"<<deptname<<endl;
    //bookcount=2;
    cout<<endl;
 }
};student s[10];
class issue
{
   public:
   int day,month,year;
   int day2,month2,year2;
   int iday,imon,iyear;
   int rday,rmon,ryear;
   int eday,emon,eyear;
   int yr1,yr2,m1,m2,d1,d2,mons1,mons2,mons,days,yrs,sum,j;
   int  loop;
   int fine;

   public:
   void isdatecalc()
   {
		    cout<<"\t\tEnter day:";
		    cin>>day;
		    cout<<"\t\tEnter month:";
		    cin>>month;
		    cout<<"\t\tEnter year:";
		    cin>>year;
		    day2=day;
		    month2=month;
		    year2=year;
		    day2=day2+20;

			   if(((month2==1)||(month2==3)||(month2==5)||(month2==7)||(month2==8)||(month2==10)||(month2==12))&&((day2>31)))
			    {
				day2=day2-31;
				month2=month2+1;
				if(month2==13)
				 {
				   year2++;
				   month2=1;
				 }
			      }
			   else if(((month2==4)||(month2==6)||(month2==9)||(month2==11))&&((day2>30)))
				 {
				     day2-=30;
				     month2++;
				    }
			    else if(((year2%4==0)||(year2%400==0))&&(day2>29)&&(month==2))
			      {
				day2-=29;
				month2++;
			    }
			    else if(((year2%4!=0)||(year2%100!=0)||(year2%400!=0))&&(day2>28)&&(month2==2))
			    {
			      day2-=28;
			      month2++;
			     }
			     cout<<endl;
 }
 void isdate()
 {
   iday=day;
   imon=month;
   iyear=year;

   cout<<"\t\tIssued date:"<<iday<<"/"<<imon<<"/"<<iyear;
   cout<<endl;
 }
 void retdate()
 {
 rday=day2;
 rmon=month2;
 ryear=year2;
 cout<<"\t\tReturn Date:"<<rday<<"/"<<rmon<<"/"<<ryear<<endl;
  cout<<endl;
 }
 void edatecalc()
 {
   eday=rday;
   emon=rmon;
   eyear=ryear;
		 eday=eday+20;
		 if(((emon==1)||(emon==3)||(emon==5)||(emon==7)||(emon==8)||(emon==10)||(emon==12))&&((eday>31)))
			    {
				eday=eday-31;
				emon=emon+1;
				if(emon==13)
				 {
				   eyear++;
				   emon=1;
				 }
			      }
			   else if(((emon==4)||(emon==6)||(emon==9)||(emon==11))&&((eday>30)))
				 {
				    eday-=30;
				    emon++;
				    }
			    else if(((eyear%4==0)||(eyear%100==0)||(eyear%400==0))&&(eday>29)&&(emon==2))
			      {
				eday-=29;
			       emon++;
			    }
			    else if(((eyear%4!=0)||(eyear%100!=0)||(eyear%400!=0))&&(eday>28)&&(emon==2))
			    {
			      eday-=28;
			      emon++;
			     }
			     cout<<endl;
			     cout<<endl;

		 cout<<"\t\tYour extended due date is:"<<eday<<"/"<<emon<<"/"<<eyear<<endl;
}
 void finecalc();
 }; issue is;
 void issue::finecalc()
{
  int mon[]={31,28,31,30,31,30,31,31,30,31,30,31};
				 loop=365;
				 sum=0;
				  d1=rday;
				 m1=rmon;
				yr1=ryear;
				cout<<endl;
			       cout<<"\t\tYour actual return Date Is: "<<d1<<"/"<<m1<<"/"<<yr1<<endl;
			      cout<<endl;
			      cout<<"\t\tEnter the date of return below.."<<endl;
			      cout<<endl;
			     cout<<"\t\tEnter day:";
			     cin>>d2;
			     cout<<endl;
			      cout<<"\t\tEnter month:";
			     cin>>m2;
			     cout<<endl;
			      cout<<"\t\tEnter year:";
			cin>>yr2;
			cout<<endl;
			days=d2-d1;

			yrs=yr2-yr1;
		   if(m2>=m1)
		   {
		      mons=m1-m2;
		      mons2=abs(mons);
		  }
		  else
		  {
		    mons=m2-m1;
		    mons2=abs(mons);
		  }
		  sum=yrs*loop+mons+days+mons2;
		  if(m2>m1)
		  {
		     j=m1;
		  }
		  else
		  {
		     j=m2;
		  }
		  if(mons2!=0)
		  {


		     for(i=0;i<mons2;i++)
		     {
			sum=sum+mon[j];
			j++;
		      }
		  }
		  cout<<endl;
		  cout<<"\t\tYour date of return:"<<d2<<"/"<<m2<<"/"<<yr2<<endl;
		  cout<<endl;
		  fine=(sum+mons)*1;

		  if((yr1%4==0)||(yr1%400==0)&&(m1==2))
		  {
		     fine=fine+1;
		  }
		 /* if((m1==2)&&(yr1%4!=0)||(yr1%400!=0))

		  {
		    fine=fine-1;
		  }*/

		  cout<<"\t\t\tFine amount:Rs."<<fine<<endl;
		  cout<<"\t\t\t*****************"<<endl;
}

void main()
{
int ch,i;
char ch2,ch3,ch4;
int sbookcode,sstudid;
int flag,flag1,pos,spos,ipos;
int sflag,stpos;
int ibookcode,istudid;
int rbookcode,rstudid;
int rflag1,rflag2;
int rpos1,rpos2,l;

do
{
clrscr();
textcolor(15);
textbackground(4);
cout<<"\t\t\t********%%%%%%%%%%********"<<endl;
cout<<"\t\t\tLIBRARY MANAGEMENT SYSTEM"<<endl;
cout<<"\t\t\t********%%%%%%%%%%********"<<endl;
cout<<endl;

cout<<"\t\t\t\tMAINMENU"<<endl;
cout<<"\t\t\t\t^^^^^^^^"<<endl;
cout<<endl;
cout<<"\t\t  ##############################################"<<endl;
cout<<endl;
cout<<"\t\t$ \t1. TAKE A TOUR OF THE PROJECT.  \t$"<<endl;
cout<<"\t\t$ \t2. ADD  NEW BOOK.               \t$"<<endl;
cout<<"\t\t$ \t3. VIEW ALL BOOK DETAILS.       \t$"<<endl;
cout<<"\t\t$ \t4. SEARCH A BOOK.               \t$"<<endl;
cout<<"\t\t$ \t5. ADD NEW STUDENT.             \t$"<<endl;
cout<<"\t\t$ \t6. DISPLAY ALL STUDENT DETAILS. \t$"<<endl;
cout<<"\t\t$ \t7. VIEW A STUDENT.              \t$"<<endl;
cout<<"\t\t$ \t8. ISSUE  BOOK.                 \t$"<<endl;
cout<<"\t\t$ \t9. RETURN BOOK.                 \t$"<<endl;
cout<<"\t\t$ \t0. EXIT.                        \t$"<<endl;
cout<<endl;
cout<<"\t\t  ##############################################"<<endl;
cout<<endl;
cout<<"\t\t\t\tHit your choice:";
cin>>ch;
switch(ch)
{
	case 1:clrscr();
	       int d,m;
	       d=DETECT;
	       initgraph(&d,&m," ");
	       cleardevice();
	       for(int g=440;g>=-250;g--)
	       {
		   cleardevice();
		   setcolor(5);
		   outtextxy(250,g,"WELCOME TO");
		   outtextxy(230,g+20,"LIBRARY MANAGEMENT");
		   outtextxy(260,g+40,"SYSTEM");
		   setcolor(6);
		   outtextxy(250,g+100,"MADE BY");
		   outtextxy(250,g+120,"*******");
		   outtextxy(180,g+140,"NARMADHA.S.T");
		   setcolor(3);
		   setcolor(12);
		   setbkcolor(14);
		   settextstyle(7,0,5);
		   outtextxy(250,g+250,"THANK YOU");
		   delay(20);
		}
		cleardevice();
		cout<<endl;
		cout<<endl;
		cout<<"\t The Project Library Management System contains three "<<endl;
		cout<<"\t different modules."<<endl;
		cout<<endl;
		cout<<"\t We can add new books,see the list of added books,"<<endl;
		cout<<"\t search a particular book."<<endl;
		cout<<endl;
		cout<<"\t Similarly, we can add new students, view the list of"<<endl;
		cout<<"\t all added students with their course details and view"<<endl;
		cout<<"\t a single student."<<endl;
		cout<<endl;
		cout<<"\t The main module in the project is the issue-return module."<<endl;
		cout<<endl;
		cout<<"\t We can issue only two books to a student.The issued period"<<endl;
		cout<<"\t is for twenty days.So within twenty days, the student should"<<endl;
		cout<<"\t return the book or can extend further for a period of twenty"<<endl;
		cout<<"\t days.If neither returned nor extended,a fine of Re.1/day is"<<endl;
		cout<<"\t collected on the day of return."<<endl;
		cout<<endl<<endl;
		cout<<"\t\t\t\t  THANK YOU"<<endl;
		cout<<endl;

		cout<<"\t\t\t\t Narmadha.S.T"<<endl;
		cout<<endl;
		cout<<endl;
		cout<<"\t\t\t<<-----BACK TO MAIN MENU-----"<<endl;
		getch();
		closegraph();
		main();
		getch();
		break;


	case 2:clrscr();
	cout<<"\t\tYOU HAVE CHOSEN TO ADD BOOK DETAILS"<<endl;
	cout<<"\t\t^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^"<<endl;
	cout<<endl;
	cout<<endl;
	cout<<"\t\tEnter number of books to be added:";
	cin>>n;
	for(i=1;i<=n;i++)
	{
	   cout<<"Enter book code:"<<100+i;
	    b[i].addbook();

	 }

	 cout<<endl;
	 cout<<endl;
	cout<<"\t\t<<-----Back To Main Menu-----"<<endl;
	getch();
	main();
	break;

	 case 3:clrscr();
	 cout<<"\t\t\tLIST OF ALL ADDED BOOKS"<<endl;
	 cout<<"\t\t\t^^^^^^^^^^^^^^^^^^^^^^^"<<endl;
	 cout<<endl;
	 cout<<"**********************************************************************"<<endl;
	 cout<<"BOOKCODE\tBOOKNAME\tAUTHORNAME\tPUB.COMPANY\tPRICE"<<endl;
	 cout<<"**********************************************************************"<<endl;
	 for(i=1;i<=n;i++)
	 {
	   b[i].dispbook();
	 }
	 cout<<endl;
	 cout<<endl;
	 for(i=1;i<=n;i++)
	 {
	    b[i].liststat();
	 }
	 cout<<endl;
	 cout<<"\t\t<<-----Back To Main Menu-----"<<endl;
	 getch();
	main();
	break;

	case 4:clrscr();
	       cout<<"\t\t\tSEARCH  A BOOK"<<endl;
	       cout<<"\t\t\t^^^^^^^^^^^^^^"<<endl;
	       cout<<endl;
	       cout<<"\t\tEnter book code to search:";
	       cin>>sbookcode;
	       for(i=1;i<=n;i++)
	       {
		   if(sbookcode==b[i].bookcode)
		   {
		       flag=1;
		       pos=i;
		    }
		}
		   if(flag==1)
		   {
		       cout<<endl;
		       cout<<"\t\tBook is available!!"<<endl;
		       cout<<endl;
		       cout<<"\t\tTHE BOOK DETAILS ARE..."<<endl;
		       cout<<endl;
		       cout<<"\t\tBook code          :"<<b[pos].bookcode<<endl;
		       cout<<"\t\tBook name          :"<<b[pos].bookname<<endl;
		       cout<<"\t\tAuthor name        :"<<b[pos].authorname<<endl;
		       cout<<"\t\tPublishing company :"<<b[pos].bookpub<<endl;
		       cout<<"\t\tBook price         :"<<b[pos].bookprice<<endl;

		   }
	       else
	       {
		    cout<<endl;
		    cout<<"\t\tSorry!..No Book Exists With Code:"<<sbookcode<<endl;
		}
		cout<<endl;
		cout<<endl;
		cout<<"\t\t"<<"<<-----Back To Main Menu-----"<<endl;
		getch();
		main();
	       break;

	case 5:clrscr();
	       cout<<"\t\tYOU HAVE CHOSEN TO ADD STUDENT DETAILS"<<endl;
	       cout<<"\t\t^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^"<<endl;

	       cout<<endl;
	       cout<<"\t\tEnter number of students to be added:";
	       cin>>n1;
	       for(i=1;i<=n1;i++)
		{
		   s[i].addstud();

		}
	 cout<<endl;
	 cout<<"\t\tNumber of newly added students:"<<n1<<endl;
	cout<<endl;
	cout<<endl;
	cout<<"\t\t<<-----Back To Main Menu-----"<<endl;
	getch();
	main();
	break;

	case 6:clrscr();
	       cout<<"\t\tLIST OF ALL ADDED STUDENTS"<<endl;
	       cout<<"\t\t^^^^^^^^^^^^^^^^^^^^^^^^^^"<<endl;
	 cout<<endl;
	 cout<<"\t******************************************"<<endl;
	 cout<<"\tSTUDENT ID\tSTUDENT NAME\tDEPT NAME"<<endl;
	 cout<<"\t******************************************"<<endl;

	 for(i=1;i<=n1;i++)
	 {
	   s[i].dispstud();

	 }
	 cout<<endl;

	 cout<<"\t<<-----Back To Main Menu-----"<<endl;
	 getch();
	main();
	break;

	case 7:clrscr();
	       cout<<"\t\t\tVIEW A STUDENT"<<endl;
	       cout<<"\t\t\t^^^^^^^^^^^^^^"<<endl;
	       cout<<endl;
	       cout<<"\t\tEnter student id to view:";
	       cin>>sstudid;
	       for(i=1;i<=n1;i++)
	       {
		   if(sstudid==s[i].studid)
		   {
		       sflag=1;
		       stpos=i;
		    }
		}
		   if(sflag==1)
		   {
		       cout<<endl;
		       cout<<"\t\tStudent found!!"<<endl;
		       cout<<endl;
		       cout<<"\t\tTHE STUDENT DETAILS ARE..."<<endl;
		       cout<<endl;
		       cout<<"\t\tStudent name             :"<<s[stpos].studname<<endl;
		       cout<<"\t\tDepartment name          :"<<s[stpos].deptname<<endl;

		   }
	       else
	       {
		    cout<<endl;
		    cout<<"\t\tSorry!..No Student found with this id:"<<sstudid<<endl;
		}
		cout<<endl;
		cout<<endl;
		cout<<"\t\t"<<"<<-----Back To Main Menu-----"<<endl;
		getch();
		main();
	       break;


	case 8:clrscr();
	       cout<<"\t\t YOU HAVE CHOSEN TO ISSUE A BOOK"<<endl;
	       cout<<"\t\t^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^"<<endl;
	       cout<<endl;
		cout<<"\t\tEnter student id:";
		    cin>>istudid;
		    for(i=1;i<=n1;i++)
		  {
		     if(istudid==s[i].studid)
		     {
		       flag=1;
		       spos=i;

		    }
		}

		   if(flag==1)
		   {
		     cout<<"\t\tEnter book code to issue book:";
		     cin>>ibookcode;
		     for(i=1;i<=n;i++)
		     {
		       if(ibookcode==b[i].bookcode)
		       {
			  flag1=1;
			  ipos=i;
		       }
		     }
		   }

		    cout<<endl;


		   if(flag==1)
		     {
		      if(flag1==1)
		      {

		       if(s[spos].bookcount!=0)
		       {
		       if(b[ipos].status==1)
			{

			  s[spos].bookcount--;

			  b[ipos].status=0;
			  cout<<"\t\tDate of issue"<<endl;
			  cout<<"\t\t~~~~~~~~~~~~~"<<endl;
			    is.isdatecalc();
			    is.isdate();
			    is.retdate();
			   cout<<"\t\tThis book is now issued...."<<endl;
			   cout<<endl;
			   cout<<"\t\tBooks allowed now:"<<s[spos].bookcount<<endl;
			   cout<<endl;
			    cout<<"\t Student Id\t Student Name\t BookCode"<<endl;
			    cout<<"\t ----------\t ------------\t --------"<<endl;
		   cout<<"\t "<<s[spos].studid<<"\t\t "<<s[spos].studname<<"\t\t "<<b[ipos].bookcode<<endl;


		 }

			  else
			  {
			  cout<<"\t\tSorry!Book already issued.."<<endl;
			  }

		    }
		     else
		      {
		      cout<<"\t\tSorry!.You cannot take more than two books.."<<endl;
		     }

	       }
		 else
		 {
		 cout<<"\t\tSorry!..No Book Exists With Code:"<<ibookcode<<endl;
		}
	      }
	      else

	      {
		cout<<"\t\tSorry!..No Student Exists with Id:"<<istudid<<endl;
	      }

		cout<<endl;
		cout<<"\t\t<<-----Back To Main Menu-----"<<endl;
		getch();
		main();
	       break;

	       case 9:clrscr();
		      cout<<"\t\tYOU HAVE CHOSEN TO RETURN A BOOK"<<endl;
		      cout<<"\t\t^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^"<<endl;
		      cout<<endl;
		      cout<<"\t\tEnter student id:";
			     cin>>rstudid;
			     cout<<endl;
			     for(i=1;i<=n1;i++)
			   {
			   if(rstudid==s[i].studid)
			   {
			     rflag1=1;
			     rpos1=i;
			   }
			 }




		   if(rflag1==1)
		   {

		     cout<<"\t\tEnter book code to return book:";
		     cin>>rbookcode;
		     cout<<endl;
		     for(i=1;i<=n;i++)
		     {
		       if(rbookcode==b[i].bookcode)
		       {
			  rflag2=1;
			  rpos2=i;
			}
		     }
		   }
		   if(rflag1==1)
		   {
		     if(rflag2==1)
		     {
			cout<<"\tIs the bookcode:"<<b[rpos2].bookcode<<" issued to student id:"<<s[rpos1].studid<<" ?y/n:";
			cin>>ch4;
			if(ch4=='y')
			{
			if(b[rpos2].status==0)
			 {
			    cout<<endl;
			    cout<<"\t\tYou can Return the Book..."<<endl;
			    cout<<endl;
			    is.retdate();
			    cout<<"\t\tAre you sure you want to return this book ?y/n:";
			    cin>>ch2;
			     cout<<endl;
			     if(ch2=='y')
			      {
				 cout<<"\t\t Is the book returned before due date?y/n:";
				 cin>>ch3;
				 cout<<endl;
				  if(ch3=='y')
				  {
				  //   is.retdate();
				    //cout<<endl;
				    cout<<"\t\tBook returned before due date"<<endl;
				    cout<<endl;
				    cout<<"\t\t\tFine - NIL"<<endl;
				   cout<<endl;
				   cout<<"\t\t\t THANK YOU"<<endl;
				   b[rpos2].status=1;
				   s[rpos1].bookcount++;
				   cout<<endl;
				   cout<<"\t\t<<-----Back To Main Menu-----"<<endl;
				   getch();
				   main();
				 }
				 else
				 {
				   clrscr();
				   cout<<endl;
				  cout<<"\t\tYOU HAVE TO PAY FINE !!!"<<endl;

		  is.finecalc();
		  cout<<endl;
		  b[rpos2].status=1;
		  s[rpos1].bookcount++;
		  cout<<"\t\t<<-----Back To Main Menu-----"<<endl;
		  getch();
		  main();
		}
	      }

		  else
		 {
		is.retdate();
		 cout<<endl;
		 cout<<"\t\tYou can extend the book for another twenty days.."<<endl;
		 is.edatecalc();

		}

		  }
		  else
		  {
		   cout<<endl;
		   cout<<"\t\tThis Book is not yet issued from library.. "<<endl;
		  }
		}
		else
		{
		  cout<<endl;
		  cout<<"\t\t This book is not issued to you..Sorry!!!"<<endl;
		}



			}
			  else
			  {
			  cout<<endl;
			  cout<<"\t\tSorry!..No Book Exists With Code:"<<rbookcode<<endl;
			  }

		    }

		     else
		      {
		      cout<<endl;
		      cout<<"\t\tSorry!..No Student Exists With Id:"<<rstudid<<endl;
		     }

		cout<<endl;



		cout<<"\t\t<<-----Back To Main Menu-----"<<endl;
		getch();
		main();
		break;








	case 0:exit(0);
	default: clrscr();
		 cout<<"\t\tYou have entered a wrong choice.."<<endl;
		 cout<<"\t\tPlease Re-enter your choice...."<<endl;
		 cout<<endl;
		 cout<<"\t\t\t<<---Go Back---"<<endl;
		 getch();
		 main();
		 break;


}
}while(ch==0);
getch();
}

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

225

226

227

228

229

230

231

232

233

234

235

236

237

238

239

240

241

242

243

244

245

246

247

248

249

250

251

252

253

254

255

256

257

258

259

260

261

262

263

264

265

266

267

268

269

270

271

272

273

274

275

276

277

278

279

280

281

282

283

284

285

286

287

288

289

290

291

292

293

294

295

296

297

298

299

300

301

302

303

304

305

306

307

308

309

310

311

312

313

314

315

316

317

318

319

320

321

322

323

324

325

326

327

328

329

330

331

332

333

334

335

336

337

338

339

340

341

342

343

344

345

346

347

348

349

350

351

352

353

354

355

356

357

358

359

360

361

362

363

364

365

366

367

368

369

370

371

372

373

374

375

376

377

378

379

380

381

382

383

384

385

386

387

388

389

390

391

392

393

394

395

396

397

398

399

400

401

402

403

404

405

406

407

408

409

410

411

412

413

414

415

416

417

418

419

420

421

422

423

424

425

426

427

428

429

430

431

432

433

434

435

436

437

438

439

440

441

442

443

444

445

446

447

448

449

450

451

452

453

454

455

456

457

458

459

460

461

462

463

464

465

466

467

468

469

470

471

472

473

474

475

476

477

478

479

480

481

482

483

484

485

486

487

488

489

490

491

492

493

494

495

496

497

498

499

500

501

502

503

504

505

506

507

508

509

510

511

512

513

514

515

516

517

518

519

520

521

522

523

524

525

526

527

528

529

530

531

532

533

534

535

536

537

538

539

540

541

542

543

544

545

546

547

548

549

550

551

552

553

554

555

556

557

558

559

560

561

562

563

564

565

566

567

568

569

570

571

572

573

574

575

576

577

578

579

580

581

582

583

584

585

586

587

588

589

590

591

592

593

594

595

596

597

598

599

600

601

602

603

604

605

606

607

608

609

610

611

612

613

614

615

616

617

618

619

620

621

622

623

624

625

626

627

628

629

630

631

632

633

634

635

636

637

638

639

640

641

642

643

644

645

646

647

648

649

650

651

652

653

654

655

656

657

658

659

660

661

662

663

664

665

666

667

668

669

670

671

672

673

674

675

676

677

678

679

680

681

682

683

684

685

686

687

688

689

690

691

692

693

694

695

696

697

698

699

700

701

702

703

704

705

706

707

708

709

710

711

712

713

714

715

716

717

718

719

720

721

722

723

724

725

726

727

728

729

730

731

732

733

734

735

736

737

738

739

740

741

742

743

744

745

746

747

748

749

750

751

752

753

754

755

756

757

758

759

760

761

762

763

764

765

766

767

768

769

770

771

772

773

774

775

776

777

778

779

780

781

782

783

784

785

786

787

788

789

790

791

792

793

794

#include<iostream.h>

#include<constream.h>

#include<stdlib.h>

#include<graphics.h>

#include<dos.h>

int n,n1;

int i;

int inc=0;

int inc1=0;

class book

{

public:

int bookcode;

char bookname[20];

char authorname[20];

char bookpub[20];

int bookprice;

int status;

public:

void addbook()

{

clrscr();

status=1;

cout<<"\t\t\t YOU HAVE CHOSEN TO ADD BOOK DETAILS"<<endl;

cout<<"\t\t\t^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^"<<endl;

cout<<endl;

inc++;

bookcode=100+inc;

cout<<"\n\tBook code :"<<bookcode;

cout<<endl;

cout<<"\n\tEnter book name :";

cin>>bookname;

cout<<"\n\tEnter author name :";

cin>>authorname;

cout<<"\n\tEnter publishing company :";

cin>>bookpub;

cout<<"\n\tEnter book price :";

cin>>bookprice;

}

void dispbook()

{

cout<<bookcode<<"\t\t"<<bookname<<"\t\t"<<authorname<<"\t\t"<<bookpub<<"\t\t"<<bookprice<<endl;

}

void liststat()

{

if(status==1)

{

cout<<"\t\tBookcode:"<<bookcode<<"\t\tStatus:Available"<<endl;

cout<<endl;

}

else

{

cout<<"\t\tBookcode:"<<bookcode<<"\t\tStatus:Issued"<<endl;

cout<<endl;

}

};book b[10];

class student

{

public:

int studid;

char studname[20];

char deptname[20];

int bookcount;

public:

void addstud()

{

clrscr();

cout<<"\t\tYOU HAVE CHOSEN TO ADD STUDENT DETAILS"<<endl;

cout<<"\t\t^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^"<<endl;

cout<<endl;

inc1++;

studid=100+inc1;

cout<<"\t\tStudent Id :"<<studid;

cout<<endl;

cout<<"\t\tEnter Student Name :";

cin>>studname;

cout<<endl;

cout<<"\t\tEnter Department Name :";

cin>>deptname;

cout<<endl;

bookcount=2;

cout<<endl;

cout<<"\t\tMaximum books allowed for a student:"<<bookcount<<endl;

cout<<endl;

}

void dispstud()

{

cout<<"\t"<<studid<<"\t\t"<<studname<<"\t\t"<<deptname<<endl;

//bookcount=2;

cout<<endl;

}

};student s[10];

class issue

{

public:

int day,month,year;

int day2,month2,year2;

int iday,imon,iyear;

int rday,rmon,ryear;

int eday,emon,eyear;

int yr1,yr2,m1,m2,d1,d2,mons1,mons2,mons,days,yrs,sum,j;

int loop;

int fine;

public:

void isdatecalc()

{

cout<<"\t\tEnter day:";

cin>>day;

cout<<"\t\tEnter month:";

cin>>month;

cout<<"\t\tEnter year:";

cin>>year;

day2=day;

month2=month;

year2=year;

day2=day2+20;

if(((month2==1)||(month2==3)||(month2==5)||(month2==7)||(month2==8)||(month2==10)||(month2==12))&&((day2>31)))

{

day2=day2-31;

month2=month2+1;

if(month2==13)

{

year2++;

month2=1;

}

else if(((month2==4)||(month2==6)||(month2==9)||(month2==11))&&((day2>30)))

{

day2-=30;

month2++;

}

else if(((year2%4==0)||(year2%400==0))&&(day2>29)&&(month==2))

{

day2-=29;

month2++;

}

else if(((year2%4!=0)||(year2%100!=0)||(year2%400!=0))&&(day2>28)&&(month2==2))

{

day2-=28;

month2++;

}

cout<<endl;

}

void isdate()

{

iday=day;

imon=month;

iyear=year;

cout<<"\t\tIssued date:"<<iday<<"/"<<imon<<"/"<<iyear;

cout<<endl;

}

void retdate()

{

rday=day2;

rmon=month2;

ryear=year2;

cout<<"\t\tReturn Date:"<<rday<<"/"<<rmon<<"/"<<ryear<<endl;

cout<<endl;

}

void edatecalc()

{

eday=rday;

emon=rmon;

eyear=ryear;

eday=eday+20;

if(((emon==1)||(emon==3)||(emon==5)||(emon==7)||(emon==8)||(emon==10)||(emon==12))&&((eday>31)))

{

eday=eday-31;

emon=emon+1;

if(emon==13)

{

eyear++;

emon=1;

}

else if(((emon==4)||(emon==6)||(emon==9)||(emon==11))&&((eday>30)))

{

eday-=30;

emon++;

}

else if(((eyear%4==0)||(eyear%100==0)||(eyear%400==0))&&(eday>29)&&(emon==2))

{

eday-=29;

emon++;

}

else if(((eyear%4!=0)||(eyear%100!=0)||(eyear%400!=0))&&(eday>28)&&(emon==2))

{

eday-=28;

emon++;

}

cout<<endl;

cout<<"\t\tYour extended due date is:"<<eday<<"/"<<emon<<"/"<<eyear<<endl;

}

void finecalc();

}; issue is;

void issue::finecalc()

{

int mon[]={31,28,31,30,31,30,31,31,30,31,30,31};

loop=365;

sum=0;

d1=rday;

m1=rmon;

yr1=ryear;

cout<<endl;

cout<<"\t\tYour actual return Date Is: "<<d1<<"/"<<m1<<"/"<<yr1<<endl;

cout<<endl;

cout<<"\t\tEnter the date of return below.."<<endl;

cout<<endl;

cout<<"\t\tEnter day:";

cin>>d2;

cout<<endl;

cout<<"\t\tEnter month:";

cin>>m2;

cout<<endl;

cout<<"\t\tEnter year:";

cin>>yr2;

cout<<endl;

days=d2-d1;

yrs=yr2-yr1;

if(m2>=m1)

{

mons=m1-m2;

mons2=abs(mons);

}

else

{

mons=m2-m1;

mons2=abs(mons);

}

sum=yrs*loop+mons+days+mons2;

if(m2>m1)

{

j=m1;

}

else

{

j=m2;

}

if(mons2!=0)

{

for(i=0;i<mons2;i++)

{

sum=sum+mon[j];

j++;

}

cout<<endl;

cout<<"\t\tYour date of return:"<<d2<<"/"<<m2<<"/"<<yr2<<endl;

cout<<endl;

fine=(sum+mons)*1;

if((yr1%4==0)||(yr1%400==0)&&(m1==2))

{

fine=fine+1;

}

/* if((m1==2)&&(yr1%4!=0)||(yr1%400!=0))

{

fine=fine-1;

}*/

cout<<"\t\t\tFine amount:Rs."<<fine<<endl;

cout<<"\t\t\t*****************"<<endl;

}

void main()

{

int ch,i;

char ch2,ch3,ch4;

int sbookcode,sstudid;

int flag,flag1,pos,spos,ipos;

int sflag,stpos;

int ibookcode,istudid;

int rbookcode,rstudid;

int rflag1,rflag2;

int rpos1,rpos2,l;

{

clrscr();

textcolor(15);

textbackground(4);

cout<<"\t\t\t********%%%%%%%%%%********"<<endl;

cout<<"\t\t\tLIBRARY MANAGEMENT SYSTEM"<<endl;

cout<<"\t\t\t********%%%%%%%%%%********"<<endl;

cout<<endl;

cout<<"\t\t\t\tMAINMENU"<<endl;

cout<<"\t\t\t\t^^^^^^^^"<<endl;

cout<<endl;

cout<<"\t\t ##############################################"<<endl;

cout<<endl;

cout<<"\t\t$ \t1. TAKE A TOUR OF THE PROJECT. \t$"<<endl;

cout<<"\t\t$ \t2. ADD NEW BOOK. \t$"<<endl;

cout<<"\t\t$ \t3. VIEW ALL BOOK DETAILS. \t$"<<endl;

cout<<"\t\t$ \t4. SEARCH A BOOK. \t$"<<endl;

cout<<"\t\t$ \t5. ADD NEW STUDENT. \t$"<<endl;

cout<<"\t\t$ \t6. DISPLAY ALL STUDENT DETAILS. \t$"<<endl;

cout<<"\t\t$ \t7. VIEW A STUDENT. \t$"<<endl;

cout<<"\t\t$ \t8. ISSUE BOOK. \t$"<<endl;

cout<<"\t\t$ \t9. RETURN BOOK. \t$"<<endl;

cout<<"\t\t$ \t0. EXIT. \t$"<<endl;

cout<<endl;

cout<<"\t\t ##############################################"<<endl;

cout<<endl;

cout<<"\t\t\t\tHit your choice:";

cin>>ch;

switch(ch)

{

case 1:clrscr();

int d,m;

d=DETECT;

initgraph(&d,&m," ");

cleardevice();

for(int g=440;g>=-250;g--)

{

cleardevice();

setcolor(5);

outtextxy(250,g,"WELCOME TO");

outtextxy(230,g+20,"LIBRARY MANAGEMENT");

outtextxy(260,g+40,"SYSTEM");

setcolor(6);

outtextxy(250,g+100,"MADE BY");

outtextxy(250,g+120,"*******");

outtextxy(180,g+140,"NARMADHA.S.T");

setcolor(3);

setcolor(12);

setbkcolor(14);

settextstyle(7,0,5);

outtextxy(250,g+250,"THANK YOU");

delay(20);

}

cleardevice();

cout<<endl;

cout<<"\t The Project Library Management System contains three "<<endl;

cout<<"\t different modules."<<endl;

cout<<endl;

cout<<"\t We can add new books,see the list of added books,"<<endl;

cout<<"\t search a particular book."<<endl;

cout<<endl;

cout<<"\t Similarly, we can add new students, view the list of"<<endl;

cout<<"\t all added students with their course details and view"<<endl;

cout<<"\t a single student."<<endl;

cout<<endl;

cout<<"\t The main module in the project is the issue-return module."<<endl;

cout<<endl;

cout<<"\t We can issue only two books to a student.The issued period"<<endl;

cout<<"\t is for twenty days.So within twenty days, the student should"<<endl;

cout<<"\t return the book or can extend further for a period of twenty"<<endl;

cout<<"\t days.If neither returned nor extended,a fine of Re.1/day is"<<endl;

cout<<"\t collected on the day of return."<<endl;

cout<<endl<<endl;

cout<<"\t\t\t\t THANK YOU"<<endl;

cout<<endl;

cout<<"\t\t\t\t Narmadha.S.T"<<endl;

cout<<endl;

cout<<"\t\t\t<<-----BACK TO MAIN MENU-----"<<endl;

getch();

closegraph();

main();

getch();

break;

case 2:clrscr();

cout<<"\t\tYOU HAVE CHOSEN TO ADD BOOK DETAILS"<<endl;

cout<<"\t\t^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^"<<endl;

cout<<endl;

cout<<"\t\tEnter number of books to be added:";

cin>>n;

for(i=1;i<=n;i++)

{

cout<<"Enter book code:"<<100+i;

b[i].addbook();

}

cout<<endl;

cout<<"\t\t<<-----Back To Main Menu-----"<<endl;

getch();

main();

break;

case 3:clrscr();

cout<<"\t\t\tLIST OF ALL ADDED BOOKS"<<endl;

cout<<"\t\t\t^^^^^^^^^^^^^^^^^^^^^^^"<<endl;

cout<<endl;

cout<<"**********************************************************************"<<endl;

cout<<"BOOKCODE\tBOOKNAME\tAUTHORNAME\tPUB.COMPANY\tPRICE"<<endl;

cout<<"**********************************************************************"<<endl;

for(i=1;i<=n;i++)

{

b[i].dispbook();

}

cout<<endl;

for(i=1;i<=n;i++)

{

b[i].liststat();

}

cout<<endl;

cout<<"\t\t<<-----Back To Main Menu-----"<<endl;

getch();

main();

break;

case 4:clrscr();

cout<<"\t\t\tSEARCH A BOOK"<<endl;

cout<<"\t\t\t^^^^^^^^^^^^^^"<<endl;

cout<<endl;

cout<<"\t\tEnter book code to search:";

cin>>sbookcode;

for(i=1;i<=n;i++)

{

if(sbookcode==b[i].bookcode)

{

flag=1;

pos=i;

}

if(flag==1)

{

cout<<endl;

cout<<"\t\tBook is available!!"<<endl;

cout<<endl;

cout<<"\t\tTHE BOOK DETAILS ARE..."<<endl;

cout<<endl;

cout<<"\t\tBook code :"<<b[pos].bookcode<<endl;

cout<<"\t\tBook name :"<<b[pos].bookname<<endl;

cout<<"\t\tAuthor name :"<<b[pos].authorname<<endl;

cout<<"\t\tPublishing company :"<<b[pos].bookpub<<endl;

cout<<"\t\tBook price :"<<b[pos].bookprice<<endl;

}

else

{

cout<<endl;

cout<<"\t\tSorry!..No Book Exists With Code:"<<sbookcode<<endl;

}

cout<<endl;

cout<<"\t\t"<<"<<-----Back To Main Menu-----"<<endl;

getch();

main();

break;

case 5:clrscr();

cout<<"\t\tYOU HAVE CHOSEN TO ADD STUDENT DETAILS"<<endl;

cout<<"\t\t^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^"<<endl;

cout<<endl;

cout<<"\t\tEnter number of students to be added:";

cin>>n1;

for(i=1;i<=n1;i++)

{

s[i].addstud();

}

cout<<endl;

cout<<"\t\tNumber of newly added students:"<<n1<<endl;

cout<<endl;

cout<<"\t\t<<-----Back To Main Menu-----"<<endl;

getch();

main();

break;

case 6:clrscr();

cout<<"\t\tLIST OF ALL ADDED STUDENTS"<<endl;

cout<<"\t\t^^^^^^^^^^^^^^^^^^^^^^^^^^"<<endl;

cout<<endl;

cout<<"\t******************************************"<<endl;

cout<<"\tSTUDENT ID\tSTUDENT NAME\tDEPT NAME"<<endl;

cout<<"\t******************************************"<<endl;

for(i=1;i<=n1;i++)

{

s[i].dispstud();

}

cout<<endl;

cout<<"\t<<-----Back To Main Menu-----"<<endl;

getch();

main();

break;

case 7:clrscr();

cout<<"\t\t\tVIEW A STUDENT"<<endl;

cout<<"\t\t\t^^^^^^^^^^^^^^"<<endl;

cout<<endl;

cout<<"\t\tEnter student id to view:";

cin>>sstudid;

for(i=1;i<=n1;i++)

{

if(sstudid==s[i].studid)

{

sflag=1;

stpos=i;

}

if(sflag==1)

{

cout<<endl;

cout<<"\t\tStudent found!!"<<endl;

cout<<endl;

cout<<"\t\tTHE STUDENT DETAILS ARE..."<<endl;

cout<<endl;

cout<<"\t\tStudent name :"<<s[stpos].studname<<endl;

cout<<"\t\tDepartment name :"<<s[stpos].deptname<<endl;

}

else

{

cout<<endl;

cout<<"\t\tSorry!..No Student found with this id:"<<sstudid<<endl;

}

cout<<endl;

cout<<"\t\t"<<"<<-----Back To Main Menu-----"<<endl;

getch();

main();

break;

case 8:clrscr();

cout<<"\t\t YOU HAVE CHOSEN TO ISSUE A BOOK"<<endl;

cout<<"\t\t^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^"<<endl;

cout<<endl;

cout<<"\t\tEnter student id:";

cin>>istudid;

for(i=1;i<=n1;i++)

{

if(istudid==s[i].studid)

{

flag=1;

spos=i;

}

if(flag==1)

{

cout<<"\t\tEnter book code to issue book:";

cin>>ibookcode;

for(i=1;i<=n;i++)

{

if(ibookcode==b[i].bookcode)

{

flag1=1;

ipos=i;

}

cout<<endl;

if(flag==1)

{

if(flag1==1)

{

if(s[spos].bookcount!=0)

{

if(b[ipos].status==1)

{

s[spos].bookcount--;

b[ipos].status=0;

cout<<"\t\tDate of issue"<<endl;

cout<<"\t\t~~~~~~~~~~~~~"<<endl;

is.isdatecalc();

is.isdate();

is.retdate();

cout<<"\t\tThis book is now issued...."<<endl;

cout<<endl;

cout<<"\t\tBooks allowed now:"<<s[spos].bookcount<<endl;

cout<<endl;

cout<<"\t Student Id\t Student Name\t BookCode"<<endl;

cout<<"\t ----------\t ------------\t --------"<<endl;

cout<<"\t "<<s[spos].studid<<"\t\t "<<s[spos].studname<<"\t\t "<<b[ipos].bookcode<<endl;

}

else

{

cout<<"\t\tSorry!Book already issued.."<<endl;

}

else

{

cout<<"\t\tSorry!.You cannot take more than two books.."<<endl;

}

else

{

cout<<"\t\tSorry!..No Book Exists With Code:"<<ibookcode<<endl;

}

else

{

cout<<"\t\tSorry!..No Student Exists with Id:"<<istudid<<endl;

}

cout<<endl;

cout<<"\t\t<<-----Back To Main Menu-----"<<endl;

getch();

main();

break;

case 9:clrscr();

cout<<"\t\tYOU HAVE CHOSEN TO RETURN A BOOK"<<endl;

cout<<"\t\t^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^"<<endl;

cout<<endl;

cout<<"\t\tEnter student id:";

cin>>rstudid;

cout<<endl;

for(i=1;i<=n1;i++)

{

if(rstudid==s[i].studid)

{

rflag1=1;

rpos1=i;

}

if(rflag1==1)

{

cout<<"\t\tEnter book code to return book:";

cin>>rbookcode;

cout<<endl;

for(i=1;i<=n;i++)

{

if(rbookcode==b[i].bookcode)

{

rflag2=1;

rpos2=i;

}

if(rflag1==1)

{

if(rflag2==1)

{

cout<<"\tIs the bookcode:"<<b[rpos2].bookcode<<" issued to student id:"<<s[rpos1].studid<<" ?y/n:";

cin>>ch4;

if(ch4=='y')

{

if(b[rpos2].status==0)

{

cout<<endl;

cout<<"\t\tYou can Return the Book..."<<endl;

cout<<endl;

is.retdate();

cout<<"\t\tAre you sure you want to return this book ?y/n:";

cin>>ch2;

cout<<endl;

if(ch2=='y')

{

cout<<"\t\t Is the book returned before due date?y/n:";

cin>>ch3;

cout<<endl;

if(ch3=='y')

{

// is.retdate();

//cout<<endl;

cout<<"\t\tBook returned before due date"<<endl;

cout<<endl;

cout<<"\t\t\tFine - NIL"<<endl;

cout<<endl;

cout<<"\t\t\t THANK YOU"<<endl;

b[rpos2].status=1;

s[rpos1].bookcount++;

cout<<endl;

cout<<"\t\t<<-----Back To Main Menu-----"<<endl;

getch();

main();

}

else

{

clrscr();

cout<<endl;

cout<<"\t\tYOU HAVE TO PAY FINE !!!"<<endl;

is.finecalc();

cout<<endl;

b[rpos2].status=1;

s[rpos1].bookcount++;

cout<<"\t\t<<-----Back To Main Menu-----"<<endl;

getch();

main();

}

else

{

is.retdate();

cout<<endl;

cout<<"\t\tYou can extend the book for another twenty days.."<<endl;

is.edatecalc();

}

else

{

cout<<endl;

cout<<"\t\tThis Book is not yet issued from library.. "<<endl;

}

else

{

cout<<endl;

cout<<"\t\t This book is not issued to you..Sorry!!!"<<endl;

}

else

{

cout<<endl;

cout<<"\t\tSorry!..No Book Exists With Code:"<<rbookcode<<endl;

}

else

{

cout<<endl;

cout<<"\t\tSorry!..No Student Exists With Id:"<<rstudid<<endl;

}

cout<<endl;

cout<<"\t\t<<-----Back To Main Menu-----"<<endl;

getch();

main();

break;

case 0:exit(0);

default: clrscr();

cout<<"\t\tYou have entered a wrong choice.."<<endl;

cout<<"\t\tPlease Re-enter your choice...."<<endl;

cout<<endl;

cout<<"\t\t\t<<---Go Back---"<<endl;

getch();

main();

break;

}

}while(ch==0);

getch();

}

Free Download Source code OF LIBRARY MANAGEMENT SYSTEM Project in C++ – Free Download Library Management System Software Documentation FUNCTIONAL REQUIREMENTS OF LIBRARY MANAGEMENT SYSTEM Non FUNCTIONAL REQUIREMENTS OF LIBRARY MANAGEMENT SYSTEM Use Case Diagram of Library Management System Class Diagram of …

Source code OF LIBRARY MANAGEMENT SYSTEM Project in C++ – Free Download Read More »

LIBRARY MANAGEMENT SYSTEM C# Download Source code OF Project (FYP)

Leave a Comment / C# Projects / By Projects Inventory

Let’s see the code of the LIBRARY MANAGEMENT SYSTEM project in C#. frmOverdue.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using LibrarySystem.Includes;
using LibrarySystem.Properties;

namespace LibrarySystem
{
    public partial class frmOverdue : Form
    {
        public frmOverdue()
        {
            InitializeComponent();
        }

        SQLConfig config = new SQLConfig();
        usableFunction funct = new usableFunction();
        string sql;

        private void btnPenNew_Click(object sender, EventArgs e)
        {
            funct.clearTxt(GroupBox7);
            funct.clearTxt(GroupBox10);


            sql = "SELECT br.`BorrowerId`, `BookTitle`,`DateBorrowed`, `Purpose`, `DueDate` , BorrowId,br.AccessionNo " + 
              " FROM `tblborrow` br,`tblbooks` b,`tblborrower` bw  " + 
              " WHERE br.AccessionNo=b.AccessionNo AND br.`BorrowerId`=bw.`BorrowerId` AND br.Status='Borrowed' AND Due=1 ";
            config.Load_ResultList(sql, dtgPenalties);
            dtgPenalties.Columns[5].Visible = false;
            dtgPenalties.Columns[6].Visible = false;

        }

        private void frmOverdue_Load(object sender, EventArgs e)
        {
            btnPenNew_Click(sender, e);
        }

        private void txtSearchPborrower_TextChanged(object sender, EventArgs e)
        {
            sql = "SELECT br.`BorrowerId`, `BookTitle`,`DateBorrowed`, `Purpose`, `DueDate` , BorrowId,br.AccessionNo " +
             " FROM `tblborrow` br,`tblbooks` b,`tblborrower` bw  " +
             " WHERE br.AccessionNo=b.AccessionNo AND br.`BorrowerId`=bw.`BorrowerId` AND br.Status='Borrowed' AND Due=1 AND   br.`BorrowerId` Like '%" + txtSearchPborrower.Text + "%'";
            config.Load_ResultList(sql, dtgPenalties);
            dtgPenalties.Columns[5].Visible = false;
            dtgPenalties.Columns[6].Visible = false;
        }

        private void dtgPenalties_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            sql = "SELECT  TIMEDIFF( NOW( ) ,  `DueDate` ),`AccessionNo` " 
                 + "FROM  `tblborrow` WHERE `BorrowId` = '" + dtgPenalties.CurrentRow.Cells[5].Value.ToString() + "'";
            config.singleResult(sql);
            if (config.dt.Rows.Count > 0)
            {
                TimeSpan ts = config.dt.Rows[0].Field<TimeSpan>(0);
                int tsdays, hourperday, tshours, totalhours;
                //MessageBox.Show(ts.Hours.ToString());

                tsdays = ts.Days;

                hourperday = tsdays * 24;
                tshours = ts.Hours;
                totalhours = hourperday + tshours;



                txtOverdueTime.Text = ts.ToString();
                txttothours.Text = totalhours.ToString();

            } 

        }

        private void txtamount_TextChanged(object sender, EventArgs e)
        {

            try
            {
                int totalpayments;

                totalpayments = int.Parse(txttothours.Text) * int.Parse(txtamount.Text);

            }
            catch (Exception ex)
            {

            }
        
            //totalhours = condays + tValueHour
            //totalhours = totalhours / Val(frmPayments.txthours.Text)
            //frmPayments.txtTotPay.Text = totalhours * Val(frmPayments.txtamount.Text)
        }
         
        private void txthours_ValueChanged(object sender, EventArgs e)
        {
            try
            {

                double total_hours, total_payments;

                total_hours = int.Parse(txttothours.Text) / int.Parse(txthours.Text);
                total_payments = total_hours * double.Parse(txtamount.Text);

                txtTotPay.Text = total_payments.ToString();

            }
            catch (Exception ex)
            {

            }
        }

        private void txthours_KeyPress(object sender, KeyPressEventArgs e)
        {
            try
            {

                double total_hours, total_payments;

                total_hours = int.Parse(txttothours.Text) / int.Parse(txthours.Text);
                total_payments = total_hours * double.Parse(txtamount.Text);

                txtTotPay.Text = total_payments.ToString();

            }
            catch (Exception ex)
            {

            }
        }

        private void txttenderedAmount_TextChanged(object sender, EventArgs e)
        {
            double change;
            change = double.Parse(txttenderedAmount.Text) - double.Parse(txtTotPay.Text);
            txtChange.Text = change.ToString();
        }

        private void btnPSave_Click(object sender, EventArgs e)
        {
            if (txtamount.Text == "" || txthours.Text == "" || txttenderedAmount.Text == "" || txtOverdueTime.Text == "")
            {
                MessageBox.Show("You must fill all the fields inorder to save.", "Invalid", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                return;
            }
            if(int.Parse(txtChange.Text) < 0)
            {
                MessageBox.Show("The tendered amount is less than the total payments. Its not valid", "Invalid", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                return;

            }


            sql = "INSERT INTO `tblpayment` (`BorrowId`, `Payment`, `Change`, `DatePayed`, `BorrowerId`, `Remarks`) "
                + " VALUES (" + dtgPenalties.CurrentRow.Cells[6].Value + ",'" + txtTotPay.Text + "','" + txtChange.Text +
                "',Now(),'" + dtgPenalties.CurrentRow.Cells[0].Value + "','Settled')";
            config.Execute_Query(sql);

            sql = "INSERT INTO `tblreturn` (`BorrowId`, `NoCopies`, `DateReturned`, `Remarks`)" +
                  " VALUES (" + dtgPenalties.CurrentRow.Cells[6].Value + ",1,NOW(),'Returned')";
            config.Execute_Query(sql);


            sql = "UPDATE  `tblbooks` SET  `Status` =  'Available' WHERE  `AccessionNo` = '" + dtgPenalties.CurrentRow.Cells[6].Value + "'";
            config.Execute_Query(sql);

            sql = "UPDATE `tblborrow` SET  `Status` =  'Returned', Due = 0 WHERE `BorrowId` = " + dtgPenalties.CurrentRow.Cells[5].Value;
            config.Execute_Query(sql);

            MessageBox.Show("Book has been returned and settled in the library");
            btnPenNew_Click(sender, e); 
        }

        private void btnPenClose_Click(object sender, EventArgs e)
        {
            this.Close();
        }
    }
}

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Windows.Forms;

using LibrarySystem.Includes;

using LibrarySystem.Properties;

namespace LibrarySystem

{

public partial class frmOverdue : Form

{

public frmOverdue()

{

InitializeComponent();

}

SQLConfig config = new SQLConfig();

usableFunction funct = new usableFunction();

string sql;

private void btnPenNew_Click(object sender, EventArgs e)

{

funct.clearTxt(GroupBox7);

funct.clearTxt(GroupBox10);

sql = "SELECT br.`BorrowerId`, `BookTitle`,`DateBorrowed`, `Purpose`, `DueDate` , BorrowId,br.AccessionNo " +

" FROM `tblborrow` br,`tblbooks` b,`tblborrower` bw " +

" WHERE br.AccessionNo=b.AccessionNo AND br.`BorrowerId`=bw.`BorrowerId` AND br.Status='Borrowed' AND Due=1 ";

config.Load_ResultList(sql, dtgPenalties);

dtgPenalties.Columns[5].Visible = false;

dtgPenalties.Columns[6].Visible = false;

}

private void frmOverdue_Load(object sender, EventArgs e)

{

btnPenNew_Click(sender, e);

}

private void txtSearchPborrower_TextChanged(object sender, EventArgs e)

{

sql = "SELECT br.`BorrowerId`, `BookTitle`,`DateBorrowed`, `Purpose`, `DueDate` , BorrowId,br.AccessionNo " +

" FROM `tblborrow` br,`tblbooks` b,`tblborrower` bw " +

" WHERE br.AccessionNo=b.AccessionNo AND br.`BorrowerId`=bw.`BorrowerId` AND br.Status='Borrowed' AND Due=1 AND br.`BorrowerId` Like '%" + txtSearchPborrower.Text + "%'";

config.Load_ResultList(sql, dtgPenalties);

dtgPenalties.Columns[5].Visible = false;

dtgPenalties.Columns[6].Visible = false;

}

private void dtgPenalties_CellClick(object sender, DataGridViewCellEventArgs e)

{

sql = "SELECT TIMEDIFF( NOW( ) , `DueDate` ),`AccessionNo` "

+ "FROM `tblborrow` WHERE `BorrowId` = '" + dtgPenalties.CurrentRow.Cells[5].Value.ToString() + "'";

config.singleResult(sql);

if (config.dt.Rows.Count > 0)

{

TimeSpan ts = config.dt.Rows[0].Field<TimeSpan>(0);

int tsdays, hourperday, tshours, totalhours;

//MessageBox.Show(ts.Hours.ToString());

tsdays = ts.Days;

hourperday = tsdays * 24;

tshours = ts.Hours;

totalhours = hourperday + tshours;

txtOverdueTime.Text = ts.ToString();

txttothours.Text = totalhours.ToString();

}

private void txtamount_TextChanged(object sender, EventArgs e)

{

try

{

int totalpayments;

totalpayments = int.Parse(txttothours.Text) * int.Parse(txtamount.Text);

}

catch (Exception ex)

{

}

//totalhours = condays + tValueHour

//totalhours = totalhours / Val(frmPayments.txthours.Text)

//frmPayments.txtTotPay.Text = totalhours * Val(frmPayments.txtamount.Text)

}

private void txthours_ValueChanged(object sender, EventArgs e)

{

try

{

double total_hours, total_payments;

total_hours = int.Parse(txttothours.Text) / int.Parse(txthours.Text);

total_payments = total_hours * double.Parse(txtamount.Text);

txtTotPay.Text = total_payments.ToString();

}

catch (Exception ex)

{

}

private void txthours_KeyPress(object sender, KeyPressEventArgs e)

{

try

{

double total_hours, total_payments;

total_hours = int.Parse(txttothours.Text) / int.Parse(txthours.Text);

total_payments = total_hours * double.Parse(txtamount.Text);

txtTotPay.Text = total_payments.ToString();

}

catch (Exception ex)

{

}

private void txttenderedAmount_TextChanged(object sender, EventArgs e)

{

double change;

change = double.Parse(txttenderedAmount.Text) - double.Parse(txtTotPay.Text);

txtChange.Text = change.ToString();

}

private void btnPSave_Click(object sender, EventArgs e)

{

if (txtamount.Text == "" || txthours.Text == "" || txttenderedAmount.Text == "" || txtOverdueTime.Text == "")

{

MessageBox.Show("You must fill all the fields inorder to save.", "Invalid", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);

return;

}

if(int.Parse(txtChange.Text) < 0)

{

MessageBox.Show("The tendered amount is less than the total payments. Its not valid", "Invalid", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);

return;

}

sql = "INSERT INTO `tblpayment` (`BorrowId`, `Payment`, `Change`, `DatePayed`, `BorrowerId`, `Remarks`) "

+ " VALUES (" + dtgPenalties.CurrentRow.Cells[6].Value + ",'" + txtTotPay.Text + "','" + txtChange.Text +

"',Now(),'" + dtgPenalties.CurrentRow.Cells[0].Value + "','Settled')";

config.Execute_Query(sql);

sql = "INSERT INTO `tblreturn` (`BorrowId`, `NoCopies`, `DateReturned`, `Remarks`)" +

" VALUES (" + dtgPenalties.CurrentRow.Cells[6].Value + ",1,NOW(),'Returned')";

config.Execute_Query(sql);

sql = "UPDATE `tblbooks` SET `Status` = 'Available' WHERE `AccessionNo` = '" + dtgPenalties.CurrentRow.Cells[6].Value + "'";

config.Execute_Query(sql);

sql = "UPDATE `tblborrow` SET `Status` = 'Returned', Due = 0 WHERE `BorrowId` = " + dtgPenalties.CurrentRow.Cells[5].Value;

config.Execute_Query(sql);

MessageBox.Show("Book has been returned and settled in the library");

btnPenNew_Click(sender, e);

}

private void btnPenClose_Click(object sender, EventArgs e)

{

this.Close();

}

frmCategories.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using LibrarySystem.Includes;
using LibrarySystem.Properties;
using System.IO;

namespace LibrarySystem
{
    public partial class frmCategories : Form
    {
        public frmCategories()
        {
            InitializeComponent();
        }

        SQLConfig config = new SQLConfig();
        usableFunction funct = new usableFunction();
        string sql,categoryid;
        private void frmCategories_Load(object sender, EventArgs e)
        {
            btnnew_Click(sender, e);
        }

        private void btnnew_Click(object sender, EventArgs e)
        {
            categoryid = "0";
            txtCategory.Clear();
            txtDeweyDecimal.Clear();
            sql = "Select CategoryId,`Category`,`DDecimal` as 'DeweyDecimal' From tblcategory WHERE Category !='ALL'";
            config.Load_DTG(sql, dtglist);
            btndelete.Enabled = false;
        }

        private void btnsave_Click(object sender, EventArgs e)
        {

            if( txtCategory.Text == "")
            {
                funct.emptymessage();
            }

            sql = "Select * From tblcategory WHERE CategoryId = '" + categoryid + "'";
            config.singleResult(sql);
            if (config.dt.Rows.Count > 0)
            {
                sql = "UPDATE `tblcategory` SET `Category`='" + txtCategory.Text + "',`DDecimal`='" + txtDeweyDecimal.Text + "' WHERE CategoryId='" + categoryid + "'";
                config.Execute_CUD(sql, "error to execute the query.", "Category has been updated in the database.");
            }
            else
            {
                sql = "INSERT INTO `tblcategory` (`Category`,`DDecimal`) VALUES ('" + txtCategory.Text + "','" + txtDeweyDecimal.Text + "')";
                config.Execute_CUD(sql, "error to execute the query.", "New category has been saved in the database.");
            } 
            btnnew_Click(sender, e);

          
        }

        private void btndelete_Click(object sender, EventArgs e)
        {
            sql = "Delete From tblcategory WHERE CategoryId = " + dtglist.CurrentRow.Cells[0].Value;
            config.Execute_Query(sql);
            MessageBox.Show("Data has been deleted.");
            btnnew_Click(sender, e);
        }

        private void dtglist_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            categoryid = dtglist.CurrentRow.Cells[0].Value.ToString();
            txtCategory.Text = dtglist.CurrentRow.Cells[1].Value.ToString();
            txtDeweyDecimal.Text = dtglist.CurrentRow.Cells[2].Value.ToString();
            btndelete.Enabled = true;
        }
    }
}

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Windows.Forms;

using LibrarySystem.Includes;

using LibrarySystem.Properties;

using System.IO;

namespace LibrarySystem

{

public partial class frmCategories : Form

{

public frmCategories()

{

InitializeComponent();

}

SQLConfig config = new SQLConfig();

usableFunction funct = new usableFunction();

string sql,categoryid;

private void frmCategories_Load(object sender, EventArgs e)

{

btnnew_Click(sender, e);

}

private void btnnew_Click(object sender, EventArgs e)

{

categoryid = "0";

txtCategory.Clear();

txtDeweyDecimal.Clear();

sql = "Select CategoryId,`Category`,`DDecimal` as 'DeweyDecimal' From tblcategory WHERE Category !='ALL'";

config.Load_DTG(sql, dtglist);

btndelete.Enabled = false;

}

private void btnsave_Click(object sender, EventArgs e)

{

if( txtCategory.Text == "")

{

funct.emptymessage();

}

sql = "Select * From tblcategory WHERE CategoryId = '" + categoryid + "'";

config.singleResult(sql);

if (config.dt.Rows.Count > 0)

{

sql = "UPDATE `tblcategory` SET `Category`='" + txtCategory.Text + "',`DDecimal`='" + txtDeweyDecimal.Text + "' WHERE CategoryId='" + categoryid + "'";

config.Execute_CUD(sql, "error to execute the query.", "Category has been updated in the database.");

}

else

{

sql = "INSERT INTO `tblcategory` (`Category`,`DDecimal`) VALUES ('" + txtCategory.Text + "','" + txtDeweyDecimal.Text + "')";

config.Execute_CUD(sql, "error to execute the query.", "New category has been saved in the database.");

}

btnnew_Click(sender, e);

}

private void btndelete_Click(object sender, EventArgs e)

{

sql = "Delete From tblcategory WHERE CategoryId = " + dtglist.CurrentRow.Cells[0].Value;

config.Execute_Query(sql);

MessageBox.Show("Data has been deleted.");

btnnew_Click(sender, e);

}

private void dtglist_CellClick(object sender, DataGridViewCellEventArgs e)

{

categoryid = dtglist.CurrentRow.Cells[0].Value.ToString();

txtCategory.Text = dtglist.CurrentRow.Cells[1].Value.ToString();

txtDeweyDecimal.Text = dtglist.CurrentRow.Cells[2].Value.ToString();

btndelete.Enabled = true;

}

frmReport.Designer.cs

namespace LibrarySystem
{
    partial class frmReport
    {
        /// <summary>
        /// Required designer variable.
        /// </summary>
        private System.ComponentModel.IContainer components = null;

        /// <summary>
        /// Clean up any resources being used.
        /// </summary>
        /// <param name="disposing">true if managed resources should be disposed; otherwise, false.</param>
        protected override void Dispose(bool disposing)
        {
            if (disposing && (components != null))
            {
                components.Dispose();
            }
            base.Dispose(disposing);
        }

        #region Windows Form Designer generated code

        /// <summary>
        /// Required method for Designer support - do not modify
        /// the contents of this method with the code editor.
        /// </summary>
        private void InitializeComponent()
        {
            this.dtp_endDate = new System.Windows.Forms.DateTimePicker();
            this.btn_preview = new System.Windows.Forms.Button();
            this.btnTotalbooks = new System.Windows.Forms.Button();
            this.btnListBooks = new System.Windows.Forms.Button();
            this.rdoMonthly = new System.Windows.Forms.RadioButton();
            this.rdoWeekly = new System.Windows.Forms.RadioButton();
            this.rdoDaily = new System.Windows.Forms.RadioButton();
            this.dtp_strtDate = new System.Windows.Forms.DateTimePicker();
            this.Label2 = new System.Windows.Forms.Label();
            this.Label3 = new System.Windows.Forms.Label();
            this.Label1 = new System.Windows.Forms.Label();
            this.cboStatus = new System.Windows.Forms.ComboBox();
            this.GroupBox1 = new System.Windows.Forms.GroupBox();
            this.FlowLayoutPanel1 = new System.Windows.Forms.FlowLayoutPanel();
            this.GroupBox2 = new System.Windows.Forms.GroupBox();
            this.crystalReportViewer1 = new CrystalDecisions.Windows.Forms.CrystalReportViewer();
            this.GroupBox1.SuspendLayout();
            this.FlowLayoutPanel1.SuspendLayout();
            this.GroupBox2.SuspendLayout();
            this.SuspendLayout();
            // 
            // dtp_endDate
            // 
            this.dtp_endDate.CustomFormat = "yyyy-MM-dd";
            this.dtp_endDate.Format = System.Windows.Forms.DateTimePickerFormat.Custom;
            this.dtp_endDate.Location = new System.Drawing.Point(10, 89);
            this.dtp_endDate.Name = "dtp_endDate";
            this.dtp_endDate.Size = new System.Drawing.Size(132, 20);
            this.dtp_endDate.TabIndex = 17;
            // 
            // btn_preview
            // 
            this.btn_preview.Location = new System.Drawing.Point(64, 120);
            this.btn_preview.Name = "btn_preview";
            this.btn_preview.Size = new System.Drawing.Size(78, 28);
            this.btn_preview.TabIndex = 15;
            this.btn_preview.Text = "Preview";
            this.btn_preview.UseVisualStyleBackColor = true;
            this.btn_preview.Click += new System.EventHandler(this.btn_preview_Click);
            // 
            // btnTotalbooks
            // 
            this.btnTotalbooks.Location = new System.Drawing.Point(10, 53);
            this.btnTotalbooks.Name = "btnTotalbooks";
            this.btnTotalbooks.Size = new System.Drawing.Size(133, 22);
            this.btnTotalbooks.TabIndex = 3;
            this.btnTotalbooks.Text = "Total No. of Books";
            this.btnTotalbooks.UseVisualStyleBackColor = true;
            this.btnTotalbooks.Click += new System.EventHandler(this.btnTotalbooks_Click);
            // 
            // btnListBooks
            // 
            this.btnListBooks.Location = new System.Drawing.Point(9, 25);
            this.btnListBooks.Name = "btnListBooks";
            this.btnListBooks.Size = new System.Drawing.Size(133, 22);
            this.btnListBooks.TabIndex = 2;
            this.btnListBooks.Text = "List of Books";
            this.btnListBooks.UseVisualStyleBackColor = true;
            this.btnListBooks.Click += new System.EventHandler(this.btnListBooks_Click);
            // 
            // rdoMonthly
            // 
            this.rdoMonthly.AutoSize = true;
            this.rdoMonthly.Location = new System.Drawing.Point(24, 186);
            this.rdoMonthly.Name = "rdoMonthly";
            this.rdoMonthly.Size = new System.Drawing.Size(97, 17);
            this.rdoMonthly.TabIndex = 2;
            this.rdoMonthly.TabStop = true;
            this.rdoMonthly.Text = "Monthly Report";
            this.rdoMonthly.UseVisualStyleBackColor = true;
            this.rdoMonthly.CheckedChanged += new System.EventHandler(this.rdoMonthly_CheckedChanged);
            // 
            // rdoWeekly
            // 
            this.rdoWeekly.AutoSize = true;
            this.rdoWeekly.Location = new System.Drawing.Point(24, 163);
            this.rdoWeekly.Name = "rdoWeekly";
            this.rdoWeekly.Size = new System.Drawing.Size(96, 17);
            this.rdoWeekly.TabIndex = 2;
            this.rdoWeekly.TabStop = true;
            this.rdoWeekly.Text = "Weekly Report";
            this.rdoWeekly.UseVisualStyleBackColor = true;
            this.rdoWeekly.CheckedChanged += new System.EventHandler(this.rdoWeekly_CheckedChanged);
            // 
            // rdoDaily
            // 
            this.rdoDaily.AutoSize = true;
            this.rdoDaily.Location = new System.Drawing.Point(24, 140);
            this.rdoDaily.Name = "rdoDaily";
            this.rdoDaily.Size = new System.Drawing.Size(83, 17);
            this.rdoDaily.TabIndex = 2;
            this.rdoDaily.TabStop = true;
            this.rdoDaily.Text = "Daily Report";
            this.rdoDaily.UseVisualStyleBackColor = true;
            this.rdoDaily.CheckedChanged += new System.EventHandler(this.rdoDaily_CheckedChanged);
            // 
            // dtp_strtDate
            // 
            this.dtp_strtDate.CustomFormat = "yyyy-MM-dd";
            this.dtp_strtDate.Format = System.Windows.Forms.DateTimePickerFormat.Custom;
            this.dtp_strtDate.Location = new System.Drawing.Point(10, 41);
            this.dtp_strtDate.Name = "dtp_strtDate";
            this.dtp_strtDate.Size = new System.Drawing.Size(132, 20);
            this.dtp_strtDate.TabIndex = 14;
            // 
            // Label2
            // 
            this.Label2.AutoSize = true;
            this.Label2.Location = new System.Drawing.Point(10, 26);
            this.Label2.Name = "Label2";
            this.Label2.Size = new System.Drawing.Size(61, 13);
            this.Label2.TabIndex = 16;
            this.Label2.Text = "Start Date :";
            // 
            // Label3
            // 
            this.Label3.AutoSize = true;
            this.Label3.Location = new System.Drawing.Point(10, 73);
            this.Label3.Name = "Label3";
            this.Label3.Size = new System.Drawing.Size(58, 13);
            this.Label3.TabIndex = 18;
            this.Label3.Text = "End Date :";
            // 
            // Label1
            // 
            this.Label1.AutoSize = true;
            this.Label1.Location = new System.Drawing.Point(7, 84);
            this.Label1.Name = "Label1";
            this.Label1.Size = new System.Drawing.Size(43, 13);
            this.Label1.TabIndex = 1;
            this.Label1.Text = "Status :";
            // 
            // cboStatus
            // 
            this.cboStatus.FormattingEnabled = true;
            this.cboStatus.Items.AddRange(new object[] {
            "Borrowed",
            "Returned",
            "Overdue"});
            this.cboStatus.Location = new System.Drawing.Point(6, 103);
            this.cboStatus.Name = "cboStatus";
            this.cboStatus.Size = new System.Drawing.Size(137, 21);
            this.cboStatus.TabIndex = 0;
            this.cboStatus.Text = "Borrowed";
            // 
            // GroupBox1
            // 
            this.GroupBox1.Controls.Add(this.btnTotalbooks);
            this.GroupBox1.Controls.Add(this.btnListBooks);
            this.GroupBox1.Controls.Add(this.rdoMonthly);
            this.GroupBox1.Controls.Add(this.rdoWeekly);
            this.GroupBox1.Controls.Add(this.rdoDaily);
            this.GroupBox1.Controls.Add(this.Label1);
            this.GroupBox1.Controls.Add(this.cboStatus);
            this.GroupBox1.Location = new System.Drawing.Point(3, 3);
            this.GroupBox1.Name = "GroupBox1";
            this.GroupBox1.Size = new System.Drawing.Size(152, 229);
            this.GroupBox1.TabIndex = 0;
            this.GroupBox1.TabStop = false;
            this.GroupBox1.Text = "Books";
            // 
            // FlowLayoutPanel1
            // 
            this.FlowLayoutPanel1.Controls.Add(this.GroupBox1);
            this.FlowLayoutPanel1.Controls.Add(this.GroupBox2);
            this.FlowLayoutPanel1.Dock = System.Windows.Forms.DockStyle.Left;
            this.FlowLayoutPanel1.Location = new System.Drawing.Point(0, 0);
            this.FlowLayoutPanel1.Name = "FlowLayoutPanel1";
            this.FlowLayoutPanel1.Size = new System.Drawing.Size(161, 551);
            this.FlowLayoutPanel1.TabIndex = 3;
            // 
            // GroupBox2
            // 
            this.GroupBox2.Controls.Add(this.dtp_strtDate);
            this.GroupBox2.Controls.Add(this.Label2);
            this.GroupBox2.Controls.Add(this.Label3);
            this.GroupBox2.Controls.Add(this.dtp_endDate);
            this.GroupBox2.Controls.Add(this.btn_preview);
            this.GroupBox2.Location = new System.Drawing.Point(3, 238);
            this.GroupBox2.Name = "GroupBox2";
            this.GroupBox2.Size = new System.Drawing.Size(152, 162);
            this.GroupBox2.TabIndex = 2;
            this.GroupBox2.TabStop = false;
            this.GroupBox2.Text = "Date Filter";
            // 
            // crystalReportViewer1
            // 
            this.crystalReportViewer1.ActiveViewIndex = -1;
            this.crystalReportViewer1.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
            this.crystalReportViewer1.Cursor = System.Windows.Forms.Cursors.Default;
            this.crystalReportViewer1.Dock = System.Windows.Forms.DockStyle.Fill;
            this.crystalReportViewer1.Location = new System.Drawing.Point(161, 0);
            this.crystalReportViewer1.Name = "crystalReportViewer1";
            this.crystalReportViewer1.Size = new System.Drawing.Size(727, 551);
            this.crystalReportViewer1.TabIndex = 4;
            // 
            // frmReport
            // 
            this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
            this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
            this.ClientSize = new System.Drawing.Size(888, 551);
            this.Controls.Add(this.crystalReportViewer1);
            this.Controls.Add(this.FlowLayoutPanel1);
            this.Name = "frmReport";
            this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
            this.Text = "Inventory Reports";
            this.Load += new System.EventHandler(this.frmReport_Load);
            this.GroupBox1.ResumeLayout(false);
            this.GroupBox1.PerformLayout();
            this.FlowLayoutPanel1.ResumeLayout(false);
            this.GroupBox2.ResumeLayout(false);
            this.GroupBox2.PerformLayout();
            this.ResumeLayout(false);

        }

        #endregion
        internal System.Windows.Forms.DateTimePicker dtp_endDate;
        internal System.Windows.Forms.Button btn_preview;
        internal System.Windows.Forms.Button btnTotalbooks;
        internal System.Windows.Forms.Button btnListBooks;
        internal System.Windows.Forms.RadioButton rdoMonthly;
        internal System.Windows.Forms.RadioButton rdoWeekly;
        internal System.Windows.Forms.RadioButton rdoDaily;
        internal System.Windows.Forms.DateTimePicker dtp_strtDate;
        internal System.Windows.Forms.Label Label2;
        internal System.Windows.Forms.Label Label3;
        internal System.Windows.Forms.Label Label1;
        internal System.Windows.Forms.ComboBox cboStatus;
        internal System.Windows.Forms.GroupBox GroupBox1;
        internal System.Windows.Forms.FlowLayoutPanel FlowLayoutPanel1;
        internal System.Windows.Forms.GroupBox GroupBox2;
        private CrystalDecisions.Windows.Forms.CrystalReportViewer crystalReportViewer1;
    }
}

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

225

226

227

228

229

230

231

232

233

234

235

236

237

238

239

240

241

242

243

244

245

246

247

248

249

250

251

252

253

254

255

256

257

258

259

260

261

262

263

264

265

namespace LibrarySystem

{

partial class frmReport

{

/// <summary>

/// Required designer variable.

/// </summary>

private System.ComponentModel.IContainer components = null;

/// <summary>

/// Clean up any resources being used.

/// </summary>

/// <param name="disposing">true if managed resources should be disposed; otherwise, false.</param>

protected override void Dispose(bool disposing)

{

if (disposing && (components != null))

{

components.Dispose();

}

base.Dispose(disposing);

}

#region Windows Form Designer generated code

/// <summary>

/// Required method for Designer support - do not modify

/// the contents of this method with the code editor.

/// </summary>

private void InitializeComponent()

{

this.dtp_endDate = new System.Windows.Forms.DateTimePicker();

this.btn_preview = new System.Windows.Forms.Button();

this.btnTotalbooks = new System.Windows.Forms.Button();

this.btnListBooks = new System.Windows.Forms.Button();

this.rdoMonthly = new System.Windows.Forms.RadioButton();

this.rdoWeekly = new System.Windows.Forms.RadioButton();

this.rdoDaily = new System.Windows.Forms.RadioButton();

this.dtp_strtDate = new System.Windows.Forms.DateTimePicker();

this.Label2 = new System.Windows.Forms.Label();

this.Label3 = new System.Windows.Forms.Label();

this.Label1 = new System.Windows.Forms.Label();

this.cboStatus = new System.Windows.Forms.ComboBox();

this.GroupBox1 = new System.Windows.Forms.GroupBox();

this.FlowLayoutPanel1 = new System.Windows.Forms.FlowLayoutPanel();

this.GroupBox2 = new System.Windows.Forms.GroupBox();

this.crystalReportViewer1 = new CrystalDecisions.Windows.Forms.CrystalReportViewer();

this.GroupBox1.SuspendLayout();

this.FlowLayoutPanel1.SuspendLayout();

this.GroupBox2.SuspendLayout();

this.SuspendLayout();

// dtp_endDate

this.dtp_endDate.CustomFormat = "yyyy-MM-dd";

this.dtp_endDate.Format = System.Windows.Forms.DateTimePickerFormat.Custom;

this.dtp_endDate.Location = new System.Drawing.Point(10, 89);

this.dtp_endDate.Name = "dtp_endDate";

this.dtp_endDate.Size = new System.Drawing.Size(132, 20);

this.dtp_endDate.TabIndex = 17;

// btn_preview

this.btn_preview.Location = new System.Drawing.Point(64, 120);

this.btn_preview.Name = "btn_preview";

this.btn_preview.Size = new System.Drawing.Size(78, 28);

this.btn_preview.TabIndex = 15;

this.btn_preview.Text = "Preview";

this.btn_preview.UseVisualStyleBackColor = true;

this.btn_preview.Click += new System.EventHandler(this.btn_preview_Click);

// btnTotalbooks

this.btnTotalbooks.Location = new System.Drawing.Point(10, 53);

this.btnTotalbooks.Name = "btnTotalbooks";

this.btnTotalbooks.Size = new System.Drawing.Size(133, 22);

this.btnTotalbooks.TabIndex = 3;

this.btnTotalbooks.Text = "Total No. of Books";

this.btnTotalbooks.UseVisualStyleBackColor = true;

this.btnTotalbooks.Click += new System.EventHandler(this.btnTotalbooks_Click);

// btnListBooks

this.btnListBooks.Location = new System.Drawing.Point(9, 25);

this.btnListBooks.Name = "btnListBooks";

this.btnListBooks.Size = new System.Drawing.Size(133, 22);

this.btnListBooks.TabIndex = 2;

this.btnListBooks.Text = "List of Books";

this.btnListBooks.UseVisualStyleBackColor = true;

this.btnListBooks.Click += new System.EventHandler(this.btnListBooks_Click);

// rdoMonthly

this.rdoMonthly.AutoSize = true;

this.rdoMonthly.Location = new System.Drawing.Point(24, 186);

this.rdoMonthly.Name = "rdoMonthly";

this.rdoMonthly.Size = new System.Drawing.Size(97, 17);

this.rdoMonthly.TabIndex = 2;

this.rdoMonthly.TabStop = true;

this.rdoMonthly.Text = "Monthly Report";

this.rdoMonthly.UseVisualStyleBackColor = true;

this.rdoMonthly.CheckedChanged += new System.EventHandler(this.rdoMonthly_CheckedChanged);

// rdoWeekly

this.rdoWeekly.AutoSize = true;

this.rdoWeekly.Location = new System.Drawing.Point(24, 163);

this.rdoWeekly.Name = "rdoWeekly";

this.rdoWeekly.Size = new System.Drawing.Size(96, 17);

this.rdoWeekly.TabIndex = 2;

this.rdoWeekly.TabStop = true;

this.rdoWeekly.Text = "Weekly Report";

this.rdoWeekly.UseVisualStyleBackColor = true;

this.rdoWeekly.CheckedChanged += new System.EventHandler(this.rdoWeekly_CheckedChanged);

// rdoDaily

this.rdoDaily.AutoSize = true;

this.rdoDaily.Location = new System.Drawing.Point(24, 140);

this.rdoDaily.Name = "rdoDaily";

this.rdoDaily.Size = new System.Drawing.Size(83, 17);

this.rdoDaily.TabIndex = 2;

this.rdoDaily.TabStop = true;

this.rdoDaily.Text = "Daily Report";

this.rdoDaily.UseVisualStyleBackColor = true;

this.rdoDaily.CheckedChanged += new System.EventHandler(this.rdoDaily_CheckedChanged);

// dtp_strtDate

this.dtp_strtDate.CustomFormat = "yyyy-MM-dd";

this.dtp_strtDate.Format = System.Windows.Forms.DateTimePickerFormat.Custom;

this.dtp_strtDate.Location = new System.Drawing.Point(10, 41);

this.dtp_strtDate.Name = "dtp_strtDate";

this.dtp_strtDate.Size = new System.Drawing.Size(132, 20);

this.dtp_strtDate.TabIndex = 14;

// Label2

this.Label2.AutoSize = true;

this.Label2.Location = new System.Drawing.Point(10, 26);

this.Label2.Name = "Label2";

this.Label2.Size = new System.Drawing.Size(61, 13);

this.Label2.TabIndex = 16;

this.Label2.Text = "Start Date :";

// Label3

this.Label3.AutoSize = true;

this.Label3.Location = new System.Drawing.Point(10, 73);

this.Label3.Name = "Label3";

this.Label3.Size = new System.Drawing.Size(58, 13);

this.Label3.TabIndex = 18;

this.Label3.Text = "End Date :";

// Label1

this.Label1.AutoSize = true;

this.Label1.Location = new System.Drawing.Point(7, 84);

this.Label1.Name = "Label1";

this.Label1.Size = new System.Drawing.Size(43, 13);

this.Label1.TabIndex = 1;

this.Label1.Text = "Status :";

// cboStatus

this.cboStatus.FormattingEnabled = true;

this.cboStatus.Items.AddRange(new object[] {

"Borrowed",

"Returned",

"Overdue"});

this.cboStatus.Location = new System.Drawing.Point(6, 103);

this.cboStatus.Name = "cboStatus";

this.cboStatus.Size = new System.Drawing.Size(137, 21);

this.cboStatus.TabIndex = 0;

this.cboStatus.Text = "Borrowed";

// GroupBox1

this.GroupBox1.Controls.Add(this.btnTotalbooks);

this.GroupBox1.Controls.Add(this.btnListBooks);

this.GroupBox1.Controls.Add(this.rdoMonthly);

this.GroupBox1.Controls.Add(this.rdoWeekly);

this.GroupBox1.Controls.Add(this.rdoDaily);

this.GroupBox1.Controls.Add(this.Label1);

this.GroupBox1.Controls.Add(this.cboStatus);

this.GroupBox1.Location = new System.Drawing.Point(3, 3);

this.GroupBox1.Name = "GroupBox1";

this.GroupBox1.Size = new System.Drawing.Size(152, 229);

this.GroupBox1.TabIndex = 0;

this.GroupBox1.TabStop = false;

this.GroupBox1.Text = "Books";

// FlowLayoutPanel1

this.FlowLayoutPanel1.Controls.Add(this.GroupBox1);

this.FlowLayoutPanel1.Controls.Add(this.GroupBox2);

this.FlowLayoutPanel1.Dock = System.Windows.Forms.DockStyle.Left;

this.FlowLayoutPanel1.Location = new System.Drawing.Point(0, 0);

this.FlowLayoutPanel1.Name = "FlowLayoutPanel1";

this.FlowLayoutPanel1.Size = new System.Drawing.Size(161, 551);

this.FlowLayoutPanel1.TabIndex = 3;

// GroupBox2

this.GroupBox2.Controls.Add(this.dtp_strtDate);

this.GroupBox2.Controls.Add(this.Label2);

this.GroupBox2.Controls.Add(this.Label3);

this.GroupBox2.Controls.Add(this.dtp_endDate);

this.GroupBox2.Controls.Add(this.btn_preview);

this.GroupBox2.Location = new System.Drawing.Point(3, 238);

this.GroupBox2.Name = "GroupBox2";

this.GroupBox2.Size = new System.Drawing.Size(152, 162);

this.GroupBox2.TabIndex = 2;

this.GroupBox2.TabStop = false;

this.GroupBox2.Text = "Date Filter";

// crystalReportViewer1

this.crystalReportViewer1.ActiveViewIndex = -1;

this.crystalReportViewer1.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;

this.crystalReportViewer1.Cursor = System.Windows.Forms.Cursors.Default;

this.crystalReportViewer1.Dock = System.Windows.Forms.DockStyle.Fill;

this.crystalReportViewer1.Location = new System.Drawing.Point(161, 0);

this.crystalReportViewer1.Name = "crystalReportViewer1";

this.crystalReportViewer1.Size = new System.Drawing.Size(727, 551);

this.crystalReportViewer1.TabIndex = 4;

// frmReport

this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);

this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;

this.ClientSize = new System.Drawing.Size(888, 551);

this.Controls.Add(this.crystalReportViewer1);

this.Controls.Add(this.FlowLayoutPanel1);

this.Name = "frmReport";

this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;

this.Text = "Inventory Reports";

this.Load += new System.EventHandler(this.frmReport_Load);

this.GroupBox1.ResumeLayout(false);

this.GroupBox1.PerformLayout();

this.FlowLayoutPanel1.ResumeLayout(false);

this.GroupBox2.ResumeLayout(false);

this.GroupBox2.PerformLayout();

this.ResumeLayout(false);

}

#endregion

internal System.Windows.Forms.DateTimePicker dtp_endDate;

internal System.Windows.Forms.Button btn_preview;

internal System.Windows.Forms.Button btnTotalbooks;

internal System.Windows.Forms.Button btnListBooks;

internal System.Windows.Forms.RadioButton rdoMonthly;

internal System.Windows.Forms.RadioButton rdoWeekly;

internal System.Windows.Forms.RadioButton rdoDaily;

internal System.Windows.Forms.DateTimePicker dtp_strtDate;

internal System.Windows.Forms.Label Label2;

internal System.Windows.Forms.Label Label3;

internal System.Windows.Forms.Label Label1;

internal System.Windows.Forms.ComboBox cboStatus;

internal System.Windows.Forms.GroupBox GroupBox1;

internal System.Windows.Forms.FlowLayoutPanel FlowLayoutPanel1;

internal System.Windows.Forms.GroupBox GroupBox2;

private CrystalDecisions.Windows.Forms.CrystalReportViewer crystalReportViewer1;

}

frmBorrower.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using LibrarySystem.Includes;
using LibrarySystem.Properties;
using System.IO;

namespace LibrarySystem
{
    public partial class frmBorrower : Form
    {
        public frmBorrower()
        {
            InitializeComponent();
        }

        SQLConfig config = new SQLConfig();
        usableFunction funct = new usableFunction();
        string sql;
        int inc, maxrow;

        private void navigate_records(int inc)
        {
            sql = "SELECT BorrowerId FROM tblborrower";
            config.singleResult(sql);

            if (config.dt.Rows.Count > 0)
            {
                txt_bid.Text = config.dt.Rows[inc].Field<string>(0);
            }
        }
        private void btn_New_Click(object sender, EventArgs e)
        {
            funct.clearTxt(this);  
            sql = "SELECT BorrowerId,`Firstname`, `Lastname`, `MiddleName`, `Address`, `Sex`, `ContactNo`, `CourseYear`  as 'Course/Year' FROM `tblborrower`  WHERE Stats='Active'";
            config.Load_ResultList(sql, dtg_ABorrowLists); 
            PictureBox1.ImageLocation = "";
            btn_delete.Enabled = false;

            sql = "SELECT * FROM `tblborrower`  WHERE Stats='Active'";
            config.singleResult(sql);
            if (config.dt.Rows.Count > 0)
            {
                maxrow = config.dt.Rows.Count - 1;
            }

            inc = 0;
        }

        private void frmBorrower_Load(object sender, EventArgs e)
        {
            btn_New_Click(sender, e);
        }

        private void txt_bid_TextChanged(object sender, EventArgs e)
        {
            sql = "SELECT * FROM `tblborrower` WHERE `BorrowerId` = '" + txt_bid.Text + "'";
            config.singleResult(sql);

            if(config.dt.Rows.Count > 0)
            {
                txt_fname.Text = config.dt.Rows[0].Field<string>("Firstname");
                txt_lname.Text = config.dt.Rows[0].Field<string>("Lastname");
                txt_mname.Text = config.dt.Rows[0].Field<string>("MiddleName");
                rch_address.Text = config.dt.Rows[0].Field<string>("Address");
                txtContact.Text = config.dt.Rows[0].Field<string>("ContactNo");
                txtCourse.Text = config.dt.Rows[0].Field<string>("CourseYear");
                PictureBox1.ImageLocation = Application.StartupPath + "\\BorrowerPhoto\\" + config.dt.Rows[0].Field<string>("BorrowerPhoto");

                if (config.dt.Rows[0].Field<string>("Sex") == "Female")
                {
                    rdio_female.Checked = true;
                }
                else
                {
                    rdio_male.Checked = true;
                }
                btn_delete.Enabled = true;
                 
            }
            else
            {
                btn_delete.Enabled = false;
                clearme();
            }
             
        }
        private void clearme()
        {
            txt_fname.Clear();
            txt_lname.Clear();
            txt_mname.Clear();
            rch_address.Clear();
            txtContact.Clear();
            txtCourse.Clear();
            txtPhoto.Clear();
        }

        private void btn_save_Click(object sender, EventArgs e)
        {
             
            if( txt_bid.Text == "" 
            || txt_fname.Text == "" || txt_lname.Text == "" 
            || txt_mname.Text == "" || txtCourse.Text == "" ){
              funct.emptymessage();
            }

            string gender;
            if (rdio_female.Checked)
            {
                gender = "Female";
            }
            else
            {
                gender = "Male";
            }  

            sql = "SELECT * FROM `tblborrower` WHERE `BorrowerId`=" + txt_bid.Text;
            config.singleResult(sql);
            if (config.dt.Rows.Count > 0)
            {
                sql = "update  tblborrower set  `Firstname`='" + txt_fname.Text
                      + "', `Lastname`='" + txt_lname.Text + "', `MiddleName`='" + txt_mname.Text
                      + "', `Address`='" + rch_address.Text + "', `Sex`='" + gender
                      + "', `ContactNo` ='" + txtContact.Text + "', `CourseYear`='" + txtCourse.Text.ToUpper()
                      + "', `BorrowerPhoto`='" + Path.GetFileName(PictureBox1.ImageLocation) + "', `BorrowerType`='Student' where `BorrowerId`='" + txt_bid.Text + "'";
                config.Execute_CUD(sql, "error to execute the query", "Borrower has been updated in the database.");

            }
            else
            {
                sql = "insert into tblborrower (`BorrowerId`, `Firstname`, `Lastname`, `MiddleName`, `Address`, "
                       + "`Sex`, `ContactNo`, `CourseYear`,  `BorrowerPhoto`,`BorrowerType`,Stats)"
                       + "values ('" + txt_bid.Text + "','" + txt_fname.Text + "','" + txt_lname.Text
                       + "','" + txt_mname.Text + "','" + rch_address.Text
                       + "','" + gender + "','" + txtContact.Text + "','" + txtCourse.Text
                       + "','" + Path.GetFileName(PictureBox1.ImageLocation) + "','Student','Active')";
                config.Execute_CUD(sql, "error to execute the query", "New borrower has been added in the database.");

            }
            if(txtPhoto.Text!= "")
            {
                File.Copy(txtPhoto.Text, Application.StartupPath + "\\BorrowerPhoto\\" + Path.GetFileName(PictureBox1.ImageLocation),true);
            }

            btn_New_Click(sender, e);

        }

        private void PictureBox1_Click(object sender, EventArgs e)
        {
            //With OpenFileDialog1

            //    'CHECK THE SELECTED FILE IF IT EXIST OTHERWISE THE DIALOG BOX WILL DISPLAY A WARNING.
            OpenFileDialog1.CheckFileExists = true;


            //    'CHECK THE SELECTED PATH IF IT EXIST OTHERWISE THE DIALOG BOX WILL DISPLAY A WARNING.
            OpenFileDialog1.CheckPathExists = true;


            //    'GET AND SET THE DEFAULT EXTENSION
            OpenFileDialog1.DefaultExt = "jpg";


            //    'RETURN THE FILE LINKED TO THE LNK FILE
            OpenFileDialog1.DereferenceLinks = true;

            //    'SET THE FILE NAME TO EMPTY 
            OpenFileDialog1.FileName = "";

            //    'FILTERING THE FILES
            OpenFileDialog1.Filter = "(*.jpg)|*.jpg|(*.png)|*.png|(*.jpg)|*.jpg|All files|*.*";

            //    'SET THIS FOR ONE FILE SELECTION ONLY.
            OpenFileDialog1.Multiselect = false;



            //    'SET THIS TO PUT THE CURRENT FOLDER BACK TO WHERE IT HAS STARTED.
            OpenFileDialog1.RestoreDirectory = true;

            //    'SET THE TITLE OF THE DIALOG BOX.
            OpenFileDialog1.Title = "Select a file to open";

            //    'ACCEPT ONLY THE VALID WIN32 FILE NAMES.
            OpenFileDialog1.ValidateNames = true;

            if (OpenFileDialog1.ShowDialog() == DialogResult.OK)
            {
                txtPhoto.Text = OpenFileDialog1.FileName; 
                PictureBox1.ImageLocation = OpenFileDialog1.FileName;
                PictureBox1.SizeMode = PictureBoxSizeMode.StretchImage;
            }
  
        }

        private void btn_delete_Click(object sender, EventArgs e)
        { 
            if (MessageBox.Show("Are you sure you want to delete this borrower?", "Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes) { 
                sql = "UPDATE `tblborrower` SET  `Stats` =  'NotActive' WHERE `BorrowerId` ='" + dtg_ABorrowLists.CurrentRow.Cells[0].Value + "'";
                config.Execute_Query(sql);

                MessageBox.Show("Borrower has been deleted in the database.", "Success", MessageBoxButtons.OK);
                btn_New_Click(sender, e);
            } 
        }

        private void btnClose_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        private void btn_last_Click(object sender, EventArgs e)
        {
            inc = maxrow;
            navigate_records(inc);
        }

        private void btn_prev_Click(object sender, EventArgs e)
        {
            if(inc == 0)
            {
                MessageBox.Show("First Records.", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            else if(inc <= maxrow)
            {
                inc = inc - 1;
                navigate_records(inc);
            }
        }

        private void btn_next_Click(object sender, EventArgs e)
        {
            if (inc == maxrow)
            { 
                MessageBox.Show("Last Records.", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            else  if (inc >= 0)
            {
                inc = inc + 1;
                navigate_records(inc);
            }
        }

        private void dtg_ABorrowLists_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            txt_bid.Text = dtg_ABorrowLists.CurrentRow.Cells[0].Value.ToString();
        }

        private void btn_first_Click(object sender, EventArgs e)
        {
            inc = 0;
            navigate_records(inc);
        }
    }
}

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

225

226

227

228

229

230

231

232

233

234

235

236

237

238

239

240

241

242

243

244

245

246

247

248

249

250

251

252

253

254

255

256

257

258

259

260

261

262

263

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Windows.Forms;

using LibrarySystem.Includes;

using LibrarySystem.Properties;

using System.IO;

namespace LibrarySystem

{

public partial class frmBorrower : Form

{

public frmBorrower()

{

InitializeComponent();

}

SQLConfig config = new SQLConfig();

usableFunction funct = new usableFunction();

string sql;

int inc, maxrow;

private void navigate_records(int inc)

{

sql = "SELECT BorrowerId FROM tblborrower";

config.singleResult(sql);

if (config.dt.Rows.Count > 0)

{

txt_bid.Text = config.dt.Rows[inc].Field<string>(0);

}

private void btn_New_Click(object sender, EventArgs e)

{

funct.clearTxt(this);

sql = "SELECT BorrowerId,`Firstname`, `Lastname`, `MiddleName`, `Address`, `Sex`, `ContactNo`, `CourseYear` as 'Course/Year' FROM `tblborrower` WHERE Stats='Active'";

config.Load_ResultList(sql, dtg_ABorrowLists);

PictureBox1.ImageLocation = "";

btn_delete.Enabled = false;

sql = "SELECT * FROM `tblborrower` WHERE Stats='Active'";

config.singleResult(sql);

if (config.dt.Rows.Count > 0)

{

maxrow = config.dt.Rows.Count - 1;

}

inc = 0;

}

private void frmBorrower_Load(object sender, EventArgs e)

{

btn_New_Click(sender, e);

}

private void txt_bid_TextChanged(object sender, EventArgs e)

{

sql = "SELECT * FROM `tblborrower` WHERE `BorrowerId` = '" + txt_bid.Text + "'";

config.singleResult(sql);

if(config.dt.Rows.Count > 0)

{

txt_fname.Text = config.dt.Rows[0].Field<string>("Firstname");

txt_lname.Text = config.dt.Rows[0].Field<string>("Lastname");

txt_mname.Text = config.dt.Rows[0].Field<string>("MiddleName");

rch_address.Text = config.dt.Rows[0].Field<string>("Address");

txtContact.Text = config.dt.Rows[0].Field<string>("ContactNo");

txtCourse.Text = config.dt.Rows[0].Field<string>("CourseYear");

PictureBox1.ImageLocation = Application.StartupPath + "\\BorrowerPhoto\\" + config.dt.Rows[0].Field<string>("BorrowerPhoto");

if (config.dt.Rows[0].Field<string>("Sex") == "Female")

{

rdio_female.Checked = true;

}

else

{

rdio_male.Checked = true;

}

btn_delete.Enabled = true;

}

else

{

btn_delete.Enabled = false;

clearme();

}

private void clearme()

{

txt_fname.Clear();

txt_lname.Clear();

txt_mname.Clear();

rch_address.Clear();

txtContact.Clear();

txtCourse.Clear();

txtPhoto.Clear();

}

private void btn_save_Click(object sender, EventArgs e)

{

if( txt_bid.Text == ""

|| txt_fname.Text == "" || txt_lname.Text == ""

|| txt_mname.Text == "" || txtCourse.Text == "" ){

funct.emptymessage();

}

string gender;

if (rdio_female.Checked)

{

gender = "Female";

}

else

{

gender = "Male";

}

sql = "SELECT * FROM `tblborrower` WHERE `BorrowerId`=" + txt_bid.Text;

config.singleResult(sql);

if (config.dt.Rows.Count > 0)

{

sql = "update tblborrower set `Firstname`='" + txt_fname.Text

+ "', `Lastname`='" + txt_lname.Text + "', `MiddleName`='" + txt_mname.Text

+ "', `Address`='" + rch_address.Text + "', `Sex`='" + gender

+ "', `ContactNo` ='" + txtContact.Text + "', `CourseYear`='" + txtCourse.Text.ToUpper()

+ "', `BorrowerPhoto`='" + Path.GetFileName(PictureBox1.ImageLocation) + "', `BorrowerType`='Student' where `BorrowerId`='" + txt_bid.Text + "'";

config.Execute_CUD(sql, "error to execute the query", "Borrower has been updated in the database.");

}

else

{

sql = "insert into tblborrower (`BorrowerId`, `Firstname`, `Lastname`, `MiddleName`, `Address`, "

+ "`Sex`, `ContactNo`, `CourseYear`, `BorrowerPhoto`,`BorrowerType`,Stats)"

+ "values ('" + txt_bid.Text + "','" + txt_fname.Text + "','" + txt_lname.Text

+ "','" + txt_mname.Text + "','" + rch_address.Text

+ "','" + gender + "','" + txtContact.Text + "','" + txtCourse.Text

+ "','" + Path.GetFileName(PictureBox1.ImageLocation) + "','Student','Active')";

config.Execute_CUD(sql, "error to execute the query", "New borrower has been added in the database.");

}

if(txtPhoto.Text!= "")

{

File.Copy(txtPhoto.Text, Application.StartupPath + "\\BorrowerPhoto\\" + Path.GetFileName(PictureBox1.ImageLocation),true);

}

btn_New_Click(sender, e);

}

private void PictureBox1_Click(object sender, EventArgs e)

{

//With OpenFileDialog1

// 'CHECK THE SELECTED FILE IF IT EXIST OTHERWISE THE DIALOG BOX WILL DISPLAY A WARNING.

OpenFileDialog1.CheckFileExists = true;

// 'CHECK THE SELECTED PATH IF IT EXIST OTHERWISE THE DIALOG BOX WILL DISPLAY A WARNING.

OpenFileDialog1.CheckPathExists = true;

// 'GET AND SET THE DEFAULT EXTENSION

OpenFileDialog1.DefaultExt = "jpg";

// 'RETURN THE FILE LINKED TO THE LNK FILE

OpenFileDialog1.DereferenceLinks = true;

// 'SET THE FILE NAME TO EMPTY

OpenFileDialog1.FileName = "";

// 'FILTERING THE FILES

OpenFileDialog1.Filter = "(*.jpg)|*.jpg|(*.png)|*.png|(*.jpg)|*.jpg|All files|*.*";

// 'SET THIS FOR ONE FILE SELECTION ONLY.

OpenFileDialog1.Multiselect = false;

// 'SET THIS TO PUT THE CURRENT FOLDER BACK TO WHERE IT HAS STARTED.

OpenFileDialog1.RestoreDirectory = true;

// 'SET THE TITLE OF THE DIALOG BOX.

OpenFileDialog1.Title = "Select a file to open";

// 'ACCEPT ONLY THE VALID WIN32 FILE NAMES.

OpenFileDialog1.ValidateNames = true;

if (OpenFileDialog1.ShowDialog() == DialogResult.OK)

{

txtPhoto.Text = OpenFileDialog1.FileName;

PictureBox1.ImageLocation = OpenFileDialog1.FileName;

PictureBox1.SizeMode = PictureBoxSizeMode.StretchImage;

}

private void btn_delete_Click(object sender, EventArgs e)

{

if (MessageBox.Show("Are you sure you want to delete this borrower?", "Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes) {

sql = "UPDATE `tblborrower` SET `Stats` = 'NotActive' WHERE `BorrowerId` ='" + dtg_ABorrowLists.CurrentRow.Cells[0].Value + "'";

config.Execute_Query(sql);

MessageBox.Show("Borrower has been deleted in the database.", "Success", MessageBoxButtons.OK);

btn_New_Click(sender, e);

}

private void btnClose_Click(object sender, EventArgs e)

{

this.Close();

}

private void btn_last_Click(object sender, EventArgs e)

{

inc = maxrow;

navigate_records(inc);

}

private void btn_prev_Click(object sender, EventArgs e)

{

if(inc == 0)

{

MessageBox.Show("First Records.", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information);

}

else if(inc <= maxrow)

{

inc = inc - 1;

navigate_records(inc);

}

private void btn_next_Click(object sender, EventArgs e)

{

if (inc == maxrow)

{

MessageBox.Show("Last Records.", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information);

}

else if (inc >= 0)

{

inc = inc + 1;

navigate_records(inc);

}

private void dtg_ABorrowLists_CellClick(object sender, DataGridViewCellEventArgs e)

{

txt_bid.Text = dtg_ABorrowLists.CurrentRow.Cells[0].Value.ToString();

}

private void btn_first_Click(object sender, EventArgs e)

{

inc = 0;

navigate_records(inc);

}

Free- Download Source code OF LIBRARY MANAGEMENT SYSTEM Project (FYP) Full file in C# Library Management System Software Documentation FUNCTIONAL REQUIREMENTS OF LIBRARY MANAGEMENT SYSTEM Non FUNCTIONAL REQUIREMENTS OF LIBRARY MANAGEMENT SYSTEM Use Case …

LIBRARY MANAGEMENT SYSTEM C# Download Source code OF Project (FYP) Read More »