Skip to main content

C# dynamic linq query

In to Linq query, we can use dynamic query:

  public List<Insplan> GetInsplanLookupList(string planName = null, string binNo = null, string procCtrl = null)  
     {  
       var query = (from i in _db.insplan  
              orderby i.cinsplanname ascending  
              select i).AsQueryable();  
       if (!string.IsNullOrWhiteSpace(planName))  
         query = query.Where(x => x.cinsplanname.StartsWith(planName.Trim()));  
       if (!string.IsNullOrWhiteSpace(binNo))  
         query = query.Where(x => x.cbinno.StartsWith(binNo.Trim()));  
       if (!string.IsNullOrWhiteSpace(procCtrl))  
         query = query.Where(x => x.cprocctrlno.StartsWith(procCtrl.Trim()));  
       return (from q in query  
           join ic in _db.inscomp on q.inscompid_FK equals ic.inscompid_PK into ic_joined  
           from ic in ic_joined.DefaultIfEmpty()  
           join cl in _db.clinic on q.clinicid_FK equals cl.clinicid_PK into cl_joined  
           from cl in cl_joined.DefaultIfEmpty()  
           join b in _db.insbiller on q.insbillerid_FK equals b.insbillerid_PK into gj  
           from sub in gj.DefaultIfEmpty()  
           select new Insplan  
           {  
             insplanid_PK = q.insplanid_PK,  
             cinsplanname = q.cinsplanname,  
             cbinno = q.cbinno,  
             cpharmacyno = q.cpharmacyno,  
             cprocctrlno = q.cprocctrlno,  
             ncpdpversion_FK = q.ncpdpversion_FK,  
             cinscompname = ic.cinscompname,  
             cinsbillername = sub.cinsbillername,  
             Inscomp = (ic != null ? new Inscomp { cinscompname = ic.cinscompname, inscompid_PK = ic.inscompid_PK } : null),  
             Clinic = (cl != null ? new Clinic { clinicid_PK = cl.clinicid_PK, cclinicname = cl.cclinicname } : null)  
           }).Take(20).ToList();  
     }  


Comments

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...

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...

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=...