Vehicle Management system.pdf (Team Project - not more than 2-3 students per tea

Question

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

Explanation / Answer

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);
}
}
}

Related Questions

Navigate

• Browse (All)
• Browse V
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.