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");
}
