public void AttachData_Transaction()
        {
            List <BmsHospital> list = null;

            list = balHospital.GetAll();
            WindowChildren windowChildren = new WindowChildren();

            windowChildren.AttachData_Transaction(balTransaction, sbTbAppStatus, list);
            AddTab("Transaction", windowChildren.childWindowHolder);
        }
コード例 #2
0
        private void txtSearch_ExecuteQuery(string query)
        {
            try
            {
                query = RemoveSpecialCharacters(query.Trim().ToLower()).Trim();
                string[] words = query.Split(' ');

                if (TestContains(words[0], keyWords_add))
                {
                    if (TestContains(words[1], keyWords_bank))
                    {
                        //ManageData_Bank(ActionMode.ADD, null, "Add New Bank Details");
                        CallManageFunction(ManageData_Bank, ActionMode.ADD, null, "Add New Bank Details");
                    }

                    if (TestContains(words[1], keyWords_camp))
                    {
                        //ManageData_Camp(ActionMode.ADD, null, "Add New Event Details");
                        CallManageFunction(ManageData_Camp, ActionMode.ADD, null, "Add New Event Details");
                    }
                    if (TestContains(words[1], keyWords_donation))
                    {
                        //ManageData_Donation(ActionMode.ADD, null, "Add Donation Details");
                        CallManageFunction(ManageData_Donation, ActionMode.ADD, null, "Add Donation Details");
                    }
                    if (TestContains(words[1], keyWords_donor))
                    {
                        //ManageData_Donor(ActionMode.ADD, null, "Add Donor Details");
                        CallManageFunction(ManageData_Donor, ActionMode.ADD, null, "Add Donor Details");
                    }

                    if (TestContains(words[1], keyWords_hospital))
                    {
                        //ManageData_Hospital(ActionMode.ADD, null, "Add Hospital Details");
                        CallManageFunction(ManageData_Hospital, ActionMode.ADD, null, "Add Hospital Details");
                    }
                    if (TestContains(words[1], keyWords_inventory))
                    {
                        //ManageData_Inventory(ActionMode.ADD, null, "Add Inventory Details");
                        CallManageFunction(ManageData_Inventory, ActionMode.ADD, null, "Add Inventory Details");
                    }
                    if (TestContains(words[1], keyWords_transaction))
                    {
                        //ManageData_Transaction(ActionMode.ADD, null, "Add Transaction");
                        CallManageFunction(ManageData_Transaction, ActionMode.ADD, null, "Make Transaction");
                    }
                }

                if (TestContains(words[0], keyWords_view))
                {
                    if (TestContains(words[1], keyWords_bank))
                    {
                        if (words.Length > 2)
                        {
                            if (!string.IsNullOrEmpty(words[2]))
                            {
                                int    id    = int.Parse(words[2]);
                                object value = balBank.GetAll().FirstOrDefault(c => c.BloodBankID == id);
                                ManageData_Bank(ActionMode.UPDATE, value, "View Bank Details for ID " + id);
                            }
                        }
                        else
                        {
                            List <BmsBloodBank> list = null;
                            list = balBank.GetAll();
                            WindowChildren windowChildren = new WindowChildren();
                            windowChildren.AttachData_Bank(balBank, sbTbAppStatus, list);
                            AddTab("View Blood Bank", windowChildren.childWindowHolder);
                        }
                    }

                    if (TestContains(words[1], keyWords_camp))
                    {
                        if (words.Length > 2)
                        {
                            if (!string.IsNullOrEmpty(words[2]))
                            {
                                int    id    = int.Parse(words[2]);
                                object value = balCamp.GetAll().FirstOrDefault(c => c.BloodDonationCampID == id);
                                ManageData_Camp(ActionMode.UPDATE, value, "View Donation Camps Details for ID " + id);
                            }
                        }
                        else
                        {
                            List <BmsBloodDonationCamp> list = null;
                            list = balCamp.GetAll();
                            WindowChildren windowChildren = new WindowChildren();
                            windowChildren.AttachData_Camp(balCamp, sbTbAppStatus, list);
                            AddTab("View Donation Camps Details", windowChildren.childWindowHolder);
                        }
                    }

                    if (TestContains(words[1], keyWords_donation))
                    {
                        //ManageData_Donation(ActionMode.ADD, null, "Add Donation Details");
                        if (words.Length > 2)
                        {
                            if (!string.IsNullOrEmpty(words[2]))
                            {
                                int    id    = int.Parse(words[2]);
                                object value = balDonation.GetAll().FirstOrDefault(c => c.BloodDonationCampID == id);
                                ManageData_Donation(ActionMode.UPDATE, value, "View Donation Details for ID " + id);
                            }
                        }
                        else
                        {
                            List <BmsBloodDonorDonation> list = null;
                            list = balDonation.GetAll();
                            WindowChildren windowChildren = new WindowChildren();
                            windowChildren.AttachData_Donation(balDonation, sbTbAppStatus, list);
                            AddTab("View Donation Details", windowChildren.childWindowHolder);
                        }
                    }
                    if (TestContains(words[1], keyWords_donor))
                    {
                        //ManageData_Donor(ActionMode.ADD, null, "Add Donor Details");
                        if (words.Length > 2)
                        {
                            if (!string.IsNullOrEmpty(words[2]))
                            {
                                int    id    = int.Parse(words[2]);
                                object value = balDonor.GetAll().FirstOrDefault(c => c.BloodDonorID == id);
                                ManageData_Donor(ActionMode.UPDATE, value, "View Donor Details for ID " + id);
                            }
                        }
                        else
                        {
                            List <BmsBloodDonor> list = null;
                            list = balDonor.GetAll();
                            WindowChildren windowChildren = new WindowChildren();
                            windowChildren.AttachData_Donor(balDonor, sbTbAppStatus, list);
                            AddTab("View Donor Details", windowChildren.childWindowHolder);
                        }
                    }

                    if (TestContains(words[1], keyWords_hospital))
                    {
                        //ManageData_Hospital(ActionMode.ADD, null, "Add Hospital Details");
                        if (words.Length > 2)
                        {
                            if (!string.IsNullOrEmpty(words[2]))
                            {
                                int    id    = int.Parse(words[2]);
                                object value = balHospital.GetAll().FirstOrDefault(c => c.HospitalID == id);
                                ManageData_Hospital(ActionMode.UPDATE, value, "View Hospital for ID " + id);
                            }
                        }
                        else
                        {
                            List <BmsHospital> list = null;
                            list = balHospital.GetAll();
                            WindowChildren windowChildren = new WindowChildren();
                            windowChildren.AttachData_Hospital(balHospital, sbTbAppStatus, list);
                            AddTab("View Hospital Details", windowChildren.childWindowHolder);
                        }
                    }
                    if (TestContains(words[1], keyWords_inventory))
                    {
                        //ManageData_Inventory(ActionMode.ADD, null, "Add Inventory Details");
                        if (words.Length > 2)
                        {
                            if (!string.IsNullOrEmpty(words[2]))
                            {
                                int    id    = int.Parse(words[2]);
                                object value = balInventory.GetAll().FirstOrDefault(c => c.BloodInventoryID == id);
                                ManageData_Inventory(ActionMode.UPDATE, value, "View Inventory for ID " + id);
                            }
                        }
                        else
                        {
                            List <BmsBloodInventory> list = null;
                            list = balInventory.GetAll();
                            WindowChildren windowChildren = new WindowChildren();
                            windowChildren.AttachData_Inventory(balInventory, sbTbAppStatus, list);
                            AddTab("View Inventory Details", windowChildren.childWindowHolder);
                        }
                    }
                    if (TestContains(words[1], keyWords_transaction))
                    {
                        //ManageData_Transaction(ActionMode.ADD, null, "Add Transaction");
                        if (words.Length > 2)
                        {
                            if (!string.IsNullOrEmpty(words[2]))
                            {
                                int    id    = int.Parse(words[2]);
                                object value = balTransaction.GetAll().FirstOrDefault(c => c.BloodInventoryID == id);
                                ManageData_Transaction(ActionMode.UPDATE, value, "View Transaction for ID " + id);
                            }
                        }
                        else
                        {
                            List <BmsTransaction> list = null;
                            list = balTransaction.GetAll();
                            WindowChildren windowChildren = new WindowChildren();
                            windowChildren.AttachData_Transaction(balTransaction, sbTbAppStatus, list);
                            AddTab("View Transaction Details", windowChildren.childWindowHolder);
                        }
                    }
                }

                if (TestContains(words[0], keyWords_delete))
                {
                    if (TestContains(words[1], keyWords_bank))
                    {
                        if (words.Length > 2)
                        {
                            if (!string.IsNullOrEmpty(words[2]))
                            {
                                int    id    = int.Parse(words[2]);
                                object value = balBank.GetAll().FirstOrDefault(c => c.BloodBankID == id);
                                ManageData_Bank(ActionMode.DELETE, value, "View Bank Details for ID " + id);
                            }
                        }
                        else
                        {
                            List <BmsBloodBank> list = null;
                            list = balBank.GetAll();
                            WindowChildren windowChildren = new WindowChildren();
                            windowChildren.AttachData_Bank(balBank, sbTbAppStatus, list);
                            AddTab("View Blood Bank", windowChildren.childWindowHolder);
                        }
                    }

                    if (TestContains(words[1], keyWords_camp))
                    {
                        if (words.Length > 2)
                        {
                            if (!string.IsNullOrEmpty(words[2]))
                            {
                                int    id    = int.Parse(words[2]);
                                object value = balCamp.GetAll().FirstOrDefault(c => c.BloodDonationCampID == id);
                                ManageData_Camp(ActionMode.DELETE, value, "View Donation Camps Details for ID " + id);
                            }
                        }
                        else
                        {
                            List <BmsBloodDonationCamp> list = null;
                            list = balCamp.GetAll();
                            WindowChildren windowChildren = new WindowChildren();
                            windowChildren.AttachData_Camp(balCamp, sbTbAppStatus, list);
                            AddTab("View Donation Camps Details", windowChildren.childWindowHolder);
                        }
                    }

                    if (TestContains(words[1], keyWords_donation))
                    {
                        //ManageData_Donation(ActionMode.ADD, null, "Add Donation Details");
                        if (words.Length > 2)
                        {
                            if (!string.IsNullOrEmpty(words[2]))
                            {
                                int    id    = int.Parse(words[2]);
                                object value = balDonation.GetAll().FirstOrDefault(c => c.BloodDonationCampID == id);
                                ManageData_Donation(ActionMode.DELETE, value, "View Donation Details for ID " + id);
                            }
                        }
                        else
                        {
                            List <BmsBloodDonorDonation> list = null;
                            list = balDonation.GetAll();
                            WindowChildren windowChildren = new WindowChildren();
                            windowChildren.AttachData_Donation(balDonation, sbTbAppStatus, list);
                            AddTab("View Donation Details", windowChildren.childWindowHolder);
                        }
                    }
                    if (TestContains(words[1], keyWords_donor))
                    {
                        //ManageData_Donor(ActionMode.ADD, null, "Add Donor Details");
                        if (words.Length > 2)
                        {
                            if (!string.IsNullOrEmpty(words[2]))
                            {
                                int    id    = int.Parse(words[2]);
                                object value = balDonor.GetAll().FirstOrDefault(c => c.BloodDonorID == id);
                                ManageData_Donor(ActionMode.DELETE, value, "View Donor Details for ID " + id);
                            }
                        }
                        else
                        {
                            List <BmsBloodDonor> list = null;
                            list = balDonor.GetAll();
                            WindowChildren windowChildren = new WindowChildren();
                            windowChildren.AttachData_Donor(balDonor, sbTbAppStatus, list);
                            AddTab("View Donor Details", windowChildren.childWindowHolder);
                        }
                    }

                    if (TestContains(words[1], keyWords_hospital))
                    {
                        //ManageData_Hospital(ActionMode.ADD, null, "Add Hospital Details");
                        if (words.Length > 2)
                        {
                            if (!string.IsNullOrEmpty(words[2]))
                            {
                                int    id    = int.Parse(words[2]);
                                object value = balHospital.GetAll().FirstOrDefault(c => c.HospitalID == id);
                                ManageData_Hospital(ActionMode.DELETE, value, "View Hospital for ID " + id);
                            }
                        }
                        else
                        {
                            List <BmsHospital> list = null;
                            list = balHospital.GetAll();
                            WindowChildren windowChildren = new WindowChildren();
                            windowChildren.AttachData_Hospital(balHospital, sbTbAppStatus, list);
                            AddTab("View Hospital Details", windowChildren.childWindowHolder);
                        }
                    }
                    if (TestContains(words[1], keyWords_inventory))
                    {
                        //ManageData_Inventory(ActionMode.ADD, null, "Add Inventory Details");
                        if (words.Length > 2)
                        {
                            if (!string.IsNullOrEmpty(words[2]))
                            {
                                int    id    = int.Parse(words[2]);
                                object value = balInventory.GetAll().FirstOrDefault(c => c.BloodInventoryID == id);
                                ManageData_Inventory(ActionMode.DELETE, value, "View Inventory for ID " + id);
                            }
                        }
                        else
                        {
                            List <BmsBloodInventory> list = null;
                            list = balInventory.GetAll();
                            WindowChildren windowChildren = new WindowChildren();
                            windowChildren.AttachData_Inventory(balInventory, sbTbAppStatus, list);
                            AddTab("View Inventory Details", windowChildren.childWindowHolder);
                        }
                    }
                    if (TestContains(words[1], keyWords_transaction))
                    {
                        //ManageData_Transaction(ActionMode.ADD, null, "Add Transaction");
                        if (words.Length > 2)
                        {
                            if (!string.IsNullOrEmpty(words[2]))
                            {
                                int    id    = int.Parse(words[2]);
                                object value = balTransaction.GetAll().FirstOrDefault(c => c.BloodInventoryID == id);
                                ManageData_Transaction(ActionMode.DELETE, value, "View Transaction for ID " + id);
                            }
                        }
                        else
                        {
                            List <BmsTransaction> list = null;
                            list = balTransaction.GetAll();
                            WindowChildren windowChildren = new WindowChildren();
                            windowChildren.AttachData_Transaction(balTransaction, sbTbAppStatus, list);
                            AddTab("View Transaction Details", windowChildren.childWindowHolder);
                        }
                    }
                }
            }

            catch (System.Data.SqlClient.SqlException ex)
            {
                MessageHandler.ShowErrorMessage(ex.Message);
            }

            catch (ValidationException ex)
            {
                MessageHandler.ShowErrorMessage(ex.Message);
            }
            catch (ConnectedDalException ex)
            {
                MessageHandler.ShowErrorMessage(ex.Message);
            }
            catch (Exception ex)
            {
                MessageHandler.ShowErrorMessage(ex.Message);
            }
        }