public int Insert(String name, String description, int rightID, List <MMenhDe> left)
{
if (!Exist(name))
{
String query = "Insert Into " + tableName + "(Name, Description, RightID) Values(N'"
+ name + "',N'"
+ description + "',"
+ rightID.ToString() + ")";
int dem = da.Write(query);
if (dem == 1)
{
// Cap nhat chi tiet luat
CChiTietLuat cct = new CChiTietLuat();
int lastID = GetLastID();
foreach (MMenhDe m in left)
{
cct.Insert(lastID, m.ID);
}
}
return(1);
}
else
{
return(0);
}
}
public int Delete(int id)
{
String query = "Delete " + tableName + " Where ID=" + id;
int dem = da.Write(query);
if (dem == 1)
{
CChiTietLuat cct = new CChiTietLuat();
cct.Delete("RuleID=" + id.ToString());
}
return(dem);
}
public Boolean CanDelete(String id)
{
CLuat cLuat = new CLuat();
if (cLuat.ExitRight(id))
{
return(false);
}
CChiTietLuat cChiTietLuat = new CChiTietLuat();
if (cChiTietLuat.ExistLeft(id))
{
return(false);
}
return(true);
}
public int Delete(String condition)
{
String query = "Delete " + tableName + " Where " + condition;
DataTable tb = da.Read("Select ID From " + tableName + " Where " + condition);
int demTong = 0;
foreach (DataRow r in tb.Rows)
{
String id = r["ID"].ToString();
int dem = Delete(id);
demTong += dem;
if (dem == 1)
{
CChiTietLuat cct = new CChiTietLuat();
cct.Delete("RuleID=" + id.ToString());
}
}
return(demTong);
}
public int Update(int id, String name, String description, int rightID, List <MMenhDe> left)
{
String query = "Update " + tableName + " Set Name=N'"
+ name + "', Description=N'"
+ description + "', RightID="
+ rightID + " Where ID=" + id;
int dem = da.Write(query);
if (dem == 1)
{
MLuat ml = GetByID(id.ToString());
if (ml != null)
{
List <MChiTietLuat> dscu = ml.ChiTietLuat();
List <MMenhDe> dsLeftCu = new List <MMenhDe>();
foreach (MChiTietLuat ct in dscu)
{
dsLeftCu.Add(ct.Left());
}
List <MMenhDe> dsThem = new List <MMenhDe>();
List <MMenhDe> dsXoa = new List <MMenhDe>();
foreach (MMenhDe mdc in dsLeftCu)
{
Boolean found = false;
for (int i = 0; i < left.Count; i++)
{
if (left[i].ID.ToString().Equals(mdc.ID.ToString()))
{
found = true;
}
}
if (!found)
{
dsXoa.Add(mdc);
}
}
foreach (MMenhDe mdm in left)
{
Boolean found = false;
for (int i = 0; i < dsLeftCu.Count; i++)
{
if (dsLeftCu[i].ID.ToString().Equals(mdm.ID.ToString()))
{
found = true;
}
}
if (!found)
{
dsThem.Add(mdm);
}
}
CChiTietLuat cct = new CChiTietLuat();
foreach (MMenhDe md in dsXoa)
{
cct.Delete("RuleID=" + id + " And LeftID=" + md.ID.ToString());
}
foreach (MMenhDe md in dsThem)
{
cct.Insert(id, md.ID);
}
}
}
return(dem);
}