Beispiel #1
0
        public void ResearcherSignTest()
        {
            Entities db = new Entities();

            // Arrange
            TempDataDictionary tempData = new TempDataDictionary();
            var ResearcherToDel         = DatabaseInsert.AddTestUser("Researcher", db);

            var projectToDel = DatabaseInsert.AddTestProject(ResearcherToDel, db, "Awaiting further action from Researcher");

            tempData["ActiveUser"] = ResearcherToDel;

            ResearchController controller = new ResearchController();

            controller.TempData = tempData;

            // Act
            ViewResult result = (ViewResult)controller.Sign(projectToDel.projectID);
            Entities   db2    = new Entities();

            db2.changes.Remove(db2.projects.Find(projectToDel.projectID).changes.First());
            db2.projects.Remove(db2.projects.Find(projectToDel.projectID));
            db2.users.Remove(db2.users.Find(ResearcherToDel.userID));
            db2.SaveChanges();

            // Assert
            Assert.IsNotNull(result);
            Assert.AreEqual("Index", result.ViewName);
            Assert.IsNotNull(result.TempData["ActiveUser"]);
            Assert.IsNotNull(result.Model);
            Assert.AreEqual(((List <project>)result.Model).First().projectID, projectToDel.projectID);
        }
Beispiel #2
0
        public void ResearcherDetailsTest()
        {
            Entities db = new Entities();

            // Arrange
            TempDataDictionary tempData = new TempDataDictionary();
            var researcherToDel         = DatabaseInsert.AddTestUser("Researcher", db);

            var projectToDel = DatabaseInsert.AddTestProject(researcherToDel, db);

            tempData["ActiveUser"] = researcherToDel;

            ResearchController controller = new ResearchController();

            controller.TempData = tempData;

            // Act
            ViewResult result = controller.Details(projectToDel.projectID) as ViewResult;

            // Assert
            Assert.IsNotNull(result);
            Assert.AreEqual("Details", result.ViewName);
            Assert.IsNotNull(result.TempData["ActiveUser"]);
            Assert.IsNotNull(result.Model);
            Assert.AreEqual(((project)result.Model).projectID, projectToDel.projectID);
            Assert.AreEqual(((project)result.Model).pName, projectToDel.pName);
            Assert.AreEqual(((project)result.Model).pDesc, projectToDel.pDesc);
            Assert.AreEqual(((project)result.Model).pAbstract, projectToDel.pAbstract);
            Assert.AreEqual(((project)result.Model).projectFile, projectToDel.projectFile);
            Assert.AreEqual(((project)result.Model).projectStage, projectToDel.projectStage);

            db.projects.Remove(projectToDel);
            db.users.Remove(researcherToDel);
            db.SaveChanges();
        }
Beispiel #3
0
        public void EditProjectTest()
        {
            Entities db = new Entities();
            // Arrange
            TempDataDictionary tempData = new TempDataDictionary();
            var researcherToDel         = DatabaseInsert.AddTestUser("Researcher", db);

            tempData["ActiveUser"] = researcherToDel;
            var pToDel = DatabaseInsert.AddTestProject(researcherToDel, db);
            ResearchController controller = new ResearchController
            {
                TempData = tempData
            };

            // Act
            ViewResult result = controller.EditProject(pToDel.projectID) as ViewResult;

            // Assert
            Assert.IsNotNull(result);
            Assert.AreEqual("EditProject", result.ViewName);
            Assert.IsNotNull(result.TempData["ActiveUser"]);
            Assert.IsNotNull(result.Model);
            Assert.AreEqual(((project)result.Model).projectID, pToDel.projectID);

            db.projects.Remove(pToDel);
            db.users.Remove(researcherToDel);
            db.SaveChanges();
        }
        public void DeanDetailsStandard()
        {
            //Connect to database
            Entities db = new Entities();

            //Create new TempData storage
            TempDataDictionary tempData = new TempDataDictionary();

            //Add test models to the database
            user    testUser    = DatabaseInsert.AddTestUser("Dean", db);
            project testProject = DatabaseInsert.AddTestProject(testUser, db);

            //Create controller instance
            tempData["ActiveUser"] = testUser;
            DeanController dean = new DeanController();

            dean.TempData = tempData;

            ViewResult action = (ViewResult)dean.Details(testProject.projectID);

            //Remove testing models from database
            db.projects.Remove(testProject);
            db.users.Remove(testUser);
            db.SaveChanges();

            //Main tests
            Assert.IsNotNull(action);
            Assert.IsNotNull(action.ViewData.Model);
            Assert.AreEqual(action.TempData["ActiveUser"], testUser);
        }
