Compare in a single controller two models

Guest User

Hello, I have to make an auction website and in Users_Offers I need to make sure that they don't bid less that "Start Price" from Auctions

This is the controller , but when I run the application the "oferte.Licitatie.PretInitial " ( which is Auction.StartPrice ) is null and I get an error "Object reference not set to an instance of an object." I tried to write it like : db.Auction. but then StartPrice doesn't appear anymore.

public ActionResult Create([Bind(Include = "Oferteid,IDLicitatie,IdUser,ValoareBid,DataBid")] Oferte oferte)
{
if (ModelState.IsValid)
{ if (oferte.Licitatie.PretInitial < oferte.ValoareBid)
{
db.Oferte.Add(oferte);
db.SaveChanges();
return RedirectToAction("Index", "Licitaties");
}
else { ViewBag.notificare = "Trebuie o suma mai mare decat pretul initial"; }
}
ViewBag.IDLicitatie = new SelectList(db.Licitatie, "IDLicitatie", "IDLicitatie", oferte.IDLicitatie);
ViewBag.IdUser = db.Useri.FirstOrDefault(x => x.Email == User.Identity.Name).IdUser;
return View(oferte);

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rijwan Ansari5y ago
Accepted answer
Hi

I could not understand model relation completely but if they are two different models then you can something like this:
public ActionResult Create([Bind(Include = "Oferteid,IDLicitatie,IdUser,ValoareBid,DataBid")] Oferte oferte)
        {

            if (ModelState.IsValid)
            {
             var modelTwoProce = db.ModelTwos.WhereIx=>x.CarName = Oferte.CarNameColumn).FirstOrDefault(); /// keep model name and where condition based on your model and column
             if (modelTwoProce.PretInitial < oferte.ValoareBid)
                {
                    db.Oferte.Add(oferte);
                    db.SaveChanges();
                    return RedirectToAction("Index", "Licitaties");
                }
                else { ViewBag.notificare = "Trebuie o suma mai mare decat pretul initial"; }

            }

            ViewBag.IDLicitatie = new SelectList(db.Licitatie, "IDLicitatie", "IDLicitatie", oferte.IDLicitatie);
            ViewBag.IdUser = db.Useri.FirstOrDefault(x => x.Email == User.Identity.Name).IdUser;
            return View(oferte);
Or you can share the both models, I will try to give the exact action method.
+1
Guest User5y ago
It worked, don't mind the last comment. Thank you
0
Guest User5y ago
1. public partial class Oferte
2. {
3. public int Oferteid { get; set; }
4. public Nullable<int> IDLicitatie { get; set; }
5. public Nullable<int> IdUser { get; set; }
6. public Nullable<int> ValoareBid { get; set; }
7. public Nullable DataBid { get; set; }
9. public virtual Licitatie Licitatie { get; set; }
10. public virtual Useri Useri { get; set; }
12. public Oferte() {
13. DataBid = DateTime.Now;
15. }
17. }
Yes, sure. Thank you for your answer . Those are the 2 models :
public Licitatie()
    {
        this.Oferte = new HashSet();
    }

    public int IDLicitatie { get; set; }
    public System.DateTime DataPornire { get; set; }
    public System.DateTime DataIncheiere { get; set; }
    public decimal PretInitial { get; set; }
    public int IDProdus { get; set; }

    public virtual Produse Produse { get; set; }
    [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
    public virtual ICollection Oferte { get; set; }
}
And this one:
public partial class Oferte
   {
       public int Oferteid { get; set; }
       public Nullable<int> IDLicitatie { get; set; }
       public Nullable<int> IdUser { get; set; }
       public Nullable<int> ValoareBid { get; set; }
       public Nullable DataBid { get; set; }

       public virtual Licitatie Licitatie { get; set; }
       public virtual Useri Useri { get; set; }

       public Oferte() {
               DataBid = DateTime.Now;

       }

   }
And I added the model for Users too, I don't think it's necessary but it's a many-to-many relationship between Users and Auction and Oferte = Users_Offers in english.
public Useri()
      {
          this.Oferte = new HashSet();
          this.UseriRol = new HashSet();
      }

      public int IdUser { get; set; }
      [Required(ErrorMessage = "Tastati un nume")]
      public string Nume { get; set; }
      [Required(ErrorMessage = "Tastati o adresa de mail")]
      [EmailAddress(ErrorMessage = "Scrieti o adresa de mail valida.")]
      public string Email { get; set; }
      [Required]
      [RegularExpression(@"^(?$)?0(?:(?:72|74|75|76|77|78)(?(paren)$)(?\d)(?!\k{6})\d{6}|(?:251|351)(?(paren)\))(?\d)(?!\k{5})\d{5})$")]
      public string Telefon { get; set; }
      [Required(ErrorMessage = "Tastati o parola")]
      public string Parola { get; set; }

      [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
      public virtual ICollection Oferte { get; set; }
      [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
      public virtual ICollection UseriRol { get; set; }
0