Beispiel #1
0
        /// <summary>
        /// Получение данных из БД, для дальнейшей работы с ними
        /// </summary>
        public void loadData(Firm frm)
        {
            ConnectionStringSettings connSetting = ConfigurationManager.ConnectionStrings["LocalDB"];

            if (connSetting == null || string.IsNullOrEmpty(connSetting.ConnectionString))
            {
                throw new Exception("Fatal error: missing connecting string in web.config file");
            }

            string connectionString = connSetting.ConnectionString;

            using (SqlConnection connection = new SqlConnection(connectionString)) {
                connection.Open();

                string        queryString = "SELECT * FROM Employeers";
                SqlCommand    command     = new SqlCommand(queryString, connection);
                SqlDataReader reader      = command.ExecuteReader();
                while (reader.Read())
                {
                    string _surname    = reader["Surname"].ToString();
                    string _name       = reader["Name"].ToString();
                    string _patronymic = reader["Patronymic"].ToString();
                    string _department = reader["DepartmentId"].ToString();
                    frm.personList.Add(new Person(_surname, _name, _patronymic, _department));
                }
                reader.Close();

                queryString         = "SELECT * FROM Department";
                command.CommandText = queryString;
                reader = command.ExecuteReader();
                while (reader.Read())
                {
                    int    _id      = (int)reader["Id"];
                    string _depName = reader["Name"].ToString();
                    frm.departmentList.Add(new Department(_id, _depName));
                }
                command.Dispose();
                reader.Dispose();
            }
        }
Beispiel #2
0
        public HomeModule()
        {
            Get["/"] = x => {
                return(View["FirstPage"]);
            };

            Get["/FirstPage.html"] = x => {
                return(View["FirstPage"]);
            };

            Get["/SeconfPage.html"] = x => {
                return(View["SeconfPage"]);
            };

            ///Позвращает клиенту строку с данными о сотрудниках в html-формате
            Get["/ajax_employeers_get_list"] = x => {
                string result = "";
                try {
                    string  separator = this.Request.Query.separator;
                    DbModel db        = new DbModel();
                    Firm    firm      = new Firm(separator);
                    db.loadData(firm);
                    result = firm.printWorkersByDepartments();
                } catch (Exception e) {
                    System.Diagnostics.Debug.WriteLine(e.ToString());
                }
                return(result);
            };

            ///Позвращает клиенту строку с данными о сотрудниках в json-формате
            Get["/ajax_employeers_bind"] = x => {
                DbModel db     = new DbModel();
                string  result = db.selectEmployeersToJson();
                return(result);
            };

            ///Позвращает клиенту строку с данными о сотрудниках в json-формате
            Get["/ajax_departments"] = x => {
                DbModel db     = new DbModel();
                string  result = db.selectDepartmentsToJson();
                return(result);
            };

            ///Обновление данных
            Post["/ajax_employeers_bind"] = x => {
                var     jsonString = this.Request.Body.AsString();
                Person  p          = JsonConvert.DeserializeObject <Person>(jsonString);
                DbModel db         = new DbModel();
                db.updateEmployee(p);
                return("");
            };

            ///Добавление новой записи
            Post["/ajax_employeers_add"] = x => {
                var    jsonString = this.Request.Body.AsString();
                Person p          = JsonConvert.DeserializeObject <Person>(jsonString);

                DbModel db = new DbModel();
                db.insertEmployee(p);
                return("");

                ;
            };
        }