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