private void StickyNoteCharts_Load(object sender, EventArgs e)
{
//Getting userid by username
addCategoryBLL getUserIdByUserName = new addCategoryBLL();
DataTable dt = getUserIdByUserName.getUserId(username);
userId = int.Parse(dt.Rows[0][0].ToString());
StickyChartBLL stickychartbll = new StickyChartBLL();
float completeNote, incompleteNote, allNote;
//show data for today note
completeNote = (float)stickychartbll.todayNoteCharts("completeNote", DateTime.Now.ToString(), userId);
incompleteNote = (float)stickychartbll.todayNoteCharts("incompleteNote", DateTime.Now.ToString(), userId);
allNote = (float)stickychartbll.todayNoteCharts("allNote", DateTime.Now.ToString(), userId);
todayNote_chart(completeNote, incompleteNote);
//show note data of one week
completeNote = (float)stickychartbll.weekNoteCharts("completeNote", DateTime.Now.AddDays(-7).ToString(), DateTime.Now.ToString(), userId);
incompleteNote = (float)stickychartbll.weekNoteCharts("incompleteNote", DateTime.Now.AddDays(-7).ToString(), DateTime.Now.ToString(), userId);
allNote = (float)stickychartbll.weekNoteCharts("allNote", DateTime.Now.AddDays(-7).ToString(), DateTime.Now.ToString(), userId);
weekNote_chart(completeNote, incompleteNote);
//show note data of one month
completeNote = (float)stickychartbll.monthNoteCharts("completeNote", DateTime.Now.AddDays(-1).ToString(), DateTime.Now.ToString(), userId);
incompleteNote = (float)stickychartbll.monthNoteCharts("incompleteNote", DateTime.Now.AddDays(-1).ToString(), DateTime.Now.ToString(), userId);
allNote = (float)stickychartbll.monthNoteCharts("allNote", DateTime.Now.AddDays(-1).ToString(), DateTime.Now.ToString(), userId);
monthNote_chart(completeNote, incompleteNote);
//show note data of one year
completeNote = (float)stickychartbll.yearNoteCharts("completeNote", DateTime.Now.AddDays(-1).ToString(), DateTime.Now.ToString(), userId);
incompleteNote = (float)stickychartbll.yearNoteCharts("incompleteNote", DateTime.Now.AddDays(-1).ToString(), DateTime.Now.ToString(), userId);
allNote = (float)stickychartbll.yearNoteCharts("allNote", DateTime.Now.AddDays(-1).ToString(), DateTime.Now.ToString(), userId);
yearNote_chart(completeNote, incompleteNote);
}
private void AccountSetting_Load(object sender, EventArgs e)
{
addCategoryBLL getUserIdByUserName = new addCategoryBLL();
DataTable dt = getUserIdByUserName.getUserId(this.username);
userId = int.Parse(dt.Rows[0][0].ToString());
DataTable data = acbll.accountSetting(userId);
txtFname.Text = data.Rows[0][0].ToString();
txtLname.Text = data.Rows[0][1].ToString();
string gender = data.Rows[0][2].ToString();
if (gender == "Male")
{
rdoMale.Checked = true;
}
else if (gender == "Female")
{
rdoFemale.Checked = true;
}
else if (gender == "Other")
{
rdoOther.Checked = true;
}
datePicker.Text = data.Rows[0][3].ToString();
txtEmail.Text = data.Rows[0][4].ToString();
txtUsername.Text = data.Rows[0][5].ToString();
txtPassword.Text = data.Rows[0][6].ToString();
txtConfirmPassword.Text = data.Rows[0][7].ToString();
}
private void StickyNotes_Load(object sender, EventArgs e)
{
//Getting userid by username
addCategoryBLL getUserIdByUserName = new addCategoryBLL();
DataTable dt = getUserIdByUserName.getUserId(username);
userId = int.Parse(dt.Rows[0][0].ToString());
DataTable dataTable = stickyNotesbll.ShowStickyNotes(userId);
showStickyNotes(dataTable);
}
