Пример #1
0
        /*****
         *
         * Update the table from paymodels
         *
         * ****/
        public static void writeEventMsg(List<PayModel> paymodels)
        {
            using (var context = new MVCAppEntities())
            {
                // Get the payment rows

                var payment_rows = context.Paymessages;

                /****
                 * Remove previous rows
                 * ***/
                foreach (var row in context.Paymessages)
                {
                    payment_rows.Remove(row);
                }
                /****
                * Add rows from model
                * ***/
                int pk = 1;
                foreach (var model in paymodels)
                {
                    Paymessage new_row = new Paymessage();
                    new_row.id = pk++;
                    new_row.EventId = model.EventId;
                    new_row.state = model.state.ToString();
                    new_row.error = model.errorCode.ToString();
                    context.Paymessages.Add(new_row);
                }
                context.SaveChanges();

            }
        }
Пример #2
0
 /*****
  *
  * Update the state in the table
  * from the send command
  *
  * ****/
 public void changeState(Guid RequestId, StateCodes state)
 {
     using (var context = new MVCAppEntities())
     {
         /****
          * Update the row selected with
          * the new state                 * ***/
         var row = context.Paymessages.Where(x => x.EventId == RequestId).FirstOrDefault();
         if (row != null)
         {
             Paymessage new_row = new Paymessage();
             new_row.error = row.error;
             new_row.EventId = row.EventId;
             new_row.id = row.id;
             new_row.state = state.ToString();
             context.Entry(row).CurrentValues.SetValues(new_row);
             context.SaveChanges();
         }
     }
 }