public IHttpActionResult Post(QuizParams qp)
{
string host_Quiz = string.Format("{0}:{1}"
, ConfigurationManager.AppSettings["OrientProdHost"], ConfigurationManager.AppSettings["OrientPort"]);
quizManager = new Managers.Manager(
ConfigurationManager.AppSettings["IntranetDB"]
, host_Quiz
, ConfigurationManager.AppSettings["orient_dev_login"]
, ConfigurationManager.AppSettings["orient_dev_pswd"]
);
WebManagers.ReturnEntities response = null;
string res = string.Empty;
Quizes.QuizUOW qu = new Quizes.QuizUOW(quizManager.GetRepo());
try
{
// преобразуем строку в HttpResponseMessage со ReturnEntities с результатом в поле _value
res = qu.GetQuizByMonthGap(qp.monthDepth);
response = new WebManagers.ReturnEntities(res, Request);
}
catch (Exception e)
{
System.Diagnostics.Trace.WriteLine(e.Message);
response = new WebManagers.ReturnEntities("Error: " + e.Message, Request);
}
return(response);
}
//FUNCTIONAL TESTS
public static void UOWFunctionalCheck()
{
//GET CLASS
Managers.Manager mngCl = new Managers.Manager("dev_db", null);
IOrientRepo rp = mngCl.GetRepo();
GetClass gc = rp.GetClass <Person>("dev_db", null);
//Managers.Manager mng = new Managers.Manager(ConfigurationManager.AppSettings["OrientDevDB"],null);
Managers.Manager mng = new Managers.Manager(ConfigurationManager.AppSettings["OrientUnitTestDB"], null);
Managers.Manager mngSource = new Managers.Manager(ConfigurationManager.AppSettings["OrientSourceDB"], null);
PersonUOWs.PersonUOW pu = mng.GetPersonUOW();
NewsUOWs.NewsRealUow nu = mng.GetNewsUOW();
Managers.Manager mngPerson = new Managers.Manager(ConfigurationManager.AppSettings["OrientSourceDB"]);
PersonUOWs.PersonUOW personToGetUOW = mngPerson.GetPersonUOW();
POCO.News newsToAdd0 = new News()
{
GUID = "119", content = "s \"a \"a t "
};
POCO.Person newsMaker = pu.SearchByName("Neprintsevia").FirstOrDefault();
POCO.Person likeMaker = pu.SearchByName("Person1").FirstOrDefault();
POCO.Person troubleMaker = pu.SearchByName("Person0").FirstOrDefault();
GETparameters gp = new GETparameters()
{
offest = 5, published = true, pinned = true, asc = true, author = newsMaker
};
JSONManager jm = new JSONManager();
//ABSENT PERSON CHECK
Random rnd = new Random();
//News ns = nu.GetNewsByGUID("2370b972-48d4-4e49-95ad-b99ba5382042");
//News ns = nu.GetNewsByGUID("e7bc87ec-f649-4748-b4cb-d2863f780f1c");
//nu.GetNewsByGUID("f7557c27-f889-4aab-91ce-ba15e34e3981");
//News ns = nu.GetNewsByGUID("f7557c27-f889-4aab-91ce-ba15e34e3981");
var a = nu.GetNews(5, null, null);
int acc = (int)rnd.Next(0, 10000);
Person personAbsent = new Person()
{
Name = "PersonAbsent", sAMAccountName = "absent" + acc
};
string newsContent = "{\"conntent_\":\"news text\",\"name\":\"News name\"}";
}
//MOOVE DB
public static void UOWMooveDb()
{
Managers.Manager mngFrom1 = new Managers.Manager("dev_db", "http://msk1-vm-ovisp02:2480", "root", "I9grekVmk5g");
Managers.Manager mngFrom2 = new Managers.Manager("news_test5", "http://msk1-vm-ovisp02:2480", "root", "I9grekVmk5g");
//msk1-vm-indb01.nspk.ru
//mR%mzJUGq1E
Managers.Manager mngTo = new Managers.Manager("news_prod", "http://msk1-vm-ovisp02:2480", "root", "I9grekVmk5g");
//Managers.Manager mngTo=new Managers.Manager("news_prod","http://msk1-vm-indb01.nspk.ru:2480","root","mR%mzJUGq1E");
MooveDB.Migrate(mngTo, mngFrom1, true, true, false, false);
MooveDB.Migrate(mngTo, mngFrom2, false, false, true, false);
}
public static void GenTestDB(bool cleanUpAter = false, bool newsGen = true)
{
List <News> news_ = new List <News>()
{
};
List <Commentary> comments_ = new List <Commentary>()
{
};
Managers.Manager mng = new Managers.Manager("test_db");
//CREATE DB
mng.GenDB(cleanUpAter);
//GENERATE NEWS,COMMENTS
mng.GenNewsComments(newsGen, true);
}
//MOOVE DB
public static void UOWMooveDb()
{
Managers.Manager mngFrom1 = new Managers.Manager("dev_db", "http://msk1-vm-ovisp02:2480", "root", "I9grekVmk5g");
Managers.Manager mngFrom2 = new Managers.Manager("news_test5", "http://msk1-vm-ovisp02:2480", "root", "I9grekVmk5g");
//msk1-vm-indb01.nspk.ru
//mR%mzJUGq1E
Managers.Manager mngTo = new Managers.Manager("news_test_for_prod", "http://msk1-vm-ovisp02:2480", "root", "I9grekVmk5g");
//Managers.Manager mngTo=new Managers.Manager("news_prod","http://msk1-vm-indb01.nspk.ru:2480","root","mR%mzJUGq1E");
List <IOrientObjects.IOrientDefaultObject> classes_ = new List <IOrientObjects.IOrientDefaultObject>();
classes_.Add(new Note());
classes_.Add(new Authorship());
//migrate class names and shemas from actual DB
MooveDB.Migrate(mngTo, mngFrom2, classes_, null, true, false);
//migrate ral persons from actual person DB
MooveDB.Migrate(mngTo, mngFrom1, null, classes_, false, false);
}
public News2Controller()
{
string host_Test = string.Format("{0}:{1}"
, ConfigurationManager.AppSettings["OrientTargetHost"], ConfigurationManager.AppSettings["OrientPort"]);
string host_Source = string.Format("{0}:{1}"
, ConfigurationManager.AppSettings["OrientSourceHost"], ConfigurationManager.AppSettings["OrientPort"]);
targetManager = new Managers.Manager(
ConfigurationManager.AppSettings["OrientUnitTestDB"]
, host_Test
, ConfigurationManager.AppSettings["orient_dev_login"]
, ConfigurationManager.AppSettings["orient_dev_pswd"]
);
Managers.Manager sourceManager = new Managers.Manager(
ConfigurationManager.AppSettings["OrientSourceDB"]
, host_Source
, ConfigurationManager.AppSettings["orient_login"]
, ConfigurationManager.AppSettings["orient_pswd"]
);
acc = targetManager.UserAcc();
if (acc == null)
{
throw new Exception("No account found");
}
if (targetManager.GetPersonUOW().GetPersonByAccount(acc) == null)
{
POCO.Person personToAdd = sourceManager.GetPersonUOW().GetPersonByAccount(acc);
if (personToAdd == null)
{
throw new Exception("No user object in source db exists");
}
POCO.Person personAdded = targetManager.GetPersonUOW().CreatePerson(personToAdd);
}
}
public DynamicFormController(IHostingEnvironment hostingEnvironment, Managers.Manager manager) : base(manager)
{
this.HostingEnvironment = hostingEnvironment;
}
public static OrientDatabase Migrate(Managers.Manager to_, Managers.Manager from_, List <IOrientObjects.IOrientDefaultObject> mooveClasses
, List <IOrientObjects.IOrientDefaultObject> mooveObjects, bool dropAndCreateIfExists = false, bool generate = false)
{
OrientDatabase result = null;
bool allreadyExists = false;
if (to_ == null)
{
throw new Exception("No from DB passed");
}
targetRepo_ = to_.GetRepo();
if (targetRepo_ == null)
{
throw new Exception("No from repo exists");
}
OrientDatabase dbTo = targetRepo_.GetDb();
if (dropAndCreateIfExists == true)
{
//drop and create db
if (dbTo != null)
{
targetRepo_.DeleteDb();
}
targetRepo_.CreateDb();
if (targetRepo_.GetDb() == null)
{
throw new Exception("Db was not recreated");
}
}
if (from_ != null)
{
//moove db
sourceRepo_ = from_.GetRepo();
if (sourceRepo_ == null)
{
throw new Exception("No from repo exists");
}
OrientDatabase dbFrom = sourceRepo_.GetDb();
dbFrom = sourceRepo_.GetDb();
dbTo = targetRepo_.GetDb();
if (dbTo == null)
{
throw new Exception("No target database exists");
}
if (dbFrom == null)
{
throw new Exception("No source database exists");
}
if (mooveClasses != null && mooveClasses.Count() > 0)
{
MooveClasses(targetRepo_, sourceRepo_, mooveClasses);
foreach (OrientDefaultObject oL_ in mooveClasses)
{
targetRepo_.CreateProperty <OrientDefaultObject>(oL_, null);
}
}
if (mooveObjects != null && mooveObjects.Count() > 0)
{
ConditionalItemsInit(mooveObjects);
MooveObject();
/*
* MooveObjectsOfClass<Person>(targetRepo_,sourceRepo_);
* MooveObjectsOfClass<Unit>(targetRepo_,sourceRepo_);
*
* MooveObjectsOfClass<SubUnit>(targetRepo_,sourceRepo_);
* MooveObjectsOfClass<MainAssignment>(targetRepo_,sourceRepo_);
* MooveObjectsOfClass<OldMainAssignment>(targetRepo_,sourceRepo_);
*/
}
/*
* MooveObjectsOfClass<UserSettings>(targetRepo_,sourceRepo_);
* MooveObjectsOfClass<CommonSettings>(targetRepo_,sourceRepo_);
*
*
* MooveObjectsOfClass<PersonRelation>(targetRepo_,sourceRepo_);
*/
}
if (generate == true)
{
//generate scenery to existing
to_.GenDB(false, false);
to_.GenNewsComments(null, null);
}
targetRepo_.StoreDbStatistic(null, null);
return(result);
}
public UserController(Managers.Manager manager) : base(manager)
{
this.Manager = manager;
}
public static void GetPersonCheck()
{
Managers.Manager mng = new Managers.Manager("news_test5", "http://msk1-vm-ovisp02:2480", "root", "I9grekVmk5g");
string res = mng.GetPersonWithManagers("http://msk1-vm-inapp01:8185/api/Person/GetManager/");
}
public MainController(Managers.Manager manager) : base(manager)
{
}
public PermitController(Managers.Manager manager) : base(manager)
{
}
public static OrientDatabase Migrate(Managers.Manager to_, Managers.Manager from_,
bool dropAndCreateIfExists = false, bool mooveClasses = false, bool mooveObjects = false, bool generate = false)
{
OrientDatabase result = null;
bool allreadyExists = false;
if (to_ == null)
{
throw new Exception("No from DB passed");
}
targetRepo_ = to_.GetRepo();
if (targetRepo_ == null)
{
throw new Exception("No from repo exists");
}
OrientDatabase dbTo = targetRepo_.GetDb();
if (dropAndCreateIfExists == true)
{
//drop and create db
if (dbTo != null)
{
targetRepo_.DeleteDb();
}
targetRepo_.CreateDb();
if (targetRepo_.GetDb() == null)
{
throw new Exception("Db was not recreated");
}
}
if (from_ != null)
{
//moove db
sourceRepo_ = from_.GetRepo();
if (sourceRepo_ == null)
{
throw new Exception("No from repo exists");
}
OrientDatabase dbFrom = sourceRepo_.GetDb();
dbFrom = sourceRepo_.GetDb();
dbTo = targetRepo_.GetDb();
if (dbTo == null)
{
throw new Exception("No target database exists");
}
if (dbFrom == null)
{
throw new Exception("No source database exists");
}
if (mooveClasses)
{
MooveClasses(targetRepo_, sourceRepo_);
targetRepo_.CreateProperty <OrientEdge>(new OrientEdge(), null);
//create all properties even if all null.
targetRepo_.CreateProperty <MainAssignment>(new MainAssignment(), null);
targetRepo_.CreateProperty <Unit>(new Unit(), null);
targetRepo_.CreateProperty <Note>(new Note(), null);
targetRepo_.CreateProperty <Authorship>(new Authorship(), null);
targetRepo_.CreateProperty <Comment>(new Comment(), null);
targetRepo_.CreateProperty <Commentary>(new Commentary(), null);
targetRepo_.CreateProperty <News>(new News(), null);
targetRepo_.CreateProperty <Person>(new Person(), null);
targetRepo_.CreateProperty <Liked>(new Liked(), null);
targetRepo_.CreateProperty <Tag>(new Tag(), null);
targetRepo_.CreateProperty <Tagged>(new Tagged(), null);
}
if (mooveObjects)
{
MooveObjectsOfClass <Person>(targetRepo_, sourceRepo_);
MooveObjectsOfClass <Unit>(targetRepo_, sourceRepo_);
MooveObjectsOfClass <SubUnit>(targetRepo_, sourceRepo_);
MooveObjectsOfClass <MainAssignment>(targetRepo_, sourceRepo_);
MooveObjectsOfClass <OldMainAssignment>(targetRepo_, sourceRepo_);
}
/*
* MooveObjectsOfClass<UserSettings>(targetRepo_,sourceRepo_);
* MooveObjectsOfClass<CommonSettings>(targetRepo_,sourceRepo_);
*/
MooveObjectsOfClass <PersonRelation>(targetRepo_, sourceRepo_);
}
if (generate == true)
{
//generate scenery to existing
to_.GenDB(false, false);
to_.GenNewsComments(null, null);
}
targetRepo_.StoreDbStatistic(null, null);
return(result);
}
public SharedController(Managers.Manager manager)
{
this.Manager = manager;
}