Beispiel #5
0
        public void HomeSignOut()
        {
            //Connect to database
            Entities db = new Entities();

            //Create new TempData storage
            TempDataDictionary tempData = new TempDataDictionary();

            //Create new user
            user testUser = DatabaseInsert.AddTestUser("Dean", db);

            tempData["ActiveUser"] = testUser;

            HomeController controller = new HomeController();

            controller.TempData = tempData;

            db.users.Remove(testUser);
            db.SaveChanges();

            ViewResult view = controller.SignOut() as ViewResult;

            //Main Tests
            Assert.IsNotNull(testUser);
            Assert.IsNotNull(view);
            Assert.AreEqual(null, view.TempData["ActiveUser"]);
            Assert.AreEqual("SignIn", view.ViewName);
        }
Beispiel #6
0
        public void AssociateIndexStandard()
        {
            //Connect to database
            Entities db = new Entities();

            //Create new TempData storage
            TempDataDictionary tempData = new TempDataDictionary();

            //Add test models to the database
            user    testUser    = DatabaseInsert.AddTestUser("AssociateDean", db);
            project testProject = DatabaseInsert.AddTestProject(testUser, db);

            //Create controller instance
            tempData["ActiveUser"] = testUser;

            AssociateController associate = new AssociateController();

            associate.TempData = tempData;

            ViewResult action = (ViewResult)associate.Index();

            //Remove testing models from database
            db.projects.Remove(testProject);
            db.users.Remove(testUser);
            db.SaveChanges();

            //Main Tests
            Assert.IsNotNull(action);
            Assert.IsNotNull(testUser);
            Assert.IsNotNull(action.ViewData.Model);
            Assert.IsNotNull(action.TempData["ActiveUser"]);
            Assert.AreEqual(action.TempData["ActiveUser"], testUser);
        }
Beispiel #7
0
        public void ResearcherIndexTest()
        {
            Entities db = new Entities();

            // Arrange
            TempDataDictionary tempData = new TempDataDictionary();
            var researcherToDel         = DatabaseInsert.AddTestUser("Researcher", db);

            var projectToDel = DatabaseInsert.AddTestProject(researcherToDel, db);

            tempData["ActiveUser"] = researcherToDel;

            ResearchController controller = new ResearchController();

            controller.TempData = tempData;

            // Act
            ViewResult result = controller.Index() as ViewResult;

            // Assert
            Assert.IsNotNull(result);
            Assert.AreEqual("Index", result.ViewName);
            Assert.IsNotNull(result.TempData["ActiveUser"]);
            Assert.IsNotNull(result.Model);
            Assert.AreEqual(((List <project>)result.Model).First().projectID, projectToDel.projectID);

            db.projects.Remove(projectToDel);
            db.users.Remove(researcherToDel);
            db.SaveChanges();
        }
Beispiel #8
0
        public void DownloadProjectTest()
        {
            Entities db = new Entities();
            // Arrange
            TempDataDictionary tempData = new TempDataDictionary();
            var researcherToDel         = DatabaseInsert.AddTestUser("Researcher", db);

            tempData["ActiveUser"] = researcherToDel;
            var pToDel = DatabaseInsert.AddTestProject(researcherToDel, db);
            ResearchController controller = new ResearchController
            {
                TempData = tempData
            };

            // Act
            FileResult result = controller.Download(pToDel.projectID) as FileResult;

            // Assert
            Assert.IsNotNull(result);
            Assert.AreEqual(pToDel.pName + "-ExpenditureFile" + Path.GetExtension(pToDel.projectFile), result.FileDownloadName);
            Assert.AreEqual("application/" + Path.GetExtension(pToDel.projectFile), result.ContentType);

            db.projects.Remove(pToDel);
            db.users.Remove(researcherToDel);
            db.SaveChanges();
        }
 public static IQuery Insert(IRegistration registration, long forCustomerId)
 {
     return(DatabaseInsert.Into(AuthorizationTable.TableName)
            .AddValue(AuthorizationTable.CustomerID, forCustomerId.ToString( ))
            .AddValue(AuthorizationTable.UserName, registration.Username( ))
            .AddValue(AuthorizationTable.Password, registration.Password( ))
            .Build( ));
 }
Beispiel #10
0
 public static IQuery Insert()
 {
     return(DatabaseInsert.Into(CustomerTable.TableName)
            .AddValue(CustomerTable.FirstName, string.Empty)
            .AddValue(CustomerTable.LastName, string.Empty)
            .AddValue(CustomerTable.Phone, string.Empty)
            .AddValue(CustomerTable.City, string.Empty).Build( ));
 }
