示例#1
0
        private void button4_Click(object sender, EventArgs e)
        {
            try
            {
                //update button
                int          yr   = Convert.ToInt32(label19.Text);
                YearlyIncome yrDb = db.YearlyIncomes.SingleOrDefault(x => x.Id == yr);

                yrDb.year   = Convert.ToInt32(textBox1.Text);
                yrDb.income = Convert.ToInt32(textBox2.Text);

                db.SubmitChanges();
                MessageBox.Show("Data Updated");

                //opening this window by refershing again
                Hide();
                YearlyIncomeClass newObj = new YearlyIncomeClass();
                newObj.whoLoggedIn = this.whoLoggedIn;
                newObj.Show();
            }

            catch
            {
                MessageBox.Show("Invalid Input");
            }
        }
示例#2
0
        private void YearlyIncomeClass_Load(object sender, EventArgs e)
        {
            ///first
            YearlyIncome first = db.YearlyIncomes.SingleOrDefault(x => x.Id == 1);

            label19.Text  = first.Id.ToString();
            textBox1.Text = first.year.ToString();
            textBox2.Text = first.income.ToString();

            ///second
            YearlyIncome second = db.YearlyIncomes.SingleOrDefault(x => x.Id == 2);

            label20.Text  = second.Id.ToString();
            textBox4.Text = second.year.ToString();
            textBox3.Text = second.income.ToString();

            ///third
            YearlyIncome third = db.YearlyIncomes.SingleOrDefault(x => x.Id == 3);

            label21.Text  = third.Id.ToString();
            textBox6.Text = third.year.ToString();
            textBox5.Text = third.income.ToString();

            ///forth
            YearlyIncome forth = db.YearlyIncomes.SingleOrDefault(x => x.Id == 4);

            label22.Text  = forth.Id.ToString();
            textBox8.Text = forth.year.ToString();
            textBox7.Text = forth.income.ToString();

            ///fifth
            YearlyIncome fifth = db.YearlyIncomes.SingleOrDefault(x => x.Id == 5);

            label23.Text   = fifth.Id.ToString();
            textBox10.Text = fifth.year.ToString();
            textBox9.Text  = fifth.income.ToString();
        }
 partial void UpdateYearlyIncome(YearlyIncome instance);
 partial void DeleteYearlyIncome(YearlyIncome instance);
 partial void InsertYearlyIncome(YearlyIncome instance);