public void UpdateProcess(LogData log)//string id, int statu,DateTime endDate)
{
using (var dbaccess = new MssqlDbAccess(connstring))
{
dbaccess.ExecuteNonQuery("DBO.PROC_UPDATE_ORTEC_LOG", new List <SqlParameter>
{
new SqlParameter("@P_ID", log.Id),
new SqlParameter("@P_STATU", log.State),
new SqlParameter("@P_ENDTIME", log.EndTime)
});
}
}
public void UpdateItemOfProcess(LogData log)//string id, string response,int statu,int levelid,DateTime endDate)
{
using (var dbaccess = new MssqlDbAccess(connstring))
{
dbaccess.ExecuteNonQuery("DBO.PROC_UPDATE_ORTEC_LOG_DT", new List <SqlParameter>
{
new SqlParameter("@P_ID", log.Id),
new SqlParameter("@P_RESPONSE", log.ResXml.ReplaceEncodedHtmlCharacter()),
new SqlParameter("@P_STATU", log.State),
new SqlParameter("@P_LEVELID", log.LevelId),
new SqlParameter("@P_ENDTIME", log.EndTime)
});
}
}
/// <summary>
/// Tamamlanan her data aktarım işleminin hepsine birden verilen isim process.
/// </summary>
/// <param name="log"></param>
public void InitiliazeProcess(LogData log)//string appName, string id, DateTime startTime, string ip, string host, string method)
{
using (var dbaccess = new MssqlDbAccess(connstring))
{
dbaccess.ExecuteNonQuery("DBO.PROC_INITILIAZE_ORTEC_LOG", new List <SqlParameter>
{
new SqlParameter("@P_ID", log.Id),
new SqlParameter("@P_STARTTIME", log.StartTime),
new SqlParameter("@P_METHOD", log.Method),
new SqlParameter("@P_APPNAME", log.AppName),
new SqlParameter("@P_COMPUTERID", log.ComputerId)
});
}
}
/// <summary>
/// Açılmış olan bir işlemin herbir adımına verilen isim ItemOfProcess
/// </summary>
public decimal InitiliazeItemOfProcess(LogData log)//string request, string id,string method,DateTime startTime)
{
using (var dbaccess = new MssqlDbAccess(connstring))
{
var outputparam = new SqlParameter("@P_LEVELID", log.LevelId);
outputparam.Direction = ParameterDirection.Output;
dbaccess.ExecuteNonQuery("DBO.PROC_INITILIAZE_ORTEC_LOG_DT", new List <SqlParameter>
{
new SqlParameter("@P_ID", new Guid(log.Id)),
new SqlParameter("@P_METHOD", log.Method),
new SqlParameter("@P_STARTTIME", log.StartTime),
new SqlParameter("@P_REQUEST", log.ReqXml.ReplaceEncodedHtmlCharacter()),
outputparam
});
return(Convert.ToInt32(outputparam.Value));
}
}