//CREATE Tanant
public void AddTenant(string guid, string firstname, string lastname, string email, string companyId)
{
try
{
using (var context = new MultiTenantDbEntities())
{
Guid guid_new = Guid.Parse(guid);
Guid guid_company = Guid.Parse(companyId);
context.Tenants.Add(new Tenant()
{
guid = guid_new,
firstname = firstname,
lastname = lastname,
email = email,
LandlordID = guid_company
});
context.SaveChanges();
}
}
catch (Exception)
{
throw;
}
}
//READ property
public List <property> getProperties()
{
using (var context = new MultiTenantDbEntities())
{
var results = from p in context.properties
select p;
return(results.ToList());
}
}
//CREATE landlord
public void AddLandlord(string guid, string firstname, string lastname, string profilePicUrl)
{
using (var context = new MultiTenantDbEntities())
{
Guid guid_new = Guid.Parse(guid);
context.Landlords.Add(new Landlord()
{
guid = guid_new,
firstname = firstname,
lastname = lastname,
profilePicUrl = profilePicUrl
});
context.SaveChanges();
}
}
//CREATE Property
public void AddCompany(string guid, string name, string email)
{
Guid guid_new = Guid.Parse(guid);
using (var context = new MultiTenantDbEntities())
{
context.Companies.Add(new Company()
{
guid = guid_new,
name = name,
email = email
});
context.SaveChanges();
}
}
public List <Tenant> GetUser(string email)
{
try
{
using (var context = new MultiTenantDbEntities())
{
var result = from t in context.Tenants
where t.email == email
select t;
return(result.ToList());
}
}
catch (Exception)
{
throw;
}
}
//CREATE Property
public void AddProperty(string guid, string street, string city, string postcode, string type, int bedrooms, string parking, string pets, string companyId)
{
using (var context = new MultiTenantDbEntities())
{
Guid guid_new = Guid.Parse(guid);
Guid guid_company = Guid.Parse(companyId);
context.properties.Add(new property()
{
guid = guid_new,
street = street,
city = city,
postcode = postcode,
type = type,
bedrooms = bedrooms,
parking = parking,
pets = pets,
companyID = guid_company
});
context.SaveChanges();
}
}
