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