public int UpdateMembershipType(MembershipTypeDetails mtd) { tblMembershipType tmt = _db.tblMembershipTypes.Where(m => m.MT_ID == mtd.MT_ID).FirstOrDefault(); tmt.MembershipType = mtd.MembershipType; tmt.ChargesPerMonth = mtd.ChargesPerMonth; tmt.ServiceTAX = mtd.ServiceTAX; tmt.VAT = mtd.VAT; return(_db.SaveChanges()); }
private void btnUpdateMembershipType_Click(object sender, EventArgs e) { if (txtMembershipType.Text == "") { MessageBox.Show("Please Enter MembershipType Name", "", MessageBoxButtons.OK, MessageBoxIcon.Warning); txtMembershipType.Focus(); return; } if (txtChargePerMonth.Text == "") { MessageBox.Show("Please Enter Charges per Month", "", MessageBoxButtons.OK, MessageBoxIcon.Warning); txtChargePerMonth.Focus(); return; } if (txtServicetax.Text == "") { MessageBox.Show("Please Enter Service TAX %", "", MessageBoxButtons.OK, MessageBoxIcon.Warning); txtServicetax.Focus(); return; } if (txtVAT.Text == "") { MessageBox.Show("Please Enter VAT %", "", MessageBoxButtons.OK, MessageBoxIcon.Warning); txtVAT.Focus(); return; } MembershipTypeDetails mtd = new MembershipTypeDetails(); mtd.MT_ID = membershiptypeid; mtd.MembershipType = txtMembershipType.Text; mtd.ChargesPerMonth = Convert.ToDecimal(txtChargePerMonth.Text); mtd.ServiceTAX = Convert.ToDecimal(txtServicetax.Text); mtd.VAT = Convert.ToDecimal(txtVAT.Text); bool isexists = blmt.CheckMembershipType(txtMembershipType.Text); if (isexists) { MessageBox.Show("Membership Type Already Exists", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); txtMembershipType.Text = ""; txtMembershipType.Focus(); } else { int i = blmt.UpdateMembershipType(mtd); if (i > 0) { LoadGrid(); MessageBox.Show("Membership Type Updated Successfully", "Record", MessageBoxButtons.OK, MessageBoxIcon.Information); Clear(); } } }
public int AddNewMembershipType(MembershipTypeDetails mtd) { tblMembershipType tmt = new tblMembershipType(); tmt.MembershipType = mtd.MembershipType; tmt.ChargesPerMonth = mtd.ChargesPerMonth; tmt.ServiceTAX = mtd.ServiceTAX; tmt.VAT = mtd.VAT; _db.tblMembershipTypes.Add(tmt); return(_db.SaveChanges()); }