//********************************************************** //* Создание пользователя //********************************************************** public static MembershipUser CreateUser(String username, String password, Int32 roleId) { using (SandBoxDataContext db = new SandBoxDataContext()) { var users = UserManager.GetUsers(); if (Enumerable.Any(users, us => us.Login == username)) return null; User user = new User { Login = username, Password = password, PasswordSalt = CreateSalt(), CreatedDate = DateTime.Now, LastLoginDate = DateTime.Now }; user.Password = CreatePasswordHash(password, user.PasswordSalt); db.Users.InsertOnSubmit(user); db.SubmitChanges(); var usr = db.Users.FirstOrDefault(x => x.Login == username); if (usr == null) return null; UsersInRole userInRole = new UsersInRole {UserId = usr.UserId, RoleId = roleId}; db.UsersInRoles.InsertOnSubmit(userInRole); db.SubmitChanges(); return GetUser(username); } }
//********************************************************** //* Добавление нового исследования, возвращает researchId //********************************************************** public static Int32 AddResearch(Int32 userId, Int32 mlwrId, Int32 vmId, Int32 researchVmData, Int32 duration, String name = "") { using (SandBoxDataContext db = new SandBoxDataContext()) { Research research = new Research { UserId = userId, MlwrId = mlwrId, VmId = vmId, ResearchVmData = researchVmData, State = (Int32)ResearchState.READY, CreatedDate = DateTime.Now, Duration = duration, ResearchName = name, TrafficFileReady = (Int32)TrafficFileReady.NOACTION }; db.Researches.InsertOnSubmit(research); db.SubmitChanges(); var researches = from r in db.Researches where r.UserId == userId select r.Id; return researches.Max(); } }
public static void DeleteDirectorysOfEvent(long id) { var db = new SandBoxDataContext(); var dofe = db.DirectoryOfEvents.FirstOrDefault<DirectoryOfEvents>(x => x.Id == id); if(dofe!=null) db.DirectoryOfEvents.DeleteOnSubmit(dofe); db.SubmitChanges(); }
//********************************************************** //* Добавление новой задачи //********************************************************** public static void AddTask(Int32 researchId, Int32 taskType, String value) { using (SandBoxDataContext db = new SandBoxDataContext()) { Task task = new Task { ResearchId = researchId, Type = taskType, Value = value }; db.Tasks.InsertOnSubmit(task); db.SubmitChanges(); } }
public static void AddReport(Int32 researchId, Int32 modId, Int32 actionId, String obj, String target, String additional="") { using (SandBoxDataContext db = new SandBoxDataContext()) { Report report = new Report { ResearchId = researchId, ModuleId = modId, ActionId = actionId, Object = obj, Target = target, TIme = DateTime.Now, Additional = additional}; db.Reports.InsertOnSubmit(report); db.SubmitChanges(); } }
//********************************************************** //* Добавление новой роли //********************************************************** public static void AddRole(String rolename) { using (SandBoxDataContext db = new SandBoxDataContext()) { Role role = new Role { Name = rolename }; db.Roles.InsertOnSubmit(role); db.SubmitChanges(); } }
//********************************************************** //* Добавление нового запроса //********************************************************** public static void AddRequest(Int32 researchId, RequestType requestType) { using (SandBoxDataContext db = new SandBoxDataContext()) { Request request = new Request() {ResearchId = researchId, Type = (Int32)requestType, State = (Int32)RequestState.EXECUTING}; db.Requests.InsertOnSubmit(request); db.SubmitChanges(); } }
//********************************************************** //* Удаление роли //********************************************************** public static void DeleteRole(String rolename) { using (SandBoxDataContext db = new SandBoxDataContext()) { Role role = db.Roles.FirstOrDefault(r => r.Name == rolename); if (role == null) return; db.Roles.DeleteOnSubmit(role); db.SubmitChanges(); } }
//********************************************************** //* Удалени всех запросов //********************************************************** public static void DeleteRequests() { var db = new SandBoxDataContext(); var requests = from r in db.Requests orderby r.Id select r; db.Requests.DeleteAllOnSubmit(requests); db.SubmitChanges(); }
//********************************************************** //* Добавление нового типа Vm //********************************************************** public static void AddType(String description) { using (SandBoxDataContext db = new SandBoxDataContext()) { Int32 maxType = (from t in db.VmTypes orderby t.Type select t.Type).Max(); VmType vmType = new VmType { Type = maxType + 1, Description = description }; db.VmTypes.InsertOnSubmit(vmType); db.SubmitChanges(); } }
//********************************************************** //* Добавление новой системы Vm //********************************************************** public static void AddSystem(String description) { using (SandBoxDataContext db = new SandBoxDataContext()) { Int32 maxSystem = (from s in db.VmSystems orderby s.System select s.System).Max(); VmSystem vmSystem = new VmSystem { System = maxSystem + 1, Description = description }; db.VmSystems.InsertOnSubmit(vmSystem); db.SubmitChanges(); } }
//********************************************************** //* Добавление нового состояния Vm //********************************************************** public static void AddState(String description) { using (SandBoxDataContext db = new SandBoxDataContext()) { Int32 maxState = (from s in db.VmStates orderby s.State select s.State).Max(); VmState vmState = new VmState { State = maxState + 1, Description = description }; db.VmStates.InsertOnSubmit(vmState); db.SubmitChanges(); } }
public static void DeleteItem(Int32 id) { using (SandBoxDataContext db = new SandBoxDataContext()) { Machine machine = db.Machines.FirstOrDefault(x => x.Id == id); db.Machines.DeleteOnSubmit(machine); db.SubmitChanges(); TableUpdated(Table.MACHINES); } }
public static void CreateItem(String name) { using (SandBoxDataContext db = new SandBoxDataContext()) { Machine machine = new Machine {Name = name, State = -1, UniqueId = 2, Description = "null"}; db.Machines.InsertOnSubmit(machine); db.SubmitChanges(); TableUpdated(Table.MACHINES); } }
//********************************************************** //* Удалени всех задач //********************************************************** public static void DeleteTasks() { var db = new SandBoxDataContext(); var tasks = from t in db.Tasks orderby t.Id select t; db.Tasks.DeleteAllOnSubmit(tasks); db.SubmitChanges(); }
//********************************************************** //* Отметка Mlwr по id как удаленного //********************************************************** public static void DeleteMlwr(Int32 id) { using (SandBoxDataContext db = new SandBoxDataContext()) { var mlwr = db.Mlwrs.FirstOrDefault(x => x.Id == id); if (mlwr == null) return; mlwr.IsDeleted = 1; db.SubmitChanges(); } }
public static void ClearReports(Int32 researchId) { using (SandBoxDataContext db = new SandBoxDataContext()) { var reports = from r in db.Reports where r.ResearchId == researchId select r; db.Reports.DeleteAllOnSubmit(reports); db.SubmitChanges(); } }
//********************************************************** //* Удаление пользователя //********************************************************** public static void DeleteUser(Int32 id) { using (SandBoxDataContext db = new SandBoxDataContext()) { var user = db.Users.FirstOrDefault(x => x.UserId == id); if (user == null) return; db.UsersInRoles.DeleteOnSubmit(user.UsersInRole); db.SubmitChanges(); db.Users.DeleteOnSubmit(user); db.SubmitChanges(); } }
/// <summary> /// Сохранение внешнего вида таблицы /// </summary> /// <returns></returns> public static void SetLayout(int userid, string tablename, string userlayout) { using (SandBoxDataContext db = new SandBoxDataContext()) { Layout layout = db.Layouts.FirstOrDefault(x => x.UserID == userid && x.TableName == tablename); if (layout == null) { layout = new Layout { UserID = userid, TableName = tablename, UserLayout = userlayout }; db.Layouts.InsertOnSubmit(layout); } else layout.UserLayout = userlayout; db.SubmitChanges(); } }
public static Int32 AddMlwrClass(String name, String comment) { using (SandBoxDataContext db = new SandBoxDataContext()) { MlwrClass mlwrcl = new MlwrClass() { Name = name, Comment = comment }; db.MlwrClasses.InsertOnSubmit(mlwrcl); db.SubmitChanges(); return db.MlwrClasses.FirstOrDefault<MlwrClass>(x => x.Name == name).id; } // TableUpdated(Table.MLWRS); }
//********************************************************** //* Добавление нового Mlwr //********************************************************** public static void AddMlwr(String name, String path, Int32 loadedBy) { using (SandBoxDataContext db = new SandBoxDataContext()) { Mlwr mlwr = new Mlwr() { Name = name, Path = path, ResearchCount = 0, Class = 0, LoadedDate = DateTime.Now, LoadedBy = loadedBy }; db.Mlwrs.InsertOnSubmit(mlwr); db.SubmitChanges(); } TableUpdated(Table.MLWRS); }
public static void AddMlwrClassItem(Int32 mlwrclassid, String evdesk, String evparam) { using (SandBoxDataContext db = new SandBoxDataContext()) { Int32 eventid = db.EventsEventDescriptions.FirstOrDefault<EventsEventDescriptions>(x => x.EventsEventDescription == evdesk).EventID; Int32 moduleid = db.ModulesVsEvents.FirstOrDefault<ModulesVsEvents>(x => x.Event == eventid).Module; MlwrClassItem mlwrclitm = new MlwrClassItem() { MlwrClassId = mlwrclassid, ModuleId = moduleid, EventId = eventid, Param = evparam }; db.MlwrClassItems.InsertOnSubmit(mlwrclitm); db.SubmitChanges(); } // TableUpdated(Table.MLWRS); }
//********************************************************** //* Добавление нового Mlwr //********************************************************** public static void AddMlwr(String name, String path, Int32 loadedBy, String md5, String sha1, String sha256) { using (SandBoxDataContext db = new SandBoxDataContext()) { Mlwr mlwr = new Mlwr() { Name = name, Path = path, ResearchCount = 0, Class = null, LoadedDate = DateTime.Now, LoadedBy = loadedBy, md5 = md5, sha1 = sha1, sha256 = sha256, IsDeleted = 0 }; db.Mlwrs.InsertOnSubmit(mlwr); db.SubmitChanges(); } TableUpdated(Table.MLWRS); }
public static int AddMlwrFeature(int mlwrId, string fclass, string sclass, string value) { int newMlwrId = -1; using (SandBoxDataContext db = new SandBoxDataContext()) { var fm = from f in db.MlwrFeature select f.Id; int ewMlwrId = fm.Max() + 1; MlwrFeature mlwrF = new MlwrFeature() { Id = ewMlwrId, MlwrId = mlwrId, FClass = fclass, SClass = sclass, Value = value }; db.MlwrFeature.InsertOnSubmit(mlwrF); db.SubmitChanges(); } return newMlwrId; }
public static void AddCommand(int rschId, string command, string commandParams = "", int startTime = 60) { var db = new SandBoxDataContext(); try { if ((command != null && command != String.Empty)) { Commands newCommand = new Commands() { RschId = rschId, Command = command, CommandParams = commandParams, CommandStartTime = startTime }; db.Commands.InsertOnSubmit(newCommand); db.SubmitChanges(); } } catch (Exception e) { //УБРАТЬ СЛЕПОЙ CATCH!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! } }
public static void UpdateRowDirectoriesOfEvents(int dofId, int segn, int m, int evt, string d, string wh) { using (SandBoxDataContext db = new SandBoxDataContext()) { DirectoryOfEvents dofe = db.DirectoryOfEvents.FirstOrDefault(x => x.Id == dofId); if (dofe == null) return; dofe.module = m; dofe.@event = evt; dofe.who = wh; dofe.dest = d; dofe.significance = segn; db.SubmitChanges(); } }
public static void InsertRowDirectoriesOfEvents(int segn, int m, int evt, string d, string wh) { DirectoryOfEvents dofe = new DirectoryOfEvents { significance = segn, module = m, @event = evt, dest = d, who = wh }; var db = new SandBoxDataContext(); db.DirectoryOfEvents.InsertOnSubmit(dofe); db.SubmitChanges(); }
public static void InsertComment(int mlwrId, string comment) { var db = new SandBoxDataContext(); db.MlwrComments.InsertOnSubmit(new MlwrComments() { CommentValue = comment, MlwrId = mlwrId }); db.SubmitChanges(); }
//********************************************************** //* Удалени всех задач исследования //********************************************************** public static void DeleteTasks(Int32 researchId) { var db = new SandBoxDataContext(); var tasks = from t in db.Tasks orderby t.Id where t.ResearchId == researchId select t; db.Tasks.DeleteAllOnSubmit(tasks); db.SubmitChanges(); }
//********************************************************** //* Обновление информации о траффике //********************************************************** public static void UpdateTrafficInfo(Int32 researchId, TrafficFileReady fileReady, String fileName=null) { using (SandBoxDataContext db = new SandBoxDataContext()) { Research research = db.Researches.FirstOrDefault(x => x.Id == researchId); if (research == null) return; research.TrafficFileReady = (Int32)fileReady; if (fileName != null) research.TrafficFileName = fileName; db.SubmitChanges(); } }