Beispiel #11
0
        public static long CreateCustomerRecord()
        {
            IInsertQueryBuilder builder = DatabaseInsert.Into(CustomerTable.TableName)
                                          .AddValue(CustomerTable.FirstName, string.Empty)
                                          .AddValue(CustomerTable.LastName, string.Empty)
                                          .AddValue(CustomerTable.Phone, string.Empty)
                                          .AddValue(CustomerTable.City, string.Empty);

            return(Resolve.DependencyFor <IDatabaseGateway>( ).ExecuteScalar(builder.Build( )));
        }
Beispiel #12
0
        public static long CreateSlip()
        {
            IQuery query = DatabaseInsert
                           .Into(SlipTable.TableName)
                           .AddValue(SlipTable.DockID, 1)
                           .AddValue(SlipTable.Length, 100)
                           .AddValue(SlipTable.Width, 100).Build( );

            return(Resolve.DependencyFor <IDatabaseGateway>( ).ExecuteScalar(query));
        }
        private long CreateCustomerRecord()
        {
            IQuery query = DatabaseInsert.Into(CustomerTable.TableName)
                           .AddValue(CustomerTable.FirstName, string.Empty)
                           .AddValue(CustomerTable.LastName, string.Empty)
                           .AddValue(CustomerTable.Phone, string.Empty)
                           .AddValue(CustomerTable.City, string.Empty).Build( );

            return(Resolve.DependencyFor <IDatabaseGateway>( ).ExecuteScalar(query));
        }
Beispiel #14
0
        public static void AddBoatsFor(long customerId)
        {
            IInsertQueryBuilder builder = DatabaseInsert.Into(BoatTable.TableName)
                                          .AddValue(BoatTable.RegistrationNumber, string.Empty)
                                          .AddValue(BoatTable.Manufacturer, string.Empty)
                                          .AddValue(BoatTable.ModelYear, string.Empty)
                                          .AddValue(BoatTable.Length, string.Empty)
                                          .AddValue(BoatTable.CustomerID, customerId.ToString( ));

            Resolve.DependencyFor <IDatabaseGateway>( ).Execute(builder.Build( ), builder.Build( ), builder.Build( ));
        }
Beispiel #15
0
 public static IEnumerable <IQuery> InsertQueriesFor(IEnumerable <IBoat> boats, long customerId)
 {
     foreach (IBoat boat in boats)
     {
         yield return(DatabaseInsert.Into(BoatTable.TableName)
                      .AddValue(BoatTable.CustomerID, customerId)
                      .AddValue(BoatTable.Length, boat.LengthInFeet( ))
                      .AddValue(BoatTable.Manufacturer, boat.Manufacturer( ))
                      .AddValue(BoatTable.ModelYear, boat.YearOfModel( ).Year)
                      .AddValue(BoatTable.RegistrationNumber, boat.RegistrationNumber( )).Build( ));
     }
 }
Beispiel #16
0
        public static void CreateLeaseFor(long customerId)
        {
            IQuery query = DatabaseInsert
                           .Into(LeaseTable.TableName)
                           .AddValue(LeaseTable.CustomerID, customerId)
                           .AddValue(LeaseTable.EndDate, DateTime.Now.AddDays(1))
                           .AddValue(LeaseTable.LeaseTypeID, 1)
                           .AddValue(LeaseTable.SlipID, SlipMother.CreateSlip( ))
                           .AddValue(LeaseTable.StartDate, DateTime.Now).Build( );

            Resolve.DependencyFor <IDatabaseGateway>( ).Execute(query);
        }
