bool execute(string email, string password)
{
using (var context = new RmaEntities()) {
var isCorrectData = context.User.FirstOrDefault(u => u.Email == email && u.Password == password);
return(isCorrectData != null);
}
}
public void SaveToDb()
{
using (var context = new RmaEntities()) {
context.Email.Add(_emailMessage);
context.SaveChanges();
}
}
public override void CreateRole(string roleName)
{
using (var context = new RmaEntities()) {
context.Role.Add(new Role {
Name = roleName
});
}
}
int CreateBankAccount(BankAccount bankAccount)
{
using (var context = new RmaEntities()) {
var addedBankAccount = context.BankAccount.Add(bankAccount);
context.SaveChanges();
return(addedBankAccount.Id);
}
}
int CreateAddress(Adress address)
{
using (var context = new RmaEntities()) {
var addedAddress = context.Adress.Add(address);
context.SaveChanges();
return(addedAddress.Id);
}
}
public ActionResult MessageHistory(int applicationId, string clientEMail)
{
var context = new RmaEntities();
var emails = context.Email.Where(e => e.Application_Id == applicationId).ToList();
var model = new EmailsViewModel(emails, clientEMail, applicationId);
return(View(model));
}
void CreateCode(Application application)
{
int newId;
using (var context = new RmaEntities()) {
newId = context.Application.Max(u => u.Id);
}
application.Name = $"{newId + 1}/{DateTime.Today.Month}/{DateTime.Today.Year}";
}
public void filtr_app_by_status()
{
var context = new RmaEntities();
var application =
context.Application.Include(a => a.AppType).Include(a => a.User).Include(a => a.User1).Include(a => a.Product).Include(a => a.Realization).Include(a => a.Result).Include(a => a.Statue);
var result = excecute(application);
Assert.True(result > 0);
}
void SetStatus(Application application)
{
using (var context = new RmaEntities()) {
var statusName = Statue.StatusDictionary[EStatue.NotConfirmed];
var statue = context.Statue.FirstOrDefault(s => s.Name == statusName);
if (statue != null)
{
application.Statue_Id = statue.Id;
}
}
}
int AddNewBank(RegisterUserViewModel model)
{
using (var context = new RmaEntities()) {
var newBank = new BankAccount {
Name = model.BankName,
AccountNumber = model.AccountNumber
};
context.BankAccount.Add(newBank);
context.SaveChanges();
return(newBank.Id);
}
}
int AddNewAddress(RegisterUserViewModel model)
{
using (var context = new RmaEntities()) {
var newAddress = new Adress {
City = model.City,
Street = model.Street,
ZipCode = model.ZipCode
};
context.Adress.Add(newAddress);
context.SaveChanges();
return(newAddress.Id);
}
}
public ActionResult ConfirmEmail(string token, string email)
{
using (var context = new RmaEntities()) {
var userId = int.Parse(HashHelper.Decrypt(token, email));
var user = context.User.FirstOrDefault(u => u.Id == userId && u.Email == email);
if (user == null)
{
return(null);
}
user.EmailConfirmed = true;
context.Entry(user).Property(p => p.EmailConfirmed).IsModified = true;
context.SaveChanges();
return(RedirectToAction("Index"));
}
}
public ActionResult EditDate(int?userId)
{
if (userId == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
var context = new RmaEntities();
var user = context.User.Find(userId);
if (user == null)
{
return(HttpNotFound());
}
return(View(user));
}
bool ChangeValues(User user, Adress address, BankAccount bankAccount)
{
using (var context = new RmaEntities()) {
var oldUser = context.User.Find(user.Id);
if (oldUser != null)
{
if (context.User.Any(m => m.Email == user.Email && m.Id != user.Id))
{
ModelState.AddModelError("", "Podany e-mail już istnieje!");
return(false);
}
ChangeValues(user, address, bankAccount, oldUser);
}
context.SaveChanges();
return(true);
}
}
void AddNewUser(RegisterUserViewModel model, int addressId, int bankId)
{
using (var context = new RmaEntities()) {
var newUser = new User {
FirstName = model.FirstName,
LastName = model.LastName,
Email = model.Email,
Password = model.Password,
Phone = model.Phone,
Adress_Id = addressId,
BankAccount_Id = bankId,
Role_Id = context.Role.First(r => r.Name == "Klient").Id
};
context.User.Add(newUser);
context.SaveChanges();
model.Id = newUser.Id;
}
}
void SetupFormsAuthTicket(string email, bool persistanceFlag)
{
User user;
using (var context = new RmaEntities()) {
user = context.User.FirstOrDefault(u => u.Email == email);
}
var userId = user.Id;
var userData = userId.ToString(CultureInfo.InvariantCulture);
var authTicket = new FormsAuthenticationTicket(1,
user.Email,
DateTime.Now,
DateTime.Now.AddMinutes(30),
persistanceFlag,
userData);
var encTicket = FormsAuthentication.Encrypt(authTicket);
Response.Cookies.Add(new HttpCookie(FormsAuthentication.FormsCookieName, encTicket));
}
public override string[] GetAllRoles()
{
using (var context = new RmaEntities()) {
return(context.Role.Select(r => r.Name).ToArray());
}
}
User GetUser(string email)
{
var context = new RmaEntities();
return(context.User.FirstOrDefault(u => u.Email == email));
}
static bool IsEmailNotUnique(string newEmail)
{
using (var context = new RmaEntities()) {
return(context.User.Any(u => u.Email == newEmail));
}
}
