public async Task <int> AddNewAdvertisement(AdvertisementModel model)
{
var newAdvertisement = new Advertisements()
{
Userid = model.Userid,
Ondisplay = true,
Rental = model.Rental,
PostalCode = model.PostalCode,
ContactPhoneNum = model.ContactPhoneNum,
ContactPerson = model.ContactPerson,
Title = model.Title,
Description = model.Description,
Country = model.Country,
Province = model.Province,
City = model.City,
Streetname = model.Streetname,
Streetnum = model.Streetnum,
Bedroomsnum = model.Bedroomsnum,
Bathroomsnum = model.Bathroomsnum,
Hydro = model.Hydro,
Heat = model.Heat,
Water = model.Water,
Internet = model.Internet,
Parkingnum = model.Parkingnum,
Agreementtype = model.Agreementtype,
Moveindate = model.Moveindate,
Petfriendly = model.Petfriendly,
Size = model.Size,
Furnished = model.Furnished,
Laundry = model.Laundry,
Dishwasher = model.Dishwasher,
Fridge = model.Fridge,
Airconditioning = model.Airconditioning,
Smokingpermit = model.Smokingpermit,
Postdate = DateTime.UtcNow
};
newAdvertisement.AdvertisementGallery = new List <AdvertisementGallery>();
if (model.Gallery != null)
{
foreach (var file in model.Gallery)
{
newAdvertisement.AdvertisementGallery.Add(new AdvertisementGallery()
{
URL = file.URL,
Name = file.Name
});
}
}
await _context.Advertisements.AddAsync(newAdvertisement);
await _context.SaveChangesAsync();
return(newAdvertisement.Adid);
}
public async Task <int> AddStar(int userId, int adId)
{
var star = new StarLists()
{
Userid = userId,
Adid = adId,
Stardate = DateTime.UtcNow
};
await _context.StarLists.AddAsync(star);
var result = await _context.SaveChangesAsync();
return(result);
}
public async Task <int> AddNewCreditCard(CreditCardModel cardModel)
{
var newCard = new CreditCards()
{
Cid = cardModel.Cid,
Userid = cardModel.Userid,
Cardnumber = cardModel.Cardnumber,
Cardtype = cardModel.Cardtype,
Expiremonth = cardModel.Expiremonth,
Expireyear = cardModel.Expireyear,
CardHolderName = cardModel.CardHolderName
};
await _context.CreditCards.AddAsync(newCard);
await _context.SaveChangesAsync();
return(newCard.Cid);
}
public async Task <int> AddContract(int adid, int cid, int tenantId)
{
var query = from c in _context.Advertisements
where c.Adid == adid
select c;
var ad = query.FirstOrDefault <Advertisements>();
var newContract = new Contracts
{
Adid = adid,
CreditCardId = cid,
HouseownerName = ad.ContactPerson,
Tenantid = tenantId,
Startdate = DateTime.UtcNow,
Monthlyrent = ad.Rental
};
await _context.Contracts.AddAsync(newContract);
await _context.SaveChangesAsync();
return(newContract.Adid);
}
