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