public ActionResult newConversation(int userID, int contactID, ArrayList friends_list) { dbUtils db = new dbUtils(); dbUtils db2 = new dbUtils(); string sql = "BEGIN IF NOT EXISTS (select * from CONVERSATIONS where con_userID=" + userID + " and con_contactID=" + contactID + ")" + " BEGIN insert into CONVERSATIONS (con_userID,con_contactID,con_notifications,con_starter) values (" + userID + "," + contactID + ",0," + 1 + ");"; sql += "insert into CONVERSATIONS (con_userID,con_contactID,con_notifications,con_starter) values (" + contactID + "," + userID + ",0," + 0 + "); END END"; string sql2 = "BEGIN CREATE TABLE [" + userID + "_AND_" + contactID + "] (" + "[m_id] int identity(1,1)," + "[userOneMess] nvarchar(MAX)," + "[userTwoMess] nvarchar(MAX)," + "[messDate] nvarchar(MAX)); END"; try { db.create(sql); } catch (Exception) { throw; } try { db2.create(sql2); } catch (Exception) { } return(RedirectToAction("Messenger")); }
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; } }