Beispiel #17
0
        public void EditProjectRedirectTest()
        {
            Entities db = new Entities();

            // Arrange
            TempDataDictionary tempDataRIS        = new TempDataDictionary();
            TempDataDictionary tempDataResearcher = new TempDataDictionary();

            var RISToDel        = DatabaseInsert.AddTestUser("RIS", db);
            var ResearcherToDel = DatabaseInsert.AddTestUser("Researcher", db);
            var pToDel          = DatabaseInsert.AddTestProject(ResearcherToDel, db);
            var pToDelRIS       = DatabaseInsert.AddTestProject(RISToDel, db);


            tempDataRIS["ActiveUser"]        = RISToDel;
            tempDataResearcher["ActiveUser"] = ResearcherToDel;

            ResearchController RISResearchController = new ResearchController();

            RISResearchController.TempData = tempDataRIS;

            ResearchController ResearchController = new ResearchController();

            ResearchController.TempData = tempDataResearcher;

            // Act
            RedirectToRouteResult resultRIS        = (RedirectToRouteResult)RISResearchController.EditProject(pToDelRIS.projectID) as RedirectToRouteResult;
            ViewResult            resultResearcher = (ViewResult)ResearchController.EditProject(pToDel.projectID) as ViewResult;

            db.projects.Remove(pToDelRIS);
            db.projects.Remove(pToDel);
            db.users.Remove(RISToDel);
            db.users.Remove(ResearcherToDel);
            db.SaveChanges();

            // Assert 'Other User'
            Assert.IsNotNull(resultRIS);
            Assert.IsTrue(resultRIS.RouteValues.ContainsKey("action"));
            Assert.IsTrue(resultRIS.RouteValues.ContainsKey("controller"));
            Assert.AreEqual("ControllerChange", resultRIS.RouteValues["action"].ToString());
            Assert.AreEqual("Home", resultRIS.RouteValues["controller"].ToString());

            //Assert Researcher
            Assert.IsNotNull(resultResearcher);
            Assert.AreEqual("EditProject", resultResearcher.ViewName);
        }
Beispiel #18
0
        public static long CreateCustomerRecordWith(string username)
        {
            IInsertQueryBuilder builder = DatabaseInsert.Into(CustomerTable.TableName)
                                          .AddValue(CustomerTable.FirstName, string.Empty)
                                          .AddValue(CustomerTable.LastName, string.Empty)
                                          .AddValue(CustomerTable.Phone, string.Empty)
                                          .AddValue(CustomerTable.City, string.Empty);
            long customerId = Resolve.DependencyFor <IDatabaseGateway>( ).ExecuteScalar(builder.Build( ));

            IQuery insertToAuthTable = DatabaseInsert.Into(AuthorizationTable.TableName)
                                       .AddValue(AuthorizationTable.UserName, username)
                                       .AddValue(AuthorizationTable.Password, string.Empty)
                                       .Build( );

            Resolve.DependencyFor <IDatabaseGateway>( ).Execute(insertToAuthTable);
            return(customerId);
        }
Beispiel #19
0
 public void Insert(IEnumerable <ISlipLease> leases, long forCustomerId)
 {
     using (IDatabaseTransaction transaction = new DatabaseTransaction( )) {
         IList <IQuery> queries = new List <IQuery>( );
         foreach (ISlipLease lease in leases)
         {
             queries.Add(
                 DatabaseInsert.Into(LeaseTable.TableName)
                 .AddValue(LeaseTable.StartDate, lease.StartDate( ))
                 .AddValue(LeaseTable.EndDate, lease.ExpiryDate( ))
                 .AddValue(LeaseTable.SlipID, lease.Slip( ).ID( ))
                 .AddValue(LeaseTable.CustomerID, forCustomerId)
                 .AddValue(LeaseTable.LeaseTypeID, lease.Duration( ).ID( )).Build( )
                 );
         }
         _gateway.Execute(queries);
         transaction.Commit( );
     }
 }
        public void DeanDetailsRedirect()
        {
            //Connect to database
            Entities db = new Entities();

            //Create new TempData storage
            TempDataDictionary tempData = new TempDataDictionary();

            //Add test models to the database
            user    testUser    = DatabaseInsert.AddTestUser("Dean", db);
            project testProject = DatabaseInsert.AddTestProject(testUser, db);

            //Create controller instance
            tempData["ActiveUser"] = testUser;
            DeanController deanNullProject = new DeanController();
            DeanController deanNullUser    = new DeanController();

            deanNullProject.TempData = tempData;

            //remove test project before usage
            db.projects.Remove(testProject);
            db.SaveChanges();

            //Return view with invalid projectID
            RedirectToRouteResult result  = (RedirectToRouteResult)deanNullProject.Details(testProject.projectID);
            RedirectToRouteResult result2 = (RedirectToRouteResult)deanNullUser.Details(testProject.projectID);

            db.users.Remove(testUser);
            db.SaveChanges();

            //Main Tests
            Assert.IsNotNull(result);
            Assert.IsTrue(result.RouteValues.ContainsKey("action"));
            Assert.IsTrue(result.RouteValues.ContainsKey("controller"));
            Assert.AreEqual("Index", result.RouteValues["action"].ToString());
            Assert.AreEqual("Dean", result.RouteValues["controller"].ToString());

            Assert.IsNotNull(result2);
            Assert.IsTrue(result2.RouteValues.ContainsKey("action"));
            Assert.IsTrue(result2.RouteValues.ContainsKey("controller"));
            Assert.AreEqual("SignIn", result2.RouteValues["action"].ToString());
            Assert.AreEqual("Home", result2.RouteValues["controller"].ToString());
        }
