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 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);
}