public bool CapNhatTiec(Tiec_DTO tiec)
{
SqlConnection conn = ConnectToSQL.HamKetNoi();
string str = "UPDATE TIEC SET Ngaytochuc = @Ngaytochuc, Gia = @Gia WHERE Id = @Id";
SqlCommand cmd = new SqlCommand(str, conn);
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@Id", SqlDbType.NChar, 10);
cmd.Parameters.Add("@Ngaytochuc", SqlDbType.DateTime);
cmd.Parameters.Add("@Gia", SqlDbType.Float);
cmd.Parameters["@Id"].Value = tiec.Id;
cmd.Parameters["@Ngaytochuc"].Value = tiec.Ngaytochuc;
cmd.Parameters["@Gia"].Value = tiec.Gia;
conn.Open();
int t = cmd.ExecuteNonQuery();
if (t < 1)
{
return(false);
}
conn.Close();
return(true);
}
private void btnSua_Click(object sender, EventArgs e)
{
//lay du lieu
string id = txtID.Text;
DateTime ngaytochuc = DateTime.Parse(txtNgayToChuc.Text);
float gia = float.Parse(txtTongTien.Text);
Tiec_DTO t = new Tiec_DTO(id, ngaytochuc, gia);
//xoa
Tiec_BUS t1 = new Tiec_BUS();
t1.CapNhatTiec(t);
//cap nhat danh sach tiec
dataGridViewDSTiec.DataSource = t1.LoadTiec();
//bingding
bingding();
}
public bool ThemTiec(Tiec_DTO tiec)
{
//kiem tra
SqlConnection conn = ConnectToSQL.HamKetNoi();
string str = "SELECT Id FROM TIEC WHERE Id = @Id";
SqlCommand cmd = new SqlCommand(str, conn);
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@Id", SqlDbType.NChar, 10);
cmd.Parameters["@Id"].Value = tiec.Id;
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
int count = 0;
if (reader.Read())
{
count++;
string s = reader.GetString(0);
}
reader.Close();
if (count == 1)
{
return(false);
}
SqlConnection conn1 = ConnectToSQL.HamKetNoi();
string str1 = "INSERT INTO TIEC(Id, Ngaytochuc, Gia) VALUES (@Id, @Ngaytochuc, @Gia)";
SqlCommand cmd1 = new SqlCommand(str1, conn);
cmd1.CommandType = CommandType.Text;
cmd1.Parameters.Add("@Id", SqlDbType.NChar, 10);
cmd1.Parameters.Add("@Ngaytochuc", SqlDbType.DateTime);
cmd1.Parameters.Add("@Gia", SqlDbType.Float);
cmd1.Parameters["@Id"].Value = tiec.Id;
cmd1.Parameters["@Ngaytochuc"].Value = tiec.Ngaytochuc;
cmd1.Parameters["@Gia"].Value = tiec.Gia;
conn1.Open();
cmd1.ExecuteNonQuery();
conn1.Close();
return(true);
}
public bool XoaTiec(Tiec_DTO tiec)
{
SqlConnection conn = ConnectToSQL.HamKetNoi();
string str = "DELETE FROM TIEC WHERE Id = @Id";
SqlCommand cmd = new SqlCommand(str, conn);
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@Id", System.Data.SqlDbType.NChar, 10);
cmd.Parameters["@Id"].Value = tiec.Id;
conn.Open();
int t = cmd.ExecuteNonQuery();
if (t < 1)
{
return(false);
}
conn.Close();
return(true);
}
public bool CapNhatTiec(Tiec_DTO tiec)
{
Tiec_DAO t = new Tiec_DAO();
return(t.CapNhatTiec(tiec));
}
public bool XoaTiec(Tiec_DTO tiec)
{
Tiec_DAO t = new Tiec_DAO();
return(t.XoaTiec(tiec));
}
public bool ThemTiec(Tiec_DTO tiec)
{
Tiec_DAO t = new Tiec_DAO();
return(t.ThemTiec(tiec));
}
