private void ViewAllMembers() { var db = new OOPCSEntities(); var members = db.Members.ToArray(); var memberView = new MemberView[members.Length]; for (int i = 0; i < members.Length; i++) { memberView[i] = new MemberView(members[i]); } this.grdMembers.DataSource = memberView; }
private void ViewAllExpenditure() { var db = new OOPCSEntities(); var expenditures = db.Expenditures.ToArray(); var expenditureViews = new ExpenditureView[expenditures.Length]; for (int i = 0; i < expenditureViews.Length; i++) { expenditureViews[i] = new ExpenditureView(expenditures[i]); } this.grdExpenditures.DataSource = expenditureViews; }
void btnsave_Click(object sender, EventArgs e) { DateTime date = this.dtpDate.Value; string note = this.textBox1.Text; int price = Decimal.ToInt32(this.nudPrice.Value); var expenditure = new Expenditure(); expenditure.Date = date; expenditure.Note = note; expenditure.Price = price; var db = new OOPCSEntities(); db.Expenditures.Add(expenditure); db.SaveChanges(); this.Close(); }
void grdExpenditures_KeyDown(object sender, KeyEventArgs e) { if (e.KeyValue == 46) { if (this.grdExpenditures.SelectedRows.Count == 1) { if (MessageBox.Show("do you want to delete this?") == System.Windows.Forms.DialogResult.OK) { ExpenditureView selected = (ExpenditureView) this.grdExpenditures.SelectedRows[0].DataBoundItem; var db = new OOPCSEntities(); Expenditure deleted = db.Expenditures.Find(selected.id); db.Expenditures.Remove(deleted); db.SaveChanges(); this.ViewAllExpenditure(); } } } }
public MemberView(Member member) { this.id = member.id; this.Fullname = member.Fullname; this.Gender = member.Gender == true ? "Nam" : "Nu"; if (member.Birthday != null) { this.Birthday = string.Format("{0}/{1}/{2}", member.Birthday.Value.Day, member.Birthday.Value.Month, member.Birthday.Value.Year ); } if (member.Status.HasValue) { this.Status = member.Status.Value == true ? "Living" : "Deceased"; } var db = new OOPCSEntities(); if (member.Father_id.HasValue) { var father = db.Members.Find(member.Father_id.Value); this.Father = father.Fullname; } if (member.Mother_id.HasValue) { var mother = db.Members.Find(member.Mother_id.Value); this.Mother = mother.Fullname; } if (member.Spouse_id.HasValue) { var spouse = db.Members.Find(member.Spouse_id.Value); this.Spouse = spouse.Fullname; } this.Hometowm = member.Hometowm; this.Currentliving = member.Currentliving; this.Occupation = member.Occupation; }