/// <summary>
/// Bind Reacent paps data
/// </summary>
private void GetRecentPAPS()
{
DashboardBLL objRecentPAPSLogic = new DashboardBLL();
DSH_RecentPAPSList RecentPAPS = objRecentPAPSLogic.GetRecentPAPSByUser(Convert.ToInt32(Session["USER_ID"]));
rptRecentPAPS.DataSource = RecentPAPS;
rptRecentPAPS.DataBind();
}
/// <summary>
/// To fetch details from database
/// </summary>
/// <param name="userID"></param>
/// <returns></returns>
public DSH_RecentPAPSList GetRecentPAPSByUser(int userID)
{
OracleConnection cnn = new OracleConnection(con);
DSH_RecentPAPSBO objRecentPAPS = null;
DSH_RecentPAPSList RecentPAPS = new DSH_RecentPAPSList();
OracleCommand cmd = new OracleCommand("USP_DSH_RECENT_PAPS", cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("USERID_", userID);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
try
{
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (dr.Read())
{
objRecentPAPS = new DSH_RecentPAPSBO();
if (!dr.IsDBNull(dr.GetOrdinal("ProjectCode")))
{
objRecentPAPS.ProjectCode = dr.GetString(dr.GetOrdinal("ProjectCode"));
}
if (!dr.IsDBNull(dr.GetOrdinal("HHID")))
{
objRecentPAPS.HouseholdID = dr.GetInt32(dr.GetOrdinal("HHID"));
}
if (!dr.IsDBNull(dr.GetOrdinal("PAPName")))
{
objRecentPAPS.PAPName = dr.GetString(dr.GetOrdinal("PAPName"));
}
if (!dr.IsDBNull(dr.GetOrdinal("ProjectID")))
{
objRecentPAPS.ProjectID = dr.GetInt32(dr.GetOrdinal("ProjectID"));
}
RecentPAPS.Add(objRecentPAPS);
}
dr.Close();
}
catch (Exception ex)
{
throw ex;
}
return(RecentPAPS);
}
