Vehicle Management systempdf Team Project not more than 23

Vehicle Management system.pdf  

(Team Project - not more than 2-3 students per team)

Posted: October 16

Final Submission: November 9

Project Deliverables. pdf

Evaluation_Sheet.pdf

Phase 1 :  Requirements Specification - (printed and stored on my pen drive) - October 26

Phase 2 : Design Specification- (printed and stored on my pen drive) - October 31

Phase 3 : Test Plan – (printed and stored on my pen drive) - November 2

Phase 4 :  Source Code - (printed and stored on my pen drive) - November 7

Phase 5 :  Test Cases and Results - (printed and stored on my pen drive) - November 9

Solution

program 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;
using System.Data.SqlClient;
namespace Vehicle_Management_System.Cust
{
public partial class Customer : Form
{
string query;
SqlConnection con = new SqlConnection(\"Server=.; Database = VHS; Trusted_Connection = Yes;\");
SqlCommand cmd;
SqlDataAdapter da;
string n = null;
public Customer()
{
InitializeComponent();
txt_del_cust_id.Visible = false;
}
private void get_Veh_Model()
{
query = \"Select * from Vehicle\";
da = new SqlDataAdapter(query, con);
DataSet ds_v_name = new System.Data.DataSet();
int c_count = da.Fill(ds_v_name);
if (c_count > 0)
{
cb_prefer_car_model.DataSource = ds_v_name.Tables[0];
cb_prefer_car_model.ValueMember = \"v_name\";
string carmodel = cb_prefer_car_model.SelectedValue.ToString();
if (carmodel == ds_v_name.Tables[0].Rows[0][\"v_name\"].ToString())
{
groupBox2.Visible = true;
txt_vehicle_name.Text = ds_v_name.Tables[0].Rows[0][\"v_manu_name\"].ToString();
txt_vehicle_model.Text = ds_v_name.Tables[0].Rows[0][\"v_model\"].ToString();
txt_vehicle_manu_year.Text = ds_v_name.Tables[0].Rows[0][\"v_manu_year\"].ToString();
txt_vehicle_cost.Text = ds_v_name.Tables[0].Rows[0][\"v_price\"].ToString();
}
}
}
private void get_single_veh_model(string value)
{
query = \"Select * from Vehicle where v_name=\'\" + value + \"\'\";
da = new SqlDataAdapter(query, con);
DataSet ds_v_name = new System.Data.DataSet();
int c_count = da.Fill(ds_v_name);
if (c_count > 0)
{
cb_prefer_car_model.DataSource = ds_v_name.Tables[0];
cb_prefer_car_model.ValueMember = \"v_name\";
string carmodel = cb_prefer_car_model.SelectedValue.ToString();
if (carmodel == ds_v_name.Tables[0].Rows[0][\"v_name\"].ToString())
{
groupBox2.Visible = true;
txt_vehicle_name.Text = ds_v_name.Tables[0].Rows[0][\"v_manu_name\"].ToString();
txt_vehicle_model.Text = ds_v_name.Tables[0].Rows[0][\"v_model\"].ToString();
txt_vehicle_manu_year.Text = ds_v_name.Tables[0].Rows[0][\"v_manu_year\"].ToString();
txt_vehicle_cost.Text = ds_v_name.Tables[0].Rows[0][\"v_price\"].ToString();
}
}
get_Veh_Model();
}
private void Customer_Load(object sender, EventArgs e)
{
btn_customer_getdetails.Visible = false;
btn_customer_delete.Visible = false;
btn_customer_update.Visible = false;
btn_customer_adddetails.Visible = true;
groupBox2.Visible = false;
get_Veh_Model();
}
private void btn_editcustomer_Click(object sender, EventArgs e)
{
groupBox1.Text = \"Edit Customer\";
lbl_error.Text = \"\";
btn_addcustomer.BackColor = Color.Black;
btn_editcustomer.BackColor = Color.Purple;
btn_deletecustomer.BackColor = Color.Black;
btn_customer_delete.Visible = false;
btn_customer_update.Visible = false;
btn_customer_cancel.Visible = false;
btn_customer_adddetails.Visible = false;
btn_customer_getdetails.Visible = true;
SilverTextbox();
ClearTextbox();
txt_del_cust_id.Visible = false;
}
private void btn_deletecustomer_Click(object sender, EventArgs e)
{
groupBox1.Text = \"Delete Customer\";
lbl_error.Text = \"( Please Enter Customer ID : )\" ;
btn_addcustomer.BackColor = Color.Black;
btn_editcustomer.BackColor = Color.Black;
btn_deletecustomer.BackColor = Color.Purple;
btn_customer_delete.Visible = true;
btn_customer_update.Visible = false;
btn_customer_cancel.Visible = true;
btn_customer_adddetails.Visible = false;
btn_customer_getdetails.Visible = false;
SilverTextbox();
ClearTextbox();
txt_del_cust_id.Visible = true;
}
private void btn_addcustomer_Click(object sender, EventArgs e)
{
groupBox1.Text = \"Add Customer\";
lbl_error.Text = \"\";
WhiteTextbox();
btn_addcustomer.BackColor = Color.Purple;
btn_editcustomer.BackColor = Color.Black;
btn_deletecustomer.BackColor = Color.Black;
btn_customer_delete.Visible = false;
btn_customer_update.Visible = false;
btn_customer_cancel.Visible = true;
btn_customer_adddetails.Visible = true;
btn_customer_getdetails.Visible = false;
ClearTextbox();
txt_del_cust_id.Visible = false;
}
private void btn_customer_getdetails_Click(object sender, EventArgs e)
{
btn_customer_delete.Visible = false;
btn_customer_update.Visible = true;
btn_customer_cancel.Visible = true;
btn_customer_adddetails.Visible = false;
btn_customer_getdetails.Visible = false;
WhiteTextbox();
get_cust_details(txt_customerid.Text);
}
private void get_cust_details(string cid)
{   
query = \" select * from Customer where c_id=\'\" + cid + \"\'\";
DataSet ds_get_cust = new System.Data.DataSet();
da = new SqlDataAdapter(query, con);
int n_get_cust = da.Fill(ds_get_cust);
if (n_get_cust > 0)
{
if (cid == ds_get_cust.Tables[0].Rows[0][\"c_id\"].ToString().Trim())
{
string _gender;
txt_customername.Text = ds_get_cust.Tables[0].Rows[0][\"c_name\"].ToString();
_gender = ds_get_cust.Tables[0].Rows[0][\"c_gender\"].ToString().Trim();
if (_gender == \"Male\")
{
rb_Male.Checked = true;
rb_Female.Checked = false;
}
else
{
rb_Male.Checked = false;
rb_Female.Checked = true;
}
cb_date.Text = ds_get_cust.Tables[0].Rows[0][\"c_date\"].ToString();
cb_month.Text = ds_get_cust.Tables[0].Rows[0][\"c_month\"].ToString();
cb_year.Text = ds_get_cust.Tables[0].Rows[0][\"c_year\"].ToString();
txt_customer_address.Text = ds_get_cust.Tables[0].Rows[0][\"c_address\"].ToString();
txt_customer_phone.Text = ds_get_cust.Tables[0].Rows[0][\"c_phone\"].ToString();
string _carmodel = ds_get_cust.Tables[0].Rows[0][\"c_prefer_car_model\"].ToString();
get_single_veh_model(_carmodel);
}
else
{
ClearTextbox();
}
}
else
{
ClearTextbox();
}
}
private void SilverTextbox()
{
txt_customername.Enabled = false;
txt_customer_phone.Enabled = false;
txt_customer_address.Enabled = false;
rb_Female.Enabled = false;
rb_Male.Enabled = false;
cb_date.Enabled = false;
cb_month.Enabled = false;
cb_year.Enabled = false;
cb_prefer_car_model.Enabled = false;
}
private void WhiteTextbox()
{
txt_customername.Enabled = true;
txt_customer_phone.Enabled = true;
txt_customer_address.Enabled = true;
rb_Female.Enabled = true;
rb_Male.Enabled = true;
cb_date.Enabled = true;
cb_month.Enabled = true;
cb_year.Enabled = true;
cb_prefer_car_model.Enabled = true;
}
private void ClearTextbox()
{
txt_customername.Text = \"\";
txt_customer_phone.Text = \"\";
txt_customer_address.Text = \"\";
rb_Female.Checked = false;
rb_Male.Checked = true;
cb_date.Text = \"Date\";
cb_month.Text = \"Month\";
cb_year.Text = \"Year\";
}
private void cb_prefer_car_model_SelectedIndexChanged(object sender, EventArgs e)
{
string c1;
c1 = cb_prefer_car_model.SelectedValue.ToString();
query = \"Select * from Vehicle where v_name=\'\" + cb_prefer_car_model.SelectedValue.ToString() + \"\'\";
da = new SqlDataAdapter(query, con);
DataSet ds_v_name = new System.Data.DataSet();
int c_count = da.Fill(ds_v_name);
if (c_count > 0)
{
string carmodel = cb_prefer_car_model.SelectedValue.ToString();
if (carmodel == ds_v_name.Tables[0].Rows[0][\"v_name\"].ToString())
{
groupBox2.Visible = true;
txt_vehicle_name.Text = ds_v_name.Tables[0].Rows[0][\"v_manu_name\"].ToString();
txt_vehicle_model.Text = ds_v_name.Tables[0].Rows[0][\"v_model\"].ToString();
txt_vehicle_manu_year.Text = ds_v_name.Tables[0].Rows[0][\"v_manu_year\"].ToString();
txt_vehicle_cost.Text = ds_v_name.Tables[0].Rows[0][\"v_price\"].ToString();
}
}
}
private void btn_customer_delete_Click(object sender, EventArgs e)
{
query = \"Delete Customer where c_id=\'\" + txt_customerid.Text + \"\'\";
cmd = new SqlCommand(query, con);
con.Open();
int n_del = cmd.ExecuteNonQuery();
if (n_del > 0)
{
MessageBox.Show(\"Delete Successfully...\");
con.Close();
}
}
private void btn_customer_adddetails_Click(object sender, EventArgs e)
{
string gender;
if(rb_Female.Checked==true)
{
gender=rb_Female.Text;
}
else{
gender=rb_Male.Text;
}
query = \"Insert into Customer(c_id, c_name, c_gender, c_date, c_month, c_year, c_address, c_phone, c_prefer_car_model) values(\'\" + txt_customerid.Text + \"\', \'\" + txt_customername.Text + \"\', \'\" + gender + \"\', \'\" + cb_date.Text + \"\',\'\" + cb_month.Text + \"\', \'\" + cb_year.Text + \"\', \'\" + txt_customer_address.Text + \"\', \'\" + txt_customer_phone.Text + \"\', \'\" + cb_prefer_car_model.Text + \"\')\";
cmd = new SqlCommand(query, con);
con.Open();
int cust_count = cmd.ExecuteNonQuery();
if (cust_count > 0)
{
MessageBox.Show(\"Insert Successfully...\");
con.Close();
}
}
private void btn_customer_update_Click(object sender, EventArgs e)
{
string gender;
if(rb_Female.Checked==true)
{
gender=rb_Female.Text;
}
else{
gender=rb_Male.Text;
}
query = \"Update Customer set c_name=\'\" + txt_customername.Text + \"\', c_gender=\'\" + gender + \"\', c_date=\'\" + cb_date.Text + \"\', c_month=\'\" + cb_month.Text + \"\', c_year=\'\" + cb_year.Text + \"\', c_address=\'\" + txt_customer_address.Text + \"\', c_phone=\'\" + txt_customer_phone.Text + \"\', c_prefer_car_model=\'\" + cb_prefer_car_model.Text + \"\' where c_id=\'\" + txt_customerid.Text + \"\'\";
cmd = new SqlCommand(query, con);
con.Open();
int n_update = cmd.ExecuteNonQuery();
if (n_update > 0)
{
MessageBox.Show(\"Updated Successfully...\");
con.Close();
}
}
private void btn_customer_cancel_Click(object sender, EventArgs e)
{
ClearTextbox();
}
private void txt_del_cust_id_TextChanged(object sender, EventArgs e)
{
get_cust_details(txt_del_cust_id.Text);
}
}
}