/// <summary>
/// To Get All Tenure Structures
/// </summary>
/// <param name="TenureStructureName"></param>
/// <returns></returns>
public TenureStructureList GetAllTenureStructures(string TenureStructureName)
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_MST_GET_ALTENURESTRUCTURES";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
if (TenureStructureName.ToString() == "")
{
cmd.Parameters.Add("@TenureStructureNameIN", DBNull.Value);
}
else
{
cmd.Parameters.Add("@TenureStructureNameIN", TenureStructureName.ToString());
}
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
TenureStructureBO objTenureStructre = null;
TenureStructureList TenureStructure = new TenureStructureList();
while (dr.Read())
{
objTenureStructre = new TenureStructureBO();
objTenureStructre.Str_TenureId = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("STR_TENUREID")));
objTenureStructre.Str_Tenure = dr.GetString(dr.GetOrdinal("STR_TENURE"));
objTenureStructre.IsDeleted = dr.GetString(dr.GetOrdinal("ISDELETED"));
TenureStructure.Add(objTenureStructre);
}
dr.Close();
return(TenureStructure);
}
/// <summary>
/// to bind the data from the database to the dropdown ddlTenureType
/// </summary>
private void bindDDLTenure()
{
objTenureStructureBLL = new TenureStructureBLL();
objTenureStructureList = objTenureStructureBLL.GetTenureStructures("");
ddlTenureType.DataSource = objTenureStructureList;
ddlTenureType.DataTextField = "STR_TENURE";
ddlTenureType.DataValueField = "STR_TENUREID";
ddlTenureType.DataBind();
}
