public async Task <UserListings> Update(UserListings userListings, string ownerId) { try { using (ApiMohoContext context = new ApiMohoContext()) { var userListing = await context.UserListings.SingleAsync(id => id.UserListingId == userListings.UserListingId && id.OwnerId == ownerId); userListing.CityRefId = userListings.CityRefId; userListing.ListingTypeRefId = userListings.ListingTypeRefId; userListing.CountryRefId = userListings.CountryRefId; userListing.ProvinceRefId = userListings.ProvinceRefId; userListing.ListingName = userListings.ListingName; userListing.CountryName = userListings.CountryName; userListing.ProvinceName = userListings.ProvinceName; userListing.CityName = userListings.CityName; userListing.LastUpdatedDate = DateTime.Now; userListing.ListingDescription = userListings.ListingDescription; userListing.ListingTitle = userListings.ListingTitle; userListing.PhoneNumber = userListings.PhoneNumber; userListing.Email = userListings.Email; userListing.FullName = userListings.FullName; userListing.Address = userListings.Address; await context.SaveChangesAsync(); return(userListing); } } catch (Exception ex) { _logger.LogError($"error while updateing listing from database: {ex}"); throw ex.GetBaseException(); } }
public async Task <UserListingDto> AddListingCommand(AddListingDto addListingDto, string UserFullName, string UserId) { try { var listing = new UserListings { CountryRefId = (int)addListingDto.ListingCountry, ProvinceRefId = (int)addListingDto.ListingProvince, CityRefId = (int)addListingDto.ListingCity, ListingTypeRefId = (int)addListingDto.ListingType, CountryName = EnumHelper.GetCountryEnumString((int)addListingDto.ListingCountry), ProvinceName = EnumHelper.GetProvinceEnumString((int)addListingDto.ListingProvince), CityName = EnumHelper.GetCityEnumString((int)addListingDto.ListingCity), ListingName = EnumHelper.GetListingEnumString((int)addListingDto.ListingType), ListingDescription = addListingDto.ListingDescription, ListingTitle = addListingDto.ListingTitle, Address = addListingDto.Address, Email = addListingDto.Email, PhoneNumber = addListingDto.PhoneNumber, FullName = addListingDto.FullName, OwnerId = UserId, ListingDate = DateTime.Now, LastUpdatedDate = DateTime.Now }; var addListing = await _listingRepository.AddListing(listing); var newListing = new UserListingDto { Address = addListing.Address, City = EnumHelper.GetCityEnumString((int)addListing.CityRefId), Country = EnumHelper.GetCountryEnumString((int)addListing.CountryRefId), Province = EnumHelper.GetProvinceEnumString((int)addListing.ProvinceRefId), Email = addListing.Email, FullName = addListing.FullName, PhoneNumber = addListing.PhoneNumber, LastUpdatedDate = addListing.LastUpdatedDate, ListingDate = addListing.ListingDate, ListingDescription = addListing.ListingDescription, ListingTitle = addListing.ListingTitle, ListingType = EnumHelper.GetListingEnumString((int)addListing.ListingTypeRefId), UserListingId = addListing.UserListingId, OwnerId = addListing.OwnerId, ListingEnabled = addListing.ListingEnabled }; return(newListing); } catch (Exception ex) { throw ex.InnerException; } }
public async Task <UserListingDto> UpdateListing(UpdateListingRequest updateListingRequest, string userId) { try { var listing = new UserListings { UserListingId = updateListingRequest.UserListingId, CountryName = updateListingRequest.ListingCountry, ProvinceName = updateListingRequest.ListingProvince, CityName = updateListingRequest.ListingCity, ListingName = updateListingRequest.ListingType, ListingDescription = updateListingRequest.ListingDescription, ListingTitle = updateListingRequest.ListingTitle, Address = updateListingRequest.Address, Email = updateListingRequest.Email, PhoneNumber = updateListingRequest.PhoneNumber, FullName = updateListingRequest.FullName, OwnerId = updateListingRequest.OwnerId, LastUpdatedDate = DateTime.Now, CityRefId = EnumHelper.GetCityEnumInt(updateListingRequest.ListingCity), CountryRefId = EnumHelper.GetCountryEnumInt(updateListingRequest.ListingCountry), ProvinceRefId = EnumHelper.GetProvinceEnumInt(updateListingRequest.ListingProvince), ListingTypeRefId = EnumHelper.GetListingEnumInt(updateListingRequest.ListingType), }; var addListing = await _listingRepository.Update(listing, userId); var newListing = new UserListingDto { Address = addListing.Address, City = EnumHelper.GetCityEnumString((int)addListing.CityRefId), Country = EnumHelper.GetCountryEnumString((int)addListing.CountryRefId), Province = EnumHelper.GetProvinceEnumString((int)addListing.ProvinceRefId), Email = addListing.Email, FullName = addListing.FullName, LastUpdatedDate = addListing.LastUpdatedDate, ListingDate = addListing.ListingDate, ListingDescription = addListing.ListingDescription, ListingTitle = addListing.ListingTitle, PhoneNumber = addListing.PhoneNumber, ListingType = EnumHelper.GetListingEnumString((int)addListing.ListingTypeRefId), UserListingId = addListing.UserListingId, OwnerId = addListing.OwnerId }; return(newListing); } catch (Exception ex) { throw ex.InnerException; } }
protected void Page_Load(object sender, EventArgs e) { string ConString = ConfigurationManager.ConnectionStrings["info451"].ConnectionString; using (SqlConnection con = new SqlConnection(ConString)) { using (var cmd = new SqlCommand("Select * from Inventory where UserID = @UserId", con)) { cmd.Parameters.AddWithValue("@Userid", (string)Session["Username"]); con.Open(); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); UserListings.DataSource = dt; UserListings.DataBind(); } } }
public async Task <UserListings> AddListing(UserListings userListings) { try { using (ApiMohoContext context = new ApiMohoContext()) { var result = await context.UserListings.AddAsync(userListings); await context.SaveChangesAsync(); var userlisting = result.Entity; return(userlisting); } } catch (Exception ex) { throw ex.InnerException; } }