- Timestamp:
- 09/24/10 06:53:43 (14 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/OKB/HeuristicLab.Services.OKB/3.3/AdminService.cs
r4467 r4481 43 43 } 44 44 } 45 public void StorePlatform(DataTransfer.Platform dto) { 45 public long AddPlatform(DataTransfer.Platform dto) { 46 using (OKBDataContext okb = new OKBDataContext()) { 47 DataAccess.Platform entity = Convert.ToEntity(dto); entity.Id = 0; 48 okb.Platforms.InsertOnSubmit(entity); 49 okb.SubmitChanges(); 50 return entity.Id; 51 } 52 } 53 public void UpdatePlatform(DataTransfer.Platform dto) { 46 54 using (OKBDataContext okb = new OKBDataContext()) { 47 55 DataAccess.Platform entity = okb.Platforms.FirstOrDefault(x => x.Id == dto.Id); 48 if (entity == null) okb.Platforms.InsertOnSubmit(Convert.ToEntity(dto)); 49 else Convert.ToEntity(dto, entity); 56 Convert.ToEntity(dto, entity); 50 57 okb.SubmitChanges(); 51 58 } … … 60 67 #endregion 61 68 69 #region DataType Methods 70 public DataTransfer.DataType GetDataType(long id) { 71 using (OKBDataContext okb = new OKBDataContext()) { 72 return Convert.ToDto(okb.DataTypes.FirstOrDefault(x => x.Id == id)); 73 } 74 } 75 public IEnumerable<DataTransfer.DataType> GetDataTypes() { 76 using (OKBDataContext okb = new OKBDataContext()) { 77 return okb.DataTypes.Select(x => Convert.ToDto(x)).ToArray(); 78 } 79 } 80 public long AddDataType(DataTransfer.DataType dto) { 81 using (OKBDataContext okb = new OKBDataContext()) { 82 DataAccess.DataType entity = Convert.ToEntity(dto); entity.Id = 0; 83 okb.DataTypes.InsertOnSubmit(entity); 84 okb.SubmitChanges(); 85 return entity.Id; 86 } 87 } 88 public void UpdateDataType(DataTransfer.DataType dto) { 89 using (OKBDataContext okb = new OKBDataContext()) { 90 DataAccess.DataType entity = okb.DataTypes.FirstOrDefault(x => x.Id == dto.Id); 91 Convert.ToEntity(dto, entity); 92 okb.SubmitChanges(); 93 } 94 } 95 public void DeleteDataType(long id) { 96 using (OKBDataContext okb = new OKBDataContext()) { 97 DataAccess.DataType entity = okb.DataTypes.FirstOrDefault(x => x.Id == id); 98 if (entity != null) okb.DataTypes.DeleteOnSubmit(entity); 99 okb.SubmitChanges(); 100 } 101 } 102 #endregion 103 62 104 #region AlgorithmClass Methods 63 105 public DataTransfer.AlgorithmClass GetAlgorithmClass(long id) { … … 71 113 } 72 114 } 73 public void StoreAlgorithmClass(DataTransfer.AlgorithmClass dto) { 115 public long AddAlgorithmClass(DataTransfer.AlgorithmClass dto) { 116 using (OKBDataContext okb = new OKBDataContext()) { 117 DataAccess.AlgorithmClass entity = Convert.ToEntity(dto); entity.Id = 0; 118 okb.AlgorithmClasses.InsertOnSubmit(entity); 119 okb.SubmitChanges(); 120 return entity.Id; 121 } 122 } 123 public void UpdateAlgorithmClass(DataTransfer.AlgorithmClass dto) { 74 124 using (OKBDataContext okb = new OKBDataContext()) { 75 125 DataAccess.AlgorithmClass entity = okb.AlgorithmClasses.FirstOrDefault(x => x.Id == dto.Id); 76 if (entity == null) okb.AlgorithmClasses.InsertOnSubmit(Convert.ToEntity(dto)); 77 else Convert.ToEntity(dto, entity); 126 Convert.ToEntity(dto, entity); 78 127 okb.SubmitChanges(); 79 128 } … … 99 148 } 100 149 } 101 public void StoreAlgorithm(DataTransfer.Algorithm dto) { 150 public long AddAlgorithm(DataTransfer.Algorithm dto) { 151 using (OKBDataContext okb = new OKBDataContext()) { 152 DataAccess.Algorithm entity = Convert.ToEntity(dto); entity.Id = 0; 153 okb.Algorithms.InsertOnSubmit(entity); 154 okb.SubmitChanges(); 155 return entity.Id; 156 } 157 } 158 public void UpdateAlgorithm(DataTransfer.Algorithm dto) { 102 159 using (OKBDataContext okb = new OKBDataContext()) { 103 160 DataAccess.Algorithm entity = okb.Algorithms.FirstOrDefault(x => x.Id == dto.Id); 104 if (entity == null) okb.Algorithms.InsertOnSubmit(Convert.ToEntity(dto)); 105 else Convert.ToEntity(dto, entity); 161 Convert.ToEntity(dto, entity); 106 162 okb.SubmitChanges(); 107 163 } … … 119 175 } 120 176 } 121 public void StoreAlgorithmUsers(long algorithmId, IEnumerable<Guid> users) {177 public void UpdateAlgorithmUsers(long algorithmId, IEnumerable<Guid> users) { 122 178 using (OKBDataContext okb = new OKBDataContext()) { 123 179 okb.AlgorithmUsers.DeleteAllOnSubmit(okb.AlgorithmUsers.Where(x => x.AlgorithmId == algorithmId)); … … 134 190 } 135 191 } 136 public void StoreAlgorithmData(DataTransfer.AlgorithmData dto) {192 public void UpdateAlgorithmData(DataTransfer.AlgorithmData dto) { 137 193 using (OKBDataContext okb = new OKBDataContext()) { 138 194 DataAccess.AlgorithmData entity = okb.AlgorithmDatas.FirstOrDefault(x => x.AlgorithmId == dto.AlgorithmId); … … 144 200 #endregion 145 201 146 #region DataType Methods 147 public DataTransfer.DataType GetDataType(long id) { 148 using (OKBDataContext okb = new OKBDataContext()) { 149 return Convert.ToDto(okb.DataTypes.FirstOrDefault(x => x.Id == id)); 150 } 151 } 152 public IEnumerable<DataTransfer.DataType> GetDataTypes() { 153 using (OKBDataContext okb = new OKBDataContext()) { 154 return okb.DataTypes.Select(x => Convert.ToDto(x)).ToArray(); 155 } 156 } 157 public void StoreDataType(DataTransfer.DataType dto) { 158 using (OKBDataContext okb = new OKBDataContext()) { 159 DataAccess.DataType entity = okb.DataTypes.FirstOrDefault(x => x.Id == dto.Id); 160 if (entity == null) okb.DataTypes.InsertOnSubmit(Convert.ToEntity(dto)); 202 #region ProblemClass Methods 203 public DataTransfer.ProblemClass GetProblemClass(long id) { 204 using (OKBDataContext okb = new OKBDataContext()) { 205 return Convert.ToDto(okb.ProblemClasses.FirstOrDefault(x => x.Id == id)); 206 } 207 } 208 public IEnumerable<DataTransfer.ProblemClass> GetProblemClasses() { 209 using (OKBDataContext okb = new OKBDataContext()) { 210 return okb.ProblemClasses.Select(x => Convert.ToDto(x)).ToArray(); 211 } 212 } 213 public long AddProblemClass(DataTransfer.ProblemClass dto) { 214 using (OKBDataContext okb = new OKBDataContext()) { 215 DataAccess.ProblemClass entity = Convert.ToEntity(dto); entity.Id = 0; 216 okb.ProblemClasses.InsertOnSubmit(entity); 217 okb.SubmitChanges(); 218 return entity.Id; 219 } 220 } 221 public void UpdateProblemClass(DataTransfer.ProblemClass dto) { 222 using (OKBDataContext okb = new OKBDataContext()) { 223 DataAccess.ProblemClass entity = okb.ProblemClasses.FirstOrDefault(x => x.Id == dto.Id); 224 Convert.ToEntity(dto, entity); 225 okb.SubmitChanges(); 226 } 227 } 228 public void DeleteProblemClass(long id) { 229 using (OKBDataContext okb = new OKBDataContext()) { 230 DataAccess.ProblemClass entity = okb.ProblemClasses.FirstOrDefault(x => x.Id == id); 231 if (entity != null) okb.ProblemClasses.DeleteOnSubmit(entity); 232 okb.SubmitChanges(); 233 } 234 } 235 #endregion 236 237 #region Problem Methods 238 public DataTransfer.Problem GetProblem(long id) { 239 using (OKBDataContext okb = new OKBDataContext()) { 240 return Convert.ToDto(okb.Problems.FirstOrDefault(x => x.Id == id)); 241 } 242 } 243 public IEnumerable<DataTransfer.Problem> GetProblems() { 244 using (OKBDataContext okb = new OKBDataContext()) { 245 return okb.Problems.Select(x => Convert.ToDto(x)).ToArray(); 246 } 247 } 248 public long AddProblem(DataTransfer.Problem dto) { 249 using (OKBDataContext okb = new OKBDataContext()) { 250 DataAccess.Problem entity = Convert.ToEntity(dto); entity.Id = 0; 251 okb.Problems.InsertOnSubmit(entity); 252 okb.SubmitChanges(); 253 return entity.Id; 254 } 255 } 256 public void UpdateProblem(DataTransfer.Problem dto) { 257 using (OKBDataContext okb = new OKBDataContext()) { 258 DataAccess.Problem entity = okb.Problems.FirstOrDefault(x => x.Id == dto.Id); 259 Convert.ToEntity(dto, entity); 260 okb.SubmitChanges(); 261 } 262 } 263 public void DeleteProblem(long id) { 264 using (OKBDataContext okb = new OKBDataContext()) { 265 DataAccess.Problem entity = okb.Problems.FirstOrDefault(x => x.Id == id); 266 if (entity != null) okb.Problems.DeleteOnSubmit(entity); 267 okb.SubmitChanges(); 268 } 269 } 270 public IEnumerable<Guid> GetProblemUsers(long problemId) { 271 using (OKBDataContext okb = new OKBDataContext()) { 272 return okb.ProblemUsers.Where(x => x.ProblemId == problemId).Select(x => x.UserId).ToArray(); 273 } 274 } 275 public void UpdateProblemUsers(long problemId, IEnumerable<Guid> users) { 276 using (OKBDataContext okb = new OKBDataContext()) { 277 okb.ProblemUsers.DeleteAllOnSubmit(okb.ProblemUsers.Where(x => x.ProblemId == problemId)); 278 okb.ProblemUsers.InsertAllOnSubmit(users.Select(x => new DataAccess.ProblemUser { ProblemId = problemId, UserId = x })); 279 okb.SubmitChanges(); 280 } 281 } 282 #endregion 283 284 #region ProblemData Methods 285 public DataTransfer.ProblemData GetProblemData(long problemId) { 286 using (OKBDataContext okb = new OKBDataContext()) { 287 return Convert.ToDto(okb.ProblemDatas.FirstOrDefault(x => x.ProblemId == problemId)); 288 } 289 } 290 public void UpdateProblemData(DataTransfer.ProblemData dto) { 291 using (OKBDataContext okb = new OKBDataContext()) { 292 DataAccess.ProblemData entity = okb.ProblemDatas.FirstOrDefault(x => x.ProblemId == dto.ProblemId); 293 if (entity == null) okb.ProblemDatas.InsertOnSubmit(Convert.ToEntity(dto)); 161 294 else Convert.ToEntity(dto, entity); 162 okb.SubmitChanges();163 }164 }165 public void DeleteDataType(long id) {166 using (OKBDataContext okb = new OKBDataContext()) {167 DataAccess.DataType entity = okb.DataTypes.FirstOrDefault(x => x.Id == id);168 if (entity != null) okb.DataTypes.DeleteOnSubmit(entity);169 295 okb.SubmitChanges(); 170 296 }
Note: See TracChangeset
for help on using the changeset viewer.