public RentalItemDto GetRentalItemById(int id) { DVDRentalEntities db = new DVDRentalEntities(); var ri = db.RentalItems.FirstOrDefault(x => x.ID == id); return new RentalItemDto { ID = ri.ID.ToString(), Name = ri.Name, Price = ri.Price.ToString(), Type = ri.Type.ToString() }; }
public NotificationDto GetNotificationById(int id) { DVDRentalEntities db = new DVDRentalEntities(); var n = db.Notifications.FirstOrDefault(x => x.ID == id); return new NotificationDto { ID = n.ID.ToString(), Date = n.Date.ToString(), CustomerID = n.CustomerID.ToString() }; }
public void updateBalance(int customerID, int rentalID) { DVDRentalEntities db = new DVDRentalEntities(); var customer = db.Users.FirstOrDefault(x => x.ID == customerID); customer.Balance += Convert.ToDecimal(new RentalItemBLL().GetRentalItemById(rentalID).Price); db.SaveChanges(); }
//Add notifications that use the getUserFines method in the user class. public void AddNotification(int cid) { var db = new DVDRentalEntities(); var n = new Notification { Date = DateTime.Now, CustomerID = cid, }; db.Notifications.Add(n); db.SaveChanges(); }
//Add a sale into the database. public void AddSales(int rid,int cid,int eid) { var db = new DVDRentalEntities(); var s = new Sale { Date= DateTime.Now, RentalItemID=rid, CustomerID=cid, EmployeeID=eid, }; db.Sales.Add(s); db.SaveChanges(); }
public List<NotificationDto> GetAllNotificationsByDate(string date) { DVDRentalEntities db = new DVDRentalEntities(); List<NotificationDto> LRI = new List<NotificationDto>(); DateTime dtstring = Convert.ToDateTime(date); foreach (var n in db.Notifications.Where(x => x.Date == dtstring)) { LRI.Add(new NotificationDto { ID = n.ID.ToString(), Date = n.Date.ToString(), CustomerID = n.CustomerID.ToString(), }); } return LRI; }
public List<NotificationDto> GetAllNotifications() { DVDRentalEntities db = new DVDRentalEntities(); List<NotificationDto> LRI = new List<NotificationDto>(); foreach (var n in db.Notifications) { LRI.Add(new NotificationDto { ID = n.ID.ToString(), Date = n.Date.ToString("dd MMM yyyy H:mm"), CustomerID = n.CustomerID.ToString(), FName = n.User.Name + " " + n.User.Surname, }); } return LRI; }
public List<RentalItemDto> GetAllRentalItemsByType(string type) { DVDRentalEntities db = new DVDRentalEntities(); List<RentalItemDto> LRI = new List<RentalItemDto>(); foreach (var ri in db.RentalItems.Where( x => x.Type == type)) { LRI.Add(new RentalItemDto { ID = ri.ID.ToString(), Name = ri.Name, Type = ri.Type, Price = ri.Price.ToString() }); } return LRI; }
public UserDto getCustomer(int id) { DVDRentalEntities db = new DVDRentalEntities(); var c = db.Users.FirstOrDefault(x => x.Role.Equals("Customer", StringComparison.InvariantCultureIgnoreCase) && x.ID == id); var customer = new UserDto() { Name = c.Name, Surname = c.Surname, IDNumber = c.IDNumber, Address = c.Address, ContactNumber = c.ContactNumber, Email = c.Email, Balance = c.Balance.ToString(), Fine = c.Fine.ToString(), Username = c.Username }; return customer; }
public void AddUser(string name, string surname, string idnumber, string address, string contactNumber, string email, string role, string username, string password) { DVDRentalEntities db = new DVDRentalEntities(); string hashPass = new HashBLL().CreateHash(password); User u = new User { Name = name, Surname = surname, IDNumber = idnumber, Address = address, ContactNumber = contactNumber, Email = email, Role = role, Username = username, Password = hashPass }; db.Users.Add(u); db.SaveChanges(); }
public List<UserDto> getAllClerks() { DVDRentalEntities db = new DVDRentalEntities(); var customers = db.Users.Where(x => x.Role.Equals(x.Role.Equals("Clerk", StringComparison.InvariantCultureIgnoreCase))); List<UserDto> LU = new List<UserDto>(); foreach (var c in customers) { LU.Add(new UserDto { Name = c.Name, Surname = c.Surname, IDNumber = c.IDNumber, Address = c.Address, ContactNumber = c.ContactNumber, Email = c.Email, Balance = c.Balance.ToString(), Fine = c.Fine.ToString(), Username = c.Username }); } return LU; }
//Get user fines for sending notifications page.Fines with a balance more then 0 public List<UserDto> getUserFines() { DVDRentalEntities db = new DVDRentalEntities(); var fines = db.Users.Where(x => x.Fine > 0); List<UserDto> FU = new List<UserDto>(); foreach (var f in fines) { FU.Add(new UserDto { ID=f.ID.ToString(), Name = f.Name, Surname = f.Surname, IDNumber = f.IDNumber, Address = f.Address, ContactNumber = f.ContactNumber, Email = f.Email, Balance=f.Balance.ToString(), Fine = f.Fine.ToString(), }); } return FU; }
public UserDto getUserCredentials(string username) { DVDRentalEntities db = new DVDRentalEntities(); var u = db.Users.FirstOrDefault(x => x.Username.Equals(username, StringComparison.InvariantCultureIgnoreCase)); if (u != null) { return new UserDto() { ID = u.ID.ToString(), Username = u.Username, Password = u.Password, Role = u.Role }; } else return null; }