// GET: Announcements
public List <Announcements> GetAnnouncements()
{
string connectionstring = ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString();
SqlConnection sql = new SqlConnection(connectionstring);
string sequery = string.Format("Select * from [dbo].[RequestedIdeas] where AppliedBy='{0}' and Approved=1", User.Identity.Name);
SqlCommand sesqlcommand = new SqlCommand(sequery, sql);
sql.Open();
SqlDataReader sereader = sesqlcommand.ExecuteReader();
RequestedIdeas up = new RequestedIdeas();
while (sereader.Read())
{
up.AppliedBy = sereader["AppliedBy"].ToString();
up.IdeaId = sereader["IdeaId"].ToString();
up.RequestTo = sereader["RequestTo"].ToString();
}
sql.Close();
string query = string.Format("Select * from [dbo].[Announcement] where IdeaId='{0}'", up.IdeaId);
SqlCommand sqlcommand = new SqlCommand(query, sql);
sql.Open();
SqlDataReader reader = sqlcommand.ExecuteReader();
List <Announcements> lstFiles = new List <Announcements>();
while (reader.Read())
{
Announcements down = new Announcements();
down.Announce = reader["Announce"].ToString();
down.Cale = reader["Cale"].ToString();
down.IdeaId = reader["IdeaId"].ToString();
lstFiles.Add(down);
}
/*
* DirectoryInfo dirInfo = new DirectoryInfo(HostingEnvironment.MapPath("~/pdf"));
*
* int i = 0;
* foreach (var item in dirInfo.GetFiles())
* {
* lstFiles.Add(new DownLoadFileInformation()
* {
*
* FileId = i + 1,
* FileName = item.Name,
* FilePath = dirInfo.FullName + @"\" + item.Name
* });
* i = i + 1;
* }
*/
return(lstFiles);
}
// GET: Tasks
public ActionResult Index()
{
string connectionstring = ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString();
SqlConnection sql = new SqlConnection(connectionstring);
string sequery = string.Format("Select * from [dbo].[RequestedIdeas] where AppliedBy='{0}' and Approved=1", User.Identity.Name);
SqlCommand sesqlcommand = new SqlCommand(sequery, sql);
sql.Open();
SqlDataReader sereader = sesqlcommand.ExecuteReader();
RequestedIdeas up = new RequestedIdeas();
while (sereader.Read())
{
up.AppliedBy = sereader["AppliedBy"].ToString();
up.IdeaId = sereader["IdeaId"].ToString();
up.RequestTo = sereader["RequestTo"].ToString();
}
var filecollection = GetTasks(up.IdeaId);
return(View(filecollection));
}
// GET: Upload
//ideas to upload documnts
public List <RequestedIdeas> getIdeaForTeacher()
{
string connectionstring = ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString();
SqlConnection sql = new SqlConnection(connectionstring);
string query = string.Format("Select * from [dbo].[RequestedIdeas] where Approved = 1 and RequestTo='{0}'", User.Identity.Name);
SqlCommand sqlcommand = new SqlCommand(query, sql);
sql.Open();
SqlDataReader reader = sqlcommand.ExecuteReader();
List <RequestedIdeas> lstFiles = new List <RequestedIdeas>();
while (reader.Read())
{
RequestedIdeas down = new RequestedIdeas();
down.AppliedBy = reader["AppliedBy"].ToString();
down.IdeaId = reader["IdeaId"].ToString();
down.RequestTo = reader["RequestTo"].ToString();
down.IdeaTitle = reader["IdeaTitle"].ToString();
lstFiles.Add(down);
}
return(lstFiles);
}
public List <Idea> GetApprovedIdeas()
{
string connectionstring = ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString();
SqlConnection sql = new SqlConnection(connectionstring);
//
string findquery = string.Format("Select * from [dbo].[RequestedIdeas] where AppliedBy='{0}'", User.Identity.Name);
SqlCommand findsqlcommand = new SqlCommand(findquery, sql);
sql.Open();
SqlDataReader ireader = findsqlcommand.ExecuteReader();
List <RequestedIdeas> requested = new List <RequestedIdeas>();
List <string> Ideaskey = new List <string>();
while (ireader.Read())
{
RequestedIdeas up = new RequestedIdeas();
up.IdeaId = ireader["IdeaId"].ToString();
up.IdeaTitle = ireader["IdeaTitle"].ToString();
up.RequestTo = ireader["RequestTo"].ToString();
up.AppliedBy = ireader["AppliedBy"].ToString();
Ideaskey.Add(up.IdeaId);
requested.Add(up);
}
//
sql.Close();
string query = "Select * from [dbo].[ApprovedIdea]";
SqlCommand sqlcommand = new SqlCommand(query, sql);
sql.Open();
SqlDataReader reader = sqlcommand.ExecuteReader();
List <Idea> lstFiles = new List <Idea>();
while (reader.Read())
{
Idea down = new Idea();
down.key = reader["IdeaKey"].ToString();
down.title = reader["Title"].ToString();
down.description = reader["Description"].ToString();
string matchedElement = Ideaskey.Find(x => x.Equals(down.key));
if (matchedElement == null)
{
lstFiles.Add(down);
}
}
/*
* DirectoryInfo dirInfo = new DirectoryInfo(HostingEnvironment.MapPath("~/pdf"));
*
* int i = 0;
* foreach (var item in dirInfo.GetFiles())
* {
* lstFiles.Add(new DownLoadFileInformation()
* {
*
* FileId = i + 1,
* FileName = item.Name,
* FilePath = dirInfo.FullName + @"\" + item.Name
* });
* i = i + 1;
* }
*/
return(lstFiles);
}
