public bool insertChucVu(Entities.tblChucVu cv)
{
bool check = false;
string sql = "sp_tblChucVu_Insert";
try
{
con = ds.getConnect();
cmd = new SqlCommand(sql, con);
con.Open();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = sql;
cmd.Connection = con;
cmd.Parameters.Add("@maChucVu", SqlDbType.NVarChar).Value = cv.Machucvu;
cmd.Parameters.Add("@tenChucVu", SqlDbType.NVarChar).Value = cv.Tenchucvu;
cmd.ExecuteNonQuery();
check = true;
}
catch (Exception ex)
{
ex.ToString();
}
finally
{
cmd.Dispose();
con.Close();
}
return(check);
}
public bool deleteChucVu(Entities.tblChucVu cv)
{
bool check = false;
string sql = "sp_tblChucVu_Delete";
try
{
con = ds.getConnect();
cmd = new SqlCommand(sql, con);
con.Open();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@id", SqlDbType.Int).Value = cv.Id;
cmd.ExecuteNonQuery();
check = true;
}
catch (Exception ex)
{
ex.ToString();
}
finally
{
cmd.Dispose();
con.Close();
}
return(check);
}
private void btnSave_Click(object sender, EventArgs e)
{
if (int.TryParse(lblID.Text, out _ID))
{
}
if (CheckObject())
{
Entities.tblChucVu kh = new Entities.tblChucVu();
kh.Id = _ID;
kh.Machucvu = txtMaChucVu.Text;
kh.Tenchucvu = txtTenChucVu.Text;
if (flag == "add")
{
bool check = bllChucVu.insertChucVu(kh);
if (check)
{
MessageBox.Show("Thêm thành công.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
ReLoad();
}
else if (flag == "update")
{
bool check = bllChucVu.updateChucVu(kh);
if (check)
{
MessageBox.Show("Cập nhật thành công.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
ReLoad();
}
else if (flag == "delete")
{
bool check = bllChucVu.deleteChucVu(kh);
if (check)
{
MessageBox.Show("Xóa thành công.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
ReLoad();
}
ReLoad();
dgvChucVu_SelectionChanged(sender, e);
}
}
public bool deleteChucVu(Entities.tblChucVu kh)
{
return(dal.deleteChucVu(kh));
}
public bool updateChucVu(Entities.tblChucVu kh)
{
return(dal.updateChucVu(kh));
}
public bool insertChucVu(Entities.tblChucVu kh)
{
return(dal.insertChucVu(kh));
}
