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(""); } }