//**********************************************************
//* Создание пользователя
//**********************************************************
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();
}
}
