public int insert(int mabangthongke, int maNV, DateTime date)
{
BangThongKeGopYDTO bangThongKeGopYDTO = new BangThongKeGopYDTO
{
maBangThongKe = mabangthongke,
maNVLap = maNV,
ngayLap = date
};
return(bangThongKeGopYDAO.InsertBANGTHONGKE(bangThongKeGopYDTO));
}
public int InsertBANGTHONGKE(BangThongKeGopYDTO bangThongKeGopYDTO)
{
String query = "INSERT INTO BANGTHONGKEGOPY (MANVLAP, NGAYLAP) OUTPUT INSERTED.MABANGTHONGKE VALUES (@MANVLAP, @NGAYLAP)";
List <SqlParameter> sqlParameters = new List <SqlParameter>
{
// sqlParameters.Add(new SqlParameter("@MABANGTHONGKE", bangThongKeGopYDTO.maBangThongKe));
new SqlParameter("@MANVLAP", bangThongKeGopYDTO.maNVLap),
new SqlParameter("@NGAYLAP", bangThongKeGopYDTO.ngayLap)
};
var mabtk = this.dp.ExecuteScalar(query, sqlParameters);
return(mabtk);
}
public List <BangThongKeGopYDTO> getAllBangThongKeGopY()
{
String query = "SELECT * FROM BANGTHONGKEGOPY";
DataTable dt = this.dp.ExecuteQuery(query);
List <BangThongKeGopYDTO> lst = new List <BangThongKeGopYDTO>();
foreach (DataRow dr in dt.Rows)
{
try
{
BangThongKeGopYDTO bangThongKeGopYDTO = new BangThongKeGopYDTO((int)dr["MABANGTHONGKE"], (int)dr["MANVLAP"], (DateTime)dr["NGAYLAP"]);
lst.Add(bangThongKeGopYDTO);
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
return(lst);
}
