519 PROJECTBDS/Areas/Admin/Views/LandManage/Update.cshtml
View file

Large diffs are not rendered by default.

308 PROJECTBDS/Areas/Admin/Views/ProjectManage/CreateProject.cshtml
View file

Large diffs are not rendered by default.

356 PROJECTBDS/Areas/Admin/Views/ProjectManage/EditProject.cshtml
View file

Large diffs are not rendered by default.

1 PROJECTBDS/Areas/Admin/Views/ProjectManage/Index.cshtml
View file
@@ -58,6 +58,7 @@
<td style="vertical-align: middle">@($"{item.CreateDate:dd/MM/yyyy}")</td>

<td style="vertical-align: middle;">
<a href="@Url.Action("EditProject", "ProjectManage", new { id = item.Id })" class="btn btn-xs btn-success">Sửa</a><br />
<a href="@Url.Action("Create", "ProjectDetails", new { id = item.Id })" class="btn btn-xs btn-info">Chi tiết</a>
<button class="btn btn-xs btn-danger dropdown-toggle" type="button" onclick="deletePost(@item.Id);">
Xóa
143 PROJECTBDS/Areas/Admin/Views/Shared/_Partial_Navigation.cshtml
View file
@@ -1,84 +1,85 @@
<aside class="main-sidebar">
<!-- sidebar: style can be found in sidebar.less -->
<section class="sidebar">
<!-- Sidebar user panel -->
<div class="user-panel">
<div class="pull-left image">
<img src="/Content/dist/img/user2-160x160.jpg" class="img-circle" alt="User Image">
</div>
<div class="pull-left info">
<p>@(User.Identity.IsAuthenticated == true ? User.Identity.Name : "")</p>
<a href="#"><i class="fa fa-circle text-success"></i> Online</a>
</div>
</div>
<!-- sidebar menu: : style can be found in sidebar.less -->
<ul class="sidebar-menu">
<li class="treeview">
<a href="/admin/homeadmin">
<i class="fa fa-dashboard"></i><span>DASHBOARD</span>
</a>
</li>
<li class="treeview">
<a href="#">
<span>TIN TỨC</span>
<span class="pull-right-container">
<i class="fa fa-angle-left pull-right"></i>
</span>
</a>
<ul class="treeview-menu">
<li><a href="~/Admin/NewsManage/Index">Tin tức</a></li>
<li><a href="~/Admin/EventsManage/Index">Sự kiện</a></li>
<li><a href="~/Admin/CategoryNewsManage/Index/6">Danh mục tin</a></li>
<li><a href="~/Admin/DictionaryManage/Index/9">Thời gian sự kiện</a></li>
</ul>
</li>
<li class="treeview">
<a href="#">
<span>NHÀ ĐẤT</span>
<span class="pull-right-container">
<i class="fa fa-angle-left pull-right"></i>
</span>
</a>
<ul class="treeview-menu">
<li><a href="~/Admin/LandManage/Index">DS nhà đất</a></li>
<li><a href="~/Admin/DictionaryManage/Index/1">Loại BĐS</a></li>
<li><a href="~/Admin/DictionaryManage/Index/2">Loại giao dịch</a></li>
<li><a href="~/Admin/DictionaryManage/Index/3">Hướng nhà</a></li>
<li><a href="~/Admin/DictionaryManage/Index/4">Pháp lý</a></li>
<li><a href="~/Admin/DictionaryManage/Index/5">Đơn vị</a></li>
</ul>
</li>
<li class="treeview">
<a href="#">
<span>DỰ ÁN</span>
<span class="pull-right-container">
<i class="fa fa-angle-left pull-right"></i>
</span>
</a>
<ul class="treeview-menu">
<li><a href="~/Admin/ProjectManage/Index">DS dự án</a></li>
</ul>
</li>
<li class="treeview">
<a href="~/Admin/CompanyInfoManage/Index">
<span>THÔNG TIN CÔNG TY</span>
</a>
</li>
<aside class="main-sidebar">
<!-- sidebar: style can be found in sidebar.less -->
<section class="sidebar">
<!-- Sidebar user panel -->
<div class="user-panel">
<div class="pull-left image">
<img src="/Content/dist/img/user2-160x160.jpg" class="img-circle" alt="User Image">
</div>
<div class="pull-left info">
<p>@(User.Identity.IsAuthenticated == true ? User.Identity.Name : "")</p>
<a href="#"><i class="fa fa-circle text-success"></i> Online</a>
</div>
</div>
<!-- sidebar menu: : style can be found in sidebar.less -->
<ul class="sidebar-menu">
<li class="treeview">
<a href="/admin/homeadmin">
<i class="fa fa-dashboard"></i><span>DASHBOARD</span>
</a>
</li>
<li class="treeview">
<a href="#">
<span>TIN TỨC</span>
<span class="pull-right-container">
<i class="fa fa-angle-left pull-right"></i>
</span>
</a>
<ul class="treeview-menu">
<li><a href="~/Admin/NewsManage/Index">Tin tức</a></li>
<li><a href="~/Admin/EventsManage/Index">Sự kiện</a></li>
<li><a href="~/Admin/CategoryNewsManage/Index/6">Danh mục tin</a></li>
<li><a href="~/Admin/DictionaryManage/Index/9">Thời gian sự kiện</a></li>
</ul>
</li>
<li class="treeview">
<a href="#">
<span>NHÀ ĐẤT</span>
<span class="pull-right-container">
<i class="fa fa-angle-left pull-right"></i>
</span>
</a>
<ul class="treeview-menu">
<li><a href="~/Admin/LandManage/Index">DS nhà đất</a></li>
<li><a href="~/Admin/DictionaryManage/Index/1">Loại BĐS</a></li>
<li><a href="~/Admin/DictionaryManage/Index/2">Loại giao dịch</a></li>
<li><a href="~/Admin/DictionaryManage/Index/3">Hướng nhà</a></li>
<li><a href="~/Admin/DictionaryManage/Index/4">Pháp lý</a></li>
<li><a href="~/Admin/DictionaryManage/Index/5">Đơn vị</a></li>
</ul>
</li>
<li class="treeview">
<a href="#">
<span>DỰ ÁN</span>
<span class="pull-right-container">
<i class="fa fa-angle-left pull-right"></i>
</span>
</a>
<ul class="treeview-menu">
<li><a href="~/Admin/ProjectManage/Index">DS dự án</a></li>
<li><a href="~/Admin/DictionaryManage/Index/14">Loại dự án</a></li>
</ul>
</li>
<li class="treeview">
<a href="~/Admin/CompanyInfoManage/Index">
<span>THÔNG TIN CÔNG TY</span>
</a>
</li>
<li class="treeview">
<a href="~/Admin/ConfigManage/Index">
<span>CẤU HÌNH</span>
</a>
</li>
</li>
<li class="treeview">
<a href="~/Admin/ContactManage/Index">
<span>KHÁCH HÀNG LIÊN HỆ</span>
</a>
</li>
</li>
<li class="treeview">
<a href="~/Admin/ContactManage/Subscribe">
<span>ĐĂNG KÝ NHẬN BẢN TIN</span>
</a>
</li>
</ul>
</section>
</li>
</ul>
</section>
</aside>
2 PROJECTBDS/Content/assets/css/responsive.css
View file
@@ -304,7 +304,7 @@ ul.navbar-nav li:hover, ul.navbar-nav li.active {
.right-icon label {
margin-left: 10px;
float: right;
background: #F00;
background: #0cb14b;
padding: 5px 15px;
-webkit-border-bottom-left-radius: 15px;
-moz-border-radius-bottomleft: 15px;
189 PROJECTBDS/Controllers/HomeController.cs
View file
@@ -25,7 +25,8 @@ public ActionResult Index(int? page)
var model = new HomeViewModel
{
DuAnNoiBat = _data.Get15DuAnNoiBat(),
BatDongSan = _data.GetBatDongSan().OrderByDescending(t => t.Id).ToPagedList(pageNumber, PostsPerPage)
BatDongSanBan = _data.GetBatDongSanBan().ToList(),
BatDongSanChoThue = _data.GetBatDongSanChoThue().ToList()
};
return View(model);
}
@@ -108,28 +109,28 @@ public ActionResult TimKiemBatDongSan(int? page)
//int? type, int? method, int? direction,
//string price;

var s = Request["s"];
var province = Request["province"].AsInt();
var district = Request["district"].AsInt();
var type = Request["type"].AsInt();
var method = Request["method"].AsInt();
var direction = Request["direction"].AsInt();
var s = Request["s"];
var province = Request["province"].AsInt();
var district = Request["district"].AsInt();
var type = Request["type"].AsInt();
var method = Request["method"].AsInt();
var direction = Request["direction"].AsInt();
var price = Request["price"];

var priceIndex = price.IndexOf("|", StringComparison.Ordinal);
var priceS = new string[] {};
var priceS = new string[] { };
if (priceIndex == 0)
{
priceS = price.Split('|');
}
var priceFrom = 0;
var priceTo = 0;
var flag = false || priceS.Length > 1 &&
var flag = false || priceS.Length > 1 &&
int.TryParse(priceS[0], out priceFrom) &&
int.TryParse(priceS[1], out priceTo);

IQueryable<tblLand> results =
_db.tblLand.Where(t=>t.Title.ToLower().Contains(s.ToLower()) ||
IQueryable<tblLand> results =
_db.tblLand.Where(t => t.Title.ToLower().Contains(s.ToLower()) ||
t.ProvinceId == province ||
t.DistrictId == district ||
t.CategoryId == method ||
@@ -139,8 +140,8 @@ public ActionResult TimKiemBatDongSan(int? page)
);

var pageNumber = page ?? 1;
return View(results.OrderByDescending(t=>t.Id).ToPagedList(pageNumber, PostsPerPage));

return View(results.OrderByDescending(t => t.Id).ToPagedList(pageNumber, PostsPerPage));
}

public ActionResult About()
@@ -158,93 +159,97 @@ public ActionResult Contact()
}


