private void BtnThemDanhMuc_Click(object sender, EventArgs e)
{
bool kt = true;
if (TxtTenDanhMuc.Text.Equals(""))
{
label2.ForeColor = Color.Red;
kt = false;
}
else
{
label2.ForeColor = Color.Black;
}
if (kt)
{
try
{
DanhMucDTO dm = new DanhMucDTO();
dm.MaDM = this.MaDM;
dm.TenDM = this.TxtTenDanhMuc.Text;
if (DanhMucDAO.Instance.Update(dm))
{
danhmuc.fillData();
this.Close();
}
}
catch (Exception ex)
{
MessageBox.Show("Không thể sửa danh mục này " + ex.Message);
}
}
}
public DanhMucDTO LayMaDanhMuc(string tenDM)
{
DanhMucDTO DANHMUC = null;
OleDbConnection connection = DataProvider.CreateConnection();
string cmdText = "Select * from DANHMUC where TenDanhMuc like ?";
OleDbCommand command = new OleDbCommand(cmdText, connection);
command.Parameters.Add("@TenDanhMuc", OleDbType.VarWChar);
command.Parameters["@TenDanhMuc"].Value = tenDM;
OleDbDataReader reader = command.ExecuteReader();
while (reader.Read())
{
DANHMUC = new DanhMucDTO();
DANHMUC.MaDanhMuc = (int)reader["MaDanhMuc"];
DANHMUC.TenDanhMuc = (string)reader["TenDanhMuc"];
}
reader.Close();
connection.Close();
return(DANHMUC);
}
private void ResetData()
{
TxtMaDanhMuc.Text = this.MaDM;
DanhMucDTO DM = DanhMucDAO.Instance.GetDanhMuc(this.MaDM);
TxtTenDanhMuc.Text = DM.TenDM;
}
public static bool DanhMuc_ThemSuaXoa(DanhMucDTO dm, int type)
{
string query = "";
switch (type)
{
case 1:
query = "EXEC DanhMuc_Them N'" + dm.Dm_ten + "'," + dm.Dm_trangthai + ",N'" + dm.Dm_ghichu + "'";
break;
case 2:
query = "EXEC DanhMuc_Sua " + dm.Dm_id + ",N'" + dm.Dm_ten + "'," + dm.Dm_trangthai + ",'" + dm.Dm_ghichu + "'";
break;
case 3:
query = "EXEC DanhMuc_Xoa " + dm.Dm_id + "";
break;
}
if (conn.ExcuteQuery(query))
{
return(true);
}
else
{
return(false);
}
}
public DanhMucDTO LayMaDanhMuc(string tenDM)
{
DanhMucDAO dmDAO = new DanhMucDAO();
DanhMucDTO dmDTO = null;
dmDTO = dmDAO.LayMaDanhMuc(tenDM);
return(dmDTO);
}
public static DanhMuc Map(this DanhMucDTO dmDTO)
{
return(new DanhMuc()
{
Id = dmDTO.MaDM,
TenDanhMuc = dmDTO.TenDanhMuc
});
}
public DanhMucDTO LayTenDanhMuc(int maDM)
{
DanhMucDAO dmDAO = new DanhMucDAO();
DanhMucDTO dmDTO = null;
dmDTO = dmDAO.LayTenDanhMuc(maDM);
return(dmDTO);
}
public bool CreateDanhMuc(DanhMucDTO dto)
{
var dm = dto.Map();
try
{
_context.DanhMucs.Add(dm);
_context.SaveChanges();
}
catch (Exception ex)
{
throw new ArgumentException(ex.InnerException == null ? ex.Message : ex.InnerException.Message);
}
return(true);
}
private void btnThem_Click(object sender, EventArgs e)
{
if (txtTenDanhMuc.Text.Length == 0)
{
MessageBox.Show("Bạn Chưa Nhập Tên Danh Mục!", "Cảnh báo!");
}
else
{
DanhMucDTO danhMuc = new DanhMucDTO();
danhMuc.TenDanhMuc = txtTenDanhMuc.Text;
DanhMucBUS.Insert(danhMuc);
MessageBox.Show("Thêm thành công!", "Thông báo!");
this.Refresh();
}
}
public static List <DanhMucDTO> LayDanhMuc()
{
SqlDataReader reader = DataProvider.TruyVanSqlDataReader("LayDanhSachDanhMuc");
List <DanhMucDTO> danhmuc = new List <DanhMucDTO>();
while (reader.Read())
{
DanhMucDTO d = new DanhMucDTO();
d.MaDanhMuc = reader.GetString(0);
d.TenDanhMuc = reader.GetString(1);
danhmuc.Add(d);
}
reader.Close();
return(danhmuc);
}
public static List <DanhMucDTO> DanhMuc_List()
{
DataTable dt = DanhMuc_Load();
List <DanhMucDTO> listDanhMuc = new List <DanhMucDTO>();
for (int i = 0; i < dt.Rows.Count; i++)
{
DanhMucDTO dm = new DanhMucDTO();
dm.Dm_id = int.Parse(dt.Rows[i]["dm_id"].ToString());
dm.Dm_ten = dt.Rows[i]["dm_ten"].ToString();
dm.Dm_trangthai = int.Parse(dt.Rows[i]["dm_trangthai"].ToString());
dm.Dm_ghichu = dt.Rows[i]["dm_ghichu"].ToString();
listDanhMuc.Add(dm);
}
return(listDanhMuc);
}
public static void Insert(DanhMucDTO DANHMUC)
{
OleDbConnection connection = DataProvider.CreateConnection();
string cmdText = "Insert into DANHMUC(TenDanhMuc) values(?)";
OleDbCommand command = new OleDbCommand(cmdText, connection);
command.Parameters.Add("@TenDanhMuc", OleDbType.VarWChar);
command.Parameters["@TenDanhMuc"].Value = DANHMUC.TenDanhMuc;
command.ExecuteNonQuery();
command.CommandText = "select @@IDENTITY";
DANHMUC.MaDanhMuc = (int)command.ExecuteScalar();
connection.Close();
}
public List <DanhMucDTO> DanhSach()
{
List <DanhMucDTO> listDanhMuc = new List <DanhMucDTO>();
openConnection();
string sqlSelect = "SELECT * FROM DanhMucSanPham";
SqlCommand cmd = new SqlCommand(sqlSelect, conn);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
DanhMucDTO danhmuc = new DanhMucDTO(dr["MaDM"].ToString(), dr["TenDM"].ToString());
listDanhMuc.Add(danhmuc);
}
dr.Close();
closeConnection();
return(listDanhMuc);
}
public static IList GetList()
{
ArrayList arrList = new ArrayList();
DanhMucDTO DANHMUC = null;
OleDbConnection connection = DataProvider.CreateConnection();
string cmdText = "Select * from DANHMUC";
OleDbCommand command = new OleDbCommand(cmdText, connection);
OleDbDataReader reader = command.ExecuteReader();
while (reader.Read())
{
DANHMUC = new DanhMucDTO();
DANHMUC.MaDanhMuc = (int)reader["MaDanhMuc"];
DANHMUC.TenDanhMuc = (string)reader["TenDanhMuc"];
arrList.Add(DANHMUC);
}
reader.Close();
connection.Close();
return(arrList);
}
public static bool Modify(DanhMucDTO danhMuc)
{
bool result = false;
OleDbConnection connection = DataProvider.CreateConnection();
string cmdText = "Update DANHMUC set TenDanhMuc = ? where MaDanhMuc = ?";
OleDbCommand command = new OleDbCommand(cmdText, connection);
command.Parameters.Add("@TenDanhMuc", OleDbType.VarWChar);
command.Parameters.Add("@MaDanhMuc", OleDbType.Integer);
command.Parameters["@TenDanhMuc"].Value = danhMuc.TenDanhMuc;
command.Parameters["@MaDanhMuc"].Value = danhMuc.MaDanhMuc;
int row = command.ExecuteNonQuery();
if (row > 0)
{
result = true;
}
return(result);
}
public bool UpdateDanhMuc(DanhMucDTO dto)
{
throw new NotImplementedException();
}
public static void Insert(DanhMucDTO danhMuc)
{
DanhMucDAO.Insert(danhMuc);
}
public static void Modify(DanhMucDTO danhMuc)
{
DanhMucDAO.Modify(danhMuc);
}
