private void btnCreateMember_Click(object sender, EventArgs e) { try { if (string.IsNullOrEmpty(txtBoxMemberName.Text)) { MessageBox.Show("Please provide member name!"); return; } if (string.IsNullOrEmpty(txtBoxMemberMobileNo.Text)) { MessageBox.Show("Please provide member mobile no!"); return; } _db = new AcmDbContext(); Member member = new Member { Name = txtBoxMemberName.Text, MobileNo = txtBoxMemberMobileNo.Text, CreateDateTime = DateTime.Now }; if (member.Name != "" && member.MobileNo != "") { _db.Members.Add(member); _db.SaveChanges(); var feeAmount = Convert.ToDouble(txtBoxDepositFeeAmount.Text); if (feeAmount > 0 && member.Id > 0) { MemberFeeAmount memberFeeAmount = new MemberFeeAmount { MemberId = member.Id, FeeAmount = Convert.ToDouble(txtBoxDepositFeeAmount.Text) }; _db.MemberFeeAmounts.Add(memberFeeAmount); _db.SaveChanges(); ClearTextBox(); MessageBox.Show("Member created successfully with fee amount"); } else { ClearTextBox(); MessageBox.Show("Member created successully but fee amount not created"); } } else { MessageBox.Show("Failed to create member"); } } catch (Exception ex) { MessageBox.Show("Get an exception. The exception is -" + Environment.NewLine + ex.ToString()); } }
private void btnFeeUpdate_Click(object sender, EventArgs e) { try { if (Convert.ToDouble(txtBoxNewFeeAmount.Text) <= 0 || txtBoxNewFeeAmount.Text == "") { MessageBox.Show("New fee amount value is not a right format"); return; } _db = new AcmDbContext(); var memberFeeAmount = _db.MemberFeeAmounts.FirstOrDefault(c => c.Id == _updateFeeId); if (memberFeeAmount != null) { memberFeeAmount.FeeAmount = Convert.ToDouble(txtBoxNewFeeAmount.Text); _db.MemberFeeAmounts.Attach(memberFeeAmount); _db.Entry(memberFeeAmount).State = EntityState.Modified; _db.SaveChanges(); ClearTextBox(); MessageBox.Show("Member fee amount updated successfully"); } if (memberFeeAmount == null) { MemberFeeAmount newFeeAmount = new MemberFeeAmount(); newFeeAmount.MemberId = _memberId; newFeeAmount.FeeAmount = Convert.ToDouble(txtBoxNewFeeAmount.Text); _db.MemberFeeAmounts.Add(newFeeAmount); _db.SaveChanges(); ClearTextBox(); MessageBox.Show("Member fee amount added successfully"); } } catch (Exception ex) { MessageBox.Show("Get an exception. The exception is -" + Environment.NewLine + ex.ToString()); } }