Room Booking Management System | Final Year Project | Mini Project
Abstract
- “ROOM BOOKING MANAGEMENT SYSTEM” is a software developed for managing various activities in the hostel. For the past few years, the number of educational institutions is increasing rapidly.
- Thereby the number of hostels are also increasing for the accommodation of the students who studying in their institution. Hence there are lot of strains for the person who is running the hostel and software is not usually used in this context.
- This particular project deals with the problems of managing a hostel and avoids the problems which occur when carried manually.
This project is given for Final Year Project CSE
Existing System
- The population of students gaining admission to a hostel, which is increasing on a yearly basis. This is putting enormous pressure on the facilities in these hostels.
- Adopting the conventional manual scheduling methods to the facility management jobs are the common practice in most hostels in the developing world.
- This method is characterized by numerous drawbacks such as human error, low security, data redundancy, difficulty in management, difficulty in data update, difficulty in record keeping, difficulty in data recovery in case of disaster, etc.
Proposed System
- The proposed system can automates the room allocation/management process.Thereby eliminating the loopholes associated with the current system.
- The use of database will helps in easy retrieval of information and control data concurrency.
- The use of passwords will be incorporated to maintain and ensure data security and integrity.
- The system also has a robust database for the storage of information in all places where students data need to be stored.
Architecture Design
Architecture Design
Software Requirements
- Operating System : Windows 10
- Netframework : Version 3.5
- Environment : Visual Studio 2019
- Language : C#.NET ( C# Tutorial )
- Back end : SQL SERVER 2019 ( Learn SQL )
Hardware Requirements
- Processor : Intel i3 and more
- Processor Speed : 1.6 GHZ
- RAM :1GB RAM
- Hard disk : 200 GB
Images for Room Booking Management System
JPG Image Software Installation
- Download and Install Visual Studio 2019
- Download and Install SQL Server 2019
Data Flow Diagram
- A data flow diagram (DFD) maps out the flow of information for any process or system.
- It uses defined symbols like rectangles, circles and arrows, plus short text labels, to show data inputs, outputs, storage points and the routes between each destination.
- Data flowcharts can range from simple, even hand-drawn process overviews, to in-depth, multi-level DFDs that dig progressively deeper into how the data is handled.
Data Flow Diagram
Use Case Diagram
- In the Unified Modeling Language, a use case diagram can summarize the details of your system's users (also known as actors) and their interactions with the system.
- To build one, you'll use a set of specialized symbols and connectors.
An effective use case diagram can help your team discuss and represent:
- Scenarios in which your system or application interacts with people, organizations, or external systems.
- Goals that it helps those entities (known as actors) achieve.
Usecase Design
Purpose of Use Case Diagram
- The purpose of use case diagram is to capture the dynamic aspect of a system.
- However, this definition is too generic to describe the purpose, as other four diagrams (activity, sequence, collaboration, and Statechart) also have the same purpose.
- We will look into some specific purpose, which will distinguish it from other four diagrams.
- Use case diagrams are used to gather the requirements of a system including internal and external influences. These requirements are mostly design requirements.
- Hence, when a system is analyzed to gather its functionalities, use cases are prepared and actors are identified.
- When the initial task is complete, use case diagrams are modelled to present the outside view.
In brief, the purposes of use case diagrams can be said to be as follows −
- Used to gather the requirements of a system.
- Used to get an outside view of a system.
- Identify the external and internal factors influencing the system.
- Show the interaction among the requirements are actors.
List Of Modules
- Admin Module
- Room Booking Register Module
- Selection module
- Apply Room Module
- Update Module
- View Module
- Cancel Module
Login Module
- Login page provides with a ready-to-use user interface that queries the user name and password from the user and offers a Login button for login.
- A login may include other information, such as Email id, pass code, or passphrase.
- When a login fails (i.e, the username and password combination does not match a user account), the user is invalid access.
- Many system block users when they trying to login after multiple failed login attempts.
Login Module
Sample Code
Login.Designer.cs
namespace roombooking
{
partial class Login
{
/// <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.button2 = new System.Windows.Forms.Button();
this.button1 = new System.Windows.Forms.Button();
this.textBox2 = new System.Windows.Forms.TextBox();
this.textBox1 = new System.Windows.Forms.TextBox();
this.label3 = new System.Windows.Forms.Label();
this.label2 = new System.Windows.Forms.Label();
this.label1 = new System.Windows.Forms.Label();
this.button3 = new System.Windows.Forms.Button();
this.panel4 = new System.Windows.Forms.Panel();
this.panel3 = new System.Windows.Forms.Panel();
this.panel2 = new System.Windows.Forms.Panel();
this.panel1 = new System.Windows.Forms.Panel();
this.SuspendLayout();
//
// button2
//
this.button2.BackColor = System.Drawing.Color.Linen;
this.button2.Font = new System.Drawing.Font("Cambria", 12F, System.Drawing.FontStyle.Italic, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.button2.Location = new System.Drawing.Point(364, 227);
this.button2.Name = "button2";
this.button2.Size = new System.Drawing.Size(116, 45);
this.button2.TabIndex = 16;
this.button2.Text = "Cancel";
this.button2.UseVisualStyleBackColor = false;
this.button2.Click += new System.EventHandler(this.button2_Click);
//
// button1
//
this.button1.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(192)))), ((int)(((byte)(0)))));
this.button1.Font = new System.Drawing.Font("Cambria", 12F, System.Drawing.FontStyle.Italic, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.button1.Location = new System.Drawing.Point(185, 227);
this.button1.Name = "button1";
this.button1.Size = new System.Drawing.Size(116, 45);
this.button1.TabIndex = 15;
this.button1.Text = "Login";
this.button1.UseVisualStyleBackColor = false;
this.button1.Click += new System.EventHandler(this.button1_Click);
//
// textBox2
//
this.textBox2.Location = new System.Drawing.Point(126, 185);
this.textBox2.Name = "textBox2";
this.textBox2.PasswordChar = '*';
this.textBox2.Size = new System.Drawing.Size(197, 20);
this.textBox2.TabIndex = 14;
//
// textBox1
//
this.textBox1.Location = new System.Drawing.Point(125, 147);
this.textBox1.Name = "textBox1";
this.textBox1.Size = new System.Drawing.Size(197, 20);
this.textBox1.TabIndex = 13;
//
// label3
//
this.label3.AutoSize = true;
this.label3.BackColor = System.Drawing.Color.Transparent;
this.label3.Font = new System.Drawing.Font("Cambria", 12F, System.Drawing.FontStyle.Italic, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.label3.ForeColor = System.Drawing.SystemColors.ControlLightLight;
this.label3.Location = new System.Drawing.Point(31, 186);
this.label3.Name = "label3";
this.label3.Size = new System.Drawing.Size(73, 19);
this.label3.TabIndex = 12;
this.label3.Text = "Password";
//
// label2
//
this.label2.AutoSize = true;
this.label2.BackColor = System.Drawing.Color.Transparent;
this.label2.Font = new System.Drawing.Font("Cambria", 12F, System.Drawing.FontStyle.Italic, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.label2.ForeColor = System.Drawing.SystemColors.ControlLightLight;
this.label2.Location = new System.Drawing.Point(30, 146);
this.label2.Name = "label2";
this.label2.Size = new System.Drawing.Size(47, 19);
this.label2.TabIndex = 11;
this.label2.Text = "Email";
//
// label1
//
this.label1.AutoSize = true;
this.label1.BackColor = System.Drawing.Color.Transparent;
this.label1.Font = new System.Drawing.Font("Cambria", 24F, ((System.Drawing.FontStyle)((System.Drawing.FontStyle.Bold | System.Drawing.FontStyle.Italic))), System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.label1.ForeColor = System.Drawing.Color.Red;
this.label1.Location = new System.Drawing.Point(129, 79);
this.label1.Margin = new System.Windows.Forms.Padding(5, 0, 5, 0);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(105, 37);
this.label1.TabIndex = 10;
this.label1.Text = " Login";
//
// button3
//
this.button3.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(192)))), ((int)(((byte)(128)))));
this.button3.Font = new System.Drawing.Font("Cambria", 12F, System.Drawing.FontStyle.Italic, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.button3.Location = new System.Drawing.Point(35, 227);
this.button3.Name = "button3";
this.button3.Size = new System.Drawing.Size(119, 45);
this.button3.TabIndex = 18;
this.button3.Text = "Register";
this.button3.UseVisualStyleBackColor = false;
this.button3.Click += new System.EventHandler(this.button3_Click);
//
// panel4
//
this.panel4.BackColor = System.Drawing.Color.Gold;
this.panel4.Location = new System.Drawing.Point(13, 423);
this.panel4.Name = "panel4";
this.panel4.Size = new System.Drawing.Size(758, 10);
this.panel4.TabIndex = 25;
//
// panel3
//
this.panel3.BackColor = System.Drawing.Color.Gold;
this.panel3.Location = new System.Drawing.Point(3, 0);
this.panel3.Name = "panel3";
this.panel3.Size = new System.Drawing.Size(758, 10);
this.panel3.TabIndex = 24;
//
// panel2
//
this.panel2.BackColor = System.Drawing.Color.Gold;
this.panel2.Location = new System.Drawing.Point(761, 0);
this.panel2.Name = "panel2";
this.panel2.Size = new System.Drawing.Size(10, 433);
this.panel2.TabIndex = 23;
//
// panel1
//
this.panel1.BackColor = System.Drawing.Color.Gold;
this.panel1.Location = new System.Drawing.Point(3, 0);
this.panel1.Name = "panel1";
this.panel1.Size = new System.Drawing.Size(10, 433);
this.panel1.TabIndex = 22;
//
// Login
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.BackgroundImage = global::DoctorAppointmentSystem.Properties.Resources.a2;
this.BackgroundImageLayout = System.Windows.Forms.ImageLayout.Stretch;
this.ClientSize = new System.Drawing.Size(771, 432);
this.Controls.Add(this.panel4);
this.Controls.Add(this.panel3);
this.Controls.Add(this.panel2);
this.Controls.Add(this.panel1);
this.Controls.Add(this.button3);
this.Controls.Add(this.button2);
this.Controls.Add(this.button1);
this.Controls.Add(this.textBox2);
this.Controls.Add(this.textBox1);
this.Controls.Add(this.label3);
this.Controls.Add(this.label2);
this.Controls.Add(this.label1);
this.DoubleBuffered = true;
this.Name = "Login";
this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
this.Text = "Login";
this.Load += new System.EventHandler(this.Login_Load);
this.ResumeLayout(false);
this.PerformLayout();
}
#endregion
private System.Windows.Forms.Button button2;
private System.Windows.Forms.Button button1;
private System.Windows.Forms.TextBox textBox2;
private System.Windows.Forms.TextBox textBox1;
private System.Windows.Forms.Label label3;
private System.Windows.Forms.Label label2;
private System.Windows.Forms.Label label1;
private System.Windows.Forms.Button button3;
private System.Windows.Forms.Panel panel4;
private System.Windows.Forms.Panel panel3;
private System.Windows.Forms.Panel panel2;
private System.Windows.Forms.Panel panel1;
}
}
Login.cs
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
namespace roombooking
{
public partial class Login : Form
{
public Login()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=E:\Project\DotNet-Projects\roombooking\Database\roombooking.mdf;Integrated Security=True;Connect Timeout=30");
conn.Open();
SqlCommand cmd1 = new SqlCommand(@"select Email,[Password] from UserData where Email='" + textBox1.Text + "' and [Password]='" + textBox2.Text + "'", conn);
DataTable dt1 = new DataTable();
SqlDataAdapter da1 = new SqlDataAdapter(cmd1);
da1.Fill(dt1);
string val = dt1.Rows[0][0].ToString();
string val1 = dt1.Rows[0][1].ToString();
conn.Close();
if (val !=null && val1 != null)
{
MessageBox.Show("Login Successfull");
Selection Selection = new Selection();
Selection.Show();
this.Hide();
}
else
{
MessageBox.Show("Invalid User");
}
}
private void button2_Click(object sender, EventArgs e)
{
this.Close();
}
private void button3_Click(object sender, EventArgs e)
{
Register Register = new Register();
Register.Show();
this.Hide();
}
private void Login_Load(object sender, EventArgs e)
{
}
}
}
Register Module
- Register page provides with a ready-to-use user interface that queries the registration details from the user that contains the name, Email id, phone number, password, confirm password.
- A registration form is a list of fields that a user will be input data and submit to a company or an individual.
- There are many reasons why you would want a person to fill out a registration form.
- Companies use registration forms to sign up customers for subscriptions, services, or other programs or plans.
Register Module
Sample Code
Register.Designer.cs
namespace roombooking
{
partial class Register
{
/// <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.label1 = new System.Windows.Forms.Label();
this.button2 = new System.Windows.Forms.Button();
this.button1 = new System.Windows.Forms.Button();
this.textBox7 = new System.Windows.Forms.TextBox();
this.label8 = new System.Windows.Forms.Label();
this.linkLabel1 = new System.Windows.Forms.LinkLabel();
this.textBox6 = new System.Windows.Forms.TextBox();
this.textBox5 = new System.Windows.Forms.TextBox();
this.textBox4 = new System.Windows.Forms.TextBox();
this.textBox3 = new System.Windows.Forms.TextBox();
this.textBox2 = new System.Windows.Forms.TextBox();
this.textBox1 = new System.Windows.Forms.TextBox();
this.label7 = new System.Windows.Forms.Label();
this.label6 = new System.Windows.Forms.Label();
this.label5 = new System.Windows.Forms.Label();
this.label4 = new System.Windows.Forms.Label();
this.label3 = new System.Windows.Forms.Label();
this.label2 = new System.Windows.Forms.Label();
this.panel4 = new System.Windows.Forms.Panel();
this.panel3 = new System.Windows.Forms.Panel();
this.panel2 = new System.Windows.Forms.Panel();
this.panel1 = new System.Windows.Forms.Panel();
this.button3 = new System.Windows.Forms.Button();
this.SuspendLayout();
//
// label1
//
this.label1.AutoSize = true;
this.label1.BackColor = System.Drawing.Color.Transparent;
this.label1.Font = new System.Drawing.Font("Cambria", 24F, ((System.Drawing.FontStyle)((System.Drawing.FontStyle.Bold | System.Drawing.FontStyle.Italic))), System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.label1.ForeColor = System.Drawing.Color.OrangeRed;
this.label1.Location = new System.Drawing.Point(296, 28);
this.label1.Margin = new System.Windows.Forms.Padding(5, 0, 5, 0);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(137, 37);
this.label1.TabIndex = 2;
this.label1.Text = "Register";
//
// button2
//
this.button2.BackColor = System.Drawing.Color.Tomato;
this.button2.Font = new System.Drawing.Font("Cambria", 9.75F, System.Drawing.FontStyle.Italic, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.button2.ForeColor = System.Drawing.SystemColors.ActiveCaptionText;
this.button2.Location = new System.Drawing.Point(497, 359);
this.button2.Name = "button2";
this.button2.Size = new System.Drawing.Size(89, 34);
this.button2.TabIndex = 37;
this.button2.Text = "CANCEL";
this.button2.UseVisualStyleBackColor = false;
this.button2.Click += new System.EventHandler(this.button2_Click);
//
// button1
//
this.button1.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(192)))), ((int)(((byte)(0)))));
this.button1.Font = new System.Drawing.Font("Cambria", 9.75F, System.Drawing.FontStyle.Italic, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.button1.Location = new System.Drawing.Point(363, 359);
this.button1.Name = "button1";
this.button1.Size = new System.Drawing.Size(90, 34);
this.button1.TabIndex = 36;
this.button1.Text = "REGISTER";
this.button1.UseVisualStyleBackColor = false;
this.button1.Click += new System.EventHandler(this.button1_Click);
//
// textBox7
//
this.textBox7.Location = new System.Drawing.Point(347, 321);
this.textBox7.Name = "textBox7";
this.textBox7.PasswordChar = '*';
this.textBox7.Size = new System.Drawing.Size(209, 20);
this.textBox7.TabIndex = 35;
//
// label8
//
this.label8.AutoSize = true;
this.label8.BackColor = System.Drawing.SystemColors.Control;
this.label8.Font = new System.Drawing.Font("Cambria", 9.75F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.label8.Location = new System.Drawing.Point(204, 326);
this.label8.Name = "label8";
this.label8.Size = new System.Drawing.Size(134, 15);
this.label8.TabIndex = 34;
this.label8.Text = "CONFORM PASSWORD";
//
// linkLabel1
//
this.linkLabel1.AutoSize = true;
this.linkLabel1.BackColor = System.Drawing.Color.White;
this.linkLabel1.Font = new System.Drawing.Font("Cambria", 11.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.linkLabel1.Location = new System.Drawing.Point(287, 396);
this.linkLabel1.Name = "linkLabel1";
this.linkLabel1.Size = new System.Drawing.Size(209, 17);
this.linkLabel1.TabIndex = 33;
this.linkLabel1.TabStop = true;
this.linkLabel1.Text = "Already User Goto Login Page ->";
this.linkLabel1.LinkClicked += new System.Windows.Forms.LinkLabelLinkClickedEventHandler(this.linkLabel1_LinkClicked);
//
// textBox6
//
this.textBox6.Location = new System.Drawing.Point(347, 288);
this.textBox6.Name = "textBox6";
this.textBox6.PasswordChar = '*';
this.textBox6.Size = new System.Drawing.Size(209, 20);
this.textBox6.TabIndex = 32;
//
// textBox5
//
this.textBox5.Location = new System.Drawing.Point(347, 246);
this.textBox5.Name = "textBox5";
this.textBox5.Size = new System.Drawing.Size(209, 20);
this.textBox5.TabIndex = 31;
//
// textBox4
//
this.textBox4.Location = new System.Drawing.Point(347, 206);
this.textBox4.Name = "textBox4";
this.textBox4.Size = new System.Drawing.Size(209, 20);
this.textBox4.TabIndex = 30;
//
// textBox3
//
this.textBox3.Location = new System.Drawing.Point(347, 164);
this.textBox3.Name = "textBox3";
this.textBox3.Size = new System.Drawing.Size(209, 20);
this.textBox3.TabIndex = 29;
//
// textBox2
//
this.textBox2.Location = new System.Drawing.Point(347, 128);
this.textBox2.Name = "textBox2";
this.textBox2.Size = new System.Drawing.Size(209, 20);
this.textBox2.TabIndex = 28;
//
// textBox1
//
this.textBox1.Location = new System.Drawing.Point(347, 91);
this.textBox1.Name = "textBox1";
this.textBox1.Size = new System.Drawing.Size(209, 20);
this.textBox1.TabIndex = 27;
//
// label7
//
this.label7.AutoSize = true;
this.label7.BackColor = System.Drawing.SystemColors.Control;
this.label7.Font = new System.Drawing.Font("Cambria", 9.75F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.label7.Location = new System.Drawing.Point(204, 293);
this.label7.Name = "label7";
this.label7.Size = new System.Drawing.Size(71, 15);
this.label7.TabIndex = 26;
this.label7.Text = "PASSWORD";
//
// label6
//
this.label6.AutoSize = true;
this.label6.BackColor = System.Drawing.SystemColors.Control;
this.label6.Font = new System.Drawing.Font("Cambria", 9.75F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.label6.Location = new System.Drawing.Point(204, 251);
this.label6.Name = "label6";
this.label6.Size = new System.Drawing.Size(102, 15);
this.label6.TabIndex = 25;
this.label6.Text = "PHONE NUMBER";
//
// label5
//
this.label5.AutoSize = true;
this.label5.BackColor = System.Drawing.SystemColors.Control;
this.label5.Font = new System.Drawing.Font("Cambria", 9.75F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.label5.Location = new System.Drawing.Point(204, 211);
this.label5.Name = "label5";
this.label5.Size = new System.Drawing.Size(90, 15);
this.label5.TabIndex = 24;
this.label5.Text = "AGE / GENDER";
//
// label4
//
this.label4.AutoSize = true;
this.label4.BackColor = System.Drawing.SystemColors.Control;
this.label4.Font = new System.Drawing.Font("Cambria", 9.75F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.label4.Location = new System.Drawing.Point(204, 169);
this.label4.Name = "label4";
this.label4.Size = new System.Drawing.Size(44, 15);
this.label4.TabIndex = 23;
this.label4.Text = "EMAIL";
//
// label3
//
this.label3.AutoSize = true;
this.label3.BackColor = System.Drawing.SystemColors.Control;
this.label3.Font = new System.Drawing.Font("Cambria", 9.75F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.label3.Location = new System.Drawing.Point(204, 133);
this.label3.Name = "label3";
this.label3.Size = new System.Drawing.Size(71, 15);
this.label3.TabIndex = 22;
this.label3.Text = "LASTNAME";
//
// label2
//
this.label2.AutoSize = true;
this.label2.BackColor = System.Drawing.SystemColors.Control;
this.label2.Font = new System.Drawing.Font("Cambria", 9.75F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.label2.Location = new System.Drawing.Point(204, 96);
this.label2.Name = "label2";
this.label2.Size = new System.Drawing.Size(78, 15);
this.label2.TabIndex = 21;
this.label2.Text = "FIRST NAME";
//
// panel4
//
this.panel4.BackColor = System.Drawing.Color.Gold;
this.panel4.Location = new System.Drawing.Point(10, 423);
this.panel4.Name = "panel4";
this.panel4.Size = new System.Drawing.Size(758, 10);
this.panel4.TabIndex = 41;
//
// panel3
//
this.panel3.BackColor = System.Drawing.Color.Gold;
this.panel3.Location = new System.Drawing.Point(0, 0);
this.panel3.Name = "panel3";
this.panel3.Size = new System.Drawing.Size(758, 10);
this.panel3.TabIndex = 40;
//
// panel2
//
this.panel2.BackColor = System.Drawing.Color.Gold;
this.panel2.Location = new System.Drawing.Point(758, 0);
this.panel2.Name = "panel2";
this.panel2.Size = new System.Drawing.Size(10, 433);
this.panel2.TabIndex = 39;
//
// panel1
//
this.panel1.BackColor = System.Drawing.Color.Gold;
this.panel1.Location = new System.Drawing.Point(0, 0);
this.panel1.Name = "panel1";
this.panel1.Size = new System.Drawing.Size(10, 433);
this.panel1.TabIndex = 38;
//
// button3
//
this.button3.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(192)))), ((int)(((byte)(128)))));
this.button3.Font = new System.Drawing.Font("Cambria", 12F, System.Drawing.FontStyle.Italic, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.button3.Location = new System.Drawing.Point(220, 358);
this.button3.Name = "button3";
this.button3.Size = new System.Drawing.Size(99, 34);
this.button3.TabIndex = 42;
this.button3.Text = "Home";
this.button3.UseVisualStyleBackColor = false;
this.button3.Click += new System.EventHandler(this.button3_Click);
//
// Register
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.BackgroundImage = global::DoctorAppointmentSystem.Properties.Resources.a3;
this.BackgroundImageLayout = System.Windows.Forms.ImageLayout.Stretch;
this.ClientSize = new System.Drawing.Size(769, 433);
this.Controls.Add(this.button3);
this.Controls.Add(this.panel4);
this.Controls.Add(this.panel3);
this.Controls.Add(this.panel2);
this.Controls.Add(this.panel1);
this.Controls.Add(this.button2);
this.Controls.Add(this.button1);
this.Controls.Add(this.textBox7);
this.Controls.Add(this.label8);
this.Controls.Add(this.linkLabel1);
this.Controls.Add(this.textBox6);
this.Controls.Add(this.textBox5);
this.Controls.Add(this.textBox4);
this.Controls.Add(this.textBox3);
this.Controls.Add(this.textBox2);
this.Controls.Add(this.textBox1);
this.Controls.Add(this.label7);
this.Controls.Add(this.label6);
this.Controls.Add(this.label5);
this.Controls.Add(this.label4);
this.Controls.Add(this.label3);
this.Controls.Add(this.label2);
this.Controls.Add(this.label1);
this.Name = "Register";
this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
this.Text = "Register";
this.Load += new System.EventHandler(this.Register_Load);
this.ResumeLayout(false);
this.PerformLayout();
}
#endregion
private System.Windows.Forms.Label label1;
private System.Windows.Forms.Button button2;
private System.Windows.Forms.Button button1;
private System.Windows.Forms.TextBox textBox7;
private System.Windows.Forms.Label label8;
private System.Windows.Forms.LinkLabel linkLabel1;
private System.Windows.Forms.TextBox textBox6;
private System.Windows.Forms.TextBox textBox5;
private System.Windows.Forms.TextBox textBox4;
private System.Windows.Forms.TextBox textBox3;
private System.Windows.Forms.TextBox textBox2;
private System.Windows.Forms.TextBox textBox1;
private System.Windows.Forms.Label label7;
private System.Windows.Forms.Label label6;
private System.Windows.Forms.Label label5;
private System.Windows.Forms.Label label4;
private System.Windows.Forms.Label label3;
private System.Windows.Forms.Label label2;
private System.Windows.Forms.Panel panel4;
private System.Windows.Forms.Panel panel3;
private System.Windows.Forms.Panel panel2;
private System.Windows.Forms.Panel panel1;
private System.Windows.Forms.Button button3;
}
}
Register.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 System.Data.SqlClient;
namespace roombooking
{
public partial class Register : Form
{
public Register()
{
InitializeComponent();
}
private void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
Login log = new Login();
log.Show();
this.Hide();
}
private void button2_Click(object sender, EventArgs e)
{
this.Close();
}
private void button1_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=E:\Project\DotNet-Projects\roombooking\Database\roombooking.mdf;Integrated Security=True;Connect Timeout=30");
conn.Open();
if (textBox1.Text != "" || textBox2.Text != "" || textBox3.Text != "" || textBox4.Text != "" || textBox5.Text != "" || textBox6.Text != "" || textBox7.Text != "")
{
if(textBox5.Text.Length != 10)
{
MessageBox.Show("Please Fill Valid Phone Number");
}
if (textBox6.Text != textBox7.Text)
{
MessageBox.Show("Please Enter Valid Password");
}
if(textBox5.Text.Length == 10 && textBox6.Text == textBox7.Text)
{
SqlCommand cmd = new SqlCommand(@"insert into UserData values ('" + textBox1.Text + "','" + textBox2.Text + "','" + textBox3.Text + "','" + textBox4.Text + "','" + textBox5.Text + "','" + textBox6.Text + "')", conn);
if (cmd.ExecuteNonQuery() > 0)
{
MessageBox.Show("Register Successfull");
Login golog = new Login();
golog.Show();
this.Hide();
}
else
{
MessageBox.Show("Register Failed");
}
}
}
else
{
MessageBox.Show("Please Fill All the Information");
}
conn.Close();
}
private void button3_Click(object sender, EventArgs e)
{
Login home = new Login();
home.Show();
this.Hide();
}
private void Register_Load(object sender, EventArgs e)
{
}
}
}
Selection Module
- Selection module deals with a ready-to-use user interface that queries the update details, view details from the user. We can view the details that have stored in the database.
- A Selection form is a list of fields that a user will be input data and submit to a company or individual.
- There are many reasons why you would want a person to select a selection form.
- Companies use selection forms to select the customers details, services, or other programs or plans.
Selection Module
Sample Code
Selection.Designer.Cs
namespace roombooking
{
partial class Selection
{
/// <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.button1 = new System.Windows.Forms.Button();
this.panel4 = new System.Windows.Forms.Panel();
this.panel3 = new System.Windows.Forms.Panel();
this.panel2 = new System.Windows.Forms.Panel();
this.panel1 = new System.Windows.Forms.Panel();
this.button3 = new System.Windows.Forms.Button();
this.button2 = new System.Windows.Forms.Button();
this.button4 = new System.Windows.Forms.Button();
this.SuspendLayout();
//
// button1
//
this.button1.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(192)))), ((int)(((byte)(0)))));
this.button1.Font = new System.Drawing.Font("Cambria", 12F, System.Drawing.FontStyle.Italic, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.button1.Location = new System.Drawing.Point(183, 407);
this.button1.Name = "button1";
this.button1.Size = new System.Drawing.Size(141, 49);
this.button1.TabIndex = 26;
this.button1.Text = "View Booking";
this.button1.UseVisualStyleBackColor = false;
this.button1.Click += new System.EventHandler(this.button1_Click);
//
// panel4
//
this.panel4.BackColor = System.Drawing.Color.Gold;
this.panel4.Location = new System.Drawing.Point(-1, 469);
this.panel4.Name = "panel4";
this.panel4.Size = new System.Drawing.Size(768, 17);
this.panel4.TabIndex = 34;
//
// panel3
//
this.panel3.BackColor = System.Drawing.Color.Gold;
this.panel3.Location = new System.Drawing.Point(-1, -2);
this.panel3.Name = "panel3";
this.panel3.Size = new System.Drawing.Size(758, 10);
this.panel3.TabIndex = 33;
//
// panel2
//
this.panel2.BackColor = System.Drawing.Color.Gold;
this.panel2.Location = new System.Drawing.Point(757, -2);
this.panel2.Name = "panel2";
this.panel2.Size = new System.Drawing.Size(10, 472);
this.panel2.TabIndex = 32;
//
// panel1
//
this.panel1.BackColor = System.Drawing.Color.Gold;
this.panel1.Location = new System.Drawing.Point(-1, -2);
this.panel1.Name = "panel1";
this.panel1.Size = new System.Drawing.Size(10, 473);
this.panel1.TabIndex = 31;
//
// button3
//
this.button3.BackColor = System.Drawing.Color.MistyRose;
this.button3.Font = new System.Drawing.Font("Cambria", 12F, System.Drawing.FontStyle.Italic, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.button3.Location = new System.Drawing.Point(286, 336);
this.button3.Name = "button3";
this.button3.Size = new System.Drawing.Size(154, 46);
this.button3.TabIndex = 27;
this.button3.Text = "Update Booking";
this.button3.UseVisualStyleBackColor = false;
this.button3.Click += new System.EventHandler(this.button2_Click);
//
// button2
//
this.button2.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(192)))), ((int)(((byte)(128)))));
this.button2.Font = new System.Drawing.Font("Cambria", 12F, System.Drawing.FontStyle.Italic, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.button2.Location = new System.Drawing.Point(105, 336);
this.button2.Name = "button2";
this.button2.Size = new System.Drawing.Size(139, 46);
this.button2.TabIndex = 43;
this.button2.Text = "New Booking";
this.button2.UseVisualStyleBackColor = false;
this.button2.Click += new System.EventHandler(this.button2_Click_1);
//
// button4
//
this.button4.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(128)))), ((int)(((byte)(255)))));
this.button4.Font = new System.Drawing.Font("Cambria", 12F, System.Drawing.FontStyle.Italic, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.button4.Location = new System.Drawing.Point(370, 407);
this.button4.Name = "button4";
this.button4.Size = new System.Drawing.Size(149, 49);
this.button4.TabIndex = 44;
this.button4.Text = "Logout";
this.button4.UseVisualStyleBackColor = false;
this.button4.Click += new System.EventHandler(this.button4_Click);
//
// Selection
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.BackgroundImage = global::DoctorAppointmentSystem.Properties.Resources.a11;
this.BackgroundImageLayout = System.Windows.Forms.ImageLayout.Stretch;
this.ClientSize = new System.Drawing.Size(765, 476);
this.Controls.Add(this.button4);
this.Controls.Add(this.button2);
this.Controls.Add(this.panel4);
this.Controls.Add(this.panel3);
this.Controls.Add(this.panel2);
this.Controls.Add(this.panel1);
this.Controls.Add(this.button3);
this.Controls.Add(this.button1);
this.Name = "Selection";
this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
this.Text = "Selection";
this.Load += new System.EventHandler(this.Selection_Load);
this.ResumeLayout(false);
}
#endregion
private System.Windows.Forms.Button button1;
private System.Windows.Forms.Panel panel4;
private System.Windows.Forms.Panel panel3;
private System.Windows.Forms.Panel panel2;
private System.Windows.Forms.Panel panel1;
private System.Windows.Forms.Button button3;
private System.Windows.Forms.Button button2;
private System.Windows.Forms.Button button4;
}
}
Selection.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 System.Data.SqlClient;
namespace roombooking
{
public partial class Selection : Form
{
public Selection()
{
InitializeComponent();
}
private void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
View goDosboard = new View();
goDosboard.Show();
this.Hide();
}
private void button1_Click(object sender, EventArgs e)
{
View View = new View();
View.Show();
this.Hide();
}
private void button2_Click(object sender, EventArgs e)
{
Update Update = new Update();
Update.Show();
this.Hide();
}
private void button2_Click_1(object sender, EventArgs e)
{
New new1 = new New();
new1.Show();
this.Hide();
}
private void button4_Click(object sender, EventArgs e)
{
Login golog = new Login();
golog.Show();
this.Hide();
}
private void Selection_Load(object sender, EventArgs e)
{
}
}
}
Apply Room Module
- Apply Room Module page provides Customer Id, Customer Name, Booking Date, Type of Booking and purpose offers to Apply for room.
- Apply room module can help the user that they can apply for new room, and what is the purpose to get room.
Apply Room Module
Sample Code
Apply Designer.cs
namespace roombooking
{
partial class New
{
/// <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.label1 = new System.Windows.Forms.Label();
this.label2 = new System.Windows.Forms.Label();
this.label3 = new System.Windows.Forms.Label();
this.label5 = new System.Windows.Forms.Label();
this.label6 = new System.Windows.Forms.Label();
this.textBox1 = new System.Windows.Forms.TextBox();
this.button1 = new System.Windows.Forms.Button();
this.linkLabel1 = new System.Windows.Forms.LinkLabel();
this.textBox4 = new System.Windows.Forms.TextBox();
this.textBox5 = new System.Windows.Forms.TextBox();
this.panel4 = new System.Windows.Forms.Panel();
this.panel3 = new System.Windows.Forms.Panel();
this.panel2 = new System.Windows.Forms.Panel();
this.panel1 = new System.Windows.Forms.Panel();
this.button3 = new System.Windows.Forms.Button();
this.button2 = new System.Windows.Forms.Button();
this.dateTimePicker1 = new System.Windows.Forms.DateTimePicker();
this.label4 = new System.Windows.Forms.Label();
this.comboBox1 = new System.Windows.Forms.ComboBox();
this.SuspendLayout();
//
// label1
//
this.label1.AutoSize = true;
this.label1.BackColor = System.Drawing.Color.Transparent;
this.label1.Font = new System.Drawing.Font("Cambria", 24F, ((System.Drawing.FontStyle)((System.Drawing.FontStyle.Bold | System.Drawing.FontStyle.Italic))), System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.label1.ForeColor = System.Drawing.Color.PaleTurquoise;
this.label1.Location = new System.Drawing.Point(102, 57);
this.label1.Margin = new System.Windows.Forms.Padding(5, 0, 5, 0);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(223, 37);
this.label1.TabIndex = 13;
this.label1.Text = "Room Booking";
this.label1.Click += new System.EventHandler(this.label1_Click);
//
// label2
//
this.label2.AutoSize = true;
this.label2.BackColor = System.Drawing.Color.Transparent;
this.label2.Font = new System.Drawing.Font("Cambria", 12F, System.Drawing.FontStyle.Italic, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.label2.ForeColor = System.Drawing.SystemColors.ControlLightLight;
this.label2.Location = new System.Drawing.Point(22, 191);
this.label2.Name = "label2";
this.label2.Size = new System.Drawing.Size(117, 19);
this.label2.TabIndex = 14;
this.label2.Text = "Customer Name";
//
// label3
//
this.label3.AutoSize = true;
this.label3.BackColor = System.Drawing.Color.Transparent;
this.label3.Font = new System.Drawing.Font("Cambria", 12F, System.Drawing.FontStyle.Italic, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.label3.ForeColor = System.Drawing.SystemColors.ControlLightLight;
this.label3.Location = new System.Drawing.Point(21, 239);
this.label3.Name = "label3";
this.label3.Size = new System.Drawing.Size(99, 19);
this.label3.TabIndex = 15;
this.label3.Text = "Booking Date";
//
// label5
//
this.label5.AutoSize = true;
this.label5.BackColor = System.Drawing.Color.Transparent;
this.label5.Font = new System.Drawing.Font("Cambria", 12F, System.Drawing.FontStyle.Italic, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.label5.ForeColor = System.Drawing.SystemColors.ControlLightLight;
this.label5.Location = new System.Drawing.Point(18, 285);
this.label5.Name = "label5";
this.label5.Size = new System.Drawing.Size(118, 19);
this.label5.TabIndex = 17;
this.label5.Text = "Type Of Booking";
//
// label6
//
this.label6.AutoSize = true;
this.label6.BackColor = System.Drawing.Color.Transparent;
this.label6.Font = new System.Drawing.Font("Cambria", 12F, System.Drawing.FontStyle.Italic, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.label6.ForeColor = System.Drawing.SystemColors.ControlLightLight;
this.label6.Location = new System.Drawing.Point(17, 327);
this.label6.Name = "label6";
this.label6.Size = new System.Drawing.Size(44, 19);
this.label6.TabIndex = 18;
this.label6.Text = "Place";
//
// textBox1
//
this.textBox1.Location = new System.Drawing.Point(181, 190);
this.textBox1.Name = "textBox1";
this.textBox1.Size = new System.Drawing.Size(204, 20);
this.textBox1.TabIndex = 19;
//
// button1
//
this.button1.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(192)))), ((int)(((byte)(0)))));
this.button1.Font = new System.Drawing.Font("Cambria", 12F, System.Drawing.FontStyle.Italic, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.button1.Location = new System.Drawing.Point(148, 374);
this.button1.Name = "button1";
this.button1.Size = new System.Drawing.Size(105, 34);
this.button1.TabIndex = 26;
this.button1.Text = "Add";
this.button1.UseVisualStyleBackColor = false;
this.button1.Click += new System.EventHandler(this.button1_Click);
//
// linkLabel1
//
this.linkLabel1.AutoSize = true;
this.linkLabel1.BackColor = System.Drawing.Color.Transparent;
this.linkLabel1.Font = new System.Drawing.Font("Cambria", 12F, System.Drawing.FontStyle.Italic, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.linkLabel1.LinkColor = System.Drawing.Color.Yellow;
this.linkLabel1.Location = new System.Drawing.Point(179, 412);
this.linkLabel1.Name = "linkLabel1";
this.linkLabel1.Size = new System.Drawing.Size(129, 19);
this.linkLabel1.TabIndex = 28;
this.linkLabel1.TabStop = true;
this.linkLabel1.Text = "Goto Dosboard -->";
this.linkLabel1.LinkClicked += new System.Windows.Forms.LinkLabelLinkClickedEventHandler(this.linkLabel1_LinkClicked);
//
// textBox4
//
this.textBox4.Location = new System.Drawing.Point(177, 286);
this.textBox4.Name = "textBox4";
this.textBox4.Size = new System.Drawing.Size(204, 20);
this.textBox4.TabIndex = 30;
//
// textBox5
//
this.textBox5.Location = new System.Drawing.Point(177, 328);
this.textBox5.Name = "textBox5";
this.textBox5.Size = new System.Drawing.Size(204, 20);
this.textBox5.TabIndex = 29;
//
// panel4
//
this.panel4.BackColor = System.Drawing.Color.Gold;
this.panel4.Location = new System.Drawing.Point(-1, 463);
this.panel4.Name = "panel4";
this.panel4.Size = new System.Drawing.Size(768, 17);
this.panel4.TabIndex = 34;
//
// panel3
//
this.panel3.BackColor = System.Drawing.Color.Gold;
this.panel3.Location = new System.Drawing.Point(-1, -2);
this.panel3.Name = "panel3";
this.panel3.Size = new System.Drawing.Size(758, 10);
this.panel3.TabIndex = 33;
//
// panel2
//
this.panel2.BackColor = System.Drawing.Color.Gold;
this.panel2.Location = new System.Drawing.Point(757, -2);
this.panel2.Name = "panel2";
this.panel2.Size = new System.Drawing.Size(10, 472);
this.panel2.TabIndex = 32;
//
// panel1
//
this.panel1.BackColor = System.Drawing.Color.Gold;
this.panel1.Location = new System.Drawing.Point(-1, -2);
this.panel1.Name = "panel1";
this.panel1.Size = new System.Drawing.Size(10, 473);
this.panel1.TabIndex = 31;
//
// button3
//
this.button3.BackColor = System.Drawing.Color.Red;
this.button3.Font = new System.Drawing.Font("Cambria", 12F, System.Drawing.FontStyle.Italic, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.button3.Location = new System.Drawing.Point(280, 374);
this.button3.Name = "button3";
this.button3.Size = new System.Drawing.Size(105, 34);
this.button3.TabIndex = 27;
this.button3.Text = "Cancel";
this.button3.UseVisualStyleBackColor = false;
this.button3.Click += new System.EventHandler(this.button2_Click);
//
// button2
//
this.button2.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(192)))), ((int)(((byte)(128)))));
this.button2.Font = new System.Drawing.Font("Cambria", 12F, System.Drawing.FontStyle.Italic, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.button2.Location = new System.Drawing.Point(22, 374);
this.button2.Name = "button2";
this.button2.Size = new System.Drawing.Size(99, 34);
this.button2.TabIndex = 43;
this.button2.Text = "Back";
this.button2.UseVisualStyleBackColor = false;
this.button2.Click += new System.EventHandler(this.button2_Click_1);
//
// dateTimePicker1
//
this.dateTimePicker1.Location = new System.Drawing.Point(181, 237);
this.dateTimePicker1.Name = "dateTimePicker1";
this.dateTimePicker1.Size = new System.Drawing.Size(200, 20);
this.dateTimePicker1.TabIndex = 44;
//
// label4
//
this.label4.AutoSize = true;
this.label4.BackColor = System.Drawing.Color.Transparent;
this.label4.Font = new System.Drawing.Font("Cambria", 12F, System.Drawing.FontStyle.Italic, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.label4.ForeColor = System.Drawing.SystemColors.ControlLightLight;
this.label4.Location = new System.Drawing.Point(21, 143);
this.label4.Name = "label4";
this.label4.Size = new System.Drawing.Size(93, 19);
this.label4.TabIndex = 45;
this.label4.Text = "Customer ID";
//
// comboBox1
//
this.comboBox1.FormattingEnabled = true;
this.comboBox1.Location = new System.Drawing.Point(181, 143);
this.comboBox1.Name = "comboBox1";
this.comboBox1.Size = new System.Drawing.Size(204, 21);
this.comboBox1.TabIndex = 46;
//
// New
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.BackgroundImage = global::DoctorAppointmentSystem.Properties.Resources.a21;
this.BackgroundImageLayout = System.Windows.Forms.ImageLayout.Stretch;
this.ClientSize = new System.Drawing.Size(765, 476);
this.Controls.Add(this.comboBox1);
this.Controls.Add(this.label4);
this.Controls.Add(this.dateTimePicker1);
this.Controls.Add(this.button2);
this.Controls.Add(this.panel4);
this.Controls.Add(this.panel3);
this.Controls.Add(this.panel2);
this.Controls.Add(this.panel1);
this.Controls.Add(this.textBox4);
this.Controls.Add(this.textBox5);
this.Controls.Add(this.linkLabel1);
this.Controls.Add(this.button3);
this.Controls.Add(this.button1);
this.Controls.Add(this.textBox1);
this.Controls.Add(this.label6);
this.Controls.Add(this.label5);
this.Controls.Add(this.label3);
this.Controls.Add(this.label2);
this.Controls.Add(this.label1);
this.Name = "New";
this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
this.Text = "New";
this.Load += new System.EventHandler(this.New_Load);
this.ResumeLayout(false);
this.PerformLayout();
}
#endregion
private System.Windows.Forms.Label label1;
private System.Windows.Forms.Label label2;
private System.Windows.Forms.Label label3;
private System.Windows.Forms.Label label5;
private System.Windows.Forms.Label label6;
private System.Windows.Forms.TextBox textBox1;
private System.Windows.Forms.Button button1;
private System.Windows.Forms.LinkLabel linkLabel1;
private System.Windows.Forms.TextBox textBox4;
private System.Windows.Forms.TextBox textBox5;
private System.Windows.Forms.Panel panel4;
private System.Windows.Forms.Panel panel3;
private System.Windows.Forms.Panel panel2;
private System.Windows.Forms.Panel panel1;
private System.Windows.Forms.Button button3;
private System.Windows.Forms.Button button2;
private System.Windows.Forms.DateTimePicker dateTimePicker1;
private System.Windows.Forms.Label label4;
private System.Windows.Forms.ComboBox comboBox1;
}
}
Apply.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 System.Data.SqlClient;
namespace roombooking
{
public partial class New : Form
{
public New()
{
InitializeComponent();
}
private void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
Selection sel = new Selection();
sel.Show();
this.Hide();
}
private void button1_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=E:\Project\DotNet-Projects\roombooking\Database\roombooking.mdf;Integrated Security=True;Connect Timeout=30");
conn.Open();
if (textBox1.Text != "" || textBox4.Text != "" || textBox5.Text != "")
{
SqlCommand cmd = new SqlCommand(@"insert into Detail([Id],[Name],[Date],[Type],[Purpose]) values ('" + comboBox1.SelectedItem.ToString() + "','" + textBox1.Text + "','" + dateTimePicker1.Value.ToString("MM/dd/yyyy") + "','" + textBox4.Text + "','" + textBox5.Text + "')", conn);
if (cmd.ExecuteNonQuery() > 0)
{
MessageBox.Show("Booking Successfull");
Selection gosel = new Selection();
gosel.Show();
this.Hide();
}
else
{
MessageBox.Show("Booking Rejected");
}
}
else
{
MessageBox.Show("Please Fill All the Information");
}
conn.Close();
}
private void button2_Click(object sender, EventArgs e)
{
//this.Close();
View view = new View();
view.Show();
this.Hide();
}
private void New_Load(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=E:\Project\DotNet-Projects\roombooking\Database\roombooking.mdf;Integrated Security=True;Connect Timeout=30");
conn.Open();
SqlCommand cmd = new SqlCommand(@"select id from UserData", conn);
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
foreach (DataRow dr in dt.Rows)
comboBox1.Items.Add(dr[0].ToString());
conn.Close();
}
private void button2_Click_1(object sender, EventArgs e)
{
Selection sel = new Selection();
sel.Show();
this.Hide();
}
private void label1_Click(object sender, EventArgs e)
{
}
}
}
Update Module
- Update Design module is used to update the details like Customer Id, Customer Name, Booking Date, Type of Booking.
- An Update form is a list of fields that a user will input data and submit to a company or an individual.
- There are many reasons why you would want a person to select out Update form.Companies use Update forms to Update the customers details, services, or other programs.
Update Module
Sample code
Update.Designer.cs
namespace roombooking
{
partial class Update
{
/// <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.label1 = new System.Windows.Forms.Label();
this.button1 = new System.Windows.Forms.Button();
this.label2 = new System.Windows.Forms.Label();
this.panel4 = new System.Windows.Forms.Panel();
this.panel3 = new System.Windows.Forms.Panel();
this.panel2 = new System.Windows.Forms.Panel();
this.panel1 = new System.Windows.Forms.Panel();
this.button3 = new System.Windows.Forms.Button();
this.comboBox1 = new System.Windows.Forms.ComboBox();
this.dataGridView1 = new System.Windows.Forms.DataGridView();
this.button4 = new System.Windows.Forms.Button();
this.label3 = new System.Windows.Forms.Label();
this.label4 = new System.Windows.Forms.Label();
this.dataGridView2 = new System.Windows.Forms.DataGridView();
this.comboBox2 = new System.Windows.Forms.ComboBox();
((System.ComponentModel.ISupportInitialize)(this.dataGridView1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dataGridView2)).BeginInit();
this.SuspendLayout();
//
// label1
//
this.label1.AutoSize = true;
this.label1.Font = new System.Drawing.Font("Cambria", 24F, ((System.Drawing.FontStyle)((System.Drawing.FontStyle.Bold | System.Drawing.FontStyle.Italic))), System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.label1.ForeColor = System.Drawing.Color.OrangeRed;
this.label1.Location = new System.Drawing.Point(251, 201);
this.label1.Margin = new System.Windows.Forms.Padding(5, 0, 5, 0);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(236, 37);
this.label1.TabIndex = 2;
this.label1.Text = "Update Details ";
//
// button1
//
this.button1.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(192)))), ((int)(((byte)(0)))));
this.button1.Font = new System.Drawing.Font("Cambria", 9.75F, System.Drawing.FontStyle.Italic, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.button1.Location = new System.Drawing.Point(505, 364);
this.button1.Name = "button1";
this.button1.Size = new System.Drawing.Size(90, 34);
this.button1.TabIndex = 36;
this.button1.Text = "UPDATE";
this.button1.UseVisualStyleBackColor = false;
this.button1.Click += new System.EventHandler(this.button1_Click);
//
// label2
//
this.label2.AutoSize = true;
this.label2.Font = new System.Drawing.Font("Cambria", 9.75F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.label2.Location = new System.Drawing.Point(194, 251);
this.label2.Name = "label2";
this.label2.Size = new System.Drawing.Size(76, 15);
this.label2.TabIndex = 21;
this.label2.Text = "Customer ID";
//
// panel4
//
this.panel4.BackColor = System.Drawing.Color.Gold;
this.panel4.Location = new System.Drawing.Point(10, 423);
this.panel4.Name = "panel4";
this.panel4.Size = new System.Drawing.Size(758, 10);
this.panel4.TabIndex = 41;
//
// panel3
//
this.panel3.BackColor = System.Drawing.Color.Gold;
this.panel3.Location = new System.Drawing.Point(0, 0);
this.panel3.Name = "panel3";
this.panel3.Size = new System.Drawing.Size(758, 10);
this.panel3.TabIndex = 40;
//
// panel2
//
this.panel2.BackColor = System.Drawing.Color.Gold;
this.panel2.Location = new System.Drawing.Point(758, 0);
this.panel2.Name = "panel2";
this.panel2.Size = new System.Drawing.Size(10, 433);
this.panel2.TabIndex = 39;
//
// panel1
//
this.panel1.BackColor = System.Drawing.Color.Gold;
this.panel1.Location = new System.Drawing.Point(0, 0);
this.panel1.Name = "panel1";
this.panel1.Size = new System.Drawing.Size(10, 433);
this.panel1.TabIndex = 38;
//
// button3
//
this.button3.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(192)))), ((int)(((byte)(128)))));
this.button3.Font = new System.Drawing.Font("Cambria", 12F, System.Drawing.FontStyle.Italic, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.button3.Location = new System.Drawing.Point(653, 16);
this.button3.Name = "button3";
this.button3.Size = new System.Drawing.Size(99, 34);
this.button3.TabIndex = 42;
this.button3.Text = "Home";
this.button3.UseVisualStyleBackColor = false;
this.button3.Click += new System.EventHandler(this.button3_Click_1);
//
// comboBox1
//
this.comboBox1.FormattingEnabled = true;
this.comboBox1.Location = new System.Drawing.Point(277, 245);
this.comboBox1.Name = "comboBox1";
this.comboBox1.Size = new System.Drawing.Size(203, 21);
this.comboBox1.TabIndex = 43;
//
// dataGridView1
//
this.dataGridView1.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
this.dataGridView1.Location = new System.Drawing.Point(57, 281);
this.dataGridView1.Name = "dataGridView1";
this.dataGridView1.Size = new System.Drawing.Size(667, 77);
this.dataGridView1.TabIndex = 44;
//
// button4
//
this.button4.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(192)))), ((int)(((byte)(0)))));
this.button4.Font = new System.Drawing.Font("Cambria", 9.75F, System.Drawing.FontStyle.Italic, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.button4.Location = new System.Drawing.Point(505, 241);
this.button4.Name = "button4";
this.button4.Size = new System.Drawing.Size(90, 34);
this.button4.TabIndex = 45;
this.button4.Text = "FETCH DATA ";
this.button4.UseVisualStyleBackColor = false;
this.button4.Click += new System.EventHandler(this.button4_Click);
//
// label3
//
this.label3.AutoSize = true;
this.label3.Font = new System.Drawing.Font("Cambria", 9.75F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.label3.Location = new System.Drawing.Point(194, 374);
this.label3.Name = "label3";
this.label3.Size = new System.Drawing.Size(57, 15);
this.label3.TabIndex = 46;
this.label3.Text = "PROCESS";
//
// label4
//
this.label4.AutoSize = true;
this.label4.Font = new System.Drawing.Font("Cambria", 24F, ((System.Drawing.FontStyle)((System.Drawing.FontStyle.Bold | System.Drawing.FontStyle.Italic))), System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.label4.ForeColor = System.Drawing.Color.OrangeRed;
this.label4.Location = new System.Drawing.Point(270, 39);
this.label4.Margin = new System.Windows.Forms.Padding(5, 0, 5, 0);
this.label4.Name = "label4";
this.label4.Size = new System.Drawing.Size(203, 37);
this.label4.TabIndex = 48;
this.label4.Text = "Fetch Details";
//
// dataGridView2
//
this.dataGridView2.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
this.dataGridView2.Location = new System.Drawing.Point(57, 79);
this.dataGridView2.Name = "dataGridView2";
this.dataGridView2.Size = new System.Drawing.Size(667, 100);
this.dataGridView2.TabIndex = 49;
//
// comboBox2
//
this.comboBox2.FormattingEnabled = true;
this.comboBox2.Items.AddRange(new object[] {
"Done",
"NotDone"});
this.comboBox2.Location = new System.Drawing.Point(277, 374);
this.comboBox2.Name = "comboBox2";
this.comboBox2.Size = new System.Drawing.Size(203, 21);
this.comboBox2.TabIndex = 50;
//
// Update
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.ClientSize = new System.Drawing.Size(769, 433);
this.Controls.Add(this.comboBox2);
this.Controls.Add(this.dataGridView2);
this.Controls.Add(this.label4);
this.Controls.Add(this.label3);
this.Controls.Add(this.button4);
this.Controls.Add(this.dataGridView1);
this.Controls.Add(this.comboBox1);
this.Controls.Add(this.button3);
this.Controls.Add(this.panel4);
this.Controls.Add(this.panel3);
this.Controls.Add(this.panel2);
this.Controls.Add(this.panel1);
this.Controls.Add(this.button1);
this.Controls.Add(this.label2);
this.Controls.Add(this.label1);
this.Name = "Update";
this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
this.Text = "Update";
this.Load += new System.EventHandler(this.Update_Load);
((System.ComponentModel.ISupportInitialize)(this.dataGridView1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dataGridView2)).EndInit();
this.ResumeLayout(false);
this.PerformLayout();
}
#endregion
private System.Windows.Forms.Label label1;
private System.Windows.Forms.Button button1;
private System.Windows.Forms.Label label2;
private System.Windows.Forms.Panel panel4;
private System.Windows.Forms.Panel panel3;
private System.Windows.Forms.Panel panel2;
private System.Windows.Forms.Panel panel1;
private System.Windows.Forms.Button button3;
private System.Windows.Forms.ComboBox comboBox1;
private System.Windows.Forms.DataGridView dataGridView1;
private System.Windows.Forms.Button button4;
private System.Windows.Forms.Label label3;
private System.Windows.Forms.Label label4;
private System.Windows.Forms.DataGridView dataGridView2;
private System.Windows.Forms.ComboBox comboBox2;
}
}
View Module
- View module deals with a ready-to-use user interface that queries the update details from the user. We can view the details that have stored in the database.
- A View form is a list of fields that a user will input data and submit to a company or an individual.
- There are many reasons why you would want a person to select a View form.
- Companies use View forms to View the customers details, services, or other programs or plans.
View Module
Sample Code
View.Designer.cs
namespace roombooking
{
partial class View
{
/// <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.label1 = new System.Windows.Forms.Label();
this.button1 = new System.Windows.Forms.Button();
this.dataGridView1 = new System.Windows.Forms.DataGridView();
this.dataGridView2 = new System.Windows.Forms.DataGridView();
this.button2 = new System.Windows.Forms.Button();
this.button3 = new System.Windows.Forms.Button();
this.panel4 = new System.Windows.Forms.Panel();
this.panel3 = new System.Windows.Forms.Panel();
this.panel2 = new System.Windows.Forms.Panel();
this.panel1 = new System.Windows.Forms.Panel();
((System.ComponentModel.ISupportInitialize)(this.dataGridView1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dataGridView2)).BeginInit();
this.SuspendLayout();
//
// label1
//
this.label1.AutoSize = true;
this.label1.Font = new System.Drawing.Font("Cambria", 24F, ((System.Drawing.FontStyle)((System.Drawing.FontStyle.Bold | System.Drawing.FontStyle.Italic))), System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.label1.ForeColor = System.Drawing.Color.OrangeRed;
this.label1.Location = new System.Drawing.Point(192, 12);
this.label1.Margin = new System.Windows.Forms.Padding(5, 0, 5, 0);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(421, 37);
this.label1.TabIndex = 11;
this.label1.Text = "Welcome to Your Dashboard";
//
// button1
//
this.button1.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(128)))), ((int)(((byte)(128)))), ((int)(((byte)(255)))));
this.button1.Font = new System.Drawing.Font("Cambria", 12F, System.Drawing.FontStyle.Italic, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.button1.Location = new System.Drawing.Point(288, 61);
this.button1.Name = "button1";
this.button1.Size = new System.Drawing.Size(185, 42);
this.button1.TabIndex = 12;
this.button1.Text = "View Customer Profile";
this.button1.UseVisualStyleBackColor = false;
this.button1.Click += new System.EventHandler(this.button1_Click);
//
// dataGridView1
//
this.dataGridView1.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
this.dataGridView1.Location = new System.Drawing.Point(50, 109);
this.dataGridView1.Name = "dataGridView1";
this.dataGridView1.Size = new System.Drawing.Size(667, 117);
this.dataGridView1.TabIndex = 14;
//
// dataGridView2
//
this.dataGridView2.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
this.dataGridView2.Location = new System.Drawing.Point(50, 286);
this.dataGridView2.Name = "dataGridView2";
this.dataGridView2.Size = new System.Drawing.Size(667, 117);
this.dataGridView2.TabIndex = 16;
//
// button2
//
this.button2.BackColor = System.Drawing.Color.Cyan;
this.button2.Font = new System.Drawing.Font("Cambria", 12F, System.Drawing.FontStyle.Italic, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.button2.Location = new System.Drawing.Point(264, 238);
this.button2.Name = "button2";
this.button2.Size = new System.Drawing.Size(231, 42);
this.button2.TabIndex = 15;
this.button2.Text = "View Customer Detail";
this.button2.UseVisualStyleBackColor = false;
this.button2.Click += new System.EventHandler(this.button2_Click);
//
// button3
//
this.button3.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(128)))), ((int)(((byte)(255)))));
this.button3.Font = new System.Drawing.Font("Cambria", 12F, System.Drawing.FontStyle.Italic, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.button3.Location = new System.Drawing.Point(617, 28);
this.button3.Name = "button3";
this.button3.Size = new System.Drawing.Size(100, 37);
this.button3.TabIndex = 17;
this.button3.Text = "Back";
this.button3.UseVisualStyleBackColor = false;
this.button3.Click += new System.EventHandler(this.button3_Click);
//
// panel4
//
this.panel4.BackColor = System.Drawing.Color.Gold;
this.panel4.Location = new System.Drawing.Point(8, 422);
this.panel4.Name = "panel4";
this.panel4.Size = new System.Drawing.Size(758, 10);
this.panel4.TabIndex = 25;
//
// panel3
//
this.panel3.BackColor = System.Drawing.Color.Gold;
this.panel3.Location = new System.Drawing.Point(-2, -1);
this.panel3.Name = "panel3";
this.panel3.Size = new System.Drawing.Size(758, 10);
this.panel3.TabIndex = 24;
//
// panel2
//
this.panel2.BackColor = System.Drawing.Color.Gold;
this.panel2.Location = new System.Drawing.Point(756, -1);
this.panel2.Name = "panel2";
this.panel2.Size = new System.Drawing.Size(10, 433);
this.panel2.TabIndex = 23;
//
// panel1
//
this.panel1.BackColor = System.Drawing.Color.Gold;
this.panel1.Location = new System.Drawing.Point(-2, -1);
this.panel1.Name = "panel1";
this.panel1.Size = new System.Drawing.Size(10, 433);
this.panel1.TabIndex = 22;
//
// View
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.BackColor = System.Drawing.Color.White;
this.ClientSize = new System.Drawing.Size(764, 430);
this.Controls.Add(this.panel4);
this.Controls.Add(this.panel3);
this.Controls.Add(this.panel2);
this.Controls.Add(this.panel1);
this.Controls.Add(this.button3);
this.Controls.Add(this.dataGridView2);
this.Controls.Add(this.button2);
this.Controls.Add(this.dataGridView1);
this.Controls.Add(this.button1);
this.Controls.Add(this.label1);
this.Name = "View";
this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
this.Text = "View";
this.Load += new System.EventHandler(this.View_Load);
((System.ComponentModel.ISupportInitialize)(this.dataGridView1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dataGridView2)).EndInit();
this.ResumeLayout(false);
this.PerformLayout();
}
#endregion
private System.Windows.Forms.Label label1;
private System.Windows.Forms.Button button1;
private System.Windows.Forms.DataGridView dataGridView1;
private System.Windows.Forms.DataGridView dataGridView2;
private System.Windows.Forms.Button button2;
private System.Windows.Forms.Button button3;
private System.Windows.Forms.Panel panel4;
private System.Windows.Forms.Panel panel3;
private System.Windows.Forms.Panel panel2;
private System.Windows.Forms.Panel panel1;
}
}
View.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 System.Data.SqlClient;
namespace roombooking
{
public partial class View : Form
{
public View()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=E:\Project\DotNet-Projects\roombooking\Database\roombooking.mdf;Integrated Security=True;Connect Timeout=30");
conn.Open();
SqlCommand cmd = new SqlCommand(@"select * from UserData", conn);
cmd.ExecuteNonQuery();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
dataGridView1.DataSource = dt;
conn.Close();
}
private void button2_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=E:\Project\DotNet-Projects\roombooking\Database\roombooking.mdf;Integrated Security=True;Connect Timeout=30");
conn.Open();
SqlCommand cmd = new SqlCommand(@"select * from Detail", conn);
cmd.ExecuteNonQuery();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
dataGridView2.DataSource = dt;
conn.Close();
}
private void button3_Click(object sender, EventArgs e)
{
Selection golog = new Selection();
golog.Show();
this.Hide();
}
private void View_Load(object sender, EventArgs e)
{
}
}
}Future Enhancement
- This system will also help other institutions, having an insight of how Room Management System works.
- This online payment facility will helps the sutends to pay their hostel fee online. There is no need for going to the bank or coming to school with teller after paying at the bank.Therefore it will very helpful to reducing the stress from the overall process.
Conclusion
- The conclusion on Room Management System is the concept of information technology. It expanded the use of internet as in web enabled hostel application process, which helps in hostel application. This is independent of human weakness compared to the human working as compared to the working of the computer.
- This system will also help other institutions in having an insight of how hostel management system works.