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