Many to Many Table Controller Create

Guest User

I have a project for school to make an auction website.

I made it in ASP.NET MVC database first (with edmx things)

So i have in my project 3 tables + some others:

Auctions
Users
Users_Offers with : IdUsersOffers, AmountBid, DateBid, IdUser, IdAuction

That's the auction Page .

How can i write the controller for User_Offers to add bid for the current auction but to have DateBid = Datetime.Now; , IdAuction = current auction ; IdUser = User.identity.getuserid() when i pressed the "Bid Now", and only to write the amount that i want to bid in the input shown there?

I don't mind if when I press the "Bid Now" to redirect me to another page like this:

But i want the informations from the previous page (IdAuction) to be saved

I tried to make it automatically with entity framework but the result was giving me a list with all auctions and all users and I want only the current auction and current user authenticated.

5 Replies

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

Mario Scheeren5y ago
Accepted answer
Ok...

So in your AJAX Request you POST ValoareBid
So Your Controller MEthod has to be like this:

[HttpPost]
public ActionResult WhatEverName([FromBody] decimal ValoareBid)
{
var ofr= new Oferte
{
ValoareBid = ValoareBid
};
// the other Values, you either pass on also ...
// or if already known, save in a Session and then use their vaues to fill the Oferte-Object
// Now add the Object to your Context and Save it ...
}

BTW: do not use Pictures for posting code, so someone can Copy and edit in place ... use PasteBin or things like that ;)
+3
Guest User5y ago
Yea, I have another problem. The authentication I make it with Forms Authentication and for that I created a new class "Utilizatori"... and the Id from "Utilizatori" != IdUseri... I don't know how to store in session the IdUser.

Authentication part:
public ActionResult Autentificare()
{
return View("Autentificare", new Utilizatori());
}
[HttpPost]
public ActionResult Autentificare(Utilizatori model)
{
using (var context = new Entities())
{
bool Validare = context.Useri.Any(a => a.Email == model.Email && a.Parola == model.Parola);
if (Validare)
{
FormsAuthentication.SetAuthCookie(model.Email, false);
//Session["Cont"] = ;
return RedirectToAction("Index", "Licitaties");
}
ModelState.AddModelError("", "Date incorecte");
return View();
}
}
public ActionResult Delogare()
{
FormsAuthentication.SignOut();
return RedirectToAction("Autentificare");
}
Registration part:
public ActionResult Inregistrare()
{
return View("Inregistrare", new Useri());
}
[HttpPost]
public ActionResult Inregistrare(Useri model)
{ using ( var context = new Entities())
{
if (ModelState.IsValid)
{
if (context.Useri.Any(x => x.Email == model.Email))
{ ViewBag.Notification = "Exista deja un cont cu aceasta adresa de email.";
return View();
}
else
{
context.Useri.Add(model);
context.SaveChanges();
return RedirectToAction("Autentificare");
}
}
}
return View();
+1
Guest User5y ago
What I've done so far was this, to add these methods in the AuctionController, with sql commands and Ajax post, but it didn't worked.

Another thing that I tried was to make a special controller for User Offers, but I don't know how to implement in the auction page.

Note: IDLicitatie = IDAuction, but in my language and ValoareBid=AmountBid .
I didn't write there the DateBid as well cause I selected a default value for it in sql server (GetDate()). I don't know if it's ok or not, but all the attempts didn't worked.
+2
Guest User5y ago
Yes, I'm having trouble writing the POST Method, and adding a new row to Database at the same time, i think.

What I want is when I press the "Bid Now" button to refresh the page and send to database the informations provided.

For example:
1)IDAuction
2)IDUser which can be User.Identity.Name, I think. I tried with User.Identity.GetUserId() but it returned null value.
3)BidAmount = Amount that i write in the input
4)DateBid = Datetime.Now()
Note: the values from the table with bidders and amount bid and date was manually added in sql server. I wanted to see if it's showing.
+2
Mario Scheeren5y ago
I do not quiet understand what the real problem is?
Are you having trouble to write the POST Method? Or is it the Adding New Row to DB? Or is it the Definition of the missing Table with N:M relations?

public class Offer
{
   public int OfferID {get;set;}
   public int AuctionID {get;set;}
   public int UserID {get;set;}
   public decimal BidAmount {get;set;}
}
//Adding
using (EFContext db = new EFContext())
{
    Offer off = new Offer();
    off.AuctionID = 7;
    off.UserID = 4;
    off.BidAmount = 123.45;

    db.Offers.Add(off);               //Add it to the Context

    db.SaveChanges();                      //Call Save Changes
}
+2