public TinhThanhDTO createTinhThanhFromReader(IDataReader iReader) { TinhThanhDTO p = new TinhThanhDTO(); p.MaTinhThanh = Convert.ToInt32(iReader[_fileds[0]]); p.TenTinhThanh = iReader[_fileds[1]].ToString(); return p; }
public DuLieuDTO() { _duong = new DuongDTO(); _phuong = new PhuongDTO(); _quanHuyen = new QuanHuyenDTO(); _tenDiaDiem = new TenDiaDiemDTO(); _tinhThanh = new TinhThanhDTO(); _dichVu = new DichVuDTO(); }
public TinhThanhDTO getTinhThanhInDulieu(int id) { TinhThanhDTO dv = new TinhThanhDTO(); IDataReader _iReader = base.get(id); if (_iReader.Read()) dv = createTinhThanhFromReader(_iReader); _iReader.Close(); return dv; }
public List<TinhThanhDTO> GetAllRecord() { List<TinhThanhDTO> listrecord = new List<TinhThanhDTO>(); try { SqlConnection connect = new SqlConnection(SqlDataAccess.ConnectionString); connect.Open(); try { object[] allrecord = new object[3]; SqlCommand cmd = new SqlCommand("sp_SelectTINHTHANHsAll", connect); cmd.CommandType = System.Data.CommandType.StoredProcedure; SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { reader.GetValues(allrecord); TinhThanhDTO tt = new TinhThanhDTO(); tt.ID = (int)allrecord.GetValue(0); tt.MaQuocGia = (int)allrecord.GetValue(2); tt.TenTinhThanh = (string)allrecord.GetValue(1); listrecord.Add(tt); } } catch (System.Exception ex) { throw ex; } finally { connect.Close(); } } catch (Exception e) { throw e; } return listrecord; }