public QuizTaking Get(int id)
{
using (var context = new QuizAppEntities())
{
return(context.QuizTakings.FirstOrDefault(o => o.Id == id));
}
}
public IEnumerable <QuizTaking> GetAll()
{
using (var context = new QuizAppEntities())
{
return(context.QuizTakings.ToList());
}
}
public bool AddOTP(ForgotPasswordBindingModel model)
{
var mobile = entities.AspNetUsers.Where(x => x.PhoneNumber == model.PhoneNumber).FirstOrDefault();
if (mobile != null)
{
using (QuizAppEntities entities = new QuizAppEntities())
{
var OTP = GeneralFunctions.GetOTP();
MobileOTP mobileOTP = new MobileOTP()
{
PhoneNumber = model.PhoneNumber,
OTP = OTP,
CreatedDate = DateTime.UtcNow.AddHours(5.00).AddMinutes(30.00),
};
entities.MobileOTPs.Add(mobileOTP);
var OtpSend = sms_api_callAsync(model.PhoneNumber, OTP.ToString());
return(entities.SaveChanges() > 0);
}
}
else
{
return(false);
}
}
public QuizItemQuestionAnswer Get(int id)
{
using (var context = new QuizAppEntities())
{
return(context.QuizItemQuestionAnswers.FirstOrDefault(o => o.Id == id));
}
}
public RSSFeedDesc RssFilterData(string RSSURL, string Title)
{
var rssFeed = XDocument.Load(RSSURL);
var data = rssFeed;
var rssFeedOut = (from item in rssFeed.Descendants("item")
where
((string)item.Element("title")).Trim() == Title.Trim()
select new RSSFeedDesc
{
Title = ((string)item.Element("title")),
Description = ((string)item.Element("description")),
}).FirstOrDefault();
if (rssFeedOut != null)
{
QuizAppEntities entities = new QuizAppEntities();
FilterWord filterWord = new FilterWord();
string temp = rssFeedOut.Description;
string findString = "Download Dainik Bhaskar App to read Latest Hindi News Today";
string filteredData = "";
if (temp.Contains(findString))
{
filteredData = temp.Replace(findString, "");
}
rssFeedOut.Description = filteredData;
return(rssFeedOut);
}
else
{
return(null);
}
}
public IEnumerable <QuizItemQuestionAnswer> GetAll()
{
using (var context = new QuizAppEntities())
{
return(context.QuizItemQuestionAnswers.ToList());
}
}
public bool ValidateReferalCode(string usedReferalCode, string Username)
{
using (QuizAppEntities entities = new QuizAppEntities())
{
var user = entities.Users.Where(x => x.ReferalCode == usedReferalCode && x.AspNetUser.UserName != Username).FirstOrDefault();
return(user == null);
}
}
public void Add(QuizItemQuestionAnswer model)
{
using (var context = new QuizAppEntities())
{
context.QuizItemQuestionAnswers.Add(model);
context.SaveChanges();
}
}
public int Add(QuizTaking model)
{
using (var context = new QuizAppEntities())
{
context.QuizTakings.Add(model);
context.SaveChanges();
return(model.Id);
}
}
public int Add(QuizItemQuestion model)
{
using (var context = new QuizAppEntities())
{
context.QuizItemQuestions.Add(model);
context.SaveChanges();
return(model.Id);
}
}
public void Delete(int id)
{
using (var context = new QuizAppEntities())
{
var existingEntity = context.QuizItemQuestionAnswers.FirstOrDefault(o => o.Id == id);
if (existingEntity != null)
{
context.QuizItemQuestionAnswers.Remove(existingEntity);
context.SaveChanges();
}
}
}
public void Update(QuizItemQuestion model)
{
using (var context = new QuizAppEntities())
{
var existingEntity = context.QuizItemQuestions.FirstOrDefault(o => o.Id == model.Id);
if (existingEntity == null)
{
return;
}
context.Entry(existingEntity).CurrentValues.SetValues(model);
context.SaveChanges();
}
}
public bool OTPVerification(OTPVerificationBindingModel model)
{
using (QuizAppEntities entities = new QuizAppEntities())
{
var userInfo = entities.MobileOTPs.Where(x => x.PhoneNumber == model.PhoneNumber && x.OTP == model.OTP).OrderByDescending(a => a.CreatedDate).FirstOrDefault();
if (userInfo != null && userInfo.OTP == model.OTP)
{
return(true);
}
else
{
return(false);
}
}
}
public static string GetReferalCode()
{
Random rnd = new Random();
int length = random.Next(6, 6);
string referalCode = RandomString(length);
using (QuizAppEntities entities = new QuizAppEntities())
{
var isExistReferalCode = entities.Users.Where(x => x.ReferalCode == referalCode).FirstOrDefault();
if (isExistReferalCode != null)
{
referalCode = GetReferalCode();
}
}
return(referalCode);
}
public bool UpdatePassword(string UserId, string Password)
{
using (QuizAppEntities model = new QuizAppEntities())
{
var userInfo = model.Users.Where(x => x.UserID == UserId).FirstOrDefault();
if (userInfo != null)
{
userInfo.Password = Password;
userInfo.LastUpdateDate = DateTime.UtcNow.AddHours(5.00).AddMinutes(30.00);
model.Entry(userInfo).State = EntityState.Modified;
return(model.SaveChanges() > 0);
}
else
{
return(false);
}
}
}
public string GetParentsIDsFromReferalCode(string usedReferalCode, string userId)
{
string RefCode = "";
using (QuizAppEntities entities = new QuizAppEntities())
{
var user = entities.Users.Where(x => x.ReferalCode == usedReferalCode && x.UserID != userId).FirstOrDefault();
if (user != null)
{
if (!string.IsNullOrEmpty(user.ParentIDs))
{
RefCode = user.UserID + "," + user.ParentIDs;
RefCode = UpdateParentIDsFromReferalCode(RefCode);
}
else
{
RefCode = user.UserID;
}
}
}
return(RefCode);
}
public TokenResult RegisterUser(RegisterBindingModel model)
{
try
{
var Otp = GeneralFunctions.GetOTP();
//Set By Defaulte Admin Refferal Code When User Not Use Any Refferal Code
if (model.UsedReferalCode == null || model.UsedReferalCode == "" || model.UsedReferalCode == string.Empty)
{
string AdminId = ConfigurationManager.AppSettings["Admin"].ToString();
model.UsedReferalCode = ConfigurationManager.AppSettings["RefferalCode"].ToString();
}
var ParentIDs = GetParentsIDsFromReferalCode(model.UsedReferalCode, model.UserId);
using (QuizAppEntities entities = new QuizAppEntities())
{
User registerUser = new User()
{
Name = model.Name,
Password = model.Password,
UserID = model.UserId,
CreatedDate = DateTime.UtcNow.AddHours(5.00).AddMinutes(30.00),
LastUpdateDate = DateTime.UtcNow.AddHours(5.00).AddMinutes(30.00),
ReferalCode = GeneralFunctions.GetReferalCode(),
DeviceID = model.DeviceID,
IP = model.IP,
isActive = true,
isBlocked = false,
NotificationKey = model.NotificationKey,
otp = Otp.ToString(),
ParentIDs = ParentIDs,
Platform = model.Platform,
UsedReferalCode = model.UsedReferalCode.ToLower(),
};
var OtpSend = sms_api_callAsync(model.PhoneNumber, Otp.ToString());
MobileOTP mobileOTP = new MobileOTP()
{
PhoneNumber = model.PhoneNumber,
OTP = Otp,
CreatedDate = DateTime.UtcNow.AddHours(5.00).AddMinutes(30.00)
};
entities.MobileOTPs.Add(mobileOTP);
entities.Users.Add(registerUser);
int updatedRow = entities.SaveChanges();
var UserId = registerUser.UserID;
if (updatedRow >= 1)
{
//Add Registration Income
var jsonFilePath = HttpContext.Current.Server.MapPath("~/Models/JsonFile/LevelEarningMasterUser.json");
EaningHeadModel earningHeads = new EaningHeadModel();
using (StreamReader r = new StreamReader(jsonFilePath))
{
string json = r.ReadToEnd();
earningHeads = JsonConvert.DeserializeObject <EaningHeadModel>(json);
}
var data = (from U in entities.Users
join A in entities.AspNetUsers on U.UserID equals A.Id where U.UserID == UserId
select new UserTransactionModel()
{
UserName = U.Name,
MobileNumber = A.UserName
}).FirstOrDefault();
var uniqueKey = $"{UserId}~{DateTime.UtcNow.AddHours(5.00).AddMinutes(30.00).ToString("dd-MM-yyy")}~Earning";
Transaction transaction = new Transaction()
{
UserID = UserId,
transactionDateTime = DateTime.UtcNow.AddHours(5.00).AddMinutes(30.00),
UniqueKey = uniqueKey,
paymentStatus = "Earning",
amount = earningHeads.RegistrationIncome,
comment = "Registration Income Amount",
username = data.UserName,
mobilenumber = data.MobileNumber
};
entities.Transactions.Add(transaction);
entities.SaveChanges();
AuthRepository authRepository = new AuthRepository();
return(authRepository.GenerateToken(model.PhoneNumber, model.Password, model.UserId, ""));
}
else
{
TokenResult result = new TokenResult();
result.result = false;
result.error_message = "User registration failed.";
return(result);
}
}
}
catch (Exception ex)
{
TokenResult result = new TokenResult();
result.result = false;
result.error_message = ex.Message;
return(result);
}
}
public AuthRepository()
{
_ctx = new QuizAppEntities();
}
