Esempio n. 1
0
        // Register new employee into the database
        public bool RegisterEmployee(int RegisterId, int SelectDepartmentId, string NewEmployeeName, string NewCompanyEmployeeCode)
        {
            Modules.DBModules DB = new Modules.DBModules();

            SqlDataReader sqlRdr = null;
            StringBuilder strSql = new StringBuilder();

            strSql.Append("INSERT INTO M_Employee (EmployeeId, EmployeeName, CompanyEmployeeCode, DepartmentId, IsDeleted, CreateBy, CreateOn,  UpdateBy, UpdateOn)");
            strSql.Append(" VALUES (");
            strSql.AppendFormat("'{0}'", RegisterId);
            strSql.Append(",");
            strSql.AppendFormat(" '{0}'", NewEmployeeName);
            strSql.Append(",");
            strSql.AppendFormat(" '{0}'", NewCompanyEmployeeCode);
            strSql.Append(",");
            strSql.AppendFormat(" '{0}'", SelectDepartmentId);
            strSql.Append(", '0'");
            strSql.Append(", 'Hai TV'");
            strSql.Append(", ");
            strSql.Append("'");
            strSql.Append(DateTime.Now.ToString());
            strSql.Append("'");
            strSql.Append(", 'Hai TV'");
            strSql.Append(", ");
            strSql.Append("'");
            strSql.Append(DateTime.Now.ToString());
            strSql.Append("')");

            try
            {
                if (!DB.DB_Connect())
                {
                }
                if (DB.DB_SqlReader(strSql.ToString(), ref sqlRdr))
                {
                }
                while (sqlRdr.Read())
                {
                }
            }
            catch (Exception ex) {}
            finally
            {
                if (sqlRdr != null)
                {
                    if (!sqlRdr.IsClosed)
                    {
                        sqlRdr.Close();
                    }
                }
                DB.DB_Close();
            }
            return(true);
        }
Esempio n. 2
0
        // Returns "False" If a Company Employee Code already exist otherwise return "True".
        public bool checkCompanyEmployeeCode(string NewCompanyEmployeeCode)
        {
            {
                Modules.DBModules     DB             = new Modules.DBModules();
                Models.SearchEmployee SearchEmployee = new Models.SearchEmployee();
                SqlDataReader         sqlRdr         = null;
                StringBuilder         strSql         = new StringBuilder();

                strSql.Append("SELECT * FROM M_Employee WHERE ");
                strSql.Append("CompanyEmployeeCode = ");
                strSql.AppendFormat("'{0}'", NewCompanyEmployeeCode);
                try
                {
                    if (!DB.DB_Connect())
                    {
                    }
                    if (DB.DB_SqlReader(strSql.ToString(), ref sqlRdr))
                    {
                    }
                    while (sqlRdr.Read())
                    {
                        SearchEmployee = new Models.SearchEmployee();

                        SearchEmployee.CompanyEmployeeCode = sqlRdr["CompanyEmployeeCode"].ToString();
                    }
                }
                catch (Exception ex)
                {
                }
                finally
                {
                    if (sqlRdr != null)
                    {
                        if (!sqlRdr.IsClosed)
                        {
                            sqlRdr.Close();
                        }
                    }
                    DB.DB_Close();
                }
                if (SearchEmployee.CompanyEmployeeCode == null)
                {
                    return(true);
                }
                return(false);
            }
        }
Esempio n. 3
0
        public List <Models.M_Department> GetDepartmentList(Models.DepartmentModels DepartmentModel)
        {
            Modules.DBModules          DB             = new Modules.DBModules();
            Models.M_Department        Department     = new Models.M_Department();
            List <Models.M_Department> DepartmentList = new List <Models.M_Department>();
            SqlDataReader sqlRdr = null;
            StringBuilder strSql = new StringBuilder();

            strSql.Append("SELECT * FROM M_Department");
            try
            {
                if (!DB.DB_Connect())
                {
                }
                if (DB.DB_SqlReader(strSql.ToString(), ref sqlRdr))
                {
                }
                while (sqlRdr.Read())
                {
                    Department = new Models.M_Department();

                    Department.DepartmentId   = int.Parse(sqlRdr["DepartmentId"].ToString());
                    Department.DepartmentName = sqlRdr["DepartmentName"].ToString();

                    DepartmentList.Add(Department);
                }
                DepartmentModel.DepartmentList = DepartmentList;
            }
            catch (Exception ex)
            {
            }
            finally
            {
                if (sqlRdr != null)
                {
                    if (!sqlRdr.IsClosed)
                    {
                        sqlRdr.Close();
                    }
                }
                DB.DB_Close();
            }
            return(DepartmentList);
        }
