public void Get_BusinessNature()
{
DataSet ds = new DataSet();
DataSet dsu = new DataSet();
DataTable dt = new DataTable();
string Query = "select distinct(company_Type) as Business_Nature, " +
" decode(company_Type,'R','RDA','A','Agent','C','Corporate','B','Bank') as Business_Desc " +
" From company_setup where company_type is not null ";
DatabaseConnection_Util db = new DatabaseConnection_Util();
ds = db.Local_GetDataSet1(Query);
dsu = lov.SP_GET_USERIFNO(Session["U_NAME"].ToString());
if (dsu.Tables[0].Rows.Count > 0)
{
ddl_BusinessNature.DataSource = ds.Tables[0];
ddl_BusinessNature.DataValueField = "Business_Nature";
ddl_BusinessNature.DataTextField = "Business_Desc";
ddl_BusinessNature.DataBind();
//if (usertype.ToString() != "COMPANY")
//{
ddl_BusinessNature.Items.Insert(0, new ListItem("All", "All"));
//}
}
}
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);
}
protected DataSet Fetch_DPAGE()
{
DatabaseConnection_Util db = new DatabaseConnection_Util();
DataSet ds = new DataSet();
OracleParameter[] param = new OracleParameter[1];
param[0] = db.Oracle_Param("data_resultset", OracleType.Cursor, ParameterDirection.Output, "");
ds = db.Oracle_GetDataSetSP("sp_web_setup_getdpage", param);
return(ds);
}
public void ddlCompanyName()
{
DataSet ds = new DataSet();
DatabaseConnection_Util DataTransform = new DatabaseConnection_Util();
OracleParameter[] PR = new OracleParameter[1];
PR[0] = DataTransform.Oracle_Param("DATA_RESULTSET", OracleType.Cursor, ParameterDirection.Output, "");
ds = DataTransform.Oracle_GetDataSetSP("GetCompanyName", PR);
if (ds.Tables[0].Rows.Count > 0)
{
ddlCompanyCode.DataSource = ds.Tables[0];
ddlCompanyCode.DataTextField = "COMPANY_NAME";
ddlCompanyCode.DataValueField = "COMPANY_CODE";
ddlCompanyCode.DataBind();
}
ddlCompanyCode.Items.Insert(0, new ListItem("All", ""));
}
