/// <summary>
/// 保存信息到数据库吧
/// </summary>
/// <param name="item"></param>
/// <returns></returns>
public static int SaveMessageRecord(Models.MessageViewModel item)
{
string sql = @"INSERT INTO ChemCloud_Messages
(SendUserID
,MessageContent
,ReviceUserID
,SendTime
,IsRead
,SendUserName
,ReviceUserName)
VALUES
(@SendUserID
,@MessageContent
,@ReviceUserID
,@SendTime
,@IsRead
,@SendUserName
,@ReviceUserName)";
using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(DataConstantConfigure.strConn))
{
conn.Open();
return(conn.Execute(sql, item));
}
}
public ActionResult SaveMessageRecord(
Models.MessageViewModel item)
{
item.SendTime = DateTime.Now;
Data.ChatMessage.SaveMessageRecord(item);
return(Json("11"));
}
public IHttpActionResult SendMessage(int chatId, [FromBody] Models.MessageViewModel message)
{
try
{
service.SendMessage(chatId, User.Identity.GetUserId(), message.Text);
return(Ok());
}
catch (Exception e)
{
return(BadRequest(e.Message));
}
}
