public static void CreateLogBySql(string applicationName, string functionName, string detail, string createdBy, string businessUnit, EventType eventType)
{
try
{
SqlDataAccess sda = new SqlDataAccess();
sda.openConnection(Globals.ConnectionString);
string sqlQuery = @"DECLARE @EventLogID uniqueidentifier
SET @EventLogID=NEWID()
INSERT
INTO
new_eventlogBase
(new_eventlogId
,CreatedOn
,CreatedBy
,ModifiedOn
,ModifiedBy
,OwnerId
,OwningBusinessUnit
,statecode
,statuscode
)
VALUES
(
@EventLogID
,@CreatedOn
,@CreatedBy
,@CreatedOn
,@CreatedBy
,@CreatedBy
,@BusinessUnit
,0
,1
)
INSERT
INTO
new_eventlogExtensionBase
(
new_eventlogId
,new_name
,new_applicationname
,new_detail
,new_eventtype
,new_function
)
VALUES
(
@EventLogID
,@Title
,@ApplicationName
,@Detail
,@EventType
,@FunctionName
)";
string title = string.Format("{0} - {1} - {2}", applicationName, functionName, DateTime.Now.ToString("dd.MM.yyyy HH:mm"));
List <SqlParameter> li = new List <SqlParameter>();
li.Add(new SqlParameter("@CreatedOn", DateTime.UtcNow));
li.Add(new SqlParameter("@CreatedBy", new Guid(createdBy)));
li.Add(new SqlParameter("@CreatedBy", new Guid(businessUnit)));
li.Add(new SqlParameter("@Title", title));
li.Add(new SqlParameter("@ApplicationName", applicationName));
li.Add(new SqlParameter("@Detail", detail));
li.Add(new SqlParameter("@EventType", (int)eventType));
li.Add(new SqlParameter("@FunctionName", functionName));
sda.ExecuteNonQuery(sqlQuery, li.ToArray());
sda.closeConnection();
}
catch (Exception ex)
{
}
}
