Zbiór zmian 918 dla trunk/eCard/eCardMVC/Platnosci.Core/Linq/DataContext1.cs

Data:

2009-12-01 16:03:47 (16 years ago)

Autor:

alina

Opis:

re #215 dodanie metody szukania ordernumber po orderdescription, dacie i id faktury

Pliki:

• trunk/eCard/eCardMVC/Platnosci.Core/Linq/DataContext1.cs (zmodyfikowane) (1 diff)

trunk/eCard/eCardMVC/Platnosci.Core/Linq/DataContext1.cs

@@ -87 +87 @@
                 return query;
             }
+            public int GetOrdernumber(string description, int? idfaktury, DateTime? data)
+            {
+                int ordernumber = 0;
 
+                var query = from l in _dataContext.PlatnosciEcards
+                            where l.ORDERDESCRIPTION == description && l.IDFaktury == idfaktury && l.Data == data
+                            select l;
+                
+                List<PlatnosciEcard> pl = query.ToList();
+                if (pl.Count > 0 && pl[0].ORDERNUMBER > 0) ordernumber = pl[0].ORDERNUMBER;
+                return ordernumber;
+            }
     }
 }