public int Insert(Quotation q)
        {
            SqlConnection con = new SqlConnection("server=SREERAJ-PC;integrated security=true;database=obs");
            SqlCommand cmd = new SqlCommand("Add_Quotation", con);
            cmd.CommandType = CommandType.StoredProcedure;
            SqlParameter p1 = cmd.Parameters.AddWithValue("@CRN", q.Crn);
            SqlParameter p2 = cmd.Parameters.AddWithValue("@v_type", q.VehicleType);
            SqlParameter p3 = cmd.Parameters.AddWithValue("@brand", q.Brand);
            SqlParameter p4 = cmd.Parameters.AddWithValue("@model", q.Model);
            SqlParameter p5 = cmd.Parameters.AddWithValue("@chassiss_no", q.ChassissNo);
            SqlParameter p6 = cmd.Parameters.AddWithValue("@engine_no", q.EngineNo);
            SqlParameter p7 = cmd.Parameters.AddWithValue("@exshowroom_price", q.Price);

            SqlParameter returnParam = new SqlParameter();
            returnParam.Value = ParameterDirection.ReturnValue;
            con.Open();
            cmd.ExecuteNonQuery();
            return Convert.ToInt32(returnParam.Value);
        }
 public int Insert(Quotation q)
 {
     DALInsurance insurance = new DALInsurance();
     return insurance.Insert(q);
 }
 public Quotation Insert(Quotation q)
 {
     return dal.Insert(q);
 }