Zbiór zmian 842 dla trunk/Wierszowki/Wierszowki.Model
- Data:
- 2009-10-02 13:15:40 (17 years ago)
- Lokalizacja:
- trunk/Wierszowki/Wierszowki.Model
- Pliki:
-
- 2 dodane
- 4 zmodyfikowane
-
Linq/Author.cs (zmodyfikowane) (1 diff)
-
Linq/Info.cs (dodane)
-
Linq/UpdateData.cs (dodane)
-
Linq/User.cs (zmodyfikowane) (1 diff)
-
Linq/WierszowkiDataContext.cs (zmodyfikowane) (4 diffs)
-
Wierszowki.Core.csproj (zmodyfikowane) (2 diffs)
Legenda:
- Bez zmian
- Dodane
- Usunięte
-
trunk/Wierszowki/Wierszowki.Model/Linq/Author.cs
r752 r842 8 8 public partial class Author : AuthorValidation, IIdentifiable 9 9 { 10 public string FullName { get { return FirstName + " " + LastName; } }10 public string FullName { get { return LastName + " " + FirstName; } } 11 11 } 12 12 } -
trunk/Wierszowki/Wierszowki.Model/Linq/User.cs
r823 r842 8 8 public partial class User : UserValidation, IIdentifiable 9 9 { 10 public string FullName { get { return FirstName + " " + LastName; } }10 public string FullName { get { return LastName + " " + FirstName; } } 11 11 } 12 12 } -
trunk/Wierszowki/Wierszowki.Model/Linq/WierszowkiDataContext.cs
r814 r842 9 9 public Author GetAuthorById(int id) 10 10 { 11 return Authors.Single (a => a.Id == id);11 return Authors.SingleOrDefault(a => a.Id == id); 12 12 } 13 13 … … 23 23 return Users.ToList(); 24 24 } 25 public List<Issue> GetIssue() 26 { 27 return Issues.ToList(); 28 } 25 29 26 30 public User GetUserById(int id) 27 31 { 28 return Users.Single (u => u.Id == id);32 return Users.SingleOrDefault(u => u.Id == id); 29 33 } 30 34 31 35 public User GetUserByLogin(string login) 32 36 { 33 return Users.Single (u => u.Login == login);37 return Users.SingleOrDefault(u => u.Login == login); 34 38 } 35 39 … … 58 62 } 59 63 60 public IQueryable<Issue> FindIssuesByMagazineId(int magazineId )64 public IQueryable<Issue> FindIssuesByMagazineId(int magazineId, int addId) 61 65 { 62 66 var startDate = DateTime.Now.AddMonths(-3); 63 67 var endDate = DateTime.Now.AddMonths(1); 64 65 var query = from i in Issues 66 where i.MagazineId == magazineId 67 && i.Date >= startDate 68 && i.Date <= endDate 69 select i; 70 return query; 68 if (addId != 0) 69 { 70 var query = from i in Issues 71 where (i.Id == addId) || 72 (i.MagazineId == magazineId && i.Date >= startDate && i.Date <= endDate ) 73 select i; 74 return query; 75 } 76 else 77 { 78 var query = from i in Issues 79 where i.MagazineId == magazineId 80 && i.Date >= startDate 81 && i.Date <= endDate 82 select i; 83 return query; 84 } 71 85 } 72 86 73 public IQueryable<Issue> FindIssuesByMagazineItemId(int issueId )87 public IQueryable<Issue> FindIssuesByMagazineItemId(int issueId, int addId) 74 88 { 75 89 var issue = Issues.Single(i => i.Id == issueId); 76 return FindIssuesByMagazineId(issue.MagazineId );90 return FindIssuesByMagazineId(issue.MagazineId, addId); 77 91 } 78 92 … … 151 165 InsertUser(user); 152 166 } 167 153 168 } 154 169 } -
trunk/Wierszowki/Wierszowki.Model/Wierszowki.Core.csproj
r752 r842 61 61 <Compile Include="Interfaces\IUserRepository.cs" /> 62 62 <Compile Include="Linq\Author.cs" /> 63 <Compile Include="Linq\Info.cs" /> 63 64 <Compile Include="Linq\Issue.cs" /> 64 65 <Compile Include="Linq\LinqRepository.cs" /> 65 66 <Compile Include="Linq\MagazineItem.cs" /> 66 67 <Compile Include="Linq\Report.cs" /> 68 <Compile Include="Linq\UpdateData.cs" /> 67 69 <Compile Include="Linq\User.cs" /> 68 70 <Compile Include="Linq\Wierszowki.cs"> … … 81 83 <DependentUpon>Settings.settings</DependentUpon> 82 84 </Compile> 83 <Compile Include=" Validation\AuthorValidation.cs" />84 <Compile Include=" Validation\MagazineItemValidation.cs" />85 <Compile Include=" Validation\UserValidation.cs" />85 <Compile Include="Linq\Validation\AuthorValidation.cs" /> 86 <Compile Include="Linq\Validation\MagazineItemValidation.cs" /> 87 <Compile Include="Linq\Validation\UserValidation.cs" /> 86 88 </ItemGroup> 87 89 <ItemGroup>