Beispiel #21
0
        public void DownloadProjectRedirectTest()
        {
            Entities db = new Entities();

            // Arrange
            TempDataDictionary tempDataRIS        = new TempDataDictionary();
            TempDataDictionary tempDataResearcher = new TempDataDictionary();

            var RISToDel        = DatabaseInsert.AddTestUser("RIS", db);
            var ResearcherToDel = DatabaseInsert.AddTestUser("Researcher", db);
            var pToDel          = DatabaseInsert.AddTestProject(ResearcherToDel, db);
            var pToDelRIS       = DatabaseInsert.AddTestProject(RISToDel, db);


            tempDataRIS["ActiveUser"]        = RISToDel;
            tempDataResearcher["ActiveUser"] = ResearcherToDel;

            ResearchController RISResearchController = new ResearchController();

            RISResearchController.TempData = tempDataRIS;

            ResearchController ResearchController = new ResearchController();

            ResearchController.TempData = tempDataResearcher;

            // Act
            FileResult resultRIS        = (FileResult)RISResearchController.Download(pToDelRIS.projectID) as FileResult;
            FileResult resultResearcher = ResearchController.Download(pToDel.projectID) as FileResult;

            db.projects.Remove(pToDelRIS);
            db.projects.Remove(pToDel);
            db.users.Remove(RISToDel);
            db.users.Remove(ResearcherToDel);
            db.SaveChanges();

            // Assert 'Other User'
            Assert.IsNull(resultRIS);

            //Assert Researcher
            Assert.IsNotNull(resultResearcher);
            Assert.AreEqual(pToDel.pName + "-ExpenditureFile" + Path.GetExtension(pToDel.projectFile), resultResearcher.FileDownloadName);
            Assert.AreEqual("application/" + Path.GetExtension(pToDel.projectFile), resultResearcher.ContentType);
        }
Beispiel #22
0
        public void CreateProjectTest()
        {
            Entities db = new Entities();
            // Arrange
            TempDataDictionary tempData = new TempDataDictionary();
            var researcherToDel         = DatabaseInsert.AddTestUser("Researcher", db);

            tempData["ActiveUser"] = researcherToDel;
            ResearchController controller = new ResearchController
            {
                TempData = tempData
            };

            // Act
            ViewResult result = controller.CreateProject() as ViewResult;

            // Assert
            Assert.IsNotNull(result);
            Assert.AreEqual("CreateProject", result.ViewName);
            Assert.IsNotNull(result.TempData["ActiveUser"]);
            db.users.Remove(researcherToDel);
        }
Beispiel #23
0
        public void addToHistoryTest()
        {
            //Arrange
            Entities db          = new Entities();
            var      tempUser    = DatabaseInsert.AddTestUser("Researcher", db);
            var      tempProject = DatabaseInsert.AddTestProject(tempUser, db);
            string   changeSum   = "Test Change Sum";

            //ACT
            HelperClasses.SharedControllerMethods.addToHistory(tempUser.userID, tempProject.projectID, changeSum);
            Entities db2 = new Entities();

            var found = db2.projects.Find(tempProject.projectID).changes.First().changeSummary;

            //Assert
            Assert.AreEqual(changeSum, found);

            //Clean Up

            db2.changes.Remove(db2.projects.Find(tempProject.projectID).changes.First());
            db2.projects.Remove(db2.projects.Find(tempProject.projectID));
            db2.users.Remove(db2.users.Find(tempUser.userID));
            db2.SaveChanges();
        }
