public int UpdateMember(GYM.COMMON.Model.DTO.MemberRegistration memberRegistration)
{
int result = 0;
_context.MemberRegistration.Update(memberRegistration);
result = _context.SaveChanges();
return(result);
}
public int InsertMember(GYM.COMMON.Model.DTO.MemberRegistration memberRegistration)
{
_context.Database.BeginTransaction();
GYM.COMMON.Model.DTO.MemberRegistration objmemberRegistration = new GYM.COMMON.Model.DTO.MemberRegistration();
objmemberRegistration = _context.MemberRegistration.Add(memberRegistration).Entity;
_context.SaveChanges();
if (objmemberRegistration != null)
{
int time = Convert.ToInt32(_context.PeriodTb.Where(p => p.PeriodID == (_context.PlanMaster.Where(c => c.PlanID == objmemberRegistration.PlanID).FirstOrDefault().PeriodID)).FirstOrDefault().Value.ToString());
GYM.COMMON.Model.DTO.PaymentDetails paymentDetails = new GYM.COMMON.Model.DTO.PaymentDetails()
{
PaymentAmount = _context.PlanMaster.Where(p => p.PlanID == objmemberRegistration.PlanID).FirstOrDefault().PlanAmount,
CreateDate = objmemberRegistration.JoiningDate,
Createdby = Convert.ToInt32(memberRegistration.Createdby),
MemberID = objmemberRegistration.MemberId,
Paymenttype = "Cash",
RecStatus = "A",
WorkouttypeID = Convert.ToInt32(objmemberRegistration.Createdby)
};
DateTime next = objmemberRegistration.JoiningDate.Value.AddMonths(time).AddDays(1);
paymentDetails.NextRenwalDate = next;
DateTime payto = objmemberRegistration.JoiningDate.Value.AddMonths(time);
paymentDetails.PaymentTodt = payto;
_context.PaymentDetails.Add(paymentDetails);
_context.SaveChanges();
if (paymentDetails.PaymentID > 0)
{
_context.Database.CommitTransaction();
return(Convert.ToInt32(objmemberRegistration.MemberId));
}
}
return(0);
}