protected void Page_Load(object sender, EventArgs e)
{
startDate = DateTime.Today.ToString("yyyy/MM/dd");
connectionString = @"Server=" + SERVER + @";Database=" + DATABASE + @";Uid=" + UID + @";Pwd=" + PWD;
DataLayer = new clsDataLayer();
username = Session["sessionUserID"].ToString();
usernameLabel.InnerText = username;
// TODO: move code in to this method
//GetCategoryTypes();
//loads categories
clsDataLayer cls;
if (!IsPostBack)
{
cls = new clsDataLayer();
dropdownCategoryTypes.DataSource = cls.GetCategoryTypes((string)Session["sessionUserID"]);
dropdownCategoryTypes.DataTextField = "CatName";
dropdownCategoryTypes.DataValueField = "CatID";
dropdownCategoryTypes.DataBind();
dropdownCategoryTypes.Items.Insert(0, new ListItem("--Select Category--", "0"));
getChartData(username);
}
else
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
clsDataLayer cls = new clsDataLayer();
Tuple <int, String, String> catInfo = cls.GetCategoryDetails(Int32.Parse(Session["UpdateCatID"].ToString()));
DataTable dt = cls.GetCategoryTypes(Session["sessionUserID"].ToString());
txbxCatName.Text = catInfo.Item2;
txbxCatDesc.Text = catInfo.Item3;
}
}
protected void Page_Load(object sender, EventArgs e)
{
clsDataLayer cdl;
if (!IsPostBack)
{
cdl = new clsDataLayer();
lstCategoryNames.DataSource = cdl.GetCategoryTypes((string)Session["sessionUserID"]);
lstCategoryNames.DataTextField = "CatName";
lstCategoryNames.DataValueField = "CatID";
lstCategoryNames.DataBind();
}
}
protected void GetCategoryTypes()
{
if (!IsPostBack)
{
clsDataLayer cls = new clsDataLayer();
//DatacatInfo = cls.GetCategoryDetails( username);
DataTable dt = cls.GetCategoryTypes(username);
//dropdownCategoryTypes.Text =
//ddlTeamLead.DataSource = cmd.ExecuteReader();
dropdownCategoryTypes.DataSource = dt;
dropdownCategoryTypes.DataTextField = "TeamLead";
dropdownCategoryTypes.DataValueField = "TeamLead";
//dropdownCategoryTypes.DataBind();
//ddlTeamLead.DataBind();
}
}
