public DiaDiem()
{
ten = new TenDiaDiem();
dichvu = new DichVu();
duong = new Duong();
phuong = new Phuong();
quanhuyen = new QuanHuyen();
tinhthanh = new TinhThanh();
}
public ActionResult DeleteP(int MaPhuong)//Xóa phuong
{
Phuong p = db.Phuong.Find(MaPhuong);
if (p == null)
{
return(HttpNotFound());
}
db.Phuong.Remove(p);
db.SaveChanges();
return(RedirectToAction("Phuong"));
}
public ActionResult CreateP(string TenPhuong, int MaQuan)
{
if (ModelState.IsValid)
{
Phuong p = db.Phuong.SingleOrDefault(x => x.TenPhuong == TenPhuong);
if (p != null)
{
ModelState.AddModelError("", "Phường đã có");
}
else
{
Phuong t = new Phuong();
t.TenPhuong = TenPhuong;
t.MaQuan = MaQuan;
db.Phuong.Add(t);
db.SaveChanges();
return(RedirectToAction("Phuong"));
}
}
return(RedirectToAction("Phuong"));
}
public JsonResult Search(SearchModel entity)
{
List <BaiViet> listBaiViet = new List <BaiViet>();
var res = db.BaiViets.ToList();
//Search Quan
Quan q = db.Quans.Find(entity.idQuan);
Phuong p = db.Phuongs.Find(entity.idPhuong);
KieuBD k = db.KieuBDS.Find(entity.idBDS);
LoaiBD l = db.LoaiBDS.Find(entity.idLoaiBDS);
string temp = "";
if (q == null)
{
temp = "";
}
else
{
temp = q.TenQuan;
}
if (p == null)
{
temp = temp;
}
else
{
temp += " " + p.TenPhuong;
}
if (l == null)
{
temp = temp;
}
else
{
temp += " " + l.TenLoai;
}
if (k == null)
{
temp = temp;
}
else
{
temp += " " + k.TenKieu;
}
var listNT = db.NhaTroes.SqlQuery("select * from NhaTro n where n.SoNha like N'%" + temp + "%'").ToList();
foreach (var item in res)
{
foreach (var item1 in listNT)
{
if (item.idNT == item1.idNT)
{
listBaiViet.Add(item);
}
}
}
//string tempJ = string.Empty;
//tempJ = JsonConvert.SerializeObject(listBaiViet, Formatting.Indented, new JsonSerializerSettings
//{
// ReferenceLoopHandling = ReferenceLoopHandling.Ignore
//});
return(Json(listBaiViet, JsonRequestBehavior.AllowGet));
}
