public Quotation Insert(Quotation q)
{
SqlCommand cmd = dbc.getSqlCommand("AddQuotation");
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter p1 = cmd.Parameters.AddWithValue("@v_type", q.VehicleType);
SqlParameter p2 = cmd.Parameters.AddWithValue("@brand", q.Brand);
SqlParameter p3 = cmd.Parameters.AddWithValue("@model", q.Model);
SqlParameter p4 = cmd.Parameters.AddWithValue("@price", q.Price);
SqlParameter returnParam = new SqlParameter();
returnParam.Value = ParameterDirection.ReturnValue;
dbc.con.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
q.Qid = Convert.ToInt32(reader.GetValue(0));
q.Premium = Convert.ToDouble(reader.GetValue(1));
q.Cover = Convert.ToDouble(reader.GetValue(2));
}
return(q);
}