Skip to main content

Login Page (Admin)

















Admin Main Page (Admin)


















Add Product (Admin)














Modify Product (Admin)















Delete Product (Admin)















View Bill Status (Admin)














Add Another Admin Or Seller (Admin)














Seller Log In Page (Seller)














Seller Main Page(Seller)















Add Products From Customer List (Seller)















Delete Product From Customer List (Seller)















Log Out(Admin & Seller)



















1.   Tables

1.1.        Table Name: SMBS_ADMIN_LOGIN_TB

            Description: It will shows Admin login details



Field
Datatype
               Size  
Constraints
al_admin_name
Text
50
Pk_al_username
al_admin_pass
Text
50
NOT NULL
al_admin_auth
Text
10
NOT NULL




1.2.      Table Name: SMBS_SELLER_LOGIN_TB

Description: It will shows Seller login details


Field
Datatype
               Size  
Constraints
sl_seller_name
Text
50
Pk_sl_username
sl_seller_pass
Text
50
NOT NULL
sl_seller_auth
Text
10
NOT NULL


1.3.       Table Name: SMBS_ADMIN_PRODUCTDETAILS_TB

            Description: It will shows the Product Details.

Field
DataType
Size
Constraints
ap_product_name
Text
50
NOT NULL
ap_quantity
Number
10
NOT NULL
ap_item_price
Money

NOT NULL
ap_expiry_date
Date

NOT NULL



1.4.       Table Name: SMBS_SELLER_CUSTMER_LIST_TB

    Description: It will shows the Cd details.


Field
Datatype
Size
Constraints
sc_serial_number
Number
10
Pk_ss_serialnumber
sc_customer_name
Text
50
NOT NULL
sc_product_name
Text
50
NOT NULL
sc_quantity
Number
10
NOT NULL
sc_price
Money

NOT NULL
sc_discount
Number

NOT NULL
sc_totalamount
Money

NOT NULL
sc_date
Date

NOT NULL
sc_paymentmode
Text
10
NOT NULL



Comments

Post a Comment

Popular posts from this blog

DIALOG BOX SHOW CODE IN SWING JAVA

import javax.swing.*; import java.awt.event.*; public class Dialog {   JFrame frame;   JPanel p;   public Dialog(){   frame = new JFrame("Show Message Dialog");   p=new JPanel();   JButton button = new JButton("Click Me");   button.addActionListener(new MyAction());     p.add(button);   frame.add(p);   frame.setSize(400, 400);   frame.setVisible(true);   frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);   }   public class MyAction implements ActionListener{   public void actionPerformed(ActionEvent e){   JOptionPane.showMessageDialog(frame,"My DialogBox");   }   }  public static void main(String[] args)  {     Dialog db = new Dialog();   } }
Post a Comment
Read more

DATABASE UPDATION CODE IN VB.NET

Private Sub BTNUPDATE_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BTNUPDATE.Click         connetionString = " Data Source=KEERTIG-PC\SQLEXPRESS;Initial Catalog=GAURAV1;Integrated Security=True"         connection = New SqlConnection(connetionString)         sql = "UPDATE ROOM_BOOKING SET FIRST_NAME= '" & TXTBSFNAME.Text & "',MIDDLE_NAME= '" & TXTBSMNAME.Text & "',LAST_NAME= '" & TXTBSLNAME.Text & "',NUM_OF_ROOM= '" & TXTBSNOROOM.Text & "',NUM_OF_DAYS= '" & TXTBSNODAYS.Text & "',MOBILE_NO= '" & TXTBSMOBNO.Text & "',ADDERESS= '" & TXTBSADDRESS.Text & "',ROOMBK_PRICE= '" & TXTBSPRICE.Text & "' WHERE ROOMBK_ID = '" & TXTBSBID.Text & "'  "         Try             connection.Open()             MsgBox(...
Post a Comment
Read more

ABOUT VB6.0

Introduction Þ Visual Basic is a tool that allows you to develop Windows (Graphic User Interface – GUI ) applications. The applications have a familiar appearance to the user. Þ Visual Basic is event-driven ; event driven meaning code remains idle until called upon to respond to some event (button pressing, menu selection). Visual Basic is governed by an event processor. Þ The original Visual Basic for DOS and Visual Basic for Windows were introduced in 1991. Steps in Developing Application There are three primary steps involved in building a Visual Basic application: 1. Draw the user interface 2. Assign properties to controls 3. Attach code to controls Rule for Variable Variables are used by Visual Basic to hold information. Þ No more than 40 characters Þ They may include letters, numbers, and underscore (_) Þ The first character must be a letter Þ You cannot use a reserved wor...
Post a Comment
Read more