public DataSet DisplaySet()
{
DataSet DS = new DataSet();
DS = DataTransform.ReteriveDataMultiple("EXEC ", " DISPLAY-SET ");
ClearTable();
return(DS);
}
public DataSet DisplaySet()
{
DataSet DS = new DataSet();
DS = DataTransform.ReteriveDataMultiple("SELECT ID,SIGNATORY_NAME,UPLOAD_IMAGE_PATH,CURRENT_STATUS,A_userID,A_DateTime,E_UserID,E_DateTime FROM SPDS_SignatorySetup", " DISPLAY-SET ");
ClearTable();
return(DS);
}
public DataSet Get_RPS_SP_CorrespondingBankFilesId()
{
DatabaseConnection_Util DataTransform = new DatabaseConnection_Util();
DataSet DS = new DataSet();
DS = DataTransform.ReteriveDataMultiple("select max(ID) from RPS_CorrespondingBankFile", "GET_ALL_USER");
return(DS);
}
public TABLE_RPS_DraftCancellation()
{
RPS_DraftCancellation_DATASET = DataTransform.ReteriveDataMultiple
("select DraftID ID ,DraftID,CancelNo,to_char(CancelDate,'MM/dd/yyyy') CancelDate,to_char(AcknowledgeDate,'MM/dd/yyyy') AcknowledgeDate,AcknowledgeRefNo,CancelStatusID,TracerID ,'' ReIssue,'' Refund ,'' SundryDuplicate ,A_UserID ,to_char(A_DateTime,'MM/dd/yyyy HH:MI:SS') A_DateTime ,E_UserID ,to_char(E_DateTime,'MM/dd/yyyy HH:MI:SS') E_DateTime,company_code from RPS_DraftCancellation WHERE 2=1 ", "NEW_USER_INFO");
//top 0 ID,
//OracleParameter[] PR = new OracleParameter[2];
//PR[0] = DataTransform.Oracle_Param("P_TABLE_NAME", OracleType.VarChar, ParameterDirection.Input, "RPS_DraftCancellation");
//PR[1] = DataTransform.Oracle_Param("DATA_RESULTSET", OracleType.Cursor, ParameterDirection.Output, "");
//RPS_DraftCancellation_DATASET = DataTransform.Oracle_GetDataSetSP("SP_GET_TABLE_STRUCT", PR);
}
public string Get_SP_CMN_CURRENCY_CHECK(string CurrencyCode)
{
DataSet DS = new DataSet();
DS = DataTransform.ReteriveDataMultiple("EXEC SP_CMN_CURRENCY_CHECK '" + CurrencyCode + "'", "GET_ALL_USER");
return(DS.Tables[0].Rows[0][0].ToString());
}
//public Stack BatchHeaderDivision(string STR) {}
/**************************3RD PARTY PRINTING SYSTEM**********************************************/
public DataSet Get_RPS_DRAFT_V11(string ID)
{
DataSet DS = new DataSet();
DS = DataTransform.ReteriveDataMultiple("EXEC SP_PRINT_V11 " + ID, "GET_ALL_USER");
return(DS);
}