public bool insertTinChi(Entities.tblTinChi kh)
{
bool check = false;
string sql = "sp_tblTinChi_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("@matinchi", SqlDbType.NVarChar).Value = kh.Matinchi;
cmd.Parameters.Add("@sotinchi", SqlDbType.Int).Value = kh.Sotinchi;
cmd.ExecuteNonQuery();
check = true;
}
catch (Exception ex)
{
ex.ToString();
}
finally
{
cmd.Dispose();
con.Close();
}
return(check);
}
public bool deleteTinChi(Entities.tblTinChi kh)
{
bool check = false;
string sql = "sp_tblTinChi_Delete";
try
{
con = ds.getConnect();
cmd = new SqlCommand(sql, con);
con.Open();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@id", SqlDbType.Int).Value = kh.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 (int.TryParse(txtSoTinChi.Text, out _stc))
{
}
if (CheckObject())
{
Entities.tblTinChi kh = new Entities.tblTinChi();
kh.Id = _ID;
kh.Matinchi = txtMaTinChi.Text;
kh.Sotinchi = _stc;
if (flag == "add")
{
bool check = bllTinChi.insertTinChi(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 = bllTinChi.updateTinChi(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 = bllTinChi.deleteTinChi(kh);
if (check)
{
MessageBox.Show("Xóa thành công.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
ReLoad();
}
ReLoad();
dgvTinChi_SelectionChanged(sender, e);
}
}
public bool deleteTinChi(Entities.tblTinChi tt)
{
return(dal.deleteTinChi(tt));
}
public bool updateTinChi(Entities.tblTinChi tt)
{
return(dal.updateTinChi(tt));
}
public bool insertTinChi(Entities.tblTinChi tt)
{
return(dal.insertTinChi(tt));
}
