public void AddPriviladges(Priviladge privObj) { try { Priviladge tempObj = new Priviladge(); tempObj.Id = privObj.Id; tempObj.ProgramCode = privObj.ProgramCode; tempObj.Role = privObj.Role; tempObj.RoleId = privObj.RoleId; #region Attach Program DataModel.Program tempPrgrm = new DataModel.Program(); tempPrgrm.Name = privObj.Program.Name; tempPrgrm.ProgramCode = privObj.Program.ProgramCode; tempPrgrm.Description = privObj.Program.Description; tempObj.Program = tempPrgrm; #endregion Priviladges.Add(tempObj); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public void SaveNewExperiment(string dbFile, string url, string CpuName, string CpuMHz, string FPU, string Memory, string OS, string Compiler, string ProgramName, decimal BaseRefTime, decimal BaseRunTime) { using (var db = new SPECCPUDB_Mine(new LinqToDB.DataProvider.SQLite.SQLiteDataProvider(), String.Format(@"Data Source={0}", dbFile))) { long EnvID = getEnv(db, CpuName, CpuMHz, FPU, Memory, OS, Compiler); if (EnvID < 0) { var newEnv = new DataModel.Environment(); newEnv.Compiler = Compiler; newEnv.CpuMHz = CpuMHz; newEnv.CpuName = CpuName; newEnv.FPU = FPU; newEnv.Memory = Memory; newEnv.OS = OS; db.Insert(newEnv); EnvID = getEnv(db, CpuName, CpuMHz, FPU, Memory, OS, Compiler); } long ProgID = getProg(db, ProgramName); if (ProgID<0) { var p = new DataModel.Program(); p.Name = ProgramName; db.Insert(p); ProgID = getProg(db, ProgramName); } var expID = getExp(db, url, EnvID, ProgID, BaseRefTime, BaseRunTime); if (expID < 0) { var exp = new DataModel.Experiment(); exp.url = url; exp.EnvID = EnvID; exp.ProgID = ProgID; exp.BaseRefTime = BaseRefTime; exp.BaseRunTime = BaseRunTime; db.Insert(exp); } } }
public void SaveNewExperiment(string dbFile, string url, string CpuName, string CpuMHz, string FPU, string Memory, string OS, string Compiler, string ProgramName, decimal BaseRefTime, decimal BaseRunTime) { using (var db = new SPECCPUDB_Mine(new LinqToDB.DataProvider.SQLite.SQLiteDataProvider(), String.Format(@"Data Source={0}", dbFile))) { long EnvID = getEnv(db, CpuName, CpuMHz, FPU, Memory, OS, Compiler); if (EnvID < 0) { var newEnv = new DataModel.Environment(); newEnv.Compiler = Compiler; newEnv.CpuMHz = CpuMHz; newEnv.CpuName = CpuName; newEnv.FPU = FPU; newEnv.Memory = Memory; newEnv.OS = OS; db.Insert(newEnv); EnvID = getEnv(db, CpuName, CpuMHz, FPU, Memory, OS, Compiler); } long ProgID = getProg(db, ProgramName); if (ProgID < 0) { var p = new DataModel.Program(); p.Name = ProgramName; db.Insert(p); ProgID = getProg(db, ProgramName); } var expID = getExp(db, url, EnvID, ProgID, BaseRefTime, BaseRunTime); if (expID < 0) { var exp = new DataModel.Experiment(); exp.url = url; exp.EnvID = EnvID; exp.ProgID = ProgID; exp.BaseRefTime = BaseRefTime; exp.BaseRunTime = BaseRunTime; db.Insert(exp); } } }