Beispiel #24
0
        private void OrderBtn_Click(object sender, EventArgs e)
        {
            bool control = false;

            if (SudeCombo.Text == "Tasting  250CC")
            {
                Baverages tasting = new LeShokaladeSude();
                tasting = new Tasting(tasting);
                DatabaseInsert insert = new DatabaseInsert();
                insert.Connection();
                insert.InsertOrders(Table, "Tasting Sude", tasting.GetPrice() * Convert.ToDouble(SudeUpDown.Value), Convert.ToInt32(SudeUpDown.Value));
                insert.Execute();
                insert.Close();
                control = true;
            }
            if (SudeCombo.Text == "Filling  400CC")
            {
                Baverages filling = new LeShokaladeSude();
                filling = new Filling(filling);
                DatabaseInsert insert = new DatabaseInsert();
                insert.Connection();
                insert.InsertOrders(Table, "Filling Sude", filling.GetPrice() * Convert.ToDouble(SudeUpDown.Value), Convert.ToInt32(SudeUpDown.Value));
                insert.Execute();
                insert.Close();
                control = true;
            }
            if (NerimanCombo.Text == "Tasting  250CC")
            {
                Baverages tasting = new LeShokaladeNeriman();
                tasting = new Tasting(tasting);
                DatabaseInsert insert = new DatabaseInsert();
                insert.Connection();
                insert.InsertOrders(Table, "Tasting Neriman", tasting.GetPrice() * Convert.ToDouble(NerimanUpdown.Value), Convert.ToInt32(NerimanUpdown.Value));
                insert.Execute();
                insert.Close();
                control = true;
            }
            if (NerimanCombo.Text == "Filling  400CC")
            {
                Baverages filling = new LeShokaladeNeriman();
                filling = new Filling(filling);
                DatabaseInsert insert = new DatabaseInsert();
                insert.Connection();
                insert.InsertOrders(Table, "Filling Neriman", filling.GetPrice() * Convert.ToDouble(NerimanUpdown.Value), Convert.ToInt32(NerimanUpdown.Value));
                insert.Execute();
                insert.Close();
                control = true;
            }
            if (WaffleCheck.Checked == true)
            {
                DatabaseInsert insert = new DatabaseInsert();
                insert.Connection();
                insert.InsertOrders(Table, "Waffle", 10 * Convert.ToInt32(WaffleUpDown.Value), Convert.ToInt32(WaffleUpDown.Value));
                insert.Execute();
                insert.Close();
                control = true;
            }
            if (control)
            {
                MessageBox.Show("Your order has been received.", "Thank You :)");
                SudeCombo.SelectedIndex    = 0;
                NerimanCombo.SelectedIndex = 0;
                WaffleCheck.Checked        = false;
            }
            else
            {
                MessageBox.Show("You did not choose any order!", "Warning!!", MessageBoxButtons.OK, MessageBoxIcon.Warning);
            }
        }
Beispiel #25
0
 private void GiveOrder_Click(object sender, EventArgs e)
 {
     if (string.IsNullOrEmpty(Customer.Text))
     {
         MessageBox.Show("Please specify a name!", "Warning!!", MessageBoxButtons.OK, MessageBoxIcon.Warning);
     }
     else
     {
         bool control = false;
         foreach (string choice in ProductList.CheckedItems)
         {
             string CustomerSent = Customer.Text;
             if (choice == "TastingSude")
             {
                 Baverages tasting = new LeShokaladeSude();
                 tasting = new Tasting(tasting);
                 DatabaseInsert insert = new DatabaseInsert();
                 insert.Connection();
                 insert.InsertTakeAway(CustomerSent, choice, tasting.GetPrice());
                 insert.Execute();
                 insert.Close();
                 control = true;
             }
             if (choice == "FillingSude")
             {
                 Baverages filling = new LeShokaladeSude();
                 filling = new Filling(filling);
                 DatabaseInsert insert = new DatabaseInsert();
                 insert.Connection();
                 insert.InsertTakeAway(CustomerSent, choice, filling.GetPrice());
                 insert.Execute();
                 insert.Close();
                 control = true;
             }
             if (choice == "TastingNeriman")
             {
                 Baverages tasting = new LeShokaladeNeriman();
                 tasting = new Tasting(tasting);
                 DatabaseInsert insert = new DatabaseInsert();
                 insert.Connection();
                 insert.InsertTakeAway(CustomerSent, choice, tasting.GetPrice());
                 insert.Execute();
                 insert.Close();
                 control = true;
             }
             if (choice == "FillingNeriman")
             {
                 Baverages filling = new LeShokaladeNeriman();
                 filling = new Filling(filling);
                 DatabaseInsert insert = new DatabaseInsert();
                 insert.Connection();
                 insert.InsertTakeAway(CustomerSent, choice, filling.GetPrice());
                 insert.Execute();
                 insert.Close();
                 control = true;
             }
             if (choice == "Lemonade")
             {
                 Baverages      bev    = new Lemonade();
                 DatabaseInsert insert = new DatabaseInsert();
                 insert.Connection();
                 insert.InsertTakeAway(CustomerSent, bev.GetDescription(), bev.GetPrice());
                 insert.Execute();
                 insert.Close();
                 control = true;
             }
             if (choice == "Americano")
             {
                 Baverages      bev    = new Americano();
                 DatabaseInsert insert = new DatabaseInsert();
                 insert.Connection();
                 insert.InsertTakeAway(CustomerSent, bev.GetDescription(), bev.GetPrice());
                 insert.Execute();
                 insert.Close();
                 control = true;
             }
             if (choice == "MilkyAmericano")
             {
                 Baverages bev = new Americano();
                 bev = new Milk(bev);
                 DatabaseInsert insert = new DatabaseInsert();
                 insert.Connection();
                 insert.InsertTakeAway(CustomerSent, bev.GetDescription(), bev.GetPrice());
                 insert.Execute();
                 insert.Close();
                 control = true;
             }
         }
         if (control)
         {
             MessageBox.Show("Your order has been received.", "Thank you :)");
             AbstractStore store = new LeShokaladeDukkan();
             Box.Text = store.OrderDessert("sude").Box();
             for (int i = 0; i < ProductList.Items.Count; i++)
             {
                 ProductList.SetItemChecked(i, false);
             }
             Orders.Text   = " ";
             Customer.Text = "Your Name";
         }
         else
         {
             MessageBox.Show("You did not choose any order!", "Warning!!", MessageBoxButtons.OK, MessageBoxIcon.Warning);
         }
     }
 }
