private void FetchData()
{
SqlDataSource sqlDataSource = new SqlDataSource(cs, "spSelectActiveProjects");
sqlDataSource.SelectCommandType = SqlDataSourceCommandType.StoredProcedure;
Projects.DataSource = sqlDataSource;
Projects.DataBind();
}
private void FillTable()
{
SqlDataSource sqlDataSource = new SqlDataSource(cs, "spSelectClientsActivities");
sqlDataSource.SelectCommandType = SqlDataSourceCommandType.StoredProcedure;
sqlDataSource.SelectParameters.Add("ClientID", DbType.Int32, client.IDClient.ToString());
Projects.DataSource = sqlDataSource;
Projects.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
ConnectionClass.OpenConnection();
ViewProjects vp = new ViewProjects();
dt = vp.ViewAllProjects((string)Session["uID"]);
dt.Columns.Add("TimeAgo", typeof(string));
foreach (DataRow dr in dt.Rows)
{
dr["TimeAgo"] = Agile_2018.Time.TimeAgo(DateTime.Parse(dr["DateCreated"].ToString()));
}
Projects.DataSource = dt;
Projects.DataBind();
}
public void ViewProjects(object sender, EventArgs e)
{
if (Session["Username"] == null)
{
return;
}
string connStr = ConfigurationManager.ConnectionStrings["iwork"].ToString();
SqlConnection conn = new SqlConnection(connStr);
SqlCommand cmd = new SqlCommand("getProject", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@username", Session["Username"].ToString()));
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
sda.Fill(dt);
Projects.DataSource = dt;
Projects.DataBind();
}
