public ActionResult CreateChatCommunication([FromBody] ChatCommunicationDTO chatCommunicationDTO) { if (!ModelState.IsValid) { return(BadRequest()); } if (chatCommunicationDTO == null) { return(BadRequest()); } var checkChatIdinDb = _choiceRepoistory.GetChatCommunication().Find(c => c.ChatId == chatCommunicationDTO.ChatId); if (checkChatIdinDb != null) { return(BadRequest()); } ChatCommunications newlyChatCommunication = new ChatCommunications() { //ChatId = chatCommunicationDTO.ChatId, ChatTitle = chatCommunicationDTO.ChatTitle, BookingId = chatCommunicationDTO.BookingId, ChatCommunication = chatCommunicationDTO.ChatCommunication, ProcedureId = chatCommunicationDTO.ProcedureId, IsPartnerSideCommunication = chatCommunicationDTO.IsPartnerSideCommunication, ProcedureCommunication = chatCommunicationDTO.ProcedureCommunication, CreatedDate = chatCommunicationDTO.CreatedDate, CreatedBy = chatCommunicationDTO.CreatedBy, SharepointId = chatCommunicationDTO.SharepointId }; _choiceRepoistory.SetChatCommunication(newlyChatCommunication); _choiceRepoistory.Complete(); return(CreatedAtRoute("GetChatCommunicationByChatId", new { chatId = newlyChatCommunication.ChatId }, newlyChatCommunication)); }
public void SetChatCommunication(ChatCommunications chatCommunication) { _dbContext.ChatCommunication.Add(chatCommunication); }
public void InsertData(ClientContext clientContext, DKBSDbContext dbContext) { try { Console.WriteLine(" Successfully Connected"); SP.List oListData = clientContext.Web.Lists.GetByTitle("Service request communications"); CamlQuery camlQuery = new CamlQuery(); camlQuery.ViewXml = "<View Scope='RecursiveAll'><Query></Query></View>"; ListItemCollection oListDataItem = oListData.GetItems(camlQuery); clientContext.Load(oListDataItem); clientContext.ExecuteQuery(); foreach (ListItem oItem in oListDataItem) { Console.WriteLine("ID: {0} \nTitle: {1}", oItem["ID"], oItem["Title"]); Console.WriteLine(((SP.FieldUserValue)(oItem["Author"])).LookupValue); Console.WriteLine(((SP.FieldUserValue)(oItem["Editor"])).LookupValue); Console.WriteLine(oItem["Created"].ToString()); Console.WriteLine(oItem["Modified"].ToString()); Console.WriteLine(oItem["Communications"]); Console.WriteLine(oItem["FromMyIT"]); Console.WriteLine(oItem["Created"]); Console.WriteLine(oItem["CopyToCloseRemark"]); Console.WriteLine(oItem["IsPartnerSideCommunication"]); Console.WriteLine(oItem["ProcedureInfoCommunication"]); if (oItem["ServiceRequestID"] != null) { Console.WriteLine(oItem["ServiceRequestID"]); var childIdField = oItem["ServiceRequestID"] as FieldLookupValue[]; if (childIdField != null) { foreach (var lookupValue in childIdField) { var childId_Value = lookupValue.LookupValue; var childId_Id = lookupValue.LookupId; Console.WriteLine("LookupID: " + childId_Id.ToString()); Console.WriteLine("LookupValue: " + childId_Value.ToString()); } } } if (oItem["ITProcedureID"] != null) { Console.WriteLine(oItem["ITProcedureID"]); var childIdField = oItem["ITProcedureID"] as FieldLookupValue[]; if (childIdField != null) { foreach (var lookupValue in childIdField) { var childId_Value = lookupValue.LookupValue; var childId_Id = lookupValue.LookupId; Console.WriteLine("LookupID: " + childId_Id.ToString()); Console.WriteLine("LookupValue: " + childId_Value.ToString()); } } } ChatCommunications chatCommunications = new ChatCommunications(); if (oItem["Title"] != null) { chatCommunications.ChatTitle = oItem["Title"].ToString(); } else { chatCommunications.ChatTitle = "No Chat Title"; } chatCommunications.BookingId = 7; if (oItem["Communications"] != null) { chatCommunications.ChatCommunication = oItem["Communications"].ToString(); } chatCommunications.ProcedureId = 2; if (oItem["IsPartnerSideCommunication"] != null) { chatCommunications.IsPartnerSideCommunication = Convert.ToBoolean(oItem["IsPartnerSideCommunication"]); } if (oItem["ProcedureInfoCommunication"] != null) { chatCommunications.ProcedureCommunication = Convert.ToBoolean(oItem["ProcedureInfoCommunication"]); } if (oItem["ID"] != null) { chatCommunications.SharepointId = Convert.ToInt32(oItem["ID"]); } chatCommunications.CreatedBy = ((SP.FieldUserValue)(oItem["Author"])).LookupValue; chatCommunications.CreatedDate = Convert.ToDateTime(oItem["Created"].ToString()); dbContext.Add(chatCommunications); dbContext.SaveChanges(); } } catch (Exception) { throw; } }