public static List <Uploads> GetLatestData()
{
List <Uploads> uploads = new List <Uploads>();
// 1) Create the connection
SqlConnection connection = new SqlConnection();
connection.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["SqlConnection"].ConnectionString;
// 2) Open the connection
connection.Open();
// 3) Execute query
SqlCommand command = new SqlCommand();
command.Connection = connection;
command.CommandText = string.Format("select top 2 * from Uploads");
SqlDataReader dataReader = command.ExecuteReader();
while (dataReader.Read())
{
Uploads upload = new Uploads();
upload.Id = Convert.ToInt32(dataReader["Id"]);
upload.Title = Convert.ToString(dataReader["Title"]);
upload.Path = Convert.ToString(dataReader["Path"]);
upload.UploadsTypeId = Convert.ToInt32(dataReader["UploadsTypeId"]);
upload.TopicsId = Convert.ToInt32(dataReader["TopicsId"]);
if (dataReader["UserName"] != DBNull.Value)
{
upload.UserName = Convert.ToString(dataReader["UserName"]);
}
upload.ThumbNail = Convert.ToString(dataReader["ThumbNail"]);
upload.UploadsType = UploadsTypeDA.GetSingle(upload.UploadsTypeId);
upload.Topics = TopicsDA.GetSingle(upload.TopicsId);
upload.IsApproved = Convert.ToBoolean(dataReader["IsApproved"]);
upload.CreatedOn = Convert.ToString(dataReader["CreatedOn"]);
upload.IsDeleted = Convert.ToBoolean(dataReader["IsDeleted"]);
uploads.Add(upload);
}
// 4) Close the connection
connection.Close();
return(uploads);
}
public static List <Topics> GetAllByTopics(int ParentId)
{
List <Topics> topics = new List <Topics>();
// 1) Create the connection
SqlConnection connection = new SqlConnection();
connection.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["SqlConnection"].ConnectionString;
// 2) Open the connection
connection.Open();
// 3) Execute query
SqlCommand command = new SqlCommand();
command.Connection = connection;
command.CommandText = String.Format("select * from topics where parentid ='{0}'", ParentId);
SqlDataReader dataReader = command.ExecuteReader();
while (dataReader.Read())
{
Topics topic = new Topics();
topic.Id = Convert.ToInt32(dataReader["Id"]);
topic.Name = Convert.ToString(dataReader["Name"]);
topic.SubjectId = Convert.ToInt32(dataReader["SubjectId"]);
topic.BranchId = Convert.ToInt32(dataReader["BranchId"]);
if (dataReader["ParentId"] != DBNull.Value)
{
topic.ParentId = Convert.ToInt32(dataReader["ParentId"]);
}
topic.Subjects = SubjectsDA.GetSingle(topic.SubjectId);
topic.ParentTopics = TopicsDA.GetSingle(topic.ParentId);
topics.Add(topic);
}
// 4) Close the connection
connection.Close();
return(topics);
}
