public async Task <string> UpdateQuery(QueryReplyModel queryreply) { Query query = QueryRepository.GetQueries().FirstOrDefault(c => c.QueryId == queryreply.QueryId); if (query == default(Query)) { return("query doen't exist"); } else { query.AssignTo = queryreply.AssignTo; query.AssignToMailID = queryreply.AssignToMailID; query.Querytype = queryreply.Querytype; query.Severity = queryreply.Severity; query.Status = queryreply.Status; if (queryreply.RefDocument.Contains("NaN,")) { query.RefDocument = queryreply.RefDocument.Replace("NaN,", ""); } else { query.RefDocument = queryreply.RefDocument; } } int updatequery = await QueryRepository.UpdateQuery(query); return(updatequery == 0 ? "Successfully updated query and reply record" : "Updation failed"); }
public IHttpActionResult PostQueryReply(QueryReplyModel queryreply) { if (!ModelState.IsValid) { return(BadRequest("Invalid data.")); } Task.Run(async() => await _query.AddQuery(queryreply)); return(Ok()); }
public IHttpActionResult UpdateQueryReply(QueryReplyModel queryreply) { if (!ModelState.IsValid) { return(BadRequest("Not a valid model")); } Task.Run(async() => await _query.UpdateQuery(queryreply)); return(Ok()); }
public QueryReplyModel GetQueryReplyByID(int?id) { if (id == null) { throw new HttpResponseException(HttpStatusCode.BadRequest); } QueryReplyModel queryreply = _query.GeQueryDataById((int)id); return(queryreply); }
public QueryReplyModel GeQueryDataById(int queryId) { QueryReplyModel returnobj = new QueryReplyModel(); Query query = QueryRepository.GetQueries().FirstOrDefault(c => c.QueryId == queryId); Reply reply = ReplyRepository.GetReplies().OrderByDescending(c => c.ReplyId).First(c => c.QueryId == query.QueryId); List <int> DocumentIDList = new List <int>(); if (query.RefDocument != "") { DocumentIDList = query.RefDocument.Split(',').Select(int.Parse).ToList(); } List <DocumentRefModel> documentreflist = new List <DocumentRefModel>(); foreach (int docid in DocumentIDList) { var documents = DocumentRepository.GetDocumentByID(docid); if (documents.FilePath != "") { documentreflist.Add(new DocumentRefModel { DocumentID = documents.DocumentID, DocumnetName = documents.DocumentName, DocumnetPath = documents.FilePath }); } } returnobj = new QueryReplyModel { QueryId = query.QueryId, ProjectID = query.ProjectID, Subject = query.Subject, QueryText = reply.QueryText, QueryDate = reply.QueryDate, Replytext = reply.ReplyText, ReplyDate = reply.ReplyDate, AssignTo = query.AssignTo, AssignToMailID = query.AssignToMailID, Querytype = query.Querytype, Severity = query.Severity, Status = query.Status, RefDocument = query.RefDocument, DocumnetRefList = documentreflist, CreatedDate = query.CreatedDate.Value, CreatedBy = query.CreatedBy }; return(returnobj); }
public async Task <string> AddQuery(QueryReplyModel query) { DateTime now = DateTime.Now; if (query.RefDocument.Contains("NaN,")) { query.RefDocument = query.RefDocument.Replace("NaN,", ""); } int insertedqueryid = await QueryRepository.AddQuery(new Query { ProjectID = query.ProjectID, Subject = query.QueryText, AssignTo = query.AssignTo, AssignToMailID = query.AssignToMailID, Querytype = query.Querytype, Severity = query.Severity, Status = query.Status, RefDocument = query.RefDocument, CreatedDate = query.CreatedDate, CreatedBy = query.CreatedBy }); int insertedrelyid = await ReplyRepository.AddReply(new Reply { QueryId = insertedqueryid, QueryText = query.QueryText, ReplyText = query.Replytext, QueryDate = now, ReplyDate = now, CreatedDate = query.CreatedDate, CreatedBy = query.CreatedBy }); return(insertedqueryid != 0 ? "Successfully Insertion of query record" : "Insertion failed"); }