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