public static void setPublishedProperty(Classes.PropertyDetails pd)
{
DataClasses1DataContext cntx = ToLet.Database.DBConnectionProvider.getDBConnection();
var setproperty = (from p in cntx.Properties
where p.TenantCategory == pd.TenantCategory && p.HomeCategory == pd.HomeCategory && p.Location == pd.Location && p.RoomCount == int.Parse(pd.RoomCount) &&
p.Detailed_Address == pd.DetailedAddress && p.Additional_Comments == pd.AdditionalComment && p.RentRangeId == int.Parse(pd.RentRange)
select p).SingleOrDefault();
string s = setproperty.PropertyStatus;
Property r = new Property();
if (s != null)
{
setproperty.PropertyStatus = "published";
System.Windows.Forms.MessageBox.Show("This is now for ToLet");
}
else
{
}
cntx.SubmitChanges();
}
public static Classes.PropertyDetails getForDurResult(Classes.PropertyDetails pd)
{
DataClasses1DataContext cntx = ToLet.Database.DBConnectionProvider.getDBConnection();
var result = (from p in cntx.Properties
where p.TenantCategory == pd.TenantCategory && p.HomeCategory == pd.HomeCategory && p.Location == pd.Location && p.RoomCount == int.Parse(pd.RoomCount) && p.Duration == pd.Duration && p.PropertyStatus == "published"
select new
{
p.RentRangeId,
}).FirstOrDefault();
try
{
pd.RentRange = result.RentRangeId.ToString();
return(pd);
}
catch (Exception)
{
pd.RentRange = "";
pd.Duration = "";
return(pd);
}
}
public static Classes.PropertyDetails getPublishedPropertyInfo(string home, string tenant, string roomcount, string rent, string loc)
{
DataClasses1DataContext cntx = ToLet.Database.DBConnectionProvider.getDBConnection();
var details = from p in cntx.Properties
where p.HomeCategory == home && p.TenantCategory == tenant && p.RoomCount == int.Parse(roomcount) && p.RentRangeId == int.Parse(rent) && p.Location == loc
select new
{
p.TenantCategory,
p.HomeCategory,
p.Location,
p.RoomCount,
p.Detailed_Address,
p.Additional_Comments,
p.RentRangeId
};
Classes.PropertyDetails pd = new Classes.PropertyDetails();
foreach (var item in details)
{
pd.TenantCategory = item.TenantCategory;
pd.HomeCategory = item.HomeCategory;
pd.Location = item.Location;
pd.RoomCount = item.RoomCount.ToString();
pd.DetailedAddress = item.Detailed_Address;
pd.AdditionalComment = item.Additional_Comments;
pd.RentRange = item.RentRangeId.ToString();
}
return(pd);
}
public static int getRequestedProperty(Classes.PropertyDetails pd)
{
DataClasses1DataContext cntx = ToLet.Database.DBConnectionProvider.getDBConnection();
var info = (from p in cntx.Properties
where p.TenantCategory == pd.TenantCategory && p.HomeCategory == pd.HomeCategory && p.Location == pd.Location && p.RoomCount == int.Parse(pd.RoomCount) &&
p.Detailed_Address == pd.DetailedAddress && p.Additional_Comments == pd.AdditionalComment && p.RentRangeId == int.Parse(pd.RentRange)
select p.PropertyId).SingleOrDefault();
int propertyId = info;
return(propertyId);
}
public static void setInRentProperty(Classes.PropertyDetails pd, MainUI m)
{
DataClasses1DataContext cntx = ToLet.Database.DBConnectionProvider.getDBConnection();
var info = (from p in cntx.Properties
where p.TenantCategory == pd.TenantCategory && p.HomeCategory == pd.HomeCategory && p.Location == pd.Location && p.RoomCount == int.Parse(pd.RoomCount) &&
p.Detailed_Address == pd.DetailedAddress && p.Additional_Comments == pd.AdditionalComment && p.RentRangeId == int.Parse(pd.RentRange)
select p).SingleOrDefault();
info.PropertyStatus = "inrent";
info.Request_for_rent = 0;
cntx.SubmitChanges();
m.GetData();
}
public static List <int> getRequestResult(Classes.PropertyDetails pd)
{
DataClasses1DataContext cntx = ToLet.Database.DBConnectionProvider.getDBConnection();
var propertyId = (from p in cntx.Properties
where p.TenantCategory == pd.TenantCategory && p.HomeCategory == pd.HomeCategory && p.Location == pd.Location && p.RoomCount == int.Parse(pd.RoomCount) &&
p.Detailed_Address == pd.DetailedAddress && p.Additional_Comments == pd.AdditionalComment && p.RentRangeId == int.Parse(pd.RentRange)
select p.PropertyId).SingleOrDefault();
List <int> useridlist = (from r in cntx.Requests
where r.PropertyId == propertyId
select r.UserId).ToList();
return(useridlist);
}
public static void getSearchResult(MainUI m, Classes.PropertyDetails pd)
{
DataClasses1DataContext cntx = ToLet.Database.DBConnectionProvider.getDBConnection();
try
{
string[] numbers = Regex.Split(pd.RentRange, @"\D+");
var details = (from p in cntx.Properties
where p.TenantCategory == pd.TenantCategory && p.HomeCategory == pd.HomeCategory && p.Location == pd.Location && p.RoomCount == int.Parse(pd.RoomCount) &&
(p.RentRangeId >= int.Parse(numbers[0]) && p.RentRangeId <= int.Parse(numbers[1])) && p.Duration == pd.Duration && p.PropertyStatus == "published"
select new
{
p.Location,
p.Detailed_Address,
p.HomeCategory,
p.TenantCategory,
p.RoomCount,
p.RentRangeId,
p.Duration
}).ToList();
if (details.Count < 0)
{
MessageBox.Show("No results Found");
}
else
{
m.LogInSearchResultDG.DataSource = details;
}
}
catch (Exception)
{
}
}
public static void setTenant(Classes.User tenant, Classes.PropertyDetails pd, MainUI m)
{
DataClasses1DataContext cntx = ToLet.Database.DBConnectionProvider.getDBConnection();
var info = (from p in cntx.Properties
where p.TenantCategory == pd.TenantCategory && p.HomeCategory == pd.HomeCategory && p.Location == pd.Location && p.RoomCount == int.Parse(pd.RoomCount) &&
p.Detailed_Address == pd.DetailedAddress && p.Additional_Comments == pd.AdditionalComment && p.RentRangeId == int.Parse(pd.RentRange)
select p).SingleOrDefault();
var userid = (from q in cntx.Users
where q.UserName == tenant.UserName
select q).SingleOrDefault();
Tenant t = new Tenant();
t.UserId = userid.UserId;
t.PropertyId = info.PropertyId;
cntx.Tenants.InsertOnSubmit(t);
cntx.SubmitChanges();
m.GetData();
}
public static void setMyLandlord(Classes.User tenant, Classes.PropertyDetails pd, MainUI m)
{
DataClasses1DataContext cntx = ToLet.Database.DBConnectionProvider.getDBConnection();
m.GetData();
}
