public static int Create(ListingCreateRequest model)
{
int id;
string connectionString = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
using (SqlConnection connection = new SqlConnection(connectionString))
{
using (SqlCommand command = new SqlCommand("dbo.Listing_Insert", connection))
{
command.CommandType = System.Data.CommandType.StoredProcedure;
SqlParameterCollection parameterCollection = command.Parameters;
parameterCollection.AddWithValue("@ManagerID", model.ManagerID);
parameterCollection.AddWithValue("@City", model.City);
parameterCollection.AddWithValue("@State", model.State);
parameterCollection.AddWithValue("@Role", model.Role);
parameterCollection.AddWithValue("@Description", model.Description);
parameterCollection.AddWithValue("@VideoIsEnabled", model.VideoIsEnabled);
parameterCollection.AddWithValue("@VideoPrompt", model.VideoPrompt);
SqlParameter idParameter = new SqlParameter("@ListingID", SqlDbType.Int);
idParameter.Direction = ParameterDirection.Output;
parameterCollection.Add(idParameter);
connection.Open();
command.ExecuteNonQuery();
int.TryParse(idParameter.Value.ToString(), out id);
}
}
return(id);
}
public HttpResponseMessage Create(ListingCreateRequest model)
{
ItemResponse <int> resp = new ItemResponse <int>();
int insertedId = ListingsService.Create(model);
resp.Item = insertedId;
return(Request.CreateResponse(HttpStatusCode.OK, resp));
}
public async Task <IActionResult> Create([FromForm] ListingCreateRequest request)
{
var user = HttpContext.Session.GetComplexData <UserVm>("User");
if (!ModelState.IsValid)
{
return(RedirectToAction("Index", "Listing"));
}
request.CreateBy = user.UserName;
request.ModifiedBy = user.UserName;
var result = await _listingsController.CreateListing(request);
return(View());
}
public async Task <int> CreateListingAsync(ListingCreateRequest request)
{
User user = await _repository.UserRepo.FindByCondition(x => x.UserName == request.CreateBy)
.SingleOrDefaultAsync();
Listing listing = _mapper.Map <Listing>(request);
listing.CreateDate = DateTime.Now;
listing.ModifiedDate = DateTime.Now;
listing.ListingNotes = new List <ListingNote>()
{
new ListingNote()
{
UserId = user.Id,
Text = request.ListingNote
}
};
if (request.ThumbnailImage != null)
{
listing.ListingPhotos = new List <ListingPhoto>()
{
new ListingPhoto()
{
PhotoUrl = await SaveFile(request.ThumbnailImage),
IsDefault = true
}
};
}
await _repository.ListingRepo.CreateAsync(listing);
await _repository.SaveChangesAsync();
return(listing.Id);
}
public async Task <int> CreateListing([FromForm] ListingCreateRequest request)
{
var result = await _listingService.CreateListingAsync(request);
return(result);
}
