public IEnumerable <ResearchPaper> showAdvisorList() { try { List <ResearchPaper> rPaperList = new List <ResearchPaper>(); using (SqlConnection con = new SqlConnection(ConnnectionString)) { SqlCommand cmd = new SqlCommand("getResearchPaperList", con); cmd.CommandType = CommandType.StoredProcedure; con.Open(); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { ResearchPaper rPaper = new ResearchPaper(); rPaper.Id = Convert.ToInt32(rdr["Id"]); rPaper.Title = rdr["Title"].ToString(); rPaper.FileName = rdr["FileName"].ToString(); rPaper.FilePath = rdr["FilePath"].ToString(); rPaper.Date = Convert.ToDateTime(rdr["Date"]); rPaperList.Add(rPaper); } con.Close(); } return(rPaperList); } catch { throw; } }
public int publishRPaper(ResearchPaper researchPaper) { try { using (SqlConnection con = new SqlConnection(ConnnectionString)) { SqlCommand cmd = new SqlCommand("publishRPaper", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Title", researchPaper.Title); cmd.Parameters.AddWithValue("@FileName", researchPaper.FileName); cmd.Parameters.AddWithValue("@FilePath", researchPaper.FilePath); cmd.Parameters.AddWithValue("@Date", researchPaper.Date); con.Open(); cmd.ExecuteNonQuery(); con.Close(); } return(1); } catch { throw; } }