public ActionResult loadChat(int conID)
        {
            chatModel m  = new chatModel();
            dbUtils   db = new dbUtils();

            ArrayList[] data;
            string      sql = "select con_userID,con_contactID,con_starter from CONVERSATIONS where con_id=" + conID;

            try { data = db.fetch(sql, 3); }
            catch (Exception) { throw; }

            string userID    = data[0][0].ToString(),
                   contactID = data[1][0].ToString();
            int starter      = (Int32)data[2][0];


            dbUtils db2 = new dbUtils();

            ArrayList[] data2;
            string      sql2;

            if (starter == 1)
            {
                sql2 = "select userOneMess,userTwoMess,messDate from [" + userID + "_AND_" + contactID + "]";
            }
            else
            {
                sql2 = "select userOneMess,userTwoMess,messDate from [" + contactID + "_AND_" + userID + "]";
            }

            try { data2 = db2.fetch(sql2, 3); }
            catch (Exception) { throw; }

            sql = "update CONVERSATIONS set con_notifications = 0 where con_id=" + conID;

            try { db.Update(sql); }
            catch (Exception) { throw; }

            m.userOneMess = data2[0];
            m.userTwoMess = data2[1];
            m.date        = data2[2];
            m.starter     = starter;
            m.conID       = conID;

            return(PartialView("chatHistory", m));
        }
        public MessengerModel getConversations(MessengerModel m)
        {
            dbUtils db  = new dbUtils();
            string  sql = "select con_id, con_contactID ,con_notifications,con_starter from CONVERSATIONS where con_userID =" + m.userId;

            ArrayList[] data = new ArrayList[4];
            data     = db.fetch(sql, 4);
            m.consId = data[0];
            var con = new SOCIALMEDIA_DBEntities();

            foreach (int contactID in data[1])
            {
                m.conversations.Add(con.USERS.Find(contactID));
            }
            m.notifications = data[2];
            m.starter       = data[3];
            return(m);
        }
        public void sendMessage(string m, int conID)
        {
            dbUtils db = new dbUtils();

            ArrayList[] data;
            string      sql = "select con_userID,con_contactID,con_starter from CONVERSATIONS where con_id=" + conID;

            data = db.fetch(sql, 3);
            string userID    = data[0][0].ToString(),
                   contactID = data[1][0].ToString();
            int starter      = (Int32)data[2][0];

            dbUtils db2 = new dbUtils();
            string  sql2, date;

            Thread.CurrentThread.CurrentCulture = new CultureInfo("en-US");
            date = DateTime.Now.ToString();
            ArrayList[] param = new ArrayList[2];
            param[0] = new ArrayList(); param[1] = new ArrayList();
            param[0].Add("@msg"); param[1].Add(m);
            if (starter == 1)
            {
                sql2 = "insert into [" + userID + "_AND_" + contactID + "] (userOneMess,userTwoMess,messDate) values (@msg,'','" + date + "')";
            }
            else
            {
                sql2 = "insert into [" + contactID + "_AND_" + userID + "] (userOneMess,userTwoMess,messDate) values ('',@msg,'" + date + "')";
            }

            try { db2.create(sql2, param); }
            catch (Exception) { }

            sql = "update CONVERSATIONS set con_notifications = con_notifications + 1 where con_userID=" + contactID + " and con_contactID=" + userID;

            try { db.Update(sql); }
            catch (Exception) { throw; }
        }