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;
}
}
