public List <RewardDataContract> GetActiveRewardsFromCompany(int companyID) { DateTime now = DateTime.Now.Date; List <RewardDataContract> rewards = new List <RewardDataContract>(); using (var loyalkeyDB = new LoyalKeyDB.LoyalKeyDBEntities()) { var rewardsDB = loyalkeyDB.Rewards.Where(r => r.CompanyID == companyID && now >= r.StartDate && now < r.EndDate); foreach (LoyalKeyDB.Reward r in rewardsDB) { RewardDataContract rdc = new RewardDataContract(); rdc.RewardID = r.RewardID; rdc.CompanyID = r.CompanyID; rdc.RewardTypeID = r.RewardTypeID; rdc.StartDate = r.StartDate; rdc.EndDate = r.EndDate; rewards.Add(rdc); } } return(rewards); }
public UserDataContract GetActiveUser(int userID) { UserDataContract user = new UserDataContract(); using (var loyalkeyDB = new LoyalKeyDB.LoyalKeyDBEntities()) { try { LoyalKeyDB.User userDB = loyalkeyDB.Users.Where(u => u.UserID == userID && u.IsActive == true).FirstOrDefault(); user.UserID = userDB.UserID; user.CompanyID = userDB.CompanyID == null ? -1 : userDB.CompanyID.Value; user.BassCode = userDB.BassCode; user.Identifier = userDB.Identifier; user.IsActive = userDB.IsActive; } catch { user.UserID = -1; user.CompanyID = -1; user.BassCode = -1; user.Identifier = ""; user.IsActive = false; } } return(user); }
public string AddUser(string identifier, int?companyID) { try { using (var loyalkeyDB = new LoyalKeyDB.LoyalKeyDBEntities()) { LoyalKeyDB.User user = new LoyalKeyDB.User(); user.CompanyID = companyID; user.Identifier = identifier; user.IsActive = true; //Create a random 5 digit number as a basscode Random generator = new Random(); int r = generator.Next(10000, 100000); user.BassCode = r; loyalkeyDB.Users.Add(user); loyalkeyDB.SaveChanges(); } return("success"); } catch (Exception e) { return("Failed to add user"); } }
public CompanyDataContract GetCompanyDetail(int companyID) { CompanyDataContract company = new CompanyDataContract(); using (var loyalkeyDB = new LoyalKeyDB.LoyalKeyDBEntities()) { try { LoyalKeyDB.Company companyDB = loyalkeyDB.Companies.Find(companyID); company.CompanyID = companyDB.CompanyID; company.Name = companyDB.CompanyName; company.Postcode = companyDB.PostCode; company.Deleted = companyDB.Deleted; } catch { company.CompanyID = -1; company.Name = ""; company.Postcode = ""; company.Deleted = false; } } return(company); }
public string GetCompanyName(int companyID) { string companyName = ""; try { using (LoyalKeyDB.LoyalKeyDBEntities loyalkeyDB = new LoyalKeyDB.LoyalKeyDBEntities()) { LoyalKeyDB.Company company = loyalkeyDB.Companies.Find(companyID); companyName = company.CompanyName; } } catch { companyName = "Error obtaining Company Name"; } return(companyName); }
public List <CompanyDataContract> GetAllCompanies() { List <CompanyDataContract> allCompanies = new List <CompanyDataContract>(); using (var loyalkeyDB = new LoyalKeyDB.LoyalKeyDBEntities()) { var companiesDB = loyalkeyDB.Companies.Where(c => c.Deleted == false); foreach (LoyalKeyDB.Company companyDB in companiesDB) { CompanyDataContract cdc = new CompanyDataContract(); cdc.CompanyID = companyDB.CompanyID; cdc.Name = companyDB.CompanyName; cdc.Postcode = companyDB.PostCode; cdc.Deleted = cdc.Deleted; allCompanies.Add(cdc); } } return(allCompanies); }
public List <RewardDescriptionDataContract> GetRewardDescriptionsFromReward(int rewardID) { DateTime now = DateTime.Now.Date; List <RewardDescriptionDataContract> descriptions = new List <RewardDescriptionDataContract>(); using (var loyalkeyDB = new LoyalKeyDB.LoyalKeyDBEntities()) { var query = loyalkeyDB.RewardDescriptions.Where(r => r.RewardID == rewardID); foreach (LoyalKeyDB.RewardDescription r in query) { RewardDescriptionDataContract rdc = new RewardDescriptionDataContract(); rdc.RewardDescriptionID = r.RewardDescriptionID; rdc.RewardID = r.RewardID; rdc.Description = r.Description; rdc.Value = r.Value; rdc.StartDate = r.StartDate; rdc.EndDate = r.EndDate; descriptions.Add(rdc); } } return(descriptions); }