예제 #1
0
 public List <PrevRateDM> Read(SqlParameter[] parameters, string statement)
 {
     using (SqlConnection connection = new SqlConnection(connectionString))
     {
         using (SqlCommand command = new SqlCommand(statement, connection))
         {
             command.CommandType = CommandType.StoredProcedure;
             if (parameters != null)
             {
                 command.Parameters.AddRange(parameters);
             }
             connection.Open();
             SqlDataReader     data  = command.ExecuteReader();
             List <PrevRateDM> prevs = new List <PrevRateDM>();
             while (data.Read())
             {
                 PrevRateDM prev = new PrevRateDM();
                 prev.QuoteId = data["QuoteId"].ToString();
                 prev.SeqNum  = data["SeqNum"].ToString();
                 prev.UserId  = data["UserId"].ToString();
                 prevs.Add(prev);
             }
             return(prevs);
         }
     }
 }
예제 #2
0
 public void AddPrevRate(PrevRateDM PrevRate)
 {
     SqlParameter[] parameters = new SqlParameter[] {
         new SqlParameter("@QuoteId", PrevRate.QuoteId)
         , new SqlParameter("@SeqNum", PrevRate.SeqNum)
         , new SqlParameter("@UserId", PrevRate.UserId)
     };
     dataWriter.Write(parameters, "AddPrevRate");
     logs.LogError("Event", "An PrevRate has been added to the database", "Class:PrevRateDAO, Method:AddPrevRate");
 }