Beispiel #26
0
        private void Order_Click(object sender, EventArgs e)
        {
            bool control = false;

            if (LemonCheck.Checked)
            {
                Baverages      bev    = new Lemonade();
                DatabaseInsert insert = new DatabaseInsert();
                insert.Connection();
                insert.InsertOrders(Table, bev.GetDescription(), bev.GetPrice() * Convert.ToDouble(LemonUpDown.Value), Convert.ToInt32(LemonUpDown.Value));
                insert.Execute();
                insert.Close();
                control = true;
            }
            if (AmericanoCheck.Checked)
            {
                if (NormalAmericano.Checked)
                {
                    Baverages      bev    = new Americano();
                    DatabaseInsert insert = new DatabaseInsert();
                    insert.Connection();
                    insert.InsertOrders(Table, bev.GetDescription(), bev.GetPrice() * Convert.ToDouble(AmericanoUpDown.Value), Convert.ToInt32(AmericanoUpDown.Value));
                    insert.Execute();
                    insert.Close();
                    control = true;
                }
                if (ExtraAmericano.Checked)
                {
                    Baverages bev = new Americano();
                    bev = new Milk(bev);
                    DatabaseInsert insert = new DatabaseInsert();
                    insert.Connection();
                    insert.InsertOrders(Table, bev.GetDescription(), bev.GetPrice() * Convert.ToDouble(AmericanoUpDown.Value), Convert.ToInt32(AmericanoUpDown.Value));
                    insert.Execute();
                    insert.Close();
                    control = true;
                }
            }
            if (TCoffeeCheck.Checked)
            {
                if (SugarFree.Checked)
                {
                    Baverages bev = new TurkishCoffee();
                    bev = new SugarFree(bev);
                    DatabaseInsert insert = new DatabaseInsert();
                    insert.Connection();
                    insert.InsertOrders(Table, bev.GetDescription(), bev.GetPrice() * Convert.ToDouble(TCoffeeUpDown.Value), Convert.ToInt32(TCoffeeUpDown.Value));
                    insert.Execute();
                    insert.Close();
                    control = true;
                }
                if (MidSugar.Checked)
                {
                    Baverages bev = new TurkishCoffee();
                    bev = new MidSugar(bev);
                    DatabaseInsert insert = new DatabaseInsert();
                    insert.Connection();
                    insert.InsertOrders(Table, bev.GetDescription(), bev.GetPrice() * Convert.ToDouble(TCoffeeUpDown.Value), Convert.ToInt32(TCoffeeUpDown.Value));
                    insert.Execute();
                    insert.Close();
                    control = true;
                }
                if (Sugary.Checked)
                {
                    Baverages bev = new TurkishCoffee();
                    bev = new Sugary(bev);
                    DatabaseInsert insert = new DatabaseInsert();
                    insert.Connection();
                    insert.InsertOrders(Table, bev.GetDescription(), bev.GetPrice() * Convert.ToDouble(TCoffeeUpDown.Value), Convert.ToInt32(TCoffeeUpDown.Value));
                    insert.Execute();
                    insert.Close();
                    control = true;
                }
            }
            if (control)
            {
                MessageBox.Show("Your order has been received.");
                LemonCheck.Checked     = false;
                AmericanoCheck.Checked = false;
                TCoffeeCheck.Checked   = false;
            }
            else
            {
                MessageBox.Show("You did not choose any order!", "Warning!!", MessageBoxButtons.OK, MessageBoxIcon.Warning);
            }
        }
