public static List <vehicle> vehicle()
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["DBconnect"].ConnectionString);
con.Open();
SqlCommand cmd = new SqlCommand("select * from [dbo].[vehicle]", con);
cmd.CommandType = CommandType.Text;
SqlDataReader dr;
dr = cmd.ExecuteReader();
List <vehicle> cmp = new List <vehicle>();
if (dr.HasRows)
{
while (dr.Read())
{
vehicle obj = new vehicle();
if (dr["vehicleNo"] != DBNull.Value)
{
obj.vehicleNo = (dr["vehicleNo"]).ToString();
}
if (dr["name"] != DBNull.Value)
{
obj.name = (dr["name"]).ToString();
}
cmp.Add(obj);
}
}
return(cmp);
}
public static vehicle vehicleInformation(string vehiNo)
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["DBconnect"].ConnectionString);
con.Open();
SqlCommand cmd = new SqlCommand("SELECT dbo.owner.*, dbo.vehicle.* FROM dbo.owner INNER JOIN dbo.vehicle ON dbo.owner.vehicleNo = dbo.vehicle.vehicleNo WHERE dbo.vehicle.vehicleNo = '" + vehiNo + "'", con);
cmd.CommandType = CommandType.Text;
SqlDataReader dr;
dr = cmd.ExecuteReader();
vehicle obj = new vehicle();
if (dr.HasRows)
{
while (dr.Read())
{
if (dr["vehicleNo"] != DBNull.Value)
{
obj.vehicleNo = (dr["vehicleNo"]).ToString();
}
if (dr["name"] != DBNull.Value)
{
obj.name = (dr["name"]).ToString();
}
if (dr["chassiNo"] != DBNull.Value)
{
obj.chassiNo = (dr["chassiNo"]).ToString();
}
if (dr["engineNo"] != DBNull.Value)
{
obj.engNo = (dr["engineNo"]).ToString();
}
if (dr["type"] != DBNull.Value)
{
obj.type = (dr["type"]).ToString();
}
if (dr["brand"] != DBNull.Value)
{
obj.brand = (dr["brand"]).ToString();
}
if (dr["initialPrice"] != DBNull.Value)
{
obj.price = Convert.ToInt32(dr["initialPrice"]);
}
if (dr["revenueDate"] != DBNull.Value)
{
obj.revDate = (dr["revenueDate"]).ToString();
}
if (dr["insuranceDate"] != DBNull.Value)
{
obj.insuDate = (dr["insuranceDate"]).ToString();
}
if (dr["preName"] != DBNull.Value)
{
obj.preName = (dr["preName"]).ToString();
}
if (dr["preAddress"] != DBNull.Value)
{
obj.preAddress = (dr["preAddress"]).ToString();
}
if (dr["preNic"] != DBNull.Value)
{
obj.nic = (dr["preNic"]).ToString();
}
if (dr["preTpno"] != DBNull.Value)
{
obj.tpNo = Convert.ToInt32(dr["preTpno"]);
}
if (dr["buyDate"] != DBNull.Value)
{
obj.buyDate = (dr["buyDate"]).ToString();
}
return(obj);
}
}
return(obj);
}
