public ActionResult ContributionPost(string transactionPassword) { try { BankDetail bankDetail = _valleyDreamsIndiaDBEntities.BankDetails.First(x => x.UsersDetailsId == CurrentUser.CurrentUserId && x.Deleted == 0); if (bankDetail.TransactionPassword == transactionPassword) { ContributionDetail ContributionDetails = _valleyDreamsIndiaDBEntities.ContributionDetails .Where(x => x.UserDetailsId == CurrentUser.CurrentUserId) .OrderByDescending(x => x.NextContribNumber).FirstOrDefault(); ContributionDetail contributionDetails = new ContributionDetail(); contributionDetails.ContribNumber = ContributionDetails.NextContribNumber; contributionDetails.ContribDate = DateTime.Now; contributionDetails.ContribAmount = 1000; contributionDetails.NextContribNumber = ContributionDetails.NextContribNumber + 1; contributionDetails.NextContribDate = new DateTime(DateTime.Now.AddMonths(1).Year, DateTime.Now.AddMonths(1).Month, 20); contributionDetails.RemainingContrib = 15 - ContributionDetails.NextContribNumber; contributionDetails.UserDetailsId = CurrentUser.CurrentUserId; contributionDetails.SponsoredId = bankDetail.UsersDetail.SponsoredId; contributionDetails.PayedBy = "SELF"; contributionDetails.IsCompleted = (contributionDetails.ContribNumber != 15) ? 0 : 1; _valleyDreamsIndiaDBEntities.ContributionDetails.Add(contributionDetails); _valleyDreamsIndiaDBEntities.SaveChanges(); RenewalPinDetail renewalPinDetail = _valleyDreamsIndiaDBEntities.RenewalPinDetails.Where(x => x.SponsoredId == CurrentUser.CurrentUserId && x.IsPinUsed == 0).OrderBy(x => x.PinCreatedOn).FirstOrDefault(); renewalPinDetail.IsPinUsed = 1; _valleyDreamsIndiaDBEntities.Entry(renewalPinDetail).State = System.Data.Entity.EntityState.Modified; _valleyDreamsIndiaDBEntities.SaveChanges(); ViewBag.OwnRenewalMessage = "Renewal Transfer Successfully "; UsersPersonalModelView usersPersonalModelView = GetContributionData(); return(View("~/Views/Members/Renewal/Contribution.cshtml", usersPersonalModelView)); } ViewBag.OwnRenewalMessage = "Mismatched Transaction Password"; UsersPersonalModelView usersPersonalModelView1 = GetContributionData(); return(View("~/Views/Members/Renewal/Contribution.cshtml", usersPersonalModelView1)); } catch (Exception ex) { throw new Exception(ex.Message); } }
public ActionResult OtherContribution(string transactionPassword, string memberid) { try { var otherMemberUserDetails = _valleyDreamsIndiaDBEntities.UsersDetails.Where(x => x.UserName == memberid).FirstOrDefault(); BankDetail bankDetail = _valleyDreamsIndiaDBEntities.BankDetails.First(x => x.UsersDetailsId == CurrentUser.CurrentUserId && x.Deleted == 0); if (bankDetail.TransactionPassword == transactionPassword) { ContributionDetail ContributionDetails = _valleyDreamsIndiaDBEntities.ContributionDetails .Where(x => x.UserDetailsId == otherMemberUserDetails.Id) .OrderByDescending(x => x.NextContribNumber).FirstOrDefault(); ContributionDetail contributionDetails = new ContributionDetail(); contributionDetails.ContribNumber = ContributionDetails.NextContribNumber; contributionDetails.ContribDate = DateTime.Now; contributionDetails.ContribAmount = 1000; contributionDetails.NextContribNumber = ContributionDetails.NextContribNumber + 1; contributionDetails.NextContribDate = new DateTime(DateTime.Now.AddMonths(1).Year, DateTime.Now.AddMonths(1).Month, 20); contributionDetails.RemainingContrib = 15 - ContributionDetails.NextContribNumber; contributionDetails.UserDetailsId = otherMemberUserDetails.Id; contributionDetails.SponsoredId = CurrentUser.CurrentUserId; contributionDetails.PayedBy = "SPONSOR"; contributionDetails.IsCompleted = (contributionDetails.ContribNumber != 15) ? 0 : 1; _valleyDreamsIndiaDBEntities.ContributionDetails.Add(contributionDetails); _valleyDreamsIndiaDBEntities.SaveChanges(); RenewalPinDetail renewalPinDetails = _valleyDreamsIndiaDBEntities.RenewalPinDetails.Where(x => x.SponsoredId == CurrentUser.CurrentUserId && x.IsPinUsed == 0).OrderBy(x => x.PinCreatedOn).FirstOrDefault(); renewalPinDetails.IsPinUsed = 1; _valleyDreamsIndiaDBEntities.Entry(renewalPinDetails).State = System.Data.Entity.EntityState.Modified; _valleyDreamsIndiaDBEntities.SaveChanges(); return(RedirectToAction("Contribution", new { memberid })); } return(RedirectToAction("Contribution", new { memberid })); } catch (Exception ex) { throw new Exception(ex.Message); } }
public ActionResult AssignPin(string sponsoredId, int totalPin, string pinType) { var getUser = _valleyDreamsIndiaDBEntities.UsersDetails.Where(x => x.UserName == sponsoredId).FirstOrDefault(); if (pinType == "NEW") { UsersDetail userDetail = new UsersDetail(); for (int i = 1; i <= totalPin; i++) { userDetail.PinCreatedOn = DateTime.Now; userDetail.Deleted = 0; userDetail.SponsoredId = getUser.Id; userDetail.IsPinUsed = 0; userDetail.PinType = pinType; _valleyDreamsIndiaDBEntities.UsersDetails.Add(userDetail); _valleyDreamsIndiaDBEntities.SaveChanges(); } } if (pinType == "RENEW") { RenewalPinDetail renewalPinDetail = new RenewalPinDetail(); for (int i = 1; i <= totalPin; i++) { renewalPinDetail.PinCreatedOn = DateTime.Now; renewalPinDetail.Deleted = 0; renewalPinDetail.SponsoredId = getUser.Id; renewalPinDetail.IsPinUsed = 0; _valleyDreamsIndiaDBEntities.RenewalPinDetails.Add(renewalPinDetail); _valleyDreamsIndiaDBEntities.SaveChanges(); } } ViewBag.Message = $"{pinType} has been assigned successfully"; return(View()); }