Пример #1
0
        internal static string ProvideSetting(string settingKey)
        {
            string returnValue = string.Empty;
            string sqlQuery    = "select APPSETNG_VALUE,ADS_DEF_VALUE from APP_SETTINGS where APPSETNG_KEY= N'" + settingKey + "'";

            using (OsaDirectEAManager.Database dbSetting = new OsaDirectEAManager.Database())
            {
                DbCommand    cmdSetting = dbSetting.GetSqlStringCommand(sqlQuery);
                DbDataReader drSettings = dbSetting.ExecuteReader(cmdSetting, CommandBehavior.CloseConnection);

                if (drSettings.HasRows)
                {
                    drSettings.Read();
                    returnValue = drSettings["APPSETNG_VALUE"].ToString();
                    if (string.IsNullOrEmpty(returnValue))
                    {
                        returnValue = drSettings["ADS_DEF_VALUE"].ToString();
                    }
                }
                if (drSettings != null && drSettings.IsClosed == false)
                {
                    drSettings.Close();
                }
            }
            return(returnValue);
        }
Пример #2
0
        public static bool isCostCenter(string costCenter)
        {
            bool   returnValue = false;
            string sqlQuery    = "select COSTCENTER_ID from M_COST_CENTERS where COSTCENTER_ID = " + costCenter + " ";

            using (OsaDirectEAManager.Database dbSetting = new OsaDirectEAManager.Database())
            {
                DbCommand    cmdSetting = dbSetting.GetSqlStringCommand(sqlQuery);
                DbDataReader drSettings = dbSetting.ExecuteReader(cmdSetting, CommandBehavior.CloseConnection);
                if (drSettings.HasRows)
                {
                    returnValue = true;
                }
                else
                {
                    returnValue = false;
                }

                if (drSettings != null && drSettings.IsClosed == false)
                {
                    drSettings.Close();
                }
            }
            return(returnValue);
        }
Пример #3
0
        public static int ValidatePrintUser(string printUser, out string userCostCenter)
        {
            int    printUserAccountID = 100; // Annonymous Print User
            string userGroup          = "";

            using (OsaDirectEAManager.Database database = new OsaDirectEAManager.Database())
            {
                string sqlQuery = string.Format("select USR_ACCOUNT_ID, USR_SOURCE, USR_PASSWORD,USR_COSTCENTER from M_USERS where USR_ID ='{0}' order by USR_SOURCE", printUser);

                DbDataReader drUserDetails = database.ExecuteReader(database.GetSqlStringCommand(sqlQuery));

                if (drUserDetails.HasRows)
                {
                    drUserDetails.Read();
                    string accountID    = drUserDetails["USR_ACCOUNT_ID"].ToString();
                    string userPassword = drUserDetails["USR_PASSWORD"].ToString();
                    string userSource   = drUserDetails["USR_SOURCE"].ToString();
                    userGroup = drUserDetails["USR_COSTCENTER"].ToString();

                    if (!string.IsNullOrEmpty(accountID))
                    {
                        printUserAccountID = int.Parse(accountID);
                    }
                }

                if (drUserDetails != null && drUserDetails.IsClosed == false)
                {
                    drUserDetails.Close();
                }
            }

            userCostCenter = userGroup;

            return(printUserAccountID);
        }
Пример #4
0
        public static bool ProviceOverDraftStatus(string selectedID, string limitsOn)
        {
            bool   returnValue = false;
            string query       = "select ALLOW_OVER_DRAFT from M_USERS where USR_ACCOUNT_ID='" + selectedID + "'";

            if (limitsOn == "0")
            {
                query = "select ALLOW_OVER_DRAFT from M_COST_CENTERS where COSTCENTER_ID='" + selectedID + "'";
            }
            using (OsaDirectEAManager.Database dbOverDraft = new OsaDirectEAManager.Database())
            {
                DbDataReader drOverDraft = dbOverDraft.ExecuteReader(dbOverDraft.GetSqlStringCommand(query));
                while (drOverDraft.Read())
                {
                    string value = drOverDraft["ALLOW_OVER_DRAFT"].ToString();
                    if (!string.IsNullOrEmpty(value))
                    {
                        returnValue = bool.Parse(value);
                    }
                }

                if (drOverDraft != null && drOverDraft.IsClosed == false)
                {
                    drOverDraft.Close();
                }
            }
            return(returnValue);
        }
Пример #5
0
        /// <summary>
        /// Provides the job setting.
        /// </summary>
        /// <param name="settingKey">The setting key.</param>
        /// <returns></returns>
        /// <remarks>
        /// Sequence Diagram:<br/>
        ///     <img src="SequenceDiagrams/SD_OsaDataProvider.Device.ProvideJobSetting.jpg"/>
        /// </remarks>
        public static bool ProvideJobSetting(string settingKey)
        {
            bool   returnValue = false;
            string sqlQuery    = "select * from JOB_CONFIGURATION where JOBSETTING_KEY=N'" + settingKey + "'";

            using (OsaDirectEAManager.Database dbSetting = new OsaDirectEAManager.Database())
            {
                DbCommand    cmdSetting = dbSetting.GetSqlStringCommand(sqlQuery);
                DbDataReader drSettings = dbSetting.ExecuteReader(cmdSetting, CommandBehavior.CloseConnection);
                if (drSettings.HasRows)
                {
                    drSettings.Read();
                    if (drSettings["JOBSETTING_VALUE"].ToString() == "Disable")
                    {
                        returnValue = false;
                    }
                    else
                    {
                        returnValue = true;
                    }
                }
                if (drSettings != null && drSettings.IsClosed == false)
                {
                    drSettings.Close();
                }
            }
            return(returnValue);
        }
