//public DangTinController(IDataContext dataContext, IBIL110050S01DataAccess dataAccess)
// : base(dataContext)
//{
// _dataAccess = dataAccess;
// GetMultiLang();
//}
/// <summary>
/// Data Source=CPP00136655C\SQLEXPRESS;Initial Catalog=BDS_MN;Integrated Security=True
/// </summary>
///
//DangTin[] dangTins = new DangTin[]
// {
// new DangTin {ID = 0, HinhThucDang = "edrgsdg", LoaiTin = "ksldfg", LoaiTaiSan = "lsdkf", TinhThanh = "jsdfhlsda", MaNen = "ksjdhfl", TenDuong = "kjsdfhsad", TenDuAn = "kjfdkdsf", GiaBan = 1223123, MatTien = 5, Hau = 6, ChieuDai = 18, TinhTrangPhapLy = "dat dsad"},
// new DangTin {ID = 0, HinhThucDang = "edrgsdg", LoaiTin = "ksldfg", LoaiTaiSan = "lsdkf", TinhThanh = "jsdfhlsda", MaNen = "ksjdhfl", TenDuong = "kjsdfhsad", TenDuAn = "kjfdkdsf", GiaBan = 1223123, MatTien = 5, Hau = 6, ChieuDai = 18, TinhTrangPhapLy = "dat dsad"},
// new DangTin {ID = 0, HinhThucDang = "edrgsdg", LoaiTin = "ksldfg", LoaiTaiSan = "lsdkf", TinhThanh = "jsdfhlsda", MaNen = "ksjdhfl", TenDuong = "kjsdfhsad", TenDuAn = "kjfdkdsf", GiaBan = 1223123, MatTien = 5, Hau = 6, ChieuDai = 18, TinhTrangPhapLy = "dat dsad"},
// new DangTin {ID = 0, HinhThucDang = "edrgsdg", LoaiTin = "ksldfg", LoaiTaiSan = "lsdkf", TinhThanh = "jsdfhlsda", MaNen = "ksjdhfl", TenDuong = "kjsdfhsad", TenDuAn = "kjfdkdsf", GiaBan = 1223123, MatTien = 5, Hau = 6, ChieuDai = 18, TinhTrangPhapLy = "dat dsad"},
// new DangTin {ID = 0, HinhThucDang = "edrgsdg", LoaiTin = "ksldfg", LoaiTaiSan = "lsdkf", TinhThanh = "jsdfhlsda", MaNen = "ksjdhfl", TenDuong = "kjsdfhsad", TenDuAn = "kjfdkdsf", GiaBan = 1223123, MatTien = 5, Hau = 6, ChieuDai = 18, TinhTrangPhapLy = "dat dsad"}
// };
/// <summary>
/// get connectionstring How to get Connection String from App.Config in C#
/// </summary>
/// <returns></returns>
public ObservableCollection <DangTin> GetAllDangTin()
{
var connectionString = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
const string GetDangTinsQuery = "SELECT * FROM dbo.DangTin";
var dangTins = new ObservableCollection <DangTin>();
//var students = dangTins.FromSql("[GetAllDangTin]").ToList();
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
if (conn.State == System.Data.ConnectionState.Open)
{
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = GetDangTinsQuery;
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
var dangTin = new DangTin();
dangTin.ID = reader.GetInt32(0);
dangTin.HinhThucDang = reader.GetString(1);
dangTin.LoaiTin = reader.GetString(2);
dangTin.LoaiTaiSan = reader.GetString(3);
dangTin.TinhThanh = reader.GetString(4);
dangTin.MaNen = reader.GetString(5);
dangTin.TenDuong = reader.GetString(6);
dangTin.TenDuAn = reader.GetString(7);
dangTin.GiaBan = reader.GetInt32(8);
dangTin.MatTien = reader.GetInt32(9);
dangTin.Hau = reader.GetInt32(10);
dangTin.ChieuDai = reader.GetInt32(11);
dangTin.TinhTrangPhapLy = reader.GetString(12);
dangTin.HinhAnh = reader.GetString(13);
dangTins.Add(dangTin);
}
}
}
}
}
return(dangTins);
}
catch (Exception eSql)
{
Debug.WriteLine("Exception: " + eSql.Message);
}
return(null);
}
public bool Index(DangTin data)
{
//int retry = 0; int max_retry = 5;
var req = new IndexRequest <DangTin>
{
Document = data
};
var re = client.Index(req);
if (re.Result == Result.Created)
{
//id = re.Id;
return(true);
}
return(false);
}
