public List <MovieRating> GetMovieRating()
{
using (var db = new XinematriXContext())
{
return(db.MovieRating.ToList());
}
}
public List <MovieGenre> GetMovieGenres()
{
using (var db = new XinematriXContext())
{
return(db.MovieGenre.ToList());
}
}
public async Task <bool> ValidToken(string tkValue)
{
if (tkValue == null || string.IsNullOrEmpty(tkValue))
{
return(false);
}
var tk = tkValue.Split(":");
var tokenCode = tk[0];
var encryptedUsername = tk[1];
var decryptedUsername = TokenHelper.Instance.Decrypt(encryptedUsername);
using (var con = new XinematriXContext())
{
var auth = await Task.Run(() => con.WebAdminAuth.Where
(p => p.WebAdminToken == tokenCode &&
p.WebAdminUsername == decryptedUsername &&
p.WebAdminTokenExpiryDate > DateTime.Now).ToList());
if (auth.Count == 0)
{
return(false);
}
else
{
return(true);
}
}
}
public List <MovieGenre> GetGenre()
{
using (var con = new XinematriXContext())
{
var all = con.MovieGenre.ToList();
return(all);
}
}
public async void ExpireToken(string tkValue)
{
var tk = tkValue.Split(":");
var tokenCode = tk[0];
using (var con = new XinematriXContext())
{
var auth = await Task.Run(() => con.WebAdminAuth.Where(p => p.WebAdminToken == tokenCode).FirstOrDefault());
auth.WebAdminTokenExpiryDate = DateTime.Now.AddMinutes(-5);
await con.SaveChangesAsync();
}
}
public async Task <bool> VerifyAdmin(string username, string cipherText)
{
using (var con = new XinematriXContext())
{
var data = await Task.Run(() => con.WebAdminAuth.Where(p => p.WebAdminUsername == username && p.WebAdminPassword == cipherText)
.Select(p => p.WebAdminAuthId).ToList());
if (data.Count != 0)
{
return(true);
}
return(false);
}
}
public async Task <string> CreateWebAccountToken(string username, string code)
{
using (var con = new XinematriXContext())
{
var data = await Task.Run(() => con.WebAdminAuth.Where(p => p.WebAdminUsername == username).FirstOrDefault());
data.WebAdminToken = code;
data.WebAdminTokenGeneratedDate = DateTime.Now;
data.WebAdminTokenExpiryDate = DateTime.Now.AddHours(1);
await con.SaveChangesAsync();
return(await Task.Run(() => con.WebAdminAuth.Where(p => p.WebAdminUsername == username &&
p.WebAdminTokenGeneratedDate == data.WebAdminTokenGeneratedDate &&
p.WebAdminTokenExpiryDate == data.WebAdminTokenExpiryDate).FirstOrDefault().WebAdminToken));
}
}
public async Task <bool> VerifyPassword(string oldpassword, string token)
{
var tk = token.Split(":");
var encryptedUsername = tk[1];
var decryptedUsername = TokenHelper.Instance.Decrypt(encryptedUsername);
var encryptedPassowrd = TokenHelper.Instance.Encrypt(oldpassword);
using (var con = new XinematriXContext())
{
var user = await Task.Run(() => con.WebAdminAuth.Where(p => p.WebAdminUsername == decryptedUsername && p.WebAdminPassword == encryptedPassowrd).FirstOrDefault());
if (user == null)
{
return(false);
}
return(true);
}
}
public async Task <bool> ChangePassword(ProfilePassword pass, string token)
{
try
{
var tk = token.Split(":");
var encryptedUsername = tk[1];
var decryptedUsername = TokenHelper.Instance.Decrypt(encryptedUsername);
var encryptedNewPassword = TokenHelper.Instance.Encrypt(pass.newpassword);
using (var con = new XinematriXContext())
{
var user = await Task.Run(() => con.WebAdminAuth.Where(p => p.WebAdminUsername == decryptedUsername).FirstOrDefault());
user.WebAdminPassword = encryptedNewPassword;
await con.SaveChangesAsync();
}
return(true);
}
catch (Exception x)
{
return(false);
}
}
