public void AddFile(Image image)
{
using (var dc = new CheckingContext(_connectionString))
{
dc.Images.Add(image);
dc.SaveChanges();
}
}
public Order UpdateOrder(Order order, Questionnaire q)
{
using (CheckingContext db = new CheckingContext(_connectionString))
{
Order o = db.Orders.Find(order.OrderID);
o.Questionnaire = q;
db.SaveChanges();
}
return(order);
}
public int CreateOrder(Order o)
{
using (CheckingContext db = new CheckingContext(_connectionString))
{
db.Orders.Add(o);
db.SaveChanges();
}
return(o.OrderID);
}
public Order GetOrder(int orderId)
{
Order o = null;
using (CheckingContext db = new CheckingContext(_connectionString))
{
o = db.Orders.Find(orderId);
var email = o.User.UserName;
}
return(o);
}
public bool HasPendingOrder(int userID)
{
using (var dc = new CheckingContext(_connectionString))
{
var user = dc.Users.Find(userID);
if (user == null)
{
return(false);
}
return(user.Orders.Count == 0 ? false: user.Orders.Last().OrderStatus != OrderStatus.Paid);
}
}
public User GetUser(string username, string password)
{
using (var dc = new CheckingContext(_connectionString))
{
var user = dc.Users.FirstOrDefault(a => a.UserName == username);
if (user == null)
{
return(null);
}
bool success = PasswordHelper.PasswordMatch(password, user.PasswordHash, user.Salt);
return(success ? user : null);
}
}
public void AddUser(string username, string password)
{
User user = new User();
string salt = PasswordHelper.GenerateRandomSalt();
string passwordHash = PasswordHelper.HashPassword(password, salt);
user.PasswordHash = passwordHash;
user.Salt = salt;
user.UserName = username;
user.Role = Role.Admin;
using (var dc = new CheckingContext(_connectionString))
{
dc.Users.Add(user);
dc.SaveChanges();
}
}
public List <string> GetImagePaths(int orderId)
{
List <string> paths = new List <string>();
using (CheckingContext db = new CheckingContext(_connectionString))
{
Order order = db.Orders.Find(orderId);
foreach (var i in order.Images)
{
string s = Path.GetFullPath(i.FileName);
paths.Add(s);
// FileStream stream = new FileStream(s, FileMode.Open);
}
}
return(paths);
}