public void DeleteVehicle(vehicles vehicle)
{
string connectionString = ConfigurationManager.ConnectionStrings["DBcon"].ConnectionString;
using (SqlConnection con = new SqlConnection(connectionString))
{
string query = "DELETE vehicles WHERE vehicleID=@vehicleID";
SqlCommand cmd = new SqlCommand(query, con);
SqlParameter paramvehicleID = new SqlParameter();
paramvehicleID.ParameterName = "@vehicleID";
paramvehicleID.Value = vehicle.vehicleID;
cmd.Parameters.Add(paramvehicleID);
con.Open();
cmd.ExecuteNonQuery();
}
}
public void AddNewVehicle(vehicles vehicle)
{
string connectionString = ConfigurationManager.ConnectionStrings["DBcon"].ConnectionString;
using (SqlConnection con = new SqlConnection(connectionString))
{
string query = "INSERT vehicles(vehicleNo,capacity,Make,AddedDate,TrashTypeCarried,vehicleStatus)Values(@vehicleNo,@capacity,@Make,@AddedDate,@TrashTypeCarried,@vehicleStatus)";
SqlCommand cmd = new SqlCommand(query, con);
SqlParameter paramvehicleNo = new SqlParameter();
paramvehicleNo.ParameterName = "@vehicleNo";
paramvehicleNo.Value = vehicle.vehicleNo;
cmd.Parameters.Add(paramvehicleNo);
SqlParameter paramcapacity = new SqlParameter();
paramcapacity.ParameterName = "@capacity";
paramcapacity.Value = vehicle.capacity;
cmd.Parameters.Add(paramcapacity);
SqlParameter paramMake = new SqlParameter();
paramMake.ParameterName = "@Make";
paramMake.Value = vehicle.Make;
cmd.Parameters.Add(paramMake);
SqlParameter paramAddedDate = new SqlParameter();
paramAddedDate.ParameterName = "@AddedDate";
paramAddedDate.Value = vehicle.AddedDate;
cmd.Parameters.Add(paramAddedDate);
SqlParameter paramTrashTypeCarried = new SqlParameter();
paramTrashTypeCarried.ParameterName = "@TrashTypeCarried";
paramTrashTypeCarried.Value = vehicle.TrashTypeCarried;
cmd.Parameters.Add(paramTrashTypeCarried);
SqlParameter paramvehicleStatus = new SqlParameter();
paramvehicleStatus.ParameterName = "@vehicleStatus";
paramvehicleStatus.Value = vehicle.vehicleStatus;
cmd.Parameters.Add(paramvehicleStatus);
con.Open();
cmd.ExecuteNonQuery();
}
}
public void EditVehicleDetails(vehicles vehicle)
{
string connectionString = ConfigurationManager.ConnectionStrings["DBcon"].ConnectionString;
using (SqlConnection con = new SqlConnection(connectionString))
{
string query = "UPDATE vehicles SET vehicleNo=@vehicleNo, capacity=@capacity,Make=@Make,TrashTypeCarried=@TrashTypeCarried WHERE vehicleID=@vehicleID";
SqlCommand cmd = new SqlCommand(query, con);
SqlParameter paramvehicleNo = new SqlParameter();
paramvehicleNo.ParameterName = "@vehicleNo";
paramvehicleNo.Value = vehicle.vehicleNo;
cmd.Parameters.Add(paramvehicleNo);
SqlParameter paramcapacity = new SqlParameter();
paramcapacity.ParameterName = "@capacity";
paramcapacity.Value = vehicle.capacity;
cmd.Parameters.Add(paramcapacity);
SqlParameter paramMake = new SqlParameter();
paramMake.ParameterName = "@Make";
paramMake.Value = vehicle.Make;
cmd.Parameters.Add(paramMake);
SqlParameter paramTrashTypeCarried = new SqlParameter();
paramTrashTypeCarried.ParameterName = "@TrashTypeCarried";
paramTrashTypeCarried.Value = vehicle.TrashTypeCarried;
cmd.Parameters.Add(paramTrashTypeCarried);
SqlParameter paramvehicleID = new SqlParameter();
paramvehicleID.ParameterName = "@vehicleID";
paramvehicleID.Value = vehicle.vehicleID;
cmd.Parameters.Add(paramvehicleID);
con.Open();
cmd.ExecuteNonQuery();
}
}
