/// <summary> /// /// </summary> /// <param name="puserId"></param> /// <param name="chatRoomStatusFromEtl">Estado del recodr id </param> /// <returns></returns> internal static GetRecordIdBE GetRecordId(int messageId, out int? chatRoomStatusFromEtl) { chatRoomStatusFromEtl = null; Database database = null; int? recordId = null; GetRecordIdBE wGetRecordId = new GetRecordIdBE(); //try //{ database = DatabaseFactory.CreateDatabase(Common.Common.EpironChat_CnnStringName); using (DbCommand cmd = database.GetStoredProcCommand("[chat].[Record_s_bySourceChatMessageId]")) { database.AddInParameter(cmd, "ChatMessageId", DbType.Int32, messageId); using (IDataReader reader = database.ExecuteReader(cmd)) { while (reader.Read()) { if (reader["recordId"] != DBNull.Value) wGetRecordId.RecordId = Convert.ToInt32(reader["recordId"]); if (reader["PCRecordActionResultType"] != DBNull.Value) chatRoomStatusFromEtl = Convert.ToInt32(reader["PCRecordActionResultType"]); if (reader["FirstName"] != DBNull.Value) wGetRecordId.UserFirstName = Convert.ToString(reader["FirstName"]); if (reader["LastName"] != DBNull.Value) wGetRecordId.UserLastName = Convert.ToString(reader["LastName"]); if (reader["Name"] != DBNull.Value) wGetRecordId.UserName = Convert.ToString(reader["Name"]); } } } return wGetRecordId; //} //catch (Exception ex) //{ // throw SecPortalException.ProcessException(ex, typeof(EpironChatDAC), Common.Common.EpironChat_CnnStringName); //} }
public JsonResult GetRecordId(int userId, int roomId, int messageId) { //int? recordId = -1; GetRecordIdBE wGetRecordId = new GetRecordIdBE(); int? chatRoomStatusFromEtl = null; try { wGetRecordId = EpironChatDAC.GetRecordId(messageId, out chatRoomStatusFromEtl); if (wGetRecordId.RecordId != null) EpironChatBC.ChatRoom_UpdateStatus(roomId, wGetRecordId.RecordId.Value, WebChat.Common.Enumerations.ChatRoomStatus.Active); return Json(new { Result = "OK", recordId = wGetRecordId.RecordId, userName = wGetRecordId.UserName }); } catch (Exception ex) { Helper.Log(ex.Message); return Json(new { Result = "ERROR", Message = Fwk.Exceptions.ExceptionHelper.GetAllMessageException(ex) }); } }