Skip to main content

LINQ date range search

Here i just write down the direct code for LINQ date range search

1:  internal List<Book> GetStockInRecord(Book bookObj)  
2:      {  
3:        _dataContextObj = new KARIM_INT_SECURITY_DataClassesDataContext();  
4:        List<Book> bookLsit = new List<Book>();  
5:        foreach (var p in (from j in _dataContextObj.Stock_Ins  
6:                  where j.StockDate >= bookObj.StockFromDate && j.StockDate <= bookObj.StockToDate  
7:                  select j).Distinct())  
8:        {  
9:          Book aBook = new Book();  
10:          aBook.BookId = (int) p.BookId;  
11:          aBook.BookIsbnNo = p.AD_BOOK.Book_BookIsbnNo;  
12:          aBook.BookTitle = p.AD_BOOK.Book_BookTitle;  
13:          aBook.BookAuthorName = p.AD_BOOK.Book_BookAuthor;  
14:          aBook.BookBinding = p.AD_BOOK.Book_BookBinding;  
15:          aBook.BookCategoryName = p.AD_BOOK.Book_BookCategory;  
16:          aBook.BookCurrencyName = p.AD_BOOK.Book_Currency;  
17:          aBook.BookEdition = p.AD_BOOK.Book_BookEdition;  
18:          aBook.BookPrice = (decimal)p.AD_BOOK.Book_BookPrice;  
19:          aBook.BookPublisherName = p.AD_BOOK.Book_BookPublisher;  
20:          aBook.BookYearOfPublication = p.AD_BOOK.Book_BookYearOfPublication;  
21:          bookLsit.Add(aBook);  
22:        }  
23:        return bookLsit;  
24:      }

Labels:

Comments

Post a Comment

Popular posts from this blog

WPF datagrid cell textbox change event

Entity/Class: public class FeesDetails : INotifyPropertyChanged { public int Id { get; set; } public string FeesName { get; set;} public string FeesDetailsName { get; set; } public int? PaidAmount { get; set; } public event PropertyChangedEventHandler PropertyChanged; private void NotifyPropertyChanged(System.String info) { if (PropertyChanged != null) { PropertyChanged(this, new PropertyChangedEventArgs(info)); } } public int feesAmount { get; set; } public int FeesAmount { get { return this.feesAmount; } set { if (value != this.feesAmount) { this.feesAmount = value; NotifyPropertyChanged("FeesAmount"); } } } } XAML: <DataGrid AutoGenerateColumns="False" Height="21...
Post a Comment
Read more

mvc razor textboxfor change event change another textboxfor value

Based on value of Weight, Rate , CNF & AWB it will change the value of Freight , TTLCNF anfd TTLFright . Freight= Weight*Rate; TTLCNF  = Weight*CNF; TTLFright=  Freight+ TTLCNF  + AWB; @Html.TextBoxFor(model => model.Weight, new { onChange="return GetWight(this);"}) @Html.TextBoxFor(model => model.Rate, new { onChange="return GetWight(this);"})/Kg @Html.TextBoxFor(model => model.Freight, new {disabled = "disabled" , @readonly = "readonly" ,onChange="return GetTTLFright(this);"}) @Html.TextBoxFor(model => model.CNFPK, new { onChange="return GetCNFPK(this);"}) @Html.TextBoxFor(model => model.TTLCNF, new {disabled = "disabled" , @readonly = "readonly",onChange="return GetTTLFright(this);" }) @Html.TextBoxFor(model => model.AWB, new { onChange="return GetTTLFright(this);"}) and script <script> function GetW...
Post a Comment
Read more

mvvm double click event in listview

If you want to get the double click event on a listview item you can try with this code; <ListView Grid.Row="0" Grid.RowSpan="3" Grid.Column="0" Width="250" Height="200" HorizontalAlignment="Stretch" VerticalAlignment="Top" AlternationCount="2" BorderBrush="#FFA8CC7B" ItemContainerStyle="{StaticResource alternatingStyle}" ItemsSource="{Binding FromPayerNameList}" SelectedItem="{Binding SelectedFromPayer, Mode=TwoWay}"> <ListView.ItemTemplate> <DataTemplate> <TextBlock Width="{Binding Path=ActualWidth, RelativeSource={RelativeSource FindAncestor, AncestorType={x:Type ListView}}}" Text=...
Post a Comment
Read more