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());
}
