public DiemTrungChuyenDTO getInforPointStartByID(string pointStartID)
{
SqlParameter[] sqlParameters = new SqlParameter[] {
new SqlParameter("@madiemtrungchuyen", pointStartID)
};
DiemTrungChuyenDTO diemTrungChuyenDTO = new DiemTrungChuyenDTO();
DataTable dt = DataProvider.Instance.GetData("sp_getInfoPointStartById", sqlParameters);
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
diemTrungChuyenDTO.madiemtrungchuyen = dr["madiemtrungchuyen"].ToString();
diemTrungChuyenDTO.tendiemtrungchuyen = dr["tendiemtrungchuyen"].ToString();
diemTrungChuyenDTO.diachi = dr["diachi"].ToString();
diemTrungChuyenDTO.thutu = int.Parse(dr["thutu"].ToString());
}
return(diemTrungChuyenDTO);
}
public List <DiemTrungChuyenDTO> GetDiemTrungChuyens(string malotrinh)
{
List <DiemTrungChuyenDTO> diemTrungChuyens = new List <DiemTrungChuyenDTO>();
String sql = "SELECT DISTINCT dt.*" +
" FROM DiemTrungChuyen dt" +
" JOIN TinhThanh th ON dt.matinh = dt.matinh" +
" JOIN ChiTietLoTrinh ct ON ct.idtinhthanh = dt.matinh" +
" AND ct.idtinhthanh = dt.matinh" +
" WHERE ct.malotrinh = @malotrinh";
SqlCommand command = DataProvider.Instance.getCommand(sql);
command.Parameters.AddWithValue("@malotrinh", malotrinh);
SqlDataReader rowsAffected = command.ExecuteReader();
int indexMadiemtrungchuyen = rowsAffected.GetOrdinal("madiemtrungchuyen");
int indexDiaChi = rowsAffected.GetOrdinal("diachi");
int indexMaTinh = rowsAffected.GetOrdinal("matinh");
int indextenDiemTrungChuyen = rowsAffected.GetOrdinal("tendiemtrungchuyen");
int indexLat = rowsAffected.GetOrdinal("lat");
int indexLong = rowsAffected.GetOrdinal("long");
int indexThuTu = rowsAffected.GetOrdinal("thutu");
if (rowsAffected.HasRows)
{
while (rowsAffected.Read())
{
DiemTrungChuyenDTO diemTrungChuyen = new DiemTrungChuyenDTO();
diemTrungChuyen.madiemtrungchuyen = rowsAffected.GetString(indexMadiemtrungchuyen);
diemTrungChuyen.matinh = rowsAffected.IsDBNull(indexMaTinh) ? "" : rowsAffected.GetString(indexMaTinh);
diemTrungChuyen.tendiemtrungchuyen = rowsAffected.IsDBNull(indextenDiemTrungChuyen) ? "" : rowsAffected.GetString(indextenDiemTrungChuyen);
diemTrungChuyen.diachi = rowsAffected.IsDBNull(indexDiaChi) ? "" : rowsAffected.GetString(indexDiaChi);
diemTrungChuyen.lat = rowsAffected.IsDBNull(indexLat) ? "" : rowsAffected.GetString(indexLat);
diemTrungChuyen.longt = rowsAffected.IsDBNull(indexLong) ? "" : rowsAffected.GetString(indexLong);
diemTrungChuyen.thutu = rowsAffected.IsDBNull(indexThuTu) ? -1 : rowsAffected.GetInt32(indexThuTu);
diemTrungChuyens.Add(diemTrungChuyen);
}
}
return(diemTrungChuyens);
}
public List <DiemTrungChuyenDTO> getListDiemTrungChuyen(string malotrinh)
{
SqlParameter[] sqlParameters = new SqlParameter[] {
new SqlParameter("@malotrinh", malotrinh)
};
List <DiemTrungChuyenDTO> list = new List <DiemTrungChuyenDTO>();
DataTable dt = DataProvider.Instance.GetData("sp_listdiemtrungchuyen", sqlParameters);
foreach (DataRow dr in dt.Rows)
{
DiemTrungChuyenDTO diemTrungChuyenDTO = new DiemTrungChuyenDTO();
diemTrungChuyenDTO.madiemtrungchuyen = dr["madiemtrungchuyen"].ToString();
diemTrungChuyenDTO.tendiemtrungchuyen = dr["tendiemtrungchuyen"].ToString();
diemTrungChuyenDTO.diachi = dr["diachi"].ToString();
diemTrungChuyenDTO.matinh = dr["matinh"].ToString();
diemTrungChuyenDTO.thutu = int.Parse(dr["thutu"].ToString());
// diemTrungChuyenDTO.tentinh = dr["tentinh"].ToString();
list.Add(diemTrungChuyenDTO);
}
return(list);
}