public ActionResult SendEmail(tblContact model)
{
model.Date = DateTime.Now;
_db.tblContact.Add(model);
_db.SaveChanges();
return Json(JsonRequestBehavior.AllowGet);
}
public ActionResult SendEmail(tblContact model)
{
model.Date = DateTime.Now;
_db.tblContact.Add(model);
_db.SaveChanges();
return Json(JsonRequestBehavior.AllowGet);
}

/// <summary>
/// sự kiện
/// </summary>
/// <returns></returns>
public ActionResult _Partial_Event()
{
return PartialView("_Partial_Event");
}
/// <summary>
/// sự kiện
/// </summary>
/// <returns></returns>
public ActionResult _Partial_Event()
{
return PartialView("_Partial_Event");
}

/// <summary>
/// nhà đất
/// </summary>
/// <returns></returns>
public ActionResult _Partial_Land()
{
return PartialView("_Partial_Land");
}
/// <summary>
/// nhà đất
/// </summary>
/// <returns></returns>
public ActionResult _Partial_LandSale()
{
return PartialView("_Partial_LandSale");
}
public ActionResult _Partial_LandForRent()
{
return PartialView("_Partial_LandForRent");
}

/// <summary>
/// đối tác
/// </summary>
/// <returns></returns>
public ActionResult _Partial_Partner()
{
var model = _data.GetImageByCate(46).ToList();
return PartialView("_Partial_Partner", model);
}
/// <summary>
/// đối tác
/// </summary>
/// <returns></returns>
public ActionResult _Partial_Partner()
{
var model = _data.GetImageByCate(46).ToList();
return PartialView("_Partial_Partner", model);
}

/// <summary>
/// slider
/// </summary>
/// <returns></returns>
public ActionResult _Partial_Slider()
{
var model = _data.GetImageByCate(44).ToList();
return PartialView("_Partial_Slider", model);
}
/// <summary>
/// đối tác
/// </summary>
/// <returns></returns>
public ActionResult _Partial_Advertisement()
{
var model = _data.GetImageByCate(45).ToList();
return PartialView("_Partial_Advertisement", model);
}
/// <summary>
/// slider
/// </summary>
/// <returns></returns>
public ActionResult _Partial_Slider()
{
var model = _data.GetImageByCate(44).ToList();
return PartialView("_Partial_Slider", model);
}
/// <summary>
/// đối tác
/// </summary>
/// <returns></returns>
public ActionResult _Partial_Advertisement()
{
var model = _data.GetImageByCate(45).ToList();
return PartialView("_Partial_Advertisement", model);
}

/// <summary>
/// dự án
/// </summary>
/// <returns></returns>
public ActionResult _Partial_Project()
{
return PartialView("_Partial_Project");
}
/// <summary>
/// dự án
/// </summary>
/// <returns></returns>
public ActionResult _Partial_Project()
{
return PartialView("_Partial_Project");
}

/// <summary>
/// danh sách quận huyện
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public JsonResult DistrictList(int? id)
{
return Json(new SelectList(_db.tblDistrict.Where(p => p.ProvinceId == id).ToList(), "Id", "Name"), JsonRequestBehavior.AllowGet);
}
/// <summary>
/// danh sách quận huyện
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public JsonResult DistrictList(int? id)
{
return Json(new SelectList(_db.tblDistrict.Where(p => p.ProvinceId == id).ToList(), "Id", "Name"), JsonRequestBehavior.AllowGet);
}


public ActionResult Subscribe(FormCollection fc)
public ActionResult Subscribe(FormCollection fc)
{
var model = new tblContact()
{
var model = new tblContact()
{
Email = fc["ContactEmail"],
Name = fc["ContactName"],
Phone = fc["ContactPhone"],
Date = DateTime.Now,
};
_db.tblContact.Add(model);
_db.SaveChanges();
return Json(JsonRequestBehavior.AllowGet);
}
Email = fc["ContactEmail"],
Name = fc["ContactName"],
Phone = fc["ContactPhone"],
Date = DateTime.Now,
};
_db.tblContact.Add(model);
_db.SaveChanges();
return Json(JsonRequestBehavior.AllowGet);
}
}
}
10 PROJECTBDS/Helpers/LoadData.cs
View file
@@ -69,7 +69,13 @@ public static List<tblDictionary> TimeList()
return _db.tblDictionary.Where(p => p.CategoryId == 9 && p.Delete == false).ToList();
}



