public void TienCong_Delete(TienCong Data)
{
using (var cmd = new SqlCommand("sp_TienCong_Delete", GetConnection()))
{
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@NoiDungSuaChua", Data.NoiDung));
cmd.ExecuteNonQuery();
connection.Close();
}
}
}
public static void ThayDoiTienCong(TienCong tienCong)
{
DataAccessHelper db = new DataAccessHelper();
SqlCommand cmd = db.Command("THEMTIENCONG");
cmd.Parameters.AddWithValue("@NOIDUNG", tienCong.NoiDung);
cmd.Parameters.AddWithValue("@TIENCONG", tienCong.TienCongXe);
SqlDataAdapter da = new SqlDataAdapter(cmd);
db.dt = new DataTable();
da.Fill(db.dt);
}
private void btnXoa_Click(object sender, EventArgs e)
{
try
{
TienCong tc = new TienCong();
tc.NoiDung = txtNoiDung.Text;
TienCongBUS.TienCong_Delete(tc);
MessageBox.Show("Xóa thành công!!!");
tableDSTienCong.DataSource = TienCongBUS.TienCong_GetAll();
txtNoiDung.Clear();
txtTienCong.Clear();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
btnXoa.Enabled = false;
}
private void btnThem_Click(object sender, EventArgs e)
{
try
{
TienCong tc = new TienCong();
tc.NoiDung = txtNoiDung.Text;
tc.GiaTienCong = double.Parse(txtTienCong.Text);
TienCongBUS.TienCong_Insert(tc);
MessageBox.Show("Thêm thành công!!!");
tableDSTienCong.DataSource = TienCongBUS.TienCong_GetAll();
txtNoiDung.Clear();
txtTienCong.Clear();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
btnXoa.Enabled = false;
}
private void btnSua_Click(object sender, EventArgs e)
{
if (txtTienCong.Text == "")
{
MessageBox.Show("Tiền công không được để trống", "Thông báo");
return;
}
try
{
TienCong tienCong = new TienCong();
tienCong.NoiDung = txtNoiDung.Text;
tienCong.TienCongXe = int.Parse(txtTienCong.Text);
TienCongBLL.ThayDoiTienCong(tienCong);
MessageBox.Show("Thay đổi thành công", "Thông báo");
GetDataGridView();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Thông báo");
}
}
private void btnThem_Click(object sender, EventArgs e)
{
try
{
if (txtNoiDung.Text == "" || txtTienCong.Text == "")
{
MessageBox.Show("Không được để trống tiền công và nội dung", "Thông báo");
}
else
{
TienCong tienCong = new TienCong();
tienCong.NoiDung = txtNoiDung.Text;
tienCong.TienCongXe = int.Parse(txtTienCong.Text);
TienCongBLL.ThemTienCong(tienCong);
MessageBox.Show("Thêm tiền công thành công", "Thông báo");
GetDataGridView();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Thông báo");
}
}
public static void ThemTienCong(TienCong tienCong)
{
TienCongDAL.ThemTienCong(tienCong);
}
public static void ThayDoiTienCong(TienCong tienCong)
{
TienCongDAL.ThayDoiTienCong(tienCong);
}
public static void TienCong_Delete(TienCong Data)
{
db.TienCong_Delete(Data);
}
public static void TienCong_Update(TienCong Data)
{
db.TienCong_Update(Data);
}
public static void TienCong_Insert(TienCong Data)
{
db.TienCong_Insert(Data);
}
