public void UpdateUsers(List<users> users)
{
DataClassesDataContext db = new DataClassesDataContext();
db.users.DeleteAllOnSubmit(db.users);
db.users.InsertAllOnSubmit(users);
db.SubmitChanges();
}
public void UpdateAllPlayers_internal(List<players> players)
{
DataClassesDataContext db = new DataClassesDataContext();
db.players.DeleteAllOnSubmit(db.players);
db.players.InsertAllOnSubmit(players);
db.SubmitChanges();
}
public string Check(string login, string pass)
{
DataClassesDataContext db = new DataClassesDataContext();
IQueryable<users> q = from user in db.users where user.name == login && user.pass == pass select user;
if (q == null || q.ToList().Count == 0)
return "invalid";
else
return q.ToList()[0].role;
}
public List<users> ListUsers(string key)
{
if (key != remoteappkey)
return new List<users>();
DataClassesDataContext db = new DataClassesDataContext();
IQueryable<users> q = from user in db.users orderby user.name select user;
return q.ToList();
}
public List<users> ListUsers(string key)
{
if (key != "8rAc1weajVfmpM07SpQAzmb/Jr3fJ1Lu9glo5OCGWN0=")
return new List<users>();
DataClassesDataContext db = new DataClassesDataContext();
IQueryable<users> q = from user in db.users orderby user.name select user;
return q.ToList();
}
public void UpdateAllPlayers_internal(string appkey, List<players> players)
{
if (appkey == Users.remoteappkey)
{
DataClassesDataContext db = new DataClassesDataContext();
db.players.DeleteAllOnSubmit(db.players);
db.players.InsertAllOnSubmit(players);
db.SubmitChanges();
}
}
public void UpdateUsers(string key, List<users> users)
{
if (key == remoteappkey)
{
DataClassesDataContext db = new DataClassesDataContext();
db.users.DeleteAllOnSubmit(db.users);
db.users.InsertAllOnSubmit(users);
db.SubmitChanges();
}
}
public string Player(int id)
{
DataClassesDataContext db = new DataClassesDataContext();
IQueryable<players> q = from player in db.players where player.Id == id orderby player.Name select player;
return new ListResponse<players>(q.ToList()).json();
}
public List<players> GetAllPlayers_internal()
{
DataClassesDataContext db = new DataClassesDataContext();
IQueryable<players> q = from player in db.players orderby player.Team, player.Name select player;
return q.ToList();
}
public string GetAllPlayersFromTeam(string team)
{
DataClassesDataContext db = new DataClassesDataContext();
IQueryable<players> q = from player in db.players where player.Team == team orderby player.Name select player;
return new ListResponse<players>(q.ToList()).json();
}
public string MatchInfo(int id)
{
DataClassesDataContext db = new DataClassesDataContext();
IQueryable<matches> q = from match in db.matches where match.Id == id select match;
if (q == null || q.Count() == 0)
return new CommonResponse(new BadRequestError("Unknown match id")).json();
return new ListResponse<matches>(q.ToList()).json();
}
public void UpdateMatches(List<matches> list)
{
DataClassesDataContext db = new DataClassesDataContext();
db.matches.DeleteAllOnSubmit(db.matches);
db.matches.InsertAllOnSubmit(list);
db.SubmitChanges();
}
public List<matches> GetAllMatches()
{
DataClassesDataContext db = new DataClassesDataContext();
IQueryable<matches> q = from match in db.matches where match.DateTime > DateTime.Now orderby match.DateTime select match;
return q.ToList();
}
public List<SingleTicket> GetAllBookings()
{
DataClassesDataContext db = new DataClassesDataContext();
IQueryable<SingleTicket> q = from ticket in db.tickets
join match in db.matches on ticket.MatchId equals match.Id
orderby ticket.BookingReference
select new SingleTicket(ticket, match);
return q.ToList();
}
public string BookTicket(int matchid, string tickettype, int quantity, string email)
{
DataClassesDataContext db = new DataClassesDataContext();
matches match = db.matches.First(i => i.Id == matchid);
if (match == null)
{
return(new CommonResponse(new BadRequestError("Invalid match id")).json());
}
Random rnd = new Random();
tickets ticket = new tickets();
ticket.BookingDate = DateTime.Now;
ticket.BookingReference = (
(match.Competitor.Replace(" ", string.Empty) + "XXXX").Substring(0, 4)
+ rnd.Next(0, 99999).ToString("D5")
+ ticket.BookingDate.ToString("ddMMyy")
).ToUpper();
ticket.MatchId = matchid;
ticket.TicketType = tickettype;
ticket.Quantity = quantity;
ticket.Email = email;
if (email != null && email.Length > 0)
{
try
{
string my_email, my_pass;
try
{
using (StreamReader file = new StreamReader(@"C:/crusaders.conf"))
{
string line = file.ReadLine();
if (line == null)
{
throw new NoException();
}
string[] words = line.Split(' ');
if (words.Length != 2)
{
throw new NoException();
}
my_email = words[0];
my_pass = words[1];
}
}
catch (FileNotFoundException e)
{
return(new CommonResponse(new InternalError(e.ToString())).json());
}
SmtpClient client = new SmtpClient();
client.UseDefaultCredentials = false;
client.Credentials = new System.Net.NetworkCredential(my_email, my_pass);
client.Port = 587;
client.Host = "smtp.office365.com";
client.DeliveryMethod = SmtpDeliveryMethod.Network;
client.EnableSsl = true;
MailMessage mail = new MailMessage();
mail.To.Add(new MailAddress(email));
mail.From = new MailAddress(my_email, "Crusaders booking system");
mail.Subject = "Crusaders match booking reference";
mail.Body = "Match date: " + match.DateTime.ToString() + ";\nBooking reference: " + ticket.BookingReference;
System.Threading.ThreadPool.QueueUserWorkItem(delegate
{
try
{
client.Send(mail);
}
catch (Exception)
{
// TODO: process exception
}
}, null);
}
catch (NoException)
{
}
catch (Exception e)
{
return(new CommonResponse(new BadRequestError("Can't send an email: " + e.ToString())).json());
}
}
db.tickets.InsertOnSubmit(ticket);
db.SubmitChanges();
return(new ListResponse <tickets>(ticket).json());
}
public void UpdateMatches(string appkey, List<matches> list)
{
if (appkey == Users.remoteappkey)
{
DataClassesDataContext db = new DataClassesDataContext();
db.matches.DeleteAllOnSubmit(db.matches);
db.matches.InsertAllOnSubmit(list);
db.SubmitChanges();
}
}
public string BookTicket(int matchid, string tickettype, int quantity, string email)
{
DataClassesDataContext db = new DataClassesDataContext();
matches match = db.matches.First(i => i.Id == matchid);
if (match == null)
return new CommonResponse(new BadRequestError("Invalid match id")).json();
Random rnd = new Random();
tickets ticket = new tickets();
ticket.BookingDate = DateTime.Now;
ticket.BookingReference = (
(match.Competitor.Replace(" ", string.Empty) + "XXXX").Substring(0, 4)
+ rnd.Next(0, 99999).ToString("D5")
+ ticket.BookingDate.ToString("ddMMyy")
).ToUpper();
ticket.MatchId = matchid;
ticket.TicketType = tickettype;
ticket.Quantity = quantity;
ticket.Email = email;
if (email != null && email.Length > 0)
{
try
{
string my_email, my_pass;
try
{
using (StreamReader file = new StreamReader(@"C:/crusaders.conf"))
{
string line = file.ReadLine();
if (line == null)
throw new NoException();
string[] words = line.Split(' ');
if (words.Length != 2)
throw new NoException();
my_email = words[0];
my_pass = words[1];
}
}
catch (FileNotFoundException e)
{
return new CommonResponse(new InternalError(e.ToString())).json();
}
SmtpClient client = new SmtpClient();
client.UseDefaultCredentials = false;
client.Credentials = new System.Net.NetworkCredential(my_email, my_pass);
client.Port = 587;
client.Host = "smtp.office365.com";
client.DeliveryMethod = SmtpDeliveryMethod.Network;
client.EnableSsl = true;
MailMessage mail = new MailMessage();
mail.To.Add(new MailAddress(email));
mail.From = new MailAddress(my_email, "Crusaders booking system");
mail.Subject = "Crusaders match booking reference";
mail.Body = "Match date: " + match.DateTime.ToString() + ";\nBooking reference: " + ticket.BookingReference;
System.Threading.ThreadPool.QueueUserWorkItem(delegate
{
try
{
client.Send(mail);
}
catch (Exception)
{
// TODO: process exception
}
}, null);
}
catch (NoException)
{
}
catch (Exception e)
{
return new CommonResponse(new BadRequestError("Can't send an email: " + e.ToString())).json();
}
}
db.tickets.InsertOnSubmit(ticket);
db.SubmitChanges();
return new ListResponse<tickets>(ticket).json();
}
public List<SingleTicket> GetAllBookings(string appkey)
{
if (appkey != Users.remoteappkey)
return new List<SingleTicket>();
DataClassesDataContext db = new DataClassesDataContext();
IQueryable<SingleTicket> q = from ticket in db.tickets
join match in db.matches on ticket.MatchId equals match.Id
orderby ticket.BookingReference
select new SingleTicket(ticket, match);
return q.ToList();
}