/// <summary>
/// Danh mục loại dự án
/// </summary>
/// <returns></returns>
public static List<tblDictionary> ProjectTypeList()
{
return _db.tblDictionary.Where(p => p.CategoryId == 14 && p.Delete == false).ToList();
}
}
}
55 PROJECTBDS/Models/Model.edmx
View file
@@ -191,7 +191,7 @@
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
<Property Name="Id" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
<Property Name="Title" Type="nvarchar" MaxLength="500" />
<Property Name="Desc" Type="nvarchar(max)" />
<Property Name="Content" Type="nvarchar(max)" />
@@ -222,6 +222,8 @@
<Property Name="ymap" Type="nvarchar" MaxLength="500" />
<Property Name="CustomerId" Type="int" />
<Property Name="IsDelete" Type="bit" Nullable="false" />
<Property Name="Bedroom" Type="int" />
<Property Name="Bathroom" Type="int" />
</EntityType>
<EntityType Name="tblNews">
<Key>
@@ -260,6 +262,7 @@
<Property Name="DistrictId" Type="int" />
<Property Name="Price" Type="nvarchar" MaxLength="200" />
<Property Name="Logo" Type="nvarchar" MaxLength="500" />
<Property Name="TypeId" Type="int" />
</EntityType>
<EntityType Name="tblProjectDetail">
<Key>
@@ -667,6 +670,18 @@
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_tblProjectType_tblDictionaryType">
<End Role="tblDictionary" Type="Self.tblDictionary" Multiplicity="0..1" />
<End Role="tblProject" Type="Self.tblProject" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="tblDictionary">
<PropertyRef Name="Id" />
</Principal>
<Dependent Role="tblProject">
<PropertyRef Name="TypeId" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_tblWard_tblDistrict">
<End Role="tblDistrict" Type="Self.tblDistrict" Multiplicity="0..1" />
<End Role="tblWard" Type="Self.tblWard" Multiplicity="*" />
@@ -837,6 +852,10 @@
<End Role="tblProject" EntitySet="tblProject" />
<End Role="tblProjectDetail" EntitySet="tblProjectDetail" />
</AssociationSet>
<AssociationSet Name="FK_tblProjectType_tblDictionaryType" Association="Self.FK_tblProjectType_tblDictionaryType">
<End Role="tblDictionary" EntitySet="tblDictionary" />
<End Role="tblProject" EntitySet="tblProject" />
</AssociationSet>
<AssociationSet Name="FK_tblWard_tblDistrict" Association="Self.FK_tblWard_tblDistrict">
<End Role="tblDistrict" EntitySet="tblDistrict" />
<End Role="tblWard" EntitySet="tblWard" />
@@ -989,7 +1008,8 @@
<NavigationProperty Name="tblLand4" Relationship="Self.FK_tblLandUnit_tblDictionaryUnit" FromRole="tblDictionary" ToRole="tblLand" />
<NavigationProperty Name="tblNews" Relationship="Self.FK_tblNews_tblDictionary" FromRole="tblDictionary" ToRole="tblNews" />
<NavigationProperty Name="tblNews1" Relationship="Self.FK_tblNews_tblDictionaryTime" FromRole="tblDictionary" ToRole="tblNews" />
<NavigationProperty Name="tblProjectDetail" Relationship="Self.FK_tblProjectDetail_tblDictionary" FromRole="tblDictionary" ToRole="tblProjectDetail" />
<NavigationProperty Name="tblProjectDetail" Relationship="Self.FK_tblProjectDetail_tblDictionary" FromRole="tblDictionary" ToRole="tblProjectDetail" />
<NavigationProperty Name="tblProject" Relationship="LandSoftModel.FK_tblProjectType_tblDictionaryType" FromRole="tblDictionary" ToRole="tblProject" />
</EntityType>
<EntityType Name="tblDistrict">
<Key>
@@ -1065,7 +1085,9 @@
<NavigationProperty Name="tblImage" Relationship="Self.FK_tblImage_tblLand" FromRole="tblLand" ToRole="tblImage" />
<NavigationProperty Name="tblProject" Relationship="Self.FK_tblLand_tblProject" FromRole="tblLand" ToRole="tblProject" />
<NavigationProperty Name="tblProvince" Relationship="Self.FK_tblLand_tblProvince" FromRole="tblLand" ToRole="tblProvince" />
<NavigationProperty Name="tblWard" Relationship="Self.FK_tblLand_tblWard" FromRole="tblLand" ToRole="tblWard" />
<NavigationProperty Name="tblWard" Relationship="Self.FK_tblLand_tblWard" FromRole="tblLand" ToRole="tblWard" />
<Property Name="Bedroom" Type="Int32" />
<Property Name="Bathroom" Type="Int32" />
</EntityType>
<EntityType Name="tblNews">
<Key>
@@ -1112,7 +1134,9 @@
<NavigationProperty Name="tblImage" Relationship="Self.FK_tblImage_tblProject" FromRole="tblProject" ToRole="tblImage" />
<NavigationProperty Name="tblLand" Relationship="Self.FK_tblLand_tblProject" FromRole="tblProject" ToRole="tblLand" />
<NavigationProperty Name="tblProvince" Relationship="Self.FK_tblProject_tblProvince" FromRole="tblProject" ToRole="tblProvince" />
<NavigationProperty Name="tblProjectDetail" Relationship="Self.FK_tblProjectDetail_tblProject" FromRole="tblProject" ToRole="tblProjectDetail" />
<NavigationProperty Name="tblProjectDetail" Relationship="Self.FK_tblProjectDetail_tblProject" FromRole="tblProject" ToRole="tblProjectDetail" />
<Property Name="TypeId" Type="Int32" />
<NavigationProperty Name="tblDictionary" Relationship="LandSoftModel.FK_tblProjectType_tblDictionaryType" FromRole="tblProject" ToRole="tblDictionary" />
</EntityType>
<EntityType Name="tblProjectDetail">
<Key>
@@ -1654,7 +1678,11 @@
<FunctionImport Name="SplitString" IsComposable="true" ReturnType="Collection(LandSoftModel.SplitString_Result)">
<Parameter Name="String" Mode="In" Type="String" />
<Parameter Name="Delimiter" Mode="In" Type="String" />
</FunctionImport>
</FunctionImport>
<AssociationSet Name="FK_tblProjectType_tblDictionaryType" Association="LandSoftModel.FK_tblProjectType_tblDictionaryType">
<End Role="tblDictionary" EntitySet="tblDictionary" />
<End Role="tblProject" EntitySet="tblProject" />
</AssociationSet>
</EntityContainer>
<EntityType Name="C__MigrationHistory">
<Key>
@@ -1703,7 +1731,19 @@
<ComplexType Name="SplitString_Result">
<Property Type="Int64" Name="Id" Nullable="true" />
<Property Type="String" Name="Data" Nullable="true" MaxLength="4000" />
</ComplexType>
</ComplexType>
<Association Name="FK_tblProjectType_tblDictionaryType">
<End Type="LandSoftModel.tblDictionary" Role="tblDictionary" Multiplicity="0..1" />
<End Type="LandSoftModel.tblProject" Role="tblProject" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="tblDictionary">
<PropertyRef Name="Id" />
</Principal>
<Dependent Role="tblProject">
<PropertyRef Name="TypeId" />
</Dependent>
</ReferentialConstraint>
</Association>
</Schema>
</edmx:ConceptualModels>
<!-- C-S mapping content -->
@@ -1864,6 +1904,8 @@
<EntitySetMapping Name="tblLand">
<EntityTypeMapping TypeName="LandSoftModel.tblLand">
<MappingFragment StoreEntitySet="tblLand">
<ScalarProperty Name="Bathroom" ColumnName="Bathroom" />
<ScalarProperty Name="Bedroom" ColumnName="Bedroom" />
<ScalarProperty Name="Id" ColumnName="Id" />
<ScalarProperty Name="Title" ColumnName="Title" />
<ScalarProperty Name="Desc" ColumnName="Desc" />
@@ -1922,6 +1964,7 @@
<EntitySetMapping Name="tblProject">
<EntityTypeMapping TypeName="LandSoftModel.tblProject">
<MappingFragment StoreEntitySet="tblProject">
<ScalarProperty Name="TypeId" ColumnName="TypeId" />
<ScalarProperty Name="Id" ColumnName="Id" />
<ScalarProperty Name="Title" ColumnName="Title" />
<ScalarProperty Name="Desc" ColumnName="Desc" />
3 PROJECTBDS/Models/Model.edmx.diagram
View file
@@ -55,7 +55,8 @@
<EntityTypeShape EntityType="LandSoftModel.C__MigrationHistory" Width="1.5" PointX="8.375" PointY="6.75" />
<EntityTypeShape EntityType="LandSoftModel.sysdiagrams" Width="1.5" PointX="8.375" PointY="9.75" />
<EntityTypeShape EntityType="LandSoftModel.tblContact" Width="1.5" PointX="10.375" PointY="0.75" />
<AssociationConnector Association="LandSoftModel.FK_tblNews_tblDistrict" />
<AssociationConnector Association="LandSoftModel.FK_tblNews_tblDistrict" />
<AssociationConnector Association="LandSoftModel.FK_tblProjectType_tblDictionaryType" />
</Diagram>
</edmx:Diagrams>
</edmx:Designer>
6 PROJECTBDS/Models/tblDictionary.cs
View file
@@ -40,6 +40,8 @@ public tblDictionary()

