Ejemplo n.º 1
0
        public IHttpActionResult GetMessages(int id)
        {
            IEnumerable <string> headerValues = Request.Headers.GetValues("Authorization");
            string installKey = headerValues.FirstOrDefault();

            if (installKey == "")
            {
                return(ResponseMessage(Models.Errors.InstallKeyBlank(Request)));
            }

            try
            {
                Models.Installs.checkinInstall(installKey);
            }
            catch (Exception ex)
            {
                return(ResponseMessage(Models.Errors.InstallCheckinFailed(Request)));
            }

            List <MednaNetAPIClient.Models.Messages> messages = null;

            try
            {
                using (Models.MedLaunchChatEntities db = new Models.MedLaunchChatEntities())
                {
                    var install = (from q in db.installs
                                   where q.code == installKey
                                   select q).FirstOrDefault();

                    if (install != null)
                    {
                        //var m = from q in db.groups
                        //     where q.id == id && q.group_members.Select(b => b.install_id).Contains(install.id)
                        //    select q.messages;

                        messages =
                            (from g in db.groups
                             from m in g.messages
                             from gm in g.group_members
                             where gm.install_id == install.id && g.id == id
                             select new MednaNetAPIClient.Models.Messages()
                        {
                            channel = g.id,
                            code = m.code,
                            message = m.message1,
                            name = m.name,
                            postedOn = m.posted_on
                        }).ToList();
                    }
                }
            }
            catch (Exception ex)
            {
                HttpError err = new HttpError("Error retrieving messages for group. ");
                return(ResponseMessage(Request.CreateResponse(HttpStatusCode.InternalServerError, err)));
            }

            return(Ok(messages.ToList()));
        }
Ejemplo n.º 2
0
        public IHttpActionResult GetChannelLastMessages(int id)
        {
            IEnumerable <string> headerValues = Request.Headers.GetValues("Authorization");
            string installKey = headerValues.FirstOrDefault();

            if (installKey == "")
            {
                return(ResponseMessage(Models.Errors.InstallKeyBlank(Request)));
            }

            try
            {
                Models.Installs.checkinInstall(installKey);
            }
            catch (Exception ex)
            {
                return(ResponseMessage(Models.Errors.InstallCheckinFailed(Request)));
            }


            MednaNetAPIClient.Models.Messages message = null;

            try
            {
                using (Models.MedLaunchChatEntities db = new Models.MedLaunchChatEntities())
                {
                    var install = (from q in db.installs
                                   where q.code == installKey
                                   select q).FirstOrDefault();

                    if (install != null)
                    {
                        message =
                            (from g in db.discord_channels
                             from m in g.discord_messages
                             where !m.clients_ignore && m.channel == id
                             orderby m.id descending
                             select new MednaNetAPIClient.Models.Messages()
                        {
                            channel = g.id,
                            code = m.code,
                            message = m.message,
                            name = m.name,
                            postedOn = m.posted_on,
                            id = m.id
                        }).FirstOrDefault();
                    }
                }
            }
            catch (Exception ex)
            {
                HttpError err = new HttpError("Error retrieving last message for discord channel. ");
                return(ResponseMessage(Request.CreateResponse(HttpStatusCode.InternalServerError, err)));
            }

            return(Ok(message));
        }
