private void button1_Click(object sender, EventArgs e) { if (txtName.Text == "" || txtPassword.Text == "" || txtKeyword.Text == "") { errorProvider1.SetError(txtName, "Please enter a name"); errorProvider2.SetError(txtPassword, "Please enter a password"); errorProvider3.SetError(txtKeyword, "Please enter a keyword"); } else { errorProvider1.Dispose(); errorProvider2.Dispose(); errorProvider3.Dispose(); using (var budgetContext = new BudgetEntities()) { var user = budgetContext.Accounts.Where(acc => acc.Name.Equals(txtName.Text) && acc.KeyWord.Equals(txtKeyword.Text)).FirstOrDefault(); if (user != null) { user.Password = txtPassword.Text; budgetContext.Entry(user).State = EntityState.Modified; budgetContext.SaveChanges(); MessageBox.Show("Success!"); } else { label4.Text = "Invalid keyword or name !"; } } } }
private void buttonUpdate_Click(object sender, EventArgs e) { if (this.dataGridUsers.SelectedRows.Count > 0) { using (var budgetContext = new BudgetEntities()) { foreach (DataGridViewRow item in this.dataGridUsers.SelectedRows) { var id = Convert.ToInt32(item.Cells[0].Value); var user = budgetContext.Accounts.Where(u => u.Id == id).FirstOrDefault(); user.Name = Convert.ToString(item.Cells[1].Value); user.Password = Convert.ToString(item.Cells[2].Value); user.KeyWord = Convert.ToString(item.Cells[3].Value); budgetContext.Entry(user).State = EntityState.Modified; } budgetContext.SaveChanges(); MessageBox.Show("Users have been edited !"); } } else { MessageBox.Show("Please select one row"); } }
private void button1_Click(object sender, EventArgs e) { if (txtName.Text == "" || txtPassword.Text == "" || txtKeyWord.Text == "") { errorProvider1.SetError(txtName, "Please enter a name"); errorProvider2.SetError(txtPassword, "Please enter a password"); errorProvider3.SetError(txtKeyWord, "Please enter a keyword"); } else { errorProvider1.Dispose(); errorProvider2.Dispose(); errorProvider3.Dispose(); using (var budgetContext = new BudgetEntities()) { var user = new Account(); user.Name = txtName.Text; user.Password = txtPassword.Text; user.KeyWord = txtKeyWord.Text; user.Enabled = true; budgetContext.Accounts.Add(user); budgetContext.SaveChanges(); EmptyFields(); MessageBox.Show("User successful registered !"); } } }
private void UsersForm_Load(object sender, EventArgs e) { using (var budgetContext = new BudgetEntities()) { var list = budgetContext.Accounts.ToList(); usersList = (from usr in list select new User { Id = usr.Id, Name = usr.Name, Password = usr.Password, KeyWord = usr.KeyWord }).ToList(); dataGridUsers.DataSource = usersList; } }
private void button1_Click(object sender, EventArgs e) { using (var budgetContext = new BudgetEntities()) { var user = budgetContext.Accounts.Where(acc => acc.Name.Equals(textBox1.Text) && acc.Password.Equals(textBox2.Text) && acc.Enabled).FirstOrDefault(); if (user != null) { var form = new PersonalBudget(user.Id, user.Name); form.Show(); this.Hide(); } else { label3.Text = "Invalid username or password !"; } } }
private async void button6_Click(object sender, EventArgs e) { decimal outValue = 0; decimal inValue = 0; decimal profitValue = 0; ClearCharts(); using (var db = new BudgetEntities()) { if (rbYears.Checked) { var nrYears = dtProfitEnd.Value.Year - dtProfitStart.Value.Year; for (int i = 0; i <= nrYears; i++) { decimal?outgoings = db.Outgoings.Where(o => o.StartDate.Year == dtProfitStart.Value.Year + i).Count() > 0 ? db.Outgoings.Where(o => o.StartDate.Year == dtProfitStart.Value.Year + i).Sum(a => a.Amount) : 0; outValue += outgoings.Value; decimal?incomes = db.Incomes.Where(o => o.StartDate.Year == dtProfitStart.Value.Year + i).Count() > 0 ? db.Incomes.Where(o => o.StartDate.Year == dtProfitStart.Value.Year + i).Sum(a => a.Amount) : 0; inValue += incomes.Value; decimal?profit = incomes - outgoings; profitValue += profit.Value; chart1.Series["Profit"].Points.AddXY(dtProfitStart.Value.Year + i, profit); chart1.Series["Profit"].IsValueShownAsLabel = true; chart2.Series["Income"].Points.AddXY(dtProfitStart.Value.Year + i, incomes); chart2.Series["Income"].IsValueShownAsLabel = true; chart3.Series["Outgoings"].Points.AddXY(dtProfitStart.Value.Year + i, outgoings); chart3.Series["Outgoings"].IsValueShownAsLabel = true; } } if (rbMonths.Checked) { if (dtProfitEnd.Value.Year == dtProfitStart.Value.Year) { var nrMonths = dtProfitEnd.Value.Month - dtProfitStart.Value.Month; for (int i = 0; i <= nrMonths; i++) { decimal?outgoings = db.Outgoings.Where(o => o.StartDate.Month == dtProfitStart.Value.Month + i).Count() > 0 ? db.Outgoings.Where(o => o.StartDate.Month == dtProfitStart.Value.Month + i).Sum(a => a.Amount) : 0; outValue += outgoings.Value; decimal?incomes = db.Incomes.Where(o => o.StartDate.Month == dtProfitStart.Value.Month + i).Count() > 0 ? db.Incomes.Where(o => o.StartDate.Month == dtProfitStart.Value.Month + i).Sum(a => a.Amount) : 0; inValue += incomes.Value; decimal?profit = incomes - outgoings; profitValue += profit.Value; chart1.Series["Profit"].Points.AddXY(dtProfitStart.Value.Month + i, profit); chart1.Series["Profit"].IsValueShownAsLabel = true; chart2.Series["Income"].Points.AddXY(dtProfitStart.Value.Month + i, incomes); chart2.Series["Income"].IsValueShownAsLabel = true; chart3.Series["Outgoings"].Points.AddXY(dtProfitStart.Value.Month + i, outgoings); chart3.Series["Outgoings"].IsValueShownAsLabel = true; } } } labelOutgoing.Text = outValue.ToString(); labelIncome.Text = inValue.ToString(); labelProfit.Text = profitValue.ToString(); } }