public int Create(ListingCreate request)
{
using (var con = GetConnection())
{
var cmd = con.CreateCommand();
cmd.CommandText = "Listing_Create";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Id", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.AddWithValue("@appUserId", request.AppUserId);
cmd.Parameters.AddWithValue("@listingUrl", request.ListingUrl);
cmd.Parameters.AddWithValue("@imageUrl", request.ImageUrl);
cmd.Parameters.AddWithValue("@title", request.Title);
cmd.Parameters.AddWithValue("@sellerId", request.SellerId);
cmd.Parameters.AddWithValue("@price", request.Price);
cmd.Parameters.AddWithValue("@status", request.Status);
cmd.Parameters.AddWithValue("@history", request.History);
cmd.Parameters.AddWithValue("@liveDead", request.LiveDead);
cmd.ExecuteNonQuery();
return((int)cmd.Parameters["@Id"].Value);
}
}
public async Task <IHttpActionResult> PostListing(ListingCreate model)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var identity = User.Identity as ClaimsIdentity;
Claim identityClaim = identity.Claims.FirstOrDefault(c => c.Type == ClaimTypes.NameIdentifier);
ApplicationUser user = db.Users.FirstOrDefault(u => u.Id == identityClaim.Value);
Listing listing = new Listing()
{
AvisUtil = model.AvisUtil, Visionnage = model.Visionnage
};
listing.Film = await db.Film.FindAsync(model.FilmId);
listing.User = user;
db.Listing.Add(listing);
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateException)
{
if (ListingExists(listing.ListingId))
{
return(Conflict());
}
else
{
throw;
}
}
return(Created("api/Listings", listing));
}
public int Create(ListingCreate model)
{
return(listingService.Create(model));
}
