public static List <LichSu> LoadLichSu()
{
string query = @"SELECT*FROM LICHSU";
DataTable dataTable = new DataTable();//Can destroy.
dataTable = DataProvider.QueryDataReader(query);
LichSu lichSu;
if (dataTable != null && dataTable.Rows.Count > 0)
{
List <LichSu> lstLichSu = new List <LichSu>();
for (int i = 0; i < dataTable.Rows.Count; i++)
{
lichSu = new LichSu();
lichSu.MaLichSu = dataTable.Rows[i]["MALICHSU"].ToString();
lichSu.DoCaoBanDau = dataTable.Rows[i]["DOCAOBANDAU"].ToString();
lichSu.BanKinh = dataTable.Rows[i]["BANKINH"].ToString();
lichSu.KhoiLuongRiengChat = dataTable.Rows[i]["KHOILUONGRIENGCHAT"].ToString();
lichSu.KhoiLuongRiengVat = dataTable.Rows[i]["kHOILUONGRIENGVAT"].ToString();
lichSu.ThoiGianTongHop = dataTable.Rows[i]["THOIGIANTONGHOP"].ToString();
lstLichSu.Add(lichSu);
}
return(lstLichSu);
}
return(null);
}
public static bool InsertLichSu(LichSu lichSu)
{
/*Call method insert city into THANHPHO_DAL layer*/
bool result = LichSu_DAL.InsertLichSu(lichSu);
return(result);
}
public static bool InsertLichSu(LichSu lichSu)
{
/*Set query.*/
string query = String.Format("INSERT INTO LICHSU (MALICHSU,DOCAOBANDAU,BANKINH,KHOILUONGRIENGCHAT,KHOILUONGRIENGVAT, THOIGIANTONGHOP) VALUES ('{0}','{1}','{2}','{3}','{4}', '{5}')", lichSu.MaLichSu, lichSu.DoCaoBanDau, lichSu.BanKinh, lichSu.KhoiLuongRiengChat, lichSu.KhoiLuongRiengVat, lichSu.ThoiGianTongHop);
bool result = DataProvider.QueryExecuteNonQuery(query);/*Execute query in layer dataprovider.*/
return(result);
}
private void AddHistory()
{
try
{
maLichSu = int.Parse(LichSu_DAL.quantityElement().Substring(3)) + 1;
LichSu newLichSu = new LichSu();
newLichSu.MaLichSu = IDLichSu + maLichSu;
newLichSu.DoCaoBanDau = docaobandau.ToString();
newLichSu.BanKinh = khoicau.R.ToString();
newLichSu.KhoiLuongRiengChat = khoiluongriengchatlong.ToString();
newLichSu.KhoiLuongRiengVat = khoiluongriengvat.ToString();
newLichSu.ThoiGianTongHop = khoicau.time.ToString();
bool result = LichSu_BUL.InsertLichSu(newLichSu);
}
catch (Exception ex)
{
Console.Write(ex.ToString());
MessageBox.Show("Invalid dang an oshi!");
}
}