this.tblProjectDetail = new HashSet<tblProjectDetail>();

this.tblProject = new HashSet<tblProject>();

}


@@ -97,6 +99,10 @@ public tblDictionary()

public virtual ICollection<tblProjectDetail> tblProjectDetail { get; set; }

[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]

public virtual ICollection<tblProject> tblProject { get; set; }

}

}
4 PROJECTBDS/Models/tblLand.cs
View file
@@ -89,6 +89,10 @@ public tblLand()

public bool IsDelete { get; set; }

public Nullable<int> Bedroom { get; set; }

public Nullable<int> Bathroom { get; set; }



public virtual tblCustomer tblCustomer { get; set; }
4 PROJECTBDS/Models/tblProject.cs
View file
@@ -57,6 +57,8 @@ public tblProject()

public string Logo { get; set; }

public Nullable<int> TypeId { get; set; }



public virtual tblDistrict tblDistrict { get; set; }
@@ -75,6 +77,8 @@ public tblProject()

public virtual ICollection<tblProjectDetail> tblProjectDetail { get; set; }

public virtual tblDictionary tblDictionary { get; set; }

}

}
3 PROJECTBDS/PROJECTBDS.csproj
View file
@@ -3293,7 +3293,7 @@
<Content Include="Views\Shared\Lockout.cshtml" />
<Content Include="Views\Shared\_LoginPartial.cshtml" />
<Content Include="Views\Shared\_Partial_Event.cshtml" />
<Content Include="Views\Shared\_Partial_Land.cshtml" />
<Content Include="Views\Shared\_Partial_LandForRent.cshtml" />
<Content Include="Views\Shared\_Partial_Partner.cshtml" />
<Content Include="Views\Home\_Partial_Project.cshtml" />
<Content Include="Views\Shared\_Partial_Search.cshtml" />
@@ -3332,6 +3332,7 @@
<Content Include="Views\Shared\_Partial_Subscribe.cshtml" />
<Content Include="Views\News\Cate.cshtml" />
<Content Include="Views\News\Search.cshtml" />
<Content Include="Views\Shared\_Partial_LandSale.cshtml" />
</ItemGroup>
<ItemGroup>
<Folder Include="App_Data\" />
56 PROJECTBDS/Services/Home/HomeServices.cs
View file
@@ -71,9 +71,63 @@ public List<DuAnBdsViewModel> GetBatDongSan()
return (List<DuAnBdsViewModel>)_db.Query<DuAnBdsViewModel>(query);
}

public List<DuAnBdsViewModel> GetBatDongSanBan()
{
var query =
"SELECT top 10 l.Id,l.Title as TieuDe,l.Image,Code as MaSoNhaDat,Area as DienTich,Road as DuongMatTruoc,d1.Title as HuongNha " +
",d2.Title as LoaiBatDongSan " +
",d3.Title as DonVi " +
",d4.Title as LoaiGiaoDich " +
",d.Name as ThanhPho " +
",d0.Name as Quan " +
",d5.Name as Phuong " +
",d6.Title as PhapLy " +
",d7.Title as DuAn " +
",l.Price as Gia " +
"FROM tblLand l " +
"LEFT JOIN tblProvince d ON(d.Id = l.ProvinceId) " +
"LEFT JOIN tblDistrict d0 ON(d0.Id = l.DistrictId) " +
"LEFT JOIN tblWard d5 ON(d5.Id = l.WardId) " +
"LEFT JOIN tblDictionary d1 ON(d1.Id = l.DirectionId) AND d1.CategoryId = 3 " +
"LEFT JOIN tblDictionary d2 ON(d2.Id = l.CategoryId) AND d2.CategoryId = 1 " +
"LEFT JOIN tblDictionary d3 ON(d3.Id = l.UnitId) AND d3.CategoryId = 12 " +
"LEFT JOIN tblDictionary d4 ON(d4.Id = l.TypeId) AND d4.CategoryId = 2 " +
"LEFT JOIN tblDictionary d6 ON(d6.Id = l.RuleId) AND d6.CategoryId = 4 " +
"LEFT JOIN tblProject d7 ON(d7.Id = l.ProjectId) " +
"WHERE l.TypeId = 5 ORDER BY l.CreateDate DESC";
return (List<DuAnBdsViewModel>)_db.Query<DuAnBdsViewModel>(query);
}

public List<DuAnBdsViewModel> GetBatDongSanChoThue()
{
var query =
"SELECT top 5 l.Id,l.Title as TieuDe,l.Image,Code as MaSoNhaDat,Area as DienTich,Road as DuongMatTruoc,d1.Title as HuongNha " +
",d2.Title as LoaiBatDongSan " +
",d3.Title as DonVi " +
",d4.Title as LoaiGiaoDich " +
",d.Name as ThanhPho " +
",d0.Name as Quan " +
",d5.Name as Phuong " +
",d6.Title as PhapLy " +
",d7.Title as DuAn " +
",l.Price as Gia " +
"FROM tblLand l " +
"LEFT JOIN tblProvince d ON(d.Id = l.ProvinceId) " +
"LEFT JOIN tblDistrict d0 ON(d0.Id = l.DistrictId) " +
"LEFT JOIN tblWard d5 ON(d5.Id = l.WardId) " +
"LEFT JOIN tblDictionary d1 ON(d1.Id = l.DirectionId) AND d1.CategoryId = 3 " +
"LEFT JOIN tblDictionary d2 ON(d2.Id = l.CategoryId) AND d2.CategoryId = 1 " +
"LEFT JOIN tblDictionary d3 ON(d3.Id = l.UnitId) AND d3.CategoryId = 12 " +
"LEFT JOIN tblDictionary d4 ON(d4.Id = l.TypeId) AND d4.CategoryId = 2 " +
"LEFT JOIN tblDictionary d6 ON(d6.Id = l.RuleId) AND d6.CategoryId = 4 " +
"LEFT JOIN tblProject d7 ON(d7.Id = l.ProjectId) " +
"WHERE l.TypeId = 6 ORDER BY l.CreateDate DESC";
return (List<DuAnBdsViewModel>)_db.Query<DuAnBdsViewModel>(query);
}

