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