public void MainTest01()
{
Console.WriteLine("Start Test");
InitialiseDatabase.RunOnce();
//InitialiseDatabase.ImportRegionExcel(@"C:\Temp\SystemRegion.xls");
LiveEntities dbEntity = new LiveEntities(ConfigHelper.LiveConnection.Connection);
Guid gUserID = (from u in dbEntity.MemberUsers
where u.LoginName == "test"
select u.Gid).FirstOrDefault();
var oPrivilege1 = (from p in dbEntity.MemberPrivileges
where p.UserID == gUserID && p.Ptype == (byte)ModelEnum.UserPrivType.PROGRAM
select p).FirstOrDefault();
var oProgram = (from p in dbEntity.GeneralPrograms.Include("ProgramNodes")
where p.Code == "ProgramIndex"
select p).FirstOrDefault();
oPrivilege1.PrivilegeItems.Add(
new MemberPrivItem
{
RefID = oProgram.Gid
});
var oPrivilege2 = (from p in dbEntity.MemberPrivileges
where p.UserID == gUserID && p.Ptype == (byte)ModelEnum.UserPrivType.PROGRAM_NODE
select p).FirstOrDefault();
if (oPrivilege2 == null)
{
oPrivilege2 = new MemberPrivilege
{
Ptype = (byte)ModelEnum.UserPrivType.PROGRAM_NODE,
UserID = gUserID,
PrivilegeItems = new List<MemberPrivItem>
{
new MemberPrivItem
{
RefID = oProgram.FindProgramNode("EnableEdit").Gid,
NodeCode = "EnableEdit",
NodeValue = "1"
}
}
};
dbEntity.MemberPrivileges.Add(oPrivilege2);
}
dbEntity.Entry(oPrivilege1).State = EntityState.Modified;
dbEntity.SaveChanges();
}