inventory_project_2.c

these are the mini project codes on inventiry and record entry in c language.

/******************************************

  Application: Inventry Management System
  Compiled on: Borland Turbo C++ 3.0
  Programmer: Geetika Mukhi

******************************************/

#include <conio.h>
#include <stdio.h>
#include <stdlib.h>
#include <dos.h>
#include <graphics.h>
#include <string.h>

#define TRUE 1
#define FALSE 0

/* List of Global variables used in the application*/
int mboxbrdrclr,mboxbgclr,mboxfgclr;               /* To set colors for all message boxes in the application*/
int menutxtbgclr,menutxtfgclr,appframeclr;         /* To set the frame and color's for menu items's*/
int section1_symb,section1_bgclr,section1_fgclr;   /* To set color of section 1, the region around the menu options*/
int section2_symb,section2_bgclr,section2_fgclr;   /* To set color of section 2, the section on the right of the menu options*/
int fEdit;
int animcounter;

static struct struct_stock                         /* Main database structure*/
{
  char itemcode[8];
  char itemname[50];
  float itemrate;
  float itemqty;
  int minqty;	                                   /*Used for Reorder level, which is the minimum no of stock*/
}inv_stock;

struct struct_bill
{
  char itemcode[8];
  char itemname[50];
  float itemrate;
  float itemqty;
  float itemtot;
}item_bill[100];

char password[8];

const long int stocksize=sizeof(inv_stock);   /*stocksize stores the size of the struct_stock*/
float tot_investment;
int numItems;                                /*To count the no of items in the stock*/
int button,column,row;                       /*To allow mouse operations in the application*/

FILE *dbfp;				     /*To perform database file operations on "inv_stock.dat"*/

