public IHttpActionResult FotgetPassword(string email) { using (SleepingPartnermanagementTestingEntities dc = new SleepingPartnermanagementTestingEntities()) { var v = dc.NewUserRegistrations.Where(a => a.Email.Equals(email)).FirstOrDefault(); if (v != null) { System.Net.Mail.MailMessage mail = new System.Net.Mail.MailMessage(); mail.From = new MailAddress("*****@*****.**"); mail.To.Add(v.Email); mail.Subject = "Sleeping partner management portal"; mail.Body += "Your password is " + v.Password + "</br></br>" + "<table style='font-family:Verdana, Helvetica, sans-serif;' cellpadding='0' cellspacing='0'><tbody><tr><td style='font-family:Verdana; border-right:2px solid #BD272D; padding-right:15px; text-align: right; vertical-align:top; ' valign='top'><table style='font-family:Verdana; margin-right:0; margin-left:auto;' cellpadding='0' cellspacing='0'><tbody><tr><td style='font-family:Verdana; height:55px; vertical-align:top; text-align:right;' valign='top' align='right'><span style='font-family:Verdana; font-size:14pt; font-weight:bold'>Sleeping partner management<span><br></span></span></td></tr><tr><td style='font-family:Verdana; height:40px; vertical-align:top; padding:0; text-align:right;' valign='top' align='right'><span style='font-family:Verdana; font-size:10pt;'>phone: 123456<span><br></span></span><span style='font-family:Verdana; font-size:10pt;'>mobile: 0123456</span></td></tr><tr><td><a href='http://sleepingpartnermanagementportalrct.com'>sleepingpartnermanagementportal</a></td></tr></tbody></table></td><td style='padding-left:15px;font-size:1pt; vertical-align:top; font-family:Verdana;' valign='top'><table style='font-family:Verdana;' cellpadding='0' cellspacing='0'><tbody><tr><td style='height:55px; font-family:Verdana; vertical-align:top;' valign='top'><a href='{Logo URL}' target='_blank'><img alt='Logo' style='height:40px; width:auto; border:0; ' height='40' border='0' src='~/Content/images/newsleepinglogo.png'></a></td></tr><tr><td style='height:40px; font-family:Verdana; vertical-align:top; padding:0;' valign='top'><span style='font-family:Verdana; font-size:10pt;'>{Address 1}<span><br></span></span> <span style='font-family:Verdana; font-size:10pt;'>{Address 2}</span> </td></tr><tr><td style='height:20px; font-family:Verdana; vertical-align:middle;' valign='middle'><a href='http://{Web page}' target='_blank' style='color:#BD272D; font-size:10pt; font-family:Verdana;'>{Web page}</a></td></tr></tbody></table></td></tr></tbody></table>"; mail.IsBodyHtml = true; SmtpClient smtp = new SmtpClient(); smtp.Host = "sleepingpartnermanagementportalrct.com"; smtp.EnableSsl = true; smtp.UseDefaultCredentials = false; smtp.Credentials = new NetworkCredential("*****@*****.**", "Yly21#p8"); smtp.DeliveryMethod = SmtpDeliveryMethod.Network; smtp.Port = 25; ServicePointManager.ServerCertificateValidationCallback = delegate(object s, X509Certificate certificate, X509Chain chain, SslPolicyErrors sslPolicyErrors) { return(true); }; smtp.Send(mail); return(Ok(new { success = true, message = "email and password sent to user email account" })); } else { return(Ok(new { error = true, message = "user not exist" })); } } }
public IHttpActionResult GetVideoCategory() { SleepingPartnermanagementTestingEntities db = new SleepingPartnermanagementTestingEntities(); List <VideoPackCatTbl> videocategory = db.VideoPackCatTbls.ToList(); return(Ok(videocategory)); }
public IHttpActionResult GetUserCurrentPackagesList(int userId) { // var userId = Convert.ToInt32(Session["LogedUserID"].ToString()); SleepingPartnermanagementTestingEntities db = new SleepingPartnermanagementTestingEntities(); List <UserPackageModel> List = new List <UserPackageModel>(); List = db.UserPackages.Where(a => a.UserId.Value.Equals(userId)) .Select(x => new UserPackageModel { UserPackageId = x.UserPackageId, PackageName = x.PackageName, PackagePercent = x.PackagePercent.Value, PackagePrice = x.PackagePrice.Value, PackageValidity = x.PackageValidity, PackageMinWithdrawalAmount = x.PackageMinWithdrawalAmount.Value, PackageMaxWithdrawalAmount = x.PackageMaxWithdrawalAmount.Value, PackageId = x.PackageId.Value, UserId = x.UserId.Value, IsInCurrentUse = x.IsInCurrentUse.Value, PurchaseDate = x.PurchaseDate.Value, IsBuyFromEWallet = x.IsBuyFromEWallet.Value, IsBuyFromBankAcnt = x.IsBuyFromBankAcnt.Value, IsRequestedForBuy = x.IsRequestedForBuy.Value, IsApprovedForBuy = x.IsApprovedForBuy.Value, IsRejectedForBuy = x.IsRejectedForBuy.Value }).ToList(); return(Ok(List)); }
public IHttpActionResult ShowAdvertisementData() { SleepingPartnermanagementTestingEntities db = new SleepingPartnermanagementTestingEntities(); List <Advertisement> listadvertisement = db.Advertisements.Where(x => x.IsActive == true).ToList(); return(Ok(listadvertisement)); }
public IHttpActionResult profileimage(int userId) { SleepingPartnermanagementTestingEntities db = new SleepingPartnermanagementTestingEntities(); var image = db.NewUserRegistrations.Where(x => x.UserId == userId).Select(x => x.ProfileImage).FirstOrDefault(); return(Ok(new { success = true, message = image })); }
public IHttpActionResult postAdd(Advertisement model) { SleepingPartnermanagementTestingEntities db = new SleepingPartnermanagementTestingEntities(); db.Advertisements.Add(model); db.SaveChanges(); return(Ok("success")); }
//[HttpGet] //[Route("getalltotalrightuserpv/{userId}")] public string GetAllTotalRightUserPV(int userId) { using (SleepingPartnermanagementTestingEntities dc = new SleepingPartnermanagementTestingEntities()) { var TotalAmountRightUsers = dc.GetParentChildsRightSP(userId).Where(a => a.IsPaidMember.Value.Equals(true)).ToList(); var TotalAmountRightUsersShow = TotalAmountRightUsers.Sum(x => x.PaidAmount.Value); return(TotalAmountRightUsersShow.ToString()); } }
public IHttpActionResult Inbox(SentAdminMessageModel sentmodel) { int admin_id = 1; var fileImage = sentmodel.MessageImage; byte[] img; if (fileImage != null) { img = fileImage; } else { img = null; } // var userId = Convert.ToInt32(Session["LogedUserID"].ToString()); SleepingPartnermanagementTestingEntities db = new SleepingPartnermanagementTestingEntities(); SentAdminMessage sent_msg = new SentAdminMessage(); sent_msg.Sender = sentmodel.Sender = sentmodel.UserId; sent_msg.UserId = sentmodel.UserId = sentmodel.UserId; sent_msg.SponserId = admin_id; sent_msg.Sender_Name = sentmodel.Sender_Name; sent_msg.Message = sentmodel.Message; sent_msg.IsRead = sentmodel.IsRead = false; sent_msg.CreateDate = sentmodel.CreateDate = DateTime.Today; sent_msg.MessageImage = img; //sent_msg.MessageImage = fileImage.InputStream; //imageByte; db.SentAdminMessages.Add(sent_msg); //db.SaveChanges(); ReceiveAdminMessage Recive_msg = new ReceiveAdminMessage(); Recive_msg.Sender = sentmodel.Sender = sentmodel.UserId; Recive_msg.UserId = sentmodel.UserId = sentmodel.UserId; Recive_msg.SponserId = admin_id; Recive_msg.Sender_Name = sentmodel.Sender_Name; Recive_msg.Message = sentmodel.Message; Recive_msg.IsRead = sentmodel.IsRead = true; Recive_msg.CreateDate = sentmodel.CreateDate = DateTime.Today; Recive_msg.MessageImage = img; db.ReceiveAdminMessages.Add(Recive_msg); db.SaveChanges(); //var fcm = db.NewUserRegistrations.Where(x => x.UserId == sentmodel.SponserId).Select(x => x.Fcm).FirstOrDefault(); //if (fcm != null) //{ // WebClient client = new WebClient(); // client.DownloadString("https://sleepingpartnertesting.royalcryptoexchange.com/messageNotifyApi.php?send_notification&sname=" + // sentmodel.Sender_Name + "&uid=" + sentmodel.UserId + "&sid=" + sentmodel.SponserId + "&message=" + sentmodel.Message // + "&token=" + fcm); //} return(Ok(new { success = true, message = "messsage sent successfully" })); }
//return View( //[HttpGet] //[Route("getuserpackageamountlimitforwithdrawal/{userId}")] public string GetUserPackageAmountLimitForWithdrawal(int userId) { using (SleepingPartnermanagementTestingEntities dc = new SleepingPartnermanagementTestingEntities()) { UserPackage userPackages = dc.UserPackages.Where(a => a.UserId.Value.Equals(userId)).FirstOrDefault(); var userPackagesAmountLimitValue = userPackages.PackagePrice.Value; return(userPackagesAmountLimitValue.ToString()); } //return View(); }
//[HttpGet] //[Route("getalltotalleftuserpv/{userId}")] public string GetAllTotalLeftUserPV(int userId) { //var userId = Convert.ToInt32(Session["LogedUserID"].ToString()); using (SleepingPartnermanagementTestingEntities dc = new SleepingPartnermanagementTestingEntities()) { var TotalAmountLeftUsers = dc.GetParentChildsLeftSP(userId).Where(a => a.IsPaidMember.Value.Equals(true)).ToList(); var TotalAmountLeftUsersShow = TotalAmountLeftUsers.Sum(x => x.PaidAmount.Value); return(TotalAmountLeftUsersShow.ToString()); // return Ok(TotalAmountLeftUsers); } }
public string GetUserTotalPackageCommission(int userId) { using (SleepingPartnermanagementTestingEntities dc = new SleepingPartnermanagementTestingEntities()) { var CGP = (from a in dc.EWalletTransactions where a.UserId.Value == userId && a.IsPackageBonus.Value == true select a).ToList(); var query = CGP.Sum(x => x.Amount); return(query.ToString()); } }
public IHttpActionResult changestatus(int userId, int id) { using (SleepingPartnermanagementTestingEntities dc = new SleepingPartnermanagementTestingEntities()) { EWalletTransaction data = new EWalletTransaction(); EWalletWithdrawalFund newuserdata = dc.EWalletWithdrawalFunds .Where(a => a.WithdrawalFundId.Equals(id)).FirstOrDefault(); var ewalletTransId = Convert.ToInt32(newuserdata.EwalletTransId.Value); EWalletTransaction ewalletCheck = dc.EWalletTransactions.Where(a => a.TransactionId.Equals(ewalletTransId)).FirstOrDefault(); if (newuserdata != null) { newuserdata.PaidDate = DateTime.Now; newuserdata.IsActive = false; newuserdata.IsPaid = true; data.TransactionSource = newuserdata.UserName + " : " + Common.Enum.AmountSource.Withdrawal.ToString() + " : " + newuserdata.WithdrawalFundDescription; data.TransactionName = Common.Enum.AmountDebitOrCredit.Credit.ToString(); data.AsscociatedMember = newuserdata.UserId; data.Amount = newuserdata.AmountPayble; data.TransactionDate = DateTime.Now; data.Credit = true; data.Debit = false; data.UserId = newuserdata.UserId; data.IsPackageBonus = ewalletCheck.IsPackageBonus.Value; data.PackageId = ewalletCheck.PackageId.Value; data.IsMatchingBonus = ewalletCheck.IsMatchingBonus.Value; data.IsParentBonus = ewalletCheck.IsParentBonus.Value; data.IsWithdrawlRequestByUser = false; data.IsWithdrawlPaidByAdmin = false; data.IsWithdrawlRequestApproved = false; data.AdminCredit = false; data.AdminDebit = false; data.AdminTransactionName = Common.Enum.AmountSource.Withdrawal.ToString(); dc.EWalletTransactions.Add(data); dc.SaveChanges(); ewalletCheck.IsWithdrawlRequestApproved = true; ewalletCheck.IsWithdrawlPaidByAdmin = true; dc.SaveChanges(); ModelState.Clear(); return(Ok(new { success = true, message = "success" })); } else { return(Json(new { error = true, message = "failed" })); } } }
public string GetUserDownlineMembers(int userId) { string UserTypeUser = Common.Enum.UserType.User.ToString(); using (SleepingPartnermanagementTestingEntities dc = new SleepingPartnermanagementTestingEntities()) { var totalLeft = dc.GetParentChildsLeftSP(userId).ToList(); var totalRight = dc.GetParentChildsRightSP(userId).ToList(); var query = totalLeft.Count() + totalRight.Count(); return(query.ToString()); } }
public IHttpActionResult GetUserDirectCommissionList(int userId) { //var userId = Convert.ToInt32(Session["LogedUserID"].ToString()); SleepingPartnermanagementTestingEntities db = new SleepingPartnermanagementTestingEntities(); List <EWalletTransactionModel> ListEwalletModel = new List <EWalletTransactionModel>(); List <EWalletTransaction> ListEwallet = new List <EWalletTransaction>(); //List<UserGenealogyTable> ListGeoTbl = new List<UserGenealogyTable>(); NewUserRegistration newuser = new NewUserRegistration(); ListEwallet = db.EWalletTransactions.Where(a => a.UserId.Value.Equals(userId) && a.IsParentBonus.Value.Equals(true) && a.IsMatchingBonus.Value.Equals(false) && a.IsPackageBonus.Value.Equals(false) && a.Debit.Value.Equals(true)).ToList(); foreach (var item in ListEwallet) { var userIdChild = Convert.ToInt32(item.AsscociatedMember); bool checkWithDrawalOpen = false; newuser = db.NewUserRegistrations.Where(a => a.UserId.Equals(userIdChild)).FirstOrDefault(); if (newuser.IsWithdrawalOpen == true) { checkWithDrawalOpen = true; } if (newuser.IsWithdrawalOpen == false) { checkWithDrawalOpen = false; } if (newuser != null) { ListEwalletModel.Add(new EWalletTransactionModel() { TransactionId = item.TransactionId, TransactionSource = item.TransactionSource, TransactionName = item.TransactionName, AsscociatedMember = item.AsscociatedMember.Value, Amount = item.Amount.Value, TransactionDate = item.TransactionDate.Value, IsWithdrawlRequestByUser = item.IsWithdrawlRequestByUser.Value, IsWithdrawlPaidByAdmin = item.IsWithdrawlPaidByAdmin.Value, IsWithdrawlRequestApproved = item.IsWithdrawlRequestApproved.Value, isWithdrawalOpen = checkWithDrawalOpen, }); } } return(Ok(ListEwalletModel)); }
public string GetPayoutHistorySum(int userId) { using (SleepingPartnermanagementTestingEntities dc = new SleepingPartnermanagementTestingEntities()) { var CGP = (from a in dc.EWalletWithdrawalFunds where a.IsActive.Value == false && a.UserId == userId && a.IsApproved.Value == true && a.IsPaid.Value == true select a).ToList(); var query = CGP.Sum(x => x.AmountPayble); return(query.ToString()); } }
public IHttpActionResult ApproveSleepingPartnerContinue(int userId) { SleepingPartnermanagementTestingEntities dc = new SleepingPartnermanagementTestingEntities(); NewUserRegistration newuserdata = dc.NewUserRegistrations.Where(a => a.UserId.Equals(userId)).FirstOrDefault(); if (newuserdata != null) { newuserdata.IsSleepingPartner = true; newuserdata.UserDesignation = Common.Enum.UserAsSPorSM.SleepingPartner; dc.SaveChanges(); } return(Ok(new { success = true })); }
public string GetUserTotalDirectCommission(int userId) { //var userId = Convert.ToInt32(Session["LogedUserID"].ToString()); using (SleepingPartnermanagementTestingEntities dc = new SleepingPartnermanagementTestingEntities()) { var CGP = (from a in dc.EWalletTransactions where a.UserId.Value == userId && a.IsParentBonus.Value == true select a).ToList(); var query = CGP.Sum(x => x.Amount); return(query.ToString()); } }
public string GetEWalletThisYearWithdrawal(int userId) { //var userId = Convert.ToInt32(Session["LogedUserID"].ToString()); using (SleepingPartnermanagementTestingEntities dc = new SleepingPartnermanagementTestingEntities()) { var CGP = (from eWallTr in dc.EWalletTransactions where eWallTr.UserId == userId && eWallTr.Credit == true && eWallTr.Debit == false && eWallTr.TransactionDate.Value.Year == DateTime.Now.Year select eWallTr).ToList(); var query = CGP.Sum(x => x.Amount); return(query.ToString()); } }
public IHttpActionResult updatePassword(string passord, int uid) { SleepingPartnermanagementTestingEntities dce = new SleepingPartnermanagementTestingEntities(); NewUserRegistration newuser = dce.NewUserRegistrations.SingleOrDefault(x => x.UserId == uid); if (newuser != null) { newuser.Password = passord; dce.SaveChanges(); return(Ok(new { success = true, message = "Update Successfully" })); } return(Ok(new { success = false, message = "user not found" })); }
public IHttpActionResult FcmUpdate(FcmModel model) { SleepingPartnermanagementTestingEntities dce = new SleepingPartnermanagementTestingEntities(); NewUserRegistration newuser = dce.NewUserRegistrations.SingleOrDefault(x => x.UserId == model.UserId); if (newuser != null) { newuser.fcm = model.Fcm; dce.SaveChanges(); return(Ok(new { success = true, message = "Update Successfully" })); } return(Ok(new { success = false, message = "user not found" })); }
//[HttpGet] //[Route("ewalletpayoutconfigdetail/{userId}")] public Models.EWallet.EWalletPayoutConfigModel EWalletPayoutConfigDetail() { SleepingPartnermanagementTestingEntities db = new SleepingPartnermanagementTestingEntities(); Models.EWallet.EWalletPayoutConfigModel obj = new Models.EWallet.EWalletPayoutConfigModel(); obj = db.EWalletPayoutConfigs .Select(x => new Models.EWallet.EWalletPayoutConfigModel { TimePeriod = x.TimePeriod, MinimumPayout = x.MinimumPayout.Value, PayoutChargesPercent = x.PayoutChargesPercent.Value }).FirstOrDefault(); return(obj); }
public IHttpActionResult getNewRegistration(string Username) { try { using (SleepingPartnermanagementTestingEntities dce = new SleepingPartnermanagementTestingEntities()) { NewUserRegistration v = dce.NewUserRegistrations.Where(a => a.Username == Username).FirstOrDefault(); return(Ok(v)); } }catch (Exception e) { return(Ok(e)); } }
public IHttpActionResult addUserSetup(NewUserRegistration model) { SleepingPartnermanagementTestingEntities dce = new SleepingPartnermanagementTestingEntities(); NewUserRegistration newuser = dce.NewUserRegistrations.Where(a => a.Username.Equals(model.Username)).FirstOrDefault(); //NewUserRegistration newuser = dce.NewUserRegistrations.SingleOrDefault(x => x.Username == model.UserId); if (newuser == null) { dce.NewUserRegistrations.Add(model); dce.SaveChanges(); return(Ok(new { success = true, message = "user added" })); } return(Ok(new { success = false, message = "user not found" })); }
public IHttpActionResult GetNotificationListByUser(int userId) { SleepingPartnermanagementTestingEntities db = new SleepingPartnermanagementTestingEntities(); List <NotificationModel> List = new List <NotificationModel>(); List = db.UserNotifications.Where(a => a.UserId.Value.Equals(userId) && a.IsSaveByUser.Value.Equals(true)) .Select(x => new NotificationModel { NotificationId = x.NotificationId, NotificationName = x.NotificationName, NotificationDescription = x.NotificationDescription, IsActive = x.IsActive.Value }).ToList(); return(Ok(List)); }
public IHttpActionResult DeleteReadMessage(int Id) { try { SleepingPartnermanagementTestingEntities db = new SleepingPartnermanagementTestingEntities(); SentUserMessage sum = db.SentUserMessages.Where(x => x.Id == Id).FirstOrDefault(); db.SentUserMessages.Remove(sum); db.SaveChanges(); return(Ok(new { success = true, message = "message delete successfully" })); } catch (Exception ex) { return(Ok(new { success = true, message = "unable to delete this field", ex.Message })); } }
public IHttpActionResult DeleteInboxMsg(int Id) { try { SleepingPartnermanagementTestingEntities db = new SleepingPartnermanagementTestingEntities(); ReceiveAdminMessage vd1 = db.ReceiveAdminMessages.Where(x => x.Id == Id).FirstOrDefault <ReceiveAdminMessage>(); db.ReceiveAdminMessages.Remove(vd1); db.SaveChanges(); return(Ok(new { success = true, message = "message delete successfully" })); } catch (Exception ex) { return(Ok(new { success = true, message = "unable to delete this field", ex.Message })); } }
public IHttpActionResult ProfileSetup(ProfileSetup model, int userId) { SleepingPartnermanagementTestingEntities dc = new SleepingPartnermanagementTestingEntities(); SleepingPartnermanagementTreeTestingEntities dbTree = new SleepingPartnermanagementTreeTestingEntities(); NewUserRegistration newuser = dc.NewUserRegistrations.Where(a => a.UserId.Equals(userId)).FirstOrDefault(); if (newuser != null) { newuser.Name = model.Name; //newuser.Username = model.UserName; newuser.Password = model.Password; newuser.Country = model.Country; newuser.Address = model.Address; newuser.Phone = model.Phone; newuser.Email = model.Email; newuser.IsBlock = true; newuser.AccountTitle = model.AccountTitle; newuser.AccountNumber = model.AccountNumber; newuser.BankName = model.BankName; newuser.CNIC = model.CNICNumber; //if (userId == Common.Enum.UserType.User.ToString()) //{ // newuser.IsBlock = model.IsBlock = true; //} //else //{ // newuser.IsBlock = model.IsBlock = false; //} var fileImage1 = model.NICImage; var fileImage2 = model.ProfileImage; var fileImage3 = model.NICImage1; var fileImage4 = model.DocumentImage; if (fileImage1 != null && fileImage2 != null && fileImage3 != null && fileImage4 != null) { newuser.NICImage = fileImage1; newuser.ProfileImage = fileImage2; newuser.NICImage1 = fileImage3; newuser.DocumentImage = fileImage4; } dc.SaveChanges(); //dbTree.update_tree_name(userId, model.UserName); ModelState.Clear(); return(Ok(new { success = true, message = "Update Successfully" })); } return(Ok(new { success = true, message = "Update Successfully" })); //this.AddNotification("Your profile has bees saved", NotificationType.SUCCESS); }
public string GetEWalletCreditSum(int userId) { using (SleepingPartnermanagementTestingEntities dc = new SleepingPartnermanagementTestingEntities()) { string UserTypeUser = Common.Enum.UserType.User.ToString(); var CGP = (from a in dc.EWalletTransactions where a.Credit.Value == true && a.Debit.Value == false && a.UserId.Value == userId select a).ToList(); var query = CGP.Sum(x => x.Amount); //return query.toretu return(query.ToString()); } }
public IHttpActionResult GetSentMessages(int userId) { SleepingPartnermanagementTestingEntities db = new SleepingPartnermanagementTestingEntities(); List <SentAdminMessageModel> List = new List <SentAdminMessageModel>(); List = db.SentAdminMessages.Where(a => a.UserId == userId) .Select(x => new SentAdminMessageModel { Id = x.Id, Message = x.Message, Sender_Name = x.Sender_Name, IsRead = x.IsRead, CreateDate = x.CreateDate }).ToList(); return(Ok(List)); }
public IHttpActionResult ViewAllReadMessage(SentAdminMessageModel UMM, int userId) { SleepingPartnermanagementTestingEntities db = new SleepingPartnermanagementTestingEntities(); List <ReceiveAdminMessageModel> List = new List <ReceiveAdminMessageModel>(); List = db.ReceiveAdminMessages.OrderByDescending(id => id.Id).Where(a => a.SponserId == userId) .Select(x => new ReceiveAdminMessageModel { Id = x.Id, UserId = x.UserId, Message = x.Message, Sender_Name = x.Sender_Name, IsRead = x.IsRead, CreateDate = x.CreateDate }).ToList(); return(Ok(List)); }