Ejemplo n.º 3
0
        public IHttpActionResult GetOnlineUsers()
        {
            IEnumerable <string> headerValues = Request.Headers.GetValues("Authorization");
            string installKey = headerValues.FirstOrDefault();

            if (installKey == "")
            {
                return(ResponseMessage(Models.Errors.InstallKeyBlank(Request)));
            }

            try
            {
                Models.Installs.checkinInstall(installKey);
            }
            catch (Exception ex)
            {
                return(ResponseMessage(Models.Errors.InstallCheckinFailed(Request)));
            }

            List <MednaNetAPIClient.Models.Users> users = null;

            try
            {
                using (Models.MedLaunchChatEntities db = new Models.MedLaunchChatEntities())
                {
                    var install = (from q in db.installs
                                   where q.code == installKey
                                   select q).FirstOrDefault();

                    if (install != null)
                    {
                        users = (from q in db.discord_users
                                 where q.is_online == true

                                 select new MednaNetAPIClient.Models.Users()
                        {
                            discordId = q.user_discord_id,
                            id = q.id,
                            username = q.username
                        }).ToList();
                    }
                }
            }
            catch (Exception ex)
            {
                HttpError err = new HttpError("Error retrieving discord users.");
                return(ResponseMessage(Request.CreateResponse(HttpStatusCode.InternalServerError, err)));
            }



            return(Ok(users));
        }
Ejemplo n.º 4
0
        public IHttpActionResult GetGroups()
        {
            IEnumerable <string> headerValues = Request.Headers.GetValues("Authorization");
            string installKey = headerValues.FirstOrDefault();

            if (installKey == "")
            {
                return(ResponseMessage(Models.Errors.InstallKeyBlank(Request)));
            }

            try
            {
                Models.Installs.checkinInstall(installKey);
            }
            catch (Exception ex)
            {
                return(ResponseMessage(Models.Errors.InstallCheckinFailed(Request)));
            }

            List <MednaNetAPIClient.Models.Groups> groups = null;

            try
            {
                using (Models.MedLaunchChatEntities db = new Models.MedLaunchChatEntities())
                {
                    var install = (from q in db.installs
                                   where q.code == installKey
                                   select q).FirstOrDefault();

                    if (install != null)
                    {
                        groups = (from q in db.group_members
                                  where q.install_id == install.id
                                  select new MednaNetAPIClient.Models.Groups()
                        {
                            groupDescription = [email protected]_description,
                            groupName = [email protected]_name,
                            groupOwner = [email protected]_owner,
                            id = q.id
                        }).ToList();
                    }
                }
            }
            catch (Exception ex)
            {
                HttpError err = new HttpError("Error retrieving groups. ");
                return(ResponseMessage(Request.CreateResponse(HttpStatusCode.InternalServerError, err)));
            }


            return(Ok(groups.ToList()));
        }
Ejemplo n.º 5
0
        public static void checkinInstall(string installKey)
        {
            using (Models.MedLaunchChatEntities db = new Models.MedLaunchChatEntities())
            {
                var install = (from q in db.installs
                               where q.code == installKey
                               select q).FirstOrDefault();

                install.last_checkin = DateTime.Now;

                db.SaveChanges();
            }
        }
