public ActionResult Index()
{
try
{
DataProvider dp = new DataProvider();
string sql= @"SELECT *
FROM duong
ORDER BY tenduong";
DataTable dt = new DataTable();
dt = dp.ExecuteQuery(sql);
List<Duong> ls = new List<Duong>();
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
Duong item = new Duong();
item.MaDuong = (int)dt.Rows[i]["maduong"];
item.TenDuong = (string)dt.Rows[i]["tenduong"];
item.MaQuan = (int)dt.Rows[i]["maquan"];
ls.Add(item);
}
}
return PartialView("~/Views/Shared/Duong.cshtml", ls);
}
catch (Exception ex)
{
return PartialView("~/Views/Shared/Duong.cshtml");
}
}
public static List<Duong> ListDuong()
{
List<Duong> ls = new List<Duong>();
try
{
DataProvider dp = new DataProvider();
string sql = @"SELECT *
FROM duong
ORDER BY maduong";
DataTable dt = new DataTable();
dt = dp.ExecuteQuery(sql);
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
Duong item = new Duong();
item.MaDuong = (int)dt.Rows[i]["maduong"];
item.TenDuong = (string)dt.Rows[i]["tenduong"];
item.MaQuan = (int)dt.Rows[i]["maquan"];
ls.Add(item);
}
}
return ls;
}
catch (Exception ex)
{
return ls;
}
}
public void Index(string type, int ma)
{
DataProvider dp = new DataProvider();
type = type.Trim().ToLower();
if (type.CompareTo("loaddsquan") == 0)
{
//Load danh sach thanh pho
string sql = @"SELECT * FROM quan WHERE mathanhpho = " + ma;
DataTable dt = new DataTable();
dt = dp.ExecuteQuery(sql);
List<Quan> dsQuan = new List<Quan>();
Response.Write("<option value='0'>Tất cả</option>");
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
Quan item = new Quan();
item.MaQuan = (int)dt.Rows[i]["maquan"];
item.TenQuan = dt.Rows[i]["tenquan"].ToString();
item.MaThanhPho = (int)dt.Rows[i]["mathanhpho"];
dsQuan.Add(item);
Response.Write("<option value='" + item.MaQuan.ToString() + "'>" + item.TenQuan + "</option>");
}
}
}
else if (type.CompareTo("loaddsduong") == 0)
{
//Load danh sach Duong
string sql = @"SELECT * FROM duong WHERE maquan = " + ma;
DataTable dt = new DataTable();
dt = dp.ExecuteQuery(sql);
List<Duong> dsDuong = new List<Duong>();
Response.Write("<option value='0'>Tất cả</option>");
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
Duong item = new Duong();
item.MaDuong = (int)dt.Rows[i]["maduong"];
item.TenDuong = dt.Rows[i]["tenduong"].ToString();
item.MaQuan = (int)dt.Rows[i]["maquan"];
dsDuong.Add(item);
Response.Write("<option value='" + item.MaDuong.ToString() + "'>" + item.TenDuong + "</option>");
}
}
}
}
public ActionResult ListDuong(int maquan)
{
try
{
DataProvider dp = new DataProvider();
string sql = @"SELECT *
FROM duong
WHERE maquan = " + maquan.ToString() + @"
ORDER BY maduong";
DataTable dt = new DataTable();
dt = dp.ExecuteQuery(sql);
List<Duong> ls = new List<Duong>();
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
Duong item = new Duong();
item.MaDuong = (int)dt.Rows[i]["maduong"];
item.TenDuong = (string)dt.Rows[i]["tenduong"];
item.MaQuan = (int)dt.Rows[i]["maquan"];
ls.Add(item);
}
}
return Json(ls);
}
catch (Exception ex)
{
return null;
}
}
