public void BindTeam()
{
NewRepeater1.sqlDataSource = "SELECT ID,DESCRIPTION,ACCOUNT.NAME+' '+ACCOUNT.SURNAME AS LEADERNAME,LEADERID FROM PROJECT_TEAMS LEFT OUTER JOIN ACCOUNT ON PROJECT_TEAMS.LEADERID=ACCOUNT.UID WHERE PROJECT_TEAMS.PROJECTID=" + prjID;
NewRepeater1.DataBind();
NewRepeater1.Visible = true;
TeamTable.Visible = false;
}
protected void FillRepeater()
{
NewRepeater1.sqlDataSource = string.Format("SELECT ID,TITLE FROM PROJECT WHERE CUSTOMERID={0} AND (ADMINACCOUNT LIKE '%|{1}|%' OR OWNER={1})", UC.CompanyId, UC.UserId);
NewRepeater1.DataBind();
NewRepeater1.Visible = true;
Tabber.Visible = false;
}
private void FillRepeater()
{
NewRepeater1.DataSource = DatabaseConnection.CreateDataset("select * from CatalogPriceListDescription").Tables[0];
NewRepeater1.DataBind();
ListId.Text = "-1";
ListDescription.Text = string.Empty;
ListPercentage.Text = string.Empty;
ListIncrease.Text = string.Empty;
ListIncrease.Text = string.Empty;
}
protected void FillRepeater()
{
Session.Remove("selectprj");
string q = string.Format(@"SELECT ID,TITLE FROM PROJECT WHERE CUSTOMERID={0} AND (ADMINACCOUNT LIKE '%|{1}|%' OR OWNER={1})
OR (SELECT TOP 1 PROJECT_MEMBERS.ID FROM PROJECT_MEMBERS
INNER JOIN PROJECT_TEAMS ON PROJECT_MEMBERS.TEAM=PROJECT_TEAMS.ID
WHERE PROJECT_TEAMS.PROJECTID=PROJECT.ID AND PROJECT_MEMBERS.USERID={1} AND
(PROJECT_MEMBERS.TYPE=0 OR PROJECT_MEMBERS.TYPE=2)) IS NOT NULL", UC.CompanyId, UC.UserId);
NewRepeater1.sqlDataSource = q;
NewRepeater1.DataBind();
NewRepeater1.Visible = true;
Tabber.Visible = false;
}