public static List<XeMat> TimXeTheoCMND_List(string CMND)
{
using (DataSetOBJTableAdapters.SP_TimTheoCMNDTableAdapter Adap = new DataSetOBJTableAdapters.SP_TimTheoCMNDTableAdapter { Connection = new System.Data.SqlClient.SqlConnection(ConnectString) })
{
Adap.Fill(DataSet.SP_TimTheoCMND, CMND);
List<XeMat> ListResult = new List<XeMat>();
foreach (System.Data.DataRow i in DataSet.SP_TimTheoCMND)
{
XeMat OBJ = new XeMat();
OBJ.BienSoXe = i[0].ToString();
OBJ.SoMay = i[1].ToString();
OBJ.SoKhung = i[2].ToString();
OBJ.LoaiXe = i[3].ToString();
OBJ.MauXe = i[4].ToString();
OBJ.CMNDSoHuu = i[5].ToString();
OBJ.NoiDangKy = i[6].ToString();
OBJ.DaTimThay = (bool)i[7];
ListResult.Add(OBJ);
}
return ListResult;
}
}
public static bool ThemXe(XeMat Xe, ChuXe People)
{
try
{
using(DataSetOBJTableAdapters.QueriesTableAdapter Adap = new DataSetOBJTableAdapters.QueriesTableAdapter())
Adap.SP_ThemXe
(
Xe.BienSoXe, Xe.SoMay, Xe.SoKhung, Xe.LoaiXe,
Xe.MauXe, People.CMNDSoHuu, Xe.NoiDangKy,
People.HoTen, People.DiaChi, People.DienThoai, People.NgaySinh
);
return true;
}
catch
{
return false;
}
}
