// +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ public ConversationDomain CheckConversationExists(ConversationInsertRequest model) { ConversationDomain conversation = null; try { DataProvider.ExecuteCmd(GetConnection, "dbo.Conversation_CheckIfExists" , inputParamMapper : delegate(SqlParameterCollection paramCollection) { paramCollection.AddWithValue("@sender_id", model.SenderId); paramCollection.AddWithValue("@receiver_id", model.ReceiverId); }, map : delegate(IDataReader reader, short set) { conversation = new ConversationDomain(); int startingIndex = 0; //startingOrdinal conversation.ConversationId = reader.GetSafeInt32(startingIndex++); conversation.SenderId = reader.GetSafeString(startingIndex++); conversation.ReceiverId = reader.GetSafeString(startingIndex++); conversation.CreateDate = reader.GetSafeDateTime(startingIndex++); }); } catch (Exception ex) { throw ex; } return(conversation); }
public HttpResponseMessage CheckConversationExists(ConversationInsertRequest model) { if (!ModelState.IsValid) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState)); } //- Check for existing conversations. ConversationDomain conversationDomain = _ConversationService.CheckConversationExists(model); //- If no conversation found, create new conversation. if (conversationDomain == null) { int conversationId = _ConversationService.InsertConversation(model); conversationDomain = _ConversationService.GetConversationById(conversationId); } var response = new ItemResponse <ConversationDomain> { Item = conversationDomain }; return(Request.CreateResponse(HttpStatusCode.OK, response)); }
// +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ public ConversationDomain GetConversationById(int id) { ConversationDomain singleConversation = null; try { DataProvider.ExecuteCmd(GetConnection, "dbo.Conversation_GetById" , inputParamMapper : delegate(SqlParameterCollection paramCollection) { paramCollection.AddWithValue("@id", id); }, map : delegate(IDataReader reader, short set) { singleConversation = new ConversationDomain(); int startingIndex = 0; //startingOrdinal singleConversation.ConversationId = reader.GetSafeInt32(startingIndex++); singleConversation.SenderId = reader.GetSafeString(startingIndex++); singleConversation.ReceiverId = reader.GetSafeString(startingIndex++); singleConversation.CreateDate = reader.GetSafeDateTime(startingIndex++); }); } catch (Exception ex) { throw ex; } return(singleConversation); }
public HttpResponseMessage GetConversationById(int id) { if (!ModelState.IsValid) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState)); } ConversationDomain conversation = _ConversationService.GetConversationById(id); var response = new ItemResponse <ConversationDomain> { Item = conversation }; return(Request.CreateResponse(HttpStatusCode.OK, response)); }
// +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ public List <ConversationDomain> GetDBConversationsBySenderId(string sender_id) { List <ConversationDomain> conversationList = null; try { DataProvider.ExecuteCmd(GetConnection, "dbo.Conversation_GetBySenderId" , inputParamMapper : delegate(SqlParameterCollection paramCollection) { paramCollection.AddWithValue("@sender_id", sender_id); }, map : delegate(IDataReader reader, short set) { var singleConversation = new ConversationDomain(); int startingIndex = 0; //startingOrdinal singleConversation.ConversationId = reader.GetSafeInt32(startingIndex++); singleConversation.SenderId = reader.GetSafeString(startingIndex++); singleConversation.ReceiverId = reader.GetSafeString(startingIndex++); singleConversation.CreateDate = reader.GetSafeDateTime(startingIndex++); singleConversation.SenderFullName = reader.GetSafeString(startingIndex++); singleConversation.ReceiverFullName = reader.GetSafeString(startingIndex++); singleConversation.SenderUrl = reader.GetSafeString(startingIndex++); singleConversation.ReceiverUrl = reader.GetSafeString(startingIndex++); singleConversation.ReceiverCompanyName = reader.GetSafeString(startingIndex++); singleConversation.SenderCompanyName = reader.GetSafeString(startingIndex++); if (conversationList == null) { conversationList = new List <ConversationDomain>(); } conversationList.Add(singleConversation); }); } catch (Exception ex) { throw ex; } return(conversationList); }