/// <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); }