private void AuditUpdateofUser(Guid OrderingUserId, Guid?KeycloakUserId)
 {
     try
     {
         CSLOrderingARCBAL.LinqToSqlDataContext db;
         db = new CSLOrderingARCBAL.LinqToSqlDataContext();
         CSLOrderingARCBAL.User_Migration_KC _usermigration = (from user in db.User_Migration_KCs
                                                               where user.UserId == OrderingUserId
                                                               select user).SingleOrDefault();
         _usermigration.ModifiedOn = System.DateTime.Now;
         db.SubmitChanges();
     }
     catch (Exception objException)
     {
         CSLOrderingARCBAL.LinqToSqlDataContext db;
         db = new CSLOrderingARCBAL.LinqToSqlDataContext();
         db.USP_SaveErrorDetails("Authentication Service", "AuditUpdateofUser" + OrderingUserId.ToString(), Convert.ToString(objException.Message), Convert.ToString(objException.InnerException), Convert.ToString(objException.StackTrace), "", "", false, OrderingUserId.ToString());
     }
 }
    private void AuditCreationofUser(Guid OrderingUserId, Guid?KeycloakUserId)
    {
        try {
            CSLOrderingARCBAL.LinqToSqlDataContext db;
            db = new CSLOrderingARCBAL.LinqToSqlDataContext();

            CSLOrderingARCBAL.User_Migration_KC _usermigration = new CSLOrderingARCBAL.User_Migration_KC();
            _usermigration.UserId         = OrderingUserId;
            _usermigration.KeyCloakUserId = KeycloakUserId;
            _usermigration.CreatedOn      = System.DateTime.Now;
            _usermigration.ModifiedOn     = System.DateTime.Now;
            db.User_Migration_KCs.InsertOnSubmit(_usermigration);
            db.SubmitChanges();
        }
        catch (Exception objException)
        {
            CSLOrderingARCBAL.LinqToSqlDataContext db;
            db = new CSLOrderingARCBAL.LinqToSqlDataContext();
            db.USP_SaveErrorDetails("Authentication Service", "AuditCreationofUser" + OrderingUserId.ToString(), Convert.ToString(objException.Message), Convert.ToString(objException.InnerException), Convert.ToString(objException.StackTrace), "", "", false, OrderingUserId.ToString());
        }
    }