public int UpdateMember(MemberRegistrationDTO objMRDTO)
{
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["Mystring"].ToString()))
{
var para = new DynamicParameters();
para.Add("@MemID", objMRDTO.MemID);
para.Add("@MemberFName", objMRDTO.MemberFName);
para.Add("@MemberLName", objMRDTO.MemberLName);
para.Add("@MemberMName", objMRDTO.MemberMName);
para.Add("@Address", objMRDTO.Address);
para.Add("@DOB", objMRDTO.DOB);
para.Add("@Age", objMRDTO.Age);
para.Add("@Contactno", objMRDTO.Contactno);
para.Add("@EmailID", objMRDTO.EmailID);
para.Add("@Gender", objMRDTO.Gender);
para.Add("@PlantypeID", objMRDTO.PlantypeID);
para.Add("@WorkouttypeID", objMRDTO.WorkouttypeID);
para.Add("@Createdby", objMRDTO.Createdby);
para.Add("@JoiningDate", objMRDTO.JoiningDate);
para.Add("@ModifiedBy", 0);
para.Add("@MemIDOUT", dbType: DbType.Int32, direction: ParameterDirection.Output);
con.Execute("SprocMemberRegistrationInsertUpdateSingleItem", para, null, 0, CommandType.StoredProcedure);
int MemID = para.Get <int>("MemIDOUT");
return(MemID);
}
}
public int PayUpdate(MemberRegistrationDTO obj, int MemberID)
{
try
{
PaymentDetailsDTO PayPD = new PaymentDetailsDTO();
PayPD.PaymentID = 0;
PayPD.PlanID = Convert.ToInt32(obj.PlantypeID);
PayPD.WorkouttypeID = Convert.ToInt32(obj.WorkouttypeID);
string[] joing = obj.JoiningDate.ToString().Split('-');
int year2 = Convert.ToInt32(obj.JoiningDate.Value.Year);
int month2 = Convert.ToInt32(obj.JoiningDate.Value.Month);
int day2 = Convert.ToInt32(obj.JoiningDate.Value.Day);
DateTime joining = new DateTime(year2, month2, day2);
PayPD.PaymentFromdt = joining;
PayPD.PaymentAmount = Convert.ToDecimal(obj.Amount);
PayPD.CreateUserID = Convert.ToInt32(Session["UserID"]);
PayPD.ModifyUserID = 0;
PayPD.MemberID = MemberID;
PayPD.PaymentID = Convert.ToInt32(obj.PaymentID);
int payresult = objpay.UpdatePaymentDetails(PayPD);
return(payresult);
}
catch (Exception)
{
throw;
}
}
public async Task <LoginReturnDTO> Registration(MemberRegistrationDTO memberRegistration)
{
try
{
ValidatesRegistration(memberRegistration);
Member member = new Member();
member.Name = memberRegistration.Name;
member.UserName = memberRegistration.UserName;
member.Email = memberRegistration.Email;
member.SecretWord = _encrypt.EncryptPassword(memberRegistration.SecretWord);
member.Active = true;
member = await _memberRepository.Insert(member);
var token = _accessManager.GenerateToken(member);
return(new LoginReturnDTO()
{
Name = member.Name,
Email = member.Email,
Image = member.Image,
Adm = member.Adm,
Token = token
});
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public ActionResult Create()
{
MemberRegistrationDTO objMR = new MemberRegistrationDTO();
objMR.ListScheme = BindListScheme();
objMR.ListPlan = BindListPlan();
objMR.Listgender = BindGender();
ViewData["SelectedPlan"] = string.Empty;
return(View(objMR));
}
public async Task <ActionResult <LoginReturnDTO> > RegistrationMember(MemberRegistrationDTO memberRegistration)
{
try
{
return(await _memberService.Registration(memberRegistration));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
private void ValidatesRegistration(MemberRegistrationDTO member)
{
if (string.IsNullOrEmpty(member.Name))
{
throw new ValidationException("Favor informar o nome.");
}
if (string.IsNullOrEmpty(member.UserName))
{
throw new ValidationException("Favor informar o nome de usuario para login.");
}
if (string.IsNullOrEmpty(member.Email))
{
throw new ValidationException("Favor informar o email.");
}
if (!_validator.EmailValidator(member.Email))
{
throw new ValidationException("Favor informar um email válido.");
}
if (string.IsNullOrEmpty(member.SecretWord))
{
throw new ValidationException("Favor informar a senha.");
}
var min = member.SecretWord.Length - Regex.Replace(member.SecretWord, "[a-z]", "").Length;
var mai = member.SecretWord.Length - Regex.Replace(member.SecretWord, "[A-Z]", "").Length;
var numbers = member.SecretWord.Length - Regex.Replace(member.SecretWord, "[0-9]", "").Length;
var symbols = member.SecretWord.Length - Regex.Replace(member.SecretWord, "[!@#$%&;*]", "").Length;
if (member.SecretWord.Length < 8)
{
throw new ValidationException("Senha precisa conter ao menos 8 caracteres.");
}
if (min == 0)
{
throw new ValidationException("Senha precisa conter ao menos 1 letra minúscula.");
}
if (mai == 0)
{
throw new ValidationException("Senha precisa conter ao menos 1 letra maiúscula.");
}
if (numbers == 0)
{
throw new ValidationException("Senha precisa conter ao menos 1 número.");
}
if (symbols == 0)
{
throw new ValidationException("Senha precisa conter ao menos 1 caracter especial.");
}
}
public ActionResult Create(MemberRegistrationDTO obj, FormCollection frm)
{
try
{
if (string.IsNullOrEmpty(obj.MemberFName))
{
ModelState.AddModelError("Error", "Please enter First Name");
}
else if (string.IsNullOrEmpty(obj.MemberMName))
{
ModelState.AddModelError("Error", "Please enter Middle Name");
}
else if (string.IsNullOrEmpty(obj.MemberLName))
{
ModelState.AddModelError("Error", "Please enter Last Name");
}
else if (string.IsNullOrEmpty(Convert.ToString(obj.DOB)))
{
ModelState.AddModelError("Error", "Please select Birth Date");
}
else if (string.IsNullOrEmpty(Convert.ToString(obj.JoiningDate)))
{
ModelState.AddModelError("Error", "Please select Joining Date");
}
else if (string.IsNullOrEmpty(obj.Age))
{
ModelState.AddModelError("Error", "Please enter Age");
}
else if (string.IsNullOrEmpty(obj.EmailID))
{
ModelState.AddModelError("Error", "Please enter EmailID");
}
else if (string.IsNullOrEmpty(Convert.ToString(obj.WorkouttypeID)))
{
ModelState.AddModelError("Error", "Please select Workouttype");
}
else if (string.IsNullOrEmpty(Convert.ToString(obj.PlantypeID)))
{
ModelState.AddModelError("Error", "Please select Plan");
}
else if (string.IsNullOrEmpty(obj.Contactno))
{
ModelState.AddModelError("Error", "Please enter Contactno");
}
else if (string.IsNullOrEmpty(obj.Address))
{
ModelState.AddModelError("Error", "Please enter Address");
}
else if (string.IsNullOrEmpty(Convert.ToString(obj.Amount)))
{
ModelState.AddModelError("Error", "Amount Cannot be Empty");
}
else
{
string[] parttime = obj.DOB.ToString().Split('-');
int year1 = Convert.ToInt32(obj.DOB.Value.Year);
int month1 = Convert.ToInt32(obj.DOB.Value.Month);
int day1 = Convert.ToInt32(obj.DOB.Value.Day);
DateTime birthdate = new DateTime(year1, month1, day1);
obj.DOB = birthdate;
string[] joing = obj.JoiningDate.ToString().Split('-');
int year2 = Convert.ToInt32(obj.JoiningDate.Value.Year);
int month2 = Convert.ToInt32(obj.JoiningDate.Value.Month);
int day2 = Convert.ToInt32(obj.JoiningDate.Value.Day);
DateTime joining = new DateTime(year2, month2, day2);
obj.JoiningDate = joining;
obj.Createdby = Convert.ToInt32(Session["UserID"]);
int MemberID = objRegMem.InsertMember(obj); // Insert into MemberDetails
if (MemberID > 0)
{
int payresult = Pay(obj, MemberID); // Insert into Paymentdetails
if (payresult > 0)
{
TempData["Message"] = "Member Created Successfully.";
}
else
{
TempData["Message"] = "Some thing went wrong while Member Created .";
}
}
else
{
TempData["Message"] = "Some thing went wrong while Member Created .";
}
return(RedirectToAction("Create"));
}
obj.ListScheme = BindListScheme(); // binding scheme
obj.ListPlan = BindListPlan(); // binding plan
obj.Listgender = BindGender(); // binding gender
ViewData["SelectedPlan"] = obj.PlantypeID; // Maintaining plan dropdowm list after postback
return(View(obj));
}
catch (Exception)
{
throw;
}
}
public ActionResult Edit(MemberRegistrationDTO objMR, string actionType)
{
if (actionType == "Update")
{
if (string.IsNullOrEmpty(objMR.MemberFName))
{
ModelState.AddModelError("Error", "Please enter First Name");
}
else if (string.IsNullOrEmpty(objMR.MemberMName))
{
ModelState.AddModelError("Error", "Please enter Middle Name");
}
else if (string.IsNullOrEmpty(objMR.MemberLName))
{
ModelState.AddModelError("Error", "Please enter Last Name");
}
else if (string.IsNullOrEmpty(Convert.ToString(objMR.DOB)))
{
ModelState.AddModelError("Error", "Please select Birth Date");
}
else if (string.IsNullOrEmpty(Convert.ToString(objMR.JoiningDate)))
{
ModelState.AddModelError("Error", "Please select Joining Date");
}
else if (string.IsNullOrEmpty(objMR.Age))
{
ModelState.AddModelError("Error", "Please enter Age");
}
else if (string.IsNullOrEmpty(objMR.EmailID))
{
ModelState.AddModelError("Error", "Please enter EmailID");
}
else if (string.IsNullOrEmpty(Convert.ToString(objMR.WorkouttypeID)))
{
ModelState.AddModelError("Error", "Please select Workouttype");
}
else if (string.IsNullOrEmpty(Convert.ToString(objMR.PlantypeID)))
{
ModelState.AddModelError("Error", "Please select Plan");
}
else if (string.IsNullOrEmpty(objMR.Contactno))
{
ModelState.AddModelError("Error", "Please enter Contactno");
}
else if (string.IsNullOrEmpty(objMR.Address))
{
ModelState.AddModelError("Error", "Please enter Address");
}
else if (string.IsNullOrEmpty(Convert.ToString(objMR.Amount)))
{
ModelState.AddModelError("Error", "Amount Cannot be Empty");
}
else
{
string[] parttime = objMR.DOB.ToString().Split('-');
int year1 = Convert.ToInt32(objMR.DOB.Value.Year);
int month1 = Convert.ToInt32(objMR.DOB.Value.Month);
int day1 = Convert.ToInt32(objMR.DOB.Value.Day);
DateTime birthdate = new DateTime(year1, month1, day1);
objMR.DOB = birthdate;
string[] joing = objMR.JoiningDate.ToString().Split('-');
int year2 = Convert.ToInt32(objMR.JoiningDate.Value.Year);
int month2 = Convert.ToInt32(objMR.JoiningDate.Value.Month);
int day2 = Convert.ToInt32(objMR.JoiningDate.Value.Day);
DateTime joining = new DateTime(year2, month2, day2);
objMR.JoiningDate = joining;
objMR.Createdby = Convert.ToInt32(Session["UserID"]);
int MemberID = objRegMem.UpdateMember(objMR); // Insert into MemberDetails
if (MemberID > 0)
{
int payresult = PayUpdate(objMR, MemberID);
TempData["MessageUpdate"] = "Member Created Successfully.";
}
return(RedirectToAction("Index"));
}
return(RedirectToAction("Index"));
}
else
{
return(RedirectToAction("Index"));
}
}
