public bool insertChamCong(DTO_ChamCong chamcong)
{
try
{
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "sp_InsertDataIntoChamCong";
cmd.Parameters.AddWithValue("maCC", chamcong.maCC);
cmd.Parameters.AddWithValue("maNV", chamcong.maNV);
cmd.Parameters.AddWithValue("thoiGian", chamcong.thoiGian);
cmd.Parameters.AddWithValue("chuThich", chamcong.chuThich);
if (cmd.ExecuteNonQuery() > 0)
{
return(true);
}
}
catch (Exception)
{
}
finally
{
conn.Close();
}
return(false);
}
private void btLuu_Click(object sender, EventArgs e)
{
if (txtMaCC.Text != "" || cmbMaNV.Text != "" || txtChuthich.Text != "")
{
DTO_ChamCong chamcong = new DTO_ChamCong(txtMaCC.Text, cmbMaNV.Text, dTPThoigian.Value, txtChuthich.Text);
if (busChamCong.InsertChamCong(chamcong))
{
MessageBox.Show("Thêm thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
LoadGridView_ChamCong();
CloseTextbox();
}
}
else
{
MessageBox.Show("Xin hãy nhập đầy đủ", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public bool InsertChamCong(DTO_ChamCong chamcong)
{
return(dalChamCong.insertChamCong(chamcong));
}
