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