public bool InsertPhieuTiem(DTO_PhieuTiem pt)
{
try
{
_conn.Open();
string SQL = "INSERT INTO PHIEUTIEM " +
"(MAPHIEUTIEM, NGAYTIEM, MAKH, DATIEM) " +
"VALUES " +
"(@MAPHIEUTIEM, @NGAYTIEM, @MAKH, @DATIEM)";
SqlCommand cmd = new SqlCommand(SQL, _conn);
cmd.Parameters.AddWithValue("@MAPHIEUTIEM", pt.MAPHIEUTIEM);
cmd.Parameters.AddWithValue("@NGAYTIEM", pt.NGAYTIEM);
cmd.Parameters.AddWithValue("@MAKH", pt.MAKH);
cmd.Parameters.AddWithValue("@DATIEM", pt.DATIEM);
if (cmd.ExecuteNonQuery() > 0)
{
return(true);
}
//_conn.Open();
//SqlCommand cmd = new SqlCommand("sp_InsertPhieuTiem", _conn);
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("@MAPHIEUTIEM", pt.MAPHIEUTIEM);
//cmd.Parameters.AddWithValue("@NGAYTIEM", pt.NGAYTIEM);
//cmd.Parameters.AddWithValue("@MAKH", pt.MAKH);
//cmd.Parameters.AddWithValue("@MABS", pt.MABS);
//if (cmd.ExecuteNonQuery() > 0)
//{
// return true;
//}
}
catch (Exception)
{
}
finally
{
_conn.Close();
}
return(false);
}
public bool InsertPhieuTiem(DTO_PhieuTiem pt)
{
return(dao.InsertPhieuTiem(pt));
}
