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) { } }