public bool WithNoLockQuery(out string status)
{
try
{
var responses = new List <Response>();
using (var transaction = SqlDataContext.CreateNewContextTransaction(IsolationLevel.ReadUncommitted))
{
for (var i = 1; i < 150; i++)
{
responses = SqlDataContext.Repository <Response>().Query()
.Include(r => r.User).Get().ToList();
}
transaction.Commit();
}
if (responses.Any())
{
status = "Success";
return(true);
}
status = "There is no registered response in the database";
return(false);
}
catch (Exception ex)
{
status = ex.GetAllMessages();
return(false);
}
}
public Request GetRequestById(Guid id)
{
try
{
return(SqlDataContext.Repository <Request>().Find(id));
}
catch
{
return(null);
}
}
public bool DeleteBulkResponse(IEnumerable <Response> responses, out string status)
{
try
{
SqlDataContext.Repository <Response>().DeleteMany(responses);
SqlDataContext.Save();
status = "Success";
return(true);
}
catch (Exception ex)
{
status = ex.GetAllMessages();
return(false);
}
}
public bool SaveRequest(out string status)
{
try
{
var user = SqlDataContext.Repository <User>().Query()
.Get().FirstOrDefault();
if (user == null)
{
status = "There is no registered User in the database";
return(false);
}
var requestType = SqlDataContext.Repository <RequestType>()
.Query().Get().FirstOrDefault();
if (requestType != null)
{
SqlDataContext.Repository <Request>().InsertGraph(new Request
{
Id = Guid.NewGuid(),
RequestTypeId = requestType.Id,
Header = "Test Request",
Body = "Body text for test request",
UserId = user.Id
});
SqlDataContext.Save();
status = "Success";
return(true);
}
status = "There is no registered Request Type in the database";
return(false);
}
catch (Exception ex)
{
status = ex.GetAllMessages();
return(false);
}
}
public bool SaveBulkResponse(out string status)
{
try
{
var user = SqlDataContext.Repository <User>().Query().Get().FirstOrDefault();
if (user == null)
{
status = "There is no registered User in the database";
return(false);
}
var request = SqlDataContext.Repository <Request>().Query().Include(r => r.Response).Get().FirstOrDefault();
if (request == null)
{
status = "There is no registered Request in the database";
return(false);
}
var responses = Enumerable.Range(0, 1000).Select(p => new Response
{
Id = Guid.NewGuid(),
Body = "Bulk insert test for responses",
Header = "Bulk insert test",
RequestId = request.Id,
UserId = user.Id
});
SqlDataContext.Repository <Response>().InsertMany(responses);
SqlDataContext.Save();
status = "Success";
return(true);
}
catch (Exception ex)
{
status = ex.GetAllMessages();
return(false);
}
}
public bool UserExtensionMethodTest(out string status)
{
try
{
var activeUsers = SqlDataContext.Repository <User>()
.GetActiveUsers().ToList();
if (activeUsers.Any())
{
status = "Success";
return(true);
}
status = "No active user";
return(false);
}
catch (Exception ex)
{
status = ex.GetAllMessages();
return(false);
}
}
public IList <Response> ResponseListFromStoredProcedure
(out string status)
{
try
{
var request = SqlDataContext.Repository <Request>()
.Query().Get().FirstOrDefault();
if (request != null)
{
var responses = SqlDataContext.Repository <Response>().SqlQuery(
"exec [dbo].[spGetResponsesByRequestId] @requestId", new SqlParameter
{
DbType = DbType.Guid,
ParameterName = "@requestId",
Direction = ParameterDirection.Input,
Value = request.Id
}).ToList();
if (responses.Any())
{
status = "Success";
return(responses);
}
status = "There is no registered response in the database";
return(null);
}
status = "There is no registered Request in the database";
return(null);
}
catch (Exception ex)
{
status = ex.GetAllMessages();
return(null);
}
}
public bool SaveTestUser(out string status)
{
try
{
SqlDataContext.Repository <User>().InsertGraph(new User
{
Id = Guid.NewGuid(),
Email = "*****@*****.**",
FullName = "Emre Gulay",
IsActive = true,
Password = "******"
});
SqlDataContext.Save();
status = "Saved";
return(true);
}
catch (Exception ex)
{
status = ex.GetAllMessages();
return(false);
}
}
public IQueryable <Response> GetResponses()
{
return(SqlDataContext.Repository <Response>().Query().Get());
}
