public List <EnrollingProjectData> searchProjectdata(string text)
{
string query = "SELECT * from EnrollingprojectTable WHERE projectName LIKE '%" + text + "%' OR totalAmount LIKE '%" + text + "%' OR willServe LIKE '%" + text + "%' OR duration LIKE '%" + text + "%' OR createdate LIKE '%" + text + "%'";
List <EnrollingProjectData> asList = new List <EnrollingProjectData>();
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
SqlDataReader sdr = dcc.GetData(query);
while (sdr.Read())
{
EnrollingProjectData a = new EnrollingProjectData();
a.ProjectName = sdr["ProjectName"].ToString();
a.TotalAmount = sdr["TotalAmount"].ToString();
a.WillServe = sdr["WillServe"].ToString();
a.Duration = sdr["Duration"].ToString();
a.Createdate = sdr["Createdate"].ToString();
asList.Add(a);
}
return(asList);
}
public List <EnrollingProjectData> GetallEnrollingProjectdata()
{
string query = "SELECT * from EnrollingprojectTable";
List <EnrollingProjectData> asList = new List <EnrollingProjectData>();
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
SqlDataReader sdr = dcc.GetData(query);
while (sdr.Read())
{
EnrollingProjectData a = new EnrollingProjectData();
a.ProjectName = sdr["ProjectName"].ToString();
a.TotalAmount = sdr["TotalAmount"].ToString();
a.WillServe = sdr["WillServe"].ToString();
a.Duration = sdr["Duration"].ToString();
a.Createdate = sdr["Createdate"].ToString();
asList.Add(a);
}
return(asList);
}