int main(void)
{
  float issued_qty;
  char userchoice,code[8];
  int flag,i,itemsold;
  float getInvestmentInfo(void);
  FILE *ft;
  int result;
  getConfiguration();

  /* Opens & set 'dbfp' globally so that it is accessible from anywhere in the application*/
  dbfp=fopen("d:\invstoc.dat","r+");
  if(dbfp==NULL)
  {
    clrscr();
    printf("\nDatabase does not exists.\nPress Enter key to create it. To exit, press any other key.\n ");
    fflush(stdin);
    if(getch()==13)
    {
      dbfp=fopen("d:\invstoc.dat","w+");
      printf("\nThe database for the application has been created.\nYou must restart the application.\nPress any key to continue.\n");
      fflush(stdin);
      getch();
      exit(0);
    }
    else
    {
      exit(0);
    }
  }
  /* Application control will reach here only if the database file has been opened successfully*/
  if(initmouse()==0)
      messagebox(10,33,"Mouse could not be loaded.","Error ",' ',mboxbrdrclr,mboxbgclr,mboxfgclr,0);
  showmouseptr();
  _setcursortype(_NOCURSOR);

  while(1)
  {
    clrscr();
    fEdit=FALSE;
    ShowMenu();
    numItems=0;
    rewind(dbfp);

    /* To calculate the number of records in the database*/
    while(fread(&inv_stock,stocksize,1,dbfp)==1)
      ++numItems;
    textcolor(menutxtfgclr);
    textbackground(menutxtbgclr);
    gotopos(23,1);
    cprintf("Total Items in Stock: %d",numItems);
    textcolor(BLUE);
    textbackground(BROWN);
    fflush(stdin);

    /*The application will wait for user response */
    userchoice=getUserResponse();
    switch(userchoice)
    {
      /* To Close the application*/
      case '0':
	BackupDatabase();  /*Backup the Database file to secure data*/
	flushall();
	fclose(dbfp);
	fcloseall();
	print2screen(12,40,"Thanks for Using the application.",BROWN,BLUE,0);
	sleep(1);
	setdefaultmode();
	exit(0);

      /* To Add an item*/
      case '1':
	if(getdata()==1)
	{
	  fseek(dbfp,0,SEEK_END);
	  /*Write the item information into the database*/
	  fwrite(&inv_stock,stocksize,1,dbfp);
	  print2screen(13,33,"The item has been successfully added. ",BROWN,BLUE,0);
	  getch();
	}
      break;

      /* To edit the item information*/
      case '2':
	print2screen(2,33,"Enter Item Code>",BROWN,BLUE,0);gotopos(2,54);fflush(stdin);
	scanf("%s",&code);
	fEdit=TRUE;
	if(CheckId(code)==0)
	{
	  if(messagebox(0,33,"Press Enter key to edit the item.","Confirm",' ',mboxbrdrclr,mboxbgclr,mboxfgclr,0)!=13)
	  {
	      messagebox(10,33,"The item information could not be modified. Please try again.","Edit ",' ',mboxbrdrclr,mboxbgclr,mboxfgclr,0);
	      fEdit=FALSE;
	      break;
	  }
	  fEdit=TRUE;
	  getdata();
	  fflush(stdin);
	  fseek(dbfp,-stocksize,SEEK_CUR);
	  fwrite(&inv_stock,stocksize,1,dbfp);
	}
	else
	  messagebox(10,33,"The item is not available in the database.","No records found",' ',mboxbrdrclr,mboxbgclr,mboxfgclr,0);
	  fEdit=FALSE;
      break;

      /* To show information about an an Item*/
      case '3':
	print2screen(2,33,"Enter Item Code: ",BROWN,BLUE,0);gotopos(2,55);fflush(stdin);
	scanf("%s",&code);
	flag=0;
	rewind(dbfp);
	while(fread(&inv_stock,stocksize,1,dbfp)==1)
	{
	  if(strcmp(inv_stock.itemcode,code)==0)
	  {
	     DisplayItemInfo();
	     flag=1;
	  }
	}
	if(flag==0)
	  messagebox(10,33,"The item is not available.","No records found ",' ',mboxbrdrclr,mboxbgclr,mboxfgclr,0);
      break;

      /* To show information about all items in the database*/
      case '4':
	if(numItems==0)
	  messagebox(10,33,"No items are available. ","Error ",' ',mboxbrdrclr,mboxbgclr,mboxfgclr,0);
	textcolor(BLUE);
	textbackground(BROWN);
	gotopos(3,33);
	cprintf("Number of Items Available in Stock:  %d",numItems);
	gotopos(4,33);
	getInvestmentInfo();
	cprintf("Total Investment :Rs.%.2f",tot_investment);
	gotopos(5,33);
	cprintf("Press Enter To View. Otherwise Press Any Key...");fflush(stdin);
	if(getch()==13)
	{
	  rewind(dbfp);
	  while(fread(&inv_stock,stocksize,1,dbfp)==1);  /*List All records*/
	    DisplayItemRecord(inv_stock.itemcode);
	}
	textcolor(BLUE);
      break;

      /* To issue Items*/
      case '5':
        itemsold=0;
        i=0;
	top:
	print2screen(3,33,"Enter Item Code: ",BROWN,BLUE,0);fflush(stdin);gotopos(3,55);
	scanf("%s",&code);
	if(CheckId(code)==1)
	  if(messagebox(10,33,"The item is not available.","No records found ",' ',mboxbrdrclr,mboxbgclr,mboxfgclr,0)==13)
	    goto top;
	  else
	   goto bottom;
	rewind(dbfp);
	while(fread(&inv_stock,stocksize,1,dbfp)==1)
	{
	  if(strcmp(inv_stock.itemcode,code)==0)   /*To check if the item code is available in the database*/
	  {
	     issued_qty=IssueItem();
	     if(issued_qty > 0)
	     {
	       itemsold+=1;
	       strcpy(item_bill[i].itemcode,inv_stock.itemcode);
	       strcpy(item_bill[i].itemname,inv_stock.itemname);
	       item_bill[i].itemqty=issued_qty;
	       item_bill[i].itemrate=inv_stock.itemrate;
	       item_bill[i].itemtot=inv_stock.itemrate*issued_qty;
	       i+=1;
	     }
	     print2screen(19,33,"Would you like to issue another item(Y/N)?",BROWN,BLUE,0);fflush(stdin);gotopos(19,45);
	     if(toupper(getch())=='Y')
	       goto top;
	     bottom:
	     break;
	  }
	}
      break;

      /* Items to order*/
      case '6':
	if(numItems<=0)
	{
	  messagebox(10,33,"No items are available. ","Items Not Found ",' ',mboxbrdrclr,mboxbgclr,mboxfgclr,0);
	  break;
	}
	print2screen(3,33,"Stock of these items is on the minimum level:",BROWN,RED,0);fflush(stdin);
	flag=0;
	fflush(stdin);
	rewind(dbfp);
	while(fread(&inv_stock,stocksize,1,dbfp)==1)
	{
	  if(inv_stock.itemqty <= inv_stock.minqty)
	  {
	    DisplayItemInfo();
	    flag=1;
	  }
	}
	if(flag==0)
	  messagebox(10,33,"No item is currently at reorder level.","Reorder Items",' ',mboxbrdrclr,mboxbgclr,mboxfgclr,0);
      break;

      default:
	messagebox(10,33,"The option you have entered is not available.","Invalid Option ",' ',mboxbrdrclr,mboxbgclr,mboxfgclr,0);
      break;
    }
  }
}

