public bool XoaChucDanh(string Id)
{
ChucDanhDTO ChucDanh = new ChucDanhDTO();
ChucDanh.Id = int.Parse(Id);
return(ChucDanhDAO.Instance.XoaChucDanh(ChucDanh));
}
public BindingList <ChucDanhDTO> LayDanhSach()
{
BindingList <ChucDanhDTO> danhSach = new BindingList <ChucDanhDTO>();
OleDbConnection cn;
cn = DataProvider.KetNoi();
string strSQL;
strSQL = "Select * From SysDanhMucChucDanh";
OleDbCommand cmd = new OleDbCommand(strSQL, cn);
OleDbDataReader dr;
dr = cmd.ExecuteReader();
while (dr.Read())
{
ChucDanhDTO itemDTO = new ChucDanhDTO();
itemDTO.Id = (int)dr["Id"];
itemDTO.MaChucDanh = (string)dr["MaChucDanh"];
itemDTO.TenChucDanh = (string)dr["TenChucDanh"];
itemDTO.GhiChu = (string)dr["GhiChu"];
danhSach.Add(itemDTO);
}
return(danhSach);
}
public bool XoaChucDanh(ChucDanhDTO chucDanh)
{
string[] param = { "@ID" };
object[] values = { chucDanh.Id };
string query = "Delete ChucDanh Where ID=@ID";
return(DataProvider.Instance.ExecuteNonQueryPara(query, param, values));
}
public bool SuaChucDanh(ChucDanhDTO chucDanh)
{
string[] param = { "@ID", "@Ten" };
object[] values = { chucDanh.Id, chucDanh.Ten };
string query = "Update ChucDanh Set Ten=@Ten Where ID=@ID";
return(DataProvider.Instance.ExecuteNonQueryPara(query, param, values));
}
public bool ThemChucDanh(ChucDanhDTO chucDanh)
{
string[] param = { "@Ten" };
object[] values = { chucDanh.Ten };
string query = "Insert Into ChucDanh Values(@Ten)";
return(DataProvider.Instance.ExecuteNonQueryPara(query, param, values));
}
public bool ThemChucDanh(string TenChucDanh)
{
ChucDanhDTO ChucDanh = new ChucDanhDTO();
try
{
ChucDanh.Ten = TenChucDanh;
}
catch (Exception)
{
return(false);
}
return(ChucDanhDAO.Instance.ThemChucDanh(ChucDanh));
}
public bool SuaChucDanh(string Id, string TenChucDanh)
{
ChucDanhDTO ChucDanh = new ChucDanhDTO();
try
{
ChucDanh.Id = int.Parse(Id);
ChucDanh.Ten = TenChucDanh;
}
catch (Exception)
{
return(false);
}
return(ChucDanhDAO.Instance.SuaChucDanh(ChucDanh));
}
private void gvDanhMucChuDanh_RowUpdated(object sender, DevExpress.XtraGrid.Views.Base.RowObjectEventArgs e)
{
if (gvDanhMucChuDanh.FocusedRowHandle > -1)
{
try
{
ChucDanhDTO itemDTO = new ChucDanhDTO();
ChucDanhBUS itemBUS = new ChucDanhBUS();
itemDTO.MaChucDanh = gvDanhMucChuDanh.GetFocusedRowCellValue("MaChucDanh").ToString();
itemDTO.TenChucDanh = gvDanhMucChuDanh.GetFocusedRowCellValue("TenChucDanh").ToString();
itemDTO.GhiChu = gvDanhMucChuDanh.GetFocusedRowCellValue("GhiChu").ToString();
itemDTO.Id = int.Parse(gvDanhMucChuDanh.GetFocusedRowCellValue("Id").ToString());
if (this.flagThem && gvDanhMucChuDanh.FocusedRowHandle == gvDanhMucChuDanh.RowCount - 2)
{
if (itemDTO.MaChucDanh.Length > 0)
{
DialogResult hopThoai = MessageBox.Show("Bạn chắc chắn muốn thêm mới?", "Thêm mới", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (hopThoai == DialogResult.Yes)
{
itemBUS.Them(itemDTO);
this.flagThem = false;
}
}
else
{
MessageBox.Show("Bạn chưa nhập mã!", "Cảnh báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
else
{
DialogResult hopThoai = MessageBox.Show("Bạn chắc chắn muốn cập nhật?", "Cập nhật", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (hopThoai == DialogResult.Yes)
{
itemBUS.Sua(itemDTO);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
this.LayDanhSachChucDanh();
}
}
/*
* public BindingList<ChucDanhDTO> LayDanhSachCombobox()
* {
* BindingList<ChucDanhDTO> danhSach = new BindingList<ChucDanhDTO>();
* OleDbConnection cn;
* cn = DataProvider.KetNoi();
* string strSQL;
* strSQL = "Select * From DanhMucChucDanh";
* OleDbCommand cmd = new OleDbCommand(strSQL, cn);
* OleDbDataReader dr;
* dr = cmd.ExecuteReader();
* while (dr.Read())
* {
* ChucDanhDTO itemDTO = new ChucDanhDTO();
*
* itemDTO.Id = (int)dr["Id"];
* itemDTO.MaChucDanh = (string)dr["MaChucDanh"];
* itemDTO.TenChucDanh = (string)dr["TenChucDanh"];
* itemDTO.GhiChu = (string)dr["GhiChu"];
*
* danhSach.Add(itemDTO);
* }
* return danhSach;
* }
*/
public void Them(ChucDanhDTO itemDTO)
{
OleDbConnection cn;
cn = DataProvider.KetNoi();
string strSQL;
strSQL = "Insert into SysDanhMucChucDanh (MaChucDanh,TenChucDanh,GhiChu) values (?, ?, ?)";
OleDbCommand cmd = new OleDbCommand(strSQL, cn);
cmd.Parameters.Add("@MaChucDanh", OleDbType.WChar).Value = itemDTO.MaChucDanh;
cmd.Parameters.Add("@TenChucDanh", OleDbType.WChar).Value = itemDTO.TenChucDanh;
cmd.Parameters.Add("@GhiChu", OleDbType.WChar).Value = itemDTO.GhiChu;
cmd.ExecuteNonQuery();
cn.Close();
}
public void Sua(ChucDanhDTO itemDTO)
{
OleDbConnection cn;
cn = DataProvider.KetNoi();
string strSQL;
strSQL = "Update SysDanhMucChucDanh Set MaChucDanh = ?, TenChucDanh = ?, GhiChu = ? Where Id = ?";
OleDbCommand cmd = new OleDbCommand(strSQL, cn);
cmd.Parameters.Add("@MaChucDanh", OleDbType.WChar).Value = itemDTO.MaChucDanh;
cmd.Parameters.Add("@TenChucDanh", OleDbType.WChar).Value = itemDTO.TenChucDanh;
cmd.Parameters.Add("@GhiChu", OleDbType.WChar).Value = itemDTO.GhiChu;
cmd.Parameters.Add("@Id", OleDbType.Numeric).Value = itemDTO.Id;
cmd.ExecuteNonQuery();
cn.Close();
}
public void Sua(ChucDanhDTO itemDTO)
{
ChucDanhDAO itemDAO = new ChucDanhDAO();
itemDAO.Sua(itemDTO);
}
public void Them(ChucDanhDTO itemDTO)
{
ChucDanhDAO itemDAO = new ChucDanhDAO();
itemDAO.Them(itemDTO);
}