Пример #6
0
        public static int ValidatePrintUser(string printUser, string printPassword, out string userCostCenter)
        {
            int    printUserAccountID = 100;
            string userGroup          = "";

            using (OsaDirectEAManager.Database database = new OsaDirectEAManager.Database())
            {
                string sqlQuery = string.Format("select USR_ACCOUNT_ID, USR_SOURCE, USR_PASSWORD,USR_COSTCENTER from M_USERS where USR_ID ='{0}' order by USR_SOURCE", printUser);

                DbDataReader drUserDetails = database.ExecuteReader(database.GetSqlStringCommand(sqlQuery));

                while (drUserDetails.Read())
                {
                    string accountID    = drUserDetails["USR_ACCOUNT_ID"].ToString();
                    string userPassword = drUserDetails["USR_PASSWORD"].ToString();
                    string userSource   = drUserDetails["USR_SOURCE"].ToString();
                    userGroup = drUserDetails["USR_COSTCENTER"].ToString();


                    if (userSource == "DB")
                    {
                        if (userPassword == Protector.ProvideEncryptedPassword(printPassword))
                        {
                            if (!string.IsNullOrEmpty(accountID))
                            {
                                printUserAccountID = int.Parse(accountID);
                            }
                        }
                    }
                    else
                    {
                        string userDomain = ProvideDomainName();
                        if (!string.IsNullOrEmpty(userDomain))
                        {
                            if (AppLibrary.AppAuthentication.isValidUser(printUser, printPassword, userDomain, userSource))
                            {
                                if (!string.IsNullOrEmpty(accountID))
                                {
                                    printUserAccountID = int.Parse(accountID);
                                }
                            }
                        }
                    }
                }

                if (drUserDetails != null && drUserDetails.IsClosed == false)
                {
                    drUserDetails.Close();
                }
            }

            userCostCenter = userGroup;

            return(printUserAccountID);
        }
Пример #7
0
        /// <summary>
        /// Gets the user details.
        /// </summary>
        /// <remarks>
        /// Sequence Diagram:<br/>
        /// <img src="SequenceDiagrams/SD_DataManager.Provider.Users.GetUserDetails.jpg" />
        /// </remarks>
        /// <param name="authenticationType">Type of the authentication.</param>
        /// <param name="authenticationValue">The authentication value.</param>
        /// <returns>DbDataReader</returns>
        public static DbDataReader ProvideUserDetails(AuthenticationType authenticationType, string authenticationValue)
        {
            // TODO>> Get Device Authentication Type and return the user Details

            DbDataReader drUserdetails = null;
            string       sqlQuery      = "select * from M_USERS where (";

            switch (authenticationType)
            {
            case AuthenticationType.UserSystemId:
                sqlQuery += string.Format(CultureInfo.CurrentCulture, " USR_ACCOUNT_ID = N'{0}' ", authenticationValue);
                break;

            case AuthenticationType.UserId:
                sqlQuery += string.Format(CultureInfo.CurrentCulture, " USR_ID = N'{0}' ", authenticationValue);
                break;

            case AuthenticationType.CardId:
                sqlQuery += string.Format(CultureInfo.CurrentCulture, " USR_CARD_ID = '{0}' ", authenticationValue);
                break;

            case AuthenticationType.PinNumber:
                sqlQuery += string.Format(CultureInfo.CurrentCulture, " USR_PIN = N'{0}' ", authenticationValue);
                break;

            case AuthenticationType.AnyOfThem:
                int  validAccountID         = 0;
                bool isValidAccountIDResult = int.TryParse(authenticationValue, out validAccountID);
                if (validAccountID != 0)
                {
                    sqlQuery += string.Format(CultureInfo.CurrentCulture, " USR_ACCOUNT_ID = N'{0}' or USR_ID = N'{0}' or USR_CARD_ID = N'{0}' or USR_PIN =N'{0}'", authenticationValue);
                }
                else
                {
                    sqlQuery += string.Format(CultureInfo.CurrentCulture, " USR_ID = N'{0}' or USR_CARD_ID = N'{0}' or USR_PIN =N'{0}'", authenticationValue);
                }
                break;

            default:
                sqlQuery += string.Format(CultureInfo.CurrentCulture, " USR_ACCOUNT_ID = '{0}' ", authenticationValue);
                break;
            }
            sqlQuery += ")";
            OsaDirectEAManager.Database dbUserDetails = new OsaDirectEAManager.Database();
            DbCommand cmdUserDetails = dbUserDetails.GetSqlStringCommand(sqlQuery);

            drUserdetails = dbUserDetails.ExecuteReader(cmdUserDetails);
            return(drUserdetails);
        }
