public Insurance Clone()
 {
     Insurance result = new Insurance();
     result.InsuranceID = this.InsuranceID;
     result.Name = this.Name;
     result.InsuranceCode = this.InsuranceCode;
     result.Description = this.Description;
     result.PayerTypeID = this.PayerTypeID;
     result.InsertJobID = this.InsertJobID;
     result.UpdateJobID = this.UpdateJobID;
     return result;
 }
 public void Execute(ref Insurance insurance)
 {
     Parameters.AddWithValue("@InsertJobID", insurance.InsertJobID);
     Parameters.AddWithValue("@InsuranceCode", string.Empty);
     Parameters.AddWithValue("@InsuranceName", insurance.Name);
     Parameters.AddWithValue("@PayerTypeID", insurance.PayerTypeID);
     DataTable t = ExecuteReader();
     if (t.Rows.Count > 0)
     {
         insurance.InsuranceID = t.Rows[0].Field<int>(0);
     }
 }
 public void InsuranceSave(ref Insurance ins)
 {
     spAddInsurance proc = new spAddInsurance(ConnectionString);
     proc.Execute(ref ins);
 }