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 = ""; } } }