protected void DdlUserDataBind()
{
DdlUser.DataSource = DBHelper.createDDLView("select user_id value,user_id text from jp_user where admin='0'");
DdlUser.DataTextField = "text";
DdlUser.DataValueField = "value";
DdlUser.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
var db = new TestEntities();
var userlist = db.Database.SqlQuery <KeyValue>("select cast(username as varchar(100)) as [Key], cast(Id as varchar(50)) as Value from jira_team (nolock)").ToList();
var sprintlist = db.Database.SqlQuery <KeyValue>("select cast(Sprint as varchar(100)) as [Key] , cast(Id as varchar(50)) as Value from [JIRASprint] (nolock)").ToList();
var users = new List <ListItem>();
foreach (var u in userlist)
{
users.Add(new ListItem {
Text = u.Key, Value = u.Value
});
}
DdlUser.DataSource = users;
DdlUser.DataBind();
var sprints = new List <ListItem>();
foreach (var s in sprintlist)
{
sprints.Add(new ListItem {
Text = s.Key, Value = s.Value
});
}
DdlSprint.DataSource = sprints;
DdlSprint.DataBind();
}
}
private void bindGVuser()
{
DdlUser.DataSource = DBHelper.createDDLView("select user_id,user_id user_text from jp_user");
DdlUser.DataTextField = "user_text";
DdlUser.DataValueField = "user_id";
DdlUser.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["Uname"] != null)
{
Master.Li.Visible = false;
Master.Lo.Visible = true;
if (Session["UType"].ToString() == "Administrator")
{
Master.Aut.Visible = true;
}
else
{
Response.Redirect("~/NotAut.aspx");
}
}
else
{
Response.Redirect("~/Master.aspx");
}
if (!IsPostBack)
{
string str = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
using (SqlConnection con = new SqlConnection(str))
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "select * from tbluser";
cmd.Connection = con;
con.Open();
DdlUser.DataSource = cmd.ExecuteReader();
DdlUser.DataTextField = "UName";
//DdlUser.DataValueField = "UName";
DdlUser.DataBind();
con.Close();
DdlUser.Items.Insert(0, "Select One");
DdlUser.SelectedIndex = 0;
cmd.CommandText = "select * from tblUType";
cmd.Connection = con;
con.Open();
DdlType.DataSource = cmd.ExecuteReader();
DdlType.DataTextField = "UType";
DdlType.DataValueField = "UTypeId";
DdlType.DataBind();
con.Close();
DdlType.Items.Insert(0, "Select One");
DdlType.SelectedIndex = 0;
}
DdlType.Enabled = false;
BtnSave.Enabled = false;
}
}
public void FillUser()
{
try
{
DataTable dt = USER_MASLogicLayer.GetAllUSER_MASDetials_ForDDl();
DdlUser.DataSource = dt;
DdlUser.DataValueField = "USERCODE";
DdlUser.DataTextField = "USERNAME";
DdlUser.DataBind();
}
catch (Exception)
{
throw;
}
}
public void FillDdlUser()
{
try
{
string COMP_CODE = DdlCompany.SelectedValue;
DataTable dt = USER_MASLogicLayer.GetAllUserWiseCompanyRights(COMP_CODE);
DdlUser.DataSource = dt;
DdlUser.DataValueField = "USERCODE";
DdlUser.DataTextField = "USERNAME";
DdlUser.DataBind();
}
catch (Exception)
{
throw;
}
}