Esempio n. 1
0
        /// <summary>
        ///  ===== EXAMPLE METHOD 1 ============
        ///  This  method is to be used to validate user access.
        /// </summary>
        /// <param name="CurrentUser"></param>
        /// <returns>
        ///  Returns true for 'granted access' and false for 'denied access'</returns>
        public string CheckuserSecurityAccess(string CurrentUser)
        {
            string ReturnedValue = "false";

            SqlConnection SQLConn = new SqlConnection();
            SqlCommand    SQLComm = new SqlCommand();
            SqlDataReader SQLRec;

            //connection string to the database
            SQLConn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["EmployeeDataBaseConnectionString"].ConnectionString;

            //open connection
            SQLConn.Open();

            //stored procedure name
            string SQL = "ssp_tblOperator_GetUserAccess";

            SQLComm             = new SqlCommand(SQL, SQLConn);
            SQLComm.CommandType = CommandType.StoredProcedure;

            //parameter passed
            SQLComm.Parameters.AddWithValue("@CurrentUser", CurrentUser);

            SQLRec = SQLComm.ExecuteReader();

            try
            {
                if (SQLRec.Read())
                {
                    //returned results
                    ReturnedValue = SQLRec.GetString(SQLRec.GetOrdinal("UserHasAccess"));
                }
            }
            catch (Exception e)
            {
                ReturnedValue = e.Message;
            }

            //close connection
            SQLRec.Close();
            SQLConn.Close();

            return(ReturnedValue);
        }
Esempio n. 2
0
        /// <summary>
        /// ===== EXAMPLE METHOD 2 ============
        /// </summary>
        /// This method is to be used to return a list of employee information.
        /// <returns>
        ///  A list of employee information
        /// </returns>
        public List <SampleEmployeeDataModel> GetCodeSampleList()
        {
            List <SampleEmployeeDataModel> SampleDataModel = new List <SampleEmployeeDataModel>();

            SqlConnection SQLconn = new SqlConnection();
            SqlCommand    SQLcomm = new SqlCommand();
            SqlDataReader SQLRec;

            //connection string to the database
            SQLconn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["EmployeeDataBaseConnectionString"].ConnectionString;

            //open connection
            SQLconn.Open();

            //stored procedure name
            string SQL = "ssp_tblEmployee_GetEmployeeInformationList";

            SQLcomm             = new SqlCommand(SQL, SQLconn);
            SQLcomm.CommandType = CommandType.StoredProcedure;

            SQLRec = SQLcomm.ExecuteReader();

            //read data into the model
            while (SQLRec.Read())
            {
                SampleDataModel.Add(new SampleEmployeeDataModel
                {
                    ID        = SQLRec.GetInt32(SQLRec.GetOrdinal("ID")),
                    FirstName = SQLRec.GetString(SQLRec.GetOrdinal("FirstName")),
                    LastName  = SQLRec.GetString(SQLRec.GetOrdinal("LastName")),
                    DOB       = SQLRec.GetDateTime(SQLRec.GetOrdinal("DOB")),
                    SSN       = SQLRec.GetString(SQLRec.GetOrdinal("SSN")),
                });
            }

            //close connection
            SQLRec.Close();
            SQLconn.Close();

            return(SampleDataModel);
        }