Zbiór zmian 970 dla trunk/eCard/eCardMVC/adMoto.Payments.Core/Data/DataContext.cs
- Data:
- 2009-12-23 11:26:06 (16 years ago)
- Lokalizacja:
- trunk/eCard/eCardMVC/adMoto.Payments.Core
- Pliki:
-
- 2 dodane
- 1 skopiowane
-
. (dodane)
-
Data (dodane)
-
Data/DataContext.cs (skopiowane) (skopiowane from trunk/eCard/eCardMVC/Platnosci.Core/Linq/DataContext.cs) (5 diffs)
Legenda:
- Bez zmian
- Dodane
- Usunięte
-
trunk/eCard/eCardMVC/adMoto.Payments.Core/Data/DataContext.cs
r954 r970 3 3 using System.Configuration; 4 4 using System.Linq; 5 using Platnosci.Core.Interface;5 using adMoto.Payments.Core.Interfaces; 6 6 7 namespace Platnosci.Core.Linq7 namespace adMoto.Payments.Core.Data 8 8 { 9 9 public class DataContext : IDataContext … … 44 44 } 45 45 46 public IQueryable< vPlatnosciEcard> FindInvoiceByNipNumber(string nip, string numer)46 public IQueryable<Invoice> FindInvoiceByNipNumber(string nip, string numer) 47 47 { 48 var query = from i in _dataContext. vPlatnosciEcards48 var query = from i in _dataContext.Invoices 49 49 where (i.nip == nip && i.Faktura_Numer == numer) 50 50 select i; … … 52 52 } 53 53 54 public IQueryable< vPlatnosciEcard> FindInvoiceById(int id)54 public IQueryable<Invoice> FindInvoiceById(int id) 55 55 { 56 var query = from i in _dataContext. vPlatnosciEcards56 var query = from i in _dataContext.Invoices 57 57 where i.ID_faktury == id 58 58 select i; … … 63 63 { 64 64 var query = _dataContext.PlatnosciEcards 65 .Where(vp => vp.IDFaktury == idFaktury && vp.Status == true)66 .OrderByDescending(vp => vp.IDFaktury);65 .Where(vp => vp.IDFaktury == idFaktury && vp.Status == true) 66 .OrderByDescending(vp => vp.IDFaktury); 67 67 68 68 query.ToList(); … … 74 74 var ecard = pt; 75 75 var query2 = _dataContext.PotwierdzeniaEcards 76 .Where(ps => ps.ORDERNUMBER == ecard.ORDERNUMBER && ps.CURRENTSTATE == "payment_deposited")77 .OrderBy(ps => ps.id);76 .Where(ps => ps.ORDERNUMBER == ecard.ORDERNUMBER && ps.CURRENTSTATE == "payment_deposited") 77 .OrderBy(ps => ps.id); 78 78 79 79 for (var i = 0; i < query2.ToList().Count; i++)