Ejemplo n.º 6
0
        public IHttpActionResult AddDiscordUser(List <MednaNetAPIClient.Models.Users> users)
        {
            IEnumerable <string> headerValues = Request.Headers.GetValues("Authorization");
            string installKey = headerValues.FirstOrDefault();

            if (installKey == "")
            {
                return(ResponseMessage(Models.Errors.InstallKeyBlank(Request)));
            }

            try
            {
                Models.Installs.checkinInstall(installKey);
            }
            catch (Exception ex)
            {
                return(ResponseMessage(Models.Errors.InstallCheckinFailed(Request)));
            }

            try
            {
                if (installKey == "botInstallKey")
                {
                    using (Models.MedLaunchChatEntities db = new Models.MedLaunchChatEntities())
                    {
                        //Delete all users in table
                        db.Database.ExecuteSqlCommand("TRUNCATE TABLE [discord_users]");

                        foreach (var user in users)
                        {
                            var u = new Models.discord_users();

                            u.is_online       = user.isOnline;
                            u.username        = user.username;
                            u.user_discord_id = user.discordId;

                            db.discord_users.Add(u);
                            db.SaveChanges();
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                HttpError err = new HttpError("Error adding discord user.");
                return(ResponseMessage(Request.CreateResponse(HttpStatusCode.InternalServerError, err)));
            }

            return(Ok());
        }
Ejemplo n.º 7
0
        public IHttpActionResult GetInstall()
        {
            IEnumerable <string> headerValues = Request.Headers.GetValues("Authorization");
            string installKey = headerValues.FirstOrDefault();

            if (installKey == "")
            {
                return(ResponseMessage(Models.Errors.InstallKeyBlank(Request)));
            }

            try
            {
                Models.Installs.checkinInstall(installKey);
            }
            catch (Exception ex)
            {
                return(ResponseMessage(Models.Errors.InstallCheckinFailed(Request)));
            }

            MednaNetAPIClient.Models.Installs install = null;

            try
            {
                using (Models.MedLaunchChatEntities db = new Models.MedLaunchChatEntities())
                {
                    install = (from q in db.installs
                               where q.code == installKey
                               select new MednaNetAPIClient.Models.Installs()
                    {
                        id = q.id,
                        banned = q.banned,
                        code = q.code,
                        lastCheckin = q.last_checkin,
                        registeredOn = q.registered_on,
                        tempBan = q.temp_ban,
                        tempBanEnd = q.temp_ban_end,
                        username = q.username
                    }).FirstOrDefault();
                }
            }
            catch (Exception ex)
            {
                HttpError err = new HttpError("Error retrieving install. ");
                return(ResponseMessage(Request.CreateResponse(HttpStatusCode.InternalServerError, err)));
            }

            return(Ok(install));
        }
Ejemplo n.º 8
0
        public IHttpActionResult GetChannelMessages(int id)
        {
            IEnumerable <string> headerValues = Request.Headers.GetValues("Authorization");
            string installKey = headerValues.FirstOrDefault();

            if (installKey == "")
            {
                return(ResponseMessage(Models.Errors.InstallKeyBlank(Request)));
            }

            try
            {
                Models.Installs.checkinInstall(installKey);
            }
            catch (Exception ex)
            {
                return(ResponseMessage(Models.Errors.InstallCheckinFailed(Request)));
            }

            List <MednaNetAPIClient.Models.Messages> messages = null;

            try
            {
                using (Models.MedLaunchChatEntities db = new Models.MedLaunchChatEntities())
                {
                    messages = (from q in db.discord_messages
                                where q.channel == id && !q.clients_ignore
                                select new MednaNetAPIClient.Models.Messages()
                    {
                        channel = q.channel,
                        code = q.code,
                        message = q.message,
                        name = q.name,
                        postedOn = q.posted_on,
                        id = q.id
                    }).ToList();
                }
            }
            catch (Exception ex)
            {
                HttpError err = new HttpError("Error retrieving messages for discord channel. ");
                return(ResponseMessage(Request.CreateResponse(HttpStatusCode.InternalServerError, err)));
            }

            return(Ok(messages));
        }
Ejemplo n.º 9
0
        public IHttpActionResult GetDiscordChannels()
        {
            IEnumerable <string> headerValues = Request.Headers.GetValues("Authorization");
            string installKey = headerValues.FirstOrDefault();

            Models.Installs.checkinInstall(installKey);

            if (installKey == "")
            {
                return(ResponseMessage(Models.Errors.InstallKeyBlank(Request)));
            }

            try
            {
                Models.Installs.checkinInstall(installKey);
            }
            catch (Exception ex)
            {
                return(ResponseMessage(Models.Errors.InstallCheckinFailed(Request)));
            }

            List <MednaNetAPIClient.Models.Channels> channels = null;

            try
            {
                using (Models.MedLaunchChatEntities db = new Models.MedLaunchChatEntities())
                {
                    channels = (from q in db.discord_channels
                                select new MednaNetAPIClient.Models.Channels()
                    {
                        channelName = q.channel_name,
                        id = q.id,
                        discordId = q.channel_discord_id
                    }).ToList();
                }
            }
            catch (Exception ex)
            {
                HttpError err = new HttpError("Error retrieving discord channels. ");
                return(ResponseMessage(Request.CreateResponse(HttpStatusCode.InternalServerError, err)));
            }

            return(Ok(channels));
        }
Ejemplo n.º 10
0
        public IHttpActionResult CreateInstall()
        {
            string guid = Guid.NewGuid().ToString();

            MednaNetAPIClient.Models.Installs install = null;

            try
            {
                using (Models.MedLaunchChatEntities db = new Models.MedLaunchChatEntities())
                {
                    Models.install newInstall = new Models.install();
                    newInstall.banned        = false;
                    newInstall.code          = guid;
                    newInstall.last_checkin  = DateTime.Now;
                    newInstall.registered_on = DateTime.Now;
                    newInstall.username      = "";

                    db.installs.Add(newInstall);
                    db.SaveChanges();

                    install = (from q in db.installs
                               where q.code == guid
                               select new MednaNetAPIClient.Models.Installs()
                    {
                        id = q.id,
                        banned = q.banned,
                        code = q.code,
                        lastCheckin = q.last_checkin,
                        registeredOn = q.registered_on,
                        tempBan = q.temp_ban,
                        tempBanEnd = q.temp_ban_end,
                        username = q.username
                    }).FirstOrDefault();
                }
            }
            catch (Exception ex)
            {
                HttpError err = new HttpError("Error registering new install. ");
                return(ResponseMessage(Request.CreateResponse(HttpStatusCode.InternalServerError, err)));
            }


            return(Ok(install));
        }
Ejemplo n.º 11
0
        public IHttpActionResult GetCheckedInUsers()
        {
            IEnumerable <string> headerValues = Request.Headers.GetValues("Authorization");
            string installKey = headerValues.FirstOrDefault();

            if (installKey == "")
            {
                return(ResponseMessage(Models.Errors.InstallKeyBlank(Request)));
            }

            try
            {
                Models.Installs.checkinInstall(installKey);
            }
            catch (Exception ex)
            {
                return(ResponseMessage(Models.Errors.InstallCheckinFailed(Request)));
            }

            List <MednaNetAPIClient.Models.Users> users = null;

            try
            {
                using (Models.MedLaunchChatEntities db = new Models.MedLaunchChatEntities())
                {
                    users = (from q in db.installs
                             where System.Data.Entity.DbFunctions.AddMinutes(q.last_checkin, 10) > System.Data.Entity.DbFunctions.AddMinutes(DateTime.Now, -10) && q.code != "botInstallKey"
                             select new MednaNetAPIClient.Models.Users()
                    {
                        id = q.id,
                        username = q.username
                    }).ToList();
                }
            }
            catch (Exception ex)
            {
                HttpError err = new HttpError("Error retrieving checked in users. ");
                return(ResponseMessage(Request.CreateResponse(HttpStatusCode.InternalServerError, err)));
            }

            return(Ok(users));
        }
Ejemplo n.º 12
0
        public IHttpActionResult UpdateInstall(MednaNetAPIClient.Models.Installs install)
        {
            IEnumerable <string> headerValues = Request.Headers.GetValues("Authorization");
            string installKey = headerValues.FirstOrDefault();

            if (installKey == "")
            {
                return(ResponseMessage(Models.Errors.InstallKeyBlank(Request)));
            }

            try
            {
                Models.Installs.checkinInstall(installKey);
            }
            catch (Exception ex)
            {
                return(ResponseMessage(Models.Errors.InstallCheckinFailed(Request)));
            }

            try
            {
                using (Models.MedLaunchChatEntities db = new Models.MedLaunchChatEntities())
                {
                    var dbInstall = (from q in db.installs
                                     where q.code == installKey
                                     select q).FirstOrDefault();

                    dbInstall.username = install.username;

                    db.SaveChanges();
                }
            }
            catch (Exception ex)
            {
                HttpError err = new HttpError("Username update failed. Check you are passing an existing installKey");
                return(ResponseMessage(Request.CreateResponse(HttpStatusCode.InternalServerError, err)));
            }


            return(Ok());
        }
Ejemplo n.º 13
0
        public IHttpActionResult CheckinInstall()
        {
            IEnumerable <string> headerValues = Request.Headers.GetValues("Authorization");
            string installKey = headerValues.FirstOrDefault();

            if (installKey == "")
            {
                return(ResponseMessage(Models.Errors.InstallKeyBlank(Request)));
            }

            try
            {
                Models.Installs.checkinInstall(installKey);
            }
            catch (Exception ex)
            {
                return(ResponseMessage(Models.Errors.InstallCheckinFailed(Request)));
            }

            try
            {
                using (Models.MedLaunchChatEntities db = new Models.MedLaunchChatEntities())
                {
                    var install = (from q in db.installs
                                   where q.code == installKey
                                   select q).FirstOrDefault();

                    install.last_checkin = DateTime.Now;

                    db.SaveChanges();
                }
            }
            catch (Exception ex)
            {
                return(ResponseMessage(Models.Errors.InstallCheckinFailed(Request)));
            }

            return(Ok());
        }
Ejemplo n.º 14
0
        public IHttpActionResult GetChannelMessagesFrom(int id, string from)
        {
            IEnumerable <string> headerValues = Request.Headers.GetValues("Authorization");
            string installKey = headerValues.FirstOrDefault();

            if (installKey == "")
            {
                return(ResponseMessage(Models.Errors.InstallKeyBlank(Request)));
            }

            try
            {
                Models.Installs.checkinInstall(installKey);
            }
            catch (Exception ex)
            {
                return(ResponseMessage(Models.Errors.InstallCheckinFailed(Request)));
            }

            DateTime fromDate;

            try
            {
                fromDate = DateTime.ParseExact(from, "yyyyMMddTHHmmss", System.Globalization.CultureInfo.InvariantCulture).ToLocalTime();
            }
            catch (Exception ex)
            {
                HttpError err = new HttpError("Unable to convert from value to a datetime value. ");
                return(ResponseMessage(Request.CreateResponse(HttpStatusCode.BadRequest, err)));
            }



            List <MednaNetAPIClient.Models.Messages> messages = null;

            try
            {
                using (Models.MedLaunchChatEntities db = new Models.MedLaunchChatEntities())
                {
                    var install = (from q in db.installs
                                   where q.code == installKey
                                   select q).FirstOrDefault();

                    if (install != null)
                    {
                        messages =
                            (from g in db.discord_channels
                             from m in g.discord_messages
                             where m.posted_on >= fromDate && !m.clients_ignore && m.channel == id
                             orderby m.posted_on
                             select new MednaNetAPIClient.Models.Messages()
                        {
                            channel = g.id,
                            code = m.code,
                            message = m.message,
                            name = m.name,
                            postedOn = m.posted_on,
                            id = m.id
                        }).ToList();
                    }
                }
            }
            catch (Exception ex)
            {
                HttpError err = new HttpError("Error retrieving messages for discord channel. ");
                return(ResponseMessage(Request.CreateResponse(HttpStatusCode.InternalServerError, err)));
            }

            return(Ok(messages));
        }
Ejemplo n.º 15
0
        public IHttpActionResult CreateDiscordMessage(int id, MednaNetAPIClient.Models.Messages message)
        {
            IEnumerable <string> headerValues = Request.Headers.GetValues("Authorization");
            string installKey = headerValues.FirstOrDefault();

            if (installKey == "")
            {
                return(ResponseMessage(Models.Errors.InstallKeyBlank(Request)));
            }

            try
            {
                Models.Installs.checkinInstall(installKey);
            }
            catch (Exception ex)
            {
                return(ResponseMessage(Models.Errors.InstallCheckinFailed(Request)));
            }

            string username     = "";
            bool   clientIgnore = false;

            Models.discord_messages newRecord = null;

            try
            {
                newRecord = new Models.discord_messages();
                using (Models.MedLaunchChatEntities db = new Models.MedLaunchChatEntities())
                {
                    var install = (from q in db.installs
                                   where q.code == installKey
                                   select q).FirstOrDefault();

                    if (install != null)
                    {
                        if (install.banned)
                        {
                        }
                        else
                        {
                            if (install.temp_ban)
                            {
                            }
                            else
                            {
                                if (installKey == "botInstallKey")
                                {
                                    username = message.name;
                                }
                                else
                                {
                                    username = install.username;
                                }

                                newRecord = new Models.discord_messages();

                                newRecord.code           = message.code;
                                newRecord.message        = message.message;
                                newRecord.name           = username;
                                newRecord.posted_on      = DateTime.Now;
                                newRecord.channel        = id;
                                newRecord.clients_ignore = clientIgnore;

                                db.discord_messages.Add(newRecord);
                                db.SaveChanges();
                            }
                        }
                    }
                    else
                    {
                    }
                }
            }
            catch (Exception ex)
            {
                HttpError err = new HttpError("Error creating message for discord channel. ");
                return(ResponseMessage(Request.CreateResponse(HttpStatusCode.InternalServerError, err)));
            }



            return(Ok(newRecord));
        }
Ejemplo n.º 16
0
        public IHttpActionResult CreateGroup(MednaNetAPIClient.Models.Groups group)
        {
            var APIReturn = new Models.APIReturn();

            IEnumerable <string> headerValues = Request.Headers.GetValues("Authorization");
            string installKey = headerValues.FirstOrDefault();

            if (installKey == "")
            {
                return(ResponseMessage(Models.Errors.InstallKeyBlank(Request)));
            }

            try
            {
                Models.Installs.checkinInstall(installKey);
            }
            catch (Exception ex)
            {
                return(ResponseMessage(Models.Errors.InstallCheckinFailed(Request)));
            }

            try
            {
                using (Models.MedLaunchChatEntities db = new Models.MedLaunchChatEntities())
                {
                    var install = (from q in db.installs
                                   where q.code == installKey
                                   select q).FirstOrDefault();

                    if (install != null)
                    {
                        Models.group newGroup = new Models.group();
                        newGroup.group_description = group.groupDescription;
                        newGroup.group_name        = group.groupName;
                        newGroup.group_owner       = install.id;

                        if (newGroup.group_name.Length > 20)
                        {
                            newGroup.group_name = newGroup.group_name.Substring(0, 19);
                        }

                        db.groups.Add(newGroup);

                        try
                        {
                            db.SaveChanges();
                            APIReturn.returnMessage = "Group created.";
                        }
                        catch (Exception e)
                        {
                            APIReturn.returnMessage = "Could not create group.";
                            return(new System.Web.Http.Results.ExceptionResult(e, this));
                        }

                        Models.group_members groupMember = new Models.group_members();
                        groupMember.awaiting_invite_confrim = false;
                        groupMember.group_id   = newGroup.id;
                        groupMember.install_id = install.id;
                        db.group_members.Add(groupMember);


                        try
                        {
                            db.SaveChanges();
                            APIReturn.returnMessage += "| Install added to group";
                        }
                        catch (Exception e)
                        {
                            APIReturn.returnMessage = "Could not add install to group.";
                            return(new System.Web.Http.Results.ExceptionResult(e, this));
                        }
                    }
                    else
                    {
                        APIReturn.returnMessage = "Install not found";
                    }
                }
            }
            catch (Exception ex)
            {
                HttpError err = new HttpError("Error creating group. ");
                return(ResponseMessage(Request.CreateResponse(HttpStatusCode.InternalServerError, err)));
            }

            return(Ok());
        }