Beispiel #27
0
        public void ResearcherSignRedirectTest()
        {
            Entities db = new Entities();

            // Arrange
            TempDataDictionary tempData    = new TempDataDictionary();
            TempDataDictionary tempDataRIS = new TempDataDictionary();
            var ResearcherToDel            = DatabaseInsert.AddTestUser("Researcher", db);

            var RISToDel = DatabaseInsert.AddTestUser("RIS", db);



            var projectToDel = DatabaseInsert.AddTestProject(ResearcherToDel, db, "Awaiting further action from Researcher");

            var projectToDelRIS = DatabaseInsert.AddTestProject(RISToDel, db, "Awaiting further action from Researcher");

            tempData["ActiveUser"]    = ResearcherToDel;
            tempDataRIS["ActiveUser"] = RISToDel;

            ResearchController controller = new ResearchController();

            controller.TempData = tempData;

            ResearchController RIScontroller = new ResearchController();

            RIScontroller.TempData = tempDataRIS;

            // Act
            ViewResult result = (ViewResult)controller.Sign(projectToDel.projectID);

            RedirectToRouteResult resultRIS = (RedirectToRouteResult)RIScontroller.Sign(projectToDel.projectID);

            Entities db2 = new Entities();

            db2.changes.Remove(db2.projects.Find(projectToDel.projectID).changes.First());
            db2.projects.Remove(db2.projects.Find(projectToDel.projectID));
            db2.users.Remove(db2.users.Find(ResearcherToDel.userID));

            db2.projects.Remove(db2.projects.Find(projectToDelRIS.projectID));
            db2.users.Remove(db2.users.Find(RISToDel.userID));
            db2.SaveChanges();

            // Assert
            Assert.IsNotNull(resultRIS);
            Assert.IsTrue(resultRIS.RouteValues.ContainsKey("action"));
            Assert.IsTrue(resultRIS.RouteValues.ContainsKey("controller"));
            Assert.AreEqual("ControllerChange", resultRIS.RouteValues["action"].ToString());
            Assert.AreEqual("Home", resultRIS.RouteValues["controller"].ToString());

            Assert.IsNotNull(result);
            Assert.AreEqual("Index", result.ViewName);
            Assert.IsNotNull(result.TempData["ActiveUser"]);
            Assert.IsNotNull(result.Model);
            Assert.AreEqual(((List <project>)result.Model).First().projectID, projectToDel.projectID);

            /*
             * Entities db = new Entities();
             *
             * // Arrange
             * TempDataDictionary tempDataRIS = new TempDataDictionary();
             * TempDataDictionary tempDataResearcher = new TempDataDictionary();
             *
             * var RISToDel = DatabaseInsert.AddTestUser("RIS", db);
             * var ResearcherToDel = DatabaseInsert.AddTestUser("Researcher", db);
             * var projectToDelRIS = DatabaseInsert.AddTestProject(RISToDel, db);
             * var projectToDelResearcher = DatabaseInsert.AddTestProject(ResearcherToDel, db);
             *
             * tempDataRIS["ActiveUser"] = RISToDel;
             * tempDataResearcher["ActiveUser"] = ResearcherToDel;
             *
             * RISController ResearchRISController = new RISController();
             * ResearchRISController.TempData = tempDataResearcher;
             *
             * RISController RISController = new RISController();
             * RISController.TempData = tempDataRIS;
             *
             * // Act
             * RedirectToRouteResult resultResearcher = (RedirectToRouteResult)ResearchRISController.Details(projectToDelRIS.projectID) as RedirectToRouteResult;
             * ViewResult resultRIS = (ViewResult)RISController.Details(projectToDelResearcher.projectID) as ViewResult;
             *
             * Entities db2 = new Entities();
             * db2.changes.Remove(db2.projects.Find(projectToDel.projectID).changes.First());
             * db2.projects.Remove(db2.projects.Find(projectToDel.projectID));
             * db2.users.Remove(db2.users.Find(ResearcherToDel.userID));
             * db2.SaveChanges();
             *
             * // Assert 'Other User'
             * Assert.IsNotNull(resultResearcher);
             * Assert.IsTrue(resultResearcher.RouteValues.ContainsKey("action"));
             * Assert.IsTrue(resultResearcher.RouteValues.ContainsKey("controller"));
             * Assert.AreEqual("ControllerChange", resultResearcher.RouteValues["action"].ToString());
             * Assert.AreEqual("Home", resultResearcher.RouteValues["controller"].ToString());
             *
             * //Assert RIS
             * Assert.IsNotNull(resultRIS);
             * Assert.AreEqual("Details", resultRIS.ViewName);
             */
        }