private void CreateNote_Load(object sender, EventArgs e)
{
DataTable data = getUserIdByUserName.getUserId(username);
int userId = int.Parse(data.Rows[0][0].ToString());
DataTable dt = notebll.getCategory(userId);
cmbCategory.DataSource = dt;
cmbCategory.DisplayMember = "categoryName";
cmbCategory.ValueMember = "categoryId";
}
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 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 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);
}
private void btnSave_Click(object sender, EventArgs e)
{
DataTable dt = categorybll.getUserId(username);
int userId = int.Parse(dt.Rows[0][0].ToString());
if (!string.IsNullOrEmpty(txtCategory.Text.Trim()))
{
string categoryName = txtCategory.Text;
bool isCategoryExist = categorybll.checkCategory(userId, categoryName);
if (isCategoryExist)
{
MessageBox.Show("Category name already exist");
return;
}
else if (txtCategory.Text == "")
{
MessageBox.Show("Enter category name first");
}
else if (btnSave.Text == "Save")
{
string category = txtCategory.Text;
categorybll.addCetegory(userId, category);
dataGridView1.DataSource = categorybll.showCategory(userId);
MessageBox.Show("Category added");
txtCategory.Clear();
StickyNotes stickyNote = new StickyNotes(this.username);
this.Hide();
stickyNote.ShowDialog();
this.Close();
}
else if (btnSave.Text == "Update")
{
string category = txtCategory.Text;
categorybll.updateCategory(categoryid, category);
dataGridView1.DataSource = categorybll.showCategory(userId);
MessageBox.Show("Updated Successfully");
txtCategory.Text = "";
}
}
}