Esempio n. 4
0
        //Get the ID number in the database to register information for new employees.
        public int GetRegisterNumber()
        {
            Modules.DBModules     DB             = new Modules.DBModules();
            Models.SearchEmployee SearchEmployee = new Models.SearchEmployee();
            SqlDataReader         sqlRdr         = null;
            StringBuilder         strSql         = new StringBuilder();

            strSql.Append("SELECT EmployeeId FROM M_Employee");
            try
            {
                if (!DB.DB_Connect())
                {
                }
                if (DB.DB_SqlReader(strSql.ToString(), ref sqlRdr))
                {
                }
                while (sqlRdr.Read())
                {
                    SearchEmployee = new Models.SearchEmployee();

                    SearchEmployee.EmployeeId = int.Parse(sqlRdr["EmployeeId"].ToString());
                }
            }
            catch (Exception ex)
            {
            }
            finally
            {
                if (sqlRdr != null)
                {
                    if (!sqlRdr.IsClosed)
                    {
                        sqlRdr.Close();
                    }
                }
                DB.DB_Close();
            }
            return(SearchEmployee.EmployeeId);
        }
Esempio n. 5
0
        public List <Models.SearchEmployee> SearchResult(int SelectDepartmentId, string SearchEmployeeName)
        {
            bool sqlFlag = false;

            Modules.DBModules            DB                 = new Modules.DBModules();
            Models.SearchEmployee        SearchEmployee     = new Models.SearchEmployee();
            List <Models.SearchEmployee> SearchEmployeeList = new List <Models.SearchEmployee>();
            SqlDataReader sqlRdr = null;
            StringBuilder strSql = new StringBuilder();

            strSql.Append("SELECT M_Employee.EmployeeName, M_Employee.CompanyEmployeeCode, M_Department.DepartmentName, M_Department.RegionName");
            strSql.Append(" FROM M_Department");
            strSql.Append(" INNER JOIN M_Employee ON M_Department.DepartmentId=M_Employee.DepartmentId");

            // When the user select Department in Search condition.
            if (SelectDepartmentId != 0)
            {
                strSql.Append(" WHERE");
                strSql.Append(" M_Employee.DepartmentId = ");
                strSql.AppendFormat("{0}", SelectDepartmentId);
                sqlFlag = true;
            }

            if (SearchEmployeeName != "")
            {
                if (sqlFlag == true)
                {
                    strSql.Append(" AND");
                }
                if (SelectDepartmentId == 0)
                {
                    strSql.Append(" WHERE");
                }
                strSql.Append(" M_Employee.EmployeeName = ");
                strSql.AppendFormat("'{0}'", SearchEmployeeName);
            }
            try
            {
                if (!DB.DB_Connect())
                {
                }
                if (DB.DB_SqlReader(strSql.ToString(), ref sqlRdr))
                {
                }
                while (sqlRdr.Read())
                {
                    SearchEmployee = new Models.SearchEmployee();

                    SearchEmployee.EmployeeName = sqlRdr["EmployeeName"].ToString();

                    SearchEmployee.CompanyEmployeeCode = sqlRdr["CompanyEmployeeCode"].ToString();

                    SearchEmployee.DepartmentName = sqlRdr["DepartmentName"].ToString();

                    SearchEmployee.RegionName = sqlRdr["RegionName"].ToString();

                    SearchEmployeeList.Add(SearchEmployee);
                }
            }
            catch (Exception ex)
            {
            }
            finally
            {
                if (sqlRdr != null)
                {
                    if (!sqlRdr.IsClosed)
                    {
                        sqlRdr.Close();
                    }
                }
                DB.DB_Close();
            }
            return(SearchEmployeeList);
        }