public static bool InsertThiNghiem(ThiNghiem thiNghiem)
{
/*Call method insert city into THANHPHO_DAL layer*/
bool result = ThiNghiem_DAL.InsertThiNghiem(thiNghiem);
return(result);
}
public static List <ThiNghiem> LoadThiNghiem()
{
string query = @"SELECT*FROM THINGHIEM";
DataTable dataTable = new DataTable();//Can destroy.
dataTable = DataProvider.QueryDataReader(query);
ThiNghiem thiNghiem;
if (dataTable != null && dataTable.Rows.Count > 0)
{
List <ThiNghiem> lstThiNghiem = new List <ThiNghiem>();
for (int i = 0; i < dataTable.Rows.Count; i++)
{
thiNghiem = new ThiNghiem();
thiNghiem.MaThiNghiem = dataTable.Rows[i]["ID"].ToString();
thiNghiem.MaVat = dataTable.Rows[i]["MAVAT"].ToString();
thiNghiem.MaDungDich = dataTable.Rows[i]["MADUNGDICH"].ToString();
thiNghiem.ThoiGianThucHien = (DateTime)dataTable.Rows[i]["THOIGIANTHUCHIEN"];
lstThiNghiem.Add(thiNghiem);
}
return(lstThiNghiem);
}
return(null);
}
public static bool InsertThiNghiem(ThiNghiem thiNghiem)
{
/*Set query.*/
string query = String.Format("INSERT INTO THINGHIEM (MATHINGHIEM,MAVAT,MADUNGDICH,THOIGIANTHUCHIEN) VALUES ('{0}','{1}','{2}','{3}')", thiNghiem.MaThiNghiem, thiNghiem.MaVat, thiNghiem.MaDungDich, thiNghiem.ThoiGianThucHien);
bool result = DataProvider.QueryExecuteNonQuery(query);/*Execute query in layer dataprovider.*/
return(result);
}