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