public int deleteKhachHang(string id)
{
CommonQuery cq = new CommonQuery();
string query = string.Format($"delete from KHACHHANG where MAKH = '{id}'");
int dt = cq.ExecNonQuery(query);
return(dt);
}
public int deleteNhaPhanPhoi(string id)
{
CommonQuery cq = new CommonQuery();
string query = string.Format($"delete from NHAPHANPHOI where MaNPP = '{id}'");
int dt = cq.ExecNonQuery(query);
return(dt);
}
public int removeKho(string mahanghoa)
{
CommonQuery cq = new CommonQuery();
string query = string.Format($"delete from KHO where MaKho = '{mahanghoa}'");
int dt = cq.ExecNonQuery(query);
return(dt);
}
public int deleteKhuVuc(string id)
{
CommonQuery cq = new CommonQuery();
string query = string.Format($"delete from KHUVUC where MaKhuVuc = '{id}'");
int dt = cq.ExecNonQuery(query);
return(dt);
}
public int removeBangNhomHang(string mahanghoa)
{
CommonQuery cq = new CommonQuery();
string query = string.Format($"delete from BANGNHOMHANG where MaNH = '{mahanghoa}'");
int dt = cq.ExecNonQuery(query);
return(dt);
}
public int removeHangHoa(string mahanghoa)
{
CommonQuery cq = new CommonQuery();
string query = string.Format($"delete from HANGHOA where MaHH = '{mahanghoa}'");
int dt = cq.ExecNonQuery(query);
return(dt);
}
public int removeBangDonVi(string mahanghoa)
{
CommonQuery cq = new CommonQuery();
string query = string.Format($"delete from BANGDONVI where MaDV = '{mahanghoa}'");
int dt = cq.ExecNonQuery(query);
return(dt);
}
public int removeUser(string mahanghoa)
{
CommonQuery cq = new CommonQuery();
string query = string.Format($"delete from Users where userid = '{mahanghoa}'");
int dt = cq.ExecNonQuery(query);
return(dt);
}
public bool updateRoleList(DataTable dataTable)
{
bool r = new bool();
for (int i = 0; i < dataTable.Rows.Count; i++)
{
if (cq.ExecSelectedCount($"select * from Roles where roleID = '{dataTable.Rows[i]["roleID"]}'") > 0)
{
string query = string.Format($"update Roles set rolename=N'{dataTable.Rows[i]["Chức năng"]}' , roledes=N'{dataTable.Rows[i]["roleDes"]}' , rfull='{dataTable.Rows[i]["Tất cả"]}' , raccess='{dataTable.Rows[i]["Truy cập"]}'" +
$" , radd='{dataTable.Rows[i]["Thêm"]}' , redit='{dataTable.Rows[i]["Sửa"]}' , rdelete='{dataTable.Rows[i]["Xóa"]}' , rprint='{dataTable.Rows[i]["In"]}' , rwrite='{dataTable.Rows[i]["Nhập"]}'" +
$" , rread='{dataTable.Rows[i]["Xuất"]}' , isActive='{dataTable.Rows[i]["isActived"]}' where roleID = '{dataTable.Rows[i]["roleID"]}'");
if (cq.ExecNonQuery(query) > 0)
{
r = true;
}
else
{
r = false;
}
}
else
{
string query = string.Format($"insert into Roles (roleid,rolename,roledes,rfull,raccess,radd,redit,rdelete,rprint,rwrite,rread,isactive) values('{dataTable.Rows[i]["roleID"]}',N'{dataTable.Rows[i]["Chức năng"]}',N'{dataTable.Rows[i]["roleDes"]}','{dataTable.Rows[i]["Tất cả"]}','{dataTable.Rows[i]["Truy cập"]}','{dataTable.Rows[i]["Thêm"]}'," +
$"'{dataTable.Rows[i]["Sửa"]}','{dataTable.Rows[i]["Xóa"]}','{dataTable.Rows[i]["In"]}','{dataTable.Rows[i]["Nhập"]}','{dataTable.Rows[i]["Xuất"]}','{dataTable.Rows[i]["isActived"]}' )");
if (cq.ExecNonQuery(query) > 0)
{
r = true;
}
else
{
r = false;
}
}
}
return(r);
}
public int updateUser(DTOUser hanghoa)
{
CommonQuery cq = new CommonQuery();
string query2 = string.Format($"select * from Roles where rolename = '{hanghoa.rolename}'");
DataTable dt2 = cq.GetData(query2);
hanghoa.roleid = dt2.Rows[0]["roleid"].ToString();
string query = string.Format($"update Users set userpassword='******',roleid='{hanghoa.roleid}',isactive='{hanghoa.isactive}' where userid = '{hanghoa.userid}'");
int dt = cq.ExecNonQuery(query);
return(dt);
}
public bool insertUser(DTOUser hanghoa)
{
CommonQuery cq = new CommonQuery();
string query = string.Format($"select * from Users where userid = '{hanghoa.userid}'");
if (cq.ExecSelectedCount(query) > 0)
{
return(false);
}
string query2 = string.Format($"select * from Roles where rolename = '{hanghoa.rolename}'");
DataTable dt2 = cq.GetData(query2);
hanghoa.roleid = dt2.Rows[0]["roleid"].ToString();
query = string.Format($"insert into Users values('{hanghoa.userid}','{hanghoa.username}'," +
$"'{hanghoa.userpassword}','{hanghoa.userfullname}','{hanghoa.roleid}','{hanghoa.isactive}')");
int dt = cq.ExecNonQuery(query);
return(true);
}
