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