1
Answer

Show items from SelectList with condition

Photo of Guest User

Guest User
3y
436
1
I want to show in the List only the items where "DataSfarsit" < Datetime.Now.
 
How can I do that?
 
 controller: 
  1. [Authorize]  
  2.         public ActionResult Create()  
  3.         {  
  4.             
  5.             ViewBag.IDLicitatie = new SelectList(db.Licitatie, "IDLicitatie", "IDLicitatie").Where(...);  
  6.             ViewBag.IdUser = db.Useri.FirstOrDefault(x => x.Email == User.Identity.Name).IdUser;  
  7.              
  8.             return View();  
  9.         }  
 The model:
 
  1. public partial class Licitatie  
  2.    {  
  3.        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2214:DoNotCallOverridableMethodsInConstructors")]  
  4.        public Licitatie()  
  5.        {  
  6.            this.Oferte = new HashSet<Oferte>();  
  7.             
  8.        }  
  9.      
  10.        public int IDLicitatie { get; set; }  
  11.        public System.DateTime DataPornire { get; set; }  
  12.        public System.DateTime DataIncheiere { get; set; }  
  13.        public decimal PretInitial { get; set; }  
  14.        public int IDProdus { get; set; }  
  15.      
  16.        public virtual Produse Produse { get; set; }  
  17.        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]  
  18.        public virtual ICollection<Oferte> Oferte { get; set; }  
 
So basically I want the  IDLicitate = "4" from there to not appear because it has DataSfarsit < Datetime.now.

Answers (1)

Next Recommended Forum