public List <KhuVucModel> LayDSHuyen(int maTinh)
{
try
{
using (var session = LOANSessionManager.OpenSession())
{
IDbCommand command = new SqlCommand();
command.Connection = session.Connection;
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "sp_KHU_VUC_LayDSHuyen";
command.Parameters.Add(new SqlParameter("@MaTinh", maTinh));
var dt = new DataTable();
dt.Load(command.ExecuteReader());
if (dt == null)
{
return(null);
}
List <KhuVucModel> rs = new List <KhuVucModel>();
foreach (DataRow item in dt.Rows)
{
KhuVucModel kv = new KhuVucModel();
kv.ID = Convert.ToInt32(item["ID"].ToString());
kv.Ten = item["Ten"].ToString();
rs.Add(kv);
}
return(rs);
}
}
catch (BusinessException ex)
{
throw ex;
}
}
public object Convert(object value, Type targetType, object parameter, CultureInfo culture)
{
KhuVucModel khuVuc = value as KhuVucModel;
if (khuVuc == null)
{
return(Binding.DoNothing);
}
return(khuVuc.TenKhuVuc);
}
public object ConvertBack(object value, Type targetType, object parameter, CultureInfo culture)
{
KhuVucModel castKhuVuc = value as KhuVucModel;
if (castKhuVuc == null)
{
return(Binding.DoNothing);
}
return(castKhuVuc.MaKhuVuc);
}
