public bool ADD(ChamCongCS chamcong)
{
string sql = @"insert into ChamCong values(@mcc,@mnv,@trangthai,@thang,@nam)";
SqlConnection cn = new SqlConnection(connectionString);
SqlCommand cmd = new SqlCommand(sql, cn);
cmd.Parameters.AddWithValue("@mcc", chamcong.Mcc);
cmd.Parameters.AddWithValue("@mnv", chamcong.Mnv);
cmd.Parameters.AddWithValue("@trangthai", chamcong.Trangthai);
cmd.Parameters.AddWithValue("@thang", chamcong.Thang);
cmd.Parameters.AddWithValue("@nam", chamcong.Nam);
cn.Open();
int dem = cmd.ExecuteNonQuery();
cn.Close();
return(dem >= 1);
}
protected void btncapnhat_Click(object sender, EventArgs e)
{
string mcc = Txtmacc.Text;
// ép kiểu mnv.
int mnv = int.Parse(Ddlmanv.SelectedValue.ToString());
string trangthai = Ddltrangthai.SelectedValue.ToString();
string thang = ddlthang.SelectedValue.ToString();
string nam = txtnam.Text;
ChamCongCS cc = new ChamCongCS(mcc, mnv, trangthai, thang, nam);
if (qlchamcong.ADD(cc))
{
lbthongbao.Text = "Thêm thành công!";
GVNV.DataSource = qlchamcong.getTalbe("select * from ChamCong");
GVNV.DataBind();
}
else
{
lbthongbao.Text = "Thêm thất bại";
}
}