ABSTRACT:
The purpose of this project is to analysis different perspectives, developing which helps in the application of theory to practical situations. And, where I have to be able to prepare a realistic and correct model which assures efficient Mystery Shopping and Catchment Analysis which helps in improving the existing model. I have actively contribute to the company’s objectives by applying the knowledge and skills and initially worked to gain the basic knowledge on how to behave in organization, customer behaviour, way of dealing customer, how to audit the shop, what are the criteria should need to observe, how to capture the customer, how to analyse the competitor, market selection, area analysis, site evaluation, selection of target people, how to differentiate catchment area. This project helps to create the webpage for buying the specs using the model name and color. The admin accesses the webpage to update the model name and color.
EXISTING SYSTEM:
. This project is based on creating a website for online shopping for specs. This is similar to other online shopping pages. Many people buy specs by visiting the specs shop. There was a manual storage of data base about the customer and model of the specs available which was difficult to maintain by the management.
PROPOSED SYSTEM
This project helps the public to view all the product and find the best chose for them in online. People need not visit the shop to get the specs they can shop online.
ARCHITECTURE:
SCREENSHOT:
SAMPLE CODE:
Login.cs
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace ECEVIT
{
public partial class Login : Form
{
SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\pc\Documents\lenskart.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True");
public Login()
{
InitializeComponent();
}
private void Form3_Load(object sender, EventArgs e)
{
}
private void label3_Click(object sender, EventArgs e)
{
}
private void label1_Click(object sender, EventArgs e)
{
}
private void textBox1_TextChanged(object sender, EventArgs e)
{
}
private void linkLabel2_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
Register g = new Register();
g.Show();
this.Hide();
}
private void button1_Click(object sender, EventArgs e)
{
con.Open();
SqlCommand cmd = con.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select * from table2 where Username='" + textBox1.Text + "' and Password='" + textBox2.Text + "'";
cmd.ExecuteNonQuery();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
con.Close();
if (dt.Rows.Count == 1)
{
Main f = new Main();
f.Show();
this.Hide();
}
else
MessageBox.Show("Access Denied!");
}
private void button2_Click(object sender, EventArgs e)
{
this.Hide();
}
}
}
Registration.cs
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace ECEVIT
{
public partial class Register : Form
{
SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\pc\Documents\lenskart.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True");
public Register()
{
InitializeComponent();
}
private void label1_Click(object sender, EventArgs e)
{
}
private void label2_Click(object sender, EventArgs e)
{
}
private void label4_Click(object sender, EventArgs e)
{
}
private void label5_Click(object sender, EventArgs e)
{
}
private void label3_Click(object sender, EventArgs e)
{
}
private void textBox4_TextChanged(object sender, EventArgs e)
{
}
private void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
}
private void linkLabel2_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
Login g = new Login();
g.Show();
this.Hide();
}
private void button1_Click(object sender, EventArgs e)
{
con.Open();
SqlCommand cmd = con.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "insert into table2 values('" + textBox3.Text + "','" + textBox4.Text + "')";
cmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("Registered Successfully!");
}
private void Register_Load(object sender, EventArgs e)
{
}
}
}
Main.cs
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace ECEVIT
{
public partial class Main : Form
{
SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\pc\Documents\lenskart.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True");
public Main()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
con.Open();
SqlCommand cmd = con.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "insert into table1 values('"+textBox1.Text+"','"+textBox2.Text+"','"+textBox3.Text+"','"+textBox4.Text+"')";
cmd.ExecuteNonQuery();
con.Close();
disp_data();
MessageBox.Show("Stock Inserted Successfully!");
}
public void disp_data()
{
con.Open();
SqlCommand cmd = con.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select * from table1";
cmd.ExecuteNonQuery();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
dataGridView1.DataSource = dt;
con.Close();
}
private void button3_Click(object sender, EventArgs e)
{
con.Open();
SqlCommand cmd = con.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "delete from table1 where ModelName='"+textBox1.Text+"'";
cmd.ExecuteNonQuery();
con.Close();
disp_data();
MessageBox.Show("Stock Removed Successfully!");
}
private void button4_Click(object sender, EventArgs e)
{
disp_data();
}
private void label3_Click(object sender, EventArgs e)
{
}
private void label4_Click(object sender, EventArgs e)
{
}
private void label5_Click(object sender, EventArgs e)
{
}
private void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
Search f = new Search();
f.Show();
this.Hide();
}
private void linkLabel2_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
Login g = new Login();
g.Show();
this.Hide();
}
private void linkLabel3_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
Updateoption h = new Updateoption();
h.Show();
this.Hide();
}
private void textBox1_TextChanged(object sender, EventArgs e)
{
}
}
}
Update Option.cs
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
namespace ECEVIT
{
public partial class Updateoption : Form
{
public Updateoption()
{
InitializeComponent();
}
int k;
private void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
Main f = new Main();
f.Show();
this.Hide();
}
private void radioButton1_CheckedChanged(object sender, EventArgs e)
{
k = 1;
}
private void radioButton2_CheckedChanged(object sender, EventArgs e)
{
k = 2;
}
private void linkLabel2_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
if (k == 1)
{
Nameupdate f = new Nameupdate();
f.Show();
this.Hide();
}
else
{
Colorupdate f = new Colorupdate();
f.Show();
this.Hide();
}
}
private void label1_Click(object sender, EventArgs e)
{
}
}
}
Name update.cs
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace ECEVIT
{
public partial class Nameupdate : Form
{
SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\pc\Documents\lenskart.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True");
public Nameupdate()
{
InitializeComponent();
}
public void disp_data()
{
con.Open();
SqlCommand cmd = con.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select * from table1";
cmd.ExecuteNonQuery();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
dataGridView1.DataSource = dt;
con.Close();
}
private void button1_Click(object sender, EventArgs e)
{
con.Open();
SqlCommand cmd = con.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "update table1 set ModelName='" + textBox2.Text + "' where ModelName ='" + textBox1.Text + "'";
cmd.ExecuteNonQuery();
con.Close();
disp_data();
MessageBox.Show("Stock Updated Successfully!");
}
private void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
Main f = new Main();
f.Show();
this.Hide();
}
private void textBox1_TextChanged(object sender, EventArgs e)
{
}
}
}
Color Update.cs
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace ECEVIT
{
public partial class Colorupdate : Form
{
SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\pc\Documents\lenskart.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True");
public Colorupdate()
{
InitializeComponent();
}
public void disp_data()
{
con.Open();
SqlCommand cmd = con.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select * from table1";
cmd.ExecuteNonQuery();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
dataGridView1.DataSource = dt;
con.Close();
}
private void button1_Click(object sender, EventArgs e)
{
con.Open();
SqlCommand cmd = con.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "update table1 set Color='" + textBox2.Text + "' where Color ='" + textBox1.Text + "'";
cmd.ExecuteNonQuery();
con.Close();
disp_data();
MessageBox.Show("Stock Updated Successfully!");
}
private void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
Main f = new Main();
f.Show();
this.Hide();
}
private void textBox1_TextChanged(object sender, EventArgs e)
{
}
private void Colorupdate_Load(object sender, EventArgs e)
{
}
private void label1_Click(object sender, EventArgs e)
{
}
private void label2_Click(object sender, EventArgs e)
{
}
private void label3_Click(object sender, EventArgs e)
{
}
}
}
Search.cs
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace ECEVIT
{
public partial class Search : Form
{
SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\pc\Documents\lenskart.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True");
public Search()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
con.Open();
SqlCommand cmd = con.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select * from table1 where ModelName='" + textBox1.Text + "'";
cmd.ExecuteNonQuery();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
dataGridView1.DataSource = dt;
con.Close();
}
private void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
Main f = new Main();
f.Show();
this.Hide();
}
private void textBox1_TextChanged(object sender, EventArgs e)
{
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
}
}
}
MODULES SPECIFICATION:
A module is a part of a program. Programs are composed of one or more independently developed modules that are not combined until the program is linked. A single module can contain one or several routines. The project contains the following main modules.
• LOGIN MODULE
• REGISTRATION MODULE
• MAIN MODULE
• UPDATE OPTION MODULE
• MODEL UPDATE MODULE
• COLOR UPDATE MODULE
• SEARCH MODULE
LOGIN MODULE:
In Login Module, it acts as a very great security feature to the application if the user uses proper user id and password it enters in to application or else it returns back in to the authentication login page indicating that the user is invalid
• Username: Name of the user
• Password: Password set by the user to login
REGISTRATION MODULE :
The new register accesses to hole data. The Admin has the entire control over this application. Fields required in this module are listed below:
• First Name : First name of the user
• Last Name :Last name of the user
• Email Id : Email id of the user
• Phone No : Phone number of the user
• Username : Name of the username
• Password : Password for user
MAIN MODULE:
In Main Module, it is operated by the admin. This module consists of the details of the product. List of details the main module consists of are listed below.
• Model Name: Name of the product
• Color: color of the product
• Quality: Quality of the product
• Price: price of the product
UPDATE OPTION MODULE:
The Update option module is used to choose update option weather update in model or update in color:
MODEL UPDATE MODULE:
In Update model module, the admin can change the update the model with the existing module. This field consists of:
• Existing : Existing model of the product
• Updation : Updated model of the same product
COLOR UPDATE MODULE:
This module is same as update model module .Instead of, model here we update the color. This field consists of:
• Existing : Existing color of the product
• Updation : Updated color of the same product
SEARCH MODULE:
In this module, user can search the product by using model name.
• Model Name: Name of the model
ISO certified - Mini projects topics :
KaaShiv Offers, Mini projects for engineering . Mini project for engineering includes Block Chain, Artificial Intelligence, Machine Learning, Python and R programming, Application Development, Web designing and Networking . This internship includes the topics related to mini projects for engineering 2nd year, mini projects for engineering 3rd year with circuit diagram.This company runs by,
• 10 Years Awarded Microsoft Most Valuable Professional
• Google Recognized Experts
• Cisco Recognized Certified Experts
• Microsoft Awarded Certified Experts
• Robotics Experts
• HCL Technologies Awarded Expert
Trainers at KaaShiv InfoTech are real-time Software / IT professionals worked in leading MNCs like,
• CTS,
• Wipro,
• TCS,
• Infosys,
• Accenture and
• Mindtree.
The Course curriculum for mini projects topics is carefully researched and prepared by professionals from MNC to meet the demands expected in the IT industry. After completing the mini project Training in Chennai at KaaShiv Infotech, students will be familiar with the Software development process followed in IT industry. Below are some of the insights of our mini projects topics.
• Real-time project development and Technology Training by Microsoft Awarded Most Valuable Professiona
• mini projects for engineering students involves Full practical training
• Hardware and software tools full support
• Technology training
• Placement training
• Full documentation and report analysis
• R & D projects
• Industrial exposure
• Endorsing Corporate skills
WHAT IS MINI PROJECT ?
• The mini Projects plays a crucial role in the teaching-learning process.
• It is also a way of identifying the ability of the student to perform an industrial project or applied research linked to the knowledge discipline.
• A project is defined as an effort to create or modify a specific product or service.
• Projects are temporary work efforts with a clear beginning and end.
• mini project (or program) any undertaking, carried out individually or collaboratively and possibly involving research or design, that is carefully planned (usually by a project team) to achieve a particular aim.
WHAT ARE THE BENEFITS GAINED BY DOING MINI PROJECT :
• mini projects if done well can add a lot of credibility to your profile.
• And especially your mini projects building experience can help you perform well in core job placements & higher studies admission interviews.
TIPS TO SELECT GOOD MINI PROJECTS:
• Analyze the current trends
• Focus your mini projects on any social issue
• Get expert’s assistance whenever possible
• Research about the mini projects done by your seniors
• Refer the research journals published by scholars
• Check the feasibility of your mini projects
• Work with organizations like Kaashiv InfoTech
WHY, ENGINEERING STUDENTS MINI PROJECTS SHOULD BE A REAL TIME MINI PROJECTS ?
• mini projects for engineering students provides a real time exposure for the mini projects for engineering students on the latest and trending technologies. Below are some of the Top jobs in the IT Industry Job Openings ,
• Software Developers – Good in Python, Machine Learning, Data Science and AI programming
• BlockChain Administrators
• IOT Specialists
• Cyber Security
• Web Application Developer – Web Designers
• Information Security Analyst – Security Specialist
• Network Engineers / Analyst
KaaShiv Infotech, mini projects topics - programme hornes you in the above said skills / job roles from basics to Advanced.
MINI PROJECTS FOR ENGINEERING - PROGRAMME HIGHLIGHTS :
• mini projects for topics program duration: 5days/ 10days / Or Any number of days
• Training hours: 3hrs per day
• Software & others tools installation Guidance
• Hardware support
• mini projects topics Report creation / Project Report creation
• mini projects topics students based 2 projects ( real time)
• Mini project Certificate & Inplant Training Certificate & Industrial exposure certificate + (Achievement certificate for best performers)
ADVANTAGES OF OUR- MINI PROJECTS FOR ENGINEERING :
• Get Real Work Experience
• Get a Taste of Your Chosen Field
• Start Networking
• Helps You Choose a Speciality
• Helps You Become More Self-Confident
• Boosts Your CV
• Increases Your Market Value
MINI PROJECTS FOR ENGINEERING - MATERIALS :
• mini projects topics student , includes Materials after the internship programme
• Technological guidance and materials will be shared in entire year for the students to mold technically.
• Our be student involves Free Projects at the end of the programme.
QUERIES OR CONTACT DETAILS :
Venkat (7667662428) and Asha (7667668009)
Email ID: kaashiv.info@gmail.com , priyanka.kaashiv@gmail.com
MINI PROJECTS FOR ENGINEERING- PROGRAMME DURATION :
1 months / 2 months / 3 months to 6 Months ( Any Number of Days - Based on student preferences)
WHO CAN ATTEND THIS MINI PROJECTS FOR ENGINEERING PROGRAMME :
Mini projects topics - Programme can be attended by the students who are looking for mini projects topics-for engineering students/ mini projects for final year
MINI PROJECTS FOR ENGINEERING- PROGRAMME OUTCOME :
1. Student will be specialized in Block Chain, Artificial Intelligence, Machine Learning, Python and R programming, Application Development
, Web designing and Networking concepts (Basics to Advanced)
2. Covering 45 concepts
3. Students will be getting trained in / writing 45 Programs – Will change based on the durations of the program.
4. 2 Projects and project documents will be given at the end of the program
REFERENCE YOUTUBE URL FOR MINI PROJECTS :
Check our Internship Training sample videos at this URL –
www.youtube.com/channel
REGISTRATION LINK FOR – MINI PROJECTS :
mini projects for engineering - Offline - Office training
Fill our online Internship form
MINI PROJECTS FOR ENGINEERING – DEMO LINK :
Check out our Sample mini project topics Content for the training
kaashivinfotech.com/inplant-training-in-chennai-for-cse-demo
CHECK OUR PREVIOUS TESTIMONIALS FROM STUDENTS FROM DIFFERENT COUNTRIES AND DIFFERENT STATES :
www.kaashivinfotech.com/testimonials/
CHECK OUR STUDENTS FEEDBACK ON OUR - MINI PROJECTS FOR ENGINEERING:
Mini projects topics- Feedback - inplant-training-feedback /
mini projects for topics - Feedback - internship-feedback
CHECK OUT THE COLLEGES ATTENDED OUR FINAL YEAR PROJECT FOR ENGINEERING:
internship-and-inplant-training-attendees/
CHECK OUR SOCIAL SERVICE YOUTUBE CHANNELS :
www.youtube.com/channel
Check our Social Service youtube channels
REAL TIME PROJECT :
We ranked Top 200 technological companies in Tamil Nadu, Click here to view
MORE ON OUR, MINI PROJECTS FOR ENGINEERING:
In our, internship on mini projects topics- programme below are following different kind of programmes focused such as,
1. Mini projects topics(or) paid Mini projects topics,
- Kaashiv Provides an in-depth knowledge of software Platform and other relevant software technologies.
2. Mini projects for engineering work from home – Our company provides facility for the students to learn from home as an mini projets for engineering based on latest technological trends.
3. Mini projects for engineering report – Reports are also provided for the Mini projects for engineering students in our company related
4. Mini projects for engineering jobs – 100% Job assistance will be provided for the students to gain practical knowledge during the Mini projects for engineering period in our company.
5. Mini projects for engineering summer / Winter internship 2019/2020 – Summer / Winter holiday internship in mini projects will be given to the student based on the developer knowledge base.
6. Mini projects for engineering interview questions – We provide top trending and frequently asked question for the intern students during the internship period based on software development and trending technologies.
7. Mini projects for engineering test – Based on the students request, if you are looking for any test to validate your knowledge. we are ready to provide the same.
8. Mini projects for engineering certificate – Industry recognized certificates will be provided for the students who perform internship in our company based .
9. Mini projects for engineering online– Learn Mini projects for engineering from home, our company perform internship through online too.
10. Mini projects for engineering ppt / projects report – We provide Mini projects for mca based ppts. projects and project reports as materials after the internship in our company.
11. Free Mini project for engineering - Our company will provide Mini projects for engineering the best students of kaashiv infotech.
12. Project For Diploma mini projects for engineering – We offer project for the diploma mini project for engineering students in our company.
13. Mini project for engineering 2nd Year – Our company offers you mini projects for engineering the above students.