/*Display Menu & Skins that the user will see*/
ShowMenu()
{
    if(section1_bgclr != BROWN || section1_symb != ' ')
      fillcolor(2,1,23,39,section1_symb,section1_bgclr,section1_fgclr,0);
    if(section2_bgclr != BROWN || section2_symb != ' ')
      fillcolor(2,40,23,79,section2_symb,section2_bgclr,section2_fgclr,0);
    print2screen(2,2,"1: Add an Item",menutxtbgclr,menutxtfgclr,0);
    print2screen(4,2,"2: Edit Item Information",menutxtbgclr,menutxtfgclr,0);
    print2screen(6,2,"3: Show Item Information",menutxtbgclr,menutxtfgclr,0);
    print2screen(8,2,"4: View Stock Report",menutxtbgclr,menutxtfgclr,0);
    print2screen(10,2,"5: Issue Items from Stock",menutxtbgclr,menutxtfgclr,0);
    print2screen(12,2,"6: View Items to be Ordered ",menutxtbgclr,menutxtfgclr,0);
    print2screen(14,2,"0: Close the application",menutxtbgclr,menutxtfgclr,0);

    htskin(0,0,' ',80,appframeclr,LIGHTGREEN,0);
    htskin(1,0,' ',80,appframeclr,LIGHTGREEN,0);
    vtskin(0,0,' ',24,appframeclr,LIGHTGREEN,0);
    vtskin(0,79,' ',24,appframeclr,LIGHTGREEN,0);
    htskin(24,0,' ',80,appframeclr,LIGHTGREEN,0);
    vtskin(0,31,' ',24,appframeclr,LIGHTGREEN,0);
    return;
}

/*Wait for response from the user & returns choice*/
getUserResponse()
{
  int ch,i;
  animcounter=0;

  while(!kbhit())
  {
    getmousepos(&button,&row,&column);

    /*To show Animation*/
    BlinkText(0,27,"Inventory Management System",1,YELLOW,RED,LIGHTGRAY,0,50);
    animcounter+=1;

    i++;
    if(button==1 && row==144 && column>=16 && column<=72)  /*Close*/
      return('0');
    if(button==1 && row==16 && column>=16 && column<=136)  /*Add New Item*/
      return('1');
    if(button==1 && row==32 && column>=16 && column<=144)  /*Edit Item*/
      return('2');
    if(button==1 && row==48 && column>=16 && column<=160)  /*Show an Item*/
      return('3');
    if(button==1 && row==64 && column>=16 && column<=104) /*Stock Report*/
      return('4');
    if(button==1 && row==80 && column>=16 && column<=144) /*Issue an Item*/
      return('5');
    if(button==1 && row==96 && column>=16 && column<=152) /*Items to order*/
      return('6');
  }
  ch=getch();
  return ch;
}

/*Reads a valid id and its information,returns 0 if id already exists*/
getdata()
{
  char tmp[8];
  float tst;
  _setcursortype(_NORMALCURSOR);
  print2screen(3,33,"Enter Item Code: ",BROWN,BLUE,0);fflush(stdin);gotopos(3,53);
  scanf("%s",&tmp);
  if(CheckId(tmp)==0 && fEdit == FALSE)
  {
    messagebox(10,33,"The id already exists. ","Error ",' ',mboxbrdrclr,mboxbgclr,mboxfgclr,0);
    return 0;
  }
  strcpy(inv_stock.itemcode,tmp);   /*Means got a correct item code*/
  print2screen(4,33,"Name of the Item: ",BROWN,BLUE,0);fflush(stdin);gotopos(4,53);
  gets(inv_stock.itemname);
  print2screen(5,33,"Price of Each Unit: ",BROWN,BLUE,0);fflush(stdin);gotopos(5,53);
  scanf("%f",&inv_stock.itemrate);
  print2screen(6,33,"Quantity:  ",BROWN,BLUE,0);fflush(stdin);gotopos(6,53);
  scanf("%f",&inv_stock.itemqty);
  print2screen(7,33,"Reorder Level: ",BROWN,BLUE,0);fflush(stdin);gotopos(7,53);
  scanf("%d",&inv_stock.minqty);
  _setcursortype(_NOCURSOR);
  return 1;
}

/*Returns 0 if the id already exists in the database, else returns 1*/
int CheckId(char item[8])
{
  rewind(dbfp);
  while(fread(&inv_stock,stocksize,1,dbfp)==1)
    if(strcmp(inv_stock.itemcode,item)==0)
      return(0);
  return(1);
}

/*Displays an Item*/
DisplayItemRecord(char idno[8])
{
 rewind(dbfp);
 while(fread(&inv_stock,stocksize,1,dbfp)==1)
   if(strcmp(idno,inv_stock.itemcode)==0)
     DisplayItemInfo();
 return;
}

/*Displays an Item information*/
DisplayItemInfo()
{
  int r=7;
  textcolor(menutxtfgclr);
  textbackground(menutxtbgclr);
  gotopos(r,33);
  cprintf("Item Code: %s","                                  ");
  gotopos(r,33);
  cprintf("Item Code: %s",inv_stock.itemcode);
  gotopos(r+1,33);
  cprintf("Name of the Item: %s","                             ");