예제 #1
0
        public void LeaveHistoryExcel(string empid)
        {
            DALBase obj = new DALBase(_config);
            List <Tuple <String, OracleDbType, int, object, ParameterDirection> > LstTupParameters = new List <Tuple <string, OracleDbType, int, object, ParameterDirection> >();

            obj.TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_EMPID, OracleDbType.NVarchar2, 20, empid, ParameterDirection.Input);
            obj.DeleteUser(ConstantStoredProcedure.SP_BCL_GETLEAVEHISTORYExcel, empid);
        }
        public void DeleteUser(string userid)
        {
            DALBase obj = new DALBase(_config);
            List <tbl_LeaveRequest> listObj = new List <tbl_LeaveRequest>();
            List <Tuple <String, OracleDbType, int, object, ParameterDirection> > LstTupParameters = new List <Tuple <string, OracleDbType, int, object, ParameterDirection> >();

            obj.TupleForOracleParameter(LstTupParameters, ConstantsVariables.P_USERID, OracleDbType.NVarchar2, 20, Convert.ToString(userid), ParameterDirection.Input);
            obj.DeleteUser(ConstantStoredProcedure.SP_BCL_Delete_ConcurrentLogin, userid);
        }