protected void Page_Load(object sender, EventArgs e)
{
con = new SqlConnection(conn);
if (!IsPostBack)
{
Dd2.Items.Insert(0, "select");
SqlDataAdapter da = new SqlDataAdapter();
SqlCommand cmd = new SqlCommand("Select * FROM scrum_roles2");
SqlDataAdapter da1 = new SqlDataAdapter();
SqlCommand cmd1 = new SqlCommand("Select * FROM sprints");
// SqlCommand cmd2 = new SqlCommand("Select * FROM master where [Backlog Name]='"+ s +"'");
DataTable dt1 = new DataTable();
DataTable dt2 = new DataTable();
da.SelectCommand = cmd;
da.SelectCommand.Connection = con;
da.Fill(dt1);
Dd1.DataSource = dt1;
Dd1.DataTextField = "Name";
Dd1.DataValueField = "Name";
Dd1.DataBind();
da1.SelectCommand = cmd1;
da1.SelectCommand.Connection = con;
da1.Fill(dt2);
Dd2.DataSource = dt2;
Dd2.DataTextField = "id";
Dd2.DataValueField = "id";
Dd2.DataBind();
Dd2.Items.Insert(0, new ListItem("General", "General"));
}
}
protected void Page_Load(object sender, EventArgs e)
{
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter();
SqlCommand cmd = new SqlCommand("select * from scrum_roles2", con);
da.SelectCommand = cmd;
da.SelectCommand.Connection = con;
da.Fill(dt);
if (dt.Rows.Count > 0)
{
Dd1.DataSource = dt;
Dd1.DataTextField = "Name";
Dd1.DataValueField = "Name";
Dd1.DataBind();
}
DataTable dt1 = new DataTable();
SqlDataAdapter da1 = new SqlDataAdapter();
SqlCommand cmd1 = new SqlCommand("select * from sprints", con);
da.SelectCommand = cmd1;
da.SelectCommand.Connection = con;
da.Fill(dt1);
Dd2.Items.Insert(0, new ListItem("select", ""));
if (dt1.Rows.Count > 0)
{
Dd2.DataSource = dt1;
Dd2.DataTextField = "id";
Dd2.DataValueField = "id";
Dd2.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
con = new SqlConnection(conn);
if (!IsPostBack)
{
if (Session["username"] == null || Session["password"] == null)
{
Response.Redirect("login.aspx");
}
SqlDataAdapter da = new SqlDataAdapter();
SqlCommand cmd = new SqlCommand("Select * FROM scrum_roles2");
DataTable dt1 = new DataTable();
da.SelectCommand = cmd;
da.SelectCommand.Connection = con;
da.Fill(dt1);
Dd1.DataSource = dt1;
Dd1.DataTextField = "Name";
Dd1.DataValueField = "Name";
Dd1.DataBind();
Dd1.Items.Insert(0, "select");
DataTable var = new DataTable();
SqlDataAdapter vAR = new SqlDataAdapter("select * from scrum_master1 where Username = '******' and password = '******' ", con);
vAR.Fill(var);
if (var.Rows.Count == 0)
{
Response.Redirect("dashboard.aspx");
con.Close();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
con = new SqlConnection(conn);
if (!IsPostBack)
{
con.Open();
if (Session["username"] == null && Session["password"] == null)
{
Response.Redirect("login.aspx");
}
SqlDataAdapter da = new SqlDataAdapter();
SqlCommand cmd = new SqlCommand("Select * FROM scrum_roles2 where Role='Developer'");
SqlDataAdapter da1 = new SqlDataAdapter();
SqlCommand cmd1 = new SqlCommand("Select * FROM product_backlog ");
SqlDataAdapter da2 = new SqlDataAdapter();
// SqlCommand cmd2 = new SqlCommand("Select * FROM master where [Backlog Name]='"+ s +"'");
DataTable dt1 = new DataTable();
DataTable dt2 = new DataTable();
DataTable dt3 = new DataTable();
da.SelectCommand = cmd;
da.SelectCommand.Connection = con;
da.Fill(dt1);
Dd1.DataSource = dt1;
Dd1.DataTextField = "Name";
Dd1.DataValueField = "Name";
Dd1.DataBind();
da1.SelectCommand = cmd1;
da1.SelectCommand.Connection = con;
da1.Fill(dt2);
Dd2.DataSource = dt2;
Dd2.DataTextField = "Name";
Dd2.DataValueField = "Name";
Dd2.DataBind();
// s = Dd2.SelectedValue.ToString();
//SqlCommand cmd2 = new SqlCommand("Select * FROM master");
//da2.SelectCommand = cmd2;
//da2.SelectCommand.Connection = con;
//da2.Fill(dt3);
//Dd3.DataSource = dt3;
//Dd3.DataTextField = "feature";
//Dd3.DataValueField = "feature";
//Dd3.DataBind();
//con.Close();
}
else
{
Response.Redirect("login.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
con = new SqlConnection(conn);
if (!IsPostBack)
{
if (Session["username"] != null && Session["password"] != null)
{
u = Session["username"].ToString();
p = Session["password"].ToString();
}
DataTable var = new DataTable();
SqlDataAdapter vAR = new SqlDataAdapter("select * from scrum_master1 where Username = '******' and Password = '******' ", con);
vAR.Fill(var);
if (var.Rows.Count == 0)
{
Response.Write("<script>alert('only scrum master create roles')</script>");
Response.Redirect("dashboard.aspx");
con.Close();
}
else
{
SetInitialRow();
SqlDataAdapter da = new SqlDataAdapter();
SqlCommand cmd = new SqlCommand("Select * FROM scrum_roles2 where Role='Product Master'");
DataTable dt1 = new DataTable();
da.SelectCommand = cmd;
da.SelectCommand.Connection = con;
da.Fill(dt1);
Dd1.DataSource = dt1;
Dd1.DataTextField = "Name";
Dd1.DataValueField = "Name";
Dd1.DataBind();
}
}
}
