public void SP_InsertLogRequestMessage(string Log_Type, string Log_Destination, string Log_Mode, string Log_Message, string Log_RawJson, DateTime Log_RequestDate, string Log_RequestBy, string Log_CreateBy)
{
statement = new Statement();
statement.AppendStatement("EXEC [LineDB]..[SP_InsertLogRequestMessage] @Log_Type, @Log_Destination, @Log_Mode, @Log_Message, @Log_RawJson, @Log_RequestDate, @Log_RequestBy, @Log_CreateBy");
statement.AppendParameter("@Log_Type", Log_Type);
statement.AppendParameter("@Log_Destination", Log_Destination);
statement.AppendParameter("@Log_Mode", Log_Mode);
statement.AppendParameter("@Log_Message", Log_Message);
statement.AppendParameter("@Log_RawJson", Log_RawJson);
statement.AppendParameter("@Log_RequestDate", Log_RequestDate);
statement.AppendParameter("@Log_RequestBy", Log_RequestBy);
statement.AppendParameter("@Log_CreateBy", Log_CreateBy);
resAccess.ExecutenonResult(statement);
// return
}
public void REST_KeepLogRequest(string error, string Json)
{
statement = new Statement();
statement.AppendStatement("EXEC REST_KeepLogRequest @error, @json");
statement.AppendParameter("@error", error);
statement.AppendParameter("@json", Json);
resAccess.ExecutenonResult(statement);
}
public string REST_InsertFilelog(string FileName, string OriginalFile, long fileSize, string PhoneNumber, string CallDate, string CallTime, string CreateBy)
{
_statement.AppendStatement("EXEC REST_InsertFilelog ");
_statement.AppendParameter("@Test", 0);
_resAccess.ExecutenonResult(_statement);
return("Success");
}
public void REST_InitialStep(string userId, string step, string value)
{
statement = new Statement();
statement.AppendStatement("EXEC REST_InitialStep @userId, @step, @value");
statement.AppendParameter("@userId", userId);
statement.AppendParameter("@step", step);
statement.AppendParameter("@value", value);
resAccess.ExecutenonResult(statement);
}
public string REST_InsertFilelog(string FileName, string OriginalFile, long FileSize, string Extension, string PhoneNumber, string CallDate, string CallTime, string CreateBy)
{
_statement.AppendStatement("EXEC REST_InsertFilelog @FileName, @OriginalFile, @FileSize, @Extension, @PhoneNumber, @CallDate, @CallTime, @CreateBy");
_statement.AppendParameter("@FileName", FileName.hasOrNull());
_statement.AppendParameter("@OriginalFile", OriginalFile.hasOrNull());
_statement.AppendParameter("@FileSize", FileSize.hasOrNull());
_statement.AppendParameter("@Extension", Extension.hasOrNull());
_statement.AppendParameter("@PhoneNumber", PhoneNumber.hasOrNull());
_statement.AppendParameter("@CallDate", CallDate.hasOrNull());
_statement.AppendParameter("@CallTime", CallTime.hasOrNull());
_statement.AppendParameter("@CreateBy", CreateBy.hasOrNull());
string result = _resAccess.ExecutenonResult(_statement);
return(result);
}