Пример #8
0
        /// <summary>
        /// Determines whether [is current job exist] [the specified file name].
        /// </summary>
        /// <param name="fileName">Name of the file.</param>
        /// <returns>
        ///     <c>true</c> if [is current job exist] [the specified file name]; otherwise, <c>false</c>.
        /// </returns>
        public static bool IsCurrentJobExist(string fileName)
        {
            bool   isCurrentJobExist = false;
            string query             = "select * from T_CURRENT_JOBS where JOB_NAME = '" + fileName.Replace("'", "''") + "'";

            using (OsaDirectEAManager.Database dbJobExist = new OsaDirectEAManager.Database())
            {
                DbCommand    cmdJob     = dbJobExist.GetSqlStringCommand(query);
                DbDataReader drJobExist = dbJobExist.ExecuteReader(cmdJob, CommandBehavior.CloseConnection);

                if (drJobExist.HasRows)
                {
                    isCurrentJobExist = true;
                }
            }
            return(isCurrentJobExist);
        }
Пример #9
0
        /// <summary>
        /// Gets the departments by ID.
        /// </summary>
        /// <remarks>
        /// Sequence Diagram:<br/>
        /// <img src="SequenceDiagrams/SD_DataManager.Provider.Users.GetDepartmentsByID.jpg" />
        /// </remarks>
        /// <param name="userID">The User ID.</param>
        /// <param name="authenticationType">The Authentication Type.</param>
        /// <returns>DataSet</returns>
        public static string ProvideUserDepartment(string userID, string authenticationType)
        {
            string sqlQuery    = "select DEPT_NAME from M_DEPARTMENTS where DEPT_SOURCE = N'" + authenticationType + "' and REC_SLNO in (select USR_DEPARTMENT from M_USERS where USR_ID = N'" + userID + "' and USR_SOURCE = N'" + authenticationType + "')";
            string returnValue = string.Empty;

            using (OsaDirectEAManager.Database dbDepartments = new OsaDirectEAManager.Database())
            {
                DbCommand    cmdDepartments = dbDepartments.GetSqlStringCommand(sqlQuery);
                DbDataReader drDepartment   = dbDepartments.ExecuteReader(cmdDepartments);
                if (drDepartment.HasRows)
                {
                    drDepartment.Read();
                    returnValue = drDepartment["DEPT_NAME"] as string;
                }
                if (drDepartment != null && drDepartment.IsClosed == false)
                {
                    drDepartment.Close();
                }
            }
            return(returnValue);
        }
Пример #10
0
        /// <summary>
        /// Provides the name of the domain.
        /// </summary>
        /// <returns>string</returns>
        /// <remarks>
        /// Sequence Diagram:<br/>
        ///     <img src="SequenceDiagrams/SD_DataManagerDevice.ProviderDevice.ApplicationSettings.ProvideDomainName.jpg"/>
        /// </remarks>
        public static string ProvideDomainName()
        {
            string authenticationType = string.Empty;
            string sqlQuery           = "select * from AD_SETTINGS where AD_SETTING_KEY = N'DOMAIN_NAME'";

            using (OsaDirectEAManager.Database dbDomain = new OsaDirectEAManager.Database())
            {
                DbCommand    cmdDomain  = dbDomain.GetSqlStringCommand(sqlQuery);
                DbDataReader drAuthType = dbDomain.ExecuteReader(cmdDomain, CommandBehavior.CloseConnection);

                if (drAuthType.HasRows)
                {
                    drAuthType.Read();//APPSETNG_VALUE
                    authenticationType = drAuthType["AD_SETTING_VALUE"].ToString();
                }
                if (drAuthType != null && drAuthType.IsClosed == false)
                {
                    drAuthType.Close();
                }
            }
            return(authenticationType);
        }
Пример #11
0
        /// <summary>
        /// Provides Authentication Type of specific device
        /// </summary>
        /// <param name="deviceIP">The Device IP.</param>
        /// <returns></returns>
        public static string ProvideDeviceAuthenticationType(string deviceIP)
        {
            string sqlQuery    = "select MFP_LOGON_AUTH_SOURCE from M_MFPS where MFP_IP = N'" + deviceIP + "'";
            string returnValue = string.Empty;

            using (OsaDirectEAManager.Database dbMfpDetails = new OsaDirectEAManager.Database())
            {
                DbCommand    cmdMfpDetails = dbMfpDetails.GetSqlStringCommand(sqlQuery);
                DbDataReader drDeviceAuthenticationType = dbMfpDetails.ExecuteReader(cmdMfpDetails, CommandBehavior.CloseConnection);

                if (drDeviceAuthenticationType.HasRows)
                {
                    drDeviceAuthenticationType.Read();
                    returnValue = drDeviceAuthenticationType["MFP_LOGON_AUTH_SOURCE"] as string;
                }
                if (drDeviceAuthenticationType != null && drDeviceAuthenticationType.IsClosed == false)
                {
                    drDeviceAuthenticationType.Close();
                }
            }

            return(returnValue);
        }