public Land GetLand(long idLand)
{
var query = "SELECT l.Id, l.Title as TieuDe, l.Content, l.Address, " +
var query = "SELECT l.Id, l.Code, l.Title as TieuDe, l.Content, l.Bathroom, l.Bedroom, l.Address, " +
"l.Image, Code as MaSoNhaDat, Area as DienTich, " +
"Road as DuongMatTruoc, d1.Title as HuongNha " +
",d2.Title as LoaiBatDongSan " +
7 PROJECTBDS/ViewModels/Home/DuAnNoiBatViewModel.cs
View file
@@ -13,7 +13,8 @@ public class JsonHome

public class HomeViewModel
{
public IPagedList<DuAnBdsViewModel> BatDongSan { get; set; }
public List<DuAnBdsViewModel> BatDongSanBan { get; set; }
public List<DuAnBdsViewModel> BatDongSanChoThue { get; set; }
public List<DuAnNoiBatViewModel> DuAnNoiBat { get; set; }

}
@@ -52,6 +53,7 @@ public string Address
public class DuAnBdsViewModel
{
public int Id { get; set; }
public string Code { get; set; }
public string TieuDe { get; set; }
public string Image { get; set; }
public string MaSoNhaDat { get; set; }
@@ -67,7 +69,8 @@ public class DuAnBdsViewModel
public string PhapLy { get; set; }
public string DuAn { get; set; }
public string Gia { get; set; }

public int Bedroom { get; set; }
public int Bathroom { get; set; }


public string DisplayPrice()
63 PROJECTBDS/Views/Abouts/Index.cshtml
View file
@@ -24,7 +24,7 @@
<div class="row gutter-5">
<div class="col-xs-6">
<select name="province" id="province">
<option value="0">Tỉnh/Thành phố</option>
<option value="0">Thành phố</option>
@foreach (var item in LoadData.ProvinceList())
{
<option value="@item.Id">@item.Name</option>
@@ -33,44 +33,56 @@
</div>
<div class="col-xs-6">
<select name="district" id="district" data-value="">
<option value="0">Quận/Huyện</option>
<option value="0">Quận</option>
</select>
</div>
</div>
<div class="row gutter-5">
<div class="col-xs-6">
<select name="type">
<option value="0">Loại Bất động sản</option>
<option value="0">Loại BĐS</option>
@foreach (var item in LoadData.CategoryList())
{
<option value="@item.Id">@item.Title</option>
}
</select>
</div>
<div class="col-xs-6">
<select name="method">
<option value="0">Loại giao dịch</option>
@foreach (var item in LoadData.TransactionList())
<select name="area" id="area">
<option value="0|0">Diện tích</option>
<option value="0|30">&lt;= 30 m2</option>
<option value="30|50">30 - 50 m2</option>
<option value="50|80">50 - 80 m2</option>
<option value="80|100">80 - 100</option>
<option value="100|150">100 - 150 m2</option>
<option value="150|200">150 - 200 m2</option>
<option value="200|250">200 - 250 m2</option>
<option value="250|300">250 - 300 m2</option>
<option value="300|500">300 - 500 m2</option>
<option value="500|10000">&gt; 500 m2</option>
</select>
</div>
</div>
<div class="row gutter-5">
<div class="col-xs-6">
<select name="bedroom" id="bedroom">
<option value="0">Phòng ngủ</option>
@for (int i = 1; i < 7; i++)
{
<option value="@item.Id">@item.Title</option>
<option value="@i">@i</option>
}
</select>
</div>
<div class="col-xs-6">
<select name="bathroom" id="bathroom">
<option value="0">Phòng tắm</option>
@for (int i = 1; i < 6; i++)
{
<option value="@i">@i</option>
}
</select>
</div>
</div>

<select name="area" style="display:none;">
<option value="0|0">Diện tích</option>
<option value="0|30">&lt;= 30 m2</option>
<option value="30|50">30 - 50 m2</option>
<option value="50|80">50 - 80 m2</option>
<option value="80|100">80 - 100</option>
<option value="100|150">100 - 150 m2</option>
<option value="150|200">150 - 200 m2</option>
<option value="200|250">200 - 250 m2</option>
<option value="250|300">250 - 300 m2</option>
<option value="300|500">300 - 500 m2</option>
<option value="500|10000">&gt; 500 m2</option>
</select>
<div class="row gutter-5">
<div class="col-xs-6">
<select name="direction">
@@ -137,7 +149,14 @@
</ul>
</div>
</div>

<div class="box-sidebar box-category">
<div class="box-title">
Sự kiện sắp diễn ra
</div>
<div class="box-content" style="text-align: right">
<a href="/su-kien"> Xem thêm <img src="/Content/assets/img/detail-button.jpg"></a>
</div>
</div>
@Html.Partial("_Partial_Subscribe")
</div>
</div>
67 PROJECTBDS/Views/Home/Index.cshtml
View file
@@ -1,33 +1,36 @@
@model PROJECTBDS.ViewModels.Home.HomeViewModel
@{
ViewBag.Title = "Home Page";
}
<section class="bg-sldier">
<div class="container">
<div class="head-title">
<div class="row">
<div class="col-md-offset-4 col-md-8">
<h1>chào mừng bạn đến siêu thị địa ốc <span>Bùi Ngọc Niệm</span></h1>
</div>
</div>
</div>
<div class="bg-content-slider">
<div class="row">
@Html.Partial("_Partial_Search")
@Html.Action("_Partial_Slider", "Home")
</div>
</div>
</div>
</section>
@Html.Partial("_Partial_Project", Model.DuAnNoiBat)
<section class="content-bottom">
<div class="container">
<div class="row">
@Html.Partial("_Partial_Land", Model.BatDongSan)
@Html.Partial("_Partial_Event")
</div>
</div>
</section>
@section scripts {
<script src="~/Scripts/land.js"></script>
@model PROJECTBDS.ViewModels.Home.HomeViewModel
@{
ViewBag.Title = "Home Page";
}
<section class="bg-sldier">
<div class="container">
<div class="head-title">
<div class="row">
<div class="col-md-offset-4 col-md-8">
<h1>chào mừng bạn đến siêu thị địa ốc <span>Bùi Ngọc Niệm</span></h1>
</div>
</div>
</div>
<div class="bg-content-slider">
<div class="row">
@Html.Partial("_Partial_Search")
@Html.Action("_Partial_Slider", "Home")
</div>
</div>
</div>
</section>
@Html.Partial("_Partial_Project", Model.DuAnNoiBat)
<section class="content-bottom">
<div class="container">
<div class="row">
<div class="col-lg-9 col-md-9 col-sm-8 col-xs-12">
@Html.Partial("_Partial_LandSale", Model.BatDongSanBan)
@Html.Partial("_Partial_LandForRent", Model.BatDongSanChoThue)
</div>
@Html.Partial("_Partial_Event")
</div>
</div>
</section>
@section scripts {
<script src="~/Scripts/land.js"></script>
}
9 PROJECTBDS/Views/Home/SieuThiDiaOc.cshtml
View file
@@ -49,6 +49,9 @@
<div class="box box-attribute">
<h3 class="box-title">đặc điểm chính</h3>
<div class="row gutter-5">
<div class="col-xs-6 col-md-6">
<div class="item item-lvroom">Mã nhà dất: <strong>@Model.Code</strong></div>
</div>
<div class="col-xs-6 col-md-6">
<div class="item item-lvroom">Loại: <strong>@Model.LoaiBatDongSan</strong></div>
</div>
@@ -70,6 +73,12 @@
<div class="col-xs-6 col-md-6">
<div class="item item-road">Đường rộng : <strong>@Model.DuongMatTruoc</strong></div>
</div>
<div class="col-xs-6 col-md-6">
<div class="item item-bedroom">Phòng ngủ : <strong>@Model.Bedroom</strong></div>
</div>
<div class="col-xs-6 col-md-6">
<div class="item item-badroom">Phòng tắm : <strong>@Model.Bathroom</strong></div>
</div>

</div>
</div>
54 PROJECTBDS/Views/Lands/Index.cshtml
View file
@@ -92,26 +92,32 @@
<option value="@item.Id">@item.Title</option>
}
</select>
<select name="method">
<option value="0">Loại giao dịch</option>
@foreach (var item in LoadData.TransactionList())
<select name="area">
<option value="0|0">Diện tích</option>
<option value="0|30">&lt;= 30 m2</option>
<option value="30|50">30 - 50 m2</option>
<option value="50|80">50 - 80 m2</option>
<option value="80|100">80 - 100</option>
<option value="100|150">100 - 150 m2</option>
<option value="150|200">150 - 200 m2</option>
<option value="200|250">200 - 250 m2</option>
<option value="250|300">250 - 300 m2</option>
<option value="300|500">300 - 500 m2</option>
<option value="500|10000">&gt; 500 m2</option>
</select>
<select name="bedroom" id="bedroom">
<option value="0">Số phòng ngủ</option>
@for (int i = 1; i < 7; i++)
{
<option value="@item.Id">@item.Title</option>
<option value="@i">@i</option>
}
</select>

<select name="area" style="display:none;">
<option value="">Diện tích</option>
<option value="22">&lt;= 30 m2</option>
<option value="23">30 - 50 m2</option>
<option value="24">50 - 80 m2</option>
<option value="25">80 - 100</option>
<option value="26">100 - 150 m2</option>
<option value="27">150 - 200 m2</option>
<option value="28">200 - 250 m2</option>
<option value="29">250 - 300 m2</option>
<option value="30">300 - 500 m2</option>
<option value="31">&gt; 500 m2</option>
<select name="bathroom" id="bathroom">
<option value="0">Số phòng tắm</option>
@for (int i = 1; i < 6; i++)
{
<option value="@i">@i</option>
}
</select>
<select name="direction">
<option value="0">Hướng</option>
@@ -121,13 +127,13 @@
}
</select>
<select name="price" id="rePrice">
<option value="">Khoảng giá</option>
<option value="8">Từ 0 đến 500tr</option>
<option value="9">Từ 500tr đến 1tỷ</option>
<option value="10">Từ 1tỷ đến 2tỷ</option>
<option value="11">Từ 2tỷ đến 4tỷ</option>
<option value="12">Từ 4tỷ đến 7tỷ</option>
<option value="13">Từ 7tỷ đến 10tỷ</option>
<option value="0|0">Khoảng giá</option>
<option value="0|500">Từ 0 đến 500tr</option>
<option value="501|1000">Từ 500tr đến 1tỷ</option>
<option value="1001|2000">Từ 1tỷ đến 2tỷ</option>
<option value="2001|4000">Từ 2tỷ đến 4tỷ</option>
<option value="4001|7000">Từ 4tỷ đến 7tỷ</option>
<option value="7001|10000">Từ 7tỷ đến 10tỷ</option>
</select>
<button type="submit">Tìm kiếm</button>
</form>
2 PROJECTBDS/Views/Projects/Detail.cshtml
View file
@@ -7,7 +7,7 @@
<h1>CĂN HỘ JAMILA</h1>
<div class="search-bds">
<div class="title-sr">
<img src="http://sunlandsg.vn/themes/frontend/images/search-icon.png" alt="icon search">
<img src="~/Content/assets/images/search-icon.png" alt="icon search">
Tìm kiếm bất động sản
<span class="glyphicon glyphicon-menu-down"></span>
</div>
11 PROJECTBDS/Views/Projects/Index.cshtml
View file
@@ -73,13 +73,14 @@
}
</select>
<select name="district" id="district" data-value="">
<option value="">Quận/Huyện</option>
<option value="0">Quận/Huyện</option>
</select>
<select name="type">
<option value="">Loại dự án</option>
<option value="1">Nhà</option>
<option value="2">Đất</option>
<option value="3">Chung cư</option>
<option value="0">Loại dự án</option>
@foreach (var item in LoadData.ProjectTypeList())
{
<option value="@item.Id">@item.Title</option>
}
</select>
<button type="submit">Tìm kiếm</button>
</form>
69 PROJECTBDS/Views/Shared/_Partial_Event.cshtml
View file
@@ -1,49 +1,20 @@
<div class="col-lg-3 col-md-3 col-sm-4 col-xs-12">
<div class="event-box">

<div class="event-r">
<div class="title-news">
<h2><a href="/tim-kiem-su-kien?timetype=1">Sự kiện sắp diễn ra</a><a></a></h2><a>
<span></span>
</a>
</div><a>
</a><div class="content-event padding-right-event">
<a>
<ul></ul>
</a><div class="details-button">
<a>
</a><a href="/tim-kiem-su-kien?timetype=1"> Xem thêm <img src="/Content/assets/img/detail-button.jpg"></a>
</div>
</div>
</div>

<div class="ads-r">
<h4>Đăng ký<br> nhận tin bất động sản</h4>

<div class="box-input">
<form id="realRegForm" action="/frontend/ajax/save-contact" method="post">
<input type="hidden" name="_csrf" value="WGNJR1lZa2dqDgY.bTYCKxEzCBQ.dAMvKBUWMiweHjcKBBgKCh4uLg=="><div class="form-group field-frontcontact-name required">
<input type="text" id="frontcontact-name" class="form-control" name="FrontContact[name]" placeholder="Họ và tên"><span class="help-block"><div class="help-block"></div></span>
</div><div class="form-group field-frontcontact-phone required">
<input type="text" id="frontcontact-phone" class="form-control" name="FrontContact[phone]" placeholder="Số điện thoại"><span class="help-block"><div class="help-block"></div></span>
</div><div class="form-group field-frontcontact-email required">
<input type="text" id="frontcontact-email" class="form-control" name="FrontContact[email]" placeholder="Email"><span class="help-block"><div class="help-block"></div></span>
</div><div class="form-group field-frontcontact-type">
<input type="hidden" id="frontcontact-type" class="form-control" name="FrontContact[type]" value="5">
<div class="help-block"></div>
</div><div class="form-group field-frontcontact-object_id">
<input type="hidden" id="frontcontact-object_id" class="form-control" name="FrontContact[object_id]">
<div class="help-block"></div>
</div><div class="form-group field-frontcontact-item_name">
<input type="hidden" id="frontcontact-item_name" class="form-control" name="FrontContact[item_name]">
<div class="help-block"></div>
</div> <div class="form-group">
<button type="submit" class="">Đăng ký</button>
</div>
</form>
</div>
</div>

@Html.Action("_Partial_Advertisement", "Home")
</div>
</div>
<div class="col-lg-3 col-md-3 col-sm-4 col-xs-12">
<div class="event-box">
<div class="event-r">
<div class="title-news">
<h2><a href="/su-kien">Sự kiện sắp diễn ra</a><a></a></h2><a>
<span></span>
</a>
</div><a>
</a><div class="content-event padding-right-event">
<a>
<ul></ul>
</a><div class="details-button">
<a>
</a><a href="/su-kien"> Xem thêm <img src="/Content/assets/img/detail-button.jpg"></a>
</div>
</div>
</div>
</div>
@Html.Partial("_Partial_Subscribe")
</div>
51 PROJECTBDS/Views/Shared/_Partial_LandForRent.cshtml
View file
@@ -0,0 +1,51 @@
@using PROJECTBDS.Infrastructure
@using PROJECTBDS.ViewModels.Home
@model IEnumerable<DuAnBdsViewModel>

<div class="news-list">
<div class="news-box">
<div class="title-news">
<h2><a href="/sieu-thi-dia-oc">Bất động sản cho thuê</a></h2>
<span></span>
</div>
<div class="content-news-lst">
<ul>
@if (Model != null)
{
foreach (var item in Model)
{
<li>
<a href="~/sieu-thi-dia-oc/@item.TieuDe.UrlFriendly()-@item.Id">
<img src="@(item.Image)" alt="@item.TieuDe">
</a>
<div class="r-listnews">
<div class="right-listnews">
<a href="~/sieu-thi-dia-oc/@item.TieuDe.UrlFriendly()-@item.Id" title="@item.TieuDe">@item.TieuDe</a>
<p>
<span class="duan">Dự án : @item.DuAn</span>
<span class="malo">Mã lô : @item.MaSoNhaDat</span>
</p>
<p>
<span class="dientich">Diện tích : @item.DienTich</span>
<span class="huong">Hướng nhà : @item.HuongNha</span>
</p>
<p>
<span class="duongvao">Đường trước mặt : @item.DuongMatTruoc</span>
<span class="phaply">Pháp lý : @item.PhapLy</span>
</p>
<!--<p></p>-->
</div>
<!--<div class="address-icon"><span class="icon-address-box"></span></div>-->
<div class="right-icon">
<span style="float: none; margin-top: 0; font-size: 18px;">Giá</span><label><b>@item.DisplayPrice()</b></label>
</div>
</div>
</li>
}
}
</ul>
</div>
<div class="clearfix"></div>
</div>
@Html.Action("_Partial_Partner", "Home")
</div>
49 PROJECTBDS/Views/Shared/_Partial_LandSale.cshtml
View file
@@ -0,0 +1,49 @@
@using PROJECTBDS.Infrastructure
@using PROJECTBDS.ViewModels.Home
@model IEnumerable<DuAnBdsViewModel>
<div class="news-list">
<div class="news-box">
<div class="title-news">
<h2><a href="/sieu-thi-dia-oc">Bất động sản cần bán</a></h2>
<span></span>
</div>
<div class="content-news-lst">
<ul>
@if (Model != null)
{
foreach (var item in Model)
{
<li>
<a href="~/sieu-thi-dia-oc/@item.TieuDe.UrlFriendly()-@item.Id">
<img src="@(item.Image)" alt="@item.TieuDe">
</a>
<div class="r-listnews">
<div class="right-listnews">
<a href="~/sieu-thi-dia-oc/@item.TieuDe.UrlFriendly()-@item.Id" title="@item.TieuDe">@item.TieuDe</a>
<p>
<span class="duan">Dự án : @item.DuAn</span>
<span class="malo">Mã lô : @item.MaSoNhaDat</span>
</p>
<p>
<span class="dientich">Diện tích : @item.DienTich</span>
<span class="huong">Hướng nhà : @item.HuongNha</span>
</p>
<p>
<span class="duongvao">Đường trước mặt : @item.DuongMatTruoc</span>
<span class="phaply">Pháp lý : @item.PhapLy</span>
</p>
<!--<p></p>-->
</div>
<!--<div class="address-icon"><span class="icon-address-box"></span></div>-->
<div class="right-icon">
<span style="float: none; margin-top: 0; font-size: 18px;">Giá</span><label><b>@item.DisplayPrice()</b></label>
</div>
</div>
</li>
}
}
</ul>
</div>
<div class="clearfix"></div>
</div>
</div>
53 PROJECTBDS/Views/Shared/_Partial_Search.cshtml
View file
@@ -35,28 +35,41 @@
</select>
</div>
<div class="col-xs-6">
<select name="method">
<option>Loại giao dịch</option>
@foreach (var item in LoadData.TransactionList())
{
<option value="@item.Id">@item.Title</option>
}
<select name="area">
<option value="0|0">Diện tích</option>
<option value="0|30">&lt;= 30 m2</option>
<option value="30|50">30 - 50 m2</option>
<option value="50|80">50 - 80 m2</option>
<option value="80|100">80 - 100</option>
<option value="100|150">100 - 150 m2</option>
<option value="150|200">150 - 200 m2</option>
<option value="200|250">200 - 250 m2</option>
<option value="250|300">250 - 300 m2</option>
<option value="300|500">300 - 500 m2</option>
<option value="500|10000">&gt; 500 m2</option>
</select>
</div>
</div>
<select name="area" style="display:none;">
<option value="0|0">Diện tích</option>
<option value="0|30">&lt;= 30 m2</option>
<option value="30|50">30 - 50 m2</option>
<option value="50|80">50 - 80 m2</option>
<option value="80|100">80 - 100</option>
<option value="100|150">100 - 150 m2</option>
<option value="150|200">150 - 200 m2</option>
<option value="200|250">200 - 250 m2</option>
<option value="250|300">250 - 300 m2</option>
<option value="300|500">300 - 500 m2</option>
<option value="500|10000">&gt; 500 m2</option>
</select>
</div>
<div class="row gutter-5">
<div class="col-xs-6">
<select name="bedroom" id="bedroom">
<option value="0">Số phòng ngủ</option>
@for (int i = 1; i < 7; i++)
{
<option value="@i">@i</option>
}
</select>
</div>
<div class="col-xs-6">
<select name="bathroom" id="bathroom">
<option value="0">Số phòng tắm</option>
@for (int i = 1; i < 6; i++)
{
<option value="@i">@i</option>
}
</select>
</div>
</div>
<div class="row gutter-5">
<div class="col-xs-6">
<select name="direction">
BIN +8 KB (100%) PROJECTBDS/bin/PROJECTBDS.dll
View file
Binary file not shown.
BIN +4 KB (100%) PROJECTBDS/bin/PROJECTBDS.pdb
View file
Binary file not shown.
BIN +0 Bytes (100%) PROJECTBDS/obj/Debug/TempPE/Models.Model.Designer.cs.dll
View file
Binary file not shown.
BIN +0 Bytes (100%) PROJECTBDS/obj/Debug/TempPE/Models.Model.cs.dll
View file
Binary file not shown.
21 PROJECTBDS/obj/Debug/edmxResourcesToEmbed/Models/Model.csdl
View file
@@ -144,6 +144,7 @@
<NavigationProperty Name="tblNews" Relationship="Self.FK_tblNews_tblDictionary" FromRole="tblDictionary" ToRole="tblNews" />
<NavigationProperty Name="tblNews1" Relationship="Self.FK_tblNews_tblDictionaryTime" FromRole="tblDictionary" ToRole="tblNews" />
<NavigationProperty Name="tblProjectDetail" Relationship="Self.FK_tblProjectDetail_tblDictionary" FromRole="tblDictionary" ToRole="tblProjectDetail" />
<NavigationProperty Name="tblProject" Relationship="LandSoftModel.FK_tblProjectType_tblDictionaryType" FromRole="tblDictionary" ToRole="tblProject" />
</EntityType>
<EntityType Name="tblDistrict">
<Key>
@@ -220,6 +221,8 @@
<NavigationProperty Name="tblProject" Relationship="Self.FK_tblLand_tblProject" FromRole="tblLand" ToRole="tblProject" />
<NavigationProperty Name="tblProvince" Relationship="Self.FK_tblLand_tblProvince" FromRole="tblLand" ToRole="tblProvince" />
<NavigationProperty Name="tblWard" Relationship="Self.FK_tblLand_tblWard" FromRole="tblLand" ToRole="tblWard" />
<Property Name="Bedroom" Type="Int32" />
<Property Name="Bathroom" Type="Int32" />
</EntityType>
<EntityType Name="tblNews">
<Key>
@@ -267,6 +270,8 @@
<NavigationProperty Name="tblLand" Relationship="Self.FK_tblLand_tblProject" FromRole="tblProject" ToRole="tblLand" />
<NavigationProperty Name="tblProvince" Relationship="Self.FK_tblProject_tblProvince" FromRole="tblProject" ToRole="tblProvince" />
<NavigationProperty Name="tblProjectDetail" Relationship="Self.FK_tblProjectDetail_tblProject" FromRole="tblProject" ToRole="tblProjectDetail" />
<Property Name="TypeId" Type="Int32" />
<NavigationProperty Name="tblDictionary" Relationship="LandSoftModel.FK_tblProjectType_tblDictionaryType" FromRole="tblProject" ToRole="tblDictionary" />
</EntityType>
<EntityType Name="tblProjectDetail">
<Key>
@@ -809,6 +814,10 @@
<Parameter Name="String" Mode="In" Type="String" />
<Parameter Name="Delimiter" Mode="In" Type="String" />
</FunctionImport>
<AssociationSet Name="FK_tblProjectType_tblDictionaryType" Association="LandSoftModel.FK_tblProjectType_tblDictionaryType">
<End Role="tblDictionary" EntitySet="tblDictionary" />
<End Role="tblProject" EntitySet="tblProject" />
</AssociationSet>
</EntityContainer>
<EntityType Name="C__MigrationHistory">
<Key>
@@ -858,4 +867,16 @@
<Property Type="Int64" Name="Id" Nullable="true" />
<Property Type="String" Name="Data" Nullable="true" MaxLength="4000" />
</ComplexType>
<Association Name="FK_tblProjectType_tblDictionaryType">
<End Type="LandSoftModel.tblDictionary" Role="tblDictionary" Multiplicity="0..1" />
<End Type="LandSoftModel.tblProject" Role="tblProject" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="tblDictionary">
<PropertyRef Name="Id" />
</Principal>
<Dependent Role="tblProject">
<PropertyRef Name="TypeId" />
</Dependent>
</ReferentialConstraint>
</Association>
</Schema>
3 PROJECTBDS/obj/Debug/edmxResourcesToEmbed/Models/Model.msl
View file
@@ -155,6 +155,8 @@
<EntitySetMapping Name="tblLand">
<EntityTypeMapping TypeName="LandSoftModel.tblLand">
<MappingFragment StoreEntitySet="tblLand">
<ScalarProperty Name="Bathroom" ColumnName="Bathroom" />
<ScalarProperty Name="Bedroom" ColumnName="Bedroom" />
<ScalarProperty Name="Id" ColumnName="Id" />
<ScalarProperty Name="Title" ColumnName="Title" />
<ScalarProperty Name="Desc" ColumnName="Desc" />
@@ -213,6 +215,7 @@
<EntitySetMapping Name="tblProject">
<EntityTypeMapping TypeName="LandSoftModel.tblProject">
<MappingFragment StoreEntitySet="tblProject">
<ScalarProperty Name="TypeId" ColumnName="TypeId" />
<ScalarProperty Name="Id" ColumnName="Id" />
<ScalarProperty Name="Title" ColumnName="Title" />
<ScalarProperty Name="Desc" ColumnName="Desc" />
21 PROJECTBDS/obj/Debug/edmxResourcesToEmbed/Models/Model.ssdl
View file
@@ -186,7 +186,7 @@
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
<Property Name="Id" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
<Property Name="Title" Type="nvarchar" MaxLength="500" />
<Property Name="Desc" Type="nvarchar(max)" />
<Property Name="Content" Type="nvarchar(max)" />
@@ -217,6 +217,8 @@
<Property Name="ymap" Type="nvarchar" MaxLength="500" />
<Property Name="CustomerId" Type="int" />
<Property Name="IsDelete" Type="bit" Nullable="false" />
<Property Name="Bedroom" Type="int" />
<Property Name="Bathroom" Type="int" />
</EntityType>
<EntityType Name="tblNews">
<Key>
@@ -255,6 +257,7 @@
<Property Name="DistrictId" Type="int" />
<Property Name="Price" Type="nvarchar" MaxLength="200" />
<Property Name="Logo" Type="nvarchar" MaxLength="500" />
<Property Name="TypeId" Type="int" />
</EntityType>
<EntityType Name="tblProjectDetail">
<Key>
@@ -662,6 +665,18 @@
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_tblProjectType_tblDictionaryType">
<End Role="tblDictionary" Type="Self.tblDictionary" Multiplicity="0..1" />
<End Role="tblProject" Type="Self.tblProject" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="tblDictionary">
<PropertyRef Name="Id" />
</Principal>
<Dependent Role="tblProject">
<PropertyRef Name="TypeId" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_tblWard_tblDistrict">
<End Role="tblDistrict" Type="Self.tblDistrict" Multiplicity="0..1" />
<End Role="tblWard" Type="Self.tblWard" Multiplicity="*" />
@@ -832,6 +847,10 @@
<End Role="tblProject" EntitySet="tblProject" />
<End Role="tblProjectDetail" EntitySet="tblProjectDetail" />
</AssociationSet>
<AssociationSet Name="FK_tblProjectType_tblDictionaryType" Association="Self.FK_tblProjectType_tblDictionaryType">
<End Role="tblDictionary" EntitySet="tblDictionary" />
<End Role="tblProject" EntitySet="tblProject" />
</AssociationSet>
<AssociationSet Name="FK_tblWard_tblDistrict" Association="Self.FK_tblWard_tblDistrict">
<End Role="tblDistrict" EntitySet="tblDistrict" />
<End Role="tblWard" EntitySet="tblWard" />