public ChatReplayStatus GetChatReplayStatus(int userId) { SqlConnection connection = new SqlConnection(connectionString); //string query = "SELECT * FROM ChatReplay WHERE UserId='" + userId + "'"; string query = "SELECT C.Id, C.ReplayStatus, C.UserId, U.FullName FROM ChatReplay C JOIN Users U ON C.UserId=U.Id WHERE U.Id=" + userId; SqlCommand command = new SqlCommand(query, connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); ChatReplayStatus chatReplay = null; if (reader.Read()) { int id = int.Parse(reader["Id"].ToString()); int userIdDb = int.Parse(reader["UserId"].ToString()); bool replayStatus = bool.Parse(reader["ReplayStatus"].ToString()); string fullName = reader["FullName"].ToString(); chatReplay = new ChatReplayStatus(id, userIdDb, replayStatus, fullName); } connection.Close(); return(chatReplay); }
public int InsertChatReplayStatus(ChatReplayStatus chatReplayStatus) { SqlConnection connection = new SqlConnection(connectionString); string query = "INSERT INTO ChatReplay(UserId, ReplayStatus) VALUES('" + chatReplayStatus.UserId + "','" + chatReplayStatus.ReplayStatus + "')"; SqlCommand command = new SqlCommand(query, connection); connection.Open(); int rowAffected = command.ExecuteNonQuery(); connection.Close(); return(rowAffected); }
public int UpdateChatReplayStatus(ChatReplayStatus chatReplayStatus) { SqlConnection connection = new SqlConnection(connectionString); string query = "UPDATE ChatReplay SET ReplayStatus='" + chatReplayStatus.ReplayStatus + "' WHERE UserId=" + chatReplayStatus.UserId; SqlCommand command = new SqlCommand(query, connection); connection.Open(); int rowAffected = command.ExecuteNonQuery(); connection.Close(); return(rowAffected); }
public int SetChatReplayStatus(ChatReplayStatus chatReplayStatus) { ChatReplayStatus getReplayStatus = _chatReplayGateway.GetChatReplayStatus(chatReplayStatus.UserId); if (getReplayStatus == null) { return(InsertChatReplayStatus(chatReplayStatus)); } else { return(UpdateChatReplayStatus(chatReplayStatus)); } }
protected void submitButton_Click(object sender, EventArgs e) { string message = chatBoxTextArea.Value; string userType = Session["UserType"].ToString(); int userId = int.Parse(ViewState["UserIdFromAdmin"].ToString()); ChatModel chatModel = new ChatModel(message, userType, userId); ChatReplayStatus replayStatus = new ChatReplayStatus(userId, true); int rowsAffectedMessage = _chatManager.InsertChatMessage(chatModel); int rowsAffectedStatus = _chatReplayManager.UpdateChatReplayStatus(replayStatus); Response.Redirect("ChatWithUserUI.aspx?userId=" + userId); }
protected void submitButton_Click(object sender, EventArgs e) { string message = chatBoxTextArea.Value; string userType = Session["UserType"].ToString(); int userId = int.Parse(Session["UserId"].ToString()); ChatModel chatModel = new ChatModel(message, userType, userId); ChatReplayStatus replayStatus = new ChatReplayStatus(userId, false); int rowsAffectedMessage = _chatManager.InsertChatMessage(chatModel); int rowsAffectedStatus = _chatReplayManager.SetChatReplayStatus(replayStatus); Response.Redirect("FindAgentMessageUI.aspx"); }
public List <ChatReplayStatus> GetUnReplayedStatusList() { SqlConnection connection = new SqlConnection(connectionString); //string query = "SELECT * FROM ChatReplay WHERE ReplayStatus=" + false; string query = "SELECT C.Id, C.ReplayStatus, C.UserId, U.FullName FROM ChatReplay C JOIN Users U ON C.UserId=U.Id WHERE C.ReplayStatus='" + false + "'"; SqlCommand command = new SqlCommand(query, connection); List <ChatReplayStatus> chatReplayList = new List <ChatReplayStatus>(); connection.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { int id = int.Parse(reader["Id"].ToString()); int userId = int.Parse(reader["UserId"].ToString()); bool replayStatus = bool.Parse(reader["ReplayStatus"].ToString()); string fullName = reader["FullName"].ToString(); ChatReplayStatus chatReplay = new ChatReplayStatus(id, userId, replayStatus, fullName); chatReplayList.Add(chatReplay); } connection.Close(); return(chatReplayList); }
public int InsertChatReplayStatus(ChatReplayStatus chatReplayStatus) { return(_chatReplayGateway.InsertChatReplayStatus(chatReplayStatus)); }
public int UpdateChatReplayStatus(ChatReplayStatus chatReplayStatus) { return(_chatReplayGateway.UpdateChatReplayStatus(chatReplayStatus)); }