public DataBaseView(IReadOnlyViewState viewState, DataBaseController controller)
{
InitializeComponent();
this.controller = controller;
this.viewState = viewState;
}
public void DeleteCourseTest()
{
var controller = new DataBaseController();
var expectedDifficulty = 1;
var expectedName = "deletecourse";
var expectedDescription = "coursetotestdeletion";
using (TransactionScope ts = new TransactionScope())
{
testCourse = CreateTestCourse(expectedName, expectedDescription, expectedDifficulty);
var courseController = new CourseController();
courseController.PostCourse(testCourse);
var testingList = courseController.GetCourses();
foreach (Course c in testingList)
{
if (c.CourseName == expectedName && c.CourseDescription == expectedDescription && c.CourseDifficulty == expectedDifficulty)
{
var idForTestDeletion = c.CourseID;
courseController.DeleteCourse(idForTestDeletion);
break;
}
}
Assert.IsFalse(
testingList.Exists(c => c.CourseName == expectedName && c.CourseDescription == expectedDescription && c.CourseDifficulty == expectedDifficulty)
);
}
}
public DialogsTestsBase()
{
db = new DataBaseController();
createNewClientConversation(out convID);
Client = createNewClientConversation(out convID);
ConvID = convID;
}
public async Task testLearningSpecialValues()
{
var db = new DataBaseController();
var optionsRes = await getToLearningMenu();
AssertNLP.contains(optionsRes, DBbotPhrase(Pkey.chooseStudyUnits));
var allCategory = db.getAllCategory();
var category = allCategory[rand.Next(allCategory.Length)];
var res = await sendBot(category);
res = await sendBot("ספר לי משהו מצחיק");
AssertNLP.contains(res, DBbotPhrase(Pkey.mightHaveSomthing));
res = await sendBot("ספר לי משהו מעניין");
AssertNLP.contains(res, DBbotPhrase(Pkey.mightHaveSomthing));
res = await sendBot("לך תזדיין");
AssertNLP.contains(res, DBbotPhrase(Pkey.swearResponse));
res = await sendBot("בן זונה");
AssertNLP.contains(res, DBbotPhrase(Pkey.swearResponse));
res = await sendBot("שרמוטה");
AssertNLP.contains(res, DBbotPhrase(Pkey.swearSuspention));
res = await sendBot("טוב בא נמשיך");
AssertNLP.contains(res, DBbotPhrase(Pkey.duringSwearSuspention));
res = await sendBot("סליחה");
AssertNLP.contains(res, DBbotPhrase(Pkey.letsContinue));
}
public IActionResult EditPatient(string id)
{
DataBaseController DB = new DataBaseController();
Patient patient = DB.GetPatientById(id);
ViewBag.User = HttpContext.Session.GetString("user");
return(View(patient));
}
public GenotypeForm()
{
InitializeComponent();
DataBaseController db = new DataBaseController();
Genes = db.GetGenes();
Genes.ForEach(x => comboBox1.Items.Add(x.Name));
}
public IActionResult Index()
{
DataBaseController DB = new DataBaseController();
Dictionary <Visit, Patient> Visits = DB.GetDoctorsVisits(HttpContext.Session.GetString("user"));
ViewBag.User = HttpContext.Session.GetString("user");
return(View(Visits));
}
// Use this for initialization
void Start()
{
canvas = gameObject.GetComponent <Canvas>();
defaultTrackableEventHandler = FindObjectsOfType <DefaultTrackableEventHandler>();
_db = new DataBaseController();
xmlManager = new XMLManager();
furnitures = xmlManager.LoadFurniture();
}
public IActionResult Index()
{
DataBaseController DB = new DataBaseController();
List <Medicine> medicines = DB.GetAllMedicines();
ViewBag.User = HttpContext.Session.GetString("user");
return(View(medicines));
}
public EducationController(IUser user, IStudySession studySession, ConversationController cc)
{
this.user = user;
this.db = new DataBaseController();
this.studySession = studySession;
this.ConversationController = cc;
Qac = new QuestionsAnswersControllers();
}
public void delete()
{
string deleteStatement = "DELETE FROM TEXT";
deleteStatement += $" WHERE ID = '{id}'";
var db = new DataBaseController();
db.executeNonQuery(deleteStatement);
}
// Start is called before the first frame update
void Start()
{
DataBaseController bbdd = new DataBaseController();
bbdd.Start();
results = bbdd.Top5();
SeparateValues();
Results();
}
public void insert()
{
string insertStatement = "INSERT INTO TEXT";
insertStatement += "(id,memo,createdate,DateiName)";
insertStatement += $"values('{id}','{memo}','{createDate}','{fileName}')";
var db = new DataBaseController();
db.executeNonQuery(insertStatement);
}
private void Select2()
{
item1.Opacity = 0;
item2.Opacity = 1;
item3.Opacity = 0;
MainPivot.SelectedIndex = 1;
x = DataBaseController.getValues();
lstImpaire.DataContext = x;
}
public IActionResult SavePatient(Patient patient)
{
DataBaseController DB = new DataBaseController();
DB.UpdatePatient(patient);
var patients = DB.GetDoctorsPatients(HttpContext.Session.GetString("user"));
ViewBag.User = HttpContext.Session.GetString("user");
return(View("Index", patients));
}
public void update()
{
string updateStatement = "UPDATE TEXT ";
updateStatement += $"SET MEMO = '{memo}'";
updateStatement += $", DateiName = '{fileName}'";
updateStatement += $" WHERE ID = '{id}'";
var db = new DataBaseController();
db.executeNonQuery(updateStatement);
}
private async Task show()
{
var content = SharedInformation.sharedQuotes.Text;
var img = SharedInformation.sharedQuotes.Image;
//var content = SharedInformation.sharedQuotes;
DataBaseController.insertData(content, "jlilç", "k_k__");
MessageDialog msg = new MessageDialog("Added Successfully");
await msg.ShowAsync();
}
public IActionResult CreateVisit()
{
ViewBag.User = HttpContext.Session.GetString("user");
Visit visit = new Visit();
DataBaseController DB = new DataBaseController();
ViewBag.patients = DB.GetPatients();
ViewBag.medicines = DB.GetAllMedicines();
visit.VisitId = Guid.NewGuid().ToString();
visit.DoctorId = HttpContext.Session.GetString("user");
return(View(visit));
}
private void lstImpaire_ItemClick(object sender, ItemClickEventArgs e)
{
//Favoris s = lstImpaire.SelectedItem as Favoris;
//Debug.WriteLine("xxx==== " + s.Id);
//DataBaseController.delete(s.Id);
//x.Remove(s);
Favoris s = (Favoris)e.ClickedItem;
Debug.WriteLine("xxx==== " + s.Id);
DataBaseController.delete(s.Id);
x.Remove(s);
}
public IActionResult Login(string Password, string Email)
{
DataBaseController DB = new DataBaseController();
Doctor Doc = DB.Login(Email, Password);
if (Doc == null)
{
return(View("Login"));
}
HttpContext.Session.SetString("user", Doc.DoctorId);
ViewBag.User = HttpContext.Session.GetString("user");
return(View("Index"));
}
public IActionResult SaveVisit(Visit visit)
{
DataBaseController DB = new DataBaseController();
if (visit.PrescribedMedicines == null)
{
visit.PrescribedMedicines = new List <string>();
}
DB.InsertNewVisit(visit);
Dictionary <Visit, Patient> Visits = DB.GetDoctorsVisits(HttpContext.Session.GetString("user"));
ViewBag.User = HttpContext.Session.GetString("user");
return(View("Index", Visits));
}
public IActionResult Register(Doctor doctor)
{
try
{
DataBaseController DB = new DataBaseController();
DB.InsertNewDoctor(doctor);
}
catch { }
finally
{
HttpContext.Session.SetString("user", doctor.DoctorId);
ViewBag.User = HttpContext.Session.GetString("user");
}
return(View("Index"));
}
private void Application_Startup(object sender, StartupEventArgs e)
{
using (var model = CreateDbContext()) { model.Database.Migrate(); }
var viewState = ViewState.RetrieveDataFrom(CreateDbContext());
var projectC = new ProjectController(viewState, CreateDbContext);
var importC = new ImportController(viewState, CreateDbContext);
var databaseC = new DataBaseController(viewState, CreateDbContext);
var factorsC = new FactorsController(viewState, CreateDbContext);
var newdataC = new NewDataController(viewState, CreateDbContext);
var view = new MainWindow(viewState, importC, projectC, databaseC, factorsC, newdataC);
view.ShowDialog();
}
public MainWindow(
IReadOnlyViewState model,
ImportController importC,
ProjectController projectC,
DataBaseController databaseC,
FactorsController factorsC,
NewDataController newdataC)
{
InitializeComponent();
this.model = model;
this.importC = importC;
this.projectC = projectC;
this.databaseC = databaseC;
this.factorsC = factorsC;
this.newdataC = newdataC;
}
public static bool CreatePlayer(string nickname)
{
var dt = DataBaseController.ExecuteQuery($"SELECT * FROM PLAYER WHERE nickname = '{nickname}'");
if (dt.Rows.Count > 0)
{
return(true);
}
else
{
DataBaseController.ExecuteNonQuery("INSERT INTO PLAYER(nickname) VALUES" +
$"('{nickname}')");
return(false);
}
}
public static List <Player> ObtainTopPlayers()
{
var topPlayers = new List <Player>();
DataTable dt = DataBaseController.ExecuteQuery("SELECT pl.nickname, sc.score " +
"FROM PLAYER pl, SCORES sc " +
"WHERE pl.idPlayer = sc.idPlayer " +
"ORDER BY sc.score DESC " +
"LIMIT 10");
foreach (DataRow dr in dt.Rows)
{
topPlayers.Add(new Player(dr[0].ToString(), Convert.ToInt32(dr[1])));
}
return(topPlayers);
}
public void TestInitialize()
{
dataBase = new SimpleDataBase();
controller = new DataBaseController(dataBase);
dataBase.AddServer(new Server("test-8080", "test server", "DM", "TDM"));
dataBase.AddServer(new Server("test2-8080", "] My P3rfect Server [", "DM"));
var scoreBoard = new List <ScoreBoardUnit>()
{
new ScoreBoardUnit("Player1", 20, 21, 3),
new ScoreBoardUnit("Player2", 2, 2, 21)
};
dataBase.PutMatch("test-8080", "2017-01-22T15:17:00Z",
new MatchInfo("DM-HelloWorld", "DM", 20, 20, 12.345678, scoreBoard));
}
public void testLearningMenuStopSession()
{
var db = new DataBaseController();
var res = getToLearningMenu();
AssertNLP.contains(res, DBbotPhrase(Pkey.chooseStudyUnits));
var options = getOptions(res[1]);
res = sendBot("תשובה כלשהי");
res = sendBot("מספיק");
AssertNLP.contains(res, DBbotPhrase(Pkey.earlyDiparture));
AssertNLP.contains(res, DBbotPhrase(Pkey.areYouSure));
res = sendBot("כן");
AssertNLP.contains(res, DBbotPhrase(Pkey.goodbye));
res = sendBot("בי");
Assert.AreEqual(res, new string[] { });
}
public void PutCourseTest()
{
int expectedDifficulty = 5;
string expectedName = "testcourse";
string expectedDescription = "this is a test course";
var testCourse = CreateTestCourse(expectedName, expectedDescription, expectedDifficulty);
var controller = new DataBaseController();
using (TransactionScope ts = new TransactionScope())
{
var courseController = new CourseController();
courseController.PostCourse(testCourse);
var testingList = courseController.GetCourses();
Assert.IsTrue(
testingList.Exists(c => c.CourseName == expectedName && c.CourseDescription == expectedDescription && c.CourseDifficulty == expectedDifficulty)
);
}
}
public virtual string getPhrase(Pkey key, string[] flags = null, string[] flagesNot = null, string textVar = null)
{
Logger.addLog("Bot: " + Enum.GetName(typeof(Pkey), key));
if (flags == null)
{
flags = new string[] { }
}
;
if (flagesNot == null)
{
flagesNot = new string[] { }
}
;
var phrases = new DataBaseController().getBotPhrase(key, flags, flagesNot);
string phraseRes = null;
if (phrases.Length > 0)
{
var rundomInt = 0;
phraseRes = phrases[rundomInt];
}
else
{
// throw new botphraseException();
}
if (phraseRes != null)
{
return(phraseRes);
}
else